pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg_dumpall errors.
2+ messages / 1 participants
[nested] [flat]

* pg_dumpall errors.
@ 2004-01-30 19:39 Luke Clutter <clutterl@yahoo.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Luke Clutter @ 2004-01-30 19:39 UTC (permalink / raw)
  To: pgsql-admin

We recently had an unexpected san outage which caused
our postgresql to stop pg_dumpall'ing properly.  As a
unix admin, not a db person, i'm short on ideas for
what I should try next.

some base info:
RHAS2.1 box

postgresql-libs-7.1.3-4bp.2
postgresql-jdbc-7.1.3-4bp.2
postgresql-tk-7.1.3-4bp.2
postgresql-7.1.3-4bp.2
postgresql-contrib-7.1.3-4bp.2
postgresql-perl-7.1.3-4bp.2
postgresql-docs-7.1.3-4bp.2
postgresql-python-7.1.3-4bp.2
postgresql-server-7.1.3-4bp.2
postgresql-tcl-7.1.3-4bp.2
postgresql-odbc-7.1.3-4bp.2

#pg_dumpall > pg_dumpall.txt 
ERROR:  not all toast chunks found for value 12660184
PQendcopy: resetting connection
SQL query to dump the contents of Table 'inmail_' did
not execute correctly.  After we read all the table
contents from the backend, PQendcopy() failed. 
Explanation from backend: ''.
The query was: 'COPY "inmail_" TO stdout;
'.
pg_dump failed on lmpg, exiting


#vacuumdb -z -v lmpg 
NOTICE:  --Relation pg_type--
NOTICE:  Pages 3: Changed 0, reaped 0, Empty 0, New 0;
Tup 202: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0,
MinLen 106, MaxLen 109; Re-using: Free/Avail. Space
0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
....
....
NOTICE:  --Relation pg_toast_18779--
NOTICE:  Pages 3745: Changed 0, reaped 437, Empty 0,
New 0; Tup 16223: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed
539, MinLen 46, MaxLen 2034; Re-using: Free/Avail.
Space 33756/31020; EndEmpty/Avail. Pages 0/64. CPU
0.09s/0.01u sec.
NOTICE:  Index pg_toast_18779_idx: Pages 222; Tuples
16223: Deleted 0. CPU 0.02s/0.03u sec.
NOTICE:  Rel pg_toast_18779: Pages: 3745 --> 3745;
Tuple(s) moved: 0. CPU 0.05s/0.01u sec.
NOTICE:  Analyzing...
ERROR:  not all toast chunks found for value 12660184
vacuumdb: vacuum  lmpg failed

Thanks in advance,
and if anyone wants more info, please let me know...

Luke

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* pg_dumpall errors
@ 2004-01-30 19:46 Luke Clutter <clutterl@yahoo.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Luke Clutter @ 2004-01-30 19:46 UTC (permalink / raw)
  To: pgsql-admin

We recently had an unexpected san outage which caused
our postgresql to stop pg_dumpall'ing properly.  As a
unix admin, not a db person, i'm short on ideas for
what I should try next.

some base info:
RHAS2.1 box

postgresql-libs-7.1.3-4bp.2
postgresql-jdbc-7.1.3-4bp.2
postgresql-tk-7.1.3-4bp.2
postgresql-7.1.3-4bp.2
postgresql-contrib-7.1.3-4bp.2
postgresql-perl-7.1.3-4bp.2
postgresql-docs-7.1.3-4bp.2
postgresql-python-7.1.3-4bp.2
postgresql-server-7.1.3-4bp.2
postgresql-tcl-7.1.3-4bp.2
postgresql-odbc-7.1.3-4bp.2

#pg_dumpall > pg_dumpall.txt 
ERROR:  not all toast chunks found for value 12660184
PQendcopy: resetting connection
SQL query to dump the contents of Table 'inmail_' did
not execute correctly.  After we read all the table
contents from the backend, PQendcopy() failed. 
Explanation from backend: ''.
The query was: 'COPY "inmail_" TO stdout;
'.
pg_dump failed on lmpg, exiting


#vacuumdb -z -v lmpg 
NOTICE:  --Relation pg_type--
NOTICE:  Pages 3: Changed 0, reaped 0, Empty 0, New 0;
Tup 202: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0,
MinLen 106, MaxLen 109; Re-using: Free/Avail. Space
0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
....
....
NOTICE:  --Relation pg_toast_18779--
NOTICE:  Pages 3745: Changed 0, reaped 437, Empty 0,
New 0; Tup 16223: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed
539, MinLen 46, MaxLen 2034; Re-using: Free/Avail.
Space 33756/31020; EndEmpty/Avail. Pages 0/64. CPU
0.09s/0.01u sec.
NOTICE:  Index pg_toast_18779_idx: Pages 222; Tuples
16223: Deleted 0. CPU 0.02s/0.03u sec.
NOTICE:  Rel pg_toast_18779: Pages: 3745 --> 3745;
Tuple(s) moved: 0. CPU 0.05s/0.01u sec.
NOTICE:  Analyzing...
ERROR:  not all toast chunks found for value 12660184
vacuumdb: vacuum  lmpg failed

Thanks in advance,
and if anyone wants more info, please let me know...

Luke


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-01-30 19:46 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-01-30 19:39 pg_dumpall errors. Luke Clutter <clutterl@yahoo.com>
2004-01-30 19:46 pg_dumpall errors Luke Clutter <clutterl@yahoo.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox