[
https://issues.apache.org/jira/browse/LENS-244?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Raghavendra Singh closed LENS-244.
----------------------------------
> HSQL Database lock acquisition failure when populating examples second time
> in separate db.
> -------------------------------------------------------------------------------------------
>
> Key: LENS-244
> URL: https://issues.apache.org/jira/browse/LENS-244
> Project: Apache Lens
> Issue Type: Bug
> Components: examples
> Reporter: Amareshwari Sriramadasu
> Assignee: Amareshwari Sriramadasu
> Fix For: 2.2
>
> Attachments: LENS-244.patch
>
>
> When we populate examples in more than db, seeing the following :
> {noformat}
> 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
> {noformat}
> Restarting the server solves the lock issue.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
