Welcome to the new Gigaspaces XAP forum. To recover your account, please follow these instructions.

Ask Your Question
0

Mirror service crash

Hi all.

Yesterday, our production system crashed. I don´t know what happened but I think is something wrong with the mirror service.

A bulk operation failed because our database is using "LATIN1 encoding" and the object the system tried to save had a string with a "UTF-8 character".

The weird thing is that the mirror service since Mar 19, 2009 to Mar 25, 2009 was trying to insert the record in the database about each 2 seconds.

* GSC Log:

Mar 19, 2009 4:54:36 AM

WARNING [com.gigaspaces.core.cluster.replication]:

Replicator: replication failed due to persistency errors on target.

[ source space: AFSpaceCache_container2:AFSpaceCache ]

[ target space: mirror-service_container:mirror-service ; target space url: jini://*/mirror-service_container/mirror-service?groups=AF3GSGroup&total_members=2,1&schema=persistent&cluster_schema=partitioned-sync2backup&mirror=true&id=2&state=started&timeout=5000 ]

Replication will be disabled until the problem is resolved.

com.j_spaces.core.exception.internal.PersistentInternalSpaceException: Failed to perform bulk operations

   at com.j_spaces.sadapter.datasource.DataAdapter.bulkOperations(DataAdapter.java:1265)


   at com.j_spaces.core.cache.CacheManager.bulkOperations(CacheManager.java:5411)


   at com.j_spaces.core.JSpaceEngine.bulkOperations(JSpaceEngine.java:7926)


   at com.j_spaces.core.mirror.MirrorService.replicateAsync(MirrorService.java:78)


   at sun.reflect.GeneratedMethodAccessor174.invoke(Unknown Source)


   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)


   at java.lang.reflect.Method.invoke(Method.java:585)


   at com.gigaspaces.lrmi.LRMIRuntime.invoked(LRMIRuntime.java:381)


   at com.gigaspaces.lrmi.nio.Pivot.consumeAndHandleRequest(Pivot.java:371)


   at com.gigaspaces.lrmi.nio.Pivot.handleRequest(Pivot.java:459)


   at com.gigaspaces.lrmi.nio.Pivot$ChannelEntryTask.run(Pivot.java:149)


   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)


   at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)


   at java.util.concurrent.FutureTask.run(FutureTask.java:123)


   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)


   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)


   at java.lang.Thread.run(Thread.java:595)

Caused by: org.hibernate.exception.DataException: Could not execute JDBC batch update

   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)


   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:2229)


   at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2665)


   at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:60)


   at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)


   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)


   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.openspaces.persistency.hibernate.DefaultHibernateExternalDataSource.executeBulk(DefaultHibernateExternalDataSource.java:122)


   ... 18 more

Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into af.af_transaccion (nombre, transaccion_uuid) values (ABCDE ÇAÜDE, -8673391105542597421) was aborted. Call getNextException to see the cause.

   at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2396)


   at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1257)


   at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:334)


   at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2455)


   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeBatch(DelegatingPreparedStatement.java:231)


   at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)


   at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)


   ... 33 more

* Application log:

2009-03-25 13:46:58,057 WARN [LRMI Connection-pool-2-thread-1] [util.JDBCExceptionReporter] - SQL Error: 0, SQLState: null

2009-03-25 13:46:58,057 ERROR [LRMI Connection-pool-2-thread-1] [util.JDBCExceptionReporter] - Batch entry 0 insert into af.af_transaccion (nombre, transaccion_uuid) values (ABCDE ÇAÜDE, -8673391105542597421) was aborted. Call getNextException to see the cause.

2009-03-25 13:46:58,057 WARN [LRMI Connection-pool-2-thread-1] [util.JDBCExceptionReporter] - SQL Error: 0, SQLState: 22P05

2009-03-25 13:46:58,057 ERROR [LRMI Connection-pool-2-thread-1] [util.JDBCExceptionReporter] - ERROR: character 0xc49e of encoding "UTF8" has no equivalent in "LATIN1"

2009-03-25 13:46:58,057 ERROR [LRMI Connection-pool-2-thread-1] [def.AbstractFlushingEventListener] - Could not synchronize database state with session

org.hibernate.exception.DataException: Could not execute JDBC batch update

   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)


   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:2229)


   at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2665)


   at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:60)


   at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)


   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)


   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.openspaces.persistency.hibernate.DefaultHibernateExternalDataSource.executeBulk(DefaultHibernateExternalDataSource.java:122)


   at com.j_spaces.sadapter.datasource.DataStorage.executeBulk(DataStorage.java:415)


   at com.j_spaces.sadapter.datasource.DataAdapter.bulkOperations(DataAdapter.java:1252)


   at com.j_spaces.core.cache.CacheManager.bulkOperations(CacheManager.java:5411)


   at com.j_spaces.core.JSpaceEngine.bulkOperations(JSpaceEngine.java:7926)


   at com.j_spaces.core.mirror.MirrorService.replicateAsync(MirrorService.java:78)


   at sun.reflect.GeneratedMethodAccessor174.invoke(Unknown Source)


   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)


   at java.lang.reflect.Method.invoke(Method.java:585)


   at com.gigaspaces.lrmi.LRMIRuntime.invoked(LRMIRuntime.java:381)


   at com.gigaspaces.lrmi.nio.Pivot.consumeAndHandleRequest(Pivot.java:371)


   at com.gigaspaces.lrmi.nio.Pivot.handleRequest(Pivot.java:459)


   at com.gigaspaces.lrmi.nio.Pivot$ChannelEntryTask.run(Pivot.java:149)


   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)


   at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269 ...
(more)

asked 2009-03-26 14:34:13 -0500

nullcipher2 gravatar image

updated 2013-08-08 09:52:00 -0500

jaissefsfex gravatar image
edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

Please contact support to resolve this issue.
I recommend you to use the latest 6.6.3 build.
Shay

answered 2009-03-27 00:40:15 -0500

shay hassidim gravatar image
edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower

Stats

Asked: 2009-03-26 14:34:13 -0500

Seen: 55 times

Last updated: Mar 27 '09