abh1sar commented on PR #10485:
URL: https://github.com/apache/cloudstack/pull/10485#issuecomment-2892913188
> Could you post the test steps you took to reproduce the issue and verify
that this PR fixes it?
@JoaoJandre The first time management server is started after running the
cloudstack-setup-database commands will cause lots of exceptions like below in
the management-server.log
I tested the same with the changes with both HikariCP and Apache DBCP. I
observed no Exceptions and management-server was coming up as expected.
```
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)
```
--
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
