Waiting for changelog lock....
During start-up, the following messages may appear in the cascade.log file and prevent Cascade Server from starting:
...
Waiting for changelog lock....
Waiting for changelog lock....
Waiting for changelog lock....
...
To see which machine has locked the Cascade Server database, execute the following SQL query:
select * from DATABASECHANGELOGLOCK;
Check the lockedby column to see who locked the table. Generally, the lock will be from the local machine.
If this is the case (and no other machine has a lock on the database), the record should be updated by executing the following query:
update DATABASECHANGELOGLOCK
set locked=0, lockgranted=null, lockedby=null
where id=1
After updating this record Cascade Server should start up again without any problems.