Wrong Query logged in case of parse error
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Medium
|
Oleg Tsarev | ||
5.1 |
Fix Released
|
Medium
|
Oleg Tsarev | ||
5.5 |
Fix Released
|
Medium
|
Oleg Tsarev |
Bug Description
It looks like some variables are not cleared in Percona Server 12.5 with logging:
mysql> create table zzz(i int);
ERROR 1050 (42S01): Table 'zzz' already exists
In the slow query log we have:
# Time: 110207 4:16:27.0000239554
# User@Host: root[root] @ localhost []
# Thread_id: 38 Schema: test Last_errno: 1050 Killed: 0
# Query_time: 0.000238 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 Rows_read: 1
# Bytes_sent: 39 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0
# QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No
# Filesort: No Filesort_on_disk: No Merge_passes: 0
# No InnoDB statistics available for this query
SET timestamp=
create table zzz(i int);
# Time: 110207 4:16:28.0000532378
# User@Host: root[root] @ localhost []
# Thread_id: 38 Schema: test Last_errno: 1050 Killed: 0
# Query_time: 0.000038 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 Rows_read: 1
# Bytes_sent: 39 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0
# QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No
# Filesort: No Filesort_on_disk: No Merge_passes: 0
# No InnoDB statistics available for this query
SET timestamp=
# administrator command: Quit;
Note Last_errno is reported 1050 for administrator command: Quit
Config file:
log_slow_queries
enable_
userstat_running=1
use_global_
log_slow_
log_slow_
log_slow_
slow_query_
log_slow_
long_query_time=0
Related branches
- Laurynas Biveinis (community): Approve
- Alexey Kopytov: Pending requested
-
Diff: 779 lines (+526/-107)1 file modifiedpatches/slow_extended.patch (+526/-107)
- Laurynas Biveinis (community): Approve
- Alexey Kopytov: Pending requested
-
Diff: 741 lines (+519/-92)1 file modifiedpatches/slow_extended.patch (+519/-92)
Changed in percona-server: | |
assignee: | Valentine Gostev (longbow) → Oleg Tsarev (tsarev) |
status: | New → In Progress |
would be great to have own .test file for this.