Not the answer you need?
Register and ask your own question!

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

t0mt0m EntrantInactive User Role Beginner
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
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.