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 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.phpIf not, we are going to need more information than this to fix it.
regards, tom lane
--
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?
--
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?
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?
yep - it should have the same effect
Stefan
--
Regards,
Sergey Konoplev
--
PostgreSQL articles in english & russian
http://gray-hemp.blogspot.com/search/label/postgresql/