线上操作Mysql持久化异常：Communications link failure during rollback(). Transaction resolution unknown.

问题： 线上操作Mysql持久化异常：Communications link failure during rollback(). Transaction resolution unknown.

如下：

20/09/22 08:51:31 ERROR jdbc.SpartaJdbcUtils$: Save partition with errors
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during rollback(). Transaction resolution unknown.
  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.Util.getInstance(Util.java:408)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
  at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:4541)
  at org.apache.spark.sql.jdbc.SpartaJdbcUtils$.org$apache$spark$sql$jdbc$SpartaJdbcUtils$$savePartition(SpartaJdbcUtils.scala:422)
  at org.apache.spark.sql.jdbc.SpartaJdbcUtils$$anonfun$saveTable$1$$anonfun$4.apply$mcV$sp(SpartaJdbcUtils.scala:143)
  at org.apache.spark.sql.jdbc.SpartaJdbcUtils$$anonfun$saveTable$1$$anonfun$4.apply(SpartaJdbcUtils.scala:143)
  at org.apache.spark.sql.jdbc.SpartaJdbcUtils$$anonfun$saveTable$1$$anonfun$4.apply(SpartaJdbcUtils.scala:143)
  at scala.util.Try$.apply(Try.scala:192)
  at org.apache.spark.sql.jdbc.SpartaJdbcUtils$$anonfun$saveTable$1.apply(SpartaJdbcUtils.scala:143)
  at org.apache.spark.sql.jdbc.SpartaJdbcUtils$$anonfun$saveTable$1.apply(SpartaJdbcUtils.scala:142)
  at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:935)
  at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:935)
  at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:2074)
  at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:2074)
  at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:87)
  at org.apache.spark.scheduler.Task.run(Task.scala:109)
  at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:381)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  at java.lang.Thread.run(Thread.java:748)

原因：

1. 这边大佬眼飘说是网络问题，但是其他同库持久化又是正常，这似乎说不过去；估计是没时间看吧.......

2. 查看工具类代码，确认是只使用connection没有关闭直接就sumbit()，这应该是主要因素;

3. 网上查看到的原因是 .........使用创建的SqlSession，在使用完mybatis后，没有关闭

解决：

sqlSession.close();

具体因素，大家可以认真审阅自己的工具类，多伴是工具类的问题，编写不严谨；