While taking the full backup, my app cannot write any data to mysql.

Hi,

I’m trying to take the mysql (innodb) full backup, using the xtrabackup.

innobackupex --user=root --password=root --defaults-file=${mysql_install}/db.cnf --socket=/tmp/mysql.sock --parallel=4 --lock-wait-timeout=1200 ${backup dir}

However, while taking the full backup, my app (java application) cannot write any data in mysql. During the full backup, the following exception happens many times in my app. It looks like the app is waiting to release any lock by the xtrabackup.


Caused by: java.lang.RuntimeException: java.lang.InterruptedException
at com.singularity.ee.controller.beans.agent.db.PerfDataUtils.readLockMetricData(PerfDataUtils.java:787)

Could you please give me the workaround? If you need further information, please let me know.

Best regards,
t0m