org.artifactory.storage.fs.VfsException: Failed to delete stats from node id 72011

JFrog JIRA | Jay Denebeim | 1 year ago
  1. 0

    Using google cloud storage when trying to delete some test files I get the following traps: org.artifactory.storage.fs.VfsException: Failed to delete stats from node id 72011 at org.artifactory.storage.db.fs.service.InternalStatsServiceImpl.deleteStats(InternalStatsServiceImpl.java:149) ~[artifactory-storage-db-4.1.0.jar:na] at org.artifactory.storage.service.StatsServiceImpl.deleteStats(StatsServiceImpl.java:78) ~[artifactory-core-4.1.0.jar:na] at org.artifactory.storage.db.fs.model.DbMutableFile.doDeleteInternal(DbMutableFile.java:187) ~[artifactory-storage-db-4.1.0.jar:na] at org.artifactory.storage.db.fs.model.DbMutableItem.save(DbMutableItem.java:214) ~[artifactory-storage-db-4.1.0.jar:na] at org.artifactory.storage.fs.lock.SessionLockEntry.save(SessionLockEntry.java:72) ~[artifactory-storage-common-4.1.0.jar:na] at org.artifactory.storage.db.fs.session.SqlStorageSession.save(SqlStorageSession.java:66) ~[artifactory-storage-db-4.1.0.jar:na] at org.artifactory.storage.db.spring.SessionSynchronization.beforeCommit(SessionSynchronization.java:77) ~[artifactory-storage-db-4.1.0.jar:na] at org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:95) ~[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:928) ~[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:740) ~[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:726) ~[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:521) ~[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291) ~[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) ~[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE] at org.artifactory.storage.fs.lock.aop.LockingAdvice.invoke(LockingAdvice.java:64) ~[artifactory-storage-common-4.1.0.jar:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) ~[spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE] at com.sun.proxy.$Proxy47.undeploy(Unknown Source) ~[na:na] at org.artifactory.ui.rest.service.artifacts.browse.treebrowser.actions.DeleteArtifactService.deleteArtifact(DeleteArtifactService.java:60) ~[artifactory-rest-ui-4.1.0.jar:na] at org.artifactory.ui.rest.service.artifacts.browse.treebrowser.actions.DeleteArtifactService.execute(DeleteArtifactService.java:34) ~[artifactory-rest-ui-4.1.0.jar:na] at org.artifactory.ui.rest.service.ServiceExecutor.process(ServiceExecutor.java:21) ~[artifactory-rest-ui-4.1.0.jar:na] at org.artifactory.ui.rest.resource.BaseResource.runService(BaseResource.java:76) ~[artifactory-rest-ui-4.1.0.jar:na] at org.artifactory.ui.rest.resource.artifacts.browse.treebrowser.actions.ArtifactActionsResource.deleteArtifact(ArtifactActionsResource.java:104) ~[artifactory-rest-ui-4.1.0.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_51] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_51] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_51] at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_51] at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) ~[jersey-server-1.19.jar:1.19] at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) ~[jersey-server-1.19.jar:1.19] at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) ~[jersey-server-1.19.jar:1.19] at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) ~[jersey-server-1.19.jar:1.19] at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) ~[jersey-server-1.19.jar:1.19] at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) ~[jersey-server-1.19.jar:1.19] at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) ~[jersey-server-1.19.jar:1.19] at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) ~[jersey-server-1.19.jar:1.19] at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542) [jersey-server-1.19.jar:1.19] at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473) [jersey-server-1.19.jar:1.19] at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419) [jersey-server-1.19.jar:1.19] at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409) [jersey-server-1.19.jar:1.19] at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409) [jersey-servlet-1.19.jar:1.19] at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558) [jersey-servlet-1.19.jar:1.19] at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733) [jersey-servlet-1.19.jar:1.19] at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) [servlet-api.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291) [catalina.jar:8.0.22] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.22] at org.artifactory.webapp.servlet.RepoFilter.execute(RepoFilter.java:208) [artifactory-web-application-4.1.0.jar:na] at org.artifactory.webapp.servlet.RepoFilter.doFilter(RepoFilter.java:95) [artifactory-web-application-4.1.0.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.22] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.22] at org.artifactory.webapp.servlet.AccessFilter.useAuthentication(AccessFilter.java:329) [artifactory-web-application-4.1.0.jar:na] at org.artifactory.webapp.servlet.AccessFilter.doFilterInternal(AccessFilter.java:195) [artifactory-web-application-4.1.0.jar:na] at org.artifactory.webapp.servlet.AccessFilter.doFilter(AccessFilter.java:155) [artifactory-web-application-4.1.0.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.22] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.22] at org.artifactory.webapp.servlet.RequestFilter.doFilter(RequestFilter.java:67) [artifactory-web-application-4.1.0.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.22] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.22] at org.artifactory.webapp.servlet.ArtifactoryFilter.doFilter(ArtifactoryFilter.java:116) [artifactory-web-application-4.1.0.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.22] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.22] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) [catalina.jar:8.0.22] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) [catalina.jar:8.0.22] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142) [catalina.jar:8.0.22] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) [catalina.jar:8.0.22] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) [catalina.jar:8.0.22] at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:673) [catalina.jar:8.0.22] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518) [catalina.jar:8.0.22] at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091) [tomcat-coyote.jar:8.0.22] at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:668) [tomcat-coyote.jar:8.0.22] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1521) [tomcat-coyote.jar:8.0.22] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1478) [tomcat-coyote.jar:8.0.22] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_51] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_51] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.0.22] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_51] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'artdb.stats_remote' doesn't exist at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_51] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_51] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_51] at java.lang.reflect.Constructor.newInstance(Constructor.java:422) ~[na:1.8.0_51] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.Util.getInstance(Util.java:386) ~[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) ~[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) ~[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) ~[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) ~[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) ~[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) ~[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) ~[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2459) ~[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2376) ~[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2360) ~[mysql-connector-java-5.1.27.jar:na] at org.artifactory.storage.db.util.JdbcHelper.executeUpdate(JdbcHelper.java:131) ~[artifactory-storage-db-4.1.0.jar:na] at org.artifactory.storage.db.fs.dao.StatsDao.deleteRemoteStats(StatsDao.java:159) ~[artifactory-storage-db-4.1.0.jar:na] at org.artifactory.storage.db.fs.dao.StatsDao.deleteStats(StatsDao.java:228) ~[artifactory-storage-db-4.1.0.jar:na] at org.artifactory.storage.db.fs.service.InternalStatsServiceImpl.deleteStats(InternalStatsServiceImpl.java:146) ~[artifactory-storage-db-4.1.0.jar:na] ... 74 common frames omitted

    JFrog JIRA | 1 year ago | Jay Denebeim
    org.artifactory.storage.fs.VfsException: Failed to delete stats from node id 72011
  2. 0

    Using google cloud storage when trying to delete some test files I get the following traps: org.artifactory.storage.fs.VfsException: Failed to delete stats from node id 72011 at org.artifactory.storage.db.fs.service.InternalStatsServiceImpl.deleteStats(InternalStatsServiceImpl.java:149) ~[artifactory-storage-db-4.1.0.jar:na] at org.artifactory.storage.service.StatsServiceImpl.deleteStats(StatsServiceImpl.java:78) ~[artifactory-core-4.1.0.jar:na] at org.artifactory.storage.db.fs.model.DbMutableFile.doDeleteInternal(DbMutableFile.java:187) ~[artifactory-storage-db-4.1.0.jar:na] at org.artifactory.storage.db.fs.model.DbMutableItem.save(DbMutableItem.java:214) ~[artifactory-storage-db-4.1.0.jar:na] at org.artifactory.storage.fs.lock.SessionLockEntry.save(SessionLockEntry.java:72) ~[artifactory-storage-common-4.1.0.jar:na] at org.artifactory.storage.db.fs.session.SqlStorageSession.save(SqlStorageSession.java:66) ~[artifactory-storage-db-4.1.0.jar:na] at org.artifactory.storage.db.spring.SessionSynchronization.beforeCommit(SessionSynchronization.java:77) ~[artifactory-storage-db-4.1.0.jar:na] at org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:95) ~[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:928) ~[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:740) ~[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:726) ~[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:521) ~[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291) ~[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) ~[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE] at org.artifactory.storage.fs.lock.aop.LockingAdvice.invoke(LockingAdvice.java:64) ~[artifactory-storage-common-4.1.0.jar:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) ~[spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE] at com.sun.proxy.$Proxy47.undeploy(Unknown Source) ~[na:na] at org.artifactory.ui.rest.service.artifacts.browse.treebrowser.actions.DeleteArtifactService.deleteArtifact(DeleteArtifactService.java:60) ~[artifactory-rest-ui-4.1.0.jar:na] at org.artifactory.ui.rest.service.artifacts.browse.treebrowser.actions.DeleteArtifactService.execute(DeleteArtifactService.java:34) ~[artifactory-rest-ui-4.1.0.jar:na] at org.artifactory.ui.rest.service.ServiceExecutor.process(ServiceExecutor.java:21) ~[artifactory-rest-ui-4.1.0.jar:na] at org.artifactory.ui.rest.resource.BaseResource.runService(BaseResource.java:76) ~[artifactory-rest-ui-4.1.0.jar:na] at org.artifactory.ui.rest.resource.artifacts.browse.treebrowser.actions.ArtifactActionsResource.deleteArtifact(ArtifactActionsResource.java:104) ~[artifactory-rest-ui-4.1.0.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_51] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_51] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_51] at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_51] at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) ~[jersey-server-1.19.jar:1.19] at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) ~[jersey-server-1.19.jar:1.19] at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) ~[jersey-server-1.19.jar:1.19] at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) ~[jersey-server-1.19.jar:1.19] at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) ~[jersey-server-1.19.jar:1.19] at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) ~[jersey-server-1.19.jar:1.19] at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) ~[jersey-server-1.19.jar:1.19] at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) ~[jersey-server-1.19.jar:1.19] at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542) [jersey-server-1.19.jar:1.19] at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473) [jersey-server-1.19.jar:1.19] at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419) [jersey-server-1.19.jar:1.19] at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409) [jersey-server-1.19.jar:1.19] at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409) [jersey-servlet-1.19.jar:1.19] at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558) [jersey-servlet-1.19.jar:1.19] at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733) [jersey-servlet-1.19.jar:1.19] at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) [servlet-api.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291) [catalina.jar:8.0.22] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.22] at org.artifactory.webapp.servlet.RepoFilter.execute(RepoFilter.java:208) [artifactory-web-application-4.1.0.jar:na] at org.artifactory.webapp.servlet.RepoFilter.doFilter(RepoFilter.java:95) [artifactory-web-application-4.1.0.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.22] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.22] at org.artifactory.webapp.servlet.AccessFilter.useAuthentication(AccessFilter.java:329) [artifactory-web-application-4.1.0.jar:na] at org.artifactory.webapp.servlet.AccessFilter.doFilterInternal(AccessFilter.java:195) [artifactory-web-application-4.1.0.jar:na] at org.artifactory.webapp.servlet.AccessFilter.doFilter(AccessFilter.java:155) [artifactory-web-application-4.1.0.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.22] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.22] at org.artifactory.webapp.servlet.RequestFilter.doFilter(RequestFilter.java:67) [artifactory-web-application-4.1.0.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.22] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.22] at org.artifactory.webapp.servlet.ArtifactoryFilter.doFilter(ArtifactoryFilter.java:116) [artifactory-web-application-4.1.0.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) [catalina.jar:8.0.22] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:8.0.22] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) [catalina.jar:8.0.22] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) [catalina.jar:8.0.22] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142) [catalina.jar:8.0.22] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) [catalina.jar:8.0.22] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) [catalina.jar:8.0.22] at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:673) [catalina.jar:8.0.22] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518) [catalina.jar:8.0.22] at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091) [tomcat-coyote.jar:8.0.22] at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:668) [tomcat-coyote.jar:8.0.22] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1521) [tomcat-coyote.jar:8.0.22] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1478) [tomcat-coyote.jar:8.0.22] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_51] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_51] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.0.22] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_51] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'artdb.stats_remote' doesn't exist at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_51] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_51] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_51] at java.lang.reflect.Constructor.newInstance(Constructor.java:422) ~[na:1.8.0_51] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.Util.getInstance(Util.java:386) ~[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) ~[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) ~[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) ~[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) ~[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) ~[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) ~[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) ~[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2459) ~[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2376) ~[mysql-connector-java-5.1.27.jar:na] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2360) ~[mysql-connector-java-5.1.27.jar:na] at org.artifactory.storage.db.util.JdbcHelper.executeUpdate(JdbcHelper.java:131) ~[artifactory-storage-db-4.1.0.jar:na] at org.artifactory.storage.db.fs.dao.StatsDao.deleteRemoteStats(StatsDao.java:159) ~[artifactory-storage-db-4.1.0.jar:na] at org.artifactory.storage.db.fs.dao.StatsDao.deleteStats(StatsDao.java:228) ~[artifactory-storage-db-4.1.0.jar:na] at org.artifactory.storage.db.fs.service.InternalStatsServiceImpl.deleteStats(InternalStatsServiceImpl.java:146) ~[artifactory-storage-db-4.1.0.jar:na] ... 74 common frames omitted

    JFrog JIRA | 1 year ago | Jay Denebeim
    org.artifactory.storage.fs.VfsException: Failed to delete stats from node id 72011
  3. 0

    SQL exception & stacktrace

    GitHub | 3 years ago | mibby
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

    Stack Overflow | 3 years ago | CODE FISH
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'testspring.user' doesn't exist
  6. 0

    How to auto generate tables using Hibernate and MySQL using Java based configuration.

    Stack Overflow | 2 years ago | Adio
    org.hibernate.exception.SQLGrammarException: could not execute statement

  1. dafman 2 times, last 2 months ago
  2. somasundaram 1 times, last 3 months ago
  3. tvrmsmith 1 times, last 4 months ago
  4. Seungwan 1 times, last 5 months ago
  5. Kialandei 1 times, last 1 week ago
27 more registered users
66 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

    Table 'artdb.stats_remote' doesn't exist

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[na:1.8.0_51]
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[na:1.8.0_51]
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[na:1.8.0_51]
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:422)[na:1.8.0_51]
    4 frames
  3. MySQL jdbc
    PreparedStatement.executeUpdate
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:411)[mysql-connector-java-5.1.27.jar:na]
    2. com.mysql.jdbc.Util.getInstance(Util.java:386)[mysql-connector-java-5.1.27.jar:na]
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)[mysql-connector-java-5.1.27.jar:na]
    4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)[mysql-connector-java-5.1.27.jar:na]
    5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)[mysql-connector-java-5.1.27.jar:na]
    6. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)[mysql-connector-java-5.1.27.jar:na]
    7. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)[mysql-connector-java-5.1.27.jar:na]
    8. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)[mysql-connector-java-5.1.27.jar:na]
    9. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)[mysql-connector-java-5.1.27.jar:na]
    10. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2459)[mysql-connector-java-5.1.27.jar:na]
    11. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2376)[mysql-connector-java-5.1.27.jar:na]
    12. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2360)[mysql-connector-java-5.1.27.jar:na]
    12 frames
  4. org.artifactory.storage
    SessionSynchronization.beforeCommit
    1. org.artifactory.storage.db.util.JdbcHelper.executeUpdate(JdbcHelper.java:131)[artifactory-storage-db-4.1.0.jar:na]
    2. org.artifactory.storage.db.fs.dao.StatsDao.deleteRemoteStats(StatsDao.java:159)[artifactory-storage-db-4.1.0.jar:na]
    3. org.artifactory.storage.db.fs.dao.StatsDao.deleteStats(StatsDao.java:228)[artifactory-storage-db-4.1.0.jar:na]
    4. org.artifactory.storage.db.fs.service.InternalStatsServiceImpl.deleteStats(InternalStatsServiceImpl.java:146)[artifactory-storage-db-4.1.0.jar:na]
    5. org.artifactory.storage.service.StatsServiceImpl.deleteStats(StatsServiceImpl.java:78)[artifactory-core-4.1.0.jar:na]
    6. org.artifactory.storage.db.fs.model.DbMutableFile.doDeleteInternal(DbMutableFile.java:187)[artifactory-storage-db-4.1.0.jar:na]
    7. org.artifactory.storage.db.fs.model.DbMutableItem.save(DbMutableItem.java:214)[artifactory-storage-db-4.1.0.jar:na]
    8. org.artifactory.storage.fs.lock.SessionLockEntry.save(SessionLockEntry.java:72)[artifactory-storage-common-4.1.0.jar:na]
    9. org.artifactory.storage.db.fs.session.SqlStorageSession.save(SqlStorageSession.java:66)[artifactory-storage-db-4.1.0.jar:na]
    10. org.artifactory.storage.db.spring.SessionSynchronization.beforeCommit(SessionSynchronization.java:77)[artifactory-storage-db-4.1.0.jar:na]
    10 frames
  5. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:95)[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    2. org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:928)[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    3. org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:740)[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    4. org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:726)[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    5. org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:521)[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    6. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    7. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)[spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    7 frames
  6. org.artifactory.storage
    LockingAdvice.invoke
    1. org.artifactory.storage.fs.lock.aop.LockingAdvice.invoke(LockingAdvice.java:64)[artifactory-storage-common-4.1.0.jar:na]
    1 frame
  7. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)[spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)[spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
    2 frames
  8. com.sun.proxy
    $Proxy47.undeploy
    1. com.sun.proxy.$Proxy47.undeploy(Unknown Source)[na:na]
    1 frame
  9. org.artifactory.ui
    ArtifactActionsResource.deleteArtifact
    1. org.artifactory.ui.rest.service.artifacts.browse.treebrowser.actions.DeleteArtifactService.deleteArtifact(DeleteArtifactService.java:60)[artifactory-rest-ui-4.1.0.jar:na]
    2. org.artifactory.ui.rest.service.artifacts.browse.treebrowser.actions.DeleteArtifactService.execute(DeleteArtifactService.java:34)[artifactory-rest-ui-4.1.0.jar:na]
    3. org.artifactory.ui.rest.service.ServiceExecutor.process(ServiceExecutor.java:21)[artifactory-rest-ui-4.1.0.jar:na]
    4. org.artifactory.ui.rest.resource.BaseResource.runService(BaseResource.java:76)[artifactory-rest-ui-4.1.0.jar:na]
    5. org.artifactory.ui.rest.resource.artifacts.browse.treebrowser.actions.ArtifactActionsResource.deleteArtifact(ArtifactActionsResource.java:104)[artifactory-rest-ui-4.1.0.jar:na]
    5 frames
  10. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.8.0_51]
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)[na:1.8.0_51]
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.8.0_51]
    4. java.lang.reflect.Method.invoke(Method.java:497)[na:1.8.0_51]
    4 frames
  11. Jersey
    WebApplicationImpl.handleRequest
    1. com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)[jersey-server-1.19.jar:1.19]
    2. com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)[jersey-server-1.19.jar:1.19]
    3. com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)[jersey-server-1.19.jar:1.19]
    4. com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)[jersey-server-1.19.jar:1.19]
    5. com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)[jersey-server-1.19.jar:1.19]
    6. com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)[jersey-server-1.19.jar:1.19]
    7. com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)[jersey-server-1.19.jar:1.19]
    8. com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)[jersey-server-1.19.jar:1.19]
    9. com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)[jersey-server-1.19.jar:1.19]
    10. com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)[jersey-server-1.19.jar:1.19]
    11. com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)[jersey-server-1.19.jar:1.19]
    12. com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)[jersey-server-1.19.jar:1.19]
    12 frames
  12. Jersey
    ServletContainer.service
    1. com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)[jersey-servlet-1.19.jar:1.19]
    2. com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)[jersey-servlet-1.19.jar:1.19]
    3. com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)[jersey-servlet-1.19.jar:1.19]
    3 frames
  13. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:729)[servlet-api.jar:na]
    1 frame
  14. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)[catalina.jar:8.0.22]
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)[catalina.jar:8.0.22]
    2 frames
  15. org.artifactory.webapp
    RepoFilter.doFilter
    1. org.artifactory.webapp.servlet.RepoFilter.execute(RepoFilter.java:208)[artifactory-web-application-4.1.0.jar:na]
    2. org.artifactory.webapp.servlet.RepoFilter.doFilter(RepoFilter.java:95)[artifactory-web-application-4.1.0.jar:na]
    2 frames
  16. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)[catalina.jar:8.0.22]
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)[catalina.jar:8.0.22]
    2 frames
  17. org.artifactory.webapp
    AccessFilter.doFilter
    1. org.artifactory.webapp.servlet.AccessFilter.useAuthentication(AccessFilter.java:329)[artifactory-web-application-4.1.0.jar:na]
    2. org.artifactory.webapp.servlet.AccessFilter.doFilterInternal(AccessFilter.java:195)[artifactory-web-application-4.1.0.jar:na]
    3. org.artifactory.webapp.servlet.AccessFilter.doFilter(AccessFilter.java:155)[artifactory-web-application-4.1.0.jar:na]
    3 frames
  18. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)[catalina.jar:8.0.22]
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)[catalina.jar:8.0.22]
    2 frames
  19. org.artifactory.webapp
    RequestFilter.doFilter
    1. org.artifactory.webapp.servlet.RequestFilter.doFilter(RequestFilter.java:67)[artifactory-web-application-4.1.0.jar:na]
    1 frame
  20. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)[catalina.jar:8.0.22]
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)[catalina.jar:8.0.22]
    2 frames
  21. org.artifactory.webapp
    ArtifactoryFilter.doFilter
    1. org.artifactory.webapp.servlet.ArtifactoryFilter.doFilter(ArtifactoryFilter.java:116)[artifactory-web-application-4.1.0.jar:na]
    1 frame
  22. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)[catalina.jar:8.0.22]
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)[catalina.jar:8.0.22]
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)[catalina.jar:8.0.22]
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)[catalina.jar:8.0.22]
    5. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)[catalina.jar:8.0.22]
    6. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)[catalina.jar:8.0.22]
    7. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)[catalina.jar:8.0.22]
    8. org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:673)[catalina.jar:8.0.22]
    9. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)[catalina.jar:8.0.22]
    9 frames
  23. Grizzly HTTP
    NioEndpoint$SocketProcessor.run
    1. org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)[tomcat-coyote.jar:8.0.22]
    2. org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:668)[tomcat-coyote.jar:8.0.22]
    3. org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1521)[tomcat-coyote.jar:8.0.22]
    4. org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1478)[tomcat-coyote.jar:8.0.22]
    4 frames
  24. Java RT
    ThreadPoolExecutor$Worker.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)[na:1.8.0_51]
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)[na:1.8.0_51]
    2 frames
  25. Tomcat Util
    TaskThread$WrappingRunnable.run
    1. org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)[tomcat-util.jar:8.0.22]
    1 frame
  26. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)[na:1.8.0_51]
    1 frame