INFO 6/11/13 9:06 PM:liquibase: Waiting for changelog lock....

11 de Junho de 2013 19:11

What does this mean, i had an error creating a retail company, then i was not able to delete or continue with
that company so i just used an image of the database server to recover from when the company was not
created. now when i start CPBM i get this:
INFO 6/11/13 9:06 PM:liquibase: Waiting for changelog lock....

I woul be really nice i Citrix would be able to write a few lines about what we should do to remove a company
when creation has gone wrong????

are there any select statesments we can use to remove a company.. ?

Kind regards
Gert

4 comentários

Comentário oficial

Pankaj Paliwal

23 de Março de 2016 07:47

Hi Gert,

All the CPBM logs are in the file *+/usr/share/cloud/portal/logs/cpbm-server.log+*.

Thanks,
Manish

Manish Agarwal CITRIX EMPLOYEES 12 June 2013 - 05:42 AM

iniciar sessão para comentar.

Previous 4 comentários

Data Votos

Gert Jensen

23 de Março de 2016 07:47

Is it just me or ?

once you go Citrix CPBM you go alone.. ?

Pankaj Paliwal

23 de Março de 2016 07:47

Hi Gert,

Regarding the "Waiting for changelog lock issue", it seems the CPBM server stopped when it was holding the changelog lock and could not relinquish when stopped.

Could you please use below MySQL queries to remove the lock. These need to be run from console on the MySQL server.

$ mysql -u root cloud_portal -e "update DATABASECHANGELOGLOCK set locked=false, LOCKGRANTED=null, LOCKEDBY=null where id=1"
$ mysql -u root cloud_reports -e "update DATABASECHANGELOGLOCK set locked=false, LOCKGRANTED=null, LOCKEDBY=null where id=1"

And regarding removal of an account, any account which is not in New state can be Terminated and then Removed from UI ("*Accounts*" >> "*All Accounts*" >> <select the account and perform Change State from menu available at gear icon>).
For accounts in New state, we do not allow change of state to avoid activation of account without following workflow. Following MySQL query can be used to mark an account Terminated and removed.
$ update tenants set state=4 , removed=now(), removed_by=1 where account_id = 'AA000005'

*Note:* Above query should be used only when account is in New state , when account is in any other state then "*Change State*" must be used in order to perform required clean up.

Please let me know if any other info is required.

Thanks,
Manish

Manish Agarwal CITRIX EMPLOYEES 12 June 2013 - 03:59 AM

Gert Jensen

23 de Março de 2016 07:47

Hello Manish,

THANKY YOU,

That solved the problem, my problem was the the tennant was stock in the New state.

Do you have any info on there to look i.e which log files, when you get page not found.. ?
I know that this is a different questions, but i can not fint the logs for this..
i get it on the login page when i try to request an account, and then click on retail.

Kind reagards
Gert