From: | "Saeed Ahmed (DB)" <saeed(dot)ahmed1(at)telenor(dot)com(dot)pk> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | WARNING: terminating connection because of crash of another server process |
Date: | 2017-09-18 12:32:05 |
Message-ID: | C35F307BE15BEA4585014E7B3753CC96FB17FBAD0A@ISB-EXMB-CLUS.telenor.com.pk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Dear Team,
We are having POSGRESQL version 9.6 installed on OS version Linux REDHAT 7.2. While running our Decoder (for larger load) OR Audit execution, we are seeing connection errors as service to DB goes down when application tries to connect to postgres.
Log file is attached.
2017-09-14 00:35:16 ICT [5769]: [1-1] user=,db=,app=,client= LOG: checkpoint starting: time
2017-09-14 00:35:16 ICT [5769]: [2-1] user=,db=,app=,client= LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=0.486 s, sync=0.000 s, total=0.491 s; sync files=3, longest=0.000 s, average=0.000 s; distance=23 kB, estimate=23 kB
2017-09-14 00:39:01 ICT [5803]: [1-1] user=[unknown],db=[unknown],app=[unknown],client=[local] LOG: connection received: host=[local]
2017-09-14 00:39:01 ICT [5803]: [2-1] user=postgres,db=postgres,app=[unknown],client=[local] LOG: connection authorized: user=postgres database=postgres
2017-09-14 00:39:01 ICT [5803]: [3-1] user=postgres,db=postgres,app=psql,client=[local] LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local]
2017-09-14 00:39:16 ICT [5812]: [1-1] user=,db=,app=,client= FATAL: semctl(1693253819, 10, SETVAL, 0) failed: Invalid argument
2017-09-14 00:39:16 ICT [1617]: [13584-1] user=,db=,app=,client= LOG: server process (PID 5812) exited with exit code 1
2017-09-14 00:39:16 ICT [1617]: [13585-1] user=,db=,app=,client= LOG: terminating any other active server processes
2017-09-14 00:39:16 ICT [5782]: [3-1] user=raref,db=radb1,app=[unknown],client=10.68.128.7 WARNING: terminating connection because of crash of another server process
2017-09-14 00:39:16 ICT [5782]: [4-1] user=raref,db=radb1,app=[unknown],client=10.68.128.7 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.
2017-09-14 00:39:16 ICT [5782]: [5-1] user=raref,db=radb1,app=[unknown],client=10.68.128.7 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2017-09-14 00:39:16 ICT [5783]: [3-1] user=raref,db=radb1,app=[unknown],client=10.68.128.1 WARNING: terminating connection because of crash of another server process
2017-09-14 00:39:16 ICT [5783]: [4-1] user=raref,db=radb1,app=[unknown],client=10.68.128.1 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.
2017-09-14 00:39:16 ICT [5783]: [5-1] user=raref,db=radb1,app=[unknown],client=10.68.128.1 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2017-09-14 00:39:16 ICT [5779]: [3-1] user=raref,db=radb1,app=[unknown],client=10.68.128.1 WARNING: terminating connection because of crash of another server process
2017-09-14 00:39:16 ICT [5779]: [4-1] user=raref,db=radb1,app=[unknown],client=10.68.128.1 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.
2017-09-14 00:39:16 ICT [5779]: [5-1] user=raref,db=radb1,app=[unknown],client=10.68.128.1 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2017-09-14 00:39:16 ICT [5780]: [3-1] user=raref,db=radb1,app=[unknown],client=10.68.128.1 WARNING: terminating connection because of crash of another server process
2017-09-14 00:39:16 ICT [5780]: [4-1] user=raref,db=radb1,app=[unknown],client=10.68.128.1 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.
2017-09-14 00:39:16 ICT [5780]: [5-1] user=raref,db=radb1,app=[unknown],client=10.68.128.1 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2017-09-14 00:39:16 ICT [5781]: [3-1] user=raref,db=radb1,app=[unknown],client=10.68.128.7 WARNING: terminating connection because of crash of another server process
2017-09-14 00:39:16 ICT [5781]: [4-1] user=raref,db=radb1,app=[unknown],client=10.68.128.7 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.
2017-09-14 00:39:16 ICT [5781]: [5-1] user=raref,db=radb1,app=[unknown],client=10.68.128.7 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2017-09-14 00:39:16 ICT [5777]: [3-1] user=raref,db=radb1,app=[unknown],client=10.68.128.1 WARNING: terminating connection because of crash of another server process
2017-09-14 00:39:16 ICT [5777]: [4-1] user=raref,db=radb1,app=[unknown],client=10.68.128.1 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.
2017-09-14 00:39:16 ICT [5777]: [5-1] user=raref,db=radb1,app=[unknown],client=10.68.128.1 HINT: In a moment you should be able to reconnect to the database and repeat your command.
2017-09-14 00:39:16 ICT [5778]: [3-1] user=raref,db=radb1,app=[unknown],client=10.68.128.7 WARNING: terminating connection because of crash of another server process
2017-09-14 00:39:16 ICT [5778]: [4-1] user=raref,db=radb1,app=[unknown],client=10.68.128.7 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.
Regards,
Saeed Ahmed
Attachment | Content-Type | Size |
---|---|---|
postgresql-2017-09-14.rar | application/octet-stream | 549.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Whitney | 2017-09-19 14:51:17 | Re: WARNING: terminating connection because of crash of another server process |
Previous Message | yaya2002 | 2017-09-18 09:09:51 | ec2 not connect postgreSql "Connection refused. Check that the hostname and port are correct" |