On 01/04/2016 06:07 PM, John Hong wrote:
Hello Everyone,
On 2015/12/30 17:51:01, Transaction was failed on our system.
I checked the pg_log, it states as below:
2015-12-30 17:51:01 CST [11260]: [42-1] LOG: 00000: server process (PID
14272) was terminated by signal 11: Segmentation fault
On my case, Please give me the instruction in steps on how to figure out
the
reason why did this “signal 11” happen and how to solve “signal 11:
Segmentation fault” issue.
The part that confuses me is:
"
2015-12-30 17:50:52 CST [18954]: [5195-1] LOG: 00000: duration: 0.111 ms
2015-12-30 17:50:52 CST [18954]: [5196-1] LOCATION: exec_simple_query,
postgres.c:1364
★2015-12-30 17:51:02 CST [14276]: [1-1] LOG: 00000: database system was
interrupted; last known up at 2015-12-30 17:50:21 CST★
★2015-12-30 17:51:02 CST [14276]: [31-1] LOG: 00000: last completed
transaction was at log time 2015-12-30 17:50:52.793516+08★
2015-12-30 17:51:01 CST [14270]: [1-1] LOG: 00000: connection received:
host=[local]
"
Is the above a cut and paste error or did the server really go backwards
in time?
At any rate this:
"
2015-12-30 17:51:01 CST [14270]: [9-1] LOG: 00000: statement: select
current_timestamp,pid,current_timestamp - query_start as
runtime,datname,usename,client_addr,query
2015-12-30 17:51:01 CST [14270]: [10-1] LOCATION: exec_simple_query,
postgres.c:1082
2015-12-30 17:51:01 CST [14272]: [3-1] LOG: 00000: connection
authorized: user=enterprisedb database=edb
2015-12-30 17:51:01 CST [14272]: [4-1] LOCATION: PerformAuthentication,
postinit.c:265
2015-12-30 17:51:01 CST [14271]: [5-1] LOG: 00000: statement: select
CURRENT_TIMESTAMP(0), client_addr, count(client_addr) from
pg_stat_activity group by client_addr order by client_addr;
2015-12-30 17:51:01 CST [14271]: [6-1] LOCATION: exec_simple_query,
postgres.c:1082
2015-12-30 17:51:01 CST [14272]: [5-1] LOG: 00000: statement: select now();
2015-12-30 17:51:01 CST [14272]: [6-1] LOCATION: exec_simple_query,
postgres.c:1082
2015-12-30 17:51:01 CST [14272]: [7-1] LOG: 00000: duration: 0.997 ms
2015-12-30 17:51:01 CST [14272]: [8-1] LOCATION: exec_simple_query,
postgres.c:1364
2015-12-30 17:51:01 CST [14272]: [9-1] LOG: 00000: statement: SELECT
bl.pid AS blocked_pid,
"
which includes the statement that was at fault:
"★2015-12-30 17:51:01 CST [11260]: [42-1] LOG: 00000: server process
(PID 14272) was terminated by signal 11: Segmentation fault★
★2015-12-30 17:51:01 CST [11260]: [43-1] DETAIL: Failed process was
running: SELECT bl.pid AS blocked_pid,★
"
looks like something coming from a monitoring/logging process, if that
helps.
Thank you in advance.
John
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
