nvazquez opened a new issue, #10480: URL: https://github.com/apache/cloudstack/issues/10480
### problem It is observed that starting the management server service after running the `cloudstack-setup-databases` command leads to multiple exceptions on the management server logs. These exceptions are not observed anymore after restarting the management server ### Logs ```` 2025-02-27 13:26:26,070 ERROR [o.a.c.f.c.d.ConfigurationDaoImpl] (VMSchedulerPollTask:[ctx-f804ce4a]) (logid:30a4a0a1) DB Exception on: HikariProxyPreparedStatement@1499732297 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'6472732e706c616e2e6578706972652e696e74657276616c' java.sql.SQLDataException: Cannot determine value type from string '' 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:594) at com.cloud.utils.db.GenericDaoBase.setField(GenericDaoBase.java:2059) at com.cloud.utils.db.GenericDaoBase.toEntityBean(GenericDaoBase.java:1919) at com.cloud.utils.db.GenericDaoBase.toEntityBean(GenericDaoBase.java:1880) at com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:1075) at com.cloud.utils.db.GenericDaoBase.lockRow(GenericDaoBase.java:1050) 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:294) 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:307) at org.apache.cloudstack.framework.config.ConfigKey.value(ConfigKey.java:324) at org.apache.cloudstack.cluster.ClusterDrsServiceImpl.cleanUpOldDrsPlans(ClusterDrsServiceImpl.java:610) at org.apache.cloudstack.cluster.ClusterDrsServiceImpl.poll(ClusterDrsServiceImpl.java:194) at org.apache.cloudstack.cluster.ClusterDrsServiceImpl$1.runInContext(ClusterDrsServiceImpl.java:155) at org.apache.cloudstack.managed.context.ManagedContextTimerTask$1.runInContext(ManagedContextTimerTask.java:30) at org.apache.cloudstack.managed.context.ManagedContextRunnable$1.run(ManagedContextRunnable.java:49) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext$1.call(DefaultManagedContext.java:56) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callWithContext(DefaultManagedContext.java:103) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWithContext(DefaultManagedContext.java:53) at org.apache.cloudstack.managed.context.ManagedContextRunnable.run(ManagedContextRunnable.java:46) at org.apache.cloudstack.managed.context.ManagedContextTimerTask.run(ManagedContextTimerTask.java:32) at java.base/java.util.TimerThread.mainLoop(Timer.java:566) at java.base/java.util.TimerThread.run(Timer.java:516) Caused by: com.mysql.cj.exceptions.DataConversionException: Cannot determine value type from string '' 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) ... 44 more 2025-02-27 13:26:26,072 ERROR [o.a.c.c.ClusterDrsServiceImpl] (VMSchedulerPollTask:[ctx-f804ce4a]) (logid:30a4a0a1) Error while running DRS com.cloud.utils.exception.CloudRuntimeException: Unable to find by id on DB, due to: Cannot determine value type from string '' at com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:1078) at com.cloud.utils.db.GenericDaoBase.lockRow(GenericDaoBase.java:1050) 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:294) 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:307) at org.apache.cloudstack.framework.config.ConfigKey.value(ConfigKey.java:324) at org.apache.cloudstack.cluster.ClusterDrsServiceImpl.cleanUpOldDrsPlans(ClusterDrsServiceImpl.java:610) at org.apache.cloudstack.cluster.ClusterDrsServiceImpl.poll(ClusterDrsServiceImpl.java:194) at org.apache.cloudstack.cluster.ClusterDrsServiceImpl$1.runInContext(ClusterDrsServiceImpl.java:155) at org.apache.cloudstack.managed.context.ManagedContextTimerTask$1.runInContext(ManagedContextTimerTask.java:30) at org.apache.cloudstack.managed.context.ManagedContextRunnable$1.run(ManagedContextRunnable.java:49) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext$1.call(DefaultManagedContext.java:56) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callWithContext(DefaultManagedContext.java:103) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWithContext(DefaultManagedContext.java:53) at org.apache.cloudstack.managed.context.ManagedContextRunnable.run(ManagedContextRunnable.java:46) at org.apache.cloudstack.managed.context.ManagedContextTimerTask.run(ManagedContextTimerTask.java:32) at java.base/java.util.TimerThread.mainLoop(Timer.java:566) at java.base/java.util.TimerThread.run(Timer.java:516) ... 2025-02-27 13:26:31,067 ERROR [o.a.c.f.c.d.ConfigurationDaoImpl] (AsyncJobMgr-Heartbeat-1:[ctx-dd76f341]) (logid:c8292f0a) DB Exception on: HikariProxyPreparedStatement@64236286 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'6a6f622e63616e63656c2e7468726573686f6c642e6d696e75746573' java.sql.SQLDataException: Cannot determine value type from string '' 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:594) at com.cloud.utils.db.GenericDaoBase.setField(GenericDaoBase.java:2059) at com.cloud.utils.db.GenericDaoBase.toEntityBean(GenericDaoBase.java:1919) at com.cloud.utils.db.GenericDaoBase.toEntityBean(GenericDaoBase.java:1880) at com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:1075) at com.cloud.utils.db.GenericDaoBase.lockRow(GenericDaoBase.java:1050) 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:294) 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:307) at org.apache.cloudstack.framework.config.ConfigKey.value(ConfigKey.java:324) at org.apache.cloudstack.framework.jobs.impl.AsyncJobManagerImpl$7.reallyRun(AsyncJobManagerImpl.java:948) at org.apache.cloudstack.framework.jobs.impl.AsyncJobManagerImpl$7.runInContext(AsyncJobManagerImpl.java:933) at org.apache.cloudstack.managed.context.ManagedContextRunnable$1.run(ManagedContextRunnable.java:49) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext$1.call(DefaultManagedContext.java:56) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callWithContext(DefaultManagedContext.java:103) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWithContext(DefaultManagedContext.java:53) at org.apache.cloudstack.managed.context.ManagedContextRunnable.run(ManagedContextRunnable.java:46) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305) at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.base/java.lang.Thread.run(Thread.java:840) Caused by: com.mysql.cj.exceptions.DataConversionException: Cannot determine value type from string '' 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) ... 45 more 2025-02-27 13:26:31,067 ERROR [o.a.c.f.j.i.AsyncJobManagerImpl$7] (AsyncJobMgr-Heartbeat-1:[ctx-dd76f341]) (logid:c8292f0a) Unexpected exception when trying to execute queue item, com.cloud.utils.exception.CloudRuntimeException: Unable to find by id on DB, due to: Cannot determine value type from string '' at com.cloud.utils.db.GenericDaoBase.findById(GenericDaoBase.java:1078) at com.cloud.utils.db.GenericDaoBase.lockRow(GenericDaoBase.java:1050) 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:294) 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:307) at org.apache.cloudstack.framework.config.ConfigKey.value(ConfigKey.java:324) at org.apache.cloudstack.framework.jobs.impl.AsyncJobManagerImpl$7.reallyRun(AsyncJobManagerImpl.java:948) at org.apache.cloudstack.framework.jobs.impl.AsyncJobManagerImpl$7.runInContext(AsyncJobManagerImpl.java:933) at org.apache.cloudstack.managed.context.ManagedContextRunnable$1.run(ManagedContextRunnable.java:49) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext$1.call(DefaultManagedContext.java:56) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callWithContext(DefaultManagedContext.java:103) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWithContext(DefaultManagedContext.java:53) at org.apache.cloudstack.managed.context.ManagedContextRunnable.run(ManagedContextRunnable.java:46) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305) at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.base/java.lang.Thread.run(Thread.java:840) ```` ### versions Main branch (currently 4.21.0.0-SNAPSHOT) ### The steps to reproduce the bug 1. Install management server from the latest main branch 2. Run setup databases command 3. Start management-server service 4. Observe the logs ### What to do about it? Workaround: Restart the management server -- 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.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org