Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Message-ID: <4A366456.70205@intland.com>
Date: Mon, 15 Jun 2009 17:10:14 +0200
From: Zsolt Koppany <zkoppanylist@intland.com>
User-Agent: Thunderbird 2.0.0.21 (X11/20090409)
MIME-Version: 1.0
To: user-java@ibatis.apache.org
Subject: Re: Does ping really work?
References: <4A3616ED.20103@intland.com>
 <a10a823c0906150418u6016fb55if22685b4c8936461@mail.gmail.com>
In-Reply-To: <a10a823c0906150418u6016fb55if22685b4c8936461@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Thank you Larry,

I also found that at startup we get a connection from the pool that is 
not closed. But as far as I understand "Pool.MaximumCheckoutTime" should 
guarantee that a connection cannot be used longer that 20 seconds (in 
our case).

Do I miss something?

Zsolt

Larry Meadors wrote:
> Google is your friend:
> 
> http://forums.mysql.com/read.php?39,199085,204628#msg-204628
> 
> Larry
> 
> On Mon, Jun 15, 2009 at 3:39 AM, Zsolt Koppany<zkoppanylist@intland.com> wrote:
>> Hi,
>>
>> I get an exception attached at the end. Here are the ibatis pool properties:
>>
>> Pool.MaximumActiveConnections=20
>> Pool.MaximumIdleConnections=5
>> Pool.MaximumCheckoutTime=20000
>> Pool.TimeToWait=20000
>> Pool.PingEnabled=true
>> Pool.PingQuery=SELECT 1 FROM always_one_row
>> Pool.PingConnectionsOlderThan=0
>> Pool.PingConnectionsNotUsedFor=5000
>>
>> How is it possible getting this exception? "Pool.PingConnectionsNotUsedFor"
>> is set to 5 seconds and mysql complains that last packet was sent 758278
>> seconds ago. As far as I understand for connections older than 5 seconds the
>> ping command should be executed and if not successful a new connection
>> created.
>>
>> I use ibatis-2.3.4.726. Does anybody have an idea?
>>
>> Zsolt
>>
>> 2009-06-14 14:31:19,167 ERROR dao.impl.ProjectDaoImpl     - iBATIS exception
>> [TP-Processor489]
>> com.ibatis.common.jdbc.exception.NestedSQLException:
>> --- The error occurred while applying a parameter map.
>> --- Check the findProject-InlineParameterMap.
>> --- Check the statement (query failed).
>> --- Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last
>> packet successfully received from the server was758278 seconds ago.The last
>> packet sent successfully to the server was 758278 seconds ago, which  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
>> com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)
>>        at
>> com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)
>>        at
>> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567)
>>        at
>> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:126)
>>        at
>> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:102)
>>        at
>> com.intland.codebeamer.persistence.util.SqlMapClientWrapper.queryForList(SqlMapClientWrapper.java:345)
>>
>>
>