[kepler-dev] Problems running from the trunk
Aaron Schultz
aschultz at nceas.ucsb.edu
Wed May 13 15:01:20 PDT 2009
Hi David,
Yeah that is the error you get if config.xml is not updated to include
the new "TYPE" column in the cacheContentTable.
For some reason the table definitions for the hsql database are defined
in config.xml
that probably should change along with a tracking mechanism for
database schema versions
This would allow us to have update scripts for migrating data from one
version to the next version.
Instead of having to clean-cache every time the tables change, you would
instead run the appropriate migration script.
Aaron
David Welker wrote:
> This error has been resolved.
>
> David
>> I have updated, and I get some problems running at the trunk do to
>> recent changes. I think Aaron might be best positioned to figure it
>> out, because the errors mention both the TabPane and the LSID.
>>
>> -David
>>
>> run:
>> [run] Building Kars...
>> [run] Opening user preferences PtolemyPreferences.xml...
>> [run] java.sql.SQLException: Column count does not match in
>> statement [insert into cacheContentTable (name, lsid, date, file,
>> expiration, type) values ( ?, ?, ?, ?, ?, ? )]
>> [run] at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
>> [run] at
>> org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
>> [run] at
>> org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
>> [run] at
>> org.kepler.objectmanager.cache.CacheManager.insertObject(CacheManager.java:280)
>>
>> [run] at
>> org.kepler.objectmanager.cache.KARCacheObject.openKAR(KARCacheObject.java:188)
>>
>> [run] at
>> org.kepler.moml.KARLibraryBuilderTask.run(KARLibraryBuilder.java:317)
>> [run] at
>> org.kepler.moml.KARLibraryBuilder.buildLibrary(KARLibraryBuilder.java:170)
>>
>> [run] at
>> ptolemy.actor.gui.UserActorLibrary.openLibrary(UserActorLibrary.java:202)
>>
>> [run] at
>> ptolemy.actor.gui.UserActorLibrary.openUserLibrary(UserActorLibrary.java:140)
>>
>> [run] at
>> ptolemy.vergil.VergilApplication._createDefaultConfiguration(VergilApplication.java:304)
>>
>> [run] at
>> ptolemy.vergil.VergilApplication._createEmptyConfiguration(VergilApplication.java:321)
>>
>> [run] at
>> ptolemy.actor.gui.MoMLApplication._parseArgs(MoMLApplication.java:1045)
>> [run] at
>> ptolemy.vergil.VergilApplication._parseArgs(VergilApplication.java:448)
>> [run] at
>> ptolemy.actor.gui.MoMLApplication.<init>(MoMLApplication.java:217)
>> [run] at
>> ptolemy.vergil.VergilApplication.<init>(VergilApplication.java:103)
>> [run] at
>> ptolemy.vergil.VergilApplication$1.run(VergilApplication.java:193)
>> [run] at
>> java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
>> [run] at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
>> [run] at
>> java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:269)
>>
>> [run] at
>> java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
>>
>> [run] at
>> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:184)
>> [run] at
>> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:176)
>> [run] at
>> java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
>> [run] WARN (org.kepler.moml.KARLibraryBuilderTask:run:326)
>> Unable to process kar file
>> "/Users/davidwelker/kepler.modules/common/kar/actors/actors-JobFileFetcher.kar".
>>
>> [run] org.kepler.objectmanager.cache.CacheException: Error
>> creating KARCacheObject: Unable to create prepared statements.
>> [run] at
>> org.kepler.objectmanager.cache.KARCacheObject.openKAR(KARCacheObject.java:216)
>>
>> [run] at
>> org.kepler.moml.KARLibraryBuilderTask.run(KARLibraryBuilder.java:317)
>> [run] at
>> org.kepler.moml.KARLibraryBuilder.buildLibrary(KARLibraryBuilder.java:170)
>>
>> [run] at
>> ptolemy.actor.gui.UserActorLibrary.openLibrary(UserActorLibrary.java:202)
>>
>> [run] at
>> ptolemy.actor.gui.UserActorLibrary.openUserLibrary(UserActorLibrary.java:140)
>>
>> [run] at
>> ptolemy.vergil.VergilApplication._createDefaultConfiguration(VergilApplication.java:304)
>>
>> [run] at
>> ptolemy.vergil.VergilApplication._createEmptyConfiguration(VergilApplication.java:321)
>>
>> [run] at
>> ptolemy.actor.gui.MoMLApplication._parseArgs(MoMLApplication.java:1045)
>> [run] at
>> ptolemy.vergil.VergilApplication._parseArgs(VergilApplication.java:448)
>> [run] at
>> ptolemy.actor.gui.MoMLApplication.<init>(MoMLApplication.java:217)
>> [run] at
>> ptolemy.vergil.VergilApplication.<init>(VergilApplication.java:103)
>> [run] at
>> ptolemy.vergil.VergilApplication$1.run(VergilApplication.java:193)
>> [run] at
>> java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
>> [run] at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
>> [run] at
>> java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:269)
>>
>> [run] at
>> java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
>>
>> [run] at
>> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:184)
>> [run] at
>> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:176)
>> [run] at
>> java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
>> [run] java.sql.SQLException: Column not found: TYPE in statement
>> [select name, lsid, file, expiration, type from cacheContentTable]
>> [run] at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
>> [run] at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown
>> Source)
>> [run] at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown
>> Source)
>> [run] at
>> org.kepler.objectmanager.cache.CacheManager.getCacheObjectIterator(CacheManager.java:717)
>>
>> [run] at
>> org.kepler.objectmanager.cache.CacheManager.getCacheObjectIterator(CacheManager.java:694)
>>
>> [run] at
>> org.kepler.objectmanager.library.LibraryIndex._buildNewestRevisionList(LibraryIndex.java:967)
>>
>> [run] at
>> org.kepler.objectmanager.library.LibraryIndex._buildComponentTable(LibraryIndex.java:851)
>>
>> [run] at
>> org.kepler.objectmanager.library.LibraryIndex._buildNewIndex(LibraryIndex.java:821)
>>
>> [run] at
>> org.kepler.objectmanager.library.LibraryIndex.<init>(LibraryIndex.java:113)
>>
>> [run] at
>> org.kepler.objectmanager.library.LibraryIndex.getInstance(LibraryIndex.java:248)
>>
>> [run] at
>> org.kepler.moml.KARLibraryBuilder.buildLibrary(KARLibraryBuilder.java:183)
>>
>> [run] at
>> ptolemy.actor.gui.UserActorLibrary.openLibrary(UserActorLibrary.java:202)
>>
>> [run] at
>> ptolemy.actor.gui.UserActorLibrary.openUserLibrary(UserActorLibrary.java:140)
>>
>> [run] at
>> ptolemy.vergil.VergilApplication._createDefaultConfiguration(VergilApplication.java:304)
>>
>> [run] at
>> ptolemy.vergil.VergilApplication._createEmptyConfiguration(VergilApplication.java:321)
>>
>> [run] at
>> ptolemy.actor.gui.MoMLApplication._parseArgs(MoMLApplication.java:1045)
>> [run] at
>> ptolemy.vergil.VergilApplication._parseArgs(VergilApplication.java:448)
>> [run] at
>> ptolemy.actor.gui.MoMLApplication.<init>(MoMLApplication.java:217)
>> [run] at
>> ptolemy.vergil.VergilApplication.<init>(VergilApplication.java:103)
>> [run] at
>> ptolemy.vergil.VergilApplication$1.run(VergilApplication.java:193)
>> [run] at
>> java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
>> [run] at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
>> [run] at
>> java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:269)
>>
>> [run] at
>> java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
>>
>> [run] at
>> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:184)
>> [run] at
>> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:176)
>> [run] at
>> java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
>> [run] org.kepler.objectmanager.cache.CacheException: Error
>> creating CacheObjectInterface iterator. Try removing the ~/.kepler
>> directory?: Column not found: TYPE in statement [select name, lsid,
>> file, expiration, type from cacheContentTable]
>> [run] at
>> org.kepler.objectmanager.cache.CacheManager.getCacheObjectIterator(CacheManager.java:751)
>>
>> [run] at
>> org.kepler.objectmanager.cache.CacheManager.getCacheObjectIterator(CacheManager.java:694)
>>
>> [run] at
>> org.kepler.objectmanager.library.LibraryIndex._buildNewestRevisionList(LibraryIndex.java:967)
>>
>> [run] at
>> org.kepler.objectmanager.library.LibraryIndex._buildComponentTable(LibraryIndex.java:851)
>>
>> [run] at
>> org.kepler.objectmanager.library.LibraryIndex._buildNewIndex(LibraryIndex.java:821)
>>
>> [run] at
>> org.kepler.objectmanager.library.LibraryIndex.<init>(LibraryIndex.java:113)
>>
>> [run] at
>> org.kepler.objectmanager.library.LibraryIndex.getInstance(LibraryIndex.java:248)
>>
>> [run] at
>> org.kepler.moml.KARLibraryBuilder.buildLibrary(KARLibraryBuilder.java:183)
>>
>> [run] at
>> ptolemy.actor.gui.UserActorLibrary.openLibrary(UserActorLibrary.java:202)
>>
>> [run] at
>> ptolemy.actor.gui.UserActorLibrary.openUserLibrary(UserActorLibrary.java:140)
>>
>> [run] at
>> ptolemy.vergil.VergilApplication._createDefaultConfiguration(VergilApplication.java:304)
>>
>> [run] at
>> ptolemy.vergil.VergilApplication._createEmptyConfiguration(VergilApplication.java:321)
>>
>> [run] at
>> ptolemy.actor.gui.MoMLApplication._parseArgs(MoMLApplication.java:1045)
>> [run] at
>> ptolemy.vergil.VergilApplication._parseArgs(VergilApplication.java:448)
>> [run] at
>> ptolemy.actor.gui.MoMLApplication.<init>(MoMLApplication.java:217)
>> [run] at
>> ptolemy.vergil.VergilApplication.<init>(VergilApplication.java:103)
>> [run] at
>> ptolemy.vergil.VergilApplication$1.run(VergilApplication.java:193)
>> [run] at
>> java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
>> [run] at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
>> [run] at
>> java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:269)
>>
>> [run] at
>> java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
>>
>> [run] at
>> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:184)
>> [run] at
>> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:176)
>> [run] at
>> java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
>> [run] ptolemy.kernel.util.IllegalActionException: Could not get
>> the cache iterator: Error creating CacheObjectInterface iterator. Try
>> removing the ~/.kepler directory?: Column not found: TYPE in
>> statement [select name, lsid, file, expiration, type from
>> cacheContentTable]
>> [run] at
>> org.kepler.objectmanager.library.LibraryIndex._buildNewestRevisionList(LibraryIndex.java:970)
>>
>> [run] at
>> org.kepler.objectmanager.library.LibraryIndex._buildComponentTable(LibraryIndex.java:851)
>>
>> [run] at
>> org.kepler.objectmanager.library.LibraryIndex._buildNewIndex(LibraryIndex.java:821)
>>
>> [run] at
>> org.kepler.objectmanager.library.LibraryIndex.<init>(LibraryIndex.java:113)
>>
>> [run] at
>> org.kepler.objectmanager.library.LibraryIndex.getInstance(LibraryIndex.java:248)
>>
>> [run] at
>> org.kepler.moml.KARLibraryBuilder.buildLibrary(KARLibraryBuilder.java:183)
>>
>> [run] at
>> ptolemy.actor.gui.UserActorLibrary.openLibrary(UserActorLibrary.java:202)
>>
>> [run] at
>> ptolemy.actor.gui.UserActorLibrary.openUserLibrary(UserActorLibrary.java:140)
>>
>> [run] at
>> ptolemy.vergil.VergilApplication._createDefaultConfiguration(VergilApplication.java:304)
>>
>> [run] at
>> ptolemy.vergil.VergilApplication._createEmptyConfiguration(VergilApplication.java:321)
>>
>> [run] at
>> ptolemy.actor.gui.MoMLApplication._parseArgs(MoMLApplication.java:1045)
>> [run] at
>> ptolemy.vergil.VergilApplication._parseArgs(VergilApplication.java:448)
>> [run] at
>> ptolemy.actor.gui.MoMLApplication.<init>(MoMLApplication.java:217)
>> [run] at
>> ptolemy.vergil.VergilApplication.<init>(VergilApplication.java:103)
>> [run] at
>> ptolemy.vergil.VergilApplication$1.run(VergilApplication.java:193)
>> [run] at
>> java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
>> [run] at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
>> [run] at
>> java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:269)
>>
>> [run] at
>> java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
>>
>> [run] at
>> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:184)
>> [run] at
>> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:176)
>> [run] at
>> java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
>> [run] java.sql.SQLException: Column not found: TYPE in statement
>> [select name, lsid, file, expiration, type from cacheContentTable
>> WHERE type = 'org.kepler.objectmanager.cache.WorkflowCacheObject']
>> [run] at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
>> [run] at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown
>> Source)
>> [run] at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown
>> Source)
>> [run] at
>> org.kepler.objectmanager.cache.CacheManager.getCacheObjectIterator(CacheManager.java:717)
>>
>> [run] at
>> org.kepler.gui.pane.WorkflowLibraryTabPane.initLibrary(WorkflowLibraryTabPane.java:104)
>>
>> [run] at
>> org.kepler.gui.pane.WorkflowLibraryTabPane.initializeTab(WorkflowLibraryTabPane.java:84)
>>
>> [run] at
>> org.kepler.gui.TabPaneFactory.createTabPaneTabs(TabPaneFactory.java:78)
>> [run] at
>> org.kepler.gui.TabManager.initializeTabs(TabManager.java:47)
>> [run] at
>> org.kepler.gui.KeplerGraphFrame._initBasicGraphFrame(KeplerGraphFrame.java:329)
>>
>> [run] at
>> ptolemy.vergil.basic.BasicGraphFrame.<init>(BasicGraphFrame.java:219)
>> [run] at
>> ptolemy.vergil.basic.ExtendedGraphFrame.<init>(ExtendedGraphFrame.java:95)
>>
>> [run] at
>> ptolemy.vergil.actor.ActorGraphFrame.<init>(ActorGraphFrame.java:132)
>> [run] at
>> org.kepler.gui.KeplerGraphFrame.<init>(KeplerGraphFrame.java:147)
>> [run] at
>> org.kepler.gui.frame.KeplerGraphTableau.<init>(KeplerGraphTableau.java:186)
>>
>> [run] at
>> org.kepler.gui.frame.KeplerGraphTableau$Factory.createTableau(KeplerGraphTableau.java:257)
>>
>> [run] at
>> ptolemy.actor.gui.PtolemyTableauFactory.createTableau(PtolemyTableauFactory.java:100)
>>
>> [run] at
>> ptolemy.actor.gui.TableauFactory.createTableau(TableauFactory.java:127)
>> [run] at
>> ptolemy.actor.gui.Configuration.createPrimaryTableau(Configuration.java:412)
>>
>> [run] at
>> ptolemy.vergil.VergilApplication._createEmptyConfiguration(VergilApplication.java:376)
>>
>> [run] at
>> ptolemy.actor.gui.MoMLApplication._parseArgs(MoMLApplication.java:1045)
>> [run] at
>> ptolemy.vergil.VergilApplication._parseArgs(VergilApplication.java:448)
>> [run] at
>> ptolemy.actor.gui.MoMLApplication.<init>(MoMLApplication.java:217)
>> [run] at
>> ptolemy.vergil.VergilApplication.<init>(VergilApplication.java:103)
>> [run] at
>> ptolemy.vergil.VergilApplication$1.run(VergilApplication.java:193)
>> [run] at
>> java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
>> [run] at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
>> [run] at
>> java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:269)
>>
>> [run] at
>> java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
>>
>> [run] at
>> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:184)
>> [run] at
>> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:176)
>> [run] at
>> java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
>> [run] org.kepler.objectmanager.cache.CacheException: Error
>> creating CacheObjectInterface iterator. Try removing the ~/.kepler
>> directory?: Column not found: TYPE in statement [select name, lsid,
>> file, expiration, type from cacheContentTable WHERE type =
>> 'org.kepler.objectmanager.cache.WorkflowCacheObject']
>> [run] at
>> org.kepler.objectmanager.cache.CacheManager.getCacheObjectIterator(CacheManager.java:751)
>>
>> [run] at
>> org.kepler.gui.pane.WorkflowLibraryTabPane.initLibrary(WorkflowLibraryTabPane.java:104)
>>
>> [run] at
>> org.kepler.gui.pane.WorkflowLibraryTabPane.initializeTab(WorkflowLibraryTabPane.java:84)
>>
>> [run] at
>> org.kepler.gui.TabPaneFactory.createTabPaneTabs(TabPaneFactory.java:78)
>> [run] at
>> org.kepler.gui.TabManager.initializeTabs(TabManager.java:47)
>> [run] at
>> org.kepler.gui.KeplerGraphFrame._initBasicGraphFrame(KeplerGraphFrame.java:329)
>>
>> [run] at
>> ptolemy.vergil.basic.BasicGraphFrame.<init>(BasicGraphFrame.java:219)
>> [run] at
>> ptolemy.vergil.basic.ExtendedGraphFrame.<init>(ExtendedGraphFrame.java:95)
>>
>> [run] at
>> ptolemy.vergil.actor.ActorGraphFrame.<init>(ActorGraphFrame.java:132)
>> [run] at
>> org.kepler.gui.KeplerGraphFrame.<init>(KeplerGraphFrame.java:147)
>> [run] at
>> org.kepler.gui.frame.KeplerGraphTableau.<init>(KeplerGraphTableau.java:186)
>>
>> [run] at
>> org.kepler.gui.frame.KeplerGraphTableau$Factory.createTableau(KeplerGraphTableau.java:257)
>>
>> [run] at
>> ptolemy.actor.gui.PtolemyTableauFactory.createTableau(PtolemyTableauFactory.java:100)
>>
>> [run] at
>> ptolemy.actor.gui.TableauFactory.createTableau(TableauFactory.java:127)
>> [run] at
>> ptolemy.actor.gui.Configuration.createPrimaryTableau(Configuration.java:412)
>>
>> [run] at
>> ptolemy.vergil.VergilApplication._createEmptyConfiguration(VergilApplication.java:376)
>>
>> [run] at
>> ptolemy.actor.gui.MoMLApplication._parseArgs(MoMLApplication.java:1045)
>> [run] at
>> ptolemy.vergil.VergilApplication._parseArgs(VergilApplication.java:448)
>> [run] at
>> ptolemy.actor.gui.MoMLApplication.<init>(MoMLApplication.java:217)
>> [run] at
>> ptolemy.vergil.VergilApplication.<init>(VergilApplication.java:103)
>> [run] at
>> ptolemy.vergil.VergilApplication$1.run(VergilApplication.java:193)
>> [run] at
>> java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
>> [run] at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
>> [run] at
>> java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:269)
>>
>> [run] at
>> java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
>>
>> [run] at
>> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:184)
>> [run] at
>> java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:176)
>> [run] at
>> java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
>> [run] 2009-05-13 13:29:55.910 java[675:80f] *** CPerformer:
>> ignoring exception 'Can't cache image' raised during perform of
>> selector 'getDockIconImage:' on target '<ApplicationDelegate:
>> 0x14ba20>' with args '<>'
>> [run] 2009-05-13 13:30:06.789 java[675:80f] *** CPerformer:
>> ignoring exception 'Can't cache image' raised during perform of
>> selector 'getDockIconImage:' on target '<ApplicationDelegate:
>> 0x14ba20>' with args '<>'
>> [run] error: TabPane is null. This problem can be fixed by
>> adding a tabPaneFactory property in the configuration.xml file.
>> [run] *** Attempting to get ResourceBundle for SVG defaults ***
>> [run] *** svgRenderingMethod = SVG_BATIK_RENDERING ***
>>
>>
>
> _______________________________________________
> Kepler-dev mailing list
> Kepler-dev at kepler-project.org
> http://mercury.nceas.ucsb.edu/kepler/mailman/listinfo/kepler-dev
>
More information about the Kepler-dev
mailing list