Martijn van Oosterhout wrote:
>On Thu, May 04, 2006 at 12:22:01PM +0100, Gavin Hamill wrote:
>
>
>
>At a guess rip = return instruction pointer, rsp = return stack point.
>The fact that they're all the same seems to rule out hardware.
>
>
>
That's good to hear (in one way... :)
>fore starting the server, run "ulimit -S -c unlimited"
>
>If done properly it should enable core dumps for the backend.
>
>Have a nice day,
>
>
Great stuff - it's crashed again and dropped 6MB of core which points
the finger squarely at Slony - I'll ask on the relevant list :)
Core was generated by `postgres: sharp laterooms 194.24.250.135(54478)
UPDATE '.
Program terminated with signal 11, Segmentation fault.
Reading symbols from /lib/libpam.so.0...(no debugging symbols found)...done.
....
Reading symbols from /usr/lib/postgresql/8.1/lib/slony1_funcs.so...done.
Loaded symbols for /usr/lib/postgresql/8.1/lib/slony1_funcs.so
Reading symbols from /usr/lib/postgresql/8.1/lib/xxid.so...done.
Loaded symbols for /usr/lib/postgresql/8.1/lib/xxid.so
#0 0x00002aaaab5e8c00 in strlen () from /lib/libc.so.6
(gdb) bt
#0 0x00002aaaab5e8c00 in strlen () from /lib/libc.so.6
#1 0x00002aaaca65b062 in slon_quote_literal (str=0x0) at
slony1_funcs.c:1044
#2 0x00002aaaca65c348 in _Slony_I_logTrigger (fcinfo=0x8f5ec5) at
slony1_funcs.c:783
#3 0x00000000005ca9f9 in fmgr_internal_function ()
#4 0x00000000004ce6a4 in FreeTriggerDesc ()
#5 0x00000000004cf42e in ExecARUpdateTriggers ()
#6 0x00000000004cf873 in ExecARUpdateTriggers ()
#7 0x00000000004cfb10 in AfterTriggerEndQuery ()
#8 0x000000000055ef05 in FreeQueryDesc ()
#9 0x000000000055fecf in PortalRun ()
#10 0x000000000055f78f in PortalRun ()
#11 0x000000000055b721 in pg_plan_queries ()
#12 0x000000000055e14c in PostgresMain ()
#13 0x0000000000539cc1 in ClosePostmasterPorts ()
#14 0x0000000000539797 in ClosePostmasterPorts ()
#15 0x0000000000537d3d in PostmasterMain ()
#16 0x000000000053704e in PostmasterMain ()
#17 0x00000000004fdb58 in main ()
Cheers,
Gavin,