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

occasionally IDB-2031: Blocks are missing. Alter or drop table in progress?`

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 1.1.2
    • Fix Version/s: Icebox
    • Component/s: PrimProc
    • Labels:
      None
    • Environment:
      Debian 8

      Description

      Sometimes for some statements (select or insert) the following error occurs.

      Result: `HY000 1815 Internal error: IDB-2031: Blocks are missing. Alter or drop table in progress?`

      If the error occurs, the error will repeat for every retry.

      Erro vanished, if

      calFlushCache()
      

      will be executed.

      In error case the following line occured in debug, warning, info, error and critical log

      Mar 13 15:53:40 tarcs01 PrimProc[22169]: 40.808502 |0|0|0| C 28 CAL0000: /home/builder/mariadb-columnstore-server/mariadb-columnstore-engine/primitives/primproc/columncommand.cpp error on projectResultRG for oid 350608 lbid 16743424: input rids 876,  output rids 0
      

      execution order:

      Mar 13 15:53:38 tarcs01 ExeMgr[22274]: 38.965410 |2350|0|0| D 16 CAL0041: <Statement>
       
      Mar 13 15:53:39 tarcs01 ExeMgr[22274]: 39.793165 |2147485998|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn  [..]
       
       
      Mar 13 15:53:40 tarcs01 PrimProc[22169]: 40.808502 |0|0|0| C 28 CAL0000: /home/builder/mariadb-columnstore-server/mariadb-columnstore-engine/primitives/primproc/columncommand.cpp error on projectResultRG for oid 350608 lbid 16743424: input rids 876,  output rids 0
       
      Mar 13 15:53:40 tarcs01 ExeMgr[22274]: 40.944300 |2147485998|0|0| D 16 CAL0042: End SQL statement
      

      I don't beleive, it is a duplicate from MCOL-631.
      portconfigure was succesfully run and local query flag is not set.

      infinidb_local_query =0

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              LinuxJedi Andrew Hutchings (Inactive)
              Reporter:
              Richard Richard Stracke
              Votes:
              2 Vote for this issue
              Watchers:
              7 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.