at org.jumpmind.db.model.Table.getColumn(Table.java:230)
at org.jumpmind.symmetric.io.data.writer.DatabaseWriter.update(DatabaseWriter.
java:504)
at org.jumpmind.symmetric.io.data.writer.DefaultDatabaseWriterConflictResolver
.performFallbackToUpdate(DefaultDatabaseWriterConflictResolver.java:238)
at org.jumpmind.symmetric.io.data.writer.DefaultTransformWriterConflictResolve
r.performFallbackToUpdate(DefaultTransformWriterConflictResolver.java:69)
at org.jumpmind.symmetric.io.data.writer.DefaultDatabaseWriterConflictResolver
.needsResolved(DefaultDatabaseWriterConflictResolver.java:38)
at org.jumpmind.symmetric.io.data.writer.DatabaseWriter.write(DatabaseWriter.j
ava:156)
at org.jumpmind.symmetric.io.data.writer.TransformWriter.write(TransformWriter
.java:181)
at org.jumpmind.symmetric.io.data.DataProcessor.forEachDataInTable(DataProcess
or.java:159)
at org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProces
sor.java:131)
at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:86)
at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArr
ivalListener.end(DataLoaderService.java:647)
at org.jumpmind.symmetric.io.data.writer.StagingDataWriter.notifyEndBatch(Stag
ingDataWriter.java:43)
at org.jumpmind.symmetric.io.data.writer.AbstractProtocolDataWriter.end(Abstra
ctProtocolDataWriter.java:155)
at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:92)
at org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataFromTransport
(DataLoaderService.java:316)
at org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataFromPush(Data
LoaderService.java:242)
at org.jumpmind.symmetric.web.PushUriHandler.push(PushUriHandler.java:79)
at org.jumpmind.symmetric.web.PushUriHandler.handle(PushUriHandler.java:66)
at
org.jumpmind.symmetric.web.SymmetricServlet.service(SymmetricServlet.java:82)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:565)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:479)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:524)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.jav
a:227)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.jav
a:1031)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java
:186)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java
:965)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:
111)
at org.eclipse.jetty.server.Server.handle(Server.java:348)
at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpC
onnection.java:452)
at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnect
ion.java:894)
at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(Abst
ractHttpConnection.java:948)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:851)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.jav
a:77)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint
.java:606)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.
java:46)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java
:603)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:
538)
at java.lang.Thread.run(Unknown Source)
2012-06-09 22:52:45,311 ERROR Received an error from node 00000 for batch 7.
Check the outgoing_batch table for more info.
2012-06-09 22:52:45,311 INFO Pushed data to corp:00000:00000. 1 data and 1
batches were processed
2012-06-09 22:52:45,826 INFO Push data sent to corp:00000:00000
Hello,
I am testing SymmetricDS 3.0.1 with Firebird database 2.5.1 and Java 1.7 on
Windows 7.
After inserting a few records, it started showing the following errors:
2012-06-09 22:46:52,898 INFO Creating SYM_ON_I_FOR_CR_RLSTN_FRM_CLNT trigger
for cr_realisation
2012-06-09 22:46:52,945 INFO Creating SYM_ON_U_FOR_CR_RLSTN_FRM_CLNT trigger
for cr_realisation
2012-06-09 22:46:52,992 INFO Creating SYM_ON_D_FOR_CR_RLSTN_FRM_CLNT trigger
for cr_realisation
2012-06-09 22:46:54,037 INFO Done synchronizing triggers
2012-06-09 22:46:54,068 INFO Pull data received from corp:00000:00000. 159
rows and 2 batches were processed
2012-06-09 22:48:19,476 INFO Routed 2 data events in 307 ms
2012-06-09 22:48:23,860 INFO Push data sent to corp:00000:00000
2012-06-09 22:48:24,359 INFO Pushed data to corp:00000:00000. 2 data and 1
batches were processed
2012-06-09 22:48:33,329 INFO Routed 2 data events in 281 ms
2012-06-09 22:49:09,711 INFO Routed 1 data events in 234 ms
2012-06-09 22:49:14,157 INFO Push data sent to corp:00000:00000
2012-06-09 22:49:14,204 INFO Pushed data to corp:00000:00000. 1 data and 1
batches were processed
2012-06-09 22:49:14,313 INFO Routed 1 data events in 249 ms
2012-06-09 22:50:08,770 INFO Routed 2 data events in 218 ms
2012-06-09 22:50:09,600 INFO Push data sent to corp:00000:00000
2012-06-09 22:50:09,662 INFO Pushed data to corp:00000:00000. 2 data and 1
batches were processed
2012-06-09 22:50:15,980 INFO Routed 2 data events in 281 ms
2012-06-09 22:52:35,546 INFO Routed 1 data events in 265 ms
2012-06-09 22:52:35,796 INFO Push data sent to corp:00000:00000
2012-06-09 22:52:45,249 ERROR Failed to load batch 1-7 because: Index: 6,
Size: 6
2012-06-09 22:52:45,280 ERROR Failed while parsing batch
java.lang.IndexOutOfBoundsException: Index: 6, Size: 6
at java.util.ArrayList.rangeCheck(Unknown Source)
at java.util.ArrayList.get(Unknown Source)
at org.jumpmind.db.model.Table.getColumn(Table.java:230)
at org.jumpmind.symmetric.io.data.writer.DatabaseWriter.update(DatabaseWriter.
java:504)
at org.jumpmind.symmetric.io.data.writer.DefaultDatabaseWriterConflictResolver
.performFallbackToUpdate(DefaultDatabaseWriterConflictResolver.java:238)
at org.jumpmind.symmetric.io.data.writer.DefaultTransformWriterConflictResolve
r.performFallbackToUpdate(DefaultTransformWriterConflictResolver.java:69)
at org.jumpmind.symmetric.io.data.writer.DefaultDatabaseWriterConflictResolver
.needsResolved(DefaultDatabaseWriterConflictResolver.java:38)
at org.jumpmind.symmetric.io.data.writer.DatabaseWriter.write(DatabaseWriter.j
ava:156)
at org.jumpmind.symmetric.io.data.writer.TransformWriter.write(TransformWriter
.java:181)
at org.jumpmind.symmetric.io.data.DataProcessor.forEachDataInTable(DataProcess
or.java:159)
at org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProces
sor.java:131)
at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:86)
at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArr
ivalListener.end(DataLoaderService.java:647)
at org.jumpmind.symmetric.io.data.writer.StagingDataWriter.notifyEndBatch(Stag
ingDataWriter.java:43)
at org.jumpmind.symmetric.io.data.writer.AbstractProtocolDataWriter.end(Abstra
ctProtocolDataWriter.java:155)
at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:92)
at org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataFromTransport
(DataLoaderService.java:316)
at org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataFromPush(Data
LoaderService.java:242)
at org.jumpmind.symmetric.web.PushUriHandler.push(PushUriHandler.java:79)
at org.jumpmind.symmetric.web.PushUriHandler.handle(PushUriHandler.java:66)
at
org.jumpmind.symmetric.web.SymmetricServlet.service(SymmetricServlet.java:82)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:565)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:479)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:524)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.jav
a:227)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.jav
a:1031)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java
:186)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java
:965)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:
111)
at org.eclipse.jetty.server.Server.handle(Server.java:348)
at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpC
onnection.java:452)
at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnect
ion.java:894)
at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(Abst
ractHttpConnection.java:948)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:851)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.jav
a:77)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint
.java:606)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.
java:46)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java
:603)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:
538)
at java.lang.Thread.run(Unknown Source)
2012-06-09 22:52:45,311 ERROR Received an error from node 00000 for batch 7.
Check the outgoing_batch table for more info.
2012-06-09 22:52:45,311 INFO Pushed data to corp:00000:00000. 1 data and 1
batches were processed
2012-06-09 22:52:45,826 INFO Push data sent to corp:00000:00000
2012-06-09 22:52:45,857 WARN Retrying batch 1-7
2012-06-09 22:52:45,888 ERROR Failed to load batch 1-7 because: Index: 6,
Size: 6
2012-06-09 22:52:46,060 ERROR Failed while parsing batch
java.lang.IndexOutOfBoundsException: Index: 6, Size: 6
at java.util.ArrayList.rangeCheck(Unknown Source)
at java.util.ArrayList.get(Unknown Source)
at org.jumpmind.db.model.Table.getColumn(Table.java:230)
Thank you.
Vishal Sudheer
Vishal,
Is there a chance you have a data transformation configured for the tables
involved in this batch?
Mark.
This will be fixed in 3.0.3. It is an issue with falling back from an insert
to an update.