[kepler-dev] [Bug 5444] New: Kepler can't run workflow if two instances exist at same time

[bugzilla-daemon at ecoinformatics.org]

http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5444

           Summary: Kepler can't run workflow if two instances exist at
                    same time
           Product: Kepler
           Version: 1.x dev
          Platform: Other
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: core
        AssignedTo: david.v.welker at gmail.com
        ReportedBy: tao at nceas.ucsb.edu
         QAContact: kepler-dev at kepler-project.org
   Estimated Hours: 0.0


Both vanilla and reporting suites (2.3) have problems. But the behaviors are
different:
1. Vanilla kepler:

Start a kepler then start antoher one. The second one runs a workflow. Then
close the first kepler. Finally close the second one, it shows the error:
java.sql.SQLException: Connection is broken: java.io.EOFException
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
at org.kepler.util.sql.DatabaseType._executeSQL(DatabaseType.java:930)
at org.kepler.util.sql.HSQL.disconnect(HSQL.java:79)
at
org.kepler.objectmanager.lsid.LSIDGenerator.closeDatabase(LSIDGenerator.java:400)
at org.kepler.module.core.Shutdown.shutdownModule(Shutdown.java:48)
at org.kepler.Kepler._initializeModules(Kepler.java:572)
at org.kepler.Kepler.access$100(Kepler.java:81)
at org.kepler.Kepler$Shutdown.shutdown(Kepler.java:663)
at org.kepler.util.ShutdownNotifier.shutdown(ShutdownNotifier.java:48)
at org.kepler.gui.KeplerGraphFrame.dispose(KeplerGraphFrame.java:1146)

2. Reporting kepler.
Two kepers are running. One runs a workflow and get an error:
<jing> 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-07-28
13:32:04.979 heartbeat - read: -8463 ms.
in .testWithReport.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-07-28
13:32:04.979 heartbeat - read: -8463 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)

-- 
Configure bugmail: http://bugzilla.ecoinformatics.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.