You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by "Amareshwari Sriramadasu (JIRA)" <ji...@apache.org> on 2015/01/29 02:23:34 UTC
[jira] [Created] (LENS-244) HSQL Database lock acquisition failure
when populating examples second time in separate db.
Amareshwari Sriramadasu created LENS-244:
--------------------------------------------
Summary: 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
Fix For: 2.1
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)