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

Create table caused primproc crashed for a specific configuration

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 1.0.7, 1.0.8
    • Icebox
    • PrimProc
    • 2017-10, 2017-11, 2017-12, 2017-13

    Description

      Build tested: 1.0.7-1, 1.0.8-1

      The issue occurs on the following specific setup

      ubuntu16.04 (did not check on 14.04)
      1um 2pm
      local query enabled
      non root installation

      Mr. Hill also reproduced the issue in his environment:

      MariaDB [david]> create table tmp (c1 int) engine=columnstore;
      ERROR 1815 (HY000): Internal error: CAL0009: IDB-2031: Blocks are missing. Alter or drop table in progress?
      MariaDB [david]>

      I used Mr. Hill's terminal output above since I forgot to capture it in my test.

      Mar 21 16:45:20 vagrant controllernode[5252]: 20.941541 |0|0|0| C 29 CAL0000: BRMShmImpl::BRMShmImpl(): retrying on size==0
      Mar 21 16:45:20 vagrant joblist[7319]: 20.958232 |0|0|0| C 05 CAL0000: /home/builder/mariadb-columnstore-server/mariadb-columnstore-engine/dbcon/joblist/distributedenginecomm.cpp @ 382 DEC: lost connection to 10.0.0.21
      Mar 21 16:45:21 vagrant ProcessMonitor[4002]: 21.228480 |0|0|0| C 18 CAL0000: *****Calpont Process Restarting: PrimProc, old PID = 5252

      When I tried to create a table, I got the following in crit.log

      Mar 21 16:56:40 vagrant PrimProc[27821]: 40.209536 |0|0|0| C 28 CAL0000: IDB-2031: Blocks are missing. Alter or drop table in progress?
      Mar 21 16:56:40 vagrant PrimProc[27821]: 40.209769 |0|0|0| C 28 CAL0000: IDB-2031: Blocks are missing. Alter or drop table in progress?

      after restarting the stack, create table worked.

      The same test for root user worked fine

      Attachments

        Activity

          People

            David.Hall David Hall (Inactive)
            dleeyh Daniel Lee (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            3 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.