sureshanaparti commented on PR #8753: URL: https://github.com/apache/cloudstack/pull/8753#issuecomment-1983328902
> @mlsorensen PR LGTM, however, it's breaking the mvn deploydb: > > ``` > ========> Processing upgrade: com.cloud.upgrade.DatabaseUpgradeChecker > 22:48:25.067 [com.cloud.upgrade.DatabaseCreator.main()] ERROR com.cloud.utils.db.DbUtil - GET_LOCK() throws exception > java.sql.SQLException: Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY. > at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130) ~[mysql-connector-j-8.0.33.jar:8.0.33] > at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-j-8.0.33.jar:8.0.33] > ``` > > From release notes, it seems the driver has changed/assumed some new defaults in handling of cursor/resultset. > > @blueorangutan test matrix Hi @mlsorensen It works after adding "_scrollTolerantForwardOnly=true_" to the connection string. Please update the mysql connection strings. References: https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-24.html https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-result-sets.html#cj-conn-prop_scrollTolerantForwardOnly `A new connection property, [scrollTolerantForwardOnly](https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-result-sets.html#cj-conn-prop_scrollTolerantForwardOnly), has been introduced, which preserved the legacy behavior of Connector/J 8.0.17 and earlier by tolerating backward and absolute cursor movements on result sets of type ResultSet.TYPE_FORWARD_ONLY. This is for maintaining compatibility with legacy code that took advantage of the old behavior. See the description for [scrollTolerantForwardOnly](https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-result-sets.html#cj-conn-prop_scrollTolerantForwardOnly) for details. (Bug #31747910)` -- 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
