网站开发搭建,成都网站建设服务,c 网站开发案例详解下载,网站1g空间多大我有一个Quartz作业#xff0c;每5分钟一次在MySQL数据库中执行一个存储过程#xff0c;由于某种原因#xff0c;3个执行中有1个失败#xff0c;并提供了这个奇怪的异常。我搜索并搜索了这个异常是什么意思#xff0c;但是我找不到解决方案。这是完整的堆栈跟踪#xff1…我有一个Quartz作业每5分钟一次在MySQL数据库中执行一个存储过程由于某种原因3个执行中有1个失败并提供了这个奇怪的异常。我搜索并搜索了这个异常是什么意思但是我找不到解决方案。这是完整的堆栈跟踪java.sql.SQLException: Could not retrieve transation read-only status serverat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:951)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:941)at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3939)at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3910)at com.mysql.jdbc.PreparedStatement.checkReadOnlySafeStatement(PreparedStatement.java:1258)at com.mysql.jdbc.CallableStatement.checkReadOnlySafeStatement(CallableStatement.java:2656)at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1278)at com.mysql.jdbc.CallableStatement.execute(CallableStatement.java:920)at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:3044)at org.deadmandungeons.website.tasks.RankUpdateTask.execute(RankUpdateTask.java:30)at org.quartz.core.JobRunShell.run(JobRunShell.java:202)at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet successfully received from the server was 1,198,219 milliseconds ago. The last packet sent successfully to the server was 950,420 milliseconds ago.at sun.reflect.GeneratedConstructorAccessor43.newInstance(Unknown Source)at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)at java.lang.reflect.Constructor.newInstance(Constructor.java:526)at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1121)at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3673)at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3562)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4113)at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2812)at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2761)at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612)at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3933)... 9 moreCaused by: java.net.SocketException: Connection timed outat java.net.SocketInputStream.socketRead0(Native Method)at java.net.SocketInputStream.read(SocketInputStream.java:150)at java.net.SocketInputStream.read(SocketInputStream.java:121)at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114)at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161)at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189)at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3116)at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3573)... 17 more所以我认为这是超时的因为它认为MySQL服务器处于只读状态这只会发生在这个石英作业中而不是与数据库通信的任何其他时间。这个执行当然是在另一个线程中发生的但是我不认为这与它有任何关系。为什么会认为服务器处于只读模式此外我不认为“转换”是一个字所以有…