Not able to connect to remote mysql database on windows server 2022 (OD-1926)
crotella opened 2 years ago

Not able to connect to remote mySql database, get the following error

io.onedev.commons.utils.ExplicitException: Invalid servers detected in cluster: loopback address should not be used at io.onedev.server.ee.clustering.DefaultClusterManager.start(DefaultClusterManager.java:164) at io.onedev.server.OneDev.start(OneDev.java:140) 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.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:349) at java.base/java.lang.Thread.run(Thread.java:834)

is there some configuration i need to setup

Thank You,

  • Robin Shen commented 2 years ago

    Please remove all rows in table o_ClusterServer and try again.

  • crotella commented 2 years ago
    Got passed that error, 

    now have this error


    Launching a JVM...
    WrapperManager: Initializing...
    Detected that the Java process launched by the Wrapper (PID 13948) was redirected to C:\Program Files\Java\jdk-11\bin\java.exe (PID 5836).
     Switch to monitoring the Java process.
    08:54:30 INFO  i.onedev.commons.bootstrap.Bootstrap - Launching application from 'C:\OneDev\onedev-latest'...
    08:54:30 INFO  i.onedev.commons.bootstrap.Bootstrap - Cleaning temp directory...
    08:54:31 INFO  io.onedev.commons.loader.AppLoader - Starting application...
    08:54:59 INFO  io.onedev.agent.ExecutorUtils - Checking Windows OS version...
    08:54:59 INFO  io.onedev.agent.ExecutorUtils - Windows OS version: 10.0.20348
    08:55:00 ERROR i.onedev.commons.bootstrap.Bootstrap - Error booting application
    java.lang.RuntimeException: java.lang.reflect.InvocationTargetException
    at io.onedev.server.event.Listener.notify(Listener.java:21)
    at io.onedev.server.event.DefaultListenerRegistry.invokeListeners(DefaultListenerRegistry.java:103)
    at io.onedev.server.event.DefaultListenerRegistry.post(DefaultListenerRegistry.java:153)
    at io.onedev.server.persistence.TransactionInterceptor$1.call(TransactionInterceptor.java:23)
    at io.onedev.server.persistence.DefaultTransactionManager.lambda$call$0(DefaultTransactionManager.java:66)
    at io.onedev.server.persistence.DefaultSessionManager.call(DefaultSessionManager.java:90)
    at io.onedev.server.persistence.DefaultTransactionManager.call(DefaultTransactionManager.java:57)
    at io.onedev.server.persistence.TransactionInterceptor.invoke(TransactionInterceptor.java:18)
    at io.onedev.server.OneDev.lambda$start$2(OneDev.java:160)
    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.OneDev.start(OneDev.java:160)
    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.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:349)
    at java.base/java.lang.Thread.run(Thread.java:834)
    Caused by: java.lang.reflect.InvocationTargetException: null
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at io.onedev.server.event.Listener.notify(Listener.java:19)
    ... 21 common frames omitted
    Caused by: 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.Loader.loadFromResultSet(Loader.java:1870)
    at org.hibernate.loader.Loader.hydrateEntityState(Loader.java:1798)
    at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1771)
    at org.hibernate.loader.Loader.getRow(Loader.java:1623)
    at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:740)
    at org.hibernate.loader.Loader.getRowsFromResultSet(Loader.java:1039)
    at org.hibernate.loader.Loader.processResultSet(Loader.java:990)
    at org.hibernate.loader.Loader.doQuery(Loader.java:959)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349)
    at org.hibernate.loader.Loader.doList(Loader.java:2850)
    at org.hibernate.loader.Loader.doList(Loader.java:2832)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2664)
    at org.hibernate.loader.Loader.list(Loader.java:2659)
    at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:109)
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1877)
    at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:370)
    at io.onedev.server.persistence.dao.DefaultDao.query(DefaultDao.java:68)
    at io.onedev.server.persistence.SessionInterceptor$1.call(SessionInterceptor.java:23)
    at io.onedev.server.persistence.DefaultSessionManager.call(DefaultSessionManager.java:90)
    at io.onedev.server.persistence.SessionInterceptor.invoke(SessionInterceptor.java:18)
    at io.onedev.server.persistence.dao.DefaultDao.query(DefaultDao.java:109)
    at io.onedev.server.persistence.SessionInterceptor$1.call(SessionInterceptor.java:23)
    at io.onedev.server.persistence.DefaultSessionManager.call(DefaultSessionManager.java:90)
    at io.onedev.server.persistence.SessionInterceptor.invoke(SessionInterceptor.java:18)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at com.google.inject.internal.DelegatingInvocationHandler.invoke(DelegatingInvocationHandler.java:50)
    at com.sun.proxy.$Proxy29.query(Unknown Source)
    at io.onedev.server.persistence.dao.BaseEntityManager.query(BaseEntityManager.java:60)
    at io.onedev.server.persistence.dao.BaseEntityManager.query(BaseEntityManager.java:65)
    at io.onedev.server.entitymanager.impl.DefaultSettingManager.on(DefaultSettingManager.java:58)
    at io.onedev.server.persistence.SessionInterceptor$1.call(SessionInterceptor.java:23)
    at io.onedev.server.persistence.DefaultSessionManager.call(DefaultSessionManager.java:90)
    at io.onedev.server.persistence.SessionInterceptor.invoke(SessionInterceptor.java:18)
    ... 26 common frames omitted
    Caused by: java.io.StreamCorruptedException: invalid stream header: C2ACC3AD
    at java.base/java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:947)
    at java.base/java.io.ObjectInputStream.<init>(ObjectInputStream.java:386)
    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)
    ... 73 common frames omitted
    08:55:00 INFO  io.onedev.commons.loader.AppLoader - Stopping application...
    <-- Wrapper Stopped
  • Robin Shen commented 2 years ago

    Seems that your database is corrupted. You may need to restore from a backup.

  • crotella commented 2 years ago
    ok thank you,
    will try that
  • Robin Shen changed state to 'Closed' 2 years ago
    Previous Value Current Value
    Open
    Closed
issue 1/1
Type
Bug
Priority
Major
Assignee
Affected Versions
latest
Labels
No labels
Issue Votes (0)
Watchers (2)
Reference
OD-1926
Please wait...
Connection lost or session expired, reload to recover
Page is in error, reload to recover