【致远FAQ】安装报错An error occurred while executing database script. Could not retrieve transaction r_致远剑客的博客

问题如图

问题分析

检查安装日志文件all.log，err.log发现异常信息：

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'xietong'@'10.10.10.4' to database 'mysql'

java.sql.SQLException: Could not retrieve transaction read-only status from server

Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 321,381 milliseconds ago.  The last packet sent successfully to the server was 3 milliseconds ago.

Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.

at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3014)

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3472)

... 22 more

SHUTDOWN REQUESTED

存在权限问题以及连接丢失，当前用户无法访问mysql自带的系统库，客户使用的云rds，进入云数据库后台控制端检查，发现对应的wait_timeout设置的120s，等待时间过长连接被断开。

 问题解决

1)使用客户提供的高权限账户连接
2)浏览器登录云数据库管理后台把timeout调整为28800（8小时），再安装OA正常