Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Unresolved
-
1.0.9
-
None
-
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
- duplicates
-
MCOL-1662 WriteEngine bulk methods do not version dictionaries correctly
- Closed
- is blocked by
-
MCOL-1278 occasionally IDB-2031: Blocks are missing. Alter or drop table in progress?`
- Closed
- relates to
-
MCOL-984 Error 1815 after several executions of example/basic_bulk_insert having SMALLINT in t1
- Closed