数据治理

发布日期: 2018-06-22

SpagoBI/Knowage 登录首页后报错:

1 2	An error has occurred. Retry later. If the problems persists, contact the system administrator.

刷新多次可能正常登录。

跟踪日志发现错误：

Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 69,949,658 milliseconds ago.  The last packet sent successfully to the server was 69,949,659 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
        at sun.reflect.GeneratedConstructorAccessor249.newInstance(Unknown Source)
        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:377)
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1036)
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3661)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2417)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
        at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4842)
        at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:371)
        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:328)
        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:87)
        ... 43 more
Caused by: java.net.SocketException: Connection reset
        at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
        at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
        at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
        at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3643)
        ... 50 more

解决方案

修改server.xml中JNDI配置：

<Resource auth="Container" driverClassName="com.mysql.jdbc.Driver"
		maxActive="200"
		maxIdle="50"
		maxWait="-1"
		name="jdbc/knowage"
		type="javax.sql.DataSource"
		url="jdbc:mysql://a.x:3306/knowagedb" username="knowageuser" password="knowagepassword"
		logAbandoned="true"
        removeAbandoned="true"
        removeAbandonedTimeout="10"  
        validationQuery="select 1 from dual"  
        testWhileIdle="true"  
        testOnBorrow="false"  
        timeBetweenEvictionRunsMillis="30000"  
        minEvictableIdleTimeMillis="1800000"  
        numTestsPerEvictionRun="3"  
	    />