Re: PostgreSQL, NetBSD and NFS

On Sunday 02 February 2003 12:26, Tom Lane wrote:
> At this point I think you need to rebuild with --enable-debug and
> --enable-cassert (if you didn't already) and then capture some
> stack traces from the stuck backend. We have to find out what the
> backend thinks it's doing.

Well, it does appear to be working but it never finishes. Here are two
backtraces. One was taken while it was running and the other after a kill
-9. The primary key file should have had 322846720 bytes based on the
database that I was copying in but it only had 4603904 after running the
restore for 12 hours. The file seems to get to a static size and just stays
there. I am running another test to confirm that.

(gdb) bt
#0 LWLockAcquire (lockid=7272, mode=LW_SHARED) at lwlock.c:236
#1 0x8110417 in LockBuffer (buffer=3626, mode=1) at bufmgr.c:2004
#2 0x80828ec in _bt_getbuf (rel=0x83a86f0, blkno=6, access=1) at
nbtpage.c:321
#3 0x808559d in _bt_moveright (rel=0x83a86f0, buf=3538, keysz=1,
scankey=0x83b90c0, access=1) at nbtsearch.c:159
#4 0x8085412 in _bt_search (rel=0x83a86f0, keysz=1, scankey=0x83b90c0,
bufP=0xbfbfcb04, access=2) at nbtsearch.c:105
#5 0x807da06 in _bt_doinsert (rel=0x83a86f0, btitem=0x83ba12c,
index_is_unique=1 '\001', heapRel=0x83a6b78) at nbtinsert.c:101
#6 0x8082f84 in btinsert (fcinfo=0xbfbfcb58) at nbtree.c:283
#7 0x815e7cd in OidFunctionCall5 (functionId=331, arg1=138053360,
arg2=3217017956, arg3=3217017940, arg4=138124076, arg5=138046328)
at fmgr.c:1247
#8 0x807c8f4 in index_insert (relation=0x83a86f0, datum=0xbfbfcc64,
nulls=0xbfbfcc54 " ", heap_t_ctid=0x83b9b2c, heapRel=0x83a6b78)
at indexam.c:193
#9 0x80d3d47 in ExecInsertIndexTuples (slot=0x83b9068, tupleid=0x83b9b2c,
estate=0x83b9a48, is_update=0) at execUtils.c:668
#10 0x80b8645 in CopyFrom (rel=0x83a6b78, binary=0 '\000', oids=0 '\000',
fp=0x0, delim=0x8193d36 "\t", null_print=0x8193d38 "\\N") at copy.c:927
#11 0x80b75cb in DoCopy (relname=0x83b11d0 "certificate", binary=0 '\000',
oids=0 '\000', from=1 '\001', pipe=1 '\001', filename=0x0,
delim=0x8193d36 "\t", null_print=0x8193d38 "\\N") at copy.c:336
#12 0x811ea7d in ProcessUtility (parsetree=0x83b11ec, dest=Remote,
completionTag=0xbfbfcdfc "") at utility.c:341
#13 0x811cc46 in pg_exec_query_string (
query_string=0x83b1038 "COPY \"certificate\" FROM stdin;", dest=Remote,
parse_context=0x83676a0) at postgres.c:766
#14 0x811dce8 in PostgresMain (argc=5, argv=0xbfbfd008,
username=0x833c525 "darcy") at postgres.c:1926
#15 0x8102e9f in DoBackend (port=0x833c400) at postmaster.c:2243
#16 0x8102859 in BackendStartup (port=0x833c400) at postmaster.c:1874
#17 0x8101bbf in ServerLoop () at postmaster.c:995
#18 0x8101782 in PostmasterMain (argc=1, argv=0x832d030) at postmaster.c:771
#19 0x80e188f in main (argc=1, argv=0xbfbfd780) at main.c:206
#20 0x8067559 in ___start ()
(gdb) cont
Continuing.

Program received signal SIGKILL, Killed.
0x8119a5d in LWLockAcquire (lockid=3587, mode=LW_SHARED) at lwlock.c:199
lwlock.c:199: No such file or directory.
(gdb) bt
#0 0x8119a5d in LWLockAcquire (lockid=3587, mode=LW_SHARED) at lwlock.c:199
#1 0x80828ec in _bt_getbuf (rel=0x83a86f0, blkno=404, access=1)
at nbtpage.c:321
#2 0x808559d in _bt_moveright (rel=0x83a86f0, buf=3538, keysz=1,
scankey=0x83b90c0, access=1) at nbtsearch.c:159
#3 0x8085412 in _bt_search (rel=0x83a86f0, keysz=1, scankey=0x83b90c0,
bufP=0xbfbfcb04, access=2) at nbtsearch.c:105
#4 0x807da06 in _bt_doinsert (rel=0x83a86f0, btitem=0x83ba12c,
index_is_unique=1 '\001', heapRel=0x83a6b78) at nbtinsert.c:101
#5 0x8082f84 in btinsert (fcinfo=0xbfbfcb58) at nbtree.c:283
#6 0x815e7cd in OidFunctionCall5 (functionId=331, arg1=138053360,
arg2=3217017956, arg3=3217017940, arg4=138124076, arg5=138046328)
at fmgr.c:1247
#7 0x807c8f4 in index_insert (relation=0x83a86f0, datum=0xbfbfcc64,
nulls=0xbfbfcc54 " ", heap_t_ctid=0x83b9b2c, heapRel=0x83a6b78)
at indexam.c:193
#8 0x80d3d47 in ExecInsertIndexTuples (slot=0x83b9068, tupleid=0x83b9b2c,
estate=0x83b9a48, is_update=0) at execUtils.c:668
#9 0x80b8645 in CopyFrom (rel=0x83a6b78, binary=0 '\000', oids=0 '\000',
fp=0x0, delim=0x8193d36 "\t", null_print=0x8193d38 "\\N") at copy.c:927
#10 0x80b75cb in DoCopy (relname=0x83b11d0 "certificate", binary=0 '\000',
oids=0 '\000', from=1 '\001', pipe=1 '\001', filename=0x0,
delim=0x8193d36 "\t", null_print=0x8193d38 "\\N") at copy.c:336
#11 0x811ea7d in ProcessUtility (parsetree=0x83b11ec, dest=Remote,
completionTag=0xbfbfcdfc "") at utility.c:341
#12 0x811cc46 in pg_exec_query_string (
query_string=0x83b1038 "COPY \"certificate\" FROM stdin;", dest=Remote,
parse_context=0x83676a0) at postgres.c:766
#13 0x811dce8 in PostgresMain (argc=5, argv=0xbfbfd008,
username=0x833c525 "darcy") at postgres.c:1926
#14 0x8102e9f in DoBackend (port=0x833c400) at postmaster.c:2243
#15 0x8102859 in BackendStartup (port=0x833c400) at postmaster.c:1874
#16 0x8101bbf in ServerLoop () at postmaster.c:995
#17 0x8101782 in PostmasterMain (argc=1, argv=0x832d030) at postmaster.c:771
#18 0x80e188f in main (argc=1, argv=0xbfbfd780) at main.c:206
#19 0x8067559 in ___start ()

>
> BTW: *are* we certain it's associated with NFS, and not a hardware
> problem on your NetBSD box? Can you perform the same tests running
> the database off a local disk?
>
> regards, tom lane

--
D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.