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] dSQL |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 T2|Q-Id] 5RealDB:cdata.jdbc.cassandra.CassandraDriver]The connection is disconnected.
2024-01-24T22:13:40.955+0530 1 02|Q-Id] :RealDB:MySQL]The connection is disconnected.
2024-01-24T22:13:40.955+0530 1 d2|Q-Id] -RealDB:Derby]The connection is disconnected.
2024-01-24T22:13:40.955+0530 1 s2|Q-Id] bSQL |Messag] Query Failed: +REPLICATE �orderdashboard] WITH _id = 'dVliqUz79KW/pJr8i8+vNg==', ReplicateID = 'ym5RUxyrxDweS3YeOqwAow==' SELECT * FROM vhendrixstg_bkp].Iorderdashboard]]. Error: The operation timed out.
2024-01-24T22:13:40.955+0530 2 o |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 m2|Q-Id] SINFO|Connec] Closed Replicate connection
Can someone please help with this?
Page 1 / 1
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 [email protected] 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Data Connectors
ETL/ ELT Solutions
Cloud & API Connectivity
OEM & Custom Drivers