[kepler-dev] [Bug 5444] Kepler can't run workflow if two instances exist at same time
bugzilla-daemon at ecoinformatics.org
bugzilla-daemon at ecoinformatics.org
Wed Dec 7 09:41:41 PST 2011
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5444
--- Comment #13 from Jing Tao <tao at nceas.ucsb.edu> 2011-12-07 09:41:41 PST ---
Hrrm. I couldn't reproduce the bug dragging the sdf director this time when my
workflow run engine (embedded a reporting-2.3 kepler) is up.
However, when I started the second reporting-2.3 kepler instance, I got the
error:
[run] java.sql.SQLException: The database is already in use by another process:
lockFile: org.hsqldb.persist.LockFile at aef9f24b[file
=/home/tao/KeplerData/modules/provenance/db-2.3/provenanceDB.lck, exists=true,
locked=false, valid=false, ] method: checkHeartbeat read: 2011-12-07
09:37:55.611 heartbeat - read: -3887 ms.
[run] at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
[run] at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
[run] at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
[run] at org.hsqldb.jdbcDriver.connect(Unknown Source)
[run] at java.sql.DriverManager.getConnection(DriverManager.java:582)
[run] at java.sql.DriverManager.getConnection(DriverManager.java:185)
[run] at org.kepler.util.sql.HSQL._getConnection(HSQL.java:446)
[run] at
org.kepler.util.sql.DatabaseType.connect(DatabaseType.java:135)
[run] at
org.kepler.util.sql.DatabaseFactory.getConnectedDatabaseType(DatabaseFactory.java:283)
[run] at
org.kepler.provenance.sql.SQLQueryV8.<init>(SQLQueryV8.java:77)
[run] at
org.kepler.workflowrunmanager.WorkflowRunManager.connect(WorkflowRunManager.java:155)
[run] at
org.kepler.module.workflowrunmanager.Initialize.initializeModule(Initialize.java:141)
[run] at org.kepler.Kepler._initializeModules(Kepler.java:609)
[run] at org.kepler.Kepler.initialize(Kepler.java:472)
[run] at org.kepler.Kepler.parseArgsAndRun(Kepler.java:346)
[run] at org.kepler.Kepler.main(Kepler.java:260)
[run] org.kepler.provenance.QueryException: Unable to connect or
initialize database connection: The database is already in use by another
process: lockFile: org.hsqldb.persist.LockFile at aef9f24b[file
=/home/tao/KeplerData/modules/provenance/db-2.3/provenanceDB.lck, exists=true,
locked=false, valid=false, ] method: checkHeartbeat read: 2011-12-07
09:37:55.611 heartbeat - read: -3887 ms.
[run] at
org.kepler.provenance.sql.SQLQueryV8.<init>(SQLQueryV8.java:82)
[run] at
org.kepler.workflowrunmanager.WorkflowRunManager.connect(WorkflowRunManager.java:155)
[run] at
org.kepler.module.workflowrunmanager.Initialize.initializeModule(Initialize.java:141)
[run] at org.kepler.Kepler._initializeModules(Kepler.java:609)
[run] at org.kepler.Kepler.initialize(Kepler.java:472)
[run] at org.kepler.Kepler.parseArgsAndRun(Kepler.java:346)
[run] at org.kepler.Kepler.main(Kepler.java:260)
[run] Caused by: java.sql.SQLException: The database is already in use by
another process: lockFile: org.hsqldb.persist.LockFile at aef9f24b[file
=/home/tao/KeplerData/modules/provenance/db-2.3/provenanceDB.lck, exists=true,
locked=false, valid=false, ] method: checkHeartbeat read: 2011-12-07
09:37:55.611 heartbeat - read: -3887 ms.
[run] at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
[run] at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
[run] at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
[run] at org.hsqldb.jdbcDriver.connect(Unknown Source)
[run] at java.sql.DriverManager.getConnection(DriverManager.java:582)
[run] at java.sql.DriverManager.getConnection(DriverManager.java:185)
[run] at org.kepler.util.sql.HSQL._getConnection(HSQL.java:446)
[run] at
org.kepler.util.sql.DatabaseType.connect(DatabaseType.java:135)
[run] at
org.kepler.util.sql.DatabaseFactory.getConnectedDatabaseType(DatabaseFactory.java:283)
[run] at
org.kepler.provenance.sql.SQLQueryV8.<init>(SQLQueryV8.java:77)
[run] ... 6 more
And when i ran a workflow, i got the exception:
ptolemy.kernel.util.IllegalActionException: Error recording workflow structure:
Error connecting or initializing database.
{DB User Name=sa, Password=, DB Host=, DB Name=provenanceDB, DB Type=HSQL, DB
Port=9002, DB Table Prefix=, JDBC URL=}
The database is already in use by another process: lockFile:
org.hsqldb.persist.LockFile at aef9f24b[file
=/home/tao/KeplerData/modules/provenance/db-2.3/provenanceDB.lck, exists=true,
locked=false, valid=false, ] method: checkHeartbeat read: 2011-12-07
09:39:51.390 heartbeat - read: -9667 ms.
in .HelloWordWithReport.TOP Provenance Recorder
Because:
Error connecting or initializing database.
{DB User Name=sa, Password=, DB Host=, DB Name=provenanceDB, DB Type=HSQL, DB
Port=9002, DB Table Prefix=, JDBC URL=}
The database is already in use by another process: lockFile:
org.hsqldb.persist.LockFile at aef9f24b[file
=/home/tao/KeplerData/modules/provenance/db-2.3/provenanceDB.lck, exists=true,
locked=false, valid=false, ] method: checkHeartbeat read: 2011-12-07
09:39:51.390 heartbeat - read: -9667 ms.
at
org.kepler.provenance.ProvenanceRecorder._recordWorkflowContents(ProvenanceRecorder.java:2618)
at
org.kepler.provenance.ProvenanceRecorder.preinitialize(ProvenanceRecorder.java:583)
at ptolemy.actor.CompositeActor.preinitialize(CompositeActor.java:1682)
at ptolemy.actor.Manager.preinitializeAndResolveTypes(Manager.java:930)
at ptolemy.actor.Manager.initialize(Manager.java:636)
at ptolemy.actor.Manager.execute(Manager.java:340)
at ptolemy.actor.Manager.run(Manager.java:1111)
at ptolemy.actor.Manager$PtolemyRunThread.run(Manager.java:1641)
Caused by: org.kepler.provenance.RecordingException: Error connecting or
initializing database.
I am using reporting-2.3 suite and the os is Ubuntu 10.04.
--
Configure bugmail: http://bugzilla.ecoinformatics.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.
More information about the Kepler-dev
mailing list