XPlannerIssue_06302010x - Jira

tastelessbeachInternet and Web Development

Nov 12, 2013 (3 years and 8 months ago)

328 views


[hide]

Cause

org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute query; uncategorized
SQLException for SQL []; SQL state [HY000]; error code [1030]; Got error 28 from storage engine; nested
exception is
java.sql.SQLException: Got error 28 from storage engine

[hide]

Stack Trace

org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute query; uncategorized
SQLException for SQL []; SQL state [HY000]; error code [1030]; Got er
ror 28 from storage engine; nested
exception is java.sql.SQLException: Got error 28 from storage engine

java.sql.SQLException: Got error 28 from storage engine


at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)


at com.mysql.jdbc.MysqlIO.che
ckErrorPacket(MysqlIO.java:2870)


at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)


at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1169)


at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPrepared
Statement.java:693)


at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1266)


at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)


at

org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)


at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89)


at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880)


at net.sf.hiber
nate.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:1054)


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 org.springframework.orm.hibernate.HibernateTemplate$23.do
InHibernate(HibernateTemplate.java:850)


at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:363)


at
org.springframework.orm.hibernate.HibernateTemplate.findByNamedQueryAndNamedParam(HibernateTemplate.java:841)


at
com.te
chnoetic.xplanner.domain.repository.TaskRepositoryHibernate.queryTasks(TaskRepositoryHibernate.java:168)


at
com.technoetic.xplanner.domain.repository.TaskRepositoryHibernate.getCurrentTasksForPerson(TaskRepositoryHibern
ate.java:161)


at com.technoetic.xpl
anner.actions.ViewPersonAction.doExecute(ViewPersonAction.java:40)


at com.technoetic.xplanner.actions.AbstractAction$1.run(AbstractAction.java:52)


at
com.technoetic.xplanner.tx.CheckedExceptionHandlingTransactionTemplate$1.doInTransaction(CheckedExceptio
nHandli
ngTransactionTemplate.java:34)


at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:114)


at
com.technoetic.xplanner.tx.CheckedExceptionHandlingTransactionTemplate.execute(CheckedExceptionHandlingTransact
i
onTemplate.java:31)


at com.technoetic.xplanner.actions.AbstractAction.execute(AbstractAction.java:50)


at org.strutsspring.SpringAction.execute(SpringAction.java:72)


at

org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)


at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)


at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)


at org.
apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)


at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)


at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


at org.apache.catalina.core.ApplicationFilterChain.internalD
oFilter(ApplicationFilterChain.java:252)


at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)


at
com.technoetic.xplanner.filters.RequestCharacterEncodingFilter.doFilter(RequestCharacterEncodingFilter.java:37)


at o
rg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)


at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)


at
com.technoetic.xplanner.security.filter.AbstractSecurityFilte
r.doFilter(AbstractSecurityFilter.java:51)


at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)


at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)


at com.technoeti
c.xplanner.filters.ServletRequestFilter.doFilter(ServletRequestFilter.java:24)


at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)


at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil
terChain.java:173)


at
com.technoetic.xplanner.db.hibernate.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:43)


at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)


at org.apache.catalina.core.A
pplicationFilterChain.doFilter(ApplicationFilterChain.java:173)


at
org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java
:174)


at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePe
rRequestFilter.java:76)


at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)


at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)


at

com.technoetic.xplanner.filters.ActivityLogFilter.doFilter(ActivityLogFilter.java:34)


at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)


at org.apache.catalina.core.ApplicationFilterChain.doFilter(Applic
ationFilterChain.java:173)


at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)


at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)


at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:126)


at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)


at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)


at org.apache.catalina.connector.CoyoteAdapter.service(Coy
oteAdapter.java:148)


at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)


at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:6
64)


at org.apache.tomcat.util.net.PoolTc
pEndpoint.processSocket(PoolTcpEndpoint.java:527)


at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)


at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)


at java.lang.Threa
d.run(Unknown Source)

System Environment

[hide]

Build



Version
:
0.7b7




Build Date
:
05/24/2006




Build Revision
:
1149




Build Package
:
War

[hide]

Database



Dialect
:
com.technoetic.xplanner.db.hibernate.XPlannerMySQLDialect




Driver
:
com.mysql.jdbc.Driver




Driver

Version
:
mysql
-
connector
-
java
-
5.0.4 ( $Date: 2006
-
10
-
19 17:47:48 +0200 (Thu, 19 Oct 2006) $, $Revision: 5908 $ )




Database Vendor
:
MySQL




Database Version
:
5.0.27
-
community
-
nt




Database Name
:
xplanner




Database Url
:
jdbc:mysql://localhost/xplanner?autoRec
onnect=true




Database User Name
:
xplanner




Database User Password
:
******




Database Patch Level
:
14

[hide]

App Server



Application Server
:
Apache Tomcat/5.5.20




Servlet Version
:
2.4

[hide]

Memory



Total Memory
:
127MB




Free Memory
:
69MB




Used Memory
:
58MB

[
hide]

System



System Date
:
Jun 30, 2010




System Time
:
8:28:33 AM




Current directory
:
C:
\
Program Files
\
Apache Software Foundation
\
Tomcat 5.5




Java Version
:
1.5.0_10




Java Vendor
:
Sun Microsystems Inc.




JVM Version
:
1.0




JVM Vendor
:
Sun Microsystems Inc.




JVM

Implementation Version
:
1.5.0_10
-
b03




Java Runtime
:
Java(TM) 2 Runtime Environment, Standard Edition




Java VM
:
Java HotSpot(TM) Client VM




User Name
:
SYSTEM




User Timezone
:
America/Chicago




Operating System
:
Windows 2003 5.2




OS Architecture
:
x86

Request
Information

[hide]

General



Referer URL
:
http://mia
-
vm
-
xplanner:8000/xplanner/do/view/projects




Locale
:
en_US




URL
:

o

Scheme
:
http


o

Server
:
mia
-
vm
-
xplanner


o

Port
:
8000


o

URI
:
/xplanner/WEB
-
INF/jsp/common/unexpectedError.jsp




Context Path
:
/xplanner




Servlet

Path
:
/WEB
-
INF/jsp/common/unexpectedError.jsp




Path Info
:



Query String
:
oid=471994


[hide]

Parameters



oid
:
471994

[hide]

Attributes



OpenSessionInViewFilter.FILTERED
:
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 28 from storage engine; nested exception is java.sql
.SQLException: Got error 28 from
storage engine




javax.servlet.error.
exception_type
:
class org.springframework.jdbc.UncategorizedSQLException




javax.servlet.error.message
:
Hibernate operation: Could not execute query; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1030];
Got error 28 from storage engi
ne; nested exception is java.sql.SQLException: Got error 28 from storage engine




javax.servlet.error.request_uri
:
/xplanner/do/view/person




javax.servlet.error.servlet_name
:
XPlannerServlet




javax.servlet.error.status_code
:
500




javax.servlet.forward.conte
xt_path
:
/xplanner




javax.servlet.forward.path_info
:
/WEB
-
INF/jsp/common/unexpectedError.jsp




javax.servlet.forward.query_string
:
oid=471994




javax.servlet.forward.request_uri
:
/xplanner/do/view/person




javax.servlet.forward.servlet_path
:
/do




org.apache.struts.action.MESSAGE
:
org.apache.struts.util.PropertyMessageResources@b13288




org.apache.struts.action.MODULE
:
org.apache.struts.config.impl.ModuleConfigImpl@1b8c0ce




org.apache.struts.action.mapping.instance
:
ActionConfig[path=/view/person,scope=session,type=com.technoetic.xplanner.actions.ViewPersonAction