Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.0.4
-
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