Details
-
Improvement
-
Status: Done
-
Medium
-
Resolution: Fixed
-
8.0.17-8, 5.7.28-31
-
None
Description
Start Percona Server 8.0 with slow query log enabled:
--loose-log_slow_verbosity=full --slow_query_log=1 --long_query_time=0
Execute following statements:
mysql -uroot test
mysql> create table t1(f1 decimal(5,2) not null);
mysql>INSERT INTO t1(f1) values (31.400191);
Row was successfully inserted but also we got a warning with error code 1265. This warning was logged into the slow query log as value for 'Last_errno' field (see below) but that field should represent only real errors and not a warnings.
<cut>
Time: 2019-12-18T18:53:15.857371Z
- [email protected]: root[root] @ localhost [] Id: 40167
- Schema: test Last_errno: 1265 Killed: 0
- Query_time: 0.000593 Lock_time: 0.000101 Rows_sent: 0 Rows_examined: 0 Rows_affected: 1
- Bytes_sent: 11 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0
- InnoDB_trx_id: 32015
- Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No
- Filesort: No Filesort_on_disk: No Merge_passes: 0
- InnoDB_IO_r_ops: 0 InnoDB_IO_r_bytes: 0 InnoDB_IO_r_wait: 0.000000
- InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000
- InnoDB_pages_distinct: 5
SET timestamp=1576695195;
INSERT INTO t1(f1) values (31.400191);
<cut>
Slow query log should be fixed to separate errors from warnings and report only errors in 'Last_errno' field.
Attachments
Issue Links
- relates to
-
PS-6774 slow_query_log broken for Last_errno: filed in percona server 8.0
-
- Done
-