Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-2249

Tables fail to load with Error: Alter or delete in progress?

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • 1.0.14
    • Icebox
    • cpimport, DDLProc, DMLProc
    • 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

          Activity

            People

              Unassigned Unassigned
              abhinav.santi Abhinav santi
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.