ERROR Reported --------------- load_test_radius=> select count(*) from sessions; ^CCancel request sent WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. ERROR: canceling statement due to user request SSL SYSCALL error: EOF detected The connection to the server was lost. Attempting reset: Failed. !> \q -------------- Postgres Logs in DEBUG5 mode --------------- 2020-06-09 18:42:05 UTC:10.69.40.130(37518):master@postgres:[21250]:DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0 2020-06-09 18:42:14 UTC:10.69.40.130(37518):master@postgres:[21250]:DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0 2020-06-09 18:42:14 UTC:10.69.40.130(37518):master@postgres:[21250]:DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0 2020-06-09 18:42:14 UTC:10.69.40.130(37518):master@postgres:[21250]:STATEMENT: set log_min_error_statement = 'DEBUG5'; 2020-06-09 18:42:18 UTC:10.69.40.130(37518):master@postgres:[21250]:DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0 2020-06-09 18:42:18 UTC:10.69.40.130(37518):master@postgres:[21250]:STATEMENT: SELECT pg_catalog.quote_ident(datname) FROM pg_catalog.pg_database WHERE substring(pg_catalog.quote_ident(datname),1,2)='lo' LIMIT 1000 2020-06-09 18:42:18 UTC:10.69.40.130(37518):master@postgres:[21250]:DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0 2020-06-09 18:42:18 UTC:10.69.40.130(37518):master@postgres:[21250]:STATEMENT: SELECT pg_catalog.quote_ident(datname) FROM pg_catalog.pg_database WHERE substring(pg_catalog.quote_ident(datname),1,2)='lo' LIMIT 1000 2020-06-09 18:42:18 UTC:10.69.40.130(37518):master@postgres:[21250]:DEBUG: shmem_exit(0): 1 before_shmem_exit callbacks to make 2020-06-09 18:42:18 UTC:10.69.40.130(37518):master@postgres:[21250]:DEBUG: shmem_exit(0): 6 on_shmem_exit callbacks to make 2020-06-09 18:42:18 UTC:10.69.40.130(37518):master@postgres:[21250]:DEBUG: proc_exit(0): 3 callbacks to make 2020-06-09 18:42:18 UTC:10.69.40.130(37518):master@postgres:[21250]:DEBUG: SSL: write alert (0x0100) 2020-06-09 18:42:18 UTC:10.69.40.130(37518):master@postgres:[21250]:DEBUG: exit(0) 2020-06-09 18:42:18 UTC:10.69.40.130(37518):master@postgres:[21250]:DEBUG: shmem_exit(-1): 0 before_shmem_exit callbacks to make 2020-06-09 18:42:18 UTC:10.69.40.130(37518):master@postgres:[21250]:DEBUG: shmem_exit(-1): 0 on_shmem_exit callbacks to make 2020-06-09 18:42:18 UTC:10.69.40.130(37518):master@postgres:[21250]:DEBUG: proc_exit(-1): 0 callbacks to make 2020-06-09 18:42:21 UTC:10.69.40.130(37549):master@load_test_radius:[21372]:ERROR: canceling statement due to user request 2020-06-09 18:42:21 UTC:10.69.40.130(37549):master@load_test_radius:[21372]:STATEMENT: select count(*) from sessions; 2020-06-09 18:42:21 UTC::@:[21402]:FATAL: terminating connection due to administrator command 2020-06-09 18:42:21 UTC::@:[21402]:STATEMENT: select count(*) from sessions; 2020-06-09 18:42:21 UTC::@:[21401]:FATAL: terminating connection due to administrator command 2020-06-09 18:42:21 UTC::@:[21401]:STATEMENT: select count(*) from sessions; 2020-06-09 18:42:21 UTC::@:[30955]:LOG: background worker "parallel worker" (PID 21402) was terminated by signal 11: Segmentation fault 2020-06-09 18:42:21 UTC::@:[30955]:DETAIL: Failed process was running: select count(*) from sessions; 2020-06-09 18:42:21 UTC::@:[30955]:LOG: terminating any other active server processes 2020-06-09 18:42:21 UTC::@:[20942]:WARNING: terminating connection because of crash of another server process 2020-06-09 18:42:21 UTC::@:[20942]:DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2020-06-09 18:42:21 UTC::@:[20942]:HINT: In a moment you should be able to reconnect to the database and repeat your command. 2020-06-09 18:42:21 UTC:10.69.40.130(37549):master@load_test_radius:[21372]:WARNING: terminating connection because of crash of another server process 2020-06-09 18:42:21 UTC:10.69.40.130(37549):master@load_test_radius:[21372]:DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2020-06-09 18:42:21 UTC:10.69.40.130(37549):master@load_test_radius:[21372]:HINT: In a moment you should be able to reconnect to the database and repeat your command. 2020-06-09 18:42:21 UTC::@:[30955]:LOG: all server processes terminated; reinitializing 2020-06-09 18:42:21 UTC::@:[21407]:LOG: database system was interrupted; last known up at 2020-06-09 18:41:29 UTC 2020-06-09 18:42:21 UTC:10.69.40.130(37559):master@load_test_radius:[21408]:FATAL: the database system is in recovery mode 2020-06-09 18:42:21 UTC::@:[21407]:LOG: database system was not properly shut down; automatic recovery in progress 2020-06-09 18:42:21 UTC:10.69.40.130(37560):master@load_test_radius:[21409]:FATAL: the database system is in recovery mode 2020-06-09 18:42:21 UTC::@:[21407]:LOG: redo starts at 2EB4/83FFFCD0 2020-06-09 18:42:21 UTC::@:[21407]:LOG: redo done at 2EB4/8488DC40 2020-06-09 18:42:21 UTC::@:[21407]:LOG: checkpoint starting: end-of-recovery immediate 2020-06-09 18:42:21 UTC::@:[21407]:LOG: checkpoint complete: wrote 1267 buffers (0.5%); 0 WAL file(s) added, 1 removed, 0 recycled; write=0.012 s, sync=0.035 s, total=0.058 s; sync files=3, longest=0.035 s, average=0.011 s; distance=8766 kB, estimate=8766 kB 2020-06-09 18:42:21 UTC::@:[30955]:LOG: database system is ready to accept connections -----------------