Solved

Db migration is failing for large tables : Cassandra to MySQL

  • 25 January 2024
  • 1 reply
  • 44 views

Userlevel 1
Badge

Hi,

I have been trying to migrate data from cassandra to mysql..The size of the source data table is approx. 4.5 GB.
The migration job ran for 11 hours and then failed with below error:

2024-01-24T22:13:40.908+0530    1    [2|Q-Id]    [SQL |Cache ] The operation timed out.
2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [SQL |Cache ] Cache failed: The operation timed out.
2024-01-24T22:13:40.955+0530    0    [2|Q-Id]    [SQL |Cache ] Replication Failed. Error:The operation timed out.
2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [RealDB:cdata.jdbc.cassandra.CassandraDriver]The connection is disconnected.
2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [RealDB:MySQL]The connection is disconnected.
2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [RealDB:Derby]The connection is disconnected.
2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [SQL |Messag] Query Failed: [REPLICATE [orderdashboard] WITH _id = 'dVliqUz79KW/pJr8i8+vNg==', ReplicateID = 'ym5RUxyrxDweS3YeOqwAow==' SELECT * FROM [hendrixstg_bkp].[orderdashboard]]. Error: The operation timed out.
2024-01-24T22:13:40.955+0530    2    [ |Q-Id]    The operation timed out.
XcoreXreplicateX230X8698.dce
    at XcoreXmysqlX230X8771.aic.a(Unknown Source)
    at XcoreXmysqlX230X8771.aic.a(Unknown Source)
    at XcoreXmysqlX230X8771.yhc.execute(Unknown Source)
    at XcoreXreplicateX230X8698.cjd.a(Unknown Source)
    at XcoreXreplicateX230X8698.cjd.a(Unknown Source)
    at XcoreXreplicateX230X8698.thd.a(Unknown Source)
    at XcoreXreplicateX230X8698.tjd.a(Unknown Source)
    at XcoreXreplicateX230X8698.tjd.a(Unknown Source)
    at XcoreXreplicateX230X8698.yid.b(Unknown Source)
    at XcoreXreplicateX230X8698.yid.a(Unknown Source)
    at XcoreXreplicateX230X8698.cjd.a(Unknown Source)
    at XcoreXreplicateX230X8698.thd.a(Unknown Source)
    at XcoreXreplicateX230X8698.zrb.H(Unknown Source)
    at XcoreXreplicateX230X8698.zrb.b(Unknown Source)
    at XcoreXreplicateX230X8698.pqb.a(Unknown Source)
    at XcoreXreplicateX230X8698.hqe.a(Unknown Source)
    at XcoreXreplicateX230X8698.oqe$f.a(Unknown Source)
    at XcoreXreplicateX230X8698.oqe$f.a(Unknown Source)
    at XcoreXreplicateX230X8698.oqe$g.a(Unknown Source)
    at XcoreXreplicateX230X8698.oqe.b(Unknown Source)
    at XcoreXreplicateX230X8698.oqe.a(Unknown Source)
    at XcoreXreplicateX230X8698.cyc.a(Unknown Source)
    at XcoreXreplicateX230X8698.cyc.a(Unknown Source)
    at XcoreXreplicateX230X8698.vib.a(Unknown Source)
    at XcoreXreplicateX230X8698.dvb.a(Unknown Source)
    at XcoreXreplicateX230X8698.had.E(Unknown Source)
    at XcoreXreplicateX230X8698.upc.b(Unknown Source)
    at XcoreXreplicateX230X8698.pqb.a(Unknown Source)
    at XcoreXreplicateX230X8698.ofc.a(Unknown Source)
    at XcoreXreplicateX230X8698.ofc.a(Unknown Source)
    at XcoreXreplicateX230X8698.ofc.executeUpdate(Unknown Source)
    at XcoreXcdata.syncX233X8700.ngb.c(Unknown Source)
    at rssbus.syncops.CallStackKeeper.executeSyncUpdate(Unknown Source)
    at XcoreXcdata.syncX233X8700.yeb.run(Unknown Source)
    at XcoreXcdata.syncX233X8700.web.a(Unknown Source)
    at XcoreXcdata.syncX233X8700.xeb.executeQueries(Unknown Source)
    at XcoreXcdata.syncX233X8700.xeb.runImpl(Unknown Source)
    at rssbus.syncops.JobExecContext.run(Unknown Source)
    at java.base/java.lang.Thread.run(Unknown Source)
2024-01-24T22:13:40.976+0530    1    [2|Q-Id]    [INFO|Connec] Closed Replicate connection



Can someone please help with this?

icon

Best answer by Alex 1 February 2024, 16:50

View original

1 reply

Userlevel 3
Badge

Hello! I’m sorry to hear about this issue you’re facing with CData Sync. In order to properly determine the cause behind a timeout error like this, logging information will likely be necessary.

Something like that would best be suited for our dedicated technical support team though. I’d highly recommend reaching out to them at support@cdata.com with additional information regarding the issue you’re experiencing.

Once they get back to you, they can share all the steps you need in order to generate some logging information that will help them resolve this issue.

Reply