Project

General

Profile

Bug #5425

error when running -nocache and no .kepler

Added by Daniel Crawl almost 8 years ago. Updated almost 7 years ago.

Status:
New
Priority:
Normal
Category:
core
Target version:
Start date:
06/20/2011
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
5425

Description

The following occurs when running from the command line, specifying -nocache, and there's no .kepler:

[null] java.sql.SQLException: Table not found in statement [insert into cacheContentTable (name, lsid, date, file, type, classname) values ( ?, ?, ?, ?, ?, ? )]
[null] at org.hsqldb.jdbc.Util.throwError(Unknown Source)
[null] at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
[null] at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
[null] at org.kepler.objectmanager.cache.CacheManager.<init>(CacheManager.java:113)
[null] at org.kepler.objectmanager.cache.CacheManager.getInstance(CacheManager.java:141)
[null] at org.kepler.objectmanager.ObjectManager.getObjectFromCache(ObjectManager.java:398)
[null] at org.kepler.objectmanager.ObjectManager.getObjectRevision(ObjectManager.java:217)
[null] at org.kepler.util.WorkflowRunUtil.putInObjectManager(WorkflowRunUtil.java:46)
[null] at org.kepler.util.WorkflowRun.<init>(WorkflowRun.java:312)
[null] at org.kepler.provenance.sql.SQLQueryV8.getWorkflowRunsForExecutionLSIDs(SQLQueryV8.java:667)
[null] at org.kepler.workflowrunmanager.WorkflowRunManager.workflowRunManagerEventOccurred(WorkflowRunManager.java:1110)
[null] at org.kepler.workflowrunmanager.WorkflowRunManager.fireWorkflowRunManagerEvent(WorkflowRunManager.java:1089)
[null] at org.kepler.workflowrunmanager.WorkflowRunManager.fireWorkflowRunManagerEvent(WorkflowRunManager.java:1073)
[null] at org.kepler.workflowrunmanager.WorkflowRunManagerRecording.executionStart(WorkflowRunManagerRecording.java:107)
[null] at org.kepler.provenance.ProvenanceRecorder.preinitialize(ProvenanceRecorder.java:649)
[null] at ptolemy.actor.CompositeActor.preinitialize(CompositeActor.java:1683)
[null] at ptolemy.actor.Manager.preinitializeAndResolveTypes(Manager.java:928)
[null] at ptolemy.actor.Manager.initialize(Manager.java:635)
[null] at ptolemy.actor.Manager.execute(Manager.java:340)
[null] at ptolemy.actor.Manager.run(Manager.java:1109)
[null] at ptolemy.actor.Manager$PtolemyRunThread.run(Manager.java:1639)
[null] java.sql.SQLException: Table not found in statement [select name, lsid, file from cacheContentTable]
[null] at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
[null] at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
[null] at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
[null] at org.kepler.objectmanager.cache.CacheManager.getObject(CacheManager.java:508)
[null] at org.kepler.objectmanager.ObjectManager.getObjectFromCache(ObjectManager.java:398)
[null] at org.kepler.objectmanager.ObjectManager.getObjectRevision(ObjectManager.java:217)
[null] at org.kepler.util.WorkflowRunUtil.putInObjectManager(WorkflowRunUtil.java:46)
[null] at org.kepler.util.WorkflowRun.<init>(WorkflowRun.java:312)
[null] at org.kepler.provenance.sql.SQLQueryV8.getWorkflowRunsForExecutionLSIDs(SQLQueryV8.java:667)
[null] at org.kepler.workflowrunmanager.WorkflowRunManager.workflowRunManagerEventOccurred(WorkflowRunManager.java:1110)
[null] at org.kepler.workflowrunmanager.WorkflowRunManager.fireWorkflowRunManagerEvent(WorkflowRunManager.java:1089)
[null] at org.kepler.workflowrunmanager.WorkflowRunManager.fireWorkflowRunManagerEvent(WorkflowRunManager.java:1073)
[null] at org.kepler.workflowrunmanager.WorkflowRunManagerRecording.executionStart(WorkflowRunManagerRecording.java:107)
[null] at org.kepler.provenance.ProvenanceRecorder.preinitialize(ProvenanceRecorder.java:649)
[null] at ptolemy.actor.CompositeActor.preinitialize(CompositeActor.java:1683)
[null] at ptolemy.actor.Manager.preinitializeAndResolveTypes(Manager.java:928)
[null] at ptolemy.actor.Manager.initialize(Manager.java:635)
[null] at ptolemy.actor.Manager.execute(Manager.java:340)
[null] at ptolemy.actor.Manager.run(Manager.java:1109)
[null] at ptolemy.actor.Manager$PtolemyRunThread.run(Manager.java:1639)
[null] org.kepler.objectmanager.cache.CacheException: SQL exception when getting object
[null] at org.kepler.objectmanager.cache.CacheManager.getObject(CacheManager.java:533)
[null] at org.kepler.objectmanager.ObjectManager.getObjectFromCache(ObjectManager.java:398)
[null] at org.kepler.objectmanager.ObjectManager.getObjectRevision(ObjectManager.java:217)
[null] at org.kepler.util.WorkflowRunUtil.putInObjectManager(WorkflowRunUtil.java:46)
[null] at org.kepler.util.WorkflowRun.<init>(WorkflowRun.java:312)
[null] at org.kepler.provenance.sql.SQLQueryV8.getWorkflowRunsForExecutionLSIDs(SQLQueryV8.java:667)
[null] at org.kepler.workflowrunmanager.WorkflowRunManager.workflowRunManagerEventOccurred(WorkflowRunManager.java:1110)
[null] at org.kepler.workflowrunmanager.WorkflowRunManager.fireWorkflowRunManagerEvent(WorkflowRunManager.java:1089)
[null] at org.kepler.workflowrunmanager.WorkflowRunManager.fireWorkflowRunManagerEvent(WorkflowRunManager.java:1073)
[null] at org.kepler.workflowrunmanager.WorkflowRunManagerRecording.executionStart(WorkflowRunManagerRecording.java:107)
[null] at org.kepler.provenance.ProvenanceRecorder.preinitialize(ProvenanceRecorder.java:649)
[null] at ptolemy.actor.CompositeActor.preinitialize(CompositeActor.java:1683)
[null] at ptolemy.actor.Manager.preinitializeAndResolveTypes(Manager.java:928)
[null] at ptolemy.actor.Manager.initialize(Manager.java:635)
[null] at ptolemy.actor.Manager.execute(Manager.java:340)
[null] at ptolemy.actor.Manager.run(Manager.java:1109)
[null] at ptolemy.actor.Manager$PtolemyRunThread.run(Manager.java:1639)
[null] Caused by: java.sql.SQLException: Table not found in statement [select name, lsid, file from cacheContentTable]
[null] at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
[null] at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
[null] at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
[null] at org.kepler.objectmanager.cache.CacheManager.getObject(CacheManager.java:508)
[null] ... 16 more

History

#1 Updated by Derik Barseghian over 7 years ago

This seems like an advanced user usecase, and can be pushed post reporting-2.3.0, so retargeting.
Please put it back if you feel otherwise.

#2 Updated by Daniel Crawl almost 7 years ago

This does not occur with the kepler or provenance suite. Looks like wrm requires the cache db.

#3 Updated by Redmine Admin about 6 years ago

Original Bugzilla ID was 5425

Also available in: Atom PDF