[MCOL-1885] Cross engine / Query stats doesn't show specific query errors Created: 2018-11-13  Updated: 2018-11-20  Resolved: 2018-11-20

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.2.0
Fix Version/s: 1.2.2

Type: Bug Priority: Major
Reporter: Andrew Hutchings (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2018-20

 Description   

It shows generic ones because we don't catch at mysql_real_query(), we catch at mysql_use_result() instead.

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2018-11-13 ]

DO NOT MERGE UNTIL 1.2.1 IS RELEASED

For QA:

1. Drop the infinidb_querystats.querystats table
2. Enable querystats in Columnstore.xml
3. Execute a ColumnStore query
4. Do "SHOW WARNINGS"

Before fix:

Columnstore Query Stats - fatal error running mysql_use_result() or empty result set in libmysql_client lib (4294967295) (unknown)

After fix:

Columnstore Query Stats - fatal error runing mysql_real_query() in libmysql_client lib (1146) (Table 'infinidb_querystats.querystats' doesn't exist)

Comment by Daniel Lee (Inactive) [ 2018-11-20 ]

Build verified: 1.2.2-1 source

/root/columnstore/mariadb-columnstore-server
commit 6bd66f5df21c6a8aa638ca92051bb833f2a8479f
Author: david hill <david.hill@mariadb.com>
Date: Thu Nov 15 09:22:34 2018 -0600

update version
/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit 77a3890fb0806bb263feaa53c2994ef86b95f8a0
Merge: ca55a80 a4f4580
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
Date: Tue Nov 20 15:44:24 2018 +0000

Merge pull request #630 from pleblanc1976/mcol-1847

Mcol 1847. Added ability to specify an absolute value for PM cache size

MariaDB [mytest]> select * from t1;
-----------+

c1 c2

-----------+

1 hello
1 world

-----------+
2 rows in set, 1 warning (0.092 sec)

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

Level Code Message

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

Note 1051 Unknown table 'infinidb_vtable.$vtable_14'
Warning 9999 Columnstore Query Stats - fatal error runing mysql_real_query() in libmysql_client lib (1146) (Table 'infinidb_querystats.querystats' doesn't exist)

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

Generated at Thu Feb 08 02:32:07 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.