[Deploying Sakai] Critical problem with melete 2.6.0

Jean-Francois Leveque jean-francois.leveque at upmc.fr
Wed Nov 25 03:04:56 PST 2009


Hi,

I would like to know a way to recover from the following. This issue 
makes all melete content in the course unavailable.

Thanks

Jean-Francois Leveque
Sakai Chief Technical Officer
Universite Pierre et Marie Curie
Paris, France

2009-11-24 14:51:35,976  WARN TP-Processor20 
org.hibernate.util.JDBCExceptionReporter - SQL Error: 1062, SQLState: 23000
2009-11-24 14:51:35,976 ERROR TP-Processor20 
org.hibernate.util.JDBCExceptionReporter - Duplicate entry 
'/private/meleteDocs/fmpmcPM1_2007/uploads/evaluation-1' for key 1
2009-11-24 14:51:35,976 ERROR TP-Processor20 
org.hibernate.event.def.AbstractFlushingEventListener - Could not 
synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute 
JDBC batch update
         at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
         at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
         at 
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
         at 
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
         at 
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
         at 
org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
         at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2224)
         at 
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
         at 
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
         at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
         at 
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
         at 
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
         at 
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
         at 
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
         at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
         at 
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
         at 
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
         at 
org.etudes.component.app.melete.SectionDB.insertMeleteResource(SectionDB.java:772)
         at 
org.etudes.component.app.melete.SectionServiceImpl.insertMeleteResource(SectionServiceImpl.java:304)
         at 
org.etudes.tool.melete.AddSectionPage.saveHere(AddSectionPage.java:193)
         at 
org.etudes.tool.melete.AddSectionPage.save(AddSectionPage.java:234)
...
Caused by: java.sql.BatchUpdateException: Duplicate entry 
'/private/meleteDocs/fmpmcPM1_2007/uploads/evaluation-1' for key 1
         at 
com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1666)
         at 
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1082)
         at 
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
         at 
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
         at 
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
         ... 76 more

2009-11-24 14:51:45,748 ERROR TP-Processor12 
org.etudes.component.app.melete.SectionDB - add section HE 
exceptionorg.hibernate.ObjectNotFoundException: No row with the given 
identifier exists: 
[org.etudes.component.app.melete.MeleteResource#/private/meleteDocs/fmpmcPM1_2007/uploads/evaluation-1]




More information about the production mailing list