Description:
I excepted to get a backup file of MYSQL,
but the program blocked when I run command "mysqldump -uroot -pxxxxxxxxxxxxxxx --single-transaction --flush-logs --default-character-set=gb2312 --master-data=2 --add-drop-table ASM --ignore-table=ASM.THaBinLog --ignore-table=ASM.TAlarmLog --ignore-table=ASM.TEmail --ignore-table=ASM.THaBinLog --ignore-table=ASM.ToperatorLog --ignore-table=ASM.TSMSList --ignore-table=ASM.VIEW_testcreate2 --ignore-table=ASM.VIEW_audit --ignore-table=ASM.VIEW_liubin --ignore-table=ASM.VIEW_testcreate1 --ignore-table=ASM.VIEW_admin --ignore-table=ASM.VIEW_liaoct1 --ignore-table=ASM.VIEW_test1 --ignore-table=ASM.VIEW_2 --ignore-table=ASM.VIEW_liaoct --ignore-table=ASM.VIEW_test --ignore-table=ASM.VIEW_1 --ignore-table=ASM.VIEW_zhaoying --ignore-table=ASM.VIEW_dengtan --ignore-table=ASM.VIEW_secadmin --ignore-table=ASM.VIEW_wlj2 --ignore-table=ASM.VIEW_debug2 --ignore-table=ASM.VIEW_luokf --ignore-table=ASM.VIEW_wlj1 --ignore-table=ASM.VIEW_debug1 --ignore-table=ASM.VIEW_lixl --ignore-table=ASM.VIEW_wanglj --ignore-table=ASM.VIEW_debug --ignore-table=ASM.VIEW_lixiaoling88888888889999999999 --ignore-table=ASM.VIEW_thirdadmin --ignore-table=ASM.VIEW_cascade".
The more detail message followed blow:
130515 16:01:51 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.52-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
130515 16:01:54 [ERROR] Slave I/O: error connecting to master 'ha@191.191.191.192:3306' - retry-time: 3 retries: 86400, Error_code: 2013
130515 16:01:57 [Note] Slave I/O thread: connected to master 'ha@191.191.191.192:3306',replication started in log 'mysql-bin.007516' at position 722379
130515 16:02:17 [Note] Slave I/O thread killed while reading event
130515 16:02:17 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.007517', position 499778
130515 16:02:19 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.007516' at position 995930
130515 16:02:20 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='191.191.191.192', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='191.191.191.192', master_port='3306', master_log_file='mysql-bin.007516', master_log_pos='833285'.
130515 16:02:20 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.007516' at position 833285, relay log './mysqld-relay-bin.000001' position: 4
130515 16:02:20 [Note] Slave I/O thread: connected to master 'ha@191.191.191.192:3306',replication started in log 'mysql-bin.007516' at position 833285
130515 16:18:55 [Note] Slave I/O thread killed while reading event
130515 16:18:55 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.007518', position 233881
130515 16:18:55 [Note] Error reading relay log event: slave SQL thread was killed
130515 20:08:22 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='191.191.191.192', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='191.191.191.192', master_port='3306', master_log_file='mysql-bin.007518', master_log_pos='455924'.
130515 20:08:22 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.007518' at position 455924, relay log './mysqld-relay-bin.000001' position: 4
130515 20:08:22 [Note] Slave I/O thread: connected to master 'ha@191.191.191.192:3306',replication started in log 'mysql-bin.007518' at position 455924
130515 20:08:26 [Note] Slave I/O thread killed while reading event
130515 20:08:26 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.007518', position 467469
130515 20:08:26 [Note] Error reading relay log event: slave SQL thread was killed
130515 20:17:16 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='191.191.191.192', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='191.191.191.192', master_port='3306', master_log_file='mysql-bin.007518', master_log_pos='489095'.
130515 20:17:16 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.007518' at position 489095, relay log './mysqld-relay-bin.000001' position: 4
130515 20:17:16 [Note] Slave I/O thread: connected to master 'ha@191.191.191.192:3306',replication started in log 'mysql-bin.007518' at position 489095
130515 20:17:19 [Note] Slave I/O thread killed while reading event
130515 20:17:19 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.007518', position 494457
How to repeat:
unknown