can you also check user_vm_details for the VMs running on the host ?
-Wei On Sat, Jun 28, 2025 at 10:04 AM Levin Ng <levindec...@gmail.com> wrote: > Hi Wei, > > Thanks again, from the problematic cluster_id 7, it just contains one > cpuOvercommitRatio row, any idea? > > Regads, > Levin > > MariaDB [cloud]> select * from cluster_details; > +----+------------+-----------------------+-------+ > | id | cluster_id | name | value | > +----+------------+-----------------------+-------+ > | 1 | 1 | memoryOvercommitRatio | 1.0 | > | 2 | 1 | cpuOvercommitRatio | 1.0 | > | 3 | 2 | memoryOvercommitRatio | 1.0 | > | 4 | 2 | cpuOvercommitRatio | 1.0 | > | 5 | 3 | memoryOvercommitRatio | 1.0 | > | 6 | 3 | cpuOvercommitRatio | 1.0 | > | 7 | 4 | memoryOvercommitRatio | 1.0 | > | 8 | 4 | cpuOvercommitRatio | 1.0 | > | 9 | 5 | memoryOvercommitRatio | 1.0 | > | 10 | 5 | cpuOvercommitRatio | 1.0 | > | 11 | 6 | memoryOvercommitRatio | 1.0 | > | 12 | 6 | cpuOvercommitRatio | 1.0 | > | 13 | 7 | memoryOvercommitRatio | 1.0 | > | 14 | 7 | cpuOvercommitRatio | 12 | > | 15 | 7 | resourceHAEnabled | false | > | 16 | 8 | memoryOvercommitRatio | 1.3 | > | 17 | 8 | cpuOvercommitRatio | 15.0 | > | 18 | 9 | memoryOvercommitRatio | 1.3 | > | 19 | 9 | cpuOvercommitRatio | 15.0 | > | 20 | 10 | memoryOvercommitRatio | 1.3 | > | 21 | 10 | cpuOvercommitRatio | 15.0 | > | 22 | 11 | memoryOvercommitRatio | 1.0 | > | 23 | 11 | cpuOvercommitRatio | 12.0 | > +----+------------+-----------------------+-------+ > 23 rows in set (0.001 sec) > > MariaDB [cloud]> desc cluster_details; > > +------------+---------------------+------+-----+---------+----------------+ > | Field | Type | Null | Key | Default | Extra | > > +------------+---------------------+------+-----+---------+----------------+ > | id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | > | cluster_id | bigint(20) unsigned | NO | MUL | NULL | | > | name | varchar(255) | NO | MUL | NULL | | > | value | varchar(255) | NO | | NULL | | > > +------------+---------------------+------+-----+---------+----------------+ > 4 rows in set (0.005 sec) > > On 28 Jun 2025 at 15:54 +0800, Wei ZHOU <ustcweiz...@gmail.com>, wrote: > > Hi, > > > > Maybe check cluster_details if there are multiple records with the same > > name "cpuOvercommitRatio" for a cluster. > > > > > > -Wei > > > > On Sat, Jun 28, 2025 at 9:37 AM Levin Ng <levindec...@gmail.com> wrote: > > > > > Hi, > > > > > > I’m having trouble after 4.20.1 upgrade, some of the existing host are > not > > > able to reconnect ACS management and found some sql error in the log, > > > anyone have idea how to resolve it?, thank you very much. > > > > > > 2025-06-28 15:30:49,259 ERROR [c.c.a.m.ClusteredAgentManagerImpl] > > > (AgentConnectTaskPool-1092:[ctx-99bfb3dd]) (logid:b354f521) Monitor > > > ComputeCapacityListener says there is an error in the connect process > for > > > 110 due to Duplicate key cpuOvercommitRatio (attempted merging values > 12 > > > and 12) java.lang.IllegalStateException: Duplicate key > cpuOvercommitRatio > > > (attempted merging values 12 and 12) > > > > > > > > > Regards, > > > Levin > > > >
