Page 2 of 2
Re: No ManagedConnections available message
PostPosted:Thu Feb 17, 2011 8:35 am
by jllort
The origin could be the MySQL restarting ... but let's try understanding more.
1- If you've system has been 7 months running the error has started happening now it's not older problem ?
2- 7 months ago MySQL restarting as doing now ... or it's something new ?
3- it happens to first user than login at morning or at the middle ? It happens to all users or only some ones ?
Re: No ManagedConnections available message
PostPosted:Thu Feb 17, 2011 4:03 pm
by pavila
Code: Select allException while dispatching incoming RPC call
This error is not related to MySQL, this is a connection error between the browser and the OpenKM server deployed in JBoss.
Re: No ManagedConnections available message
PostPosted:Wed Feb 23, 2011 9:34 pm
by ilagi
Hi jllort,
Let me answer your questions:
"The origin could be the MySQL restarting ... but let's try understanding more."
>> I agree, that was my guess too
"1- If you've system has been 7 months running the error has started happening now it's not older problem ?"
>> The error was started happning only recently, around the time when we started this discussion, when I applied the next setting: <idle-timeout-minutes>28680</idle-timeout-minutes> (see the first few comments in the topic)
"2- 7 months ago MySQL restarting as doing now ... or it's something new ?"
>> MySQL restart is happening for 7 months now.
"3- it happens to first user than login at morning or at the middle ? It happens to all users or only some ones ?"
>> It happens to all users and not only to the first one logging in.
Re: No ManagedConnections available message
PostPosted:Thu Feb 24, 2011 8:50 am
by jllort
Try with it
Code: Select all<idle-timeout-minutes>28680</idle-timeout-minutes>
<exception-sorter-class-name>com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter</exception-sorter-class-name>
<valid-connection-checker-class-name>com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker</valid-connection-checker-class-name>
if not solves try return to original configuration
Code: Select all<idle-timeout-minutes>0</idle-timeout-minutes>
I don't know how to helping you, because it's very strange error and seems something happens with this MySQL, some configuration problem ... I don't know.
Re: No ManagedConnections available message
PostPosted:Thu Feb 24, 2011 10:10 am
by pavila
You can specify the max and min connection pool size in the openkm-ds.xml file.
Code: Select all<!--pooling parameters-->
<min-pool-size>5</min-pool-size>
<max-pool-size>100</max-pool-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
Add the folloing in the openkm-ds.xml file so that it will throw exceptions if any statements or result sets left unclosed.
Code: Select all<track-statements>true</track-statements>
Re: No ManagedConnections available message
PostPosted:Fri Feb 25, 2011 3:14 pm
by ilagi
Hi jllort,
As you proposed adding the below has worked - the error message doesn't come up for the users anymore!
Code: Select all<idle-timeout-minutes>28680</idle-timeout-minutes>
<exception-sorter-class-name>com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter</exception-sorter-class-name>
<valid-connection-checker-class-name>com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker</valid-connection-checker-class-name>
Thanks!!!