View Issue Details

IDProjectCategoryView StatusLast Update
0002563SymmetricDSBugpublic2019-06-25 18:06
ReporterMikaN Assigned Tojosh-a-hicks  
Status closedResolutionfixed 
Product Version3.7.32 
Target Version3.10.3Fixed in Version3.10.3 
Summary0002563: When Primary key is binary; SymmetricDS fails capture changes.
DescriptionShould we reopen bug 0002219 ? It was marked as "fixed" but I'm getting the same error even with the latest Symmetric version.

When primary key type is varbinary Symmetrics fails with following error:

[replonv2] - AcknowledgeService - The outgoing batch 001-13 failed. There are no keys defined for Reporting-DB.dbo.booking_offers. Cannot build an update statement. The only keys defined are binary and they have been removed.
[replonv2] - PushService - There was a failure while pushing data to store:001:001. 1 data and 1 batches were processed
[replonv2] - PushService - Push data sent to store:001:001
[azure] - IncomingBatchService - Retrying batch 000-13
[azure] - DataLoaderService - Failed while parsing batch
java.lang.IllegalStateException: There are no keys defined for Reporting-DB.dbo.booking_offers. Cannot build an update statement. The only keys defined are binary and they have been removed.
    at org.jumpmind.symmetric.model.ProcessInfoDataWriter.write(
    at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener.end(
    at org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataFromTransport(
    at org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataFromPush(
    at org.jumpmind.symmetric.web.PushUriHandler.push(
    at org.jumpmind.symmetric.web.PushUriHandler.handle(
    at org.jumpmind.symmetric.web.SymmetricServlet.service(
    at javax.servlet.http.HttpServlet.service(
    at org.eclipse.jetty.servlet.ServletHolder.handle(
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(
    at org.eclipse.jetty.servlet.ServletHandler.doScope(
    at org.eclipse.jetty.server.session.SessionHandler.doScope(
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(
    at org.eclipse.jetty.server.Server.handle(
    at org.eclipse.jetty.server.HttpChannel.handle(
    at org.eclipse.jetty.server.HttpConnection.onFillable(
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(
    at org.eclipse.jetty.util.thread.QueuedThreadPool$

Additional InformationSource is MySQL 5.6.25 and that data should flow unidirectionally to SQL Azure.
Tagsdata type, dialect: mysql/mariadb


related to 0000963 closedjosh-a-hicks Update and delete does not sync on tables with varbinary primary key 



2016-04-22 05:40

reporter   ~0000786

Anyone? This issues makes SymmetricDS practically useless because after the initial sync SymmetricDS is crashing because of that error.

Related Changesets

SymmetricDS: 3.10 28fd261d

2019-05-14 16:25:02


Details Diff
0002563: When Primary key is binary; SymmetricDS fails capture changes. Affected Issues
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mysql/ Diff File

Issue History

Date Modified Username Field Change
2016-04-14 12:25 MikaN New Issue
2016-04-22 05:40 MikaN Note Added: 0000786
2019-04-24 12:39 elong Tag Attached: dialect: mysql/mariadb
2019-04-24 12:39 elong Tag Attached: data type
2019-05-14 12:32 elong Relationship added related to 0000963
2019-05-14 20:32 josh-a-hicks Assigned To => josh-a-hicks
2019-05-14 20:32 josh-a-hicks Status new => resolved
2019-05-14 20:32 josh-a-hicks Resolution open => fixed
2019-05-14 20:32 josh-a-hicks Fixed in Version => 3.10.3
2019-05-14 21:00 josh-a-hicks Changeset attached => SymmetricDS 3.10 28fd261d
2019-06-25 18:06 admin Status resolved => closed