Could not acquire change log lock.
Answered
Hi,
Getting this error while trying to update yellowfin. as I can see it's due to some DATABASECHANGELOGLOCK table where to find this table.
Regards
Pratap
The same question
Hi Pratap,
Is this a production server or a test/dev server?
It sounds as though the upgrade was running and something caused the lock (possibly something else trying to use the DB) which causes the upgrade to fail. Was Yellowfin shutdown properly before the upgrade?
For whatever reason however, the lock record has not been cleared from the DB.
You should be able to manually clear the row from the ChangeLockTable and all should be well. As always, please backup the DB prior to making any manual changes.
Check the TABLE
SELECT * FROM databasechangeloglock;
Clear the ROW
DELETE FROM databasechangeloglock where id=1;
Let me know how it goes.
Thank you,
Paul
Hi Pratap,
Is this a production server or a test/dev server?
It sounds as though the upgrade was running and something caused the lock (possibly something else trying to use the DB) which causes the upgrade to fail. Was Yellowfin shutdown properly before the upgrade?
For whatever reason however, the lock record has not been cleared from the DB.
You should be able to manually clear the row from the ChangeLockTable and all should be well. As always, please backup the DB prior to making any manual changes.
Check the TABLE
SELECT * FROM databasechangeloglock;
Clear the ROW
DELETE FROM databasechangeloglock where id=1;
Let me know how it goes.
Thank you,
Paul
Hi Pratap,
Is this a production server or a test/dev server?
It sounds as though the upgrade was running and something caused the lock (possibly something else trying to use the DB) which causes the upgrade to fail. Was Yellowfin shutdown properly before the upgrade?
For whatever reason however, the lock record has not been cleared from the DB.
You should be able to manually clear the row from the ChangeLockTable and all should be well. As always, please backup the DB prior to making any manual changes.
Check the TABLE
SELECT * FROM databasechangeloglock;
Clear the ROW
DELETE FROM databasechangeloglock where id=1;
Let me know how it goes.
Thank you,
Paul
Hi Pratap,
Is this a production server or a test/dev server?
It sounds as though the upgrade was running and something caused the lock (possibly something else trying to use the DB) which causes the upgrade to fail. Was Yellowfin shutdown properly before the upgrade?
For whatever reason however, the lock record has not been cleared from the DB.
You should be able to manually clear the row from the ChangeLockTable and all should be well. As always, please backup the DB prior to making any manual changes.
Check the TABLE
SELECT * FROM databasechangeloglock;
Clear the ROW
DELETE FROM databasechangeloglock where id=1;
Let me know how it goes.
Thank you,
Paul
Hi Pratap,
That is great news. I will mark this as completed, but please get back to me if you need anything else.
Cheers,
Paul
Hi Pratap,
That is great news. I will mark this as completed, but please get back to me if you need anything else.
Cheers,
Paul
Replies have been locked on this page!