Hello List, I have a problem with my PostgreSQL 8.3.4 installation. We had some problems with our storage subsystem and it seems postgresql suffered a little bit from it. Here are some log excerpts: When trying to start postgesql: --- # /etc/init.d/postgresql-8.3 start Starting PostgreSQL 8.3 database server: main* Removed stale pid file. The PostgreSQL server failed to start. Please check the log output: 2009-09-19 16:51:00 CEST LOG: could not load root certificate file "root.crt": no SSL error reported 2009-09-19 16:51:00 CEST DETAIL: Will not verify client certificates. 2009-09-19 16:51:00 CEST LOG: could not create IPv6 socket: Address family not supported by protocol 2009-09-19 16:51:00 CEST LOG: database system was interrupted while in recovery at 2009-09-19 16:47:52 CEST 2009-09-19 16:51:00 CEST HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery. 2009-09-19 16:51:00 CEST LOG: database system was not properly shut down; automatic recovery in progress 2009-09-19 16:51:00 CEST LOG: incomplete startup packet 2009-09-19 16:51:00 CEST LOG: redo starts at 44D/CEAFB200 2009-09-19 16:51:00 CEST LOG: unexpected pageaddr 44D/B8B0A000 in log file 1101, segment 206, offset 11575296 2009-09-19 16:51:00 CEST LOG: redo done at 44D/CEB062C0 2009-09-19 16:51:00 CEST PANIC: right sibling's left-link doesn't match: block 49696 links to 49978 instead of expected 3 in index "132010" 2009-09-19 16:51:00 CEST LOG: startup process (PID 3727) was terminated by signal 6: Aborted 2009-09-19 16:51:00 CEST LOG: aborting startup due to startup process failure failed! --- I think the index is not a system index. But when I tried to start Postgresql in single-user mode to be able to repair this index i am getting the mentioned SIGSEGV. Here is the last part of the strace output: http://pastie.org/622807 Here is the gdb output: --- Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 47930899067328 (LWP 3881)] 0x00000000005a7fc0 in SHMQueueInsertBefore () (gdb) bt #0 0x00000000005a7fc0 in SHMQueueInsertBefore () #1 0x00000000005ac7a0 in LockAcquire () #2 0x00000000005aa416 in LockRelationForExtension () #3 0x0000000000469b0e in _bt_getbuf () #4 0x0000000000467759 in _bt_getstackbuf () #5 0x00000000004687d2 in _bt_insert_parent () #6 0x000000000046fc34 in btree_xlog_cleanup () #7 0x000000000047fbfb in StartupXLOG () #8 0x00000000005b899d in PostgresMain () #9 0x00000000005448df in main () --- Its a debian, and I think there are no debug symbols in the package (gdb announces some "no debugging symbols found") Anyone knows what to do? Thanks in advance, Björn -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
