GBase 8s
适配迁移
问答

从mysql迁移到gbase8s，数据库宕机

Jackie Liu
发表于2025-10-10 18:27:19429次浏览14个评论

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

【GBase版本】: GBase8sV8.8_3.6.3_3X2_x86_64.tar

【操作系统】:  CentOS Linux 7

【CPU】: 32G

【问题描述】*:  迁移2个mysql到gbase8s，其他一个成功了，但是另外一个数据库迁移到20%，gbase数据库挂了。在另外一个服务器重新安装了该版本gbase，重新迁移也是同样的错误。

评论

登录后才可以发表评论
用户头像
路路路发表于 9个月前
稍等
佛洛伊得发表于 9个月前
稍等
佛洛伊得发表于 9个月前
有日志没
Jackie Liu发表于 9个月前
@佛洛伊得：tmp/online.log的日志是这样的
佛洛伊得发表于 9个月前
迁移工具不完善
GBase用户15671发表于 9个月前
@佛洛伊得：怎么看出是迁移工具的问题呢
佛洛伊得发表于 9个月前
可能有BUG
佛洛伊得发表于 9个月前
国产要走的路还很长
Jackie Liu发表于 9个月前
@佛洛伊得：我们觉得很奇怪，迁移数据失败就失败了，为啥会把自己数据库搞崩的。
GBase用户15671发表于 9个月前
麻烦提供下迁移工具版本号和迁移工具对应的日志
Jackie Liu发表于 9个月前
@GBase用户15671：迁移工具：GBase8sMTK_V2.1.8_1_WIN10_x86_64.zip
Jackie Liu发表于 9个月前
@GBase用户15671：日志都是报创建表结构失败等内容。
java.sql.SQLException: “语句”已关闭。
at com.gbasedbt.util.IfxErrMsg.getSQLException(IfxErrMsg.java:413)
at com.gbasedbt.jdbc.IfxPreparedStatement.clearBatch(IfxPreparedStatement.java:3421)
at com.gbasedbt.jdbc.IfxPreparedStatement.executeBatch(IfxPreparedStatement.java:3349)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:551)
at cn.gbase.migration.core.dataBase.dbExcutor.TargetDataBaseExecutor.executeInsertSQLWithLog(TargetDataBaseExecutor.java:122)
at cn.gbase.migration.core.dataBase.dbExcutor.GBase8sDataBaseExecutor.executeInsertSQL(GBase8sDataBaseExecutor.java:106)
at cn.gbase.migration.core.worker.impl.UserDataWriteWorker.call(UserDataWriteWorker.java:197)
at cn.gbase.migration.core.worker.impl.UserDataWriteWorker.call(UserDataWriteWorker.java:44)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2025-10-11 10:28:27,932 ERROR [ [ TaskName : vpp_sh_point_1 ] {UserDataWriteWorkerThread-[2]}] impl.UserDataWriteWorker call (UserDataWriteWorker.java:452) - 表[t_basic_point_20250519]插入数据发生错误:
Error SQLCode : [-79865]!
Error message : “语句”已关闭。

java.sql.SQLException: “语句”已关闭。
at com.gbasedbt.util.IfxErrMsg.getSQLException(IfxErrMsg.java:413)
at com.gbasedbt.jdbc.IfxPreparedStatement.clearBatch(IfxPreparedStatement.java:3421)
at com.gbasedbt.jdbc.IfxPreparedStatement.executeBatch(IfxPreparedStatement.java:3349)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:551)
at cn.gbase.migration.core.dataBase.dbExcutor.TargetDataBaseExecutor.executeInsertSQLWithLog(TargetDataBaseExecutor.java:122)
at cn.gbase.migration.core.dataBase.dbExcutor.GBase8sDataBaseExecutor.executeInsertSQL(GBase8sDataBaseExecutor.java:106)
at cn.gbase.migration.core.worker.impl.UserDataWriteWorker.call(UserDataWriteWorker.java:197)
at cn.gbase.migration.core.worker.impl.UserDataWriteWorker.call(UserDataWriteWorker.java:44)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2025-10-11 10:28:27,941 ERROR [ [ TaskName : vpp_sh_point_1 ] {UserDataWriteWorkerThread-[3]}] impl.UserDataWriteWorker call (UserDataWriteWorker.java:311) - 表[t_basic_point_20250519]写入数据发生错误
java.sql.SQLException: 系统或内部错误 java.io.IOException
at com.gbasedbt.util.IfxErrMsg.getSQLException(IfxErrMsg.java:477)
at com.gbasedbt.jdbc.IfxSqli.a(IfxSqli.java:8648)
at com.gbasedbt.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2821)
at com.gbasedbt.jdbc.IfxSqli.executePrepare(IfxSqli.java:1328)
at com.gbasedbt.jdbc.IfxPreparedStatement.f(IfxPreparedStatement.java:487)
at com.gbasedbt.jdbc.IfxPreparedStatement.a(IfxPreparedStatement.java:468)
at com.gbasedbt.jdbc.IfxPreparedStatement.(IfxPreparedStatement.java:270)
at com.gbasedbt.jdbc.IfxSqliConnect.h(IfxSqliConnect.java:6720)
at com.gbasedbt.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:2778)
at com.alibaba.druid.pool.DruidStatementConnection.prepareStatement(DruidStatementConnection.java:74)
at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:369)
at cn.gbase.migration.core.dataBase.dbExcutor.TargetDataBaseExecutor.executeInsertSQLWithLog(TargetDataBaseExecutor.java:91)
at cn.gbase.migration.core.dataBase.dbExcutor.GBase8sDataBaseExecutor.executeInsertSQL(GBase8sDataBaseExecutor.java:106)
at cn.gbase.migration.core.worker.impl.UserDataWriteWorker.call(UserDataWriteWorker.java:197)
at cn.gbase.migration.core.worker.impl.UserDataWriteWorker.call(UserDataWriteWorker.java:44)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.io.IOException
at com.gbasedbt.asf.IfxDataInputStream.readFully(IfxDataInputStream.java:138)
at com.gbasedbt.asf.IfxDataInputStream.readSmallInt(IfxDataInputStream.java:410)
at com.gbasedbt.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2795)
... 14 more
2025-10-11 10:28:27,941 ERROR [ [ TaskName : vpp_sh_point_1 ] {UserDataWriteWorkerThread-[3]}] impl.UserDataWriteWorker call (UserDataWriteWorker.java:452) - 表[t_basic_point_20250519]插入数据发生错误:
Error SQLCode : [-79716]!
Error message : 系统或内部错误 java.io.IOException

java.sql.SQLException: 系统或内部错误 java.io.IOException
at com.gbasedbt.util.IfxErrMsg.getSQLException(IfxErrMsg.java:477)
at com.gbasedbt.jdbc.IfxSqli.a(IfxSqli.java:8648)
at com.gbasedbt.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2821)
at com.gbasedbt.jdbc.IfxSqli.executePrepare(IfxSqli.java:1328)
at com.gbasedbt.jdbc.IfxPreparedStatement.f(IfxPreparedStatement.java:487)
at com.gbasedbt.jdbc.IfxPreparedStatement.a(IfxPreparedStatement.java:468)
at com.gbasedbt.jdbc.IfxPreparedStatement.(IfxPreparedStatement.java:270)
at com.gbasedbt.jdbc.IfxSqliConnect.h(IfxSqliConnect.java:6720)
at com.gbasedbt.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:2778)
at com.alibaba.druid.pool.DruidStatementConnection.prepareStatement(DruidStatementConnection.java:74)
at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:369)
at cn.gbase.migration.core.dataBase.dbExcutor.TargetDataBaseExecutor.executeInsertSQLWithLog(TargetDataBaseExecutor.java:91)
at cn.gbase.migration.core.dataBase.dbExcutor.GBase8sDataBaseExecutor.executeInsertSQL(GBase8sDataBaseExecutor.java:106)
at cn.gbase.migration.core.worker.impl.UserDataWriteWorker.call(UserDataWriteWorker.java:197)
at cn.gbase.migration.core.worker.impl.UserDataWriteWorker.call(UserDataWriteWorker.java:44)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.io.IOException
at com.gbasedbt.asf.IfxDataInputStream.readFully(IfxDataInputStream.java:138)
at com.gbasedbt.asf.IfxDataInputStream.readSmallInt(IfxDataInputStream.java:410)
at com.gbasedbt.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2795)
GBase用户15671发表于 9个月前
@Jackie Liu：建个任务把t_basic_point_20250519这个表单独迁一遍试试
用户头像
远方发表于 9个月前
你库不会创建在rootdbs的吧 吧系统表空间给使用完了

热门帖子