On 10/11/19 3:42 PM, wambacher@xxxxxxxxx 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@xxxxxxxxxxx
