The following bug has been logged online: Bug reference: 5159 Logged by: Sergey Konoplev Email address: gray...@gmail.com PostgreSQL version: 8.4.1 Operating system: CentOS release 5.4 (Final) Description: 8.4.1 Segmentation fault Details:
Hello Contribs: btree_gist hstore btree_gin (hasn't been used yet) After migration to 8.4.1 from 8.3.7 our server worked normally for half our and then become falling down continuously with "Segmentation fault". I did two codedumps and bt on it: Core was generated by `postgres: mirtesen mirtesen [local] INSERT '. Program terminated with signal 11, Segmentation fault. [New process 9238] #0 0x00000000006646e1 in ?? () (gdb) bt #0 0x00000000006646e1 in ?? () #1 0x0000000000665545 in ts_stat1 () #2 0x00000000005390b7 in ExecMakeTableFunctionResult () #3 0x00000000005454e1 in ?? () #4 0x000000000053a390 in ExecScan () #5 0x000000000053373a in ExecProcNode () #6 0x000000000053148f in standard_ExecutorRun () #7 0x000000000054e546 in ?? () #8 0x000000000054e980 in SPI_execute_plan () #9 0x00002ade2044d06d in ?? () from /usr/lib64/pgsql/plpgsql.so #10 0x00002ade2044f7f2 in ?? () from /usr/lib64/pgsql/plpgsql.so #11 0x00002ade2044f300 in ?? () from /usr/lib64/pgsql/plpgsql.so #12 0x00002ade20451482 in plpgsql_exec_trigger () from /usr/lib64/pgsql/plpgsql.so #13 0x00002ade2044783a in plpgsql_call_handler () from /usr/lib64/pgsql/plpgsql.so #14 0x000000000051647b in ?? () #15 0x0000000000516826 in ?? () #16 0x0000000000516f7e in AfterTriggerEndQuery () #17 0x00000000005d560b in ?? () #18 0x00000000005d57d9 in ?? () #19 0x00000000005d59d9 in ?? () #20 0x00000000005d5fc3 in PortalRun () #21 0x00000000005d1c65 in ?? () #22 0x00000000005d28fb in PostgresMain () #23 0x00000000005a9a29 in ?? () #24 0x00000000005aa5fe in PostmasterMain () #25 0x00000000005589fe in main () (gdb) Core was generated by `postgres: mirtesen mirtesen [local] INSERT '. Program terminated with signal 11, Segmentation fault. [New process 10384] #0 0x00000000006646e1 in ?? () (gdb) bt #0 0x00000000006646e1 in ?? () #1 0x0000000000665545 in ts_stat1 () #2 0x00000000005390b7 in ExecMakeTableFunctionResult () #3 0x00000000005454e1 in ?? () #4 0x000000000053a390 in ExecScan () #5 0x000000000053373a in ExecProcNode () #6 0x000000000053148f in standard_ExecutorRun () #7 0x000000000054e546 in ?? () #8 0x000000000054e980 in SPI_execute_plan () #9 0x00002ade201c506d in ?? () from /usr/lib64/pgsql/plpgsql.so #10 0x00002ade201c77f2 in ?? () from /usr/lib64/pgsql/plpgsql.so #11 0x00002ade201c7300 in ?? () from /usr/lib64/pgsql/plpgsql.so #12 0x00002ade201c9482 in plpgsql_exec_trigger () from /usr/lib64/pgsql/plpgsql.so #13 0x00002ade201bf83a in plpgsql_call_handler () from /usr/lib64/pgsql/plpgsql.so #14 0x000000000051647b in ?? () #15 0x0000000000516826 in ?? () #16 0x0000000000516f7e in AfterTriggerEndQuery () #17 0x00000000005d560b in ?? () #18 0x00000000005d57d9 in ?? () #19 0x00000000005d59d9 in ?? () #20 0x00000000005d5fc3 in PortalRun () #21 0x00000000005d1c65 in ?? () #22 0x00000000005d28fb in PostgresMain () #23 0x00000000005a9a29 in ?? () #24 0x00000000005aa5fe in PostmasterMain () #25 0x00000000005589fe in main () (gdb) Regards, Sergey Konoplev -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
