Обсуждение: pg_dump: Error message from server: ERROR: missing chunk number
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. --
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
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
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. --
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. --