Debugging - Mailing list pgsql-general

From Ian Harding
Subject Debugging
Date
Msg-id s1372186.086@mail.tpchd.org
Whole thread Raw
Responses Re: Debugging
List pgsql-general
Is there any way to debug a procedural language shared library when you can't createlang?

I get this...
L-897V601: {1} createlang pltcl template1
DEBUG:  InitPostgres
DEBUG:  StartTransactionCommand
DEBUG:  PortalRun
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  PortalRun
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  ProcessUtility
createlang: language installation failed: server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
L-897V601: {2}

and in the log...

DEBUG:  00000: ProcessUtility
LOCATION:  PortalRunUtility, pquery.c:741
STATEMENT:  CREATE FUNCTION "pltcl_call_handler" () RETURNS language_handler AS
'$libdir/pltcl' LANGUAGE C;
        CREATE TRUSTED LANGUAGE "pltcl" HANDLER "pltcl_call_handler";

DEBUG:  00000: reaping dead processes
LOCATION:  reaper, postmaster.c:1819
DEBUG:  00000: child process (PID 2365) was terminated by signal 6
LOCATION:  LogChildExit, postmaster.c:2087
LOG:  00000: server process (PID 2365) was terminated by signal 6
LOCATION:  LogChildExit, postmaster.c:2087
LOG:  00000: terminating any other active server processes
LOCATION:  CleanupProc, postmaster.c:2008
LOG:  00000: all server processes terminated; reinitializing
LOCATION:  reaper, postmaster.c:1920
DEBUG:  00000: shmem_exit(0)
LOCATION:  shmem_exit, ipc.c:126
DEBUG:  00000: invoking IpcMemoryCreate(size=7798784)
LOCATION:  CreateSharedMemoryAndSemaphores, ipci.c:73
LOG:  00000: database system was interrupted at 2004-09-02 07:01:17 PDT
LOCATION:  StartupXLOG, xlog.c:2610

None of which is helping me any.

All its friends seem to be there...

L-897V601: {7} ldd pltcl.so
pltcl.so:
         -ltcl84.1 => /usr/pkg/lib/libtcl84.so.1
         -lpthread.0 => /usr/lib/libpthread.so.0
         -lm.0 => /usr/lib/libm387.so.0
         -lm.0 => /usr/lib/libm.so.0
         -lc.12 => /usr/lib/libc.so.12

Any advice will be appreciated.

Ian

pgsql-general by date:

Previous
From: Wes
Date:
Subject: How to determine a database is intact?
Next
From: Thomas F.O'Connell
Date:
Subject: Re: How to determine a database is intact?