Solved

Cassandra to MySQL Db migration is failing

  • 25 January 2024
  • 1 reply
  • 36 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 John 1 February 2024, 16:55

View original

1 reply

Userlevel 5
Badge

Thank you for reaching out with your query about database migration from Cassandra to MySQL. We noticed that you've posted this question in another thread as well. To keep our community organized and to provide the most efficient support, we've already addressed your concern in that thread.

You can find the detailed response and ongoing discussion here: DB Migration is Failing for Large Tables - Cassandra to MySQL.

We encourage you to join the conversation there! If you have any further questions or if there's anything else we can assist you with, feel free to ask. We're here to help!

Reply