Server process crash - Segmentation fault - Mailing list pgsql-general

From Leif Jensen
Subject Server process crash - Segmentation fault
Date
Msg-id 8336843.9833.1399385291498.JavaMail.root@quick
Whole thread Raw
Responses Re: Server process crash - Segmentation fault
List pgsql-general
Hello.

   I was running PostgreSQL 9.1.4 when I got a server process crash (Segmentation fault) as the postgres log shown
below.I tried upgrade to newest version 9.3.4, but this gives exactly the same problem. 

   It is an (ecpg based) C-program that does tons of these scroll cursor exercises. Until recently this worked too but
changesto totally different part of the program made this happen. (I have made way too many changes to this other part
tobe able to "roll back" the code :-( ). The system generates data all the time for this lookup, but I can grab the SQL
fromthe postgres log and run it through psql and get the result I expect, so I don't see how it can be data related. 

   Please help,

 Leif

.
.
.
22864 2014-05-06 15:37:35.350 CEST LOG:  statement: close execcurs
22864 2014-05-06 15:37:35.350 CEST LOG:  statement: deallocate "ApplDBConn_22854_f6adeb70_query"
22864 2014-05-06 15:37:35.352 CEST DEBUG:  parse ApplDBConn_22854_f6adeb70_query: SELECT data_type FROM
information_schema.columnsWHERE table_name = 'l2_hb_water_hours_sum' AND column_name = ''; 
22864 2014-05-06 15:37:35.353 CEST LOG:  statement: declare execcurs  scroll cursor  for SELECT data_type FROM
information_schema.columnsWHERE table_name = 'l2_hb_water_hours_sum' AND column_name = ' 
';
22864 2014-05-06 15:37:35.356 CEST LOG:  statement: fetch first in execcurs
22864 2014-05-06 15:37:35.358 CEST LOG:  statement: close execcurs
22864 2014-05-06 15:37:35.358 CEST LOG:  statement: deallocate "ApplDBConn_22854_f6adeb70_query"
22864 2014-05-06 15:37:35.359 CEST LOG:  statement: commit
22864 2014-05-06 15:37:35.359 CEST LOG:  statement: start transaction read only
22864 2014-05-06 15:37:35.360 CEST DEBUG:  parse ApplDBConn_22854_f6adeb70_query: SELECT montime, year, month, day, hh,
gal_hour,exp_hour, unsched_hour FROM l2_hb_water_hours_sum  WHERE  l2_hb_water_ 
hours_sum.ctrlid =  86  ORDER BY year,month,day,hh OFFSET (SELECT CASE WHEN count(*) > 2000 THEN count(*) -2000 ELSE 0
ENDFROM l2_hb_water_hours_sum    WHERE  l2_hb_water_hours_sum.ctrlid =  86 ); 
22864 2014-05-06 15:37:35.365 CEST LOG:  statement: declare execcurs  scroll cursor  for SELECT montime, year, month,
day,hh, gal_hour, exp_hour, unsched_hour FROM l2_hb_water_hours_sum  WHERE  l2_hb 
_water_hours_sum.ctrlid =  86  ORDER BY year,month,day,hh OFFSET (SELECT CASE WHEN count(*) > 2000 THEN count(*) -2000
ELSE0 END FROM l2_hb_water_hours_sum    WHERE  l2_hb_water_hours_sum.ctrlid =  8 
6 );
22864 2014-05-06 15:37:35.432 CEST LOG:  statement: fetch first in execcurs
21702 2014-05-06 15:37:35.440 CEST DEBUG:  server process (PID 22864) was terminated by signal 11: Segmentation fault
21702 2014-05-06 15:37:35.440 CEST DETAIL:  Failed process was running: fetch first in execcurs
21702 2014-05-06 15:37:35.440 CEST LOG:  server process (PID 22864) was terminated by signal 11: Segmentation fault
21702 2014-05-06 15:37:35.440 CEST DETAIL:  Failed process was running: fetch first in execcurs
21702 2014-05-06 15:37:35.440 CEST LOG:  terminating any other active server processes
21702 2014-05-06 15:37:35.440 CEST DEBUG:  sending SIGQUIT to process 22896
21702 2014-05-06 15:37:35.440 CEST DEBUG:  sending SIGQUIT to process 22893
21702 2014-05-06 15:37:35.440 CEST DEBUG:  sending SIGQUIT to process 22882
21702 2014-05-06 15:37:35.440 CEST DEBUG:  sending SIGQUIT to process 22751
21702 2014-05-06 15:37:35.440 CEST DEBUG:  sending SIGQUIT to process 22749
21702 2014-05-06 15:37:35.440 CEST DEBUG:  sending SIGQUIT to process 22748
21702 2014-05-06 15:37:35.440 CEST DEBUG:  sending SIGQUIT to process 21705
21702 2014-05-06 15:37:35.440 CEST DEBUG:  sending SIGQUIT to process 21704
21702 2014-05-06 15:37:35.440 CEST DEBUG:  sending SIGQUIT to process 21706
21702 2014-05-06 15:37:35.440 CEST DEBUG:  sending SIGQUIT to process 21707
22751 2014-05-06 15:37:35.440 CEST WARNING:  terminating connection because of crash of another server process
22751 2014-05-06 15:37:35.440 CEST DETAIL:  The postmaster has commanded this server process to roll back the current
transactionand exit, because another server process exited abnormally and possibl 
y corrupted shared memory.
22751 2014-05-06 15:37:35.440 CEST HINT:  In a moment you should be able to reconnect to the database and repeat your
command.
21702 2014-05-06 15:37:35.440 CEST DEBUG:  sending SIGQUIT to process 21708


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: DDL statement blocked on long-running query with no runtime dependancy
Next
From: Adrian Klaver
Date:
Subject: Re: Server process crash - Segmentation fault