[2025-11-11 12:16:11.635] [ERROR] [main] [CommunicationsException, druid version 1.2.9, jdbcUrl : jdbc:mysql://172.25.228.4:3309?useUnicode=true&rewriteBatchedStatements=true&connectTimeout=30000&socketTimeout=1800000&allowMultiQueries=true&characterEncoding=utf8&netTimeoutForStreamingResults=28800&useSSL=false, testWhileIdle true, idle millis 1800123, minIdle 0, poolingCount 0, timeBetweenEvictionRunsMillis 10000, lastValidIdleMillis 1800123, driver com.mysql.jdbc.Driver, exceptionSorter com.oceanbase.oms.dataflow.datasource.druid.AbstractDruidDataSource$1][2025-11-11 12:16:11.638] [ERROR] [main] [notifyStopped:]com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet successfully received from the server was 1,800,101 milliseconds ago. The last packet sent successfully to the server was 1,800,100 milliseconds ago. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3562) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3462) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3905) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2011) at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:227) at com.oceanbase.oms.dataflow.jdbcclient.mysqlbased.AbstractMysqlJDBCClient.getTablesInner(AbstractMysqlJDBCClient.java:661) at com.oceanbase.oms.dataflow.jdbcclient.mysqlbased.mysql.MysqlJDBCClient.getTables(MysqlJDBCClient.java:361) at com.oceanbase.oms.dataflow.jdbcclient.mysqlbased.mysql.MysqlJDBCClient.getTables(MysqlJDBCClient.java:319) at com.oceanbase.oms.connector.source.dataflow.ConditionTableSearcher.searchTables(ConditionTableSearcher.java:25) at com.oceanbase.oms.connector.source.dataflow.DataFlowSourceBooster.getAllTables(DataFlowSourceBooster.java:367) at com.oceanbase.oms.connector.source.dataflow.DataFlowSourceBooster.initSourceEnv(DataFlowSourceBooster.java:156) at com.oceanbase.oms.connector.source.dataflow.DataFlowSourceBooster.initSourceEnv(DataFlowSourceBooster.java:124) at com.oceanbase.oms.connector.coordinator.BootStrapPanel.boot(BootStrapPanel.java:194) at com.oceanbase.oms.connector.jdbc.coordinator.Bootstrap.main(Bootstrap.java:44)Caused by: java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) at java.net.SocketInputStream.read(SocketInputStream.java:171) at java.net.SocketInputStream.read(SocketInputStream.java:141) at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:101) at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:144) at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:174) at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3011) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3472) … 17 common frames omitted[2025-11-11 12:16:11.662] [ERROR] [main] [main thread error]com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet successfully received from the server was 1,800,101 milliseconds ago. The last packet sent successfully to the server was 1,800,100 milliseconds ago. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3562) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3462) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3905) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2011) at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:227) at com.oceanbase.oms.dataflow.jdbcclient.mysqlbased.AbstractMysqlJDBCClient.getTablesInner(AbstractMysqlJDBCClient.java:661) at com.oceanbase.oms.dataflow.jdbcclient.mysqlbased.mysql.MysqlJDBCClient.getTables(MysqlJDBCClient.java:361) at com.oceanbase.oms.dataflow.jdbcclient.mysqlbased.mysql.MysqlJDBCClient.getTables(MysqlJDBCClient.java:319) at com.oceanbase.oms.connector.source.dataflow.ConditionTableSearcher.searchTables(ConditionTableSearcher.java:25) at com.oceanbase.oms.connector.source.dataflow.DataFlowSourceBooster.getAllTables(DataFlowSourceBooster.java:367) at com.oceanbase.oms.connector.source.dataflow.DataFlowSourceBooster.initSourceEnv(DataFlowSourceBooster.java:156) at com.oceanbase.oms.connector.source.dataflow.DataFlowSourceBooster.initSourceEnv(DataFlowSourceBooster.java:124) at com.oceanbase.oms.connector.coordinator.BootStrapPanel.boot(BootStrapPanel.java:194) at com.oceanbase.oms.connector.jdbc.coordinator.Bootstrap.main(Bootstrap.java:44)Caused by: java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) at java.net.SocketInputStream.read(SocketInputStream.java:171) at java.net.SocketInputStream.read(SocketInputStream.java:141) at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:101) at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:144) at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:174) at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3011) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3472) … 17 common frames omitted
麻烦截图看一致组件监控那里 组件都正常么
学到了
点恢复重试一下看看
那个我删掉了,我重复迁移了很多次,每次都是处于运行状态但未实际同步数据,一直显示不成功
{“accumulatedRunningTime”:30,“capacity”:0,“consistentQuantity”:0,“dstRps”:0,“dstRpsRef”:32000,“dstRt”:0,“dstRtRef”:1,“dstSpeed”:0,“failedTables”:0,“finishedTables”:0,“firstRoundStartingGmtTime”:1762845221,“id”:“1”,“inconsistentQuantity”:0,“message”:"",“numberOfDeletedRecords”:0,“numberOfInsertedRecords”:0,“numberOfReadRecords”:0,“numberOfUpdatedRecords”:0,“predictedTimeToFinish”:604800,“processedRecords”:0,“progress”:“NaN”,“recordProgress”:“0.000”,“reportingGmtTime”:1762845252,“rps”:0,“srcRps”:0,“srcRpsRef”:32000,“srcRt”:0,“srcRtRef”:1,“srcSpeed”:0,“srcSpeedRef”:33554432,“startingGmtTime”:1762845221,“status”:“running”,“subId”:“1”,“totalTables”:0,“type”:“migrate”}][2025-11-11 15:14:22.082] [INFO] [timerTaskScheduler] [migrate/1/heartbeat : {“accumulatedRunningTime”:40,“capacity”:0,“consistentQuantity”:0,“dstRps”:0,“dstRpsRef”:32000,“dstRt”:0,“dstRtRef”:1,“dstSpeed”:0,“failedTables”:0,“finishedTables”:0,“firstRoundStartingGmtTime”:1762845221,“id”:“1”,“inconsistentQuantity”:0,“message”:"",“numberOfDeletedRecords”:0,“numberOfInsertedRecords”:0,“numberOfReadRecords”:0,“numberOfUpdatedRecords”:0,“predictedTimeToFinish”:604800,“processedRecords”:0,“progress”:“NaN”,“recordProgress”:“0.000”,“reportingGmtTime”:1762845262,“rps”:0,“srcRps”:0,“srcRpsRef”:32000,“srcRt”:0,“srcRtRef”:1,“srcSpeed”:0,“srcSpeedRef”:33554432,“startingGmtTime”:1762845221,“status”:“running”,“subId”:“1”,“totalTables”:0,“type”:“migrate”}][2025-11-11 15:14:32.083] [INFO] [timerTaskScheduler] [migrate/1/heartbeat : {“accumulatedRunningTime”:50,“capacity”:0,“consistentQuantity”:0,“dstRps”:0,“dstRpsRef”:32000,“dstRt”:0,“dstRtRef”:1,“dstSpeed”:0,“failedTables”:0,“finishedTables”:0,“firstRoundStartingGmtTime”:1762845221,“id”:“1”,“inconsistentQuantity”:0,“message”:"",“numberOfDeletedRecords”:0,“numberOfInsertedRecords”:0,“numberOfReadRecords”:0,“numberOfUpdatedRecords”:0,“predictedTimeToFinish”:604800,“processedRecords”:0,“progress”:“NaN”,“recordProgress”:“0.000”,“reportingGmtTime”:1762845272,“rps”:0,“srcRps”:0,“srcRpsRef”:32000,“srcRt”:0,“srcRtRef”:1,“srcSpeed”:0,“srcSpeedRef”:33554432,“startingGmtTime”:1762845221,“status”:“running”,“subId”:“1”,“totalTables”:0,“type”:“migrate”}][2025-11-11 15:14:42.083] [INFO] [timerTaskScheduler] [migrate/1/heartbeat : {“accumulatedRunningTime”:60,“capacity”:0,“consistentQuantity”:0,“dstRps”:0,“dstRpsRef”:32000,“dstRt”:0,“dstRtRef”:1,“dstSpeed”:0,“failedTables”:0,“finishedTables”:0,“firstRoundStartingGmtTime”:1762845221,“id”:“1”,“inconsistentQuantity”:0,“message”:"",“numberOfDeletedRecords”:0,“numberOfInsertedRecords”:0,“numberOfReadRecords”:0,“numberOfUpdatedRecords”:0,“predictedTimeToFinish”:604800,“processedRecords”:0,“progress”:“NaN”,“recordProgress”:“0.000”,“reportingGmtTime”:1762845282,“rps”:0,“srcRps”:0,“srcRpsRef”:32000,“srcRt”:0,“srcRtRef”:1,“srcSpeed”:0,“srcSpeedRef”:33554432,“startingGmtTime”:1762845221,“status”:“running”,“subId”:“1”,“totalTables”:0,“type”:“migrate”}][2025-11-11 15:14:52.082] [INFO] [timerTaskScheduler] [migrate/1/heartbeat : {“accumulatedRunningTime”:70,“capacity”:0,“consistentQuantity”:0,“dstRps”:0,“dstRpsRef”:32000,“dstRt”:0,“dstRtRef”:1,“dstSpeed”:0,“failedTables”:0,“finishedTables”:0,“firstRoundStartingGmtTime”:1762845221,“id”:“1”,“inconsistentQuantity”:0,“message”:"",“numberOfDeletedRecords”:0,“numberOfInsertedRecords”:0,“numberOfReadRecords”:0,“numberOfUpdatedRecords”:0,“predictedTimeToFinish”:604800,“processedRecords”:0,“progress”:“NaN”,“recordProgress”:“0.000”,“reportingGmtTime”:1762845292,“rps”:0,“srcRps”:0,“srcRpsRef”:32000,“srcRt”:0,“srcRtRef”:1,“srcSpeed”:0,“srcSpeedRef”:33554432,“startingGmtTime”:1762845221,“status”:“running”,“subId”:“1”,“totalTables”:0,“type”:“migrate”}][2025-11-11 15:15:02.083] [INFO] [timerTaskScheduler] [migrate/1/heartbeat : {“accumulatedRunningTime”:80,“capacity”:0,“consistentQuantity”:0,“dstRps”:0,“dstRpsRef”:32000,“dstRt”:0,“dstRtRef”:1,“dstSpeed”:0,“failedTables”:0,“finishedTables”:0,“firstRoundStartingGmtTime”:1762845221,“id”:“1”,“inconsistentQuantity”:0,“message”:"",“numberOfDeletedRecords”:0,“numberOfInsertedRecords”:0,“numberOfReadRecords”:0,“numberOfUpdatedRecords”:0,“predictedTimeToFinish”:604800,“processedRecords”:0,“progress”:“NaN”,“recordProgress”:“0.000”,“reportingGmtTime”:1762845302,“rps”:0,“srcRps”:0,“srcRpsRef”:32000,“srcRt”:0,“srcRtRef”:1,“srcSpeed”:0,“srcSpeedRef”:33554432,“startingGmtTime”:1762845221,“status”:“running”,“subId”:“1”,“totalTables”:0,“type”:“migrate”}][2025-11-11 15:15:12.082] [INFO] [timerTaskScheduler] [migrate/1/heartbeat : {“accumulatedRunningTime”:90,“capacity”:0,“consistentQuantity”:0,“dstRps”:0,“dstRpsRef”:32000,“dstRt”:0,“dstRtRef”:1,“dstSpeed”:0,“failedTables”:0,“finishedTables”:0,“firstRoundStartingGmtTime”:1762845221,“id”:“1”,“inconsistentQuantity”:0,“message”:"",“numberOfDeletedRecords”:0,“numberOfInsertedRecords”:0,“numberOfReadRecords”:0,“numberOfUpdatedRecords”:0,“predictedTimeToFinish”:604800,“processedRecords”:0,“progress”:“NaN”,“recordProgress”:“0.000”,“reportingGmtTime”:1762845312,“rps”:0,“srcRps”:0,“srcRpsRef”:32000,“srcRt”:0,“srcRtRef”:1,“srcSpeed”:0,“srcSpeedRef”:33554432,“startingGmtTime”:1762845221,“status”:“running”,“subId”:“1”,“totalTables”:0,“type”:“migrate”}]
麻烦发一下组件的日志,oms容器内 /home/ds/run/组件id/logs
我上面那个就是组件日志
不是这个,把这个/home/ds/run/组件id/logs目录下的日志文件打包上传一下
