Bug #68122 Cannot create PoolableConnectionFactory
Submitted: 19 Jan 2013 4:23 Modified: 24 Jan 2013 19:27
Reporter: pie li Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connector / J Severity:S1 (Critical)
Version:5.1.61-0ubuntu0.10.10.1 OS:Linux (Ubuntu)
Assigned to: CPU Architecture:Any

[19 Jan 2013 4:23] pie li 
Description:
I met this situation a lot ,which block the site

The exception detail is:

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 0 ms ago.)
	org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
	org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
	org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
	org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:210)
	$Proxy14.toString(Unknown Source)
	java.lang.String.valueOf(String.java:2826)

I try a lot ways , like set the wait_timeout variable, but it did not work

How to repeat:
Using Java JDBC Connection Normally, it will come up
[19 Jan 2013 4:30] MySQL Verification Team 
why do you assume this is a bug in the product?
[24 Jan 2013 19:27] Sveta Smirnova 
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

We need repeatable test case showing this is MySQL Connector/J problem and not springframework But your backtrace even does not have any point to Connector/J code. So I am closing this as "Not a Bug". Feel free to reopen report if you are able to prove this is Connector/J failure.