Обсуждение: BUG #5159: 8.4.1 Segmentation fault
The following bug has been logged online: Bug reference: 5159 Logged by: Sergey Konoplev Email address: gray.ru@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
"Sergey Konoplev" <gray.ru@gmail.com> writes: > 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 () Hmm, maybe this is this bug: http://archives.postgresql.org/pgsql-committers/2009-10/msg00056.php If not, we are going to need more information than this to fix it. regards, tom lane
Thanx, Tom. So I just need to checkout REL8_4_STABLE and install it to fix my problem, right? On Mon, Nov 2, 2009 at 7:48 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: > "Sergey Konoplev" <gray.ru@gmail.com> writes: >> 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 d= id >> two codedumps and bt on it: > >> Core was generated by `postgres: mirtesen mirtesen [local] INSERT =A0 = =A0 =A0 =A0'. >> Program terminated with signal 11, Segmentation fault. >> [New process 9238] >> #0 =A00x00000000006646e1 in ?? () >> (gdb) bt >> #0 =A00x00000000006646e1 in ?? () >> #1 =A00x0000000000665545 in ts_stat1 () >> #2 =A00x00000000005390b7 in ExecMakeTableFunctionResult () > > Hmm, maybe this is this bug: > http://archives.postgresql.org/pgsql-committers/2009-10/msg00056.php > > If not, we are going to need more information than this to fix it. > > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0regards, tom lane > --=20 Regards, Sergey Konoplev -- PostgreSQL articles in english & russian http://gray-hemp.blogspot.com/search/label/postgresql/
Sergey Konoplev wrote: > Thanx, Tom. > > So I just need to checkout REL8_4_STABLE and install it to fix my > problem, right? that should work if it is indeed the same issue. Stefan
On Mon, Nov 2, 2009 at 8:25 PM, Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> wrote: > Sergey Konoplev wrote: >> >> Thanx, Tom. >> >> So I just need to checkout REL8_4_STABLE and install it to fix my >> problem, right? > > that should work if it is indeed the same issue. > What if I apply this patch to 8.4.1? Would I get the same result? http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsvector_op.c?r1=1.23&r2=1.23.2.1 -- Regards, Sergey Konoplev
Sergey Konoplev wrote: > On Mon, Nov 2, 2009 at 8:25 PM, Stefan Kaltenbrunner > <stefan@kaltenbrunner.cc> wrote: >> Sergey Konoplev wrote: >>> Thanx, Tom. >>> >>> So I just need to checkout REL8_4_STABLE and install it to fix my >>> problem, right? >> that should work if it is indeed the same issue. >> > > What if I apply this patch to 8.4.1? Would I get the same result? > > http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsvector_op.c?r1=1.23&r2=1.23.2.1 yep - it should have the same effect Stefan
Thank you. Will try. On Mon, Nov 2, 2009 at 8:40 PM, Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> wrote: > Sergey Konoplev wrote: >> >> On Mon, Nov 2, 2009 at 8:25 PM, Stefan Kaltenbrunner >> <stefan@kaltenbrunner.cc> wrote: >>> >>> Sergey Konoplev wrote: >>>> >>>> Thanx, Tom. >>>> >>>> So I just need to checkout REL8_4_STABLE and install it to fix my >>>> problem, right? >>> >>> that should work if it is indeed the same issue. >>> >> >> What if I apply this patch to 8.4.1? Would I get the same result? >> >> >> http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsvector_op.c?r1=1.23&r2=1.23.2.1 > > > yep - it should have the same effect > > Stefan > -- Regards, Sergey Konoplev -- PostgreSQL articles in english & russian http://gray-hemp.blogspot.com/search/label/postgresql/