Обсуждение: pg_dump: Error message from server: ERROR: missing chunk number

Поиск
Список
Период
Сортировка

pg_dump: Error message from server: ERROR: missing chunk number

От
Silvio Brandani
Дата:
We have a standby database version postgres 8.3.1 on linux .
During pg_dump we get the error:

-- pg_dump: SQL command failed
-- pg_dump: Error message from server: ERROR:  missing chunk number 0
for toast value 254723406
-- pg_dump: The command was: COPY helpdesk.attachments_data (id,
filedata, attachment_id) TO stdout;

I have already try to reindex and vacuum full the table. but problem
still stand.

How can we fix this error and get a good dump??--


Any help higly appreciated.


--Silvio Brandani


---






Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalità amministrative e contabili, anche
quandoli comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e agli altri Suoi
diritti,sono riportate alla pagina http://www.savinodelbene.com/news/privacy.html 
Se avete ricevuto questo messaggio per errore Vi preghiamo di ritornarlo al mittente eliminandolo assieme agli
eventualiallegati, ai sensi art. 616 codice penale http://www.savinodelbene.com/codice_penale_616.html 
L'Azienda non si assume alcuna responsabilità giuridica qualora pervengano da questo indirizzo messaggi estranei
all'attivitàlavorativa o contrari a norme. 
--

Re: pg_dump: Error message from server: ERROR: missing chunk number

От
"Kevin Grittner"
Дата:
Silvio Brandani <silvio.brandani@tech.sdb.it> wrote:

> We have a standby database version postgres 8.3.1 on linux .

You should seriously consider upgrading to a more recent 8.3 bug fix
release.  The most current is now 8.3.11.  Please read this:

http://www.postgresql.org/support/versioning

There was a bug fix related to TOAST values in 8.3.6, although I'm
not sure whether that could be related to the corruption you
currently have in your database.

> During pg_dump we get the error:
>
> -- pg_dump: SQL command failed
> -- pg_dump: Error message from server: ERROR:  missing chunk
> number 0 for toast value 254723406
> -- pg_dump: The command was: COPY helpdesk.attachments_data (id,
> filedata, attachment_id) TO stdout;

> How can we fix this error and get a good dump??--

You need to read sets of rows to narrow down what row or rows are
damaged, capture any usable information from those rows, and then
delete them.

Do you have any idea how the damage occurred?  In particular, what
are your settings for fsync and full_page_writes?  Have you had any
power outages or OS freezes?  Any indication of hardware problems?
Any unusual issues like accidentally starting two PostgreSQL servers
against the same data directory?

-Kevin

Re: pg_dump: Error message from server: ERROR: missing chunk number

От
"Kevin Grittner"
Дата:
Silvio Brandani <silvio.brandani@tech.sdb.it> wrote:

> We have a standby database

> During pg_dump

Hmm...  I just noticed that word "standby" in there.  Can you
elaborate on what you mean by that?

-Kevin

Re: pg_dump: Error message from server: ERROR: missing chunk number

От
Silvio Brandani
Дата:
Kevin Grittner ha scritto:
> Silvio Brandani <silvio.brandani@tech.sdb.it> wrote:
>
>
>> We have a standby database
>>
>
>
>> During pg_dump
>>
>
> Hmm...  I just noticed that word "standby" in there.  Can you
> elaborate on what you mean by that?
>
> -Kevin
>
>
It means it is an istance refreshed (via rsync) from another istance
which is in recovery mode with log shipping and PITR.
So to summarize we have :
- a production istance
- a pitr istance ( log shipping from production)
- a quality istance (the one with error  in the backup) which is
refreshed with rsync from the pitr istance.
- a dev istance that we would like to refresh from the quality with
pg_dump / pg_restore


--
Silvio Brandani


---






Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalità amministrative e contabili, anche
quandoli comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e agli altri Suoi
diritti,sono riportate alla pagina http://www.savinodelbene.com/news/privacy.html 
Se avete ricevuto questo messaggio per errore Vi preghiamo di ritornarlo al mittente eliminandolo assieme agli
eventualiallegati, ai sensi art. 616 codice penale http://www.savinodelbene.com/codice_penale_616.html 
L'Azienda non si assume alcuna responsabilità giuridica qualora pervengano da questo indirizzo messaggi estranei
all'attivitàlavorativa o contrari a norme. 
--

Re: pg_dump: Error message from server: ERROR: missing chunk number

От
Silvio Brandani
Дата:
Kevin Grittner ha scritto:
> Silvio Brandani <silvio.brandani@tech.sdb.it> wrote:
>
>
>> We have a standby database
>>
>
>
>> During pg_dump
>>
>
> Hmm...  I just noticed that word "standby" in there.  Can you
> elaborate on what you mean by that?
>
> -Kevin
>
>
It means it is an istance refreshed (via rsync) from another istance
which is in recovery mode with log shipping and PITR.
So to summarize we have :
- a production istance
- a pitr istance ( log shipping from production)
- a quality istance (the one with error  in the backup) which is
refreshed with rsync from the pitr istance.
- a dev istance that we would like to refresh from the quality with
pg_dump / pg_restore


--
Silvio Brandani




--
Silvio Brandani
Infrastructure Administrator
SDB Information Technology
Phone: +39.055.3811222
Fax:   +39.055.5201119

---






Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalità amministrative e contabili, anche
quandoli comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e agli altri Suoi
diritti,sono riportate alla pagina http://www.savinodelbene.com/news/privacy.html 
Se avete ricevuto questo messaggio per errore Vi preghiamo di ritornarlo al mittente eliminandolo assieme agli
eventualiallegati, ai sensi art. 616 codice penale http://www.savinodelbene.com/codice_penale_616.html 
L'Azienda non si assume alcuna responsabilità giuridica qualora pervengano da questo indirizzo messaggi estranei
all'attivitàlavorativa o contrari a norme. 
--