Skip site navigation (1) Skip section navigation (2)

Why "ERROR: dtoi4: integer out of range" on pg_dump

From: Martin Weinberg <weinberg(at)osprey(dot)astro(dot)umass(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Cc: weinberg(at)osprey(dot)astro(dot)umass(dot)edu
Subject: Why "ERROR: dtoi4: integer out of range" on pg_dump
Date: 2001-08-31 20:04:31
Message-ID: 200108312004.QAA21279@osprey.astro.umass.edu (view raw or flat)
Thread:
Lists: pgsql-hackers
Folks,

We have a database with several very large tables.  When trying
to pg_dump we get the above error, e.g.:

pg_dump -v wsdb
--  saving database definition
--  last builtin oid is 18539 
--  reading user-defined types 
--  reading user-defined functions 
--  reading user-defined aggregates 
--  reading user-defined operators 
--  reading user-defined tables 
getTables(): SELECT (for PRIMARY KEY) failed on table v3otgdsrcq.
Explanation from backend: ERROR:  dtoi4: integer out of range

Making another small database (same system, 7.1.2 on Debian/GNU Linux
2.2), gives the same sort of problem:

pg_dump -v tmp
--  saving database definition
--  last builtin oid is 18539 
--  reading user-defined types 
--  reading user-defined functions 
--  reading user-defined aggregates 
--  reading user-defined operators 
--  reading user-defined tables 
--  reading indices information 
--  reading table inheritance information 
--  finding the attribute names and types for each table 
--  finding the attrs and types for table: 'tmp' 
--  flagging inherited attributes in subtables 
--  dumping out database comment 
DumpComment: SELECT failed: 'ERROR:  dtoi4: integer out of range

If I init a new db and restart postgres with the new base,
no problem.

I suspect some sort of corruption but we're not sure where to
look.  A vacuum did not help.  We'd like to recover, if at all
possible.  Any ideas (no luck on other lists or I wouldn't post
here)?

TIA,

--Martin

Responses

pgsql-hackers by date

Next:From: Thomas LockhartDate: 2001-09-01 01:16:05
Subject: Re: INTERVAL type: SQL92 implementation
Previous:From: Dave BlasbyDate: 2001-08-31 19:32:39
Subject: Bad behaviour when inserting unspecified variable length datatypes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group