GBase 8s
适配迁移
问答

使用数据迁移工具从mysql迁移到gbase8s少量表迁移报错

发表于2023-07-25 10:30:07484次浏览4个评论

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。

【GBase版本】:GBase8sV8.8_3.5.0_x86_64    GBase8sMTK_V8.9_1.7.1_1_WIN10_x86_64  

【操作系统】:centos 7

【CPU】:8C

【问题描述】*:Mysql版本 5.6.42

总共660个表

报错1:个数4

[ERROR] : 读取数据发生错误:
Error message : Connect to:XXXX:6855 [/XXXX] failed: Connection refused: connect

6855端口是啥端口,其他表也是迁,为啥没有问题

报错2:个数1

[ERROR] : 读取数据发生错误:
Error message : 获取表数据总量错误。 Error SQLCode : [0]!
Error message : The last packet successfully received from the server was 28,801,544 milliseconds ago. The last packet sent successfully to the server was 28,801,603 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

报错3:个数6

[ERROR] : 获取数据结果集错误。 error message: Streaming result set com.mysql.cj.protocol.a.result.ResultsetRowsStreaming@5e6fa3eb is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.

[ERROR] : Operation not allowed after ResultSet closed

报错4:个数1

[ERROR] : Error retrieving record: Unexpected Exception: java.io.EOFException message given: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.

Nested Stack Trace:


** BEGIN NESTED EXCEPTION **

java.io.EOFException
MESSAGE: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.

STACKTRACE:

java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. 
    at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67) 
    at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) 
    at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) 
    at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) 
    at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) 
    at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) 
    at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) 
    at com.mysql.cj.protocol.a.ResultsetRowReader.read(ResultsetRowReader.java:71) 
    at com.mysql.cj.protocol.a.ResultsetRowReader.read(ResultsetRowReader.java:42) 
    at com.mysql.cj.protocol.a.NativeProtocol.read(NativeProtocol.java:1577) 
    at com.mysql.cj.protocol.a.result.ResultsetRowsStreaming.next(ResultsetRowsStreaming.java:193) 
    at com.mysql.cj.protocol.a.result.ResultsetRowsStreaming.next(ResultsetRowsStreaming.java:62) 
    at com.mysql.cj.jdbc.result.ResultSetImpl.next(ResultSetImpl.java:1738) 
    at cn.gbase.studio.migration.core.worker.impl.UserDataReadWorker$ExpDataParallelTask.call(UserDataReadWorker.java:841) 
    at cn.gbase.studio.migration.core.worker.impl.UserDataReadWorker$ExpDataParallelTask.call(UserDataReadWorker.java:807) 
    at java.util.concurrent.FutureTask.run(Unknown Source) 
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) 
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) 
    at java.lang.Thread.run(Unknown Source)


** END NESTED EXCEPTION **

 

评论

登录后才可以发表评论
用户头像
liaosnet发表于 3年前
出现错误的表重新迁移。
最佳回答
用户头像
路路路发表于 3年前
@liaosnet:头像太有新意了,让我在这擦了半天屏幕
崔哥发表于 9个月前
感谢分享
曾云林发表于 2个月前
不清楚啊。