[LENS-244] HSQL Database lock acquisition failure when populating examples second time in separate db.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.2
• Component/s: examples
• Assignee: Amareshwari Sriramadasu
• Reporter: Amareshwari Sriramadasu
• Created: 29/Jan/15 01:23
• Updated: 03/Jul/15 13:40
• Resolved: 28/Apr/15 08:44

Description

When we populate examples in more than db, seeing the following :

java.sql.SQLException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@ac3a4182[file =/private/tmp/db-storage.db.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2015-01-29 01:17:15 heartbeat - read: -7434 ms.
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
	at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
	at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
	at java.sql.DriverManager.getConnection(DriverManager.java:579)
	at java.sql.DriverManager.getConnection(DriverManager.java:221)
	at org.apache.lens.examples.DatabaseUtil.initalizeDatabaseStorage(DatabaseUtil.java:46)
	at org.apache.lens.examples.PopulateSampleMetastore.populateDimTables(PopulateSampleMetastore.java:108)
	at org.apache.lens.examples.PopulateSampleMetastore.populateAll(PopulateSampleMetastore.java:64)
	at org.apache.lens.examples.PopulateSampleMetastore.main(PopulateSampleMetastore.java:54)
Caused by: org.hsqldb.HsqlException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@ac3a4182[file =/private/tmp/db-storage.db.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2015-01-29 01:17:15 heartbeat - read: -7434 ms.
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.persist.LockFile.newLockFileLock(Unknown Source)
	at org.hsqldb.persist.Logger.acquireLock(Unknown Source)
	at org.hsqldb.persist.Logger.openPersistence(Unknown Source)
	at org.hsqldb.Database.reopen(Unknown Source)
	at org.hsqldb.Database.open(Unknown Source)
	at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)
	at org.hsqldb.DatabaseManager.newSession(Unknown Source)
	... 9 more

Restarting the server solves the lock issue.