Re: tuple concurrently updated

From: 066ce286(at)free(dot)fr
To: wambacher(at)posteo(dot)de
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: tuple concurrently updated
Date: 2018-08-28 13:10:05
Message-ID: 114865725.367018989.1535461805284.JavaMail.root@zimbra82-e14.priv.proxad.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

BTW you have data corruption.

So forget your problem about concurrent updates ; that's not the clue.

Your new question should be how to recover corrupted table.

Sorry, I've no skill for that problem other that "how ran your backups/archivelogs ?"

----- Mail original -----
De: wambacher(at)posteo(dot)de
À: pgsql-admin(at)lists(dot)postgresql(dot)org
Envoyé: Mardi 28 Août 2018 15:04:14
Objet: Re: tuple concurrently updated

pg_dump not completed:

pg_dump: Ausgabe des Inhalts der Tabelle »planet_osm_line«
fehlgeschlagen: PQgetResult() fehlgeschlagen.
pg_dump: Fehlermeldung vom Server: FEHLER:  unexpected chunk number 0
(expected 1) for toast value 1261719035 in pg_toast_1340113

anything else i can do?

regards
walter
Am 28.08.2018 um 13:25 schrieb wambacher(at)posteo(dot)de:
>
> Am 28.08.2018 um 13:15 schrieb 066ce286(at)free(dot)fr:
>> Maybe it'll be wise to dump/restore ?
>>
> yes, that may be one option. pg_dump is running right now.
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message wambacher 2018-08-28 13:19:28 Re: tuple concurrently updated
Previous Message wambacher 2018-08-28 13:04:14 Re: tuple concurrently updated