On Wed, May 16, 2007 at 01:50:04PM -0400, Tom Lane wrote:
> You got the wrong process then --- maybe the postmaster itself rather
> than the backend assigned to your psql session? You can identify the
> backend PID via pg_backend_pid() within the psql session of interest,
> or look in pg_stat_activity.
Thanks. I have now activated gdb on three sub-process busy with the
query as far as I can determine. The first one was the the writer
process which reached a breakpoint before the query ended. Here is the
output:
Program received signal SIGINT, Interrupt.
0xffffe410 in __kernel_vsyscall ()
(gdb) bt
#0 0xffffe410 in __kernel_vsyscall ()
#1 0xb7c5b03d in select () from /lib/tls/i686/cmov/libc.so.6
#2 0x082a8dff in pg_usleep ()
#3 0x081c1862 in BackgroundWriterMain ()
#4 0x080cbf71 in BootstrapMain ()
#5 0x081c6c87 in ClosePostmasterPorts ()
#6 0x081cab77 in PostmasterMain ()
#7 <signal handler called>
#8 0xffffe410 in __kernel_vsyscall ()
#9 0xb7c5b03d in select () from /lib/tls/i686/cmov/libc.so.6
#10 0x081c8037 in ClosePostmasterPorts ()
#11 0x081c9924 in PostmasterMain ()
#12 0x081823b5 in main ()
(gdb) q
Another one that happened before an error message from psql. I typed
'cont' after this output and the error message from psql followed
thereafter.
Breakpoint 1, 0x0827eef6 in errfinish ()
(gdb) bt
#0 0x0827eef6 in errfinish ()
#1 0x0828039c in elog_finish ()
#2 0x082993b3 in MemoryContextAlloc ()
#3 0x0828d437 in pg_mb2wchar ()
#4 0x0811c288 in CreateCopyDestReceiver ()
#5 0x0811ea43 in DoCopy ()
#6 0x081f9d00 in ProcessUtility ()
#7 0x081f6ed9 in PostgresMain ()
#8 0x081f7cac in FreeQueryDesc ()
#9 0x081f84d9 in PortalRun ()
#10 0x081f3b51 in pg_parse_query ()
#11 0x081f5296 in PostgresMain ()
#12 0x081c8a1f in ClosePostmasterPorts ()
#13 0x081c9924 in PostmasterMain ()
#14 0x081823b5 in main ()
Regards
Johann
--
Johann Spies Telefoon: 021-808 4036
Informasietegnologie, Universiteit van Stellenbosch
"Jesus said unto her, I am the resurrection, and the
life. He that believeth in me, though he were dead,
yet shall he live." John 11:25