Can you run the SQL query manually ?
mysql> 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'\G
*************************** 1. row ***************************
instance: DEFAULT
component: ApiServer
name: proxy.header.verify
value: false
default_value: false
description: enables/disables checking of ipaddresses from a proxy set
header. See "proxy.header.names" for the headers to allow.
category: Network
is_dynamic: 1
scope: 1
updated: 2026-03-03 18:06:28
group_id: 1
subgroup_id: 1
parent: NULL
display_text: Proxy header verify
kind: NULL
options: NULL
1 row in set (0.00 sec)
-Wei
On Mon, Sep 14, 2026 at 1:38 PM Stanley Burkee <[email protected]>
wrote:
> 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
> >
>
