BUG #5159: 8.4.1 Segmentation fault

From: "Sergey Konoplev" <gray(dot)ru(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5159: 8.4.1 Segmentation fault
Date: 2009-11-02 16:42:24
Message-ID: 200911021642.nA2GgOOv072366@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5159
Logged by: Sergey Konoplev
Email address: gray(dot)ru(at)gmail(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2009-11-02 16:48:55 Re: BUG #5159: 8.4.1 Segmentation fault
Previous Message donniehan 2009-11-02 15:19:35 Re: BUG #5147: DBA can not access view