Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.0.14
-
None
-
AWS 5PM, 1UM, PRD System
Description
Columnstore fail to come up automatically after a module (prod-PM4) failed to respond. After a manual restart some of the queries fail to respond with error message : Internal error: IDB-2031: Blocks are missing. Alter or drop table in progress?
Mar 18 21:55:19 ip-172 writeengine[118183]: 19.819644 |0|0|0| I 19 CAL0074: ClearTableLock: Rollback extentMap for table f(OID-3147), column 3152. Restoring HWM column extent: dbRoot-1; part#-0; seg#-2; hwm-12248
Mar 18 21:55:19 ip-172 writeengine[118183]: 19.820559 |0|0|0| I 19 CAL0075: ClearTableLock: Rollback dbfile for table (OID-3147), column 3152. Reinit HWM compressed column extent in db file: dbRoot-1; part#-0; seg#-2; rawOffset(bytes)-100343808; rawFreeBlks-4135
Mar 18 21:55:19 ip- writeengine[118183]: 19.821158 |0|0|0| I 19 CAL0075: ClearTableLock: Rollback dbfile for table (OID-3147), column 3152. HWM compressed column file: dbRoot-1; part#-0; seg#-2; restoredChunk-212992 bytes; truncated to 70819840 bytes
Mar 18 21:55:20 ip- writeengine[118183]: 20.009945 |0|0|0| I 19 CAL0073: ClearTableLock: Rollback extents for table (OID-3147), column 3160. DBRoot-1 (dictionary extent)
Mar 18 21:55:20 ip- writeengine[118183]: 20.010018 |0|0|0| I 19 CAL0074: ClearTableLock: Rollback extentMap for table (OID-3147), column 3160. Restoring HWM dictionary store extents: dbRoot-1; part#-0; HWM(s): 50
Mar 18 21:55:20 ip- writeengine[118183]: 20.010750 |0|0|0| I 19 CAL0075: ClearTableLock: Rollback dbfile for table (OID-3147), column 3160. Reinit HWM compressed dictionary store extent in db file: dbRoot-1; part#-0; seg#-2; rawOffset(bytes)-417792; rawFreeBlks-8141
Mar 18 21:55:20 ip- writeengine[118183]: 20.011366 |0|0|0| I 19 CAL0075: ClearTableLock: Rollback dbfile for table (OID-3147), column 3160. HWM compressed dictionary file: dbRoot-1; part#-0; seg#-2; rawFreeBlks-205 (abbrev); restoredChunk-409600 bytes; truncated to 2105344 bytes
Mar 18 21:55:20 ip- writeengine[118183]: 20.016997 |0|0|0| I 19 CAL0073: ClearTableLock: Rollback extents for table (OID-3147), column 3153. DBRoot-1 (column extent)
Mar 18 21:55:20 ip- writeengine[118183]: 20.017041 |0|0|0| I 19 CAL0074: ClearTableLock: Rollback extentMap for table (OID-3147), column 3153. Restoring HWM column extent: dbRoot-1; part#-0; seg#-2; hwm-12248
Mar 18 21:55:20 ip- writeengine[118183]: 20.018212 |0|0|0| I 19 CAL0075: ClearTableLock: Rollback dbfile for table (OID-3147), column 3153. Reinit HWM compressed column extent in db file: dbRoot-1; part#-0; seg#-2; rawOffset(bytes)-100343808; rawFreeBlks-4135
Mar 18 21:55:20 ip- writeengine[118183]: 20.018978 |0|0|0| I 19 CAL0075: ClearTableLock: Rollback dbfile for table (OID-3147), column 3153. HWM compressed column file: dbRoot-1; part#-0; seg#-2; restoredChunk-212992 bytes; truncated to 70795264 bytes
Attachments
Issue Links
- relates to
-
MCOL-4657 Concurrent DML test sometimes failed with a 'Blocks are missing' error
- Open