HTTP Status 500 - Could not execute search query for username='anonymous'

type Exception report

message Could not execute search query for username='anonymous'

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.springframework.security.authentication.AuthenticationServiceException: Could not execute search query for username='anonymous'
	org.springframework.security.authentication.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:109)
	org.springframework.security.authentication.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:132)
	org.artifactory.security.db.DbAuthenticationProvider.authenticate(DbAuthenticationProvider.java:49)
	org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:156)
	org.artifactory.security.RealmAwareAuthenticationManager.authenticate(RealmAwareAuthenticationManager.java:68)
	org.artifactory.webapp.servlet.AccessFilter.useAnonymousIfPossible(AccessFilter.java:350)
	org.artifactory.webapp.servlet.AccessFilter.doFilterInternal(AccessFilter.java:207)
	org.artifactory.webapp.servlet.AccessFilter.doFilter(AccessFilter.java:165)
	org.artifactory.webapp.servlet.RequestFilter.doFilter(RequestFilter.java:67)
	org.springframework.session.web.http.SessionRepositoryFilter.doFilterInternal(SessionRepositoryFilter.java:164)
	org.springframework.session.web.http.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:80)
	org.artifactory.webapp.servlet.SessionFilter.doFilter(SessionFilter.java:62)
	org.artifactory.webapp.servlet.ArtifactoryFilter.doFilter(ArtifactoryFilter.java:116)

root cause

org.artifactory.storage.StorageException: Could not execute search query for username='anonymous'
	org.artifactory.storage.db.security.service.UserGroupStoreServiceImpl.findUser(UserGroupStoreServiceImpl.java:181)
	org.artifactory.storage.db.security.service.UserGroupStoreServiceImpl.findUser(UserGroupStoreServiceImpl.java:159)
	sun.reflect.GeneratedMethodAccessor177.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
	com.sun.proxy.$Proxy139.findUser(Unknown Source)
	org.artifactory.security.db.DbUserDetailsService.loadUserByUsername(DbUserDetailsService.java:46)
	org.springframework.security.authentication.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:101)
	org.springframework.security.authentication.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:132)
	org.artifactory.security.db.DbAuthenticationProvider.authenticate(DbAuthenticationProvider.java:49)
	org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:156)
	org.artifactory.security.RealmAwareAuthenticationManager.authenticate(RealmAwareAuthenticationManager.java:68)
	org.artifactory.webapp.servlet.AccessFilter.useAnonymousIfPossible(AccessFilter.java:350)
	org.artifactory.webapp.servlet.AccessFilter.doFilterInternal(AccessFilter.java:207)
	org.artifactory.webapp.servlet.AccessFilter.doFilter(AccessFilter.java:165)
	org.artifactory.webapp.servlet.RequestFilter.doFilter(RequestFilter.java:67)
	org.springframework.session.web.http.SessionRepositoryFilter.doFilterInternal(SessionRepositoryFilter.java:164)
	org.springframework.session.web.http.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:80)
	org.artifactory.webapp.servlet.SessionFilter.doFilter(SessionFilter.java:62)
	org.artifactory.webapp.servlet.ArtifactoryFilter.doFilter(ArtifactoryFilter.java:116)

root cause

java.sql.SQLException: Failed to start database '/opt/jfrog/artifactory/data/derby' with class loader java.net.URLClassLoader@e9e54c2, see the next exception for details.
	org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
	org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
	org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
	org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
	org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
	org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown Source)
	org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
	org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
	org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
	org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:307)
	org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:200)
	org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:711)
	org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:645)
	org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:187)
	org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
	org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	org.artifactory.storage.db.util.JdbcHelper.getConnection(JdbcHelper.java:120)
	org.artifactory.storage.db.util.JdbcHelper.executeSelect(JdbcHelper.java:151)
	org.artifactory.storage.db.util.JdbcHelper.executeSelect(JdbcHelper.java:132)
	org.artifactory.storage.db.security.dao.UserGroupsDao.findUserByName(UserGroupsDao.java:342)
	org.artifactory.storage.db.security.dao.UserGroupsDao.findUserByName(UserGroupsDao.java:326)
	org.artifactory.storage.db.security.service.UserGroupStoreServiceImpl.findUser(UserGroupStoreServiceImpl.java:165)
	org.artifactory.storage.db.security.service.UserGroupStoreServiceImpl.findUser(UserGroupStoreServiceImpl.java:159)
	sun.reflect.GeneratedMethodAccessor177.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
	com.sun.proxy.$Proxy139.findUser(Unknown Source)
	org.artifactory.security.db.DbUserDetailsService.loadUserByUsername(DbUserDetailsService.java:46)
	org.springframework.security.authentication.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:101)
	org.springframework.security.authentication.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:132)
	org.artifactory.security.db.DbAuthenticationProvider.authenticate(DbAuthenticationProvider.java:49)
	org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:156)
	org.artifactory.security.RealmAwareAuthenticationManager.authenticate(RealmAwareAuthenticationManager.java:68)
	org.artifactory.webapp.servlet.AccessFilter.useAnonymousIfPossible(AccessFilter.java:350)
	org.artifactory.webapp.servlet.AccessFilter.doFilterInternal(AccessFilter.java:207)
	org.artifactory.webapp.servlet.AccessFilter.doFilter(AccessFilter.java:165)
	org.artifactory.webapp.servlet.RequestFilter.doFilter(RequestFilter.java:67)
	org.springframework.session.web.http.SessionRepositoryFilter.doFilterInternal(SessionRepositoryFilter.java:164)
	org.springframework.session.web.http.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:80)
	org.artifactory.webapp.servlet.SessionFilter.doFilter(SessionFilter.java:62)
	org.artifactory.webapp.servlet.ArtifactoryFilter.doFilter(ArtifactoryFilter.java:116)

root cause

ERROR XJ040: Failed to start database '/opt/jfrog/artifactory/data/derby' with class loader java.net.URLClassLoader@e9e54c2, see the next exception for details.
	org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
	org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source)
	org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
	org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
	org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
	org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
	org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
	org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown Source)
	org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
	org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
	org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
	org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:307)
	org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:200)
	org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:711)
	org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:645)
	org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:187)
	org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
	org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	org.artifactory.storage.db.util.JdbcHelper.getConnection(JdbcHelper.java:120)
	org.artifactory.storage.db.util.JdbcHelper.executeSelect(JdbcHelper.java:151)
	org.artifactory.storage.db.util.JdbcHelper.executeSelect(JdbcHelper.java:132)
	org.artifactory.storage.db.security.dao.UserGroupsDao.findUserByName(UserGroupsDao.java:342)
	org.artifactory.storage.db.security.dao.UserGroupsDao.findUserByName(UserGroupsDao.java:326)
	org.artifactory.storage.db.security.service.UserGroupStoreServiceImpl.findUser(UserGroupStoreServiceImpl.java:165)
	org.artifactory.storage.db.security.service.UserGroupStoreServiceImpl.findUser(UserGroupStoreServiceImpl.java:159)
	sun.reflect.GeneratedMethodAccessor177.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
	com.sun.proxy.$Proxy139.findUser(Unknown Source)
	org.artifactory.security.db.DbUserDetailsService.loadUserByUsername(DbUserDetailsService.java:46)
	org.springframework.security.authentication.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:101)
	org.springframework.security.authentication.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:132)
	org.artifactory.security.db.DbAuthenticationProvider.authenticate(DbAuthenticationProvider.java:49)
	org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:156)
	org.artifactory.security.RealmAwareAuthenticationManager.authenticate(RealmAwareAuthenticationManager.java:68)
	org.artifactory.webapp.servlet.AccessFilter.useAnonymousIfPossible(AccessFilter.java:350)
	org.artifactory.webapp.servlet.AccessFilter.doFilterInternal(AccessFilter.java:207)
	org.artifactory.webapp.servlet.AccessFilter.doFilter(AccessFilter.java:165)
	org.artifactory.webapp.servlet.RequestFilter.doFilter(RequestFilter.java:67)
	org.springframework.session.web.http.SessionRepositoryFilter.doFilterInternal(SessionRepositoryFilter.java:164)
	org.springframework.session.web.http.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:80)
	org.artifactory.webapp.servlet.SessionFilter.doFilter(SessionFilter.java:62)
	org.artifactory.webapp.servlet.ArtifactoryFilter.doFilter(ArtifactoryFilter.java:116)

root cause

java.io.IOException: Transport endpoint is not connected
	java.io.UnixFileSystem.canonicalize0(Native Method)
	java.io.UnixFileSystem.canonicalize(UnixFileSystem.java:172)
	java.io.File.getCanonicalPath(File.java:618)
	org.apache.derby.impl.io.DirStorageFactory.doInit(Unknown Source)
	org.apache.derby.impl.io.BaseStorageFactory.init(Unknown Source)
	org.apache.derby.impl.io.DirStorageFactory.init(Unknown Source)
	org.apache.derby.impl.services.monitor.StorageFactoryService.privGetStorageFactoryInstance(Unknown Source)
	org.apache.derby.impl.services.monitor.StorageFactoryService.access$400(Unknown Source)
	org.apache.derby.impl.services.monitor.StorageFactoryService$12.run(Unknown Source)
	org.apache.derby.impl.services.monitor.StorageFactoryService$12.run(Unknown Source)
	java.security.AccessController.doPrivileged(Native Method)
	org.apache.derby.impl.services.monitor.StorageFactoryService.getCanonicalServiceName(Unknown Source)
	org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source)
	org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source)
	org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)
	org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
	org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
	org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown Source)
	org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
	org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
	org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
	org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:307)
	org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:200)
	org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:711)
	org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:645)
	org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:187)
	org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
	org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	org.artifactory.storage.db.util.JdbcHelper.getConnection(JdbcHelper.java:120)
	org.artifactory.storage.db.util.JdbcHelper.executeSelect(JdbcHelper.java:151)
	org.artifactory.storage.db.util.JdbcHelper.executeSelect(JdbcHelper.java:132)
	org.artifactory.storage.db.security.dao.UserGroupsDao.findUserByName(UserGroupsDao.java:342)
	org.artifactory.storage.db.security.dao.UserGroupsDao.findUserByName(UserGroupsDao.java:326)
	org.artifactory.storage.db.security.service.UserGroupStoreServiceImpl.findUser(UserGroupStoreServiceImpl.java:165)
	org.artifactory.storage.db.security.service.UserGroupStoreServiceImpl.findUser(UserGroupStoreServiceImpl.java:159)
	sun.reflect.GeneratedMethodAccessor177.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
	com.sun.proxy.$Proxy139.findUser(Unknown Source)
	org.artifactory.security.db.DbUserDetailsService.loadUserByUsername(DbUserDetailsService.java:46)
	org.springframework.security.authentication.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:101)
	org.springframework.security.authentication.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:132)
	org.artifactory.security.db.DbAuthenticationProvider.authenticate(DbAuthenticationProvider.java:49)
	org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:156)
	org.artifactory.security.RealmAwareAuthenticationManager.authenticate(RealmAwareAuthenticationManager.java:68)
	org.artifactory.webapp.servlet.AccessFilter.useAnonymousIfPossible(AccessFilter.java:350)
	org.artifactory.webapp.servlet.AccessFilter.doFilterInternal(AccessFilter.java:207)
	org.artifactory.webapp.servlet.AccessFilter.doFilter(AccessFilter.java:165)
	org.artifactory.webapp.servlet.RequestFilter.doFilter(RequestFilter.java:67)
	org.springframework.session.web.http.SessionRepositoryFilter.doFilterInternal(SessionRepositoryFilter.java:164)
	org.springframework.session.web.http.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:80)
	org.artifactory.webapp.servlet.SessionFilter.doFilter(SessionFilter.java:62)
	org.artifactory.webapp.servlet.ArtifactoryFilter.doFilter(ArtifactoryFilter.java:116)

note The full stack trace of the root cause is available in the Apache Tomcat/8.0.41 logs.


Apache Tomcat/8.0.41