Comment 0 for bug 1215136

I am getting a parse column error on two different tests I've tried. I'm running percona-playback on Ubuntu 10.0.4 and have tried both Percona 5.5 and MySQL 5.1 servers, getting the same results.

The queries run for the first test:
SELECT * FROM test LIMIT 10;
UPDATE test SET p = "test" WHERE id = 1;
DELETE FROM test WHERE id = 2;

The second test was meant to capture a sysbench oltp test.

Printing out the queries causing the errors gave me the following results:

(First test) select @@version_coort

(Second test) SHOW TABLE STATUS Lort

It seems like this may be a parsing issue with the tcpdump file? I'm guessing it should be select @@version_comment and SHOW TABLE STATUS LIKE <something>, but not sure why it's getting "ort" instead.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

tcpdump -i lo port 3306 -w example2.dump

percona-playback --input-plugin=tcpdump --tcpdump-file=example2.dump --tcpdump-mode=fast --db-plugin=libmysqlclient --mysql-host=127.0.0.1 --mysql-username=test --mysql-schema=test

Database Plugin: libmysqlclient
 Running...
Parse column error
Error during query: Unknown system variable 'version_coort', number of tries 0
Error during query: Unknown system variable 'version_coort', number of tries 1
Error during query: Unknown system variable 'version_coort', number of tries 2
Error during query: Unknown system variable 'version_coort', number of tries 3
Error during query: Unknown system variable 'version_coort', number of tries 4
Error during query: Unknown system variable 'version_coort', number of tries 5
Error during query: Unknown system variable 'version_coort', number of tries 6
Error during query: Unknown system variable 'version_coort', number of tries 7
Error during query: Unknown system variable 'version_coort', number of tries 8
Error during query: Unknown system variable 'version_coort', number of tries 9
Error Report finished

Detailed Report
----------------
SELECTs : 0 queries (0 faster, 0 slower)
INSERTs : 0 queries (0 faster, 0 slower)
UPDATEs : 0 queries (0 faster, 0 slower)
DELETEs : 0 queries (0 faster, 0 slower)
REPLACEs : 0 queries (0 faster, 0 slower)
DROPs : 0 queries (0 faster, 0 slower)

Report
------
Executed 0 queries
Spent 00:00:00 executing queries versus an expected 00:00:00 time.
0 queries were quicker than expected, 0 were slower
A total of 0 queries had errors.
Expected 0 rows, got 0 (a difference of 0)
Number of queries where number of rows differed: 0.

Average of -nan queries per connection (0 connections).

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

tcpdump -i eth0 src host 10.0.0.1 and port 3306 -w example.dump

percona-playback --input-plugin=tcpdump --tcpdump-file=example2.dump --tcpdump-mode=fast --db-plugin=libmysqlclient --mysql-host=127.0.0.1 --mysql-username=test --mysql-schema=test

Database Plugin: libmysqlclient
 Running...
Error during query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Lort' at line 1, number of tries 0
Error during query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Lort' at line 1, number of tries 1
Error during query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Lort' at line 1, number of tries 2
Error during query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Lort' at line 1, number of tries 3
Error during query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Lort' at line 1, number of tries 4
Error during query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Lort' at line 1, number of tries 5
Error during query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Lort' at line 1, number of tries 6
Error during query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Lort' at line 1, number of tries 7
Error during query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Lort' at line 1, number of tries 8
Error during query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Lort' at line 1, number of tries 9
Error Report finished

Detailed Report
----------------
SELECTs : 0 queries (0 faster, 0 slower)
INSERTs : 0 queries (0 faster, 0 slower)
UPDATEs : 0 queries (0 faster, 0 slower)
DELETEs : 0 queries (0 faster, 0 slower)
REPLACEs : 0 queries (0 faster, 0 slower)
DROPs : 0 queries (0 faster, 0 slower)

Report
------
Executed 0 queries
Spent 00:00:00 executing queries versus an expected 00:00:00 time.
0 queries were quicker than expected, 0 were slower
A total of 0 queries had errors.
Expected 0 rows, got 0 (a difference of 0)
Number of queries where number of rows differed: 0.

Average of -nan queries per connection (0 connections).