GitHub user weizhouapache 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 GitHub link: https://github.com/apache/cloudstack/discussions/10471#discussioncomment-12344584 ---- This is an automatically sent email for users@cloudstack.apache.org. To unsubscribe, please send an email to: users-unsubscr...@cloudstack.apache.org
