I am running Mysql server with master and slave replication. From past few days i found that backups on my master server are incomplete.
When i ran manually on master it's returning the below error
"mysqldump: Error 1317: Query execution was interrupted when dumping table
table_name at row: 36705562"
Command i am using to take backups
mysqldump -u dbdump -p dbname --routines --single-transaction --lock-tables=false --max-allowed-packet=512M --master-data=2 -q -C -E -e -f -R | gzip -c > backup.sql.gz
Ideally i am using the same command on both master and slave, but it's failing on master.
I tried to do backup from remote machine but the same error.
In /etc/my.cnf --> max packet size is set to 512M