BUG #5159: 8.4.1 Segmentation fault

Поиск
Список
Период
Сортировка
От Sergey Konoplev
Тема BUG #5159: 8.4.1 Segmentation fault
Дата
Msg-id 200911021642.nA2GgOOv072366@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #5159: 8.4.1 Segmentation fault  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: donniehan
Дата:
Сообщение: Re: BUG #5147: DBA can not access view
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5159: 8.4.1 Segmentation fault