Re: tuple concurrently updated

Поиск
Список
Период
Сортировка
От 066ce286@free.fr
Тема Re: tuple concurrently updated
Дата
Msg-id 114865725.367018989.1535461805284.JavaMail.root@zimbra82-e14.priv.proxad.net
обсуждение исходный текст
Ответ на Re: tuple concurrently updated  (wambacher@posteo.de)
Ответы Re: tuple concurrently updated
Список 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@posteo.de
À: pgsql-admin@lists.postgresql.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@posteo.de:
>
> Am 28.08.2018 um 13:15 schrieb 066ce286@free.fr:
>> Maybe it'll be wise to dump/restore ?
>>
> yes, that may be one option. pg_dump is running right now.
>



В списке pgsql-admin по дате отправления:

Предыдущее
От: wambacher@posteo.de
Дата:
Сообщение: Re: tuple concurrently updated
Следующее
От: wambacher@posteo.de
Дата:
Сообщение: Re: tuple concurrently updated