Network packet read error while dumping the binlog file
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Data Dumper |
New
|
Undecided
|
Unassigned |
Bug Description
I am new to mydumper, after successful installation I took some backups but when I tried to dump to binlog using option -b I got the following error
Network packet read error getting binlog file: mysqld-bin.000001
I am doing the backup on localhost
mydumper version - mydumper-0.5.2
MySQL version - 5.1.67-log Source distribution
OS - CentOS Linux release 6.0 (Final)
root@centos6 mydumper-0.5.2]# mydumper -B abc -o /tmp/mydumperbackup -v 3 -b
** Message: Connected to a MySQL server
** Message: Started dump at: 2013-04-04 02:32:01
** Message: Written master status
** Message: Thread 1 connected using MySQL connection ID 13
** Message: Thread 2 connected using MySQL connection ID 14
** Message: Thread 3 connected using MySQL connection ID 15
** Message: Thread 4 connected using MySQL connection ID 16
** Message: Thread 1 dumping data for `abc`.`tp`
** Message: Thread 2 dumping schema for `abc`.`tp`
** Message: Non-InnoDB dump complete, unlocking tables
** Message: Thread 3 connected using MySQL connection ID 17 (in binlog mode)
** Message: Thread 3 dumping binary log file mysqld-bin.000001
** Message: Thread 4 connected using MySQL connection ID 18 (in binlog mode)
** Message: Thread 4 dumping binary log file mysqld-bin.000002
** (mydumper:9282): CRITICAL **: Error: binlog: Network packet read error getting binlog file: mysqld-bin.000001
** Message: Thread 3 shutting down
** (mydumper:9282): CRITICAL **: Error: binlog: Network packet read error getting binlog file: mysqld-bin.000002
** Message: Thread 4 shutting down
** Message: Thread 2 connected using MySQL connection ID 19 (in binlog mode)
** Message: Thread 2 dumping binary log file mysqld-bin.000003
** (mydumper:9282): CRITICAL **: Error: binlog: Network packet read error getting binlog file: mysqld-bin.000003
** Message: Thread 2 shutting down
** Message: Thread 1 shutting down
** Message: Finished dump at: 2013-04-04 02:32:02
-------
ls output of the the backup directory
total 164K
4.0K drwxr-xr-x 3 root root 4.0K Apr 4 01:58 ./
4.0K dr-xr-x---. 19 root root 4.0K Apr 4 02:57 ../
4.0K -rw-r--r-- 1 root root 248 Apr 4 02:32 abc.tp-schema.sql
144K -rw-r--r-- 1 root root 142K Apr 4 02:32 abc.tp.sql
4.0K drwx------ 2 root root 4.0K Apr 4 02:32 binlog_snapshot/
4.0K -rw-r--r-- 1 root root 130 Apr 4 02:32 metadata
-------
cat metadata
Started dump at: 2013-04-04 02:32:01
SHOW MASTER STATUS:
Log: mysqld-bin.000003
Pos: 106
Finished dump at: 2013-04-04 02:32:02
summary: |
- Network packet read error while dupling the binlog file + Network packet read error while dumping the binlog file |