Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Fixed
-
8.0.17-8, Not 5.7.x
-
None
Description
slow_query_log broken for Last_errno: filed in percona server 8.0
Even though my query ran successfully on mysql client without any error or warning, in the slow log it showing Last_errno: 3554
Percona server 8.0.17
mysql [localhost] {msandbox} ((none)) > SELECT SCHEMA_NAME as XYZTest FROM information_schema.schemata WHERE SCHEMA_NAME NOT IN ('mysql', 'performance_schema', 'information_schema'); +---------+ | XYZTest | +---------+ | sys | | test | | test1 | +---------+ 3 rows in set (0.01 sec) # Time: 2020-01-14T12:46:31.378334Z # User@Host: msandbox[msandbox] @ localhost [] Id: 8 # Schema: Last_errno: 3554 Killed: 0 # Query_time: 0.007943 Lock_time: 0.002580 Rows_sent: 3 Rows_examined: 13 Rows_affected: 0 # Bytes_sent: 108 SET timestamp=1579005991; SELECT SCHEMA_NAME as XYZTest FROM information_schema.schemata WHERE SCHEMA_NAME NOT IN ('mysql', 'performance_schema', 'information_schema');
It's working fine and as expected in percona server 5.7:
Percona Server 5.7
master [localhost] {msandbox} ((none)) > SELECT SCHEMA_NAME as XYZTest FROM information_schema.schemata WHERE SCHEMA_NAME NOT IN ('mysql', 'performance_schema', 'information_schema'); +---------+ | XYZTest | +---------+ | sys | | test | +---------+ 2 rows in set (0.00 sec) # Time: 2020-01-14T15:05:36.041846Z # User@Host: msandbox[msandbox] @ localhost [] Id: 16 # Schema: Last_errno: 0 Killed: 0 # Query_time: 0.001092 Lock_time: 0.000432 Rows_sent: 2 Rows_examined: 5 Rows_affected: 0 # Bytes_sent: 111 SET timestamp=1579014336; SELECT SCHEMA_NAME as XYZTest FROM information_schema.schemata WHERE SCHEMA_NAME NOT IN ('mysql', 'performance_schema', 'information_schema');
Attachments
Issue Links
- relates to
-
PS-6730 Slow query log: Field 'Last_errno:' should be used for errors only
-
- Done
-