pg_dump failure, can't get data out...

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: PostgreSQL Hackers List <pgsql-hackers(at)postgresql(dot)org>, tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: pg_dump failure, can't get data out...
Date: 2001-08-27 00:13:54
Message-ID: 20010826191354.A3950@lerami.lerctr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I had upgraded yesterday and *THOUGHT* all was fine.

Forgot to pg_dump, so I restored my $PGLIB and bin directory, now get
the following when I try to pg_dump:

$ pg_dump ler >z
Password:
pg_dump: query to get function name of oid - failed: ERROR: oidin:
error in "-": can't parse "-"
$

And the debug query log:

Aug 26 19:10:05 lerami pg-prod[3861]: [1] DEBUG: connection: host=[local] user=ler database=ler
Aug 26 19:10:05 lerami pg-prod[3861]: [2] DEBUG: InitPostgres
Aug 26 19:10:05 lerami pg-prod[3861]: [3] DEBUG: StartTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [4] DEBUG: query: select getdatabaseencoding()
Aug 26 19:10:05 lerami pg-prod[3861]: [5] DEBUG: ProcessQuery
Aug 26 19:10:05 lerami pg-prod[3861]: [6] DEBUG: CommitTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [7] DEBUG: StartTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [8] DEBUG: query: SELECT version();
Aug 26 19:10:05 lerami pg-prod[3861]: [9] DEBUG: ProcessQuery
Aug 26 19:10:05 lerami pg-prod[3861]: [10] DEBUG: CommitTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [11] DEBUG: StartTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [12] DEBUG: query: begin
Aug 26 19:10:05 lerami pg-prod[3861]: [13] DEBUG: ProcessUtility: begin
Aug 26 19:10:05 lerami pg-prod[3861]: [14] DEBUG: CommitTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [15] DEBUG: StartTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [16] DEBUG: query: set transaction isolation level serializable
Aug 26 19:10:05 lerami pg-prod[3861]: [17] DEBUG: ProcessUtility: set transaction isolation level serializable
Aug 26 19:10:05 lerami pg-prod[3861]: [18] DEBUG: CommitTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [19] DEBUG: StartTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [20] DEBUG: query: SELECT datlastsysoid from pg_database where datname = 'ler'
Aug 26 19:10:05 lerami pg-prod[3861]: [21] DEBUG: ProcessQuery
Aug 26 19:10:05 lerami pg-prod[3861]: [22] DEBUG: CommitTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [23] DEBUG: StartTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [24] DEBUG: query: select (select usename from pg_user where datdba = usesysid) as dba from pg_database where datname = 'ler'
Aug 26 19:10:05 lerami pg-prod[3861]: [25] DEBUG: ProcessQuery
Aug 26 19:10:05 lerami pg-prod[3861]: [26] DEBUG: CommitTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [27] DEBUG: StartTransactionCommand
Aug 26 19:10:05 lerami pg-prod[3861]: [28-1] DEBUG: query: SELECT pg_type.oid, typowner, typname, typlen, typprtlen, typinput, typoutput, typreceive, typsend, typelem,
Aug 26 19:10:05 lerami pg-prod[3861]: [28-2] typdelim, typdefault, typrelid, typalign, typstorage, typbyval, typisdefined, (select usename from pg_user where typowner =
Aug 26 19:10:05 lerami pg-prod[3861]: [28-3] usesysid) as usename, format_type(pg_type.oid, NULL) as typedefn from pg_type
Aug 26 19:10:05 lerami pg-prod[3861]: [29] DEBUG: ProcessQuery
Aug 26 19:10:06 lerami pg-prod[3861]: [30] DEBUG: CommitTransactionCommand
Aug 26 19:10:06 lerami pg-prod[3861]: [31] DEBUG: StartTransactionCommand
Aug 26 19:10:06 lerami pg-prod[3861]: [32-1] DEBUG: query: SELECT pg_proc.oid, proname, prolang, pronargs, prorettype, proretset, proargtypes, prosrc, probin, (select
Aug 26 19:10:06 lerami pg-prod[3861]: [32-2] usename from pg_user where proowner = usesysid) as usename, proiscachable, proisstrict from pg_proc where pg_proc.oid >
Aug 26 19:10:06 lerami pg-prod[3861]: [32-3] '16554'::oid
Aug 26 19:10:06 lerami pg-prod[3861]: [33] DEBUG: ProcessQuery
Aug 26 19:10:06 lerami pg-prod[3861]: [34] DEBUG: CommitTransactionCommand
Aug 26 19:10:06 lerami pg-prod[3861]: [35] DEBUG: StartTransactionCommand
Aug 26 19:10:06 lerami pg-prod[3861]: [36-1] DEBUG: query: SELECT pg_aggregate.oid, aggname, aggtransfn, aggfinalfn, aggtranstype, aggbasetype, agginitval, 't'::boolean as
Aug 26 19:10:06 lerami pg-prod[3861]: [36-2] convertok, (select usename from pg_user where aggowner = usesysid) as usename from pg_aggregate
Aug 26 19:10:06 lerami pg-prod[3861]: [37] DEBUG: ProcessQuery
Aug 26 19:10:06 lerami pg-prod[3861]: [38] DEBUG: CommitTransactionCommand
Aug 26 19:10:06 lerami pg-prod[3861]: [39] DEBUG: StartTransactionCommand
Aug 26 19:10:06 lerami pg-prod[3861]: [40-1] DEBUG: query: SELECT pg_operator.oid, oprname, oprkind, oprcode, oprleft, oprright, oprcom, oprnegate, oprrest, oprjoin,
Aug 26 19:10:06 lerami pg-prod[3861]: [40-2] oprcanhash, oprlsortop, oprrsortop, (select usename from pg_user where oprowner = usesysid) as usename from pg_operator
Aug 26 19:10:06 lerami pg-prod[3861]: [41] DEBUG: ProcessQuery
Aug 26 19:10:06 lerami pg-prod[3861]: [42] DEBUG: CommitTransactionCommand
Aug 26 19:10:06 lerami pg-prod[3861]: [43] DEBUG: StartTransactionCommand
Aug 26 19:10:06 lerami pg-prod[3861]: [44-1] DEBUG: query: SELECT pg_class.oid, relname, relacl, relkind, (select usename from pg_user where relowner = usesysid) as
Aug 26 19:10:06 lerami pg-prod[3861]: [44-2] usename, relchecks, reltriggers, relhasindex, relhasoids from pg_class where relname !~ '^pg_' and relkind in ('r', 'S', 'v')
Aug 26 19:10:06 lerami pg-prod[3861]: [44-3] order by oid
Aug 26 19:10:06 lerami pg-prod[3861]: [45] DEBUG: ProcessQuery
Aug 26 19:10:06 lerami pg-prod[3861]: [46] DEBUG: CommitTransactionCommand
Aug 26 19:10:06 lerami pg-prod[3861]: [47] DEBUG: StartTransactionCommand
Aug 26 19:10:06 lerami pg-prod[3861]: [48] DEBUG: query: SELECT indexrelid FROM pg_index i WHERE i.indisprimary AND i.indrelid = 20947
Aug 26 19:10:06 lerami pg-prod[3861]: [49] DEBUG: ProcessQuery
Aug 26 19:10:06 lerami pg-prod[3861]: [50] DEBUG: CommitTransactionCommand
Aug 26 19:10:06 lerami pg-prod[3861]: [51] DEBUG: StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [448-2] relname = 'pg_class') and objsubid = 9
Aug 26 19:10:07 lerami pg-prod[3861]: [449] DEBUG: ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [450] DEBUG: CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [451] DEBUG: StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [452-1] DEBUG: query: SELECT description FROM pg_description WHERE objoid = 20974 and classoid = (SELECT oid FROM pg_class where
Aug 26 19:10:07 lerami pg-prod[3861]: [452-2] relname = 'pg_class') and objsubid = 10
Aug 26 19:10:07 lerami pg-prod[3861]: [453] DEBUG: ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [454] DEBUG: CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [455] DEBUG: StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [456-1] DEBUG: query: SELECT description FROM pg_description WHERE objoid = 20974 and classoid = (SELECT oid FROM pg_class where
Aug 26 19:10:07 lerami pg-prod[3861]: [456-2] relname = 'pg_class') and objsubid = 0
Aug 26 19:10:07 lerami pg-prod[3861]: [457] DEBUG: ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [458] DEBUG: CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [459] DEBUG: StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [460-1] DEBUG: query: SELECT description FROM pg_description WHERE objoid = 20976 and classoid = (SELECT oid FROM pg_class where
Aug 26 19:10:07 lerami pg-prod[3861]: [460-2] relname = 'pg_class') and objsubid = 1
Aug 26 19:10:07 lerami pg-prod[3861]: [461] DEBUG: ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [462] DEBUG: CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [463] DEBUG: StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [464-1] DEBUG: query: SELECT description FROM pg_description WHERE objoid = 20976 and classoid = (SELECT oid FROM pg_class where
Aug 26 19:10:07 lerami pg-prod[3861]: [464-2] relname = 'pg_class') and objsubid = 2
Aug 26 19:10:07 lerami pg-prod[3861]: [465] DEBUG: ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [466] DEBUG: CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [467] DEBUG: StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [468-1] DEBUG: query: SELECT description FROM pg_description WHERE objoid = 20976 and classoid = (SELECT oid FROM pg_class where
Aug 26 19:10:07 lerami pg-prod[3861]: [468-2] relname = 'pg_class') and objsubid = 3
Aug 26 19:10:07 lerami pg-prod[3861]: [469] DEBUG: ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [470] DEBUG: CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [471] DEBUG: StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [472-1] DEBUG: query: SELECT description FROM pg_description WHERE objoid = 20976 and classoid = (SELECT oid FROM pg_class where
Aug 26 19:10:07 lerami pg-prod[3861]: [472-2] relname = 'pg_class') and objsubid = 4
Aug 26 19:10:07 lerami pg-prod[3861]: [473] DEBUG: ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [474] DEBUG: CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [475] DEBUG: StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [476-1] DEBUG: query: SELECT description FROM pg_description WHERE objoid = 20976 and classoid = (SELECT oid FROM pg_class where
Aug 26 19:10:07 lerami pg-prod[3861]: [476-2] relname = 'pg_class') and objsubid = 5
Aug 26 19:10:07 lerami pg-prod[3861]: [477] DEBUG: ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [478] DEBUG: CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [479] DEBUG: StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [480-1] DEBUG: query: SELECT description FROM pg_description WHERE objoid = 20976 and classoid = (SELECT oid FROM pg_class where
Aug 26 19:10:07 lerami pg-prod[3861]: [480-2] relname = 'pg_class') and objsubid = 6
Aug 26 19:10:07 lerami pg-prod[3861]: [481] DEBUG: ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [482] DEBUG: CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [483] DEBUG: StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [484-1] DEBUG: query: SELECT description FROM pg_description WHERE objoid = 20976 and classoid = (SELECT oid FROM pg_class where
Aug 26 19:10:07 lerami pg-prod[3861]: [484-2] relname = 'pg_class') and objsubid = 7
Aug 26 19:10:07 lerami pg-prod[3861]: [485] DEBUG: ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [486] DEBUG: CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [487] DEBUG: StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [488-1] DEBUG: query: SELECT description FROM pg_description WHERE objoid = 20976 and classoid = (SELECT oid FROM pg_class where
Aug 26 19:10:07 lerami pg-prod[3861]: [488-2] relname = 'pg_class') and objsubid = 8
Aug 26 19:10:07 lerami pg-prod[3861]: [489] DEBUG: ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [490] DEBUG: CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [491] DEBUG: StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [492-1] DEBUG: query: SELECT description FROM pg_description WHERE objoid = 20976 and classoid = (SELECT oid FROM pg_class where
Aug 26 19:10:07 lerami pg-prod[3861]: [492-2] relname = 'pg_class') and objsubid = 9
Aug 26 19:10:07 lerami pg-prod[3861]: [493] DEBUG: ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [494] DEBUG: CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [495] DEBUG: StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [496-1] DEBUG: query: SELECT description FROM pg_description WHERE objoid = 20976 and classoid = (SELECT oid FROM pg_class where
Aug 26 19:10:07 lerami pg-prod[3861]: [496-2] relname = 'pg_class') and objsubid = 10
Aug 26 19:10:07 lerami pg-prod[3861]: [497] DEBUG: ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [498] DEBUG: CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [499] DEBUG: StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [500-1] DEBUG: query: SELECT description FROM pg_description WHERE objoid = 20976 and classoid = (SELECT oid FROM pg_class where
Aug 26 19:10:07 lerami pg-prod[3861]: [500-2] relname = 'pg_class') and objsubid = 0
Aug 26 19:10:07 lerami pg-prod[3861]: [501] DEBUG: ProcessQuery
Aug 26 19:10:07 lerami pg-prod[3861]: [502] DEBUG: CommitTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [503] DEBUG: StartTransactionCommand
Aug 26 19:10:07 lerami pg-prod[3861]: [504] DEBUG: query: SELECT proname from pg_proc where pg_proc.oid = '-'::oid
Aug 26 19:10:07 lerami pg-prod[3861]: [505] ERROR: oidin: error in "-": can't parse "-"
Aug 26 19:10:07 lerami pg-prod[3861]: [506] DEBUG: AbortCurrentTransaction
Aug 26 19:10:07 lerami pg-prod[3861]: [507] DEBUG: proc_exit(0)
Aug 26 19:10:07 lerami pg-prod[3861]: [508] DEBUG: shmem_exit(0)
Aug 26 19:10:07 lerami pg-prod[3861]: [509] DEBUG: exit(0)

Any ideas on how I can get my data out?

LER

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-08-27 00:24:59 Re: pg_dump failure, can't get data out...
Previous Message Tom Lane 2001-08-26 23:08:09 Anyone see any value in LockDisable/LockingDisabled mechanism?