Liquibase lock – reasons?

by

Sometimes if the update application is abruptly stopped, then the lock remains stuck.

Then running

UPDATE DATABASECHANGELOGLOCK SET LOCKED=0, LOCKGRANTED=null, LOCKEDBY=null where ID=1;

against the database helps.

You may also need to replace LOCKED=0 with LOCKED=FALSE.

Or you can simply drop the DATABASECHANGELOGLOCK table, it will be recreated.

More Related Contents:

  1. Can we update primary key values of a table?
  2. Oracle (ORA-02270) : no matching unique or primary key for this column-list error
  3. How to display table data more clearly in oracle sqlplus
  4. How SID is different from Service name in Oracle tnsnames.ora
  5. Are foreign keys really necessary in a database design?
  6. Is it possible to generate django models from the database?
  7. What is a View in Oracle?
  8. What is the difference between Non-Repeatable Read and Phantom Read?
  9. Business Logic: Database or Application Layer
  10. Convert String ISO-8601 date to oracle’s timestamp datatype
  11. What is the default Precision and Scale for a Number in Oracle?
  12. Oracle: How do I convert hex to decimal in Oracle SQL?
  13. How to recover a corrupt SQLite3 database?
  14. How do IMMUTABLE, STABLE and VOLATILE keywords effect behaviour of function?
  15. Partial Dependency (Databases)
  16. Can I rollback a transaction I’ve already committed? (data loss)
  17. What is the most efficient way to store tags in a database?
  18. Microservices with shared database? using multiple ORM’s? [closed]
  19. What’s the best strategy for unit-testing database-driven applications?
  20. Does mysql have the equivalent of Oracle’s “analytic functions”?
  21. Is there a standard for storing normalized phone numbers in a database?
  22. how to use Blob datatype in Postgres
  23. Is there any option for local database like Sqlite for j2me – CLDC devices?
  24. Are database triggers necessary? [closed]
  25. Which is a good design for a database table that can be owned by two different resources, and therefore needs two different foreign keys? [closed]
  26. many-to-many relationship in database design
  27. What can cause an Oracle ROWID to change?
  28. HTML5 database storage (SQL lite) – few questions
  29. Oracle DB: How can I write query ignoring case?
  30. Maximum number of rows in a sqlite table

Leave a Comment