can't run tcpdump load

[Miguel Angel Nieto]

I have this table:

mysql> select * from test.t;
+------+
| i |
+------+
| 1 |
+------+

mysql> show create table test.t\G
*************************** 1. row ***************************
Table: t
Create Table: CREATE TABLE `t` (
`i` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1

I start tcpdump:

tcpdump -i any port 3306 -w example2.dump

In other session I connect to mysql and run:

USE test;
SELECT * FROM t;
SELECT * FROM t;
[...]

I stop tcpdump and try to use percona-playback:

# percona-playback --input-plugin=tcpdump --db-plugin=libmysqlclient --mysql-host=127.0.0.1 --mysql-username=root --mysql-schema=test --tcpdump-file=/root/example2.dump
Database Plugin: libmysqlclient
Running...
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).

Attached the example2.dump and the strace output.

[Miguel Angel Nieto (miguelangelnieto)]

Queries are there:

Starting tcpick 0.2.1 at 2013-04-17 13:17 CEST
Timeout for connections is 600
tcpick: reading from example2.dump
1 SYN-SENT 10.0.1.20:60931 > 10.0.1.20:mysql
1 SYN-RECEIVED 10.0.1.20:60931 > 10.0.1.20:mysql
1 ESTABLISHED 10.0.1.20:60931 > 10.0.1.20:mysql
O...
5.5.30-30.2.....W`_:D'4q...................\X$K-=-e8'Zq.mysql_native_password.
<...........!.......................root..mysql_native_password.
...........
!....select @@version_comment limit 1
.....'....def....@@version_comment..!....................4...3Percona Server (GPL), Release rel30.2, Revision 500.........
.....SELECT DATABASE()
..... ....def...
DATABASE()..!.f................................
.....test
...........
.....show databases
.....K....def.information_schema.SCHEMATA.SCHEMATA.Database.SCHEMA_NAME.!.................."......information_schema.....mysql.....performance_schema.....shbdn.....test... ...".
.....show tables
.....V....def.information_schema.TABLE_NAMES.TABLE_NAMES.Tables_in_test
TABLE_NAME.!.................."......t.......".
.....t.
.....def.test.t.t.i.i.?.....................
.....select * from t
..........def.test.t.t.i.i.?.................."......1.......".
.....select * from t
..........def.test.t.t.i.i.?.................."......1.......".
.....select * from t
..........def.test.t.t.i.i.?.................."......1.......".
.....select * from t
..........def.test.t.t.i.i.?.................."......1.......".
.....select * from t
..........def.test.t.t.i.i.?.................."......1.......".
.....select * from t
..........def.test.t.t.i.i.?.................."......1.......".
.....select * from t
..........def.test.t.t.i.i.?.................."......1.......".
.....select * from t
..........def.test.t.t.i.i.?.................."......1.......".
.....select * from t
..........def.test.t.t.i.i.?.................."......1.......".
.....select * from t
..........def.test.t.t.i.i.?.................."......1.......".
.....
1 FIN-WAIT-1 10.0.1.20:60931 > 10.0.1.20:mysql
1 TIME-WAIT 10.0.1.20:60931 > 10.0.1.20:mysql
1 CLOSED 10.0.1.20:60931 > 10.0.1.20:mysql
tcpick: done reading from example2.dump

[Miguel Angel Nieto (miguelangelnieto)]

I think I've found the problem. If you capture data with "-i any" percona-playback it doesn't work, it doesn't even connect to mysql. If you capture data with -i ethX it works.