[大数据] 【致远FAQ】安装报错An error occurred while executing database script. Could not retrieve transaction r

开发: C++知识库 Java知识库 JavaScript Python PHP知识库人工智能区块链大数据移动开发嵌入式开发工具数据结构与算法开发测试游戏开发网络协议系统运维
教程: HTML教程 CSS教程 JavaScript教程 Go语言教程 JQuery教程 VUE教程 VUE3教程 Bootstrap教程 SQL数据库教程 C语言教程 C++教程 Java教程 Python教程 Python3教程 C#教程
数码: 电脑笔记本显卡显示器固态硬盘硬盘耳机手机 iphone vivo oppo 小米华为单反装机图拉丁

-> 大数据 -> 【致远FAQ】安装报错An error occurred while executing database script. Could not retrieve transaction r -> 正文阅读

[大数据]【致远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，等待时间过长连接被断开。