From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | wambacher(at)posteo(dot)de, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: got error: DELETE FROM planet_osm_line WHERE osm_id = -390840 failed: FEHLER: tuple concurrently updated |
Date: | 2019-10-12 00:19:00 |
Message-ID: | 9d34861a-50d0-5e75-acc5-c48f4043bf4e@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 10/11/19 3:42 PM, wambacher(at)posteo(dot)de wrote:
> Hi Adrian,
>
> no, system hang and i had to do a power reset (nothing else helped)
>>
>> By system do you mean just Postgres or the computer as a whole?
>
> The whole system was hanging (Ubuntu). very strange: did a "lshw" not
> being root. no idea what was going on. But we don't have to discuss that
> here. May be disk io was hanging too.
>
>>
>> Have you tried a REINDEX?
>>
> not yet because i don't want to change any bit in this table right now.
> at least i'll wait until my recovery program finished (about ~ 50% done)
>
> toast seems to be invalid too. here some lines of the log:
Any hardware 'events' recently?
>
> planet3=# truncate pol_recover;select wno_recover_pol();
> TRUNCATE TABLE
> HINWEIS: wno_recover_pol: 2019-10-11 21:52:18.066759+02 rows=0
> osm_id=633182165
> HINWEIS: wno_recover_pol: 2019-10-11 21:53:59.233604+02 rows=1000000
> osm_id=701634735
> HINWEIS: wno_recover_pol: 2019-10-11 21:56:41.457124+02 rows=2000000
> osm_id=513908287
> HINWEIS: wno_recover_pol: 2019-10-11 22:03:58.663295+02 rows=3000000
> osm_id=36807165
> HINWEIS: wno_recover_pol: 2019-10-11 22:09:40.59184+02 rows=4000000
> osm_id=-9334086
> HINWEIS: wno_recover_pol: 2019-10-11 22:25:24.717055+02 rows=5000000
> osm_id=-2242787
> HINWEIS: wno_recover_pol: Exception -9493166 unexpected chunk number 0
> (expected 1) for toast value 3243289288 in pg_toast_1340113
> HINWEIS: wno_recover_pol: Exception -9493166 unexpected chunk number 0
> (expected 1) for toast value 3243289288 in pg_toast_1340113
> HINWEIS: wno_recover_pol: Exception -61549 unexpected chunk number 0
> (expected 1) for toast value 3243289264 in pg_toast_1340113
> HINWEIS: wno_recover_pol: Exception -240861 unexpected chunk number 0
> (expected 1) for toast value 3243289204 in pg_toast_1340113
> HINWEIS: wno_recover_pol: Exception -240861 unexpected chunk number 0
> (expected 1) for toast value 3243289204 in pg_toast_1340113
> HINWEIS: wno_recover_pol: Exception -240861 unexpected chunk number 0
> (expected 1) for toast value 3243289204 in pg_toast_1340113
> HINWEIS: wno_recover_pol: Exception -240861 unexpected chunk number 0
> (expected 1) for toast value 3243289204 in pg_toast_1340113
> HINWEIS: wno_recover_pol: Exception -240861 unexpected chunk number 0
> (expected 1) for toast value 3243289204 in pg_toast_1340113
> HINWEIS: wno_recover_pol: Exception -240861 unexpected chunk number 0
> (expected 1) for toast value 3243289204 in pg_toast_1340113
> HINWEIS: wno_recover_pol: Exception -240861 unexpected chunk number 0
> (expected 1) for toast value 3243289204 in pg_toast_1340113
> HINWEIS: wno_recover_pol: Exception -240861 unexpected chunk number 0
> (expected 1) for toast value 3243289204 in pg_toast_1340113
> HINWEIS: wno_recover_pol: 2019-10-11 22:40:42.696463+02 rows=6000000
> osm_id=303611045
> HINWEIS: wno_recover_pol: 2019-10-11 22:42:19.535747+02 rows=7000000
> osm_id=439078923
>
> ...
>
> until now "only" 3 damaged records :)
>
> regards
>
> walter
>
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Olarte | 2019-10-12 11:33:59 | Re: SELECT d02name::bytea FROM ... && DBI::Pg |
Previous Message | wambacher | 2019-10-11 22:42:57 | Re: got error: DELETE FROM planet_osm_line WHERE osm_id = -390840 failed: FEHLER: tuple concurrently updated |