dhis2-users team mailing list archive

[林晓东 <lin_xd@xxxxxxx>]

develop version of dhis2, got : 


 WARN  2017-05-16 02:00:00,500 SQL Error: 0, SQLState: 23503 (SqlExceptionHelper.java [taskSchedule
r-24])
* ERROR 2017-05-16 02:00:00,513 Error: on "fileresource"  update or delete operation  on "externalfilereso
urce" 's "fk_fileresource_externalfileresource" violate constraint....


  detail：键值对(fileresourceid)=(862296)仍然是从表"externalfileresource"引用的. (SqlExceptionHelper.j
ava [taskScheduler-24])
* ERROR 2017-05-16 02:00:00,601 HHH000346: Error during managed flush [could not execute statement]
(SessionImpl.java [taskScheduler-24])
* ERROR 2017-05-16 02:00:00,621 Unexpected error occurred in scheduled task. (TaskUtils.java [taskSc
heduler-24])
org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; con
straint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not
execute statement
        at org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(Se
ssionFactoryUtils.java:241)
        at org.springframework.orm.hibernate5.HibernateTransactionManager.convertHibernateAccessExce
ption(HibernateTransactionManager.java:755)
        at org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransact
ionManager.java:590)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(
AbstractPlatformTransactionManager.java:761)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(Abstrac
tPlatformTransactionManager.java:730)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAft
erReturning(TransactionAspectSupport.java:504)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransact
ion(TransactionAspectSupport.java:292)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInte
rceptor.java:96)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvo
cation.java:179)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
        at com.sun.proxy.$Proxy154.deleteFileResource(Unknown Source)
        at org.hisp.dhis.fileresource.FileResourceCleanUpTask.lambda$run$111(FileResourceCleanUpTask
.java:64)
        at java.util.ArrayList.forEach(ArrayList.java:1249)
        at org.hisp.dhis.fileresource.FileResourceCleanUpTask.run(FileResourceCleanUpTask.java:62)
        at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErro
rHandlingRunnable.java:54)
        at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.j
ava:81)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Scheduled
ThreadPoolExecutor.java:180)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadP
oolExecutor.java:293)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
        at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDel
egate.java:112)
        at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExcepti
onConverter.java:42)
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
        at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.
java:207)
        at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.jav
a:45)
        at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.jav
a:3311)
        at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.jav
a:3548)
        at org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:98)
        at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:586)
        at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:460)
        at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlus
hingEventListener.java:337)
        at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.
java:39)
        at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295)
        at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:468)
        at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3135
)
        at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2352)
        at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCo
ordinatorImpl.java:491)
        at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoor
dinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:147)
        at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoor
dinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38)
        at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoor
dinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231
)
        at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:65)


        at org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransact
ionManager.java:582)
        ... 20 more
Caused by: org.postgresql.util.PSQLException: 错误: 在 "fileresource" 上的更新或删除操作违反了在 "ex
ternalfileresource" 上的外键约束 "fk_fileresource_externalfileresource"
  详细：键值对(fileresourceid)=(862296)仍然是从表"externalfileresource"引用的.




--

此致

easy

莫愁前路无知己，天下谁人不识君。