Community
 
 
 

CloudPortal Business Manager 2.x

324フォロワー
 
Avatar
yesid Mora

Table ACTIVEMQ_LOCK DB cloud_portalmq

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


4件のコメント
0

サインインしてコメントを残してください。

 
 

Previous 4件のコメント

Avatar
Administrator
Avatar

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


Manish Agarwal CITRIX EMPLOYEES
コメントアクション パーマリンク
Avatar
yesid Mora

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,


コメントアクション パーマリンク
Avatar
Administrator
Avatar

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


Manish Agarwal CITRIX EMPLOYEES
コメントアクション パーマリンク
Avatar
yesid Mora

Hello Manish, thanks for your comments, I execute dump satisfactory.


コメントアクション パーマリンク

Top Contributors