playback doesn't handle multi-line queries in slow log
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MOVED - Percona Playback |
New
|
Undecided
|
Unassigned |
Bug Description
If you send a query to mysql with newlines in the query string, mysql will write the query across multiple lines. However, playback seems to assume that each line is a full query:
Take this sample slow log:
/usr/sbin/mysqld, Version: 5.5.13-55-log (Percona Server (GPL), Release rel20.4, Revision 138). started with:
Tcp port: 3306 Unix socket: /dbname/
Time Id Command Argument
# User@Host: dbuser[dbuser] @ [127.0.0.1]
# Thread_id: 166047072 Schema: dbname Last_errno: 0 Killed: 0
# Query_time: 0.000102 Lock_time: 0.000031 Rows_sent: 1 Rows_examined: 1 Rows_affected: 0 Rows_read: 1
# Bytes_sent: 102 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0
# InnoDB_trx_id: 197B13D5A3
# 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
# InnoDB_IO_r_ops: 0 InnoDB_IO_r_bytes: 0 InnoDB_IO_r_wait: 0.000000
# InnoDB_
# InnoDB_
SET timestamp=
SELECT
column
FROM
table
WHERE foo=1
Running that file through the program generates these errors:
Database Plugin: libmysqlclient
Running...
Error query: SELECT
Connection 166047072 Rows Sent: 0 != expected 1 for query: SELECT
Error query: column
Connection 166047072 Rows Sent: 0 != expected 1 for query: column
Error query: FROM
Connection 166047072 Rows Sent: 0 != expected 1 for query: FROM
Error query: table
Connection 166047072 Rows Sent: 0 != expected 1 for query: table
Error query: WHERE foo=1
Connection 166047072 Rows Sent: 0 != expected 1 for query: WHERE foo=1
just realized that this is a dupe of: /bugs.launchpad .net/percona- playback/ +bug/1035217
https:/