Hi, we are trying upgrade Talend from 7.1 to 7.3. While upgrading TAC admin database we are getting below error.
Task 'ExecutionHistoryCleanerMigrationOperation' 'before' part starts...
Task 'ExecutionHistoryCleanerMigrationOperation' 'before' part successfully ends
Task 'SchedulerMigration' 'before' part starts...
Task 'SchedulerMigration' 'before' part successfully ends
Task 'EmptyToken' 'before' part starts...
Task 'EmptyToken' 'before' part successfully ends
Task 'ChangeRoleName' 'before' part starts...
WARN: no 'Business user' or 'Guest' role name in userrole table.
Task 'ChangeRoleName' 'before' part successfully ends
Task 'JobPrmMigration' 'before' part starts...
org.hibernate.exception.GenericJDBCException: could not extract ResultSet
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67)
at org.hibernate.loader.Loader.getResultSet(Loader.java:2292)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2050)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2012)
at org.hibernate.loader.Loader.doQuery(Loader.java:953)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354)
at org.hibernate.loader.Loader.doList(Loader.java:2815)
at org.hibernate.loader.Loader.doList(Loader.java:2797)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2629)
at org.hibernate.loader.Loader.list(Loader.java:2624)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:109)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1859)
at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:370)
at org.talend.migration.operations.JobPrmMigration.doOperationsBeforeDatabaseMigration(JobPrmMigration.java:112)
at org.talend.migration.AdministratorCenterMigration.doOperationsBeforeDatabaseMigration(AdministratorCenterMigration.java:112)
at org.talend.migration.TalendMigrationApplication.call(TalendMigrationApplication.java:270)
at org.talend.migration.TalendMigrationApplication.call(TalendMigrationApplication.java:51)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Connection reset
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:974)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1024)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:379)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
... 18 more
org.hibernate.TransactionException: Unable to rollback against JDBC Connection
at org.hibernate.resource.jdbc.internal.AbstractLogicalConnectionImplementor.rollback(AbstractLogicalConnectionImplementor.java:122)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.rollback(JdbcResourceLocalTransactionCoordinatorImpl.java:304)
at org.hibernate.engine.transaction.internal.TransactionImpl.rollback(TransactionImpl.java:142)
at org.talend.migration.operations.JobPrmMigration.doOperationsBeforeDatabaseMigration(JobPrmMigration.java:124)
at org.talend.migration.AdministratorCenterMigration.doOperationsBeforeDatabaseMigration(AdministratorCenterMigration.java:112)
at org.talend.migration.TalendMigrationApplication.call(TalendMigrationApplication.java:270)
at org.talend.migration.TalendMigrationApplication.call(TalendMigrationApplication.java:51)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.lang.Thread.run(Thread.java:748)
