Hello All, Can anyone help me on this issue? Thank you.
Stanley On Sat, 12 Sept, 2026, 8:28 pm Stanley Burkee, <[email protected]> wrote: > Hello , > > We are upgrading cloudstack 4.20 to 4.22.1. After upgrading the management > servers 4.22, when we are starting cloudstack management service , we are > facing following error in the logs of the management servers > > 2026-09-12 00:44:06,688 ERROR [o.a.c.f.c.d.ConfigurationDaoImpl] > (qtp1404565079-22:[]) (logid:) DB Exception on: > HikariProxyPreparedStatement@601710788 wrapping > com.mysql.cj.jdbc.ServerPreparedStatement[3]: SELECT > configuration.instance, configuration.component, configuration.name, > configuration.value, configuration.default_value, > configuration.description, configuration.category, > configuration.is_dynamic, configuration.scope, configuration.updated, > configuration.group_id, configuration.subgroup_id, configuration.parent, > configuration.display_text, configuration.kind, configuration.options FROM > configuration WHERE configuration.name = > x'70726f78792e6865616465722e766572696679' java.sql.SQLDataException: Cannot > determine value type from string 'global' > > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:115) > > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98) > > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90) > > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64) > > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74) > > at > com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:96) > > at > com.mysql.cj.jdbc.result.ResultSetImpl.getObject(ResultSetImpl.java:1431) > > at com.mysql.cj.jdbc.result.ResultSetImpl.getInt(ResultSetImpl.java:830) > > at > com.zaxxer.hikari.pool.HikariProxyResultSet.getInt(HikariProxyResultSet.java) > > at com.cloud.utils.db.GenericDaoBase.setField(GenericDaoBase.java:598) > > at com.cloud.utils.db.GenericDaoBase.setField(GenericDaoBase.java:2078) > > at com.cloud.utils.db.GenericDaoBase.toEntityBean(GenericDaoBase.java:1933) > > at com.cloud.utils.db.GenericDaoBase.toEntityBean(GenericDaoBase.java:1894) > > at com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:1087) > > at com.cloud.utils.db.GenericDaoBase.lockRow(GenericDaoBase.java:1062) > > at com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:997) > > at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) > > at > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) > > at > java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > at java.base/java.lang.reflect.Method.invoke(Method.java:569) > > at > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) > > at > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) > > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) > > at > com.cloud.utils.db.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:34) > > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175) > > at > org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) > > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) > > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215) > > at jdk.proxy3/jdk.proxy3.$Proxy39.findById(Unknown Source) > > at > org.apache.cloudstack.framework.config.impl.ConfigDepotImpl.getConfigStringValueInternal(ConfigDepotImpl.java:292) > > at > com.github.benmanes.caffeine.cache.LocalLoadingCache.lambda$newMappingFunction$3(LocalLoadingCache.java:183) > > at > com.github.benmanes.caffeine.cache.BoundedLocalCache.lambda$doComputeIfAbsent$14(BoundedLocalCache.java:2687) > > at > java.base/java.util.concurrent.ConcurrentHashMap.compute(ConcurrentHashMap.java:1916) > > at > com.github.benmanes.caffeine.cache.BoundedLocalCache.doComputeIfAbsent(BoundedLocalCache.java:2685) > > at > com.github.benmanes.caffeine.cache.BoundedLocalCache.computeIfAbsent(BoundedLocalCache.java:2668) > > at > com.github.benmanes.caffeine.cache.LocalCache.computeIfAbsent(LocalCache.java:112) > > at > com.github.benmanes.caffeine.cache.LocalLoadingCache.get(LocalLoadingCache.java:58) > > at org.apache.cloudstack.utils.cache.LazyCache.get(LazyCache.java:38) > > at > org.apache.cloudstack.framework.config.impl.ConfigDepotImpl.getConfigStringValue(ConfigDepotImpl.java:305) > > at > org.apache.cloudstack.framework.config.ConfigKey.value(ConfigKey.java:390) > > at com.cloud.api.ApiServlet.doUseForwardHeaders(ApiServlet.java:686) > > at com.cloud.api.ApiServlet.getClientAddress(ApiServlet.java:695) > > at org.apache.cloudstack.ACSRequestLog.log(ACSRequestLog.java:56) > > at org.eclipse.jetty.server.HttpChannel.onCompleted(HttpChannel.java:911) > > at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:467) > > at > org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277) > > at > org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) > > at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) > > at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) > > at > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) > > at > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) > > at > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) > > at > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.produce(EatWhatYouKill.java:137) > > at > org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) > > at > org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) > > at java.base/java.lang.Thread.run(Thread.java:840) > > Caused by: com.mysql.cj.exceptions.DataConversionException: Cannot > determine value type from string 'global' > > at > com.mysql.cj.result.AbstractNumericValueFactory.createFromBytes(AbstractNumericValueFactory.java:65) > > at > com.mysql.cj.protocol.a.MysqlBinaryValueDecoder.decodeByteArray(MysqlBinaryValueDecoder.java:269) > > at > com.mysql.cj.protocol.result.AbstractResultsetRow.decodeAndCreateReturnValue(AbstractResultsetRow.java:135) > > at > com.mysql.cj.protocol.result.AbstractResultsetRow.getValueFromBytes(AbstractResultsetRow.java:243) > > at > com.mysql.cj.protocol.a.result.ByteArrayRow.getValue(ByteArrayRow.java:91) > > at > com.mysql.cj.jdbc.result.ResultSetImpl.getObject(ResultSetImpl.java:1324) > > > > I am using Cloudstack KVM 4.20 on ubuntu 22.04. Thanks in advance for the > response. > > Thank You > > Stanley >
