No ManagedConnections available message

[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 ?

[pavila]

Code: Select all

Exception 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.

[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.

[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.

[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>

[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!!!