Hello Wei, Thanks for your response. The output is given below for your reference
*************************** 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 kind: NULL options: NULL 1 row in set (0.00 sec) Thanks for your help in advance. Stanley On Wed, 16 Sept, 2026, 2:00 pm Stanley Burkee, <[email protected]> wrote: > 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 >> > > >> > >> >
