Project

General

Profile

Bug #4350

Integrity constraint violation - no parent SYS_FK_59 table - during _first_ startup

Added by Michal Owsiak about 10 years ago. Updated almost 10 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
general
Target version:
Start date:
08/29/2009
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
4350

Description

During Kepler startup - from Eclipse project, following error occurs.

NOTE! This error occurs during first start-up, when there is no "~/.kepler" directory.

Scanning Local Repositories for KAR files...
java.sql.SQLException: Integrity constraint violation - no parent SYS_FK_59 table: CACHECONTENTTABLE in statement [insert into KAR_CONTENTS ( karlsid, lsid, name, type ) values ( ?, ?, ?, ? ) ]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at org.kepler.kar.KARCacheManager.insertEntriesIntoCache(KARCacheManager.java:345)
at org.kepler.kar.KARCacheManager.insertIntoCache(KARCacheManager.java:295)
at org.kepler.kar.KARCacheManager.synchronizeKARCacheWithLocalRepositories(KARCacheManager.java:149)
at org.kepler.objectmanager.library.LibraryManager.buildLibrary(LibraryManager.java:663)
at org.kepler.objectmanager.library.LibraryManager.initialize(LibraryManager.java:935)
at org.kepler.moml.KARLibraryBuilder.buildLibrary(KARLibraryBuilder.java:68)
at ptolemy.actor.gui.UserActorLibrary.openLibrary(UserActorLibrary.java:202)
at ptolemy.actor.gui.UserActorLibrary.openUserLibrary(UserActorLibrary.java:140)
at ptolemy.vergil.VergilApplication._createDefaultConfiguration(VergilApplication.java:305)
at ptolemy.vergil.VergilApplication._createEmptyConfiguration(VergilApplication.java:322)
at ptolemy.actor.gui.ConfigurationApplication._parseArgs(ConfigurationApplication.java:1109)
at ptolemy.vergil.VergilApplication._parseArgs(VergilApplication.java:452)
at ptolemy.actor.gui.ConfigurationApplication.<init>(ConfigurationApplication.java:226)
at ptolemy.actor.gui.MoMLApplication.<init>(MoMLApplication.java:81)
at ptolemy.vergil.VergilApplication.<init>(VergilApplication.java:104)
at ptolemy.vergil.VergilApplication$1.run(VergilApplication.java:194)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
java.sql.SQLException: Integrity constraint violation - no parent SYS_FK_59 table: CACHECONTENTTABLE in statement [insert into KAR_CONTENTS ( karlsid, lsid, name, type ) values ( ?, ?, ?, ? ) ]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at org.kepler.kar.KARCacheManager.insertEntriesIntoCache(KARCacheManager.java:345)
at org.kepler.kar.KARCacheManager.insertIntoCache(KARCacheManager.java:295)
at org.kepler.kar.KARCacheManager.synchronizeKARCacheWithLocalRepositories(KARCacheManager.java:149)
at org.kepler.objectmanager.library.LibraryManager.buildLibrary(LibraryManager.java:663)
at org.kepler.objectmanager.library.LibraryManager.initialize(LibraryManager.java:935)
at org.kepler.moml.KARLibraryBuilder.buildLibrary(KARLibraryBuilder.java:68)
at ptolemy.actor.gui.UserActorLibrary.openLibrary(UserActorLibrary.java:202)
at ptolemy.actor.gui.UserActorLibrary.openUserLibrary(UserActorLibrary.java:140)
at ptolemy.vergil.VergilApplication._createDefaultConfiguration(VergilApplication.java:305)
at ptolemy.vergil.VergilApplication._createEmptyConfiguration(VergilApplication.java:322)
at ptolemy.actor.gui.ConfigurationApplication._parseArgs(ConfigurationApplication.java:1109)
at ptolemy.vergil.VergilApplication._parseArgs(VergilApplication.java:452)
at ptolemy.actor.gui.ConfigurationApplication.<init>(ConfigurationApplication.java:226)
at ptolemy.actor.gui.MoMLApplication.<init>(MoMLApplication.java:81)
at ptolemy.vergil.VergilApplication.<init>(VergilApplication.java:104)
at ptolemy.vergil.VergilApplication$1.run(VergilApplication.java:194)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
java.sql.SQLException: Integrity constraint violation - no parent SYS_FK_59 table: CACHECONTENTTABLE in statement [insert into KAR_CONTENTS ( karlsid, lsid, name, type ) values ( ?, ?, ?, ? ) ]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at org.kepler.kar.KARCacheManager.insertEntriesIntoCache(KARCacheManager.java:345)
at org.kepler.kar.KARCacheManager.insertIntoCache(KARCacheManager.java:295)
at org.kepler.kar.KARCacheManager.synchronizeKARCacheWithLocalRepositories(KARCacheManager.java:149)
at org.kepler.objectmanager.library.LibraryManager.buildLibrary(LibraryManager.java:663)
at org.kepler.objectmanager.library.LibraryManager.initialize(LibraryManager.java:935)
at org.kepler.moml.KARLibraryBuilder.buildLibrary(KARLibraryBuilder.java:68)
at ptolemy.actor.gui.UserActorLibrary.openLibrary(UserActorLibrary.java:202)
at ptolemy.actor.gui.UserActorLibrary.openUserLibrary(UserActorLibrary.java:140)
at ptolemy.vergil.VergilApplication._createDefaultConfiguration(VergilApplication.java:305)
at ptolemy.vergil.VergilApplication._createEmptyConfiguration(VergilApplication.java:322)
at ptolemy.actor.gui.ConfigurationApplication._parseArgs(ConfigurationApplication.java:1109)
at ptolemy.vergil.VergilApplication._parseArgs(VergilApplication.java:452)
at ptolemy.actor.gui.ConfigurationApplication.<init>(ConfigurationApplication.java:226)
at ptolemy.actor.gui.MoMLApplication.<init>(MoMLApplication.java:81)
at ptolemy.vergil.VergilApplication.<init>(VergilApplication.java:104)
at ptolemy.vergil.VergilApplication$1.run(VergilApplication.java:194)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
java.sql.SQLException: Integrity constraint violation - no parent SYS_FK_59 table: CACHECONTENTTABLE in statement [insert into KAR_CONTENTS ( karlsid, lsid, name, type ) values ( ?, ?, ?, ? ) ]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at org.kepler.kar.KARCacheManager.insertEntriesIntoCache(KARCacheManager.java:345)
at org.kepler.kar.KARCacheManager.insertIntoCache(KARCacheManager.java:295)
at org.kepler.kar.KARCacheManager.synchronizeKARCacheWithLocalRepositories(KARCacheManager.java:149)
at org.kepler.objectmanager.library.LibraryManager.buildLibrary(LibraryManager.java:663)
at org.kepler.objectmanager.library.LibraryManager.initialize(LibraryManager.java:935)
at org.kepler.moml.KARLibraryBuilder.buildLibrary(KARLibraryBuilder.java:68)
at ptolemy.actor.gui.UserActorLibrary.openLibrary(UserActorLibrary.java:202)
at ptolemy.actor.gui.UserActorLibrary.openUserLibrary(UserActorLibrary.java:140)
at ptolemy.vergil.VergilApplication._createDefaultConfiguration(VergilApplication.java:305)
at ptolemy.vergil.VergilApplication._createEmptyConfiguration(VergilApplication.java:322)
at ptolemy.actor.gui.ConfigurationApplication._parseArgs(ConfigurationApplication.java:1109)
at ptolemy.vergil.VergilApplication._parseArgs(VergilApplication.java:452)
at ptolemy.actor.gui.ConfigurationApplication.<init>(ConfigurationApplication.java:226)
at ptolemy.actor.gui.MoMLApplication.<init>(MoMLApplication.java:81)
at ptolemy.vergil.VergilApplication.<init>(VergilApplication.java:104)
at ptolemy.vergil.VergilApplication$1.run(VergilApplication.java:194)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

History

#1 Updated by Chad Berkley almost 10 years ago

The cache directory just needs to be cleaned.

#2 Updated by Redmine Admin over 6 years ago

Original Bugzilla ID was 4350

Also available in: Atom PDF