http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5444
--- Comment #13 from Jing Tao <[email protected]> 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@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@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@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@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@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. _______________________________________________ Kepler-dev mailing list [email protected] http://lists.nceas.ucsb.edu/kepler/mailman/listinfo/kepler-dev
