"Column count doesn't match value count at row 2" error occurs while upgrading to 2024.q1.1 using MariaDB as database

Issue

• Upgrading Liferay DXP 7.3 to Quarterly 2024.q1.1 shows the error "Column count doesn't match value count at row 2" in the log.

Environment

• 2024.q1
• MariaDB 10.4

Resolution

• A possible cause is that the rewriteBatchedStatements=true parameter is being used in the connection url for MariaDB.
• This parameter is a performance extension for batch operations which would not be compatible with the execution of the upgrade.
• Remove this parameter from the url connection configured in the portal-upgrade-database.properties (jdbc.default.url) and try the upgrade again.

Additional Information

• https://mariadb.com/docs/server/connect/programming-languages/java/batch/