sureshanaparti commented on issue #11426:
URL: https://github.com/apache/cloudstack/issues/11426#issuecomment-3173612188
Noticed this exception in logs while generating root CA public/private keys,
so these configs are null.
```
2025-08-11 06:02:22,607 DEBUG [o.a.c.f.c.i.ConfigDepotImpl] (main:[])
(logid:) Retrieving keys from RootCAProvider
2025-08-11 06:02:22,691 DEBUG [o.a.c.s.l.r.ExtensionRegistry] (main:[])
(logid:) Registering extension [RootCAProvider] in [Ca Providers Registry]
2025-08-11 06:02:22,691 DEBUG [o.a.c.s.l.r.RegistryLifecycle] (main:[])
(logid:) Registered org.apache.cloudstack.ca.provider.RootCAProvider@22be4867
2025-08-11 06:02:22,691 INFO [o.a.c.s.l.CloudStackExtendedLifeCycle]
(main:[]) (logid:) Configuring CloudStack Components
2025-08-11 06:02:22,691 INFO [o.a.c.s.l.CloudStackExtendedLifeCycle]
(main:[]) (logid:) configuring bean RootCAProvider.
2025-08-11 06:02:22,696 ERROR [o.a.c.f.c.d.ConfigurationDaoImpl] (main:[])
(logid:) DB Exception on: HikariProxyPreparedStatement@224702128 wrapping
com.mysql.cj.jdbc.ServerPreparedStatement[782]: 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'63612e706c7567696e2e726f6f742e7075626c69632e6b6579'
java.sql.SQLDataException: Cannot determine value type from string
'^A^@^@^@^@^@^@^@'
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:597)
at
com.cloud.utils.db.GenericDaoBase.setField(GenericDaoBase.java:2070)
at
com.cloud.utils.db.GenericDaoBase.toEntityBean(GenericDaoBase.java:1930)
at
com.cloud.utils.db.GenericDaoBase.toEntityBean(GenericDaoBase.java:1891)
at
com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:1086)
at
com.cloud.utils.db.GenericDaoBase.lockRow(GenericDaoBase.java:1061)
at
com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:996)
at jdk.internal.reflect.GeneratedMethodAccessor14.invoke(Unknown
Source)
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:289)
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:1955)
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:302)
at
org.apache.cloudstack.framework.config.ConfigKey.value(ConfigKey.java:324)
at
org.apache.cloudstack.ca.provider.RootCAProvider.loadRootCAKeyPair(RootCAProvider.java:346)
at
org.apache.cloudstack.ca.provider.RootCAProvider.setupCA(RootCAProvider.java:425)
at
org.apache.cloudstack.ca.provider.RootCAProvider.configure(RootCAProvider.java:454)
he.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:279)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:279)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:262)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.java:131)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:79)
at
org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37)
at
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:71)
at
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:58)
at
org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:62)
at
org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:53)
at
org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:1073)
at
org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:572)
at
org.eclipse.jetty.server.handler.ContextHandler.contextInitialized(ContextHandler.java:1002)
at
org.eclipse.jetty.servlet.ServletHandler.initialize(ServletHandler.java:765)
at
org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:379)
at
org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1449)
at
org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1414)
at
org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:916)
at
org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:288)
at
org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:524)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:73)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:110)
at
org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97)
at
org.eclipse.jetty.server.handler.gzip.GzipHandler.doStart(GzipHandler.java:426)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:73)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:117)
at
org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:73)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169)
at org.eclipse.jetty.server.Server.start(Server.java:423)
at
org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:110)
at
org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97)
at org.eclipse.jetty.server.Server.doStart(Server.java:387)
at
org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:73)
at org.apache.cloudstack.ServerDaemon.start(ServerDaemon.java:207)
at org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:117)
Caused by: com.mysql.cj.exceptions.DataConversionException: Cannot determine
value type from string '^A^@^@^@^@^@^@^@'
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)
... 91 more
2025-08-11 06:02:22,699 ERROR [o.a.c.s.l.CloudStackExtendedLifeCycle]
(main:[]) (logid:) Error on configuring bean RootCAProvider - Unable to find by
id on DB, due to: Cannot determine value type from string '^A^@^@^@^@^@^@^@'
com.cloud.utils.exception.CloudRuntimeException: Unable to find by id on DB,
due to: Cannot determine value type from string '^A^@^@^@^@^@^@^@'
at
com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:1089)
at
com.cloud.utils.db.GenericDaoBase.lockRow(GenericDaoBase.java:1061)
at
com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:996)
at jdk.internal.reflect.GeneratedMethodAccessor14.invoke(Unknown
Source)
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:289)
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:1955)
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:302)
at
org.apache.cloudstack.framework.config.ConfigKey.value(ConfigKey.java:324)
at
org.apache.cloudstack.ca.provider.RootCAProvider.loadRootCAKeyPair(RootCAProvider.java:346)
at
org.apache.cloudstack.ca.provider.RootCAProvider.setupCA(RootCAProvider.java:425)
at
org.apache.cloudstack.ca.provider.RootCAProvider.configure(RootCAProvider.java:454)
at
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle$3.with(CloudStackExtendedLifeCycle.java:121)
at
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.with(CloudStackExtendedLifeCycle.java:163)
at
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.configure(CloudStackExtendedLifeCycle.java:116)
at
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:53)
at
org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:178)
at
org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:54)
at
org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:356)
...
2025-08-11 06:02:22,701 WARN [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:[]) (logid:) Failed to start module [root-ca] due to: [Failed to start
bean 'cloudStackLifeCycle'; nested exception is
com.cloud.utils.exception.CloudRuntimeException: Unable to find by id on DB,
due to: Cannot determine value type from string '^A^@^@^@^@^@^@^@'].
2025-08-11 06:02:22,701 DEBUG [o.a.c.s.m.m.i.DefaultModuleDefinitionSet]
(main:[]) (logid:) module start failure of module [root-ca] was due to:
org.springframework.context.ApplicationContextException: Failed to start bean
'cloudStackLifeCycle'; nested exception is
com.cloud.utils.exception.CloudRuntimeException: Unable to find by id on DB,
due to: Cannot determine value type from string '^A^@^@^@^@^@^@^@'
at
org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:181)
at
org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:54)
at
org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:356)
at java.base/java.lang.Iterable.forEach(Iterable.java:75)
at
org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:155)
at
org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:123)
at
org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:937)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:586)
at
org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:174)
...
Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to find
by id on DB, due to: Cannot determine value type from string '^A^@^@^@^@^@^@^@'
at
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle$3.with(CloudStackExtendedLifeCycle.java:127)
at
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.with(CloudStackExtendedLifeCycle.java:163)
at
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.configure(CloudStackExtendedLifeCycle.java:116)
at
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:53)
at
org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:178)
... 51 more
Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to find
by id on DB, due to: Cannot determine value type from string '^A^@^@^@^@^@^@^@'
at
com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:1089)
at
com.cloud.utils.db.GenericDaoBase.lockRow(GenericDaoBase.java:1061)
at
com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:996)
at jdk.internal.reflect.GeneratedMethodAccessor14.invoke(Unknown
Source)
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)
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
