Hi Adrian/Ron,
Please find the server log, if you can find something (due to some reasons not being able to get OS system log, will be shared soon).
Thanks,
Anil
On Sun, Oct 10, 2021 at 10:56 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
On 10/10/21 10:19, Anil wrote:
Please reply to list also.
Ccing list.
For future reference do not include images for textual information. Copy
and paste the errors as text.
Response in line.
> Thanks for the response.
>
> 1. I am facing with both (pgAdmin and in python). pgAdmin is throwing
> this window.
> image.png
> 2. Python is throwing below error very often, so I had to create a
> pool object again, which is slowing down my application 45 times.
> *OperationalError: server closed the connection unexpectedly
> *
> *This probably means the server terminated abnormally
> before or while processing the request.*
>
> 3. I don't see anything in log (from pgAdmin).
> image.png
>
> I tried to use the connection pool but it was still the same. Could
> you help?
Per my response to Ron, the answer to this is going to be found on the
server side not the client side.
You need to look at the Postgres server log as well as the OS system log.
>
> Thanks,
> Anil
>
>
> On Sun, Oct 10, 2021 at 1:56 AM Adrian Klaver
> <adrian.klaver@xxxxxxxxxxx> wrote:
>
> On 10/9/21 9:01 AM, Anil wrote:
> > Hi Team,
> >
> > I am using Postgres (AWS instance, version: PostgreSQL 12.7 on
> > x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.3 20140911 (Red Hat
> > 4.8.3-9), 64-bit) with python for programming and pgAdmin for
> querying.
> > However facing below error very often but did not see any aborted
> > information in log (in server activity, pdAdmin
> dashboard). Tried to get
> > support from open community but no luck so writing to you, could
> you
> > help me?
>
> What does the actual Postgres log show?
>
> When does the error occur, with the Python program, the pgAdmin query
> or both?
>
> >
> > *OperationalError: server closed the connection unexpectedly
> > *
> > *This probably means the server terminated abnormally
> > before or while processing the request.*
> >
> > Thanks,
> > Anil
>
>
> --
> Adrian Klaver
> adrian.klaver@xxxxxxxxxxx
>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
2021-10-10 14:03:04 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 14:03:04 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.003 s, total=0.116 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65536 kB, estimate=65542 kB 2021-10-10 14:08:04 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 14:08:05 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.002 s, total=0.118 s; sync files=1, longest=0.002 s, average=0.002 s; distance=65535 kB, estimate=65541 kB 2021-10-10 14:12:50 UTC:185.220.205.213(35246):[unknown]@[unknown]:[25190]:LOG: invalid length of startup packet 2021-10-10 14:13:04 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 14:13:04 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.003 s, total=0.116 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65536 kB, estimate=65541 kB 2021-10-10 14:16:40 UTC:45.146.164.110(42488):pgadmin@postgres:[28502]:FATAL: password authentication failed for user "pgadmin" 2021-10-10 14:16:40 UTC:45.146.164.110(42488):pgadmin@postgres:[28502]:DETAIL: Role "pgadmin" does not exist. Connection matched pg_hba.conf line 13: "host all all all md5" 2021-10-10 14:18:04 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 14:18:04 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.004 s, total=0.117 s; sync files=1, longest=0.004 s, average=0.004 s; distance=65536 kB, estimate=65540 kB 2021-10-10 14:23:04 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 14:23:05 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.004 s, total=0.137 s; sync files=1, longest=0.004 s, average=0.004 s; distance=65536 kB, estimate=65540 kB 2021-10-10 14:28:04 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 14:28:04 UTC::@:[7159]:LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.607 s, sync=0.003 s, total=0.619 s; sync files=6, longest=0.003 s, average=0.001 s; distance=65560 kB, estimate=65560 kB 2021-10-10 14:33:04 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 14:33:04 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.003 s, total=0.113 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65511 kB, estimate=65555 kB 2021-10-10 14:35:22 UTC:45.146.164.110(52386):pgadmin@postgres:[12099]:FATAL: password authentication failed for user "pgadmin" 2021-10-10 14:35:22 UTC:45.146.164.110(52386):pgadmin@postgres:[12099]:DETAIL: Role "pgadmin" does not exist. Connection matched pg_hba.conf line 13: "host all all all md5" 2021-10-10 14:38:04 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 14:38:04 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.002 s, total=0.113 s; sync files=1, longest=0.002 s, average=0.002 s; distance=65536 kB, estimate=65553 kB 2021-10-10 14:40:02 UTC:49.37.162.238(51364):optiwinsdev@optiwins-dev-2:[2351]:LOG: could not receive data from client: Connection reset by peer 2021-10-10 14:43:04 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 14:43:04 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.002 s, total=0.113 s; sync files=1, longest=0.002 s, average=0.002 s; distance=65536 kB, estimate=65551 kB 2021-10-10 14:45:43 UTC:49.37.162.238(62174):optiwinsdev@optiwins-dev-2:[3606]:LOG: could not receive data from client: Connection reset by peer 2021-10-10 14:45:43 UTC:49.37.162.238(62174):optiwinsdev@optiwins-dev-2:[3606]:LOG: unexpected EOF on client connection with an open transaction 2021-10-10 14:48:04 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 14:48:04 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.002 s, total=0.115 s; sync files=1, longest=0.002 s, average=0.002 s; distance=65536 kB, estimate=65550 kB 2021-10-10 14:53:04 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 14:53:04 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.003 s, total=0.116 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65536 kB, estimate=65548 kB 2021-10-10 14:54:07 UTC:45.146.164.110(43792):pgadmin@postgres:[28118]:FATAL: password authentication failed for user "pgadmin" 2021-10-10 14:54:07 UTC:45.146.164.110(43792):pgadmin@postgres:[28118]:DETAIL: Role "pgadmin" does not exist. Connection matched pg_hba.conf line 13: "host all all all md5" 2021-10-10 14:58:04 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 14:58:04 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.003 s, total=0.116 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65535 kB, estimate=65547 kB ----------------------- END OF LOG ---------------------- 2021-10-10 15:03:04 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 15:03:04 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.003 s, total=0.114 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65536 kB, estimate=65546 kB 2021-10-10 15:04:24 UTC:34.77.162.31(51701):[unknown]@[unknown]:[4258]:LOG: could not accept SSL connection: unknown protocol 2021-10-10 15:08:04 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 15:08:04 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.003 s, total=0.114 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65535 kB, estimate=65545 kB 2021-10-10 15:12:51 UTC:45.146.164.110(56522):pgadmin@postgres:[11135]:FATAL: password authentication failed for user "pgadmin" 2021-10-10 15:12:51 UTC:45.146.164.110(56522):pgadmin@postgres:[11135]:DETAIL: Role "pgadmin" does not exist. Connection matched pg_hba.conf line 13: "host all all all md5" 2021-10-10 15:13:04 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 15:13:04 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.002 s, total=0.114 s; sync files=1, longest=0.002 s, average=0.002 s; distance=65536 kB, estimate=65544 kB 2021-10-10 15:18:04 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 15:18:04 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.003 s, total=0.117 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65536 kB, estimate=65543 kB 2021-10-10 15:22:24 UTC:49.37.162.238(60492):optiwinsdev@optiwins-engine:[21509]:LOG: could not receive data from client: Connection reset by peer 2021-10-10 15:23:04 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 15:23:04 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.003 s, total=0.116 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65535 kB, estimate=65542 kB 2021-10-10 15:28:04 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 15:28:05 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.002 s, total=0.114 s; sync files=1, longest=0.002 s, average=0.002 s; distance=65534 kB, estimate=65542 kB 2021-10-10 15:31:38 UTC:45.146.164.110(46234):pgadmin@postgres:[27354]:FATAL: password authentication failed for user "pgadmin" 2021-10-10 15:31:38 UTC:45.146.164.110(46234):pgadmin@postgres:[27354]:DETAIL: Role "pgadmin" does not exist. Connection matched pg_hba.conf line 13: "host all all all md5" 2021-10-10 15:33:04 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 15:33:04 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.003 s, total=0.116 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65536 kB, estimate=65541 kB 2021-10-10 15:38:04 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 15:38:04 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.003 s, total=0.114 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65536 kB, estimate=65540 kB 2021-10-10 15:43:05 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 15:43:05 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.004 s, total=0.118 s; sync files=1, longest=0.004 s, average=0.004 s; distance=65536 kB, estimate=65540 kB 2021-10-10 15:48:05 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 15:48:05 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.003 s, total=0.115 s; sync files=1, longest=0.002 s, average=0.002 s; distance=65536 kB, estimate=65539 kB 2021-10-10 15:50:27 UTC:45.146.164.110(54132):pgadmin@postgres:[11167]:FATAL: password authentication failed for user "pgadmin" 2021-10-10 15:50:27 UTC:45.146.164.110(54132):pgadmin@postgres:[11167]:DETAIL: Role "pgadmin" does not exist. Connection matched pg_hba.conf line 13: "host all all all md5" 2021-10-10 15:53:05 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 15:53:05 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.002 s, total=0.118 s; sync files=1, longest=0.002 s, average=0.002 s; distance=65535 kB, estimate=65539 kB 2021-10-10 15:58:06 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 15:58:06 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.003 s, total=0.115 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65535 kB, estimate=65539 kB ----------------------- END OF LOG ---------------------- 2021-10-10 16:03:06 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 16:03:06 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.003 s, total=0.117 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65536 kB, estimate=65538 kB 2021-10-10 16:08:06 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 16:08:06 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.003 s, total=0.116 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65536 kB, estimate=65538 kB 2021-10-10 16:09:53 UTC:45.146.164.110(48318):pgadmin@postgres:[27800]:FATAL: password authentication failed for user "pgadmin" 2021-10-10 16:09:53 UTC:45.146.164.110(48318):pgadmin@postgres:[27800]:DETAIL: Role "pgadmin" does not exist. Connection matched pg_hba.conf line 13: "host all all all md5" 2021-10-10 16:13:07 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 16:13:07 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.003 s, total=0.115 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65537 kB, estimate=65538 kB 2021-10-10 16:18:07 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 16:18:07 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.003 s, total=0.114 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65536 kB, estimate=65538 kB 2021-10-10 16:23:07 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 16:23:07 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.002 s, total=0.114 s; sync files=1, longest=0.002 s, average=0.002 s; distance=65536 kB, estimate=65538 kB 2021-10-10 16:28:08 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 16:28:08 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.003 s, total=0.124 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65535 kB, estimate=65537 kB 2021-10-10 16:28:32 UTC:45.146.164.110(46312):postgres@bbbbbbb:[11182]:FATAL: expected password response, got message type 0 2021-10-10 16:29:21 UTC:45.146.164.110(33734):pgadmin@postgres:[12047]:FATAL: password authentication failed for user "pgadmin" 2021-10-10 16:29:21 UTC:45.146.164.110(33734):pgadmin@postgres:[12047]:DETAIL: Role "pgadmin" does not exist. Connection matched pg_hba.conf line 13: "host all all all md5" 2021-10-10 16:33:08 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 16:33:08 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.003 s, total=0.115 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65536 kB, estimate=65537 kB 2021-10-10 16:38:08 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 16:38:08 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.003 s, total=0.115 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65536 kB, estimate=65537 kB 2021-10-10 16:43:09 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 16:43:09 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.003 s, total=0.114 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65535 kB, estimate=65537 kB 2021-10-10 16:48:09 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 16:48:09 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.005 s, total=0.117 s; sync files=1, longest=0.005 s, average=0.005 s; distance=65536 kB, estimate=65537 kB 2021-10-10 16:48:48 UTC:45.146.164.110(54896):pgadmin@postgres:[28826]:FATAL: password authentication failed for user "pgadmin" 2021-10-10 16:48:48 UTC:45.146.164.110(54896):pgadmin@postgres:[28826]:DETAIL: Role "pgadmin" does not exist. Connection matched pg_hba.conf line 13: "host all all all md5" 2021-10-10 16:53:09 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 16:53:09 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.003 s, total=0.115 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65536 kB, estimate=65537 kB 2021-10-10 16:58:10 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 16:58:10 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 2 recycled; write=0.227 s, sync=0.002 s, total=0.388 s; sync files=1, longest=0.002 s, average=0.002 s; distance=65535 kB, estimate=65536 kB ----------------------- END OF LOG ---------------------- 2021-10-10 17:03:10 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 17:03:10 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.223 s, sync=0.002 s, total=0.236 s; sync files=1, longest=0.002 s, average=0.002 s; distance=65536 kB, estimate=65536 kB 2021-10-10 17:08:10 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 17:08:11 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.228 s, sync=0.003 s, total=0.241 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65536 kB, estimate=65536 kB 2021-10-10 17:08:16 UTC:45.146.164.110(59750):pgadmin@postgres:[12805]:FATAL: password authentication failed for user "pgadmin" 2021-10-10 17:08:16 UTC:45.146.164.110(59750):pgadmin@postgres:[12805]:DETAIL: Role "pgadmin" does not exist. Connection matched pg_hba.conf line 13: "host all all all md5" 2021-10-10 17:13:10 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 17:13:10 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.226 s, sync=0.002 s, total=0.238 s; sync files=1, longest=0.002 s, average=0.002 s; distance=65536 kB, estimate=65536 kB 2021-10-10 17:18:10 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 17:18:11 UTC::@:[7159]:LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.734 s, sync=0.003 s, total=0.747 s; sync files=5, longest=0.003 s, average=0.001 s; distance=65564 kB, estimate=65564 kB 2021-10-10 17:23:10 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 17:23:10 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.229 s, sync=0.002 s, total=0.253 s; sync files=1, longest=0.002 s, average=0.002 s; distance=65507 kB, estimate=65558 kB 2021-10-10 17:27:39 UTC:45.146.164.110(33054):pgadmin@postgres:[29276]:FATAL: password authentication failed for user "pgadmin" 2021-10-10 17:27:39 UTC:45.146.164.110(33054):pgadmin@postgres:[29276]:DETAIL: Role "pgadmin" does not exist. Connection matched pg_hba.conf line 13: "host all all all md5" 2021-10-10 17:28:10 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 17:28:11 UTC::@:[7159]:LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.335 s, sync=0.002 s, total=0.360 s; sync files=2, longest=0.002 s, average=0.001 s; distance=65540 kB, estimate=65556 kB 2021-10-10 17:33:10 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 17:33:10 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.230 s, sync=0.003 s, total=0.243 s; sync files=1, longest=0.002 s, average=0.002 s; distance=65532 kB, estimate=65554 kB 2021-10-10 17:38:10 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 17:38:10 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.271 s, sync=0.002 s, total=0.284 s; sync files=1, longest=0.002 s, average=0.002 s; distance=65536 kB, estimate=65552 kB 2021-10-10 17:43:10 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 17:43:11 UTC::@:[7159]:LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.546 s, sync=0.002 s, total=0.557 s; sync files=3, longest=0.002 s, average=0.001 s; distance=65553 kB, estimate=65553 kB 2021-10-10 17:46:54 UTC:45.146.164.110(55354):pgadmin@postgres:[13308]:FATAL: password authentication failed for user "pgadmin" 2021-10-10 17:46:54 UTC:45.146.164.110(55354):pgadmin@postgres:[13308]:DETAIL: Role "pgadmin" does not exist. Connection matched pg_hba.conf line 13: "host all all all md5" 2021-10-10 17:48:10 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 17:48:10 UTC::@:[7159]:LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.520 s, sync=0.002 s, total=0.532 s; sync files=4, longest=0.002 s, average=0.001 s; distance=65536 kB, estimate=65551 kB 2021-10-10 17:53:11 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 17:53:11 UTC::@:[7159]:LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.327 s, sync=0.002 s, total=0.340 s; sync files=2, longest=0.002 s, average=0.001 s; distance=65516 kB, estimate=65548 kB 2021-10-10 17:58:11 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 17:58:11 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.223 s, sync=0.002 s, total=0.236 s; sync files=1, longest=0.002 s, average=0.002 s; distance=65536 kB, estimate=65546 kB 2021-10-10 18:03:11 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 18:03:11 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.227 s, sync=0.002 s, total=0.239 s; sync files=1, longest=0.002 s, average=0.002 s; distance=65536 kB, estimate=65545 kB 2021-10-10 18:05:49 UTC:45.146.164.110(40552):pgadmin@postgres:[29655]:FATAL: password authentication failed for user "pgadmin" 2021-10-10 18:05:49 UTC:45.146.164.110(40552):pgadmin@postgres:[29655]:DETAIL: Role "pgadmin" does not exist. Connection matched pg_hba.conf line 13: "host all all all md5" 2021-10-10 18:08:12 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 18:08:12 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.224 s, sync=0.002 s, total=0.235 s; sync files=1, longest=0.002 s, average=0.002 s; distance=65536 kB, estimate=65544 kB 2021-10-10 18:13:12 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 18:13:12 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.229 s, sync=0.002 s, total=0.240 s; sync files=1, longest=0.002 s, average=0.002 s; distance=65536 kB, estimate=65543 kB 2021-10-10 18:13:55 UTC:49.37.162.238(65012):optiwinsdev@optiwins-dev-2:[17037]:LOG: could not receive data from client: Connection reset by peer 2021-10-10 18:18:12 UTC::@:[7159]:LOG: checkpoint starting: time 2021-10-10 18:18:12 UTC::@:[7159]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.218 s, sync=0.002 s, total=0.234 s; sync files=1, longest=0.002 s, average=0.002 s; distance=65536 kB, estimate=65543 kB ----------------------- END OF LOG ----------------------
