GitHub user Luskan777 added a comment to the discussion: DB connection is interrupted with multiple management servers
> > Hi @DaanHoogland , I updated my MariaDB version to 11.2, but I still have > > the same problem. > > From what I've researched, it seems that the connections are not being > > closed correctly in some part of the application. > > The problem starts to happen mainly when I enable HA on the agent hosts > > (KVM). However, in another Cloudstack installation where I used Mysql > > Server (without HA), this happened a few times as soon as I installed > > cloudstack-usage, but since it didn't happen very often, I ended up not > > paying attention. > > The problem doesn't seem to be on the database server (MariaDB), because > > the MariaDB database servers are healthy from what I've monitored, there is > > no excessive memory or CPU consumption. So I believe there is some > > limitation in the configuration and use of the hikaricp library. I've > > explored several configurations, but I haven't had any success with any of > > them. Can you tell me if I'm missing something? > > I tested mariadb for pr #9941 on rocky8/9, it worked fine. However the pr is > targeted to 4.19 so it does not use hikaricp, I will test with 4.20-snapshot. > > Based on your suspicion, can you change some settings in db.properties to > dbcp2, then restart management server ? > > db.cloud.connectionPoolLib db.cloud_usage.connectionPoolLib > db.simulator.connectionPoolLib > > Refer to > https://docs.cloudstack.apache.org/en/4.20.0.0/adminguide/tuning.html#selecting-database-connection-pool-library Hi @weizhouapache , thanks for your contribution. Perfect, I will test the configuration with dbcp2, I will get back to you with the result soon GitHub link: https://github.com/apache/cloudstack/discussions/10471#discussioncomment-12351628 ---- This is an automatically sent email for users@cloudstack.apache.org. To unsubscribe, please send an email to: users-unsubscr...@cloudstack.apache.org
