[MCOL-970] MariaDB's slow query log only logging vtable information Created: 2017-10-12  Updated: 2020-08-25  Resolved: 2018-07-26

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

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

Sprint: 2018-14, 2018-15

 Description   

The slow query log is logging vtable information instead of details of the actual user query.



 Comments   
Comment by Roman [ 2018-07-03 ]

Fixed for 1.1.
Steps to reproduce:

set global slow_query_log=1;
set slow_query_log=1;
select l_orderkey,l_linenumber,l_shipmode,l_shipinstruct,l_shipinstruct from lineitem order by 1,2;
update lineitem set l_linenumber  where l_shipinstruct='COLLECT COD';

After that one consults /usr/local/mariadb/columnstore/mysql/db/$hostname-slow.log for slow query entries.

Comment by Roman [ 2018-07-03 ]

Please review.

Comment by Daniel Lee (Inactive) [ 2018-07-26 ]

Build verified: 1.1.6-1 source

/root/columnstore/mariadb-columnstore-server
commit 513775738f72ec990d055a5d47e2511e3c0e34dd
Merge: 3c37210 9236098
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
Date: Wed Jul 18 09:37:17 2018 +0100

Merge pull request #123 from drrtuy/MCOL-970

MCOL-970 Slow query log now contains original query even in vtable mode

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit f9f6dc43dd15ad3f2ca2d9e515b1e44028a16183
Merge: ced7eb4 1170b4e
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
Date: Tue Jul 24 18:06:24 2018 +0100

Merge pull request #526 from mariadb-corporation/MCOL-1535

Mcol 1535

Reproduced the issue in 1.1.5-1

use test1;
SET timestamp=1532617240;
select * from infinidb_vtable.$vtable_23 order by 1, 2;

Verified in 1.1.6-1

use test1;
SET timestamp=1532617312;
select l_orderkey,l_linenumber,l_shipmode,l_shipinstruct,l_shipinstruct from lineitem order by 1,2;

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