Script started on Thu Aug 24 08:37:35 2000 > gdb ~/bin/postgres postgres.core GNU gdb 4.18 Copyright 1998 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type "show copying" to see the conditions. There is absolutely no warranty for GDB. Type "show warranty" for details. This GDB was configured as "i386-unknown-freebsd"... Core was generated by `postgres'. Program terminated with signal 6, Abort trap. Reading symbols from /usr/lib/libcrypt.so.2...done. Reading symbols from /usr/lib/libm.so.2...done. Reading symbols from /usr/lib/libutil.so.3...done. Reading symbols from /usr/lib/libreadline.so.4...done. Reading symbols from /usr/lib/libncurses.so.5...done. Reading symbols from /usr/lib/libc.so.4...done. Reading symbols from /usr/libexec/ld-elf.so.1...done. #0 0x18271d90 in kill () from /usr/lib/libc.so.4 (gdb) bt #0 0x18271d90 in kill () from /usr/lib/libc.so.4 #1 0x182b2e09 in abort () from /usr/lib/libc.so.4 #2 0x80ee847 in s_lock_stuck (lock=0x20048065 "\001", file=0x816723c "spin.c", line=127) at s_lock.c:51 #3 0x80ee8c3 in s_lock (lock=0x20048065 "\001", file=0x816723c "spin.c", line=127) at s_lock.c:80 #4 0x80f1580 in SpinAcquire (lockid=7) at spin.c:127 #5 0x80f3903 in LockRelease (lockmethod=1, locktag=0xbfbfe674, lockmode=1) at lock.c:1044 #6 0x80f2af9 in UnlockRelation (relation=0x82063f0, lockmode=1) at lmgr.c:178 #7 0x806f25e in index_endscan (scan=0x8208780) at indexam.c:284 #8 0x8084cf2 in CatalogIndexFetchTuple (heapRelation=0x81c3ba0, idesc=0x82063f0, skey=0xbfbfe754, num_keys=2) at indexing.c:275 #9 0x8084f45 in AttributeRelidNameIndexScan (heapRelation=0x81c3ba0, relid=1790185824, attname=0x8208350 "userid") at indexing.c:437 #10 0x812ba88 in SearchSysCache (cache=0x81ce018, v1=1790185824, v2=136348496, v3=0, v4=0) at catcache.c:1055 #11 0x812f2d5 in SearchSysCacheTuple (cacheId=4, key1=1790185824, key2=136348496, key3=0, key4=0) at syscache.c:532 #12 0x812f55e in get_attnum (relid=1790185824, attname=0x8208350 "userid") at lsyscache.c:86 #13 0x80c3724 in colnameRangeTableEntry (pstate=0x8208170, colname=0x8208350 "userid") at parse_relation.c:201 #14 0x80bfd92 in transformIdent (pstate=0x8208170, ident=0x8208368, precedence=1) at parse_expr.c:639 #15 0x80bf630 in transformExpr (pstate=0x8208170, expr=0x8208368, precedence=1) at parse_expr.c:248 #16 0x80bf301 in transformExpr (pstate=0x8208170, expr=0x82080c8, precedence=1) at parse_expr.c:161 #17 0x80bf3d4 in transformExpr (pstate=0x8208170, expr=0x8208148, precedence=1) at parse_expr.c:194 #18 0x80be16c in transformWhereClause (pstate=0x8208170, clause=0x8208148) at parse_clause.c:142 #19 0x80b08ad in transformSelectStmt (pstate=0x8208170, stmt=0x8208410) at analyze.c:1425 #20 0x80af233 in transformStmt (pstate=0x8208170, parseTree=0x8208410) at analyze.c:238 #21 0x80aeed6 in parse_analyze (pl=0x82084c8, parentParseState=0x0) at analyze.c:75 #22 0x80bdc05 in parser ( str=0x81a8308 "SELECT 1\n", ' ' , "FROM customer_password\n", ' ' , "WHERE userid = '443'\n", ' ' , "AND passwd = 'TLX6L46';", typev=0x0, nargs=0) at parser.c:64 #23 0x80f797b in pg_parse_and_rewrite ( query_string=0x81a8308 "SELECT 1\n", ' ' , "FROM customer_password\n", ' ' , "WHERE userid = '443'\n", ' ' , "AND passwd = 'TLX6L46';", typev=0x0, nargs=0, aclOverride=0 '\000') at postgres.c:395 #24 0x80f7c23 in pg_exec_query_dest ( query_string=0x81a8308 "SELECT 1\n", ' ' , "FROM customer_password\n", ' ' , "WHERE userid = '443'\n", ' ' , "AND passwd = 'TLX6L46';", dest=Remote, aclOverride=0) at postgres.c:580 #25 0x80f7be9 in pg_exec_query ( query_string=0x81a8308 "SELECT 1\n", ' ' , "FROM customer_password\n", ' ' , "WHERE userid = '443'\n", ' ' , "AND passwd = 'TLX6L46';") at postgres.c:562 #26 0x80f8b52 in PostgresMain (argc=11, argv=0xbfbff164, real_argc=11, real_argv=0xbfbffbb4) at postgres.c:1590 #27 0x80e1bd2 in DoBackend (port=0x81ac400) at postmaster.c:2009 #28 0x80e1765 in BackendStartup (port=0x81ac400) at postmaster.c:1776 #29 0x80e0989 in ServerLoop () at postmaster.c:1037 #30 0x80e0386 in PostmasterMain (argc=11, argv=0xbfbffbb4) at postmaster.c:725 #31 0x80aee3b in main (argc=11, argv=0xbfbffbb4) at main.c:93 ---Type to continue, or q to quit--- #32 0x80633cf in _start () (gdb) up #1 0x182b2e09 in abort () from /usr/lib/libc.so.4 (gdb) up #2 0x80ee847 in s_lock_stuck (lock=0x20048065 "\001", file=0x816723c "spin.c", line=127) at s_lock.c:51 51 abort(); (gdb) list 46 "\nFATAL: s_lock(%08x) at %s:%d, stuck spinlock. Aborting.\n", 47 (unsigned int) lock, file, line); 48 fprintf(stdout, 49 "\nFATAL: s_lock(%08x) at %s:%d, stuck spinlock. Aborting.\n", 50 (unsigned int) lock, file, line); 51 abort(); 52 } 53 54 55 void (gdb) up #3 0x80ee8c3 in s_lock (lock=0x20048065 "\001", file=0x816723c "spin.c", line=127) at s_lock.c:80 80 s_lock_stuck(lock, file, line); (gdb) list 75 { 76 s_lock_sleep(spins); 77 if (++spins > S_MAX_BUSY) 78 { 79 /* It's been over a minute... */ 80 s_lock_stuck(lock, file, line); 81 } 82 } 83 } 84 (gdb) exit Undefined command: "exit". Try "help". (gdb) quit > exit exit Script done on Thu Aug 24 08:38:20 2000