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

On a 2PM combo stack with query stats enabled, one of the PMs returned an error when queries is executed

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.0.4
    • 1.0.11, 1.1.0
    • ExeMgr
    • None
    • 2016-22, 2016-23, 2016-24, 2016-25, 2017-16

    Description

      Build tested: 1.0.4-1 beta

      I setup a combo stack with 2 PMs, then I changed parameters in Columnstore.xml to enable query stats:
      <CrossEngineSupport>
      <Host>localhost</Host>
      <Port>3306</Port>
      <User>root</User>
      <Password/>
      </CrossEngineSupport>
      <QueryStats>
      <Enabled>Y</Enabled>
      </QueryStats>

      After the above change, PM2 worked as expected and queries are being logged in infinidb_querystats.querystats table, but PM2 would return an warning. The executed query was not log in either of the PMs.
      MariaDB [mytest]> select count from orders;
      ----------

      count

      ----------

      1500000

      ----------
      1 row in set, 1 warning (0.05 sec)

      MariaDB [mytest]> show warnings;
      -----------------------------------------------------------------------------------------------------------

      Level Code Message

      -----------------------------------------------------------------------------------------------------------

      Note 1051 Unknown table 'infinidb_vtable.$vtable_16'
      Warning 9999 Columnstore Query Stats - IDB-8002: Error: fatal error executing query in querystats lib (17).

      -----------------------------------------------------------------------------------------------------------
      2 rows in set (0.00 sec)

      MariaDB [mytest]> select * from infinidb_querystats.querystats;
      Empty set (0.00 sec)

      MariaDB [mytest]> quit

      Attachments

        Activity

          People

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