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

pg_dump or hardware?

From: andrea suisani <andrea(dot)suisani(at)opinioni(dot)net>
To: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
Subject: pg_dump or hardware?
Date: 2006-04-19 11:20:22
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Hi all,

short summary:

platform: i386 SMP (dual PIII)
os: linux
vendor: debian (3.1, stable)
pgsql ver: 7.4.7 (deb)
disk: tech. SCSI vendor. IBM model. DDYS-T36950N rev. S96H
controller: adaptec aic-7892a


we're experiencing a weird problem
trying to get a dump of our db for backup purposes,
the executed command is:

/usr/bin/pg_dump -U postgres -h 6pali elenco | /usr/bin/bzip2 > elenco_test.bz2

the output:

pg_dump: ERROR:  could not open relation with OID 201327173
pg_dump: SQL command to dump the contents of table "nominativi" failed: PQendcopy() failed.
pg_dump: Error message from server: ERROR:  could not open relation with OID 201327173
pg_dump: The command was: COPY public.nominativi (nome_cogno, indirizzo, cap, citta, prov, 
prefisso, telefono1, telefono2, note, idpersona, estrazione, num_estra, occupato, 
cod_prov, cod_com, cod_reg, capoluo, rand) TO stdout;

so it seems that we've got some problems with the "nominativi" table
(a 20 million-row table), in fact the following command also fails:

pg_dump -t nominativi -U postgres -h 6pali elenco | /usr/bin/bzip2 > nominativi.bz2

with the same err msg as before. Before the erros occurs we're are able to
get a partial backup, see:

#> ls -l nominativi.bz2
-rw-r--r--    1 sickpig  users        2.5M apr 19 12:35 nominativi.bz2

#> wc -l nominativi
  145904 nominativi

We're trying to understand whether this is due to data corruption or
hardware failure. We run long self-tests on our SCSI disk through
smartmontools on a regular basis. see attached file for "smartctl -a /dev/sda"
output. All suggestions are welcome.



Attachment: smartctl.txt
Description: text/plain (3.1 KB)


pgsql-bugs by date

Next:From: Tom LaneDate: 2006-04-19 14:15:54
Subject: Re: bug in windows xp
Previous:From: Martijn van OosterhoutDate: 2006-04-19 10:20:06
Subject: Re: bug in windows xp

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