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.