登录
注册
开源
企业版
高校版
搜索
帮助中心
使用条款
关于我们
开源
企业版
高校版
私有云
模力方舟
AI 队友
登录
注册
Gitee 2025 年度开源项目评选中
代码拉取完成,页面将自动刷新
开源项目
>
开发工具
>
测试工具
&&
捐赠
捐赠前请先登录
取消
前往登录
扫描微信二维码支付
取消
支付完成
支付提示
将跳转至支付宝完成支付
确定
取消
Watch
不关注
关注所有动态
仅关注版本发行动态
关注但不提醒动态
8
Star
48
Fork
24
HyBench
/
Hybench
代码
Issues
11
Pull Requests
1
Wiki
统计
流水线
服务
JavaDoc
质量分析
Jenkins for Gitee
腾讯云托管
腾讯云 Serverless
悬镜安全
阿里云 SAE
Codeblitz
SBOM
我知道了,不再自动展开
更新失败,请稍后重试!
移除标识
内容风险标识
本任务被
标识为内容中包含有代码安全 Bug 、隐私泄露等敏感信息,仓库外成员不可访问
mysql 8.0 runtp报错: java.sql.SQLException: SQL String can not be NULL
待办的
#IBCBLC
Admin
创建于
2024-12-19 11:09
最新commit节点8caa27e, 使用JDK17或者JDK1.8, 在mysql 8.0 运行runtp报错:( **倒退到这个节点可以运行成功 b8f1768** ) ``` at com.moandjiezana.toml.Toml.read(Toml.java:140) at com.moandjiezana.toml.Toml.read(Toml.java:107) at com.hybench.workload.SqlReader.loader(SqlReader.java:30) at com.hybench.HyBench.main(HyBench.java:375) 2024-12-19 11:03:58.247 [main] INFO HyBench:60 - Begin TP Workload 2024-12-19 11:03:58.258 [main] INFO Client:252 - Waiting for a while to load data 2024-12-19 11:03:58.503 [Thread-2] ERROR Client:188 - Get under_review queue failed! 2024-12-19 11:03:58.503 [Thread-1] ERROR Client:149 - Get lent queue failed! 2024-12-19 11:03:58.503 [Thread-3] ERROR Client:232 - Get accept queue failed! java.sql.SQLException: SQL String can not be NULL at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860) at com.mysql.jdbc.PreparedStatement.<init>(PreparedStatement.java:819) at com.mysql.jdbc.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:45) at com.mysql.jdbc.JDBC42PreparedStatement.<init>(JDBC42PreparedStatement.java:39) 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.PreparedStatement.getInstance(PreparedStatement.java:761) at com.mysql.jdbc.ConnectionImpl.clientPrepareStatement(ConnectionImpl.java:1471) at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4167) at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4071) at com.hybench.workload.TPClient$2.run(TPClient.java:173) java.sql.SQLException: SQL String can not be NULL at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860) at com.mysql.jdbc.PreparedStatement.<init>(PreparedStatement.java:819) at com.mysql.jdbc.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:45) at com.mysql.jdbc.JDBC42PreparedStatement.<init>(JDBC42PreparedStatement.java:39) 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.PreparedStatement.getInstance(PreparedStatement.java:761) at com.mysql.jdbc.ConnectionImpl.clientPrepareStatement(ConnectionImpl.java:1471) at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4167) at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4071) at com.hybench.workload.TPClient$3.run(TPClient.java:214) java.sql.SQLException: SQL String can not be NULL at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860) at com.mysql.jdbc.PreparedStatement.<init>(PreparedStatement.java:819) at com.mysql.jdbc.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:45) at com.mysql.jdbc.JDBC42PreparedStatement.<init>(JDBC42PreparedStatement.java:39) 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.PreparedStatement.getInstance(PreparedStatement.java:761) at com.mysql.jdbc.ConnectionImpl.clientPrepareStatement(ConnectionImpl.java:1471) at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4167) at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4071) at com.hybench.workload.TPClient$1.run(TPClient.java:131) Exception in thread "Thread-3" Exception in thread "Thread-1" java.lang.NullPointerException at com.hybench.workload.TPClient$3.run(TPClient.java:236) Exception in thread "Thread-2" java.lang.NullPointerException at com.hybench.workload.TPClient$1.run(TPClient.java:153) java.lang.NullPointerException at com.hybench.workload.TPClient$2.run(TPClient.java:192) ``` 执行步骤: ``` 生成数据: ---成功 ./hybench -t gendata -c conf/db.prop 创建表结构: ---成功 ./hybench -t sql -f conf/ddl_mysql.sql -c conf/db.prop 初始化表索引: ---成功 ./hybench -t sql -f conf/create_index_mysql.sql -c conf/db.prop 导入数据: ---成功 ./hybench -t sql -f conf/load_data_mysql.sql -c conf/db.prop 运行tp ---出错 ./hybench -t runtp -c conf/db.prop -f conf/stmt_mysql.toml ``` config信息: ``` 2024-12-19 11:03:58.201 [main] INFO ConfigLoader:57 - ===============configuration================== 2024-12-19 11:03:58.201 [main] INFO ConfigLoader:59 - password = 2024-12-19 11:03:58.201 [main] INFO ConfigLoader:59 - apRunMins = 1 2024-12-19 11:03:58.201 [main] INFO ConfigLoader:59 - xtpclient = 1 2024-12-19 11:03:58.201 [main] INFO ConfigLoader:59 - xpRunMins = 1 2024-12-19 11:03:58.202 [main] INFO ConfigLoader:59 - at5_percent = 7 2024-12-19 11:03:58.202 [main] INFO ConfigLoader:59 - at3_percent = 15 2024-12-19 11:03:58.202 [main] INFO ConfigLoader:59 - username = root 2024-12-19 11:03:58.202 [main] INFO ConfigLoader:59 - url = jdbc:mysql://<IP>:<PORT>/hybench_org?useUnicode=true&characterEncoding=utf-8&allowLoadLocalInfile=true&useSSL=false 2024-12-19 11:03:58.202 [main] INFO ConfigLoader:59 - at2_percent = 25 2024-12-19 11:03:58.202 [main] INFO ConfigLoader:59 - apround = 1 2024-12-19 11:03:58.203 [main] INFO ConfigLoader:59 - apclient = 1 2024-12-19 11:03:58.203 [main] INFO ConfigLoader:59 - xapclient = 1 2024-12-19 11:03:58.203 [main] INFO ConfigLoader:59 - at6_percent = 3 2024-12-19 11:03:58.203 [main] INFO ConfigLoader:59 - at4_percent = 15 2024-12-19 11:03:58.203 [main] INFO ConfigLoader:59 - tpRunMins = 1 2024-12-19 11:03:58.204 [main] INFO ConfigLoader:59 - at1_percent = 35 2024-12-19 11:03:58.204 [main] INFO ConfigLoader:59 - classname = com.mysql.cj.jdbc.Driver 2024-12-19 11:03:58.204 [main] INFO ConfigLoader:59 - fresh_interval = 20 2024-12-19 11:03:58.204 [main] INFO ConfigLoader:59 - tpclient = 1 2024-12-19 11:03:58.205 [main] INFO ConfigLoader:59 - db = mysql 2024-12-19 11:03:58.205 [main] INFO ConfigLoader:59 - sf = 1x 2024-12-19 11:03:58.205 [main] INFO ConfigLoader:61 - ===============configuration================== ```
最新commit节点8caa27e, 使用JDK17或者JDK1.8, 在mysql 8.0 运行runtp报错:( **倒退到这个节点可以运行成功 b8f1768** ) ``` at com.moandjiezana.toml.Toml.read(Toml.java:140) at com.moandjiezana.toml.Toml.read(Toml.java:107) at com.hybench.workload.SqlReader.loader(SqlReader.java:30) at com.hybench.HyBench.main(HyBench.java:375) 2024-12-19 11:03:58.247 [main] INFO HyBench:60 - Begin TP Workload 2024-12-19 11:03:58.258 [main] INFO Client:252 - Waiting for a while to load data 2024-12-19 11:03:58.503 [Thread-2] ERROR Client:188 - Get under_review queue failed! 2024-12-19 11:03:58.503 [Thread-1] ERROR Client:149 - Get lent queue failed! 2024-12-19 11:03:58.503 [Thread-3] ERROR Client:232 - Get accept queue failed! java.sql.SQLException: SQL String can not be NULL at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860) at com.mysql.jdbc.PreparedStatement.<init>(PreparedStatement.java:819) at com.mysql.jdbc.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:45) at com.mysql.jdbc.JDBC42PreparedStatement.<init>(JDBC42PreparedStatement.java:39) 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.PreparedStatement.getInstance(PreparedStatement.java:761) at com.mysql.jdbc.ConnectionImpl.clientPrepareStatement(ConnectionImpl.java:1471) at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4167) at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4071) at com.hybench.workload.TPClient$2.run(TPClient.java:173) java.sql.SQLException: SQL String can not be NULL at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860) at com.mysql.jdbc.PreparedStatement.<init>(PreparedStatement.java:819) at com.mysql.jdbc.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:45) at com.mysql.jdbc.JDBC42PreparedStatement.<init>(JDBC42PreparedStatement.java:39) 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.PreparedStatement.getInstance(PreparedStatement.java:761) at com.mysql.jdbc.ConnectionImpl.clientPrepareStatement(ConnectionImpl.java:1471) at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4167) at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4071) at com.hybench.workload.TPClient$3.run(TPClient.java:214) java.sql.SQLException: SQL String can not be NULL at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860) at com.mysql.jdbc.PreparedStatement.<init>(PreparedStatement.java:819) at com.mysql.jdbc.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:45) at com.mysql.jdbc.JDBC42PreparedStatement.<init>(JDBC42PreparedStatement.java:39) 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.PreparedStatement.getInstance(PreparedStatement.java:761) at com.mysql.jdbc.ConnectionImpl.clientPrepareStatement(ConnectionImpl.java:1471) at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4167) at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4071) at com.hybench.workload.TPClient$1.run(TPClient.java:131) Exception in thread "Thread-3" Exception in thread "Thread-1" java.lang.NullPointerException at com.hybench.workload.TPClient$3.run(TPClient.java:236) Exception in thread "Thread-2" java.lang.NullPointerException at com.hybench.workload.TPClient$1.run(TPClient.java:153) java.lang.NullPointerException at com.hybench.workload.TPClient$2.run(TPClient.java:192) ``` 执行步骤: ``` 生成数据: ---成功 ./hybench -t gendata -c conf/db.prop 创建表结构: ---成功 ./hybench -t sql -f conf/ddl_mysql.sql -c conf/db.prop 初始化表索引: ---成功 ./hybench -t sql -f conf/create_index_mysql.sql -c conf/db.prop 导入数据: ---成功 ./hybench -t sql -f conf/load_data_mysql.sql -c conf/db.prop 运行tp ---出错 ./hybench -t runtp -c conf/db.prop -f conf/stmt_mysql.toml ``` config信息: ``` 2024-12-19 11:03:58.201 [main] INFO ConfigLoader:57 - ===============configuration================== 2024-12-19 11:03:58.201 [main] INFO ConfigLoader:59 - password = 2024-12-19 11:03:58.201 [main] INFO ConfigLoader:59 - apRunMins = 1 2024-12-19 11:03:58.201 [main] INFO ConfigLoader:59 - xtpclient = 1 2024-12-19 11:03:58.201 [main] INFO ConfigLoader:59 - xpRunMins = 1 2024-12-19 11:03:58.202 [main] INFO ConfigLoader:59 - at5_percent = 7 2024-12-19 11:03:58.202 [main] INFO ConfigLoader:59 - at3_percent = 15 2024-12-19 11:03:58.202 [main] INFO ConfigLoader:59 - username = root 2024-12-19 11:03:58.202 [main] INFO ConfigLoader:59 - url = jdbc:mysql://<IP>:<PORT>/hybench_org?useUnicode=true&characterEncoding=utf-8&allowLoadLocalInfile=true&useSSL=false 2024-12-19 11:03:58.202 [main] INFO ConfigLoader:59 - at2_percent = 25 2024-12-19 11:03:58.202 [main] INFO ConfigLoader:59 - apround = 1 2024-12-19 11:03:58.203 [main] INFO ConfigLoader:59 - apclient = 1 2024-12-19 11:03:58.203 [main] INFO ConfigLoader:59 - xapclient = 1 2024-12-19 11:03:58.203 [main] INFO ConfigLoader:59 - at6_percent = 3 2024-12-19 11:03:58.203 [main] INFO ConfigLoader:59 - at4_percent = 15 2024-12-19 11:03:58.203 [main] INFO ConfigLoader:59 - tpRunMins = 1 2024-12-19 11:03:58.204 [main] INFO ConfigLoader:59 - at1_percent = 35 2024-12-19 11:03:58.204 [main] INFO ConfigLoader:59 - classname = com.mysql.cj.jdbc.Driver 2024-12-19 11:03:58.204 [main] INFO ConfigLoader:59 - fresh_interval = 20 2024-12-19 11:03:58.204 [main] INFO ConfigLoader:59 - tpclient = 1 2024-12-19 11:03:58.205 [main] INFO ConfigLoader:59 - db = mysql 2024-12-19 11:03:58.205 [main] INFO ConfigLoader:59 - sf = 1x 2024-12-19 11:03:58.205 [main] INFO ConfigLoader:61 - ===============configuration================== ```
评论 (
2
)
登录
后才可以发表评论
状态
待办的
待办的
进行中
已完成
已关闭
负责人
未设置
标签
未设置
标签管理
里程碑
未关联里程碑
未关联里程碑
Pull Requests
未关联
未关联
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
未关联
未关联
master
开始日期   -   截止日期
-
置顶选项
不置顶
置顶等级:高
置顶等级:中
置顶等级:低
优先级
不指定
严重
主要
次要
不重要
参与者(1)
Java
1
https://gitee.com/cstc2023/hybench.git
git@gitee.com:cstc2023/hybench.git
cstc2023
hybench
Hybench
点此查找更多帮助
搜索帮助
Git 命令在线学习
如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大,如何减小?
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release(发行版)
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部
登录提示
该操作需登录 Gitee 帐号,请先登录后再操作。
立即登录
没有帐号,去注册