Uploaded image for project: 'Lucee Development'
  1. LDEV-472

Queries called from event gateways break due to invalid request timeout

    Details

    • Type: Bug
    • Status: Deployed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 4.5.2.001
    • Fix Version/s: 5.0.0.60, 4.5.2.005
    • Labels:
      None

      Description

      Lucee is using the request timeout as default timeout for queries (in the latest BER release), problem is that event gateway has a infiniti timeout what cause this issue.

      Illegal value for setQueryTimeout(). 
       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998):998 
       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:937):937
       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926):926
       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:872):872
       at com.mysql.jdbc.StatementImpl.setQueryTimeout(StatementImpl.java:2550):2550
       at lucee.runtime.db.driver.StatementProxy.setQueryTimeout(StatementProxy.java:299):299
       at lucee.runtime.type.QueryImpl.setAttributes(QueryImpl.java:366):366
       at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:250):250
       at lucee.runtime.tag.Query.executeDatasoure(Query.java:775):775
       at lucee.runtime.tag.Query.doEndTag(Query.java:585):585
       at queryexecute_cfm$cf.udfCall(/Users/chris/.m2/repository/org/lucee/lucee/4.5.2.001/lucee-server/context/library/function/queryExecute.cfm:43):43
       at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
       at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
       at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229
       at lucee.runtime.functions.system.CFFunction.call(CFFunction.java:99):99
       at com.sos.galactus.listener.listener_cfc$cf.udfCall(/Users/chris/repos/galactus/src/main/webapp/com/sos/galactus/listener/Listener.cfc:5):5
       at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
       at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
       at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229
       at lucee.runtime.ComponentImpl._call(ComponentImpl.java:641):641
       at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
       at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1760):1760
       at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:742):742
       at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1589):1589
       at lucee.extension.gateway.rabbitmqwatcher_cfc$cf.udfCall(/Users/chris/repos/galactus/src/main/webapp/WEB-INF/lucee/components/lucee/extension/gateway/RabbitMQWatcher.cfc:41):41
       at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
       at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
       at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
       at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642
       at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
       at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1777):1777
       at lucee.runtime.ComponentPage.callWDDX(ComponentPage.java:670):670
       at lucee.runtime.ComponentPage.call(ComponentPage.java:202):202
       at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:950):950
       at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:902):902
       at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:223):223
       at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:35):35
       at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2257):2257
       at lucee.runtime.gateway.GatewayEngineImpl.call(GatewayEngineImpl.java:358):358
       at lucee.runtime.gateway.GatewayEngineImpl.callOneWay(GatewayEngineImpl.java:329):329
       at lucee.runtime.gateway.CFCGateway.callOneWay(CFCGateway.java:169):169
       at lucee.runtime.gateway.CFCGateway.doStart(CFCGateway.java:99):99
       at lucee.runtime.gateway.GatewayThread.run(GatewayThread.java:41):41
      

        Attachments

          Activity

            People

            • Assignee:
              michaeloffner Michael Offner
              Reporter:
              chrisblackwell Chris Blackwell
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: