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?
Best answer by John
View original