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

Cannot execute queries

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Unresolved
    • 1.0.9
    • None
    • PrimProc
    • None
    • Red Hat Enterprise Linux Server release 7.2 (Maipo)

    Description

      When executing a simple summary query it generally works but sometimes not, if query fails
      one time then won't work anymore until i run " select calFlushCache();" or restart columnstore system.

      Is there a workaround for these?

      My errors are like these:

      [root@server6653 ~]# grep "error"/var/log/mariadb/columnstore/err.log

      Sep 18 13:10:08 localhost PrimProc[29337]: 08.069259 |0|0|0| C 28 CAL0000: /home/builder/mariadb-columnstore-server/mariadb-columnstore-engine/primitives/primproc/columncommand.cpp error on projectResultRG for oid 529299 lbid 1363416840: input rids 8192, output rids 8190
      Sep 18 13:18:22 localhost PrimProc[29337]: 22.491177 |0|0|0| C 28 CAL0000: /home/builder/mariadb-columnstore-server/mariadb-columnstore-engine/primitives/primproc/columncommand.cpp error on projectResultRG for oid 529318 lbid 1363475008: input rids 8192, output rids 8174
      Sep 18 13:18:22 localhost PrimProc[29337]: 22.495557 |0|0|0| C 28 CAL0000: /home/builder/mariadb-columnstore-server/mariadb-columnstore-engine/primitives/primproc/columncommand.cpp error on projectResultRG for oid 529318 lbid 1363475009: input rids 8192, output rids 8173
      Sep 18 13:18:22 localhost PrimProc[29337]: 22.502594 |0|0|0| C 28 CAL0000: /home/builder/mariadb-columnstore-server/mariadb-columnstore-engine/primitives/primproc/columncommand.cpp error on projectResultRG for oid 529318 lbid 1362927232: input rids 8192, output rids 8191
      Sep 18 13:18:22 localhost PrimProc[29337]: 22.523705 |0|0|0| C 28 CAL0000: /home/builder/mariadb-columnstore-server/mariadb-columnstore-engine/primitives/primproc/columncommand.cpp error on projectResultRG for oid 529318 lbid 1363475010: input rids 8192, output rids 8174
      Sep 18 13:18:22 localhost PrimProc[29337]: 22.911010 |0|0|0| C 28 CAL0000: /home/builder/mariadb-columnstore-server/mariadb-columnstore-engine/primitives/primproc/columncommand.cpp error on projectResultRG for oid 529318 lbid 1363475011: input rids 8192, output rids 8184
      Sep 18 13:18:22 localhost PrimProc[29337]: 22.916014 |0|0|0| C 28 CAL0000: /home/builder/mariadb-columnstore-server/mariadb-columnstore-engine/primitives/primproc/columncommand.cpp error on projectResultRG for oid 529318 lbid 1363475012: input rids 8192, output rids 8176
      Sep 18 13:18:22 localhost PrimProc[29337]: 22.918348 |0|0|0| C 28 CAL0000: /home/builder/mariadb-columnstore-server/mariadb-columnstore-engine/primitives/primproc/columncommand.cpp error on projectResultRG for oid 529318 lbid 1362927233: input rids 8192, output rids 8191
      Sep 18 13:18:22 localhost PrimProc[29337]: 22.921142 |0|0|0| C 28 CAL0000: /home/builder/mariadb-columnstore-server/mariadb-columnstore-engine/primitives/primproc/columncommand.cpp error on projectResultRG for oid 529318 lbid 1363475013: input rids 8192, output rids 8168
      Sep 18 13:20:09 localhost PrimProc[29337]: 09.841498 |0|0|0| C 28 CAL0000: /home/builder/mariadb-columnstore-server/mariadb-columnstore-engine/primitives/primproc/columncommand.cpp error on projectResultRG for oid 529299 lbid 1363417222: input rids 8192, output rids 8191

      Additionally i get these error at random times:

      Sep 18 13:03:18 localhost [29337]: 18.682927 |0|0|0| W 28 CAL0000: BRP::getBlock(): got a BRM lookup error. LBID=5490343937 ver= SCN: 0#012 Txns: txn=0 vbFlg=0
      Sep 18 13:03:18 localhost PrimProc[29337]: 18.688682 |0|0|0| W 28 CAL0000: IDB-2035: An internal error occurred. Check the error log file & contact support.
      Sep 18 13:03:18 localhost PrimProc[29337]: 18.732647 |0|0|0| W 28 CAL0000: BRP::getBlock(): got a BRM lookup error. LBID=5490343937 ver= SCN: 0#012 Txns: txn=0 vbFlg=0
      Sep 18 13:03:18 localhost PrimProc[29337]: 18.783959 |0|0|0| W 28 CAL0000: BRP::getBlock(): got a BRM lookup error. LBID=5490343937 ver= SCN: 0#012 Txns: txn=0 vbFlg=0

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              jinraynor1 Jimmy Atauje Hidalgo
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.