I ran ‘dspace cleanup’ and noticed that quite a few records were not
cleaned out
Running with the verbose option I got the following error
(A nice improvement to the checker would be to print that error even in
non-verbose mode)
Error: ORA-02292: integrity constraint (DSPACE.SYS_C003794) violated - child
record found
after which the checker dies
(should the checker catch the exception and try to continue working on other
records?)
according to DrGoogle:
CAUSE OF ERROR
You tried to DELETE a record from a parent table (as referenced by a foreign
key<http://www.techonthenet.com/oracle/foreign_keys/foreign_keys.php>), but a
record in the child table exists.
It appears that this should never happen unless there is a database corruption
issue or maybe there is an issue in the cleanup code .. or .. or
I am including the dspace.log in the hope that somebody can shed light on this
Monika
2014-02-26 13:37:12,619 INFO
org.springframework.beans.factory.support.DefaultListableBeanFactory @
Pre-instantiating singletons in
org.springframework.beans.factory.support.DefaultListableBeanFactory@421fbfd6:
defining beans
[org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.dspace.servicemanager.spring.DSpaceBeanPostProcessor#0,org.dspace.discovery.configuration.DiscoveryConfigurationService,defaultConfiguration,searchFilterTitle,searchFilterAuthor,searchFilterSubject,searchFilterIssued,sidebarFacetAuthor,sidebarFacetSubject,sidebarFacetDateIssued,sortTitle,sortDateIssued,org.dspace.discovery.SearchService,org.dspace.services.CachingService,org.dspace.caching.ehcache.CacheManager,org.dspace.services.SessionService,org.dspace.services.EventService,claimactionAPI,reviewactionAPI,editactionAPI,finaleditactionAPI,singleuserreviewactionAPI,selectrevieweractionAPI,scorereviewactionAPI,evaluationactionAPI,autoassignactionAPI,noUserSelectionActionAPI,assignoriginalsubmitteractionAPI,reviewaction,editaction,finaleditaction,selectrevieweraction,singleuserreviewaction,scorereviewaction,evaluationaction,claimaction,autoassignAction,noUserSelectionAction,originalSubmitterAssignAction];
root of factory hierarchy
2014-02-26 13:37:12,620 INFO
org.dspace.servicemanager.spring.SpringServiceManager @ Spring Service Manager
started up in 859 ms with 43 services...
2014-02-26 13:37:12,622 INFO org.dspace.servicemanager.DSpaceKernelImpl @
DSpace kernel startup completed in 936 ms and registered as MBean:
org.dspace:name=6138c157-087b-470a-8a1c-ccea4beb09ae,type=DSpaceKernel
2014-02-26 13:37:12,658 INFO org.dspace.storage.bitstore.Cleanup @ Cleaning up
asset store
2014-02-26 13:37:14,942 INFO net.sf.ehcache.util.UpdateChecker @ New update(s)
found: 2.4.7
[http://www.terracotta.org/confluence/display/release/Release+Notes+Ehcache+Core+2.4]
2014-02-26 13:37:18,112 FATAL org.dspace.storage.bitstore.Cleanup @ Caught
exception:
java.sql.SQLException: ORA-02292: integrity constraint (DSPACE.SYS_C003794)
violated - child record found
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:421)
at
org.dspace.storage.rdbms.DatabaseManager.deleteByValue(DatabaseManager.java:572)
at org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:536)
at
org.dspace.storage.bitstore.BitstreamStorageManager.cleanup(BitstreamStorageManager.java:633)
at org.dspace.storage.bitstore.Cleanup.main(Cleanup.java:78)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:183)
2014-02-26 13:37:18,114 INFO
org.springframework.context.support.ClassPathXmlApplicationContext @ Closing
org.springframework.context.support.ClassPathXmlApplicationContext@538f1d7e:
startup date [Wed Feb 26 13:37:11 EST 2014]; root of context hierarchy
2014-02-26 13:37:18,114 INFO
org.springframework.beans.factory.support.DefaultListableBeanFactory @
Destroying singletons in
org.springframework.beans.factory.support.DefaultListableBeanFactory@421fbfd6:
defining beans
[org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.dspace.servicemanager.spring.DSpaceBeanPostProcessor#0,org.dspace.discovery.configuration.DiscoveryConfigurationService,defaultConfiguration,searchFilterTitle,searchFilterAuthor,searchFilterSubject,searchFilterIssued,sidebarFacetAuthor,sidebarFacetSubject,sidebarFacetDateIssued,sortTitle,sortDateIssued,org.dspace.discovery.SearchService,org.dspace.services.CachingService,org.dspace.caching.ehcache.CacheManager,org.dspace.services.SessionService,org.dspace.services.EventService,claimactionAPI,reviewactionAPI,editactionAPI,finaleditactionAPI,singleuserreviewactionAPI,selectrevieweractionAPI,scorereviewactionAPI,evaluationactionAPI,autoassignactionAPI,noUserSelectionActionAPI,assignoriginalsubmitteractionAPI,reviewaction,editaction,finaleditaction,selectrevieweraction,singleuserreviewaction,scorereviewaction,evaluationaction,claimaction,autoassignAction,noUserSelectionAction,originalSubmitterAssignAction];
root of factory hierarchy
2014-02-26 13:37:18,115 INFO org.dspace.services.caching.CachingServiceImpl @
destroy()
2014-02-26 13:37:18,115 INFO
org.springframework.cache.ehcache.EhCacheManagerFactoryBean @ Shutting down
EHCache CacheManager
2014-02-26 13:37:18,115 INFO
org.dspace.services.sessions.SessionRequestServiceImpl @ shutdown
2014-02-26 13:37:18,116 WARN
org.dspace.services.sessions.SessionRequestServiceImpl @ Request interceptor
(org.dspace.services.events.SystemEventService$EventRequestInterceptor@38bdc9b3)
failed to execute on end (request-272-1393439832656): null
2014-02-26 13:37:18,116 INFO
org.dspace.servicemanager.spring.SpringServiceManager @ Spring Service Manager
Shutdown...
2014-02-26 13:37:18,117 INFO org.dspace.servicemanager.DSpaceServiceManager @
Shutdown DSpace core service manager
2014-02-26 13:37:18,117 INFO org.dspace.servicemanager.DSpaceKernelImpl @
DSpace kernel shutdown completed and unregistered MBean:
org.dspace:name=6138c157-087b-470a-8a1c-ccea4beb09ae,type=DSpaceKernel
________________
Monika Mevenkamp
phone: 609-258-4161
Lewis Library,Washington Road and Ivy Lane, Princeton University, Princeton, NJ
08544
------------------------------------------------------------------------------
Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
