[OSGeoLive] #2366: 52NorthSOS fails to launch

OSGeoLive trac_osgeolive at osgeo.org
Sat Jun 18 21:53:18 PDT 2022 

#2366: 52NorthSOS fails to launch
-----------------------+---------------------------
 Reporter:  sanak      |      Owner:  osgeolive@…
     Type:  defect     |     Status:  new
 Priority:  normal     |  Milestone:  OSGeoLive15.0
Component:  OSGeoLive  |   Keywords:  52North
-----------------------+---------------------------
 From /var/log/tomcat9/52n-sos-webapp.log.
 {{{
 2022-06-18 22:35:56,764 ERROR [main] [SqlExceptionHelper.java:146]
 Connections could not be acquired from the underlying database!
 2022-06-18 22:35:56,769 ERROR [main]
 [UnspecifiedSessionFactoryProvider.java:157] An error occurs during
 instantiation of the database connection pool!
 org.hibernate.exception.GenericJDBCException: Could not open connection
         at
 org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
         at
 org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
         at
 org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
         at
 org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:235)
         at
 org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:171)
         at
 org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:311)
         at
 org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2095)
         at
 org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2080)
         at
 org.n52.sos.ds.hibernate.UnspecifiedSessionFactoryProvider.initialize(UnspecifiedSessionFactoryProvider.java:146)
         at
 org.n52.sos.service.Configurator.initializeConnectionProviders(Configurator.java:625)
         at
 org.n52.sos.service.Configurator.initialize(Configurator.java:326)
         at
 org.n52.sos.service.Configurator.createInstance(Configurator.java:150)
         at
 org.n52.sos.service.SosContextListener.instantiateConfigurator(SosContextListener.java:169)
         at
 org.n52.sos.service.SosContextListener.instantiateConfigurator(SosContextListener.java:158)
         at
 org.n52.sos.service.SosContextListener.contextInitialized(SosContextListener.java:69)
         at
 org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4768)
         at
 org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5230)
         at
 org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
         at
 org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:726)
         at
 org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:698)
         at
 org.apache.catalina.core.StandardHost.addChild(StandardHost.java:696)
         at
 org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1024)
         at
 org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1911)
         at
 java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
         at java.util.concurrent.FutureTask.run(FutureTask.java:266)
         at
 org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
         at
 java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:112)
         at
 org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:825)
         at
 org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:475)
         at
 org.apache.catalina.startup.HostConfig.start(HostConfig.java:1618)
         at
 org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:319)
         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:946)
         at
 org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:835)
         at
 org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
         at
 org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1396)
         at
 org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1386)
         at java.util.concurrent.FutureTask.run(FutureTask.java:266)
         at
 org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
         at
 java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134)
         at
 org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:919)
         at
 org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:263)
         at
 org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
         at
 org.apache.catalina.core.StandardService.startInternal(StandardService.java:432)
         at
 org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
         at
 org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:927)
         at
 org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
         at org.apache.catalina.startup.Catalina.start(Catalina.java:772)
         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         at
 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
         at
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         at java.lang.reflect.Method.invoke(Method.java:498)
         at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:345)
         at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:480)
 Caused by: java.sql.SQLException: Connections could not be acquired from
 the underlying database!
         at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
         at
 com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692)
         at
 com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
         at
 org.hibernate.c3p0.internal.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:90)
         at
 org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:380)
         at
 org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:228)
         ... 52 common frames omitted
 Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A
 ResourcePool could not acquire a resource from its primary factory or
 source.
         at
 com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1469)
         at
 com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
         at
 com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)
         at
 com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
         at
 com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)
         ... 56 common frames omitted
 Caused by: org.postgresql.util.PSQLException: SCRAM authentication is not
 supported by this driver. You need JDK >= 8 and pgjdbc >= 42.2.0 (not
 ".jre" vesions)
         at
 org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:623)
         at
 org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:205)
         at
 org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
         at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
         at org.postgresql.Driver.makeConnection(Driver.java:452)
         at org.postgresql.Driver.connect(Driver.java:254)
         at
 com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
         at
 com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
         at
 com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
         at
 com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
         at
 com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
         at
 com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
         at
 com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
         at
 com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
         at
 com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
 }}}

 There are warning before above error.
 {{{
 2022-06-18 22:35:56,761 WARN
 [C3P0PooledConnectionPoolManager[identityToken->z8kfsxapxsrajw1cs5u4|5733fb1d]-HelperThread-#1]
 [BasicResourcePool.java:1911]
 com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask at 2269c95d
 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying
 to acquire a needed new resource, we failed to succeed more than the
 maximum number of allowed acquisition attempts (30). Last acquisition
 attempt exception:
 org.postgresql.util.PSQLException: SCRAM authentication is not supported
 by this driver. You need JDK >= 8 and pgjdbc >= 42.2.0 (not ".jre"
 vesions)
         at
 org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:623)
         at
 org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:205)
         at
 org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
         at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
         at org.postgresql.Driver.makeConnection(Driver.java:452)
         at org.postgresql.Driver.connect(Driver.java:254)
         at
 com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
         at
 com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
         at
 com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
         at
 com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
         at
 com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
         at
 com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
         at
 com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
         at
 com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
         at
 com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
 2022-06-18 22:35:56,761 WARN
 [C3P0PooledConnectionPoolManager[identityToken->z8kfsxapxsrajw1cs5u4|5733fb1d]-HelperThread-#1]
 [BasicResourcePool.java:946] Having failed to acquire a resource,
 com.mchange.v2.resourcepool.BasicResourcePool at 185efb0e is interrupting all
 Threads waiting on a resource to check out. Will try again in response to
 new client requests.
 2022-06-18 22:35:56,763 WARN [main] [SqlExceptionHelper.java:144] SQL
 Error: 0, SQLState: null
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/osgeolive/ticket/2366>
OSGeoLive <https://live.osgeo.org/>
self-contained bootable DVD, USB thumb drive or Virtual Machine based on Lubuntu, that allows you to try a wide variety of open source geospatial software without installing anything.

More information about the osgeolive mailing list