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

cmapi: Query failed after adding adding a new node

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Icebox
    • cmapi
    • None

    Description

      Build tested: 1.5.4-1 (Drone #587), cmapi (Drone #251)

      After installing the cmapi package on pm1, I was able perform the following tasks:

      1. Add two nodes (the cluster is already in a functional state)
      2. Create a ColumnStore database (DBT3)
      3. Cpimported 100gb database
      4. Executed "Select count from lineitem;"
      5. Executed "Select count from lineitem where l_orderkey > 6000000;"

      So far, all tasks worked fine.

      Now I added another node. the same query from step 5 above failed

      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

      MariaDB [tpch100]> select count from lineitem where l_orderkey > 6000000;
      ERROR 1815 (HY000): Internal error: An unexpected condition within the query caused an internal processing error within Columnstore. Please check the log files for more details. Additional Information: error in PrimitiveServer l
      MariaDB [tpch100]> exit

      After SHUTDOWN and START the cluster, the query worked again.

      The question is after adding the first two nodes, I did not need to start or shutdown/start the cluster, why did I need to restart after the third node?

      Is the restart a required step? or is it simply a bug?

      Attachments

        Activity

          People

            Unassigned Unassigned
            dleeyh Daniel Lee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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