Brent Hitzeroth
opened 5 months ago
-
Seems you are using MS SQL Server? OneDev no longer supports it since v11.6.0 (https://code.onedev.io/~help/incompatibilities#1160). Please switch to either MySQL or PostgreSQL.
-
This comes as a bit of a shock as our whole environment is built on mssql? Its not like we can just change company standards, this is a mainstream DB? I see from the docs there are three supported DB's and a backup / restore procedure to migrate to a different DB will this work in my case from MSsql to PostgreSQL for example?
-
I upgraded to latest java and installed Postgresql 17 and followed upgrade instructions but still getting an error with no data being put in new db.
Microsoft Windows [Version 10.0.14393] (c) 2016 Microsoft Corporation. All rights reserved. C:\Users\Administrator>cd\ C:\>cd C:\onedev-latest\onedev-latest\bin C:\onedev-latest\onedev-latest\bin>restore-db.bat c:\onedevbackup25 --> Wrapper Started as Console Java Service Wrapper Standard Edition 64-bit 3.5.51 Copyright (C) 1999-2022 Tanuki Software, Ltd. All Rights Reserved. http://wrapper.tanukisoftware.com Licensed to OneDev for Service Wrapping Launching a JVM... WrapperManager: Initializing... WARNING: A restricted method in java.lang.System has been called WARNING: java.lang.System::loadLibrary has been called by org.tanukisoftware.wrapper.WrapperManager in an unnamed module (file:/C:/onedev-latest/onedev-latest/boot/wrapper.jar) WARNING: Use --enable-native-access=ALL-UNNAMED to avoid a warning for callers in this module WARNING: Restricted methods will be blocked in a future release unless native access is enabled Detected that the Java process launched by the Wrapper (PID 2972) was redirected to C:\Program Files\Java\jdk-24\bin\java.exe (PID 3404). Switch to monitoring the Java process. INFO - Launching application from 'C:\onedev-latest\onedev-latest'... INFO - Cleaning temp directory... INFO - Starting application... WARNING: A terminally deprecated method in sun.misc.Unsafe has been called WARNING: sun.misc.Unsafe::objectFieldOffset has been called by com.google.common.util.concurrent.AbstractFuture$UnsafeAtomicHelper (file:/C:/onedev-latest/onedev-latest/lib/com.google.guava.guava-32.0.1-jre.jar) WARNING: Please consider reporting this to the maintainers of class com.google.common.util.concurrent.AbstractFuture$UnsafeAtomicHelper WARNING: sun.misc.Unsafe::objectFieldOffset will be removed in a future release INFO - Restoring database from c:\onedevbackup25... ERROR - Error booting application java.lang.RuntimeException: java.lang.ClassNotFoundException: org.postgresql.driver at io.onedev.commons.bootstrap.Bootstrap.unchecked(Bootstrap.java:319) at io.onedev.commons.utils.ExceptionUtils.unchecked(ExceptionUtils.java:31) at io.onedev.server.persistence.PersistenceUtils.openConnection(PersistenceUtils.java:38) at io.onedev.server.commandhandler.CommandHandler.doMaintenance(CommandHandler.java:34) at io.onedev.server.commandhandler.RestoreDatabase.start(RestoreDatabase.java:67) at io.onedev.commons.loader.DefaultPluginManager.start(DefaultPluginManager.java:44) at io.onedev.commons.loader.AppLoader.start(AppLoader.java:60) at io.onedev.commons.bootstrap.Bootstrap.main(Bootstrap.java:200) at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104) at java.base/java.lang.reflect.Method.invoke(Method.java:565) at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:349) at java.base/java.lang.Thread.run(Thread.java:1447) Caused by: java.lang.ClassNotFoundException: org.postgresql.driver at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:349) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:557) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:490) at java.base/java.lang.Class.forName0(Native Method) at java.base/java.lang.Class.forName(Class.java:543) at io.onedev.server.persistence.PersistenceUtils.openConnection(PersistenceUtils.java:27) ... 9 common frames omitted INFO - Stopping application... <-- Wrapper Stopped Press any key to continue . . . C:\onedev-latest\onedev-latest\bin> -
-
I do not know if it is relevant but in the error I see "org.postgresql.driver" when I think it is "org.postgresql.Driver". If case sensitive could cause an issue?
I went ahead and changed the spelling and the error changed.
-
I changed the config as follows and now get data in the DB but in the wrong schema.
changed as follows:
hibernate.dialect=io.onedev.server.persistence.PostgreSQLDialect
hibernate.connection.driver_class=org.postgresql.Driver hibernate.connection.url=jdbc:postgresql://localhost:5432/onedev?currentschema=onedev hibernate.connection.username=postgres hibernate.connection.password=Brent1969! -
-
The user name
unknownis reserved for other purposes. Please change to use another name. -
Please disregard my previous comment. Please check your hibernate.properties to make sure property
javax.persistence.validation.modeis set tononewhich is the default setting for OneDev. -
Hi thank you, after setting validation mode the database upgrade worked fine. I then also upgraded to the latest Onedev version successfully however when testing I encountered an error with creating a new issue. I received the error below. I had this issue on a previous version and I had to revert to an older version of java, is this the same problem?
HTTP ERROR 500 javax.servlet.ServletException: Filtered request failed. URI: /Form5/~issues/new STATUS: 500 MESSAGE: javax.servlet.ServletException: Filtered request failed. SERVLET: io.onedev.server.web.DefaultWicketServlet-6337a06d CAUSED BY: javax.servlet.ServletException: Filtered request failed. CAUSED BY: BUG! exception in phase 'semantic analysis' in source unit 'Script_6977fe0f2d6cd6a70bb5e589057f6f8c.groovy' Unsupported class file major version 68 CAUSED BY: java.lang.IllegalArgumentException: Unsupported class file major version 68 Caused by: javax.servlet.ServletException: Filtered request failed. at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:392) at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154) at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626) at io.onedev.server.security.CorsFilter.doFilter(CorsFilter.java:47) at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626) at io.onedev.server.jetty.DisableTraceFilter.doFilter(DisableTraceFilter.java:28) at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:552) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1440) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:505) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1355) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:772) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) at org.eclipse.jetty.server.Server.handle(Server.java:516) at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:487) at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:732) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:479) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) at java.base/java.lang.Thread.run(Thread.java:1447) Caused by: BUG! exception in phase 'semantic analysis' in source unit 'Script_6977fe0f2d6cd6a70bb5e589057f6f8c.groovy' Unsupported class file major version 68 at org.codehaus.groovy.control.CompilationUnit$ISourceUnitOperation.doPhaseOperation(CompilationUnit.java:906) at org.codehaus.groovy.control.CompilationUnit.compile(CompilationUnit.java:628) at groovy.lang.GroovyClassLoader.doParseClass(GroovyClassLoader.java:389) at groovy.lang.GroovyClassLoader.lambda$parseClass$3(GroovyClassLoader.java:332) at org.codehaus.groovy.runtime.memoize.StampedCommonCache.compute(StampedCommonCache.java:163) at org.codehaus.groovy.runtime.memoize.StampedCommonCache.getAndPut(StampedCommonCache.java:154) at groovy.lang.GroovyClassLoader.parseClass(GroovyClassLoader.java:330) at groovy.lang.GroovyClassLoader.parseClass(GroovyClassLoader.java:314) at groovy.lang.GroovyClassLoader.parseClass(GroovyClassLoader.java:257) at groovy.lang.GroovyClassLoader.parseClass(GroovyClassLoader.java:268) at io.onedev.server.util.GroovyUtils.compile(GroovyUtils.java:32) at io.onedev.server.util.GroovyUtils.evalScript(GroovyUtils.java:103) at io.onedev.server.buildspecmodel.inputspec.InputSpec.defineClass(InputSpec.java:261) at io.onedev.server.model.support.issue.field.FieldUtils.defineFieldBeanClass(FieldUtils.java:76) at io.onedev.server.model.support.issue.field.FieldUtils.getFieldBeanClass(FieldUtils.java:64) at io.onedev.server.web.component.issue.create.NewIssueEditor.onInitialize(NewIssueEditor.java:108) at org.apache.wicket.Component.fireInitialize(Component.java:883) at org.apache.wicket.MarkupContainer$3.component(MarkupContainer.java:1077) at org.apache.wicket.MarkupContainer$3.component(MarkupContainer.java:1073) at org.apache.wicket.util.visit.Visits.visitChildren(Visits.java:144) at org.apache.wicket.util.visit.Visits.visitChildren(Visits.java:123) at org.apache.wicket.util.visit.Visits.visitChildren(Visits.java:192) at org.apache.wicket.MarkupContainer.visitChildren(MarkupContainer.java:984) at org.apache.wicket.MarkupContainer.internalInitialize(MarkupContainer.java:1072) at org.apache.wicket.MarkupContainer.addedComponent(MarkupContainer.java:1048) at org.apache.wicket.MarkupContainer.add(MarkupContainer.java:242) at io.onedev.server.web.page.project.issues.create.NewIssuePage.onInitialize(NewIssuePage.java:118) at org.apache.wicket.Component.fireInitialize(Component.java:883) at org.apache.wicket.MarkupContainer.internalInitialize(MarkupContainer.java:1071) at org.apache.wicket.Page.isPageStateless(Page.java:465) at org.apache.wicket.core.request.mapper.AbstractBookmarkableMapper.getPageInfo(AbstractBookmarkableMapper.java:498) at org.apache.wicket.core.request.mapper.AbstractBookmarkableMapper.mapHandler(AbstractBookmarkableMapper.java:443) at org.apache.wicket.core.request.mapper.MountedMapper.mapHandler(MountedMapper.java:160) at org.apache.wicket.request.mapper.CompoundRequestMapper.mapHandler(CompoundRequestMapper.java:210) at org.apache.wicket.request.mapper.CompoundRequestMapper.mapHandler(CompoundRequestMapper.java:210) at org.apache.wicket.request.cycle.RequestCycle.mapUrlFor(RequestCycle.java:418) at org.apache.wicket.request.handler.render.WebPageRenderer.respond(WebPageRenderer.java:233) at org.apache.wicket.core.request.handler.RenderPageRequestHandler.respond(RenderPageRequestHandler.java:175) at org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:892) at org.apache.wicket.request.RequestHandlerStack.execute(RequestHandlerStack.java:64) at org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:261) at org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:218) at org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:289) at org.apache.wicket.protocol.ws.AbstractUpgradeFilter.processRequestCycle(AbstractUpgradeFilter.java:70) at org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:203) at org.apache.wicket.protocol.http.WicketServlet.doGet(WicketServlet.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at io.onedev.server.web.DefaultWicketServlet.lambda$service$0(DefaultWicketServlet.java:48) at io.onedev.server.persistence.DefaultSessionManager.lambda$run$0(DefaultSessionManager.java:108) at io.onedev.server.persistence.DefaultSessionManager.call(DefaultSessionManager.java:90) at io.onedev.server.persistence.DefaultSessionManager.run(DefaultSessionManager.java:107) at io.onedev.server.web.DefaultWicketServlet.service(DefaultWicketServlet.java:42) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799) at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1656) at com.google.inject.servlet.DefaultFilterPipeline.dispatch(DefaultFilterPipeline.java:47) at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:133) at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626) at io.onedev.server.git.GoGetFilter.doFilter(GoGetFilter.java:90) at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626) at io.onedev.server.git.GitLfsFilter.doFilter(GitLfsFilter.java:502) at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626) at io.onedev.server.git.GitFilter.doFilter(GitFilter.java:395) at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626) at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154) at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154) at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154) at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:458) at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:373) at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:370) ... 38 more Caused by: java.lang.IllegalArgumentException: Unsupported class file major version 68 at groovyjarjarasm.asm.ClassReader.(ClassReader.java:199) at groovyjarjarasm.asm.ClassReader.(ClassReader.java:180) at groovyjarjarasm.asm.ClassReader.(ClassReader.java:166) at groovyjarjarasm.asm.ClassReader.(ClassReader.java:287) at org.codehaus.groovy.ast.decompiled.AsmDecompiler.parseClass(AsmDecompiler.java:81) at org.codehaus.groovy.control.ClassNodeResolver.findDecompiled(ClassNodeResolver.java:251) at org.codehaus.groovy.control.ClassNodeResolver.tryAsLoaderClassOrScript(ClassNodeResolver.java:189) at org.codehaus.groovy.control.ClassNodeResolver.findClassNode(ClassNodeResolver.java:169) at org.codehaus.groovy.control.ClassNodeResolver.resolveName(ClassNodeResolver.java:125) at org.codehaus.groovy.control.ResolveVisitor.resolveToOuter(ResolveVisitor.java:869) at org.codehaus.groovy.control.ResolveVisitor.resolve(ResolveVisitor.java:506) at org.codehaus.groovy.control.ResolveVisitor.resolve(ResolveVisitor.java:467) at org.codehaus.groovy.control.ResolveVisitor.resolveOrFail(ResolveVisitor.java:337) at org.codehaus.groovy.control.ResolveVisitor.visitClass(ResolveVisitor.java:1456) at org.codehaus.groovy.control.ResolveVisitor.startResolving(ResolveVisitor.java:262) at org.codehaus.groovy.control.CompilationUnit.lambda$new$16(CompilationUnit.java:739) at org.codehaus.groovy.control.CompilationUnit$ISourceUnitOperation.doPhaseOperation(CompilationUnit.java:902) ... 124 more
-
OneDev only supports LTS versions, please use Java 21/17/11 instead.
-
Thank you all is working except a previously mentioned issue OD-2512 .
-
Successfully migrated from MSsql to PostreSQL and upgraded to latest Onedev.
-
Previous Value Current Value Open
Closed
| Type |
Bug
|
| Priority |
Critical
|
| Assignee | |
| Affected Versions |
12.0.4
|
| Labels |
No labels
|
console.log_2.zip