grais Communications link failure

最新推荐文章于 2024-02-29 09:55:34 发布

最新推荐文章于 2024-02-29 09:55:34 发布 · 253 阅读

文章标签：

#grails

grails 专栏收录该内容

9 篇文章

订阅专栏

本文记录了一次在Grails应用中遇到的MySQL连接失败问题，错误发生在尝试执行数据库查询时。具体表现为通讯链接故障，最近一次成功接收来自服务器的数据包为345,489毫秒前，最近一次成功发送数据包到服务器为1毫秒前。提供了几个参考链接以帮助解决类似问题。

WARNING: Failed to execute: select * from cl_service_set because: Communications link failure

The last packet successfully received from the server was 345,489 milliseconds ago.  The last packet sent successfully to the server was 1 milliseconds ago.
2015-11-11 18:02:06,233 [http-bio-8080-exec-5] ERROR errors.GrailsExceptionResolver  - MySQLNonTransientConnectionException occurred when processing request: [GET] /Xxxxx/xxxx/xxxx
Communications link failure during commit(). Transaction resolution unknown.. Stacktrace follows:
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during commit(). Transaction resolution unknown.
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
	at com.mysql.jdbc.Util.getInstance(Util.java:387)
	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:862)
	at com.mysql.jdbc.ConnectionImpl.commit(ConnectionImpl.java:1621)
	at grails.plugin.cache.web.filter.PageFragmentCachingFilter.doFilter(PageFragmentCachingFilter.java:198)
	at grails.plugin.cache.web.filter.AbstractFilter.doFilter(AbstractFilter.java:63)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:701)

解决办法参考：
[url]http://stackoverflow.com/questions/12532003/how-do-i-configure-c3p0-for-a-grails-2-x-application-with-multiple-datasources[/url]

[url]http://stackoverflow.com/questions/3404255/configuring-grails-to-use-own-datasource-implementation-or-to-proxy-the-standard[/url]

[url]http://stackoverflow.com/questions/11125962/correct-way-to-keep-pooled-connections-alive-or-time-them-out-and-get-fresh-one[/url]