Re: got error: DELETE FROM planet_osm_line WHERE osm_id = -390840failed: FEHLER: tuple concurrently updated

On 10/11/19 3:42 PM, wambacher@posteo.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.klaver@aklaver.com