Re: postgres segfaulting on pg_restore - Mailing list pgsql-general
| From | Chris Curvey |
|---|---|
| Subject | Re: postgres segfaulting on pg_restore |
| Date | |
| Msg-id | BANLkTinydizRqPGBr0ouUQJNqCcHUt+kzA@mail.gmail.com Whole thread Raw |
| In response to | Re: postgres segfaulting on pg_restore (Craig Ringer <craig@postnewspapers.com.au>) |
| Responses |
Re: postgres segfaulting on pg_restore
Re: postgres segfaulting on pg_restore |
| List | pgsql-general |
Nor I. https://launchpad.net/~pitti/+archive/postgresql/+packages doesn't seem to list any.
Martin: Are your packages stripped, or do they include minimal debug info in the main packages? Do you put your debuginfo debs anywhere accessible?
I decided to just try building it myself -- it has been a voyage of discovery. Here are instructions without going down all the false paths that I did.
1) download postgres 9.0.3 from postgresql.org
2) install bison, flex and libreadline5-dev (sudo apt-get install PACKAGE). I already had the gcc package installed
3) ./configure --enable-debug (I could not get --with-openssl to work...the server kept complaining about SSL when it started. so I gave up)
4) make
5) sudo make install
6) stop the existing server (sudo /etc/init.d/postgresql stop)
7) start the debug server (sudo -u postgres /usr/local/pgsql/bin start -D /etc/postgresql/9.0.main) took me a while to figure out that the -D argument goes to where your postgresql.conf file lives, NOT to where the database files actually are. Probably obvious to experienced users.
8) Start my restore
then follow the instructions at http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD to get gdb connected to the postgres backend.
And voila! Here is the backtrace:
#0 0x00000000006ce317 in GetMemoryChunkSpace (pointer=0x347cc70) at mcxt.c:264
#1 0x00000000006d3d56 in writetup_index (state=0x26fc530, tapenum=<value optimized out>, stup=<value optimized out>) at tuplesort.c:2924
#2 0x00000000006d2af7 in dumptuples (state=0x26fc530, alltuples=0 '\000') at tuplesort.c:2068
#3 0x00000000006d392f in puttuple_common (state=0x26fc530, tuple=0x7fff1e21d3b0) at tuplesort.c:1097
#4 0x00000000006d3c4c in tuplesort_putindextuple (state=0x26fc530, tuple=<value optimized out>) at tuplesort.c:943
#5 0x0000000000472cac in btbuildCallback (index=<value optimized out>, htup=0x26f4460, values=<value optimized out>, isnull=<value optimized out>, tupleIsAlive=1 '\001', state=0x7fff1e21d870) at nbtree.c:194
#6 0x00000000004ab1ec in IndexBuildHeapScan (heapRelation=<value optimized out>, indexRelation=<value optimized out>, indexInfo=<value optimized out>, allow_sync=<value optimized out>, callback=<value optimized out>, callback_state=<value optimized out>) at index.c:1866
#7 0x0000000000472b35 in btbuild (fcinfo=<value optimized out>) at nbtree.c:123
#8 0x00000000006b8ba1 in OidFunctionCall3 (functionId=<value optimized out>, arg1=140128587519600, arg2=140128587659696, arg3=40470992) at fmgr.c:1610
#9 0x00000000004ab804 in index_build (heapRelation=0x7f723aae9670, indexRelation=0x7f723ab0b9b0, indexInfo=0x26989d0, isprimary=0 '\000') at index.c:1427
#10 0x00000000004ad43e in index_create (heapRelationId=<value optimized out>, indexRelationName=<value optimized out>, indexRelationId=<value optimized out>, indexInfo=0x26989d0, indexColNames=<value optimized out>, accessMethodObjectId=<value optimized out>, tableSpaceId=0, classObjectId=0x26f2e70, coloptions=0x26f2e90, reloptions=0, isprimary=0 '\000', isconstraint=0 '\000', deferrable=0 '\000', initdeferred=0 '\000', allow_system_table_mods=<value optimized out>, skip_build=0 '\000', concurrent=0 '\000') at index.c:959
#11 0x0000000000514ec2 in DefineIndex (heapRelation=<value optimized out>, indexRelationName=<value optimized out>, indexRelationId=<value optimized out>, accessMethodName=<value optimized out>, tableSpaceName=<value optimized out>, attributeList=0x2, predicate=0x0, options=0x0, exclusionOpNames=0x0, unique=0 '\000', primary=0 '\000', isconstraint=0 '\000', deferrable=<value optimized out>, initdeferred=<value optimized out>, is_alter_table=0 '\000', check_rights=1 '\001', skip_build=0 '\000', quiet=0 '\000', concurrent=<value optimized out>) at indexcmds.c:484
#12 0x0000000000603b69 in standard_ProcessUtility (parsetree=0x2648880, queryString=0x2647be0 "CREATE INDEX itransf ON transactions USING btree (loccode, startdtact, starttmact);", params=0x0, isTopLevel=1 '\001', dest=0x2648c20, completionTag=0x7fff1e21e3c0 "") at utility.c:876
#13 0x00000000006000a7 in PortalRunUtility (portal=0x25bf0d0, utilityStmt=0x2648880, isTopLevel=0 '\000', dest=0x2648c20, completionTag=0x7fff1e21e3c0 "") at pquery.c:1191
#14 0x00000000006010ec in PortalRunMulti (portal=0x25bf0d0, isTopLevel=1 '\001', dest=0x2648c20, altdest=0x2648c20, completionTag=0x7fff1e21e3c0 "") at pquery.c:1296
#15 0x0000000000601852 in PortalRun (portal=<value optimized out>, count=<value optimized out>, isTopLevel=112 'p', dest=<value optimized out>, altdest=<value optimized out>, completionTag=<value optimized out>) at pquery.c:822
#16 0x00000000005fde0b in exec_simple_query (query_string=<value optimized out>) at postgres.c:1058
#17 0x00000000005fee47 in PostgresMain (argc=<value optimized out>, argv=<value optimized out>, username=<value optimized out>) at postgres.c:3931
#18 0x00000000005cc3b9 in BackendRun () at postmaster.c:3555
#19 BackendStartup () at postmaster.c:3242
#20 ServerLoop () at postmaster.c:1431
#21 0x00000000005cea1c in PostmasterMain (argc=39596208, argv=0x259f8d0) at postmaster.c:1092
#22 0x0000000000575be0 in main (argc=3, argv=0x259f8c0) at main.c:188
--
Ignoring that little voice in my head since 1966!
pgsql-general by date: