SQL Error, Connection is not available

[mbarbero]

On https://open-vsx.org production instance, we're seeing the following errors on a regular basis:

2021-03-09 12:41:51.852  WARN 1 --- [.0-8080-exec-52] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: null
2021-03-09 12:41:51.852 ERROR 1 --- [.0-8080-exec-52] o.h.engine.jdbc.spi.SqlExceptionHelper   : HikariPool-1 - Connection is not available, request timed out after 30000ms.
2021-03-09 12:41:51.858 ERROR 1 --- [.0-8080-exec-52] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.DataAccessResourceFailureException: Unable to acquire JDBC Connection; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection] with root cause

java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
	at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:695) ~[HikariCP-3.4.5.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197) ~[HikariCP-3.4.5.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162) ~[HikariCP-3.4.5.jar:na]
	at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128) ~[HikariCP-3.4.5.jar:na]
...
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) ~[spring-aop-5.3.1.jar:5.3.1]
	at com.sun.proxy.$Proxy119.findByNameIgnoreCaseAndNamespaceNameIgnoreCase(Unknown Source) ~[na:na]
	at org.eclipse.openvsx.repositories.RepositoryService.findExtension(RepositoryService.java:63) ~[classes/:na]
	at org.eclipse.openvsx.LocalRegistryService.getExtension(LocalRegistryService.java:110) ~[classes/:na]
	at org.eclipse.openvsx.LocalRegistryService$$FastClassBySpringCGLIB$$c162f6fb.invoke(<generated>) ~[classes/:na]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.1.jar:5.3.1]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:687) ~[spring-aop-5.3.1.jar:5.3.1]
	at org.eclipse.openvsx.LocalRegistryService$$EnhancerBySpringCGLIB$$c260c7e0.getExtension(<generated>) ~[classes/:na]
	at org.eclipse.openvsx.RegistryAPI.getExtension(RegistryAPI.java:137) ~[classes/:na]
	at jdk.internal.reflect.GeneratedMethodAccessor110.invoke(Unknown Source) ~[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:566) ~[na:na]
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:197) ~[spring-web-5.3.1.jar:5.3.1]

There is nothing in the log on the postgres side and everthing looks ok.

I found https://stackoverflow.com/a/34198653, could it be something to investigate?

[upward4]

I don't know if it's related, but I can't connect to Open VSX anymore. I can't browse or install extensions. I am using VSCodium.

Update: Actually it appears to be working, but it's very slow, for example when searching for extensions.

[brianking]

Update: Actually it appears to be working, but it's very slow, for example when searching for extensions.

Thanks, we are looking into it.

[mbarbero]

I don't see this one anymore since we've added caching on the LB. Closing