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