Bug #69250 mysql program blocked
Submitted: 16 May 2013 5:43 Modified: 26 May 2013 7:42
Reporter: nielin nie Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Backup Severity:S1 (Critical)
Version:5.1.52 OS:Linux (Linux ASM 3.2.6 #3 SMP Mon Mar 12 16:54:21 CST 2012 x86_64 x86_64 x86_64 GNU/Linux)
Assigned to: CPU Architecture:Any
Tags: mysql program blocked

[16 May 2013 5:43] nielin nie
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
[26 May 2013 7:42] MySQL Verification Team
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

I suggest you run SHOW FULL PROCESSLIST next time and kill off any long-running queries, then check if a backup can be made.