upgrade from 16.6.4 to 16.7.0 or later fails #3157
Tomislav Gountchev opened 7 hours ago

Trying to upgrade from 16.6.4 to any later version (16.7.0 - 16.8.2) fails. The database is MariaDB 10.11.18.

14:56:12 INFO  - >>> 14:56:12 INFO  - Importing from data file 'PullRequestTouchs.xml'...
14:56:12 INFO  - >>> 14:56:12 INFO  - Importing from data file 'Settings.xml'...
14:56:12 INFO  - >>> 14:56:12 WARN  - HHH000247: ErrorCode: 1406, SQLState: 22001
14:56:12 INFO  - >>> 14:56:12 WARN  - (conn=4243) Data too long for column 'o_value' at row 1
14:56:12 INFO  - >>> 14:56:12 ERROR - Error booting application
14:56:12 INFO  - >>> org.hibernate.exception.DataException: could not execute statement [(conn=4243) Data too long for column 'o_value' at row 1] [insert into o_Setting (o_key,o_value,o_id) values (?,?,?)]
14:56:12 INFO  - >>> 	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:53)
14:56:12 INFO  - >>> 	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:34)
14:56:12 INFO  - >>> 	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:115)
14:56:12 INFO  - >>> 	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:189)
14:56:12 INFO  - >>> 	at org.hibernate.engine.jdbc.mutation.internal.AbstractMutationExecutor.performNonBatchedMutation(AbstractMutationExecutor.java:145)
14:56:12 INFO  - >>> 	at org.hibernate.engine.jdbc.mutation.internal.MutationExecutorSingleNonBatched.performNonBatchedOperations(MutationExecutorSingleNonBatched.java:53)
14:56:12 INFO  - >>> 	at org.hibernate.engine.jdbc.mutation.internal.AbstractMutationExecutor.execute(AbstractMutationExecutor.java:65)
14:56:12 INFO  - >>> 	at org.hibernate.engine.jdbc.mutation.internal.AbstractMutationExecutor.execute(AbstractMutationExecutor.java:54)
14:56:12 INFO  - >>> 	at org.hibernate.persister.entity.mutation.InsertCoordinatorStandard.doStaticInserts(InsertCoordinatorStandard.java:183)
14:56:12 INFO  - >>> 	at org.hibernate.persister.entity.mutation.InsertCoordinatorStandard.coordinateInsert(InsertCoordinatorStandard.java:123)
14:56:12 INFO  - >>> 	at org.hibernate.persister.entity.mutation.InsertCoordinatorStandard.insert(InsertCoordinatorStandard.java:96)
14:56:12 INFO  - >>> 	at org.hibernate.internal.StatelessSessionImpl.insert(StatelessSessionImpl.java:249)
14:56:12 INFO  - >>> 	at org.hibernate.internal.StatelessSessionImpl.insert(StatelessSessionImpl.java:202)
14:56:12 INFO  - >>> 	at io.onedev.server.data.DefaultDataService.importData(DefaultDataService.java:557)
14:56:12 INFO  - >>> 	at io.onedev.server.persistence.SessionInterceptor$1.call(SessionInterceptor.java:23)
14:56:12 INFO  - >>> 	at io.onedev.server.persistence.DefaultSessionService.call(DefaultSessionService.java:85)
14:56:12 INFO  - >>> 	at io.onedev.server.persistence.SessionInterceptor.invoke(SessionInterceptor.java:18)
14:56:12 INFO  - >>> 	at io.onedev.server.commandhandler.RestoreDatabase.doRestore(RestoreDatabase.java:121)
14:56:12 INFO  - >>> 	at io.onedev.server.commandhandler.RestoreDatabase.lambda$start$0(RestoreDatabase.java:74)
14:56:12 INFO  - >>> 	at io.onedev.server.commandhandler.CommandHandler.callWithProbe(CommandHandler.java:62)
14:56:12 INFO  - >>> 	at io.onedev.server.commandhandler.CommandHandler.doMaintenance(CommandHandler.java:33)
14:56:12 INFO  - >>> 	at io.onedev.server.commandhandler.RestoreDatabase.start(RestoreDatabase.java:67)
14:56:12 INFO  - >>> 	at io.onedev.commons.loader.DefaultPluginManager.start(DefaultPluginManager.java:44)
14:56:12 INFO  - >>> 	at io.onedev.commons.loader.AppLoader.start(AppLoader.java:77)
14:56:12 INFO  - >>> 	at io.onedev.commons.bootstrap.Bootstrap.main(Bootstrap.java:212)
14:56:12 INFO  - >>> Caused by: java.sql.SQLDataException: (conn=4243) Data too long for column 'o_value' at row 1
14:56:12 INFO  - >>> 	at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:225)
14:56:12 INFO  - >>> 	at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
14:56:12 INFO  - >>> 	at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:238)
14:56:12 INFO  - >>> 	at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:232)
14:56:12 INFO  - >>> 	at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)
14:56:12 INFO  - >>> 	at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeUpdate(MariaDbPreparedStatementClient.java:194)
14:56:12 INFO  - >>> 	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
14:56:12 INFO  - >>> 	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
14:56:12 INFO  - >>> 	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:185)
14:56:12 INFO  - >>> 	... 21 common frames omitted
14:56:12 INFO  - >>> Caused by: java.sql.SQLException: Data too long for column 'o_value' at row 1
14:56:12 INFO  - >>> Query is: insert into o_Setting (o_key,o_value,o_id) values (?,?,?), parameters [13,<Stream>,3]
14:56:12 INFO  - >>> java thread: main
14:56:12 INFO  - >>> 	at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:163)
14:56:12 INFO  - >>> 	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:280)
14:56:12 INFO  - >>> 	at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:223)
14:56:12 INFO  - >>> 	... 26 common frames omitted
14:56:12 INFO  - >>> 14:56:12 INFO  - Stopping application...
14:56:12 ERROR - Failed to upgrade /opt/onedev
14:56:12 INFO  - >>> 14:56:12 INFO  - Launching application from '/opt/onedev'...
14:56:12 INFO  - >>> 14:56:12 INFO  - Cleaning temp directory...
14:56:13 INFO  - >>> 14:56:13 INFO  - Starting application...
14:56:15 INFO  - >>> 14:56:15 INFO  - Waiting for server to stop...
14:56:18 INFO  - >>> 14:56:18 INFO  - Stopping application...
14:56:18 INFO  - Cleaning database with new program...
14:56:18 INFO  - >>> 14:56:18 INFO  - Launching application from '/opt/onedev'...
14:56:18 INFO  - >>> 14:56:18 INFO  - Cleaning temp directory...
14:56:19 INFO  - >>> 14:56:19 INFO  - Starting application...
14:56:21 INFO  - >>> 14:56:21 INFO  - Waiting for server to stop...
14:56:25 INFO  - >>> 14:56:25 INFO  - Database is cleaned successfully
14:56:25 INFO  - >>> 14:56:25 INFO  - Stopping application...
14:56:25 INFO  - Restoring old program files...
14:56:25 INFO  - Old program files restored
14:56:25 INFO  - Restoring old database...
1/1
Type
Bug
Priority
Normal
Assignee
Affected Versions
16.7.0 and later
Labels
No labels
Issue Votes (0)
Watchers (2)
Reference
OD-3157
Please wait...
Connection lost or session expired, reload to recover
Page is in error, reload to recover