From: | Leif Jensen <leif(at)crysberg(dot)dk> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Server process crash - Segmentation fault |
Date: | 2014-05-06 14:08:11 |
Message-ID: | 8336843.9833.1399385291498.JavaMail.root@quick |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs 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 changes to totally different part of the program made this happen. (I have made way too many changes to this other part to be able to "roll back" the code :-( ). The system generates data all the time for this lookup, but I can grab the SQL from the 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.columns WHERE 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.columns WHERE 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 END FROM 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 ELSE 0 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 transaction and 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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2014-05-06 14:31:51 | Re: Server process crash - Segmentation fault |
Previous Message | Devrim GÜNDÜZ | 2014-05-06 12:08:43 | Re: BUG #10189: Limit in 9.3.4 no longer works when ordering using a composite multi-type index |
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2014-05-06 14:31:51 | Re: Server process crash - Segmentation fault |
Previous Message | Steve Wilkins | 2014-05-06 14:07:50 | HP-UX 11.23 |