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: commits-unsubscr...@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to