[zanata-users] Exception raised each time i try to make a search
Sean Flanigan
sflaniga at redhat.com
Fri May 10 01:49:12 UTC 2013
This seems to be https://bugzilla.redhat.com/show_bug.cgi?id=953195
On 15/04/13 21:02, Gregoire Henry wrote:
> Hi Sean , thanks for answering
>
>>> is your database definitely using UTF-8 as its
> default collation?
>
>>>> yes , but the default server collation is latin1 (don't think it matter but ...)
>
>>> Is the locale being translated definitely enabled
> for the project in question?
>
>>>> Yes
>
>
>>> And this happens with any search string
> you try to use?
>
>>>> Yes
>
>
> i'm very sure this is a configuration or system specification error
> (this is a too big issue for not being mentionned before ) , but can't
> see where is the problem ..
>
> each request to make a search raise this error ,
> - if you just try to use the check box (translated, need review
> ,untranslated) in workspace , you get the message ..
> - if you try to search from the search box , idem
> - if you try a global search/remplace .. the same
>
>
>
>
>
>
>
>
>
> 2013/4/15 Sean Flanigan <sflaniga at redhat.com <mailto:sflaniga at redhat.com>>
>
> Hi Gregoire,
>
> We haven't seen that error before, and we're having trouble working out
> what might be causing it.
>
>
> It's a long shot, but is your database definitely using UTF-8 as its
> default collation? Is the locale being translated definitely enabled
> for the project in question? And this happens with any search string
> you try to use?
>
> Regards
>
> Sean.
>
> On 2013-04-12 06:25, Gregoire Henry wrote:
> > Hello Zanata Folks.
> >
> > I've just updated to 2.2.2 from 2.0.3
> > (Win 2008 server / MySql 5.2 / jdk 1.6.31)
> >
> > Each time i try to make a search in translation workspace an exception
> > is raised (see below) and the search didn't return values ...
> >
> > Any idea ?
> >
> > FYI : this bug was also present in my 2.0.3 version (same environment)
> >
> >
> > Thanks for answering ..
> >
> >
> > Regards
> >
> > Exception below :
> >
> > 2013-04-11 22:17:01,280 ERROR
> [org.zanata.webtrans.server.SeamDispatch]
> > (http-0.0.0.0-80-3) Error dispatching action:
> > org.hibernate.hql.ast.InvalidWithClauseException: with-clause
> > expressions did not reference from-clause element to which the
> > with-clause was associated [SELECT distinct tf FROM
> > org.zanata.model.HTextFlow tf LEFT JOIN tf.targets tfts WITH
> > index(tfts)=:locale WHERE (tf.obsolete=0 AND tf.document.id
> <http://tf.document.id>
> > <http://tf.document.id>=:docId AND ((lower(tf.content0) like
> > :searchString or lower(tf.content1) like :searchString or
> > lower(tf.content2) like :searchString or lower(tf.content3) like
> > :searchString or lower(tf.content4) like :searchString or
> > lower(tf.content5) like :searchString) OR EXISTS ( FROM
> > org.zanata.model.HTextFlowTarget WHERE (textFlow=tf and locale=:locale
> > and (lower(content0) like :searchString or lower(content1) like
> > :searchString or lower(content2) like :searchString or lower(content3)
> > like :searchString or lower(content4) like :searchString or
> > lower(content5) like :searchString))))) ORDER BY tf.pos]
> > org.hibernate.hql.ast.InvalidWithClauseException: with-clause
> > expressions did not reference from-clause element to which the
> > with-clause was associated [SELECT distinct tf FROM
> > org.zanata.model.HTextFlow tf LEFT JOIN tf.targets tfts WITH
> > index(tfts)=:locale WHERE (tf.obsolete=0 AND tf.document.id
> <http://tf.document.id>
> > <http://tf.document.id>=:docId AND ((lower(tf.content0) like
> > :searchString or lower(tf.content1) like :searchString or
> > lower(tf.content2) like :searchString or lower(tf.content3) like
> > :searchString or lower(tf.content4) like :searchString or
> > lower(tf.content5) like :searchString) OR EXISTS ( FROM
> > org.zanata.model.HTextFlowTarget WHERE (textFlow=tf and locale=:locale
> > and (lower(content0) like :searchString or lower(content1) like
> > :searchString or lower(content2) like :searchString or lower(content3)
> > like :searchString or lower(content4) like :searchString or
> > lower(content5) like :searchString))))) ORDER BY tf.pos]
> > at
> >
> org.hibernate.hql.ast.HqlSqlWalker.handleWithFragment(HqlSqlWalker.java:359)
> > at
> >
> org.hibernate.hql.ast.HqlSqlWalker.createFromJoinElement(HqlSqlWalker.java:338)
> > at
> >
> org.hibernate.hql.antlr.HqlSqlBaseWalker.joinElement(HqlSqlBaseWalker.java:3275)
> > at
> >
> org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3067)
> > at
> >
> org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2945)
> > at
> >
> org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:688)
> > at
> org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:544)
> > at
> >
> org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
> > at
> >
> org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
> > at
> >
> org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:251)
> > at
> >
> org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183)
> > at
> >
> org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:134)
> > at
> org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
> > at
> org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
> > at
> >
> org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
> > at
> >
> org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
> > at
> >
> org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
> > at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1650)
> > at
> >
> org.hibernate.search.impl.FullTextSessionImpl.createQuery(FullTextSessionImpl.java:313)
> > at sun.reflect.GeneratedMethodAccessor444.invoke(Unknown Source)
> > at
> >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> > at java.lang.reflect.Method.invoke(Method.java:597)
> > at
> >
> org.jboss.seam.persistence.HibernateSessionInvocationHandler.handleCreateQueryWithString(HibernateSessionInvocationHandler.java:113)
> > at
> >
> org.jboss.seam.persistence.HibernateSessionInvocationHandler.invoke(HibernateSessionInvocationHandler.java:76)
> > at $Proxy478.createQuery(Unknown Source)
> > at
> >
> org.zanata.dao.TextFlowDAO.getTextFlowByDocumentIdWithConstraint(TextFlowDAO.java:299)
> > 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:597)
> > at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
> > at
> >
> org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:32)
> > at
> >
> org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
> > at
> >
> org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28)
> > at
> >
> org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
> > at
> >
> org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:77)
> > at
> >
> org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
> > at
> >
> org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44)
> > at
> >
> org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
> > at
> org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
> > at
> >
> org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:185)
> > at
> >
> org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:103)
> > at
> >
> org.zanata.dao.TextFlowDAO_$$_javassist_seam_68.getTextFlowByDocumentIdWithConstraint(TextFlowDAO_$$_javassist_seam_68.java)
> > at
> >
> org.zanata.webtrans.server.rpc.GetTransUnitListHandler.getTextFlows(GetTransUnitListHandler.java:119)
> > at
> >
> org.zanata.webtrans.server.rpc.GetTransUnitListHandler.execute(GetTransUnitListHandler.java:97)
> > at
> >
> org.zanata.webtrans.server.rpc.GetTransUnitListHandler.execute(GetTransUnitListHandler.java:53)
> > 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:597)
> > at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
> > at
> >
> org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:32)
> > at
> >
> org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
> > at
> >
> org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28)
> > at
> >
> org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
> > at
> >
> org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:77)
> > at
> >
> org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
> > at
> >
> org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44)
> > at
> >
> org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
> > at
> org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
> > at
> >
> org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:185)
> > at
> >
> org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:103)
> > at
> >
> org.zanata.webtrans.server.rpc.GetTransUnitListHandler_$$_javassist_seam_66.execute(GetTransUnitListHandler_$$_javassist_seam_66.java)
> > at
> org.zanata.webtrans.server.SeamDispatch.doExecute(SeamDispatch.java:164)
> > at
> org.zanata.webtrans.server.SeamDispatch.execute(SeamDispatch.java:136)
> > 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:597)
> > at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
> > at
> >
> org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:32)
> > at
> >
> org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
> > at
> >
> org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28)
> > at
> >
> org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
> > at
> >
> org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44)
> > at
> >
> org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
> > at
> org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
> > at
> >
> org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:185)
> > at
> >
> org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:103)
> > at
> >
> org.zanata.webtrans.server.SeamDispatch_$$_javassist_seam_11.execute(SeamDispatch_$$_javassist_seam_11.java)
> > at
> >
> org.zanata.webtrans.server.DispatchServiceImpl.execute(DispatchServiceImpl.java:22)
> > 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:597)
> > at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
> > at
> >
> org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:32)
> > at
> >
> org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
> > at
> >
> org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28)
> > at
> >
> org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
> > at
> >
> org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:77)
> > at
> >
> org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
> > at
> >
> org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44)
> > at
> >
> org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
> > at
> org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
> > at
> >
> org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:185)
> > at
> >
> org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:103)
> > at
> >
> org.zanata.webtrans.server.DispatchServiceImpl_$$_javassist_seam_58.execute(DispatchServiceImpl_$$_javassist_seam_58.java)
> > 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:597)
> > at
> >
> org.jboss.seam.remoting.gwt.GWTToSeamAdapter.callWebRemoteMethod(GWTToSeamAdapter.java:100)
> > at
> >
> org.jboss.seam.remoting.gwt.GWTService.RPC_invokeAndEncodeResponse(GWTService.java:544)
> > at
> org.jboss.seam.remoting.gwt.GWTService.processCall(GWTService.java:206)
> > at
> org.jboss.seam.remoting.gwt.GWTService$1.process(GWTService.java:120)
> > at
> >
> org.jboss.seam.servlet.ContextualHttpServletRequest.run(ContextualHttpServletRequest.java:65)
> > at
> org.jboss.seam.remoting.gwt.GWTService.getResource(GWTService.java:105)
> > at
> >
> org.jboss.seam.servlet.SeamResourceServlet.service(SeamResourceServlet.java:80)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> > at
> >
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> > at
> >
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> > at
> >
> org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
> > at
> org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
> > at
> >
> org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
> > at
> >
> org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:389)
> > at
> >
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> > at
> >
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> > at
> >
> org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
> > at
> >
> org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:73)
> > at
> org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
> > at
> >
> org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
> > at
> org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:206)
> > at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
> > at
> >
> org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:388)
> > at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:515)
> > at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56)
> > at
> >
> org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
> > at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:60)
> > at
> >
> org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
> > at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
> > at
> >
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> > at
> >
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> > at
> >
> org.zanata.seam.interceptor.MonitoringWrapper.doFilter(MonitoringWrapper.java:70)
> > at
> >
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> > at
> >
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> > at
> >
> org.zanata.servlet.GWTCacheControlFilter.doFilter(GWTCacheControlFilter.java:63)
> > at
> >
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> > at
> >
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> > at
> >
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
> > 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:235)
> > at
> >
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> > at
> >
> org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
> > at
> >
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
> > at
> >
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
> > at
> >
> org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
> > at
> >
> org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
> > at
> >
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> > at
> >
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> > at
> >
> org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
> > at
> >
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> > at
> >
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
> > at
> >
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
> > at
> >
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
> > at
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
> > at java.lang.Thread.run(Thread.java:662)
> >
> >
> >
> > _______________________________________________
> > zanata-users mailing list
> > zanata-users at redhat.com <mailto:zanata-users at redhat.com>
> > https://www.redhat.com/mailman/listinfo/zanata-users
>
>
> --
> Sean Flanigan
>
> Senior Software Engineer
> Engineering - Internationalisation
> Red Hat
>
>
--
Sean Flanigan
Senior Software Engineer
Engineering - Internationalisation
Red Hat
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 555 bytes
Desc: OpenPGP digital signature
URL: <http://listman.redhat.com/archives/zanata-users/attachments/20130510/a32e2253/attachment.sig>
More information about the zanata-users
mailing list