From: | Dimitri Nagiev <dnagiev(at)gmx(dot)de> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Cc: | dmagiev(at)gmx(dot)de |
Subject: | pg_dump: ERROR: cannot read block 1055 of summary: Input/output error |
Date: | 2003-06-27 21:53:00 |
Message-ID: | 20835.1056750780@www65.gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi all,
using pg_dump I get the following error message:
pg_dump stats > stats.sql
pg_dump: ERROR: cannot read block 1055 of summary: Input/output error
pg_dump: lost synchronization with server, resetting connection
pg_dump: SQL command to dump the contents of table "summary" failed:
PQendcopy() failed.
pg_dump: Error message from server: pg_dump: The command was: COPY
public.summary (id, timestamp, user, keyfigure, total, absolutedifference,
relativedifference) TO stdout;
calls from psql give me similar trouble:
# select count(*) from summary;
ERROR: cannot read block 1055 of summary: Interrupted system call
some more info:
- we are using postgresql 7.3.2
- before the problems, the table had approx. 200.000 records without any
problems
- a regular import is (was) feeding about 500 records a day into the table.
There's a good backup from yesterday, but still I am very concerned. Any
ideas on how to fix the problem ? Any reasons why it does occur ?
thanks
--
+++ GMX - Mail, Messaging & more http://www.gmx.net +++
Bitte lächeln! Fotogalerie online mit GMX ohne eigene Homepage!
From | Date | Subject | |
---|---|---|---|
Next Message | Sidar Lopez Cruz | 2003-06-27 22:17:34 | Latin character set |
Previous Message | scott.marlowe | 2003-06-27 21:42:45 | Re: How do I select the last Id in a column??? |