Project

General

Profile

Actions
Copy link

Bug #5425

open

error when running -nocache and no .kepler

Added by Daniel Crawl over 13 years ago. Updated over 12 years ago.

Status:
New
Priority:
Normal
Assignee:
Derik Barseghian
Category:
core
Target version:
reporting-2.X.Y
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
Actions
Copy link
 #1

Updated by Derik Barseghian about 13 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.

Actions
Copy link
 #2

Updated by Daniel Crawl over 12 years ago

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

Actions
Copy link
 #3

Updated by Redmine Admin over 11 years ago

Original Bugzilla ID was 5425

Actions
Copy link

Also available in: Atom PDF