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