Re: Please help! Server process was terminated by signal 11: Segmentation fault

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