MySQL connection closed and cause out of disk space issue

Q&A
1

Hi,

I am using BonitaBPM 7.2.3 + MYSQL 5.1.37, however I am facing an issue with database connection.

When there’s no user access BonitaBPM for a while say 8 hours, database connection with MySQL will be closed since it exceeds MySQL wait_timeout value (by default 28800 seconds), and then BonitaBPM will create a very large log file since it keep trying to access database and eventually fill up whole storage.

As a workaround, I have changed MySQL wait_timeout value to a big one (24 hours for now), but it is not good approach as there’s still possibility that no user access within 24 hours, and as it may hit mysql performance issue.

May I know is there a way to auto reconnect to mysql database when connection is going to be closed?

2

Hi,

I’m not sure to understand what you’re doing. Are you using MySql as a Bonita DB or are you connecting to a MySql DB through a process connector?

Thanks

3

Hi Palacin,

I am using MySQL as a Bonita DB.

Thanks