【异常】java.sql.SQLException: Could not retrieve transaction read-only status from server Query
2024-09-05 03:13:49
1 详细异常
java.sql.SQLException: Could not retrieve transaction read-only status from server Query: replace into wm_offsets (`group_id`, `topic`, `partition_id`, `offset`) values(?,?,?,?) Parameters: [[ChargingOrderRealTimeStatistics, maxwell, , ], [ChargingOrderRealTimeStatistics, maxwell, , ], [ChargingOrderRealTimeStatistics, maxwell, , ]]
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:)
at org.apache.commons.dbutils.QueryRunner.batch(QueryRunner.java:)
at org.apache.commons.dbutils.QueryRunner.batch(QueryRunner.java:)
at com.*****.common.mysql.dao.OffsetManager$.saveOffset2MySQLByGroup(OffsetManager.scala:)
at com。***.spark.streaming.ChargingOrderRealTimeStatisticsEtl$$anonfun$main$.apply(ChargingOrderRealTimeStatisticsEtl.scala:)
at com.*******.spark.streaming.ChargingOrderRealTimeStatisticsEtl$$anonfun$main$.apply(ChargingOrderRealTimeStatisticsEtl.scala:)
at org.apache.spark.streaming.dstream.DStream$$anonfun$foreachRDD$$$anonfun$apply$mcV$sp$.apply(DStream.scala:)
at org.apache.spark.streaming.dstream.DStream$$anonfun$foreachRDD$$$anonfun$apply$mcV$sp$.apply(DStream.scala:)
at org.apache.spark.streaming.dstream.ForEachDStream$$anonfun$$$anonfun$apply$mcV$sp$.apply$mcV$sp(ForEachDStream.scala:)
at org.apache.spark.streaming.dstream.ForEachDStream$$anonfun$$$anonfun$apply$mcV$sp$.apply(ForEachDStream.scala:)
at org.apache.spark.streaming.dstream.ForEachDStream$$anonfun$$$anonfun$apply$mcV$sp$.apply(ForEachDStream.scala:)
at org.apache.spark.streaming.dstream.DStream.createRDDWithLocalProperties(DStream.scala:)
at org.apache.spark.streaming.dstream.ForEachDStream$$anonfun$.apply$mcV$sp(ForEachDStream.scala:)
at org.apache.spark.streaming.dstream.ForEachDStream$$anonfun$.apply(ForEachDStream.scala:)
at org.apache.spark.streaming.dstream.ForEachDStream$$anonfun$.apply(ForEachDStream.scala:)
at scala.util.Try$.apply(Try.scala:) 看报错感觉是事务问题 https://de
2 解决方案
看报错感觉是事务问题
mysql5.7推荐的驱动是8.0的
1 查询网上的说法,修改了事务级别,但是不起作用
2 根据官方mysql的推荐,更新的mysql驱动版本到8.0.7 解决问题
最新文章
- 前端学PHP之面向对象系列第五篇——对象操作
- js 中关键字 this的用法
- 【转】SVN添加文件时的错误处理:...\conf\svnserve.conf:12: Option expected
- Thinkphp学习回顾(一)之基本结构目录
- 获取Ca证书相关与服务器信息
- linux bond配置步骤,七种bond模式说明
- Codeforces Round #369 (Div. 2)---C - Coloring Trees (很妙的DP题)
- WP8.1 Study18:动态磁贴
- Java RMI简单例子HelloWorld
- GO语言中的指针
- 玩javaweb的web.xml编译路径
- java基础知识2
- Java并发编程之ConcurrentHashMap(转)
- JDBC连接错误(Illegal mix of collations。。。)
- 移动端 滑动删除 swipeDelete
- 通知:QQ互联网回调地址校验加强
- Java高级篇(四)——反射
- Java — CommonUtil
- Invalid character found in the request target.
- Cordova热更新cordova-hot-code-push
热门文章
- 【创业】2B创业历程
- C#数字除法
- [转帖]谷歌TF2.0凌晨发布!“改变一切,力压PyTorch”
- 腾讯云+阿里云 搭建hadoop + hbase
- Centos7.0配置Hadoop2.7.0伪分布式
- [DEBUG] ubuntu pip安装成功却无法import
- windows下编译libevent(2.1.8)及使用
- Python_Modbus_RTU_通讯Demo
- Go语言学习笔记(6)——指针
- java基础知识学习 内存相关