Re: Error: server closed the connection unexpectedly

Ron <ronljohnsonjr@xxxxxxxxx> · Sun, 10 Oct 2021 14:30:01 -0500



    On 10/10/21 2:20 PM, Tom Lane wrote:

    
      Ron <ronljohnsonjr@xxxxxxxxx> writes:

      
        I think Anil mentioned that there's *nothing* in the Postgresql server log, 
even (in my case) with log_min_messages cranked to debug5.

      
      I'm skeptical that you're looking in the right place, then.
What do you get from

show log_destination;
show log_directory;
    
    
    This is AWS RDS Postgresql.  The db server log is accessed via a web
    interface, and is the postgresql log just like you see in
    vanilla Postgresql.

    
    I've attached it.  My attempt to connect happened some time between
    between 04:10:30 and 04:17:30.

    
			regards, tom lane

    
    -- 

      Angular momentum makes the world go 'round.
  

2021-10-03 04:01:06 UTC::@:[1721]:LOG:  checkpoint starting: time
2021-10-03 04:01:30 UTC::@:[1721]:LOG:  checkpoint complete: wrote 235 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=23.706 s, sync=0.004 s, total=23.733 s; sync files=73, longest=0.004 s, average=0.001 s; distance=66469 kB, estimate=68389 kB
2021-10-03 04:06:06 UTC::@:[1721]:LOG:  checkpoint starting: time
2021-10-03 04:10:21 UTC::@:[1714]:LOG:  received SIGHUP, reloading configuration files
2021-10-03 04:10:21 UTC::@:[1714]:LOG:  skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:10:21 UTC::@:[1714]:LOG:  parameter "log_min_error_statement" changed to "debug5"
2021-10-03 04:10:21 UTC::@:[1719]:LOG:  skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:10:21 UTC::@:[1723]:LOG:  skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:10:21 UTC::@:[1727]:LOG:  skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:10:21 UTC::@:[1722]:LOG:  skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:10:21 UTC::@:[1726]:LOG:  skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:10:21 UTC::@:[1724]:LOG:  skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:10:21 UTC::@:[1725]:LOG:  skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:10:21 UTC::@:[1721]:LOG:  skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:10:36 UTC::@:[1721]:LOG:  checkpoint complete: wrote 6166 buffers (0.1%); 0 WAL file(s) added, 0 removed, 2 recycled; write=269.121 s, sync=0.008 s, total=269.152 s; sync files=172, longest=0.008 s, average=0.001 s; distance=64636 kB, estimate=68014 kB
2021-10-03 04:16:06 UTC::@:[1721]:LOG:  checkpoint starting: time
2021-10-03 04:16:12 UTC::@:[1721]:LOG:  checkpoint complete: wrote 56 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=5.788 s, sync=0.007 s, total=5.816 s; sync files=39, longest=0.004 s, average=0.001 s; distance=130865 kB, estimate=130865 kB
2021-10-03 04:17:40 UTC::@:[1714]:LOG:  received SIGHUP, reloading configuration files
2021-10-03 04:17:40 UTC::@:[1714]:LOG:  skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:17:40 UTC::@:[1714]:LOG:  parameter "log_min_error_statement" changed to "info"
2021-10-03 04:17:40 UTC::@:[1719]:LOG:  skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:17:40 UTC::@:[1724]:LOG:  skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:17:40 UTC::@:[1723]:LOG:  skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:17:40 UTC::@:[1722]:LOG:  skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:17:40 UTC::@:[1726]:LOG:  skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:17:40 UTC::@:[1725]:LOG:  skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:17:40 UTC::@:[1721]:LOG:  skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:17:40 UTC::@:[1727]:LOG:  skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:21:06 UTC::@:[1721]:LOG:  checkpoint starting: time
2021-10-03 04:21:07 UTC::@:[1721]:LOG:  checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.958 s, sync=0.006 s, total=0.986 s; sync files=5, longest=0.006 s, average=0.002 s; distance=65543 kB, estimate=124333 kB
2021-10-03 04:26:06 UTC::@:[1721]:LOG:  checkpoint starting: time
2021-10-03 04:26:28 UTC::@:[1721]:LOG:  checkpoint complete: wrote 215 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=21.796 s, sync=0.006 s, total=21.823 s; sync files=117, longest=0.006 s, average=0.001 s; distance=65729 kB, estimate=118473 kB
2021-10-03 04:31:06 UTC::@:[1721]:LOG:  checkpoint starting: time
2021-10-03 04:31:29 UTC::@:[1721]:LOG:  checkpoint complete: wrote 230 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=23.305 s, sync=0.013 s, total=23.339 s; sync files=89, longest=0.013 s, average=0.001 s; distance=65945 kB, estimate=113220 kB
2021-10-03 04:36:06 UTC::@:[1721]:LOG:  checkpoint starting: time
2021-10-03 04:36:26 UTC::@:[1721]:LOG:  checkpoint complete: wrote 199 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=20.187 s, sync=0.006 s, total=20.214 s; sync files=84, longest=0.003 s, average=0.001 s; distance=65478 kB, estimate=108446 kB
2021-10-03 04:41:06 UTC::@:[1721]:LOG:  checkpoint starting: time
2021-10-03 04:41:21 UTC::@:[1721]:LOG:  checkpoint complete: wrote 144 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=14.647 s, sync=0.005 s, total=14.672 s; sync files=77, longest=0.005 s, average=0.001 s; distance=65133 kB, estimate=104114 kB
2021-10-03 04:46:06 UTC::@:[1721]:LOG:  checkpoint starting: time
2021-10-03 04:46:33 UTC::@:[1721]:LOG:  checkpoint complete: wrote 261 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=26.426 s, sync=0.004 s, total=26.457 s; sync files=140, longest=0.004 s, average=0.001 s; distance=65678 kB, estimate=100271 kB
2021-10-03 04:51:06 UTC::@:[1721]:LOG:  checkpoint starting: time
2021-10-03 04:51:21 UTC::@:[1721]:LOG:  checkpoint complete: wrote 150 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=15.252 s, sync=0.007 s, total=15.279 s; sync files=69, longest=0.006 s, average=0.001 s; distance=65318 kB, estimate=96775 kB
2021-10-03 04:56:06 UTC::@:[1721]:LOG:  checkpoint starting: time
2021-10-03 04:56:24 UTC::@:[1721]:LOG:  checkpoint complete: wrote 177 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=17.972 s, sync=0.006 s, total=17.999 s; sync files=72, longest=0.006 s, average=0.001 s; distance=66034 kB, estimate=93701 kB