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 解决问题
 
 

最新文章

  1. 前端学PHP之面向对象系列第五篇——对象操作
  2. js 中关键字 this的用法
  3. 【转】SVN添加文件时的错误处理:...\conf\svnserve.conf:12: Option expected
  4. Thinkphp学习回顾(一)之基本结构目录
  5. 获取Ca证书相关与服务器信息
  6. linux bond配置步骤,七种bond模式说明
  7. Codeforces Round #369 (Div. 2)---C - Coloring Trees (很妙的DP题)
  8. WP8.1 Study18:动态磁贴
  9. Java RMI简单例子HelloWorld
  10. GO语言中的指针
  11. 玩javaweb的web.xml编译路径
  12. java基础知识2
  13. Java并发编程之ConcurrentHashMap(转)
  14. JDBC连接错误(Illegal mix of collations。。。)
  15. 移动端 滑动删除 swipeDelete
  16. 通知:QQ互联网回调地址校验加强
  17. Java高级篇(四)——反射
  18. Java — CommonUtil
  19. Invalid character found in the request target.
  20. Cordova热更新cordova-hot-code-push

热门文章

  1. 【创业】2B创业历程
  2. C#数字除法
  3. [转帖]谷歌TF2.0凌晨发布!“改变一切,力压PyTorch”
  4. 腾讯云+阿里云 搭建hadoop + hbase
  5. Centos7.0配置Hadoop2.7.0伪分布式
  6. [DEBUG] ubuntu pip安装成功却无法import
  7. windows下编译libevent(2.1.8)及使用
  8. Python_Modbus_RTU_通讯Demo
  9. Go语言学习笔记(6)——指针
  10. java基础知识学习 内存相关