Network packet read error while dumping the binlog file

Bug #1164399 reported by Vaibhav Fursule
10
This bug affects 2 people
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
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.