bug of search

Help
2008-05-27
2013-05-01
  • i create several spaces, and a user, but i didn't allocate the user to any space, then login and search. jtrac reports:
    2008-05-27 10:33:41,203 [http-8080-Processor24] WARN [org.hibernate.util.JDBCExceptionReporter] - SQL Error: 1064, SQLState: 42000
    2008-05-27 10:33:41,218 [http-8080-Processor24] ERROR [org.hibernate.util.JDBCExceptionReporter] - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') order by space1_.name desc, this_.id desc limit 25' at line 1
    2008-05-27 10:33:41,328 [http-8080-Processor24] ERROR [org.apache.wicket.RequestCycle] - could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
    org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
        at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:613)
        at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:378)
        at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1000)
        at info.jtrac.hibernate.HibernateJtracDao$$M$dfb52019.findItems(HibernateJtracDao.java:102)
        at info.jtrac.hibernate.HibernateJtracDao$$A$dfb52019.findItems(<generated>)
        at info.jtrac.hibernate.HibernateJtracDao.findItems(<generated>)
        at info.jtrac.JtracImpl$$M$64b4c496.findItems(JtracImpl.java:371)
        at info.jtrac.JtracImpl$$A$64b4c496.findItems(<generated>)
        at info.jtrac.JtracImpl.findItems(<generated>)
        at info.jtrac.JtracImpl$$FastClassByCGLIB$$83ac5406.invoke(<generated>)
        at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
        at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
        at info.jtrac.JtracImpl$$EnhancerByCGLIB$$232e37e7.findItems(<generated>)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy6.findItems(Unknown Source)
        at info.jtrac.wicket.ItemListPanel$1$$M$bc6ddd4f.load(ItemListPanel.java:89)
        at info.jtrac.wicket.ItemListPanel$1$$A$bc6ddd4f.load(<generated>)
        at info.jtrac.wicket.ItemListPanel$1.load(<generated>)
        at org.apache.wicket.model.LoadableDetachableModel.getObject(LoadableDetachableModel.java:114)
        at info.jtrac.wicket.ItemListPanel$1.getObject(<generated>)
        at info.jtrac.wicket.ItemListPanel$$M$6fc22371.__init__(ItemListPanel.java:95)
        at info.jtrac.wicket.ItemListPanel$$A$6fc22371.__init__(<generated>)
        at info.jtrac.wicket.ItemListPanel.<init>(<generated>)
        at info.jtrac.wicket.ItemListPage$$M$acd3f3a1.__init__(ItemListPage.java:72)
        at info.jtrac.wicket.ItemListPage$$A$acd3f3a1.__init__(<generated>)
        at info.jtrac.wicket.ItemListPage.<init>(<generated>)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
        at java.lang.Class.newInstance0(Class.java:350)
        at java.lang.Class.newInstance(Class.java:303)
        at org.apache.wicket.session.DefaultPageFactory.newPage(DefaultPageFactory.java:58)
        at org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.newPage(BookmarkablePageRequestTarget.java:262)
        at org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.getPage(BookmarkablePageRequestTarget.java:283)
        at org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.processEvents(BookmarkablePageRequestTarget.java:210)
        at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:90)
        at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1166)
        at org.apache.wicket.RequestCycle.step(RequestCycle.java:1241)
        at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1316)
        at org.apache.wicket.RequestCycle.request(RequestCycle.java:493)
        at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:354)
        at org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:194)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.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(CoyoteAdapter.java:148)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.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.Thread.run(Thread.java:595)
    Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.loader.Loader.doList(Loader.java:2223)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
        at org.hibernate.loader.Loader.list(Loader.java:2099)
        at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
        at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1010)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:373)
        ... 72 more
    Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') order by space1_.name desc, this_.id desc limit 25' at line 1
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
        at org.hibernate.loader.Loader.doQuery(Loader.java:674)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
        at org.hibernate.loader.Loader.doList(Loader.java:2220)
        ... 79 more

     
    • Peter Thomas
      Peter Thomas
      2008-06-04

      I think this bug is already reported, but do log one if necessary.

       
  • Isaac
    Isaac
    2012-06-05

    I have the same problem.
    When I push Search, I have an Internal Error:

    INFO   | jvm 1    | 2012/06/05 12:16:09 | 2012-06-05 12:16:09,049  WARN  - SQL Error: 1064, SQLState: 42000
    INFO   | jvm 1    | 2012/06/05 12:16:09 | 2012-06-05 12:16:09,049  ERROR  - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') order by space1_.name desc, this_.id desc limit 25' at line 1
    INFO   | jvm 1    | 2012/06/05 12:16:09 | 2012-06-05 12:16:09,049  ERROR  - could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
    INFO   | jvm 1    | 2012/06/05 12:16:09 | org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:613)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:378)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1000)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at info.jtrac.hibernate.HibernateJtracDao.findItems(HibernateJtracDao.java:97)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at info.jtrac.JtracImpl.findItems(JtracImpl.java:342)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at sun.reflect.GeneratedMethodAccessor220.invoke(Unknown Source)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at java.lang.reflect.Method.invoke(Unknown Source)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at $Proxy0.findItems(Unknown Source)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at info.jtrac.wicket.ItemListPanel$1.load(ItemListPanel.java:68)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.apache.wicket.model.LoadableDetachableModel.getObject(LoadableDetachableModel.java:114)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at info.jtrac.wicket.ItemListPanel.<init>(ItemListPanel.java:74)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at info.jtrac.wicket.ItemListPage.<init>(ItemListPage.java:25)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at sun.reflect.GeneratedConstructorAccessor47.newInstance(Unknown Source)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at java.lang.reflect.Constructor.newInstance(Unknown Source)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at java.lang.Class.newInstance0(Unknown Source)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at java.lang.Class.newInstance(Unknown Source)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.apache.wicket.session.DefaultPageFactory.newPage(DefaultPageFactory.java:58)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.newPage(BookmarkablePageRequestTarget.java:262)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.getPage(BookmarkablePageRequestTarget.java:283)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.processEvents(BookmarkablePageRequestTarget.java:210)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:90)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1166)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.apache.wicket.RequestCycle.step(RequestCycle.java:1241)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1316)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.apache.wicket.RequestCycle.request(RequestCycle.java:493)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:354)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:194)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1065)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1065)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:365)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:185)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:689)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:391)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:146)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.mortbay.jetty.Server.handle(Server.java:285)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:457)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:751)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:500)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:209)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:357)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:329)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:475)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.hibernate.loader.Loader.doList(Loader.java:2223)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.hibernate.loader.Loader.list(Loader.java:2099)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1010)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:373)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | … 53 more
    INFO   | jvm 1    | 2012/06/05 12:16:09 | Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') order by space1_.name desc, this_.id desc limit 25' at line 1
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at java.lang.reflect.Constructor.newInstance(Unknown Source)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at com.mysql.jdbc.Util.getInstance(Util.java:386)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2683)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2144)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2310)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.hibernate.loader.Loader.doQuery(Loader.java:674)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | at org.hibernate.loader.Loader.doList(Loader.java:2220)
    INFO   | jvm 1    | 2012/06/05 12:16:09 | … 60 more

    Is a MySQL Installation.

     
  • J. Ulbts
    J. Ulbts
    2012-06-05

    Please add the exact version information of MySQL and the database backend of MySQL that is used (InnoDB or MyISAM).
    Which version of JTrac are you using (the latest version from download section or the version from the SVN)?
    Could you please add the content of the jtrac.properties file?
    Don't forget to remove user and password from the 'jtrac.properties' file! ;)