Deleting replication slot on slave resolve the issue, now WAL-files
removing automaticaly ! Thanks a lot for your answers !
ср, 17 мар. 2021 г. в 10:59, Andrew Anderson :
> But maybe there is a way to fix this ? Rebuilding slave from master with
> erasing ${PGDATA} on slave does not help.
>
> вт,
Hi,
Not much, we don't see any failed login.
We have added debug login into sssd service since we just found out that
restarting sssd released the user and it became usable again.
So there must be something wrong between postgres and sssd/pam modules...
Waiting now for fresh logs if it happens ag
Thanks - yes pleas send me a private link and I will try to reproduce it
in a test environment and then test the patch.
Regards,
Guy
On 18/03/2021 1:08 pm, Michael Paquier wrote:
On Thu, Mar 18, 2021 at 12:25:45PM +1300, Guy Burgess wrote:
FWIW, this looks the same issue I am getting (repor
On Thu, Mar 18, 2021 at 12:25:45PM +1300, Guy Burgess wrote:
> FWIW, this looks the same issue I am getting (reported last month:
> https://www.postgresql.org/message-id/f444a84e-2d29-55f9-51a6-a5dcea3bc253%40burgess.co.nz)
Yep.
> I get the same Process Monitor output, including BUFFER OVERFLOW e
On Wed, Mar 17, 2021 at 10:45:28AM +0200, Andrus wrote:
> In this server hopefully no. Application code contains xml parsing it but
> probably those queries are never running in this server.
Okay, cool. I am going to send you privately two links to the builds
I am going to produce, 13.2 unpatched
FWIW, this looks the same issue I am getting (reported last month:
https://www.postgresql.org/message-id/f444a84e-2d29-55f9-51a6-a5dcea3bc253%40burgess.co.nz)
I get the same Process Monitor output, including BUFFER OVERFLOW
entries. No sign of any process other than postgres.exe touching the
hi!
What you see in the log files of CentOS ( /var/log ) ?
i
On 17/03/2021 16:00, Marc wrote:
hi all,
We are facing a problem with a user login into database. It happens when there
is large load and only from time to time.
Once we get this error, the user becomes unusable until database is r
Michael Paquier writes:
> On Wed, Mar 17, 2021 at 11:44:48AM -0400, Tom Lane wrote:
>> Oh! That's an interesting theory; it'd explain why this broke recently,
>> because we didn't use to use that function. But how do you draw that
>> conclusion from this stack trace?
> All the reports received
On Wed, Mar 17, 2021 at 11:44:48AM -0400, Tom Lane wrote:
> Oh! That's an interesting theory; it'd explain why this broke recently,
> because we didn't use to use that function. But how do you draw that
> conclusion from this stack trace?
>
> Anyway, if you've diagnosed this correctly, I bet the
hi all,
We are facing a problem with a user login into database. It happens when there
is large load and only from time to time.
Once we get this error, the user becomes unusable until database is restarted.
(That user is being used by multiple instances of the same application, it also
happens
Andrus writes:
> It looks like too small buffer is passed to NtQueryInformationFile .
Oh! That's an interesting theory; it'd explain why this broke recently,
because we didn't use to use that function. But how do you draw that
conclusion from this stack trace?
Anyway, if you've diagnosed this
Hi!
BUFFER OVERFLOW result stack trace is
"Frame","Module","Location","Address","Path"
"0","FLTMGR.SYS","FltDecodeParameters +
0x1c5d","0xf8019f72555d","C:\Windows\System32\drivers\FLTMGR.SYS"
"1","FLTMGR.SYS","FltDecodeParameters +
0x17bc","0xf8019f7250bc","C:\Windows\System32\drivers
Hi!
Doesn't look like these are error messages.
There should be error messages that correspond to the error messages you see in
the PostgreSQL log.
I excluded SUCCESS and DELETE PENDING results and included pg_wal path
and postgres.exe process.
Log file contains only few entries, BUFFER OV
Em qua., 17 de mar. de 2021 às 10:27, Πανος Κοροβεσης <
panoskorove...@outlook.com> escreveu:
>
> Hello,
>
> I am a student and i would like to contribute through the GSoc 2021. Do
you have any tips for getting started and solving a few simple issues? I
cant quite how the whole bug fixing process w
Hello
Does anyone know why assigning a string to a refcursor before opening it
makes fetching data faster from a cursor?
begin;
select * from func1() ;
fetch all from "test";
end;
in func1 i set refcursor_variable := 'test';
On Wed, 2021-03-17 at 15:26 +0200, Andrus wrote:
> > I think what it would be most helpful to run "process monitor", so that you
> > get
> > a log of the system calls and errors; perhaps that shows some details that
> > we cannot get from the error message.
> >
>
> Process monitor shows huge num
Hello,
I am a student and i would like to contribute through the GSoc 2021. Do you
have any tips for getting started and solving a few simple issues? I cant quite
how the whole bug fixing process works.
Any help is greatly appreciated!
Hi!
I think what it would be most helpful to run "process monitor", so that you get
a log of the system calls and errors; perhaps that shows some details that
we cannot get from the error message.
Process monitor shows huge number of DELETE PENDING results from
CreateFile operation:
15:22:3
On Wed, 2021-03-17 at 01:09 +0200, Andrus wrote:
> > Those ten seconds are coming from RemoveXlogFile(), where pgrename()
> > loops 100 times for 100ms before giving up. So something holding up
> > the file's handle prevents the removal to happen.
>
> I tried sysinternals
>
> handle pg_wal
But maybe there is a way to fix this ? Rebuilding slave from master with
erasing ${PGDATA} on slave does not help.
вт, 16 мар. 2021 г. в 16:56, Laurenz Albe :
> On Tue, 2021-03-16 at 16:11 +0200, Andrew Anderson wrote:
> > postgres=# show wal_keep_segments;
> > wal_keep_segments
> >
>On Wed, Mar 17, 2021 at 09:25:00AM +0200, Andrus wrote:
pg_config --configure outputs
--enable-thread-safety --enable-nls --with-ldap --with-openssl --with-uuid
--with-libxml --with-libxslt --with-icu --with-tcl --with-perl --with-python
Thanks. Do you actually use OpenSSL,
Not directly. May
On Wed, Mar 17, 2021 at 09:25:00AM +0200, Andrus wrote:
> pg_config --configure outputs
>
> --enable-thread-safety --enable-nls --with-ldap --with-openssl --with-uuid
> --with-libxml --with-libxslt --with-icu --with-tcl --with-perl --with-python
Thanks. Do you actually use OpenSSL, LDAP, uuid-os
Hi
>I am not completely sure which flags your installation has, but
pg_config --configure outputs
--enable-thread-safety --enable-nls --with-ldap --with-openssl
--with-uuid --with-libxml --with-libxslt --with-icu --with-tcl
--with-perl --with-python
Andrus.
Hi!
I am not completely sure which flags your installation has, but
another possibility is that I directly send to you two compiled
builds, one with the patch and one without it that you could directly
test. I would not send that to the lists as an installation is rather
large, but I could just
24 matches
Mail list logo
