| 2013-08-21 20:42:21 |
Lara |
description |
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). |
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, compile_machine, or compile_os) 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). |
|
