problem recovering pgsql 6.1 data

From: Andrey V Khavryutchenko <akhavr(at)compchem(dot)kiev(dot)ua>
To: pgsql-general(at)postgreSQL(dot)org
Subject: problem recovering pgsql 6.1 data
Date: 1998-12-24 09:45:05
Message-ID: x7lnjx98m6.fsf@netmaster.compchem.kiev.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

I've got a major problem recovering the data, created by pgsql 6.1. The
original binaries are lost. And newly built (with CACHEDEBUG) one dump
core:

[akhavr(at)kbi akhavr]$ date; sudo -u postgres /home/akhavr/postgres \
-D /home/postgres/data -e -d 2 mailingad
Tue Dec 22 15:50:35 EET 1998
FindBackend: found "/home/akhavr/postgres" using argv[0]
---debug info---
Quiet = f
Noversion = f
stable = f
timings = f
dates = European
bufsize = 64
query echo = f
multiplexed backend? = f
DatabaseName = [mailingad]
----------------

InitPostgres()..
binding ShmemCreate(key=0, size=758552)
DEBUG:InitSysCache: rid=0 id=0 nkeys=3 size=500
[...]
DEBUG:CatalogCacheInitializeCache: cache @081d3720
DEBUG:CatalogCacheInitializeCache: called w/relname pg_user
DEBUG:CatalogCacheInitializeCache: relid 1260, 1 keys
DEBUG:CatalogCacheInitializeCache: load 1/1 w/1, -1
DEBUG:CatalogCacheInit pg_user 0 -1 81d3720
DEBUG:CatalogCacheComputeHashIndex pg_user 1 -1 0 81d3720
DEBUG:comphash (-1,8187980)
Segmentation fault (core dumped)
[akhavr(at)kbi akhavr]$ gdb postgres core
GDB is free software and you are welcome to 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.
GDB 4.16 (i586-ksi-linux), Copyright 1996 Free Software Foundation, Inc...
Core was generated by `/home/akhavr/postgres -D /home/postgres/data -e -d 2 mail
ingad'.
Program terminated with signal 11, Segmentation fault.
Reading symbols from /usr/lib/libcrypt.so.1...done.
Reading symbols from /lib/libdl.so.1...done.
Reading symbols from /lib/libm.so.5...done.
Reading symbols from /usr/lib/libreadline.so.2...done.
Reading symbols from /lib/libtermcap.so.2...done.
Reading symbols from /lib/libc.so.5...done.
Reading symbols from /lib/ld-linux.so.1...done.
#0 comphash (l=1953331439, v=0x8187980 "postgres") at catcache.c:299
299 i += *v++;
(gdb) bt
#0 comphash (l=1953331439, v=0x8187980 "postgres") at catcache.c:299
#1 0x8136eac in CatalogCacheComputeHashIndex (cacheInP=0x81d3720)
at catcache.c:334
#2 0x81377eb in SearchSysCache (cache=0x81d3720, v1=135821696, v2=0, v3=0,
v4=0) at catcache.c:773
#3 0x813aa0e in SearchSysCacheTuple (cacheId=21, key1=135821696, key2=0,
key3=0, key4=0) at syscache.c:416
#4 0x813f2eb in SetUserId () at miscinit.c:331
#5 0x813f7cb in InitUserid () at postinit.c:341
#6 0x813fa21 in InitPostgres (name=0xbffffce1 "mailingad") at postinit.c:636
#7 0x8107abf in PostgresMain (argc=7, argv=0xbffffb94) at postgres.c:1238
#8 0x80b144d in main (argc=7, argv=0xbffffb94) at main.c:68
#9 0x806238e in _start ()
(gdb)

Any suggestions?

--
SY, Andrey V Khavryutchenko http://www.kbi.kiev.ua/~akhavr

Shick's Law:
There is no problem a good miracle can't solve.

Browse pgsql-general by date

  From Date Subject
Next Message darold 1998-12-24 10:13:28 Backup of large object
Previous Message Bruce Momjian 1998-12-24 05:31:04 Re: [GENERAL] Postgres 6.4.1 on DEC-ALPHA