search

fil512 / stratinit

Automatically exported from code.google.com/p/stratinit
0 stars 0 forks source link

UnitSeenEvent DisableUnitSeenEventUpdate #4

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
Stratinit Update 
Exception   "org.springframework.transaction.TransactionSystemException: Could 
not commit JPA transaction; nested exception is 
javax.persistence.RollbackException: Error while commiting the transaction
    at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:465)
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at $Proxy37.disable(Unknown Source)
    at com.kenstevens.stratinit.server.remote.event.DisableUnitSeenEventUpdate.executeWrite(DisableUnitSeenEventUpdate.java:23)
    at com.kenstevens.stratinit.server.remote.event.EventUpdate.writeData(EventUpdate.java:36)
    at com.kenstevens.stratinit.server.remote.helper.SynchronizedDataAccess.write(SynchronizedDataAccess.java:27)
    at com.kenstevens.stratinit.server.remote.event.EventUpdate.update(EventUpdate.java:28)
    at com.kenstevens.stratinit.server.remote.event.StratInitUpdaterImpl.disable(StratInitUpdaterImpl.java:46)
    at com.kenstevens.stratinit.server.remote.event.UnitSeenEvent.execute(UnitSeenEvent.java:23)
    at com.kenstevens.stratinit.server.remote.event.Event$1.run(Event.java:35)
    at java.util.TimerThread.mainLoop(Timer.java:512)
    at java.util.TimerThread.run(Timer.java:462)
Caused by: javax.persistence.RollbackException: Error while commiting the 
transaction
    at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:71)
    at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:456)
    ... 18 more
Caused by: 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.engine.ActionQueue.executeActions(ActionQueue.java:266)
    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
    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.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
    ... 19 more
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into UnitSeen 
(enabled, expiry, nation_game_id, nation_player_id, unit_id) values (0, 
2010-12-23 00:16:22.034000 -0500, 43, 47, 890883) was aborted.  Call 
getNextException to see the cause.
    at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2592)
    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
    at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
    at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
    ... 27 more

Original issue reported on code.google.com by khstev...@gmail.com on 29 Dec 2010 at 8:19

GoogleCodeExporter commented 8 years ago 
Fixed in 1.1.30
Don't persist unitSeen if unit record does not exist.

Original comment by khstev...@gmail.com on 29 Jan 2011 at 10:29