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@aklaver.com