Unable to restore database with SQLServer connector (OD-43)

bufferUnderrun opened 6 years ago

I've tested onedev with the default internal database and want to migrate to ms sqlserver. I've done a backup and there is a bug when restoring to sqlserver

$ ./restore-db.bat database.dump
--> Wrapper Started as Console
Java Service Wrapper Standard Edition 64-bit 3.5.41
  Copyright (C) 1999-2019 Tanuki Software, Ltd. All Rights Reserved.
    http://wrapper.tanukisoftware.com
  Licensed to Robin Shen for OneDev

Launching a JVM...
Java HotSpot(TM) 64-Bit Server VM warning: Options -Xverify:none and -noverify were deprecated in JDK 13 and will likely be removed in a future release.
WrapperManager: Initializing...
INFO  - Launching application from 'D:\APPLICATIONS\onedev-3.0.5'...
INFO  - Cleaning temp directory...
INFO  - Initializing dependency injection container...
INFO  - Starting plugin manager...
INFO  - Restoring database from D:\APPLICATIONS\onedev-3.0.5\bin\database.dump...
ERROR - Failed to load driver class com.microsoft.sqlserver.jdbc.SQLServerDriver from HikariConfig class classloader java.net.URLClassLoader@23915509
ERROR - Failed to set property driverClassName on target class com.zaxxer.hikari.HikariConfig
java.lang.reflect.InvocationTargetException: null
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
        at java.base/java.lang.reflect.Method.invoke(Method.java:567) ~[na:na]
        at com.zaxxer.hikari.util.PropertyElf.setProperty(PropertyElf.java:146) ~[com.zaxxer.HikariCP-2.7.9.jar:na]
        at com.zaxxer.hikari.util.PropertyElf.lambda$setTargetFromProperties$0(PropertyElf.java:57) ~[com.zaxxer.HikariCP-2.7.9.jar:na]
        at java.base/java.util.concurrent.ConcurrentHashMap.forEach(ConcurrentHashMap.java:1603) ~[na:na]
        at java.base/java.util.Properties.forEach(Properties.java:1437) ~[na:na]
        at com.zaxxer.hikari.util.PropertyElf.setTargetFromProperties(PropertyElf.java:52) ~[com.zaxxer.HikariCP-2.7.9.jar:na]
        at com.zaxxer.hikari.HikariConfig.<init>(HikariConfig.java:135) ~[com.zaxxer.HikariCP-2.7.9.jar:na]
        at org.hibernate.hikaricp.internal.HikariConfigurationUtil.loadConfiguration(HikariConfigurationUtil.java:56) ~[org.hibernate.hibernate-hikaricp-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.hikaricp.internal.HikariCPConnectionProvider.configure(HikariCPConnectionProvider.java:58) ~[org.hibernate.hibernate-hikaricp-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:107) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:246) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.buildJdbcConnectionAccess(JdbcEnvironmentInitiator.java:145) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:66) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:101) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:237) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.id.factory.internal.DefaultIdentifierGeneratorFactory.injectServices(DefaultIdentifierGeneratorFactory.java:152) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.injectDependencies(AbstractServiceRegistryImpl.java:286) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:243) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:175) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:118) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:83) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:473) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:84) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at io.onedev.server.persistence.DefaultPersistManager.buildMetadata(DefaultPersistManager.java:136) ~[io.onedev.server-core-3.0.5.jar:na]
        at io.onedev.server.maintenance.RestoreDatabase.start(RestoreDatabase.java:62) ~[io.onedev.server-core-3.0.5.jar:na]
        at io.onedev.server.OneDev.start(OneDev.java:101) ~[io.onedev.server-core-3.0.5.jar:na]
        at io.onedev.commons.launcher.loader.DefaultPluginManager.start(DefaultPluginManager.java:44) ~[io.onedev.commons-launcher-loader-1.1.10.jar:na]
        at io.onedev.commons.launcher.loader.AppLoader.start(AppLoader.java:74) ~[io.onedev.commons-launcher-loader-1.1.10.jar:na]
        at io.onedev.commons.launcher.bootstrap.Bootstrap.main(Bootstrap.java:165) ~[io.onedev.commons-launcher-bootstrap-1.1.10.jar:na]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
        at java.base/java.lang.reflect.Method.invoke(Method.java:567) ~[na:na]
        at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:349) ~[wrapper.jar:3.5.41]
        at java.base/java.lang.Thread.run(Thread.java:830) ~[na:na]
Caused by: java.lang.RuntimeException: Failed to load driver class com.microsoft.sqlserver.jdbc.SQLServerDriver in either of HikariConfig class loader or Thread context classloader
        at com.zaxxer.hikari.HikariConfig.setDriverClassName(HikariConfig.java:512) ~[com.zaxxer.HikariCP-2.7.9.jar:na]
        ... 43 common frames omitted
ERROR - Error booting application
org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:275) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:237) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.id.factory.internal.DefaultIdentifierGeneratorFactory.injectServices(DefaultIdentifierGeneratorFactory.java:152) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.injectDependencies(AbstractServiceRegistryImpl.java:286) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:243) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:175) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:118) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:83) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:473) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:84) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at io.onedev.server.persistence.DefaultPersistManager.buildMetadata(DefaultPersistManager.java:136) ~[io.onedev.server-core-3.0.5.jar:na]
        at io.onedev.server.maintenance.RestoreDatabase.start(RestoreDatabase.java:62) ~[io.onedev.server-core-3.0.5.jar:na]
        at io.onedev.server.OneDev.start(OneDev.java:101) ~[io.onedev.server-core-3.0.5.jar:na]
        at io.onedev.commons.launcher.loader.DefaultPluginManager.start(DefaultPluginManager.java:44) ~[io.onedev.commons-launcher-loader-1.1.10.jar:na]
        at io.onedev.commons.launcher.loader.AppLoader.start(AppLoader.java:74) ~[io.onedev.commons-launcher-loader-1.1.10.jar:na]
        at io.onedev.commons.launcher.bootstrap.Bootstrap.main(Bootstrap.java:165) ~[io.onedev.commons-launcher-bootstrap-1.1.10.jar:na]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
        at java.base/java.lang.reflect.Method.invoke(Method.java:567) ~[na:na]
        at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:349) ~[wrapper.jar:3.5.41]
        at java.base/java.lang.Thread.run(Thread.java:830) ~[na:na]
Caused by: org.hibernate.HibernateException: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException
        at org.hibernate.hikaricp.internal.HikariCPConnectionProvider.configure(HikariCPConnectionProvider.java:63) ~[org.hibernate.hibernate-hikaricp-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:107) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:246) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.buildJdbcConnectionAccess(JdbcEnvironmentInitiator.java:145) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:66) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:101) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        ... 23 common frames omitted
Caused by: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException
        at com.zaxxer.hikari.util.PropertyElf.setProperty(PropertyElf.java:154) ~[com.zaxxer.HikariCP-2.7.9.jar:na]
        at com.zaxxer.hikari.util.PropertyElf.lambda$setTargetFromProperties$0(PropertyElf.java:57) ~[com.zaxxer.HikariCP-2.7.9.jar:na]
        at java.base/java.util.concurrent.ConcurrentHashMap.forEach(ConcurrentHashMap.java:1603) ~[na:na]
        at java.base/java.util.Properties.forEach(Properties.java:1437) ~[na:na]
        at com.zaxxer.hikari.util.PropertyElf.setTargetFromProperties(PropertyElf.java:52) ~[com.zaxxer.HikariCP-2.7.9.jar:na]
        ...

Robin Shen commented 6 years ago

@bufferUnderrun have you put SQL Server jdbc driver into onedev's site\lib directory as explained in conf\hibernate.properties? I just downloaded latest 8.2 driver it works fine with SQL server 2012 (have not tested with other versions)

After downloading the driver, you will get a zip file (sqljdbc_8.2.0.0_enu.zip), unzip it and copy the jar mssql-jdbc-8.2.0.jre8.jar into site\lib
Robin Shen changed state to 'Closed' 6 years ago
Previous Value Current Value
Open

Closed
Robin Shen commented 6 years ago

@bufferUnderrun Closing. Reopen if there is still problems.
bufferUnderrun commented 6 years ago

i'm a bit confused, i did not see this in the config file... I will download the connector and finally run OneDev on prod. Thanks for tout help

Previous Value	Current Value
Open	Closed

bufferUnderrun commented 6 years ago

I'm able to start a new fresh instance with sqlserver for database : table are created and everything work.

But, i'm still running an issue when restoring a backup :

$ ./restore-db.bat database.bak
--> Wrapper Started as Console
Java Service Wrapper Standard Edition 64-bit 3.5.41
  Copyright (C) 1999-2019 Tanuki Software, Ltd. All Rights Reserved.
    http://wrapper.tanukisoftware.com
  Licensed to Robin Shen for OneDev

Launching a JVM...
Java HotSpot(TM) 64-Bit Server VM warning: Options -Xverify:none and -noverify were deprecated in JDK 13 and will likely be removed in a future release.
WrapperManager: Initializing...
INFO  - Launching application from 'D:\APPLICATIONS\onedev-3.0.5'...
INFO  - Cleaning temp directory...
INFO  - Initializing dependency injection container...
INFO  - Starting plugin manager...
INFO  - Restoring database from D:\APPLICATIONS\onedev-3.0.5\bin\database.bak...
ERROR - Could not fetch the SequenceInformation from the database
com.microsoft.sqlserver.jdbc.SQLServerException: Nom d'objet 'INFORMATION_SCHEMA.SEQUENCES' non valide.
        at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262) ~[mssql-jdbc-8.2.0.jre11.jar:na]
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1632) ~[mssql-jdbc-8.2.0.jre11.jar:na]
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:872) ~[mssql-jdbc-8.2.0.jre11.jar:na]
        at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:767) ~[mssql-jdbc-8.2.0.jre11.jar:na]
        at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7225) ~[mssql-jdbc-8.2.0.jre11.jar:na]
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3053) ~[mssql-jdbc-8.2.0.jre11.jar:na]
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:247) ~[mssql-jdbc-8.2.0.jre11.jar:na]
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:222) ~[mssql-jdbc-8.2.0.jre11.jar:na]
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:692) ~[mssql-jdbc-8.2.0.jre11.jar:na]
        at org.hibernate.tool.schema.extract.internal.SequenceInformationExtractorLegacyImpl.extractMetadata(SequenceInformationExtractorLegacyImpl.java:42) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentImpl.sequenceInformationList(JdbcEnvironmentImpl.java:403) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentImpl.<init>(JdbcEnvironmentImpl.java:268) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:114) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:101) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:237) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.id.factory.internal.DefaultIdentifierGeneratorFactory.injectServices(DefaultIdentifierGeneratorFactory.java:152) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.injectDependencies(AbstractServiceRegistryImpl.java:286) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:243) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:175) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:118) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:83) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:473) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:84) ~[org.hibernate.hibernate-core-5.4.9.Final.jar:5.4.9.Final]
        at io.onedev.server.persistence.DefaultPersistManager.buildMetadata(DefaultPersistManager.java:136) ~[io.onedev.server-core-3.0.5.jar:na]
        at io.onedev.server.maintenance.RestoreDatabase.start(RestoreDatabase.java:62) ~[io.onedev.server-core-3.0.5.jar:na]
        at io.onedev.server.OneDev.start(OneDev.java:101) ~[io.onedev.server-core-3.0.5.jar:na]
        at io.onedev.commons.launcher.loader.DefaultPluginManager.start(DefaultPluginManager.java:44) ~[io.onedev.commons-launcher-loader-1.1.10.jar:na]
        at io.onedev.commons.launcher.loader.AppLoader.start(AppLoader.java:74) ~[io.onedev.commons-launcher-loader-1.1.10.jar:na]
        at io.onedev.commons.launcher.bootstrap.Bootstrap.main(Bootstrap.java:165) ~[io.onedev.commons-launcher-bootstrap-1.1.10.jar:na]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
        at java.base/java.lang.reflect.Method.invoke(Method.java:567) ~[na:na]
        at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:349) ~[wrapper.jar:3.5.41]
        at java.base/java.lang.Thread.run(Thread.java:830) ~[na:na]
INFO  - Validating data file 'Users.xml'...
ERROR - Error booting application
java.lang.RuntimeException: Error validating entity (entity class: class io.onedev.server.model.User, entity id: 7, entity property: password, error message: may not be empty)
        at io.onedev.server.util.validation.DefaultEntityValidator.reportError(DefaultEntityValidator.java:23) ~[io.onedev.server-core-3.0.5.jar:na]
        at io.onedev.server.util.validation.DefaultEntityValidator.validate(DefaultEntityValidator.java:30) ~[io.onedev.server-core-3.0.5.jar:na]
        at io.onedev.server.persistence.DefaultPersistManager.validateData(DefaultPersistManager.java:503) ~[io.onedev.server-core-3.0.5.jar:na]
        at io.onedev.server.maintenance.RestoreDatabase.doRestore(RestoreDatabase.java:93) ~[io.onedev.server-core-3.0.5.jar:na]
        at io.onedev.server.maintenance.RestoreDatabase.start(RestoreDatabase.java:69) ~[io.onedev.server-core-3.0.5.jar:na]
        at io.onedev.server.OneDev.start(OneDev.java:101) ~[io.onedev.server-core-3.0.5.jar:na]
        at io.onedev.commons.launcher.loader.DefaultPluginManager.start(DefaultPluginManager.java:44) ~[io.onedev.commons-launcher-loader-1.1.10.jar:na]
        at io.onedev.commons.launcher.loader.AppLoader.start(AppLoader.java:74) ~[io.onedev.commons-launcher-loader-1.1.10.jar:na]
        at io.onedev.commons.launcher.bootstrap.Bootstrap.main(Bootstrap.java:165) ~[io.onedev.commons-launcher-bootstrap-1.1.10.jar:na]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
        at java.base/java.lang.reflect.Method.invoke(Method.java:567) ~[na:na]
        at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:349) ~[wrapper.jar:3.5.41]
        at java.base/java.lang.Thread.run(Thread.java:830) ~[na:na]
<-- Wrapper Stopped

bufferUnderrun changed state to 'Open' 6 years ago
Previous Value Current Value
Closed

Open
Robin Shen commented 6 years ago

This restore fails because the data exported previously has an invalid entry due to a LDAP bug (which will be fixed in 3.0.6). If possible, please create another backup without using LDAP authentication, and restore to SQL server to see if it works. Note that you will need to re-create SQL server database if previous restore fails.

Also make sure your SQL server use has full permission over the database.
bufferUnderrun commented 6 years ago

I've removed external auth, done a new backup but the restore still fail with the same error.

The error occurs because, with LDAP, auth passwd is blank and in the database you set varchar(1014) NOT NULL, so import fail ?
Robin Shen commented 6 years ago

Yes this is a bug. The password of LDAP authenticated user is written to internal database as empty, whereas SQL server database schema for the field is set to non-null.
OneDev changed state to 'Committed' 6 years ago
Previous Value Current Value
Open

Committed
Robin Shen changed iterations 6 years ago
Previous Value Current Value
empty
3.0.6
OneDev changed state to 'Closed' 6 years ago
Previous Value Current Value
Committed

Closed
Login to comment

Previous Value	Current Value
Closed	Open

Previous Value	Current Value
Open	Committed

Previous Value	Current Value
empty	3.0.6

Previous Value	Current Value
Committed	Closed

Type	Bug
Priority	Critical
Assignee	Not assigned

Iterations

3.0.6 Closed

Issue Votes (0)

Watchers (2)

Reference

OD-43