[MCOL-2249] Tables fail to load with Error: Alter or delete in progress? Created: 2019-03-18  Updated: 2023-03-06  Resolved: 2023-03-06

Status: Closed
Project: MariaDB ColumnStore
Component/s: cpimport, DDLProc, DMLProc
Affects Version/s: 1.0.14
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Abhinav santi Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: None
Environment:

AWS 5PM, 1UM, PRD System

Issue Links:
Relates
relates to MCOL-4657 Concurrent DML test sometimes failed ... Open

 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

 Comments   
Comment by Abhinav santi [ 2019-03-20 ]

If this helps:

Mar 20 16:43:00 ip-172-30- writeenginesplit[25631]: 00.156922 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM1.
Mar 20 16:43:00 ip-172-30- writeenginesplit[25631]: 00.172810 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM2.
Mar 20 16:43:00 ip-172-30-writeenginesplit[25631]: 00.901638 |0|0|0| E 33 CAL0000: #033[0;31mReceived a Cpimport Failure from PM4#033[0m
Mar 20 16:43:00 ip-172-30- writeenginesplit[25631]: 00.901785 |0|0|0| E 33 CAL0087: BulkLoad Error: #033[0;31mReceived a Cpimport Failure from PM4#033[0m
Mar 20 16:43:01 ip-172-30- writeenginesplit[25631]: 01.181589 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM5.
Mar 20 16:43:01 ip-172-30- writeenginesplit[25631]: 01.409523 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM3.

Comment by Todd Stoffel (Inactive) [ 2023-03-06 ]

This ticket was created prior to convergence with the server and may be obsolete. If you find this issue still exists in a modern version, please open a new ticket.

Generated at Thu Feb 08 02:34:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.