Uploaded image for project: 'Runtime'
  1. Runtime
  2. RUNTIME-3188

Ametys should not go to safe mode when a datasource is broken

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Fixed
    • Icon: Critical Critical
    • 4.3.0
    • None
    • None
    • None
    • 4.3 M2
    • 2 - Long term
    • 2 - Normal

      Il faudrait enlever le blocage de l'application en cas de problème sur la vérification Apogée au démarrage et juste mettre un warning.

      Un problème Apogée ne devrait pas empêcher Ametys de se lancer.

          [RUNTIME-3188] Ametys should not go to safe mode when a datasource is broken

          Adélaïde Palacios (Inactive) added a comment - - edited

          I get this stacktrace on my local platform, when i am not connected to the VPN (so Apogee isn't accessible) :

          Date: Thu Jan 02 16:28:50 CET 2020 (1577978930302)Date: Thu Jan 02 16:28:50 CET 2020 (1577978930302)Thread: mainMessage #: 370Level: ERRORNDC: Category: org.ametys.runtime.plugin.PluginsManagerMessage: Caught an exception loading components.Location: org.ametys.runtime.plugin.PluginsManager.init(PluginsManager.java:457)Thrown:java.lang.Exception: Caught an exception trying to initialize the component org.ametys.core.ui.RibbonControlsManager at org.ametys.runtime.plugin.component.ThreadSafeComponentManager.initialize(ThreadSafeComponentManager.java:212) at org.ametys.runtime.plugin.PluginsManager.init(PluginsManager.java:453) at org.ametys.runtime.cocoon.TreeProcessor.compose(TreeProcessor.java:49) at org.apache.avalon.framework.container.ContainerUtil.compose(ContainerUtil.java:174) at org.apache.avalon.excalibur.component.DefaultComponentFactory.newInstance(DefaultComponentFactory.java:266) at org.apache.avalon.excalibur.component.ThreadSafeComponentHandler.initialize(ThreadSafeComponentHandler.java:108) at org.apache.avalon.excalibur.component.ExcaliburComponentManager.initialize(ExcaliburComponentManager.java:524) at org.apache.cocoon.components.CocoonComponentManager.initialize(CocoonComponentManager.java:583) at org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:245) at org.apache.cocoon.Cocoon.initialize(Cocoon.java:345) at org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:245) at org.ametys.runtime.servlet.RuntimeServlet._createCocoon(RuntimeServlet.java:357) at org.ametys.runtime.servlet.RuntimeServlet._initAmetys(RuntimeServlet.java:291) at org.ametys.runtime.servlet.RuntimeServlet.init(RuntimeServlet.java:214) at javax.servlet.GenericServlet.init(GenericServlet.java:158) at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1122) at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1077) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:971) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4868) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5177) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:717) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:690) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:631) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1831) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:118) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:526) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:425) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1576) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:309) at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123) at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423) at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:936) at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909) at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.startup.Catalina.start(Catalina.java:633) 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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:344) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:475)Caused by: java.lang.Exception: Caught an exception trying to initialize the component org.ametys.web.publication.schedule at org.ametys.runtime.plugin.component.ThreadSafeComponentManager.initialize(ThreadSafeComponentManager.java:212) at org.ametys.runtime.plugin.component.AbstractThreadSafeComponentExtensionPoint.initializeExtensions(AbstractThreadSafeComponentExtensionPoint.java:96) at org.ametys.core.ui.AbstractClientSideExtensionPoint.initializeExtensions(AbstractClientSideExtensionPoint.java:216) at org.ametys.runtime.plugin.component.PluginsComponentManager$ExtensionPointFactory.newInstance(PluginsComponentManager.java:219) at org.ametys.runtime.plugin.component.PluginsComponentManager$ExtensionPointFactory.newInstance(PluginsComponentManager.java:186) at org.ametys.runtime.plugin.component.ThreadSafeComponentManager.initialize(ThreadSafeComponentManager.java:206) ... 58 moreCaused by: org.apache.avalon.framework.service.ServiceException: Unable to initialize component org.ametys.plugins.core.schedule.Scheduler (key [org.ametys.plugins.core.schedule.Scheduler]) (Key='org.ametys.plugins.core.schedule.Scheduler') at org.apache.avalon.framework.service.WrapperServiceManager.lookup(WrapperServiceManager.java:81) at org.ametys.web.clientsideelement.ScheduledPageClientSideElement.service(ScheduledPageClientSideElement.java:62) at org.apache.avalon.framework.container.ContainerUtil.service(ContainerUtil.java:144) at org.ametys.runtime.plugin.component.ThreadSafeComponentManager$ComponentFactory.configureAndStart(ThreadSafeComponentManager.java:357) at org.ametys.runtime.plugin.component.ThreadSafeComponentManager$ComponentFactory.newInstance(ThreadSafeComponentManager.java:378) at org.ametys.runtime.plugin.component.ThreadSafeComponentManager.initialize(ThreadSafeComponentManager.java:206) ... 63 moreCaused by: org.apache.avalon.framework.component.ComponentException: Unable to initialize component org.ametys.plugins.core.schedule.Scheduler (key [org.ametys.plugins.core.schedule.Scheduler]) at org.ametys.runtime.plugin.component.ThreadSafeComponentManager.lookup(ThreadSafeComponentManager.java:142) at org.ametys.runtime.plugin.component.PluginsComponentManager.lookup(PluginsComponentManager.java:74) at org.apache.avalon.framework.service.WrapperServiceManager.lookup(WrapperServiceManager.java:69) ... 68 moreCaused by: org.apache.avalon.framework.service.ServiceException: Unable to initialize component org.ametys.core.datasource.SQLDataSourceManager (key [org.ametys.core.datasource.SQLDataSourceManager]) (Key='org.ametys.core.datasource.SQLDataSourceManager') at org.apache.avalon.framework.service.WrapperServiceManager.lookup(WrapperServiceManager.java:81) at org.ametys.plugins.core.schedule.Scheduler.service(Scheduler.java:169) at org.apache.avalon.framework.container.ContainerUtil.service(ContainerUtil.java:144) at org.ametys.runtime.plugin.component.ThreadSafeComponentManager$ComponentFactory.configureAndStart(ThreadSafeComponentManager.java:357) at org.ametys.runtime.plugin.component.PluginsComponentManager$ProxyComponentFactory.newInstance(PluginsComponentManager.java:156) at org.ametys.runtime.plugin.component.PluginsComponentManager$ProxyComponentFactory.newInstance(PluginsComponentManager.java:121) at org.ametys.runtime.plugin.component.ThreadSafeComponentManager.lookup(ThreadSafeComponentManager.java:138) ... 70 moreCaused by: org.apache.avalon.framework.component.ComponentException: Unable to initialize component org.ametys.core.datasource.SQLDataSourceManager (key [org.ametys.core.datasource.SQLDataSourceManager]) at org.ametys.runtime.plugin.component.ThreadSafeComponentManager.lookup(ThreadSafeComponentManager.java:142) at org.ametys.runtime.plugin.component.PluginsComponentManager.lookup(PluginsComponentManager.java:74) at org.apache.avalon.framework.service.WrapperServiceManager.lookup(WrapperServiceManager.java:69) ... 76 moreCaused by: org.ametys.runtime.model.checker.ItemCheckerTestFailureException: Erreur d'E/S: The Network Adapter could not establish the connection at org.ametys.plugins.core.impl.checker.SQLConnectionChecker.check(SQLConnectionChecker.java:62) at org.ametys.core.datasource.SQLDataSourceManager.checkParameters(SQLDataSourceManager.java:403) at org.ametys.core.datasource.AbstractDataSourceManager.initialize(AbstractDataSourceManager.java:110) at org.ametys.core.datasource.SQLDataSourceManager.initialize(SQLDataSourceManager.java:230) at org.ametys.core.datasource.SQLDataSourceManager.initialize(SQLDataSourceManager.java:242) at org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:245) at org.ametys.runtime.plugin.component.ThreadSafeComponentManager$ComponentFactory.configureAndStart(ThreadSafeComponentManager.java:367) at org.ametys.runtime.plugin.component.PluginsComponentManager$ProxyComponentFactory.newInstance(PluginsComponentManager.java:156) at org.ametys.runtime.plugin.component.PluginsComponentManager$ProxyComponentFactory.newInstance(PluginsComponentManager.java:121) at org.ametys.runtime.plugin.component.ThreadSafeComponentManager.lookup(ThreadSafeComponentManager.java:138) ... 78 moreCaused by: java.sql.SQLRecoverableException: Erreur d'E/S: The Network Adapter could not establish the connection at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:743) at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:666) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:566) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228) at org.ametys.plugins.core.impl.checker.SQLConnectionChecker.check(SQLConnectionChecker.java:58) ... 87 moreCaused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:470) at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:506) at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:595) at oracle.net.ns.NSProtocol.connect(NSProtocol.java:230) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1452) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:496) ... 93 moreCaused by: java.net.ConnectException: Connection refused: connect at java.base/java.net.PlainSocketImpl.waitForConnect(Native Method) at java.base/java.net.PlainSocketImpl.socketConnect(PlainSocketImpl.java:107) at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:399) at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:242) at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:224) at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403) at java.base/java.net.Socket.connect(Socket.java:591) at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:161) at oracle.net.nt.ConnOption.connect(ConnOption.java:159) at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:428) ... 98 more

          Adélaïde Palacios (Inactive) added a comment - - edited I get this stacktrace on my local platform, when i am not connected to the VPN (so Apogee isn't accessible) : Date: Thu Jan 02 16:28:50 CET 2020 (1577978930302)Date: Thu Jan 02 16:28:50 CET 2020 (1577978930302) Thread : mainMessage #: 370Level: ERRORNDC: Category: org.ametys.runtime.plugin.PluginsManagerMessage: Caught an exception loading components.Location: org.ametys.runtime.plugin.PluginsManager.init(PluginsManager.java:457)Thrown:java.lang.Exception: Caught an exception trying to initialize the component org.ametys.core.ui.RibbonControlsManager at org.ametys.runtime.plugin.component.ThreadSafeComponentManager.initialize(ThreadSafeComponentManager.java:212) at org.ametys.runtime.plugin.PluginsManager.init(PluginsManager.java:453) at org.ametys.runtime.cocoon.TreeProcessor.compose(TreeProcessor.java:49) at org.apache.avalon.framework.container.ContainerUtil.compose(ContainerUtil.java:174) at org.apache.avalon.excalibur.component.DefaultComponentFactory.newInstance(DefaultComponentFactory.java:266) at org.apache.avalon.excalibur.component.ThreadSafeComponentHandler.initialize(ThreadSafeComponentHandler.java:108) at org.apache.avalon.excalibur.component.ExcaliburComponentManager.initialize(ExcaliburComponentManager.java:524) at org.apache.cocoon.components.CocoonComponentManager.initialize(CocoonComponentManager.java:583) at org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:245) at org.apache.cocoon.Cocoon.initialize(Cocoon.java:345) at org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:245) at org.ametys.runtime.servlet.RuntimeServlet._createCocoon(RuntimeServlet.java:357) at org.ametys.runtime.servlet.RuntimeServlet._initAmetys(RuntimeServlet.java:291) at org.ametys.runtime.servlet.RuntimeServlet.init(RuntimeServlet.java:214) at javax.servlet.GenericServlet.init(GenericServlet.java:158) at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1122) at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1077) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:971) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4868) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5177) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:717) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:690) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:631) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1831) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:118) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:526) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:425) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1576) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:309) at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123) at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423) at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:936) at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140) at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909) at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) at org.apache.catalina.startup.Catalina.start(Catalina.java:633) 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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:344) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:475)Caused by: java.lang.Exception: Caught an exception trying to initialize the component org.ametys.web.publication.schedule at org.ametys.runtime.plugin.component.ThreadSafeComponentManager.initialize(ThreadSafeComponentManager.java:212) at org.ametys.runtime.plugin.component.AbstractThreadSafeComponentExtensionPoint.initializeExtensions(AbstractThreadSafeComponentExtensionPoint.java:96) at org.ametys.core.ui.AbstractClientSideExtensionPoint.initializeExtensions(AbstractClientSideExtensionPoint.java:216) at org.ametys.runtime.plugin.component.PluginsComponentManager$ExtensionPointFactory.newInstance(PluginsComponentManager.java:219) at org.ametys.runtime.plugin.component.PluginsComponentManager$ExtensionPointFactory.newInstance(PluginsComponentManager.java:186) at org.ametys.runtime.plugin.component.ThreadSafeComponentManager.initialize(ThreadSafeComponentManager.java:206) ... 58 moreCaused by: org.apache.avalon.framework.service.ServiceException: Unable to initialize component org.ametys.plugins.core.schedule.Scheduler (key [org.ametys.plugins.core.schedule.Scheduler]) (Key= 'org.ametys.plugins.core.schedule.Scheduler' ) at org.apache.avalon.framework.service.WrapperServiceManager.lookup(WrapperServiceManager.java:81) at org.ametys.web.clientsideelement.ScheduledPageClientSideElement.service(ScheduledPageClientSideElement.java:62) at org.apache.avalon.framework.container.ContainerUtil.service(ContainerUtil.java:144) at org.ametys.runtime.plugin.component.ThreadSafeComponentManager$ComponentFactory.configureAndStart(ThreadSafeComponentManager.java:357) at org.ametys.runtime.plugin.component.ThreadSafeComponentManager$ComponentFactory.newInstance(ThreadSafeComponentManager.java:378) at org.ametys.runtime.plugin.component.ThreadSafeComponentManager.initialize(ThreadSafeComponentManager.java:206) ... 63 moreCaused by: org.apache.avalon.framework.component.ComponentException: Unable to initialize component org.ametys.plugins.core.schedule.Scheduler (key [org.ametys.plugins.core.schedule.Scheduler]) at org.ametys.runtime.plugin.component.ThreadSafeComponentManager.lookup(ThreadSafeComponentManager.java:142) at org.ametys.runtime.plugin.component.PluginsComponentManager.lookup(PluginsComponentManager.java:74) at org.apache.avalon.framework.service.WrapperServiceManager.lookup(WrapperServiceManager.java:69) ... 68 moreCaused by: org.apache.avalon.framework.service.ServiceException: Unable to initialize component org.ametys.core.datasource.SQLDataSourceManager (key [org.ametys.core.datasource.SQLDataSourceManager]) (Key= 'org.ametys.core.datasource.SQLDataSourceManager' ) at org.apache.avalon.framework.service.WrapperServiceManager.lookup(WrapperServiceManager.java:81) at org.ametys.plugins.core.schedule.Scheduler.service(Scheduler.java:169) at org.apache.avalon.framework.container.ContainerUtil.service(ContainerUtil.java:144) at org.ametys.runtime.plugin.component.ThreadSafeComponentManager$ComponentFactory.configureAndStart(ThreadSafeComponentManager.java:357) at org.ametys.runtime.plugin.component.PluginsComponentManager$ProxyComponentFactory.newInstance(PluginsComponentManager.java:156) at org.ametys.runtime.plugin.component.PluginsComponentManager$ProxyComponentFactory.newInstance(PluginsComponentManager.java:121) at org.ametys.runtime.plugin.component.ThreadSafeComponentManager.lookup(ThreadSafeComponentManager.java:138) ... 70 moreCaused by: org.apache.avalon.framework.component.ComponentException: Unable to initialize component org.ametys.core.datasource.SQLDataSourceManager (key [org.ametys.core.datasource.SQLDataSourceManager]) at org.ametys.runtime.plugin.component.ThreadSafeComponentManager.lookup(ThreadSafeComponentManager.java:142) at org.ametys.runtime.plugin.component.PluginsComponentManager.lookup(PluginsComponentManager.java:74) at org.apache.avalon.framework.service.WrapperServiceManager.lookup(WrapperServiceManager.java:69) ... 76 moreCaused by: org.ametys.runtime.model.checker.ItemCheckerTestFailureException: Erreur d 'E/S: The Network Adapter could not establish the connection at org.ametys.plugins.core.impl.checker.SQLConnectionChecker.check(SQLConnectionChecker.java:62) at org.ametys.core.datasource.SQLDataSourceManager.checkParameters(SQLDataSourceManager.java:403) at org.ametys.core.datasource.AbstractDataSourceManager.initialize(AbstractDataSourceManager.java:110) at org.ametys.core.datasource.SQLDataSourceManager.initialize(SQLDataSourceManager.java:230) at org.ametys.core.datasource.SQLDataSourceManager.initialize(SQLDataSourceManager.java:242) at org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:245) at org.ametys.runtime.plugin.component.ThreadSafeComponentManager$ComponentFactory.configureAndStart(ThreadSafeComponentManager.java:367) at org.ametys.runtime.plugin.component.PluginsComponentManager$ProxyComponentFactory.newInstance(PluginsComponentManager.java:156) at org.ametys.runtime.plugin.component.PluginsComponentManager$ProxyComponentFactory.newInstance(PluginsComponentManager.java:121) at org.ametys.runtime.plugin.component.ThreadSafeComponentManager.lookup(ThreadSafeComponentManager.java:138) ... 78 moreCaused by: java.sql.SQLRecoverableException: Erreur d' E/S: The Network Adapter could not establish the connection at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:743) at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:666) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:566) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228) at org.ametys.plugins.core.impl.checker.SQLConnectionChecker.check(SQLConnectionChecker.java:58) ... 87 moreCaused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:470) at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:506) at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:595) at oracle.net.ns.NSProtocol.connect(NSProtocol.java:230) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1452) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:496) ... 93 moreCaused by: java.net.ConnectException: Connection refused: connect at java.base/java.net.PlainSocketImpl.waitForConnect(Native Method) at java.base/java.net.PlainSocketImpl.socketConnect(PlainSocketImpl.java:107) at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:399) at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:242) at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:224) at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403) at java.base/java.net.Socket.connect(Socket.java:591) at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:161) at oracle.net.nt.ConnOption.connect(ConnOption.java:159) at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:428) ... 98 more

          Laurence Aumeunier added a comment -

          Nop, Apogee export use a WS url and to do not use Apogee datasource.
          Could you please join the full stack trace ?

          Laurence Aumeunier added a comment - Nop, Apogee export use a WS url and to do not use Apogee datasource. Could you please join the full stack trace ?

          Bérénice Maurel added a comment -

          I'm surprised, I think the Apogée datasource is maybe also used for export. And this in general configuration.

          Bérénice Maurel added a comment - I'm surprised, I think the Apogée datasource is maybe also used for export. And this in general configuration.

          Adélaïde Palacios (Inactive) added a comment -

          Tested on 4.3 latest snapshot (23/12/2019), when Apogee is not accessible, application starts in safe mode

          Adélaïde Palacios (Inactive) added a comment - Tested on 4.3 latest snapshot (23/12/2019), when Apogee is not accessible, application starts in safe mode

          Laurence Aumeunier added a comment - - edited

          All datasource consumer should anwser if a datasource is in use in a blocking or a non blocking way.

          For configuration parameters, a datasource is in use in a blocking way (ie. need to go in safe mode) only if the parameter is mandatory. Otherwise a warning in logs is enought.

          A datasource used in a synchronizable collection as Apogee should never block the application if it is invalid.

          Laurence Aumeunier added a comment - - edited All datasource consumer should anwser if a datasource is in use in a blocking or a non blocking way. For configuration parameters, a datasource is in use in a blocking way (ie. need to go in safe mode) only if the parameter is mandatory. Otherwise a warning in logs is enought. A datasource used in a synchronizable collection as Apogee should never block the application if it is invalid.

          Raphaël Franchet added a comment -

          When the datasource is used by non mandatory stuff... Ametys could start normally and work as if the datasource was not set

          Raphaël Franchet added a comment - When the datasource is used by non mandatory stuff... Ametys could start normally and work as if the datasource was not set

          Adélaïde Palacios (Inactive) added a comment - - edited

          Au démarrage de l'application si une source de donnée est innaccessible comme Apogée, l'application démarre en mode sans echec et il est impossible d'acceder au cms. Un simple warning serait suffisant.

          Adélaïde Palacios (Inactive) added a comment - - edited Au démarrage de l'application si une source de donnée est innaccessible comme Apogée, l'application démarre en mode sans echec et il est impossible d'acceder au cms. Un simple warning serait suffisant.

          Raphaël Franchet added a comment -

          c quoi comme pb qui te bloque ?

          t'as une trace stp ?

          Raphaël Franchet added a comment - c quoi comme pb qui te bloque ? t'as une trace stp ?

            adelaide Adélaïde Palacios (Inactive)
            adelaide Adélaïde Palacios (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: