Hello Wei,
Apologies for the late response. I am sharing you the output of the command
you requested
*************************** 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: Global
updated: 2025-06-26 15:15:56
group_id: 1
subgroup_id: 1
parent: NULL
display_text: Proxy header verify
Thank you
Stanley
kind: NULL
options: NULL
1 row in set (0.00 sec)
On Mon, 14 Sept, 2026, 5:12 pm Wei ZHOU, <[email protected]> wrote:
> 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
> > >
> >
>
