From which version are you performing the upgrade?

Is there an easy way to tell? I can't start the app to check the version because it just tries to upgrade again and fails/crashes

You may stop OneDev container, and run below command:

docker run --rm -v <onedev data dir>:/opt/onedev 1dev/server cat /opt/onedev/version.txt

Also please let me know your MariaDB details, including OS and version, jdbc driver version, onedev database character set, etc.

Running the command returned "7.1.8"

MariaDB Details:

OS: Official MariaDB docker image JDBC driver version: 3.0.3

hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
hibernate.connection.driver_class=org.mariadb.jdbc.Driver
hibernate.connection.url=jdbc:mariadb://<removed>:3306/onedev
hibernate.connection.username=<removed>
hibernate.connection.password=<removed>

Database character set - Not sure how to get this, but I can provide the following:

collation: utf8mb4_unicode_ci engine: InnoDB

Just tested and it works at my side. I am starting MariaDB with below command:

docker run --name mariadb -p 3306:3306 --env MARIADB_PASSWORD=root --env MARIADB_ROOT_PASSWORD=root --env MARIADB_DATABASE=onedev -v $(pwd)/db:/var/lib/mysql --network mynet mariadb:latest

Please pull your mariadb to update to latest version to see if it works. If still not work, please tell me detailed steps to reproduce this issue.

BTW: you may still get your OneDev up and running with 7.1.8 image, although upgrade fails.

I've made sure the mariadb docker image I'm using has been updated to the latest version, also I tried starting the app on both 7.1.8 and 7.1.7 after restoring the database from backup, and I was met with the following error:

INFO  - Launching application from '/app'...
INFO  - Starting server...
INFO  - Upgrading /opt/onedev...
INFO  - >>> INFO  - Launching application from '/opt/onedev'...
INFO  - >>> INFO  - Cleaning temp directory...
INFO  - >>> INFO  - Starting server...
INFO  - Old data version: 84
INFO  - Backing up old program files as /opt/onedev/site/program-backup/2022-05-16_03-16-15...
INFO  - Copying new program files into /opt/onedev...
INFO  - Successfully upgraded /opt/onedev
03:16:16 INFO  i.onedev.commons.bootstrap.Bootstrap - Launching application from '/opt/onedev'...
03:16:16 INFO  i.onedev.commons.bootstrap.Bootstrap - Cleaning temp directory...
03:16:16 INFO  io.onedev.commons.loader.AppLoader - Starting server...
03:16:23 ERROR i.onedev.commons.bootstrap.Bootstrap - Error booting application
org.hibernate.type.SerializationException: could not deserialize
        at org.hibernate.internal.util.SerializationHelper.doDeserialize(SerializationHelper.java:243)
        at org.hibernate.internal.util.SerializationHelper.deserialize(SerializationHelper.java:287)
        at org.hibernate.type.descriptor.java.SerializableTypeDescriptor.fromBytes(SerializableTypeDescriptor.java:138)
        at org.hibernate.type.descriptor.java.SerializableTypeDescriptor.wrap(SerializableTypeDescriptor.java:120)
        at org.hibernate.type.descriptor.java.SerializableTypeDescriptor.wrap(SerializableTypeDescriptor.java:29)
        at org.hibernate.type.descriptor.sql.BlobTypeDescriptor$1.doExtract(BlobTypeDescriptor.java:48)
        at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:47)
        at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:257)
        at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:253)
        at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:243)
        at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:329)
        at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:3134)
        at org.hibernate.loader.plan.exec.process.internal.EntityReferenceInitializerImpl.loadFromResultSet(EntityReferenceInitializerImpl.java:342)
        at org.hibernate.loader.plan.exec.process.internal.EntityReferenceInitializerImpl.hydrateEntityState(EntityReferenceInitializerImpl.java:269)
        at org.hibernate.loader.plan.exec.process.internal.AbstractRowReader.readRow(AbstractRowReader.java:102)
        at org.hibernate.loader.plan.exec.internal.EntityLoadQueryDetails$EntityLoaderRowReader.readRow(EntityLoadQueryDetails.java:288)
        at org.hibernate.loader.plan.exec.process.internal.ResultSetProcessorImpl.extractRows(ResultSetProcessorImpl.java:157)
        at org.hibernate.loader.plan.exec.process.internal.ResultSetProcessorImpl.extractResults(ResultSetProcessorImpl.java:94)
        at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:105)
        at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:285)
        at org.hibernate.persister.entity.AbstractEntityPersister.doLoad(AbstractEntityPersister.java:4441)
        at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4431)
        at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:569)
        at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:537)
        at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:208)
        at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:332)
        at org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:108)
        at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:74)
        at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:113)
        at org.hibernate.internal.SessionImpl.fireLoadNoChecks(SessionImpl.java:1186)
        at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1175)
        at org.hibernate.internal.SessionImpl.access$2100(SessionImpl.java:193)
        at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.doLoad(SessionImpl.java:2786)
        at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.lambda$load$1(SessionImpl.java:2767)
        at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.perform(SessionImpl.java:2723)
        at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.load(SessionImpl.java:2767)
        at org.hibernate.internal.SessionImpl.get(SessionImpl.java:983)
        at io.onedev.server.persistence.dao.DefaultDao.get(DefaultDao.java:42)
        at io.onedev.server.persistence.SessionInterceptor$1.call(SessionInterceptor.java:23)
        at io.onedev.server.persistence.DefaultSessionManager.call(DefaultSessionManager.java:79)
        at io.onedev.server.persistence.SessionInterceptor.invoke(SessionInterceptor.java:18)
        at io.onedev.server.persistence.dao.BaseEntityManager.get(BaseEntityManager.java:77)
        at io.onedev.server.maintenance.DefaultDataManager.init(DefaultDataManager.java:118)
        at io.onedev.server.persistence.TransactionInterceptor$1.call(TransactionInterceptor.java:23)
        at io.onedev.server.persistence.DefaultTransactionManager$1.call(DefaultTransactionManager.java:72)
        at io.onedev.server.persistence.DefaultSessionManager.call(DefaultSessionManager.java:79)
        at io.onedev.server.persistence.DefaultTransactionManager.call(DefaultTransactionManager.java:60)
        at io.onedev.server.persistence.TransactionInterceptor.invoke(TransactionInterceptor.java:18)
        at io.onedev.server.OneDev.start(OneDev.java:111)
        at io.onedev.commons.loader.DefaultPluginManager.start(DefaultPluginManager.java:44)
        at io.onedev.commons.loader.AppLoader.start(AppLoader.java:73)
        at io.onedev.commons.bootstrap.Bootstrap.main(Bootstrap.java:189)
Caused by: java.io.StreamCorruptedException: invalid stream header: C2ACED9C
        at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:938)
        at java.io.ObjectInputStream.<init>(ObjectInputStream.java:396)
        at org.hibernate.internal.util.SerializationHelper$CustomObjectInputStream.<init>(SerializationHelper.java:309)
        at org.hibernate.internal.util.SerializationHelper$CustomObjectInputStream.<init>(SerializationHelper.java:299)
        at org.hibernate.internal.util.SerializationHelper.doDeserialize(SerializationHelper.java:218)
        ... 51 common frames omitted

This seems to be some sort of deserialization issue in the database possibly? I'm not sure as java isn't my thing

Looks that some database record is corrupted for some reason. You might need to restore from an old backup to get it working.

Or you may send the database backup (you are using to restore database) to me [robin AT onedev DOT io] and I will check what might be wrong.

Thank you, I sent an email. Would it be easier to restart from scratch? Would I (easily) be able to grab the git repositories I have setup and just migrate them over to another instance?

All git repositories are stored under <onedev data dir>/site/projects identified by project id.

I have not got the email yet. If attachment is too large, please share a dropbox link.

Hi Robin,

The email subject I sent you is "Issue #727 - Database Corruption", I've confirmed its not too big and was able to send it on my end. I took a look at the projects directory but I am unable to find the source code of my projects. Could you elaborate within a project folder how I can find/export the files within the project

I ended up restoring from a waaaay older database backup taken by onedev on an older version, swapping to the latest (7.2.3) and letting the upgrade migration process take place. It took a while, but eventually succeeded. Thanks, closing.

This upgrade failure is odd. Please take a manual backup of your database (via OneDev's database backup menu) before next upgrade.