Table ACTIVEMQ_LOCK DB cloud_portalmq
Hi Yesid,
Can you please let us know how do you take backup of these databases and what error do you get when you try to take backup?
Thanks,
Manish
Hello, I have a Problem with table ACTIVEMQ_LOCK, because not possible create a dump for the database cloud_portalmq, but i stop the service for Cloud-Portal the database not have problem, additionally when the service is running not possible access a information or see the data in this table, please helpme, because not possible generate backups of database
Hi Yesid,
Can you please let us know how do you take backup of these databases and what error do you get when you try to take backup?
Thanks,
Manish
Hello Manish, take Backup with mysqldump for all database she i execute the command mysqldump -u -p -h cloud_portalmq the command generate time out, and i test open database for program workbench and try to open the table ACTIVEMQ_LOCK the program not have output and inform that timeout, the problem is only in this database and this table, I test with other database and other table in the database cloud portal and the working good.
thanks,
Hi Yesid,
When CPBM is running it always hold a lock on the table "ACTIVEMQ_LOCK" and this will not allow the backup of this table.
You can skip backup of this table because this table does not hold any data but just a lock to make sure not other ActiveMQ broker start accessing the database.
You can use option "--ignore-table=db_name.tbl_name" to ignore this table.
Thanks,
Manish
Ask, Discuss, Answer