java.sql.SQLException: Got error -1 from storage engine

Jenkins JIRA | jpschewe | 8 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    CONFLUENCE System Error A system error has occurred - our apologies! Please contact your Confluence administrator to create a support issue on our support system at http://support.atlassian.com with the following information: 1. a description of your problem and what you were doing at the time it occurred 2. cut & paste the error and system information found below 3. attach the application server log file (if possible). We will respond as promptly as possible. Thank you! Cause: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute query; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1030]; Got error -1 from storage engine; nested exception is java.sql.SQLException: Got error -1 from storage engine at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:120) caused by: java.sql.SQLException: Got error -1 from storage engine at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) Stack Trace: [hide] org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute query; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1030]; Got error -1 from storage engine; nested exception is java.sql.SQLException: Got error -1 from storage engine Caused by: java.sql.SQLException: Got error -1 from storage engine at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:440) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) at net.sf.hibernate.loader.Loader.doList(Loader.java:1063) at net.sf.hibernate.loader.Loader.list(Loader.java:1048) at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49) at com.atlassian.hibernate.HibernateObjectDao$5.doInHibernate(HibernateObjectDao.java:351) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370) at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:341) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:329) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:314) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:294) at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.getPage(HibernatePageDao.java:97) at com.atlassian.confluence.pages.DefaultPageManager.getPage(DefaultPageManager.java:133) at sun.reflect.GeneratedMethodAccessor401.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) at com.atlassian.spring.interceptors.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:20) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy15.getPage(Unknown Source) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.getPageFromKeyAndTitle(PageAwareInterceptor.java:183) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.getPage(PageAwareInterceptor.java:134) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:54) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.spaces.actions.SpaceAwareInterceptor.intercept(SpaceAwareInterceptor.java:67) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.core.actions.LastModifiedInterceptor.intercept(LastModifiedInterceptor.java:39) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.xwork.interceptors.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:97) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:229) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:199) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292) at com.atlassian.confluence.servlet.simpledisplay.SimpleDisplayServlet.service(SimpleDisplayServlet.java:59) at com.atlassian.confluence.servlet.SpringManagedServlet.service(SpringManagedServlet.java:64) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:141) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:54) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.jmx.JmxFilter.doFilter(JmxFilter.java:109) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.ServletContextThreadLocalFilter.doFilter(ServletContextThreadLocalFilter.java:21) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.util.LoggingContextFilter.doFilter(LoggingContextFilter.java:49) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.util.UserThreadLocalFilter.doFilter(UserThreadLocalFilter.java:44) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:192) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:114) at com.atlassian.confluence.util.AbstractBootstrapHotSwappingFilter.doFilter(AbstractBootstrapHotSwappingFilter.java:28) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:110) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.util.ClusterHeaderFilter.doFilter(ClusterHeaderFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:170) at com.atlassian.spring.filter.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:29) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:142) at com.atlassian.core.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:27) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.core.datetime.RequestTimeThreadLocalFilter.doFilter(RequestTimeThreadLocalFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.util.RequestCacheThreadLocalFilter.doFilter(RequestCacheThreadLocalFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:94) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:64) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:33) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:619) Referer URL: Unknown Build Information: home: /export/kohsuke/confluence/data buildNumber: 1322 upTime: 26 days, 20 hours, 57 minutes, 17 seconds devMode: false version: 2.8.1 Unique ID: 0x000001200AE076D7C01231851BE51C323B9E227F86915977CDD4E6D96D362A2B Server Information: Application Server: Apache Tomcat/6.0.13 Servlet Version: 2.5 Database Dialect: com.atlassian.hibernate.dialect.MySQLDialect Database Driver Name: com.mysql.jdbc.Driver Database Driver Version: 5.1 Database Name: MySQL Database Version: 5.0.51 Database Transaction Isolation: Repeatable read Database Latency: 0 Memory Information: Total Memory: 448 MB Used Memory: 337 MB Free Memory: 111 MB System Information: favouriteColour: Myrtle javaRuntime: Java(TM) SE Runtime Environment jvmVersion: 1.0 operatingSystem: SunOS 5.10 fileSystemEncoding: ISO646-US javaVm: Java HotSpot(TM) Server VM javaVendor: Sun Microsystems Inc. userTimezone: US/Pacific jvmImplementationVersion: 10.0-b22 appServer: Apache Tomcat date: Sunday, 15 Mar 2009 time: 09:04:25 jvmVendor: Sun Microsystems Inc. userName: kohsuke javaVersion: 1.6.0_06 operatingSystemArchitecture: x86 Cluster Information: Not clustered. Enabled Plugins: Confluence Attachments Plugin (confluence.extra.attachments, Version: 2.10) JIRA Macros (confluence.extra.jira, Version: 2.7) Social Bookmarking Plugin (com.atlassian.confluence.plugins.socialbookmarking, Version: 1.1.1) Admin Sections (confluence.sections.admin, Version: 1.0) Chart Plugin (confluence.extra.chart, Version: 1.9.1) System Web Resources (confluence.web.resources, Version: 1.0) Left Navigation Theme (com.atlassian.confluence.themes.leftnavigation, Version: 2.0-rc1) Confluence Remote API (confluence.extra.confluencerpc, Version: 2.8.1) Page Operations (confluence.sections.page.operations, Version: 1.0) Space Browse Sections (confluence.sections.space.browse, Version: 1.0) Core Path Converters (confluence.converters.core, Version: 1.0) Advanced Macros (confluence.macros.advanced, Version: 1.3) Code Macro (confluence.macros.code, Version: 1.4) User Menu Sections (confluence.user.menu, Version: 1.0) TinyMCE Editor Plugin (com.atlassian.confluence.extra.tinymceplugin, Version: 3.0-rc1) Add Content Menu Sections (confluence.menu.add, Version: 1.0) Table of Contents Plugin (org.randombits.confluence.toc, Version: 2.4.5) Confluence Atlassian Plugin Repository (confluence.repository.client, Version: 2.0.13) Confluence Classic Theme (com.atlassian.confluence.themes.classic, Version: 2.0-rc1) Default Theme (com.atlassian.confluence.themes.default, Version: 1.0) Page Tabs (confluence.search.mappers.lucene, Version: 1.0) Wiki Renderer Components (confluence.renderer.components, Version: 1.0) Space Advanced Sections (confluence.sections.space.advanced, Version: 1.0) Clickr Theme (com.atlassian.confluence.themes.clickr, Version: 2.0-rc1) Attachment Actions (confluence.sections.attachments, Version: 1.0) IM Presence NG Plugin (confluence.extra.impresence2, Version: 2.1) WebDAV Plugin (confluence.extra.webdav, Version: 1.1) Space Labels Sections (confluence.sections.space.labels, Version: 1.0) Space Actions Sections (confluence.sections.space.actions, Version: 1.0) Information Macros (confluence.extra.information, Version: 1.0) Content Buttons (confluence.sections.page.temp, Version: 1.0) Live Search Macros (confluence.extra.livesearch, Version: 2.6) Global Labels Sections (confluence.sections.labels, Version: 1.0) Page View Links (confluence.sections.page.actions, Version: 1.0) Space Admin Sections (confluence.sections.space.admin, Version: 1.0) Core Listeners (confluence.listeners.core, Version: 1.3) Content Action Menu Sections (confluence.content.action.menu, Version: 1.0) Space Item Tabs (confluence.sections.space, Version: 1.0) Space Pages Sections (confluence.sections.space.pages, Version: 1.0) Page Tabs (confluence.sections.page, Version: 1.0) BloggingRPC (com.atlassian.confluence.plugins.xmlrpc.bloggingrpc, Version: 1.2.2) Attachment Extractors (confluence.extractors.attachments, Version: 1.4) German language pack (confluence.languages.de_DE, Version: 1.2) French language pack (confluence.languages.fr_FR, Version: 1.6) Basic Macros (confluence.macros.basic, Version: 1.3) News Tabs (confluence.sections.news, Version: 1.0) Core Extractors (confluence.extractors.core, Version: 1.4) Core Startup and Shutdown (confluence.lifecycle.core, Version: 1) Compatibility Macros (confluence.macros.compatibility, Version: 1.3) Edit Profile Sections (confluence.sections.profile.edit, Version: 1.0) Dashboard Macros (confluence.macros.dashboard, Version: 1.3) Confluence Contributors Plugin (com.atlassian.confluence.contributors, Version: 1.1.2) User Listener (confluence.extra.userlister, Version: 2.3) Tabular Metadata (confluence.extra.masterdetail, Version: 2.7) Dynamic Task List 2 Plugin (confluence.extra.dynamictasklist2, Version: 3.0.4) Confluence Usage Stats (com.atlassian.confluence.ext.usage, Version: 0.7.3-SNAPSHOT) Comment Action Sections (confluence.comment.action, Version: 1.0) Hudson Wiki Macros (test.hudson-wiki-plugin, Version: 1.0-SNAPSHOT) Layout Macros (confluence.extra.layout, Version: 1.1) Profile Tabs (confluence.sections.profile, Version: 1.0) Request Information: URL: http://localhost:58100/500page.jsp - Scheme: http - Server: localhost - Port: 58100 - URI: /500page.jsp - - Context Path: - - Servlet Path: /500page.jsp - - Path Info: - - Query String: foofoo Attributes: - javax.servlet.forward.request_uri : /display/JENKINS/Meet+Hudson - javax.servlet.forward.context_path : - javax.servlet.forward.servlet_path : /display - javax.servlet.forward.path_info : /500page.jsp - os_securityfilter_already_filtered : true - javax.servlet.jsp.jspException : org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute query; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1030]; Got error -1 from storage engine; nested exception is java.sql.SQLException: Got error -1 from storage engine - atlassian.core.seraph.original.url : /display/JENKINS/Meet+Hudson - javax.servlet.error.status_code : 500 - javax.servlet.error.servlet_name : simple-display - __sitemesh__using_stream : false - com.atlassian.gzipfilter.GzipFilter_already_filtered : true - loginfilter.already.filtered : true - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - Confluence-Request-Time : 1237133065625 - javax.servlet.error.message : - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@169eb93 - sessioninview.FILTERED : true - __sitemesh__filterapplied : true - javax.servlet.error.exception : org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute query; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1030]; Got error -1 from storage engine; nested exception is java.sql.SQLException: Got error -1 from storage engine - javax.servlet.error.request_uri : /display/JENKINS/Meet+Hudson Parameters: Confluence User: - anonymous Logging: 0 log statements generated by this request.

    Jenkins JIRA | 8 years ago | jpschewe
    java.sql.SQLException: Got error -1 from storage engine
  2. 0

    CONFLUENCE System Error A system error has occurred - our apologies! Please contact your Confluence administrator to create a support issue on our support system at http://support.atlassian.com with the following information: 1. a description of your problem and what you were doing at the time it occurred 2. cut & paste the error and system information found below 3. attach the application server log file (if possible). We will respond as promptly as possible. Thank you! Cause: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute query; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1030]; Got error -1 from storage engine; nested exception is java.sql.SQLException: Got error -1 from storage engine at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:120) caused by: java.sql.SQLException: Got error -1 from storage engine at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) Stack Trace: [hide] org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute query; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1030]; Got error -1 from storage engine; nested exception is java.sql.SQLException: Got error -1 from storage engine Caused by: java.sql.SQLException: Got error -1 from storage engine at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:440) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) at net.sf.hibernate.loader.Loader.doList(Loader.java:1063) at net.sf.hibernate.loader.Loader.list(Loader.java:1048) at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49) at com.atlassian.hibernate.HibernateObjectDao$5.doInHibernate(HibernateObjectDao.java:351) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370) at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:341) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:329) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:314) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:294) at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.getPage(HibernatePageDao.java:97) at com.atlassian.confluence.pages.DefaultPageManager.getPage(DefaultPageManager.java:133) at sun.reflect.GeneratedMethodAccessor401.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) at com.atlassian.spring.interceptors.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:20) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy15.getPage(Unknown Source) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.getPageFromKeyAndTitle(PageAwareInterceptor.java:183) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.getPage(PageAwareInterceptor.java:134) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:54) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.spaces.actions.SpaceAwareInterceptor.intercept(SpaceAwareInterceptor.java:67) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.core.actions.LastModifiedInterceptor.intercept(LastModifiedInterceptor.java:39) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.xwork.interceptors.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:97) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:229) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:199) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292) at com.atlassian.confluence.servlet.simpledisplay.SimpleDisplayServlet.service(SimpleDisplayServlet.java:59) at com.atlassian.confluence.servlet.SpringManagedServlet.service(SpringManagedServlet.java:64) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:141) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:54) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.jmx.JmxFilter.doFilter(JmxFilter.java:109) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.ServletContextThreadLocalFilter.doFilter(ServletContextThreadLocalFilter.java:21) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.util.LoggingContextFilter.doFilter(LoggingContextFilter.java:49) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.util.UserThreadLocalFilter.doFilter(UserThreadLocalFilter.java:44) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:192) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:114) at com.atlassian.confluence.util.AbstractBootstrapHotSwappingFilter.doFilter(AbstractBootstrapHotSwappingFilter.java:28) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:110) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.util.ClusterHeaderFilter.doFilter(ClusterHeaderFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:170) at com.atlassian.spring.filter.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:29) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:142) at com.atlassian.core.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:27) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.core.datetime.RequestTimeThreadLocalFilter.doFilter(RequestTimeThreadLocalFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.util.RequestCacheThreadLocalFilter.doFilter(RequestCacheThreadLocalFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:94) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:64) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:33) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:619) Referer URL: Unknown Build Information: home: /export/kohsuke/confluence/data buildNumber: 1322 upTime: 26 days, 20 hours, 57 minutes, 17 seconds devMode: false version: 2.8.1 Unique ID: 0x000001200AE076D7C01231851BE51C323B9E227F86915977CDD4E6D96D362A2B Server Information: Application Server: Apache Tomcat/6.0.13 Servlet Version: 2.5 Database Dialect: com.atlassian.hibernate.dialect.MySQLDialect Database Driver Name: com.mysql.jdbc.Driver Database Driver Version: 5.1 Database Name: MySQL Database Version: 5.0.51 Database Transaction Isolation: Repeatable read Database Latency: 0 Memory Information: Total Memory: 448 MB Used Memory: 337 MB Free Memory: 111 MB System Information: favouriteColour: Myrtle javaRuntime: Java(TM) SE Runtime Environment jvmVersion: 1.0 operatingSystem: SunOS 5.10 fileSystemEncoding: ISO646-US javaVm: Java HotSpot(TM) Server VM javaVendor: Sun Microsystems Inc. userTimezone: US/Pacific jvmImplementationVersion: 10.0-b22 appServer: Apache Tomcat date: Sunday, 15 Mar 2009 time: 09:04:25 jvmVendor: Sun Microsystems Inc. userName: kohsuke javaVersion: 1.6.0_06 operatingSystemArchitecture: x86 Cluster Information: Not clustered. Enabled Plugins: Confluence Attachments Plugin (confluence.extra.attachments, Version: 2.10) JIRA Macros (confluence.extra.jira, Version: 2.7) Social Bookmarking Plugin (com.atlassian.confluence.plugins.socialbookmarking, Version: 1.1.1) Admin Sections (confluence.sections.admin, Version: 1.0) Chart Plugin (confluence.extra.chart, Version: 1.9.1) System Web Resources (confluence.web.resources, Version: 1.0) Left Navigation Theme (com.atlassian.confluence.themes.leftnavigation, Version: 2.0-rc1) Confluence Remote API (confluence.extra.confluencerpc, Version: 2.8.1) Page Operations (confluence.sections.page.operations, Version: 1.0) Space Browse Sections (confluence.sections.space.browse, Version: 1.0) Core Path Converters (confluence.converters.core, Version: 1.0) Advanced Macros (confluence.macros.advanced, Version: 1.3) Code Macro (confluence.macros.code, Version: 1.4) User Menu Sections (confluence.user.menu, Version: 1.0) TinyMCE Editor Plugin (com.atlassian.confluence.extra.tinymceplugin, Version: 3.0-rc1) Add Content Menu Sections (confluence.menu.add, Version: 1.0) Table of Contents Plugin (org.randombits.confluence.toc, Version: 2.4.5) Confluence Atlassian Plugin Repository (confluence.repository.client, Version: 2.0.13) Confluence Classic Theme (com.atlassian.confluence.themes.classic, Version: 2.0-rc1) Default Theme (com.atlassian.confluence.themes.default, Version: 1.0) Page Tabs (confluence.search.mappers.lucene, Version: 1.0) Wiki Renderer Components (confluence.renderer.components, Version: 1.0) Space Advanced Sections (confluence.sections.space.advanced, Version: 1.0) Clickr Theme (com.atlassian.confluence.themes.clickr, Version: 2.0-rc1) Attachment Actions (confluence.sections.attachments, Version: 1.0) IM Presence NG Plugin (confluence.extra.impresence2, Version: 2.1) WebDAV Plugin (confluence.extra.webdav, Version: 1.1) Space Labels Sections (confluence.sections.space.labels, Version: 1.0) Space Actions Sections (confluence.sections.space.actions, Version: 1.0) Information Macros (confluence.extra.information, Version: 1.0) Content Buttons (confluence.sections.page.temp, Version: 1.0) Live Search Macros (confluence.extra.livesearch, Version: 2.6) Global Labels Sections (confluence.sections.labels, Version: 1.0) Page View Links (confluence.sections.page.actions, Version: 1.0) Space Admin Sections (confluence.sections.space.admin, Version: 1.0) Core Listeners (confluence.listeners.core, Version: 1.3) Content Action Menu Sections (confluence.content.action.menu, Version: 1.0) Space Item Tabs (confluence.sections.space, Version: 1.0) Space Pages Sections (confluence.sections.space.pages, Version: 1.0) Page Tabs (confluence.sections.page, Version: 1.0) BloggingRPC (com.atlassian.confluence.plugins.xmlrpc.bloggingrpc, Version: 1.2.2) Attachment Extractors (confluence.extractors.attachments, Version: 1.4) German language pack (confluence.languages.de_DE, Version: 1.2) French language pack (confluence.languages.fr_FR, Version: 1.6) Basic Macros (confluence.macros.basic, Version: 1.3) News Tabs (confluence.sections.news, Version: 1.0) Core Extractors (confluence.extractors.core, Version: 1.4) Core Startup and Shutdown (confluence.lifecycle.core, Version: 1) Compatibility Macros (confluence.macros.compatibility, Version: 1.3) Edit Profile Sections (confluence.sections.profile.edit, Version: 1.0) Dashboard Macros (confluence.macros.dashboard, Version: 1.3) Confluence Contributors Plugin (com.atlassian.confluence.contributors, Version: 1.1.2) User Listener (confluence.extra.userlister, Version: 2.3) Tabular Metadata (confluence.extra.masterdetail, Version: 2.7) Dynamic Task List 2 Plugin (confluence.extra.dynamictasklist2, Version: 3.0.4) Confluence Usage Stats (com.atlassian.confluence.ext.usage, Version: 0.7.3-SNAPSHOT) Comment Action Sections (confluence.comment.action, Version: 1.0) Hudson Wiki Macros (test.hudson-wiki-plugin, Version: 1.0-SNAPSHOT) Layout Macros (confluence.extra.layout, Version: 1.1) Profile Tabs (confluence.sections.profile, Version: 1.0) Request Information: URL: http://localhost:58100/500page.jsp - Scheme: http - Server: localhost - Port: 58100 - URI: /500page.jsp - - Context Path: - - Servlet Path: /500page.jsp - - Path Info: - - Query String: foofoo Attributes: - javax.servlet.forward.request_uri : /display/JENKINS/Meet+Hudson - javax.servlet.forward.context_path : - javax.servlet.forward.servlet_path : /display - javax.servlet.forward.path_info : /500page.jsp - os_securityfilter_already_filtered : true - javax.servlet.jsp.jspException : org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute query; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1030]; Got error -1 from storage engine; nested exception is java.sql.SQLException: Got error -1 from storage engine - atlassian.core.seraph.original.url : /display/JENKINS/Meet+Hudson - javax.servlet.error.status_code : 500 - javax.servlet.error.servlet_name : simple-display - __sitemesh__using_stream : false - com.atlassian.gzipfilter.GzipFilter_already_filtered : true - loginfilter.already.filtered : true - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - Confluence-Request-Time : 1237133065625 - javax.servlet.error.message : - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@169eb93 - sessioninview.FILTERED : true - __sitemesh__filterapplied : true - javax.servlet.error.exception : org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute query; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1030]; Got error -1 from storage engine; nested exception is java.sql.SQLException: Got error -1 from storage engine - javax.servlet.error.request_uri : /display/JENKINS/Meet+Hudson Parameters: Confluence User: - anonymous Logging: 0 log statements generated by this request.

    Jenkins JIRA | 8 years ago | jpschewe
    java.sql.SQLException: Got error -1 from storage engine
  3. 0

    Mysql Tomcat java.sql.SQLException - Spring Forum

    spring.io | 2 years ago
    java.sql.SQLException: Access denied for user 'root'@'localhost' (using password : NO)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [JENKINS-3292] Hudson Confluence wiki has crashed - Jenkins JIRA

    jenkins-ci.org | 1 year ago
    java.sql.SQLException: Got error -1 from storage engine
  6. 0

    [JENKINS-3292] Hudson Confluence wiki has crashed - Jenkins JIRA

    jenkins-ci.org | 1 year ago
    java.sql.SQLException: Got error -1 from storage engine

    6 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. java.sql.SQLException

      Got error -1 from storage engine

      at com.mysql.jdbc.SQLError.createSQLException()
    2. MySQL jdbc
      SQLError.createSQLException
      1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
      1 frame