B4J Question java.lang.RuntimeException: java.sql.SQLException

prajinpraveen

Active Member
Licensed User
Longtime User
Good day,

I tend to get these errors often. SQL connections are closed. The web app also accepts API connections from Mobile App
Any ideas why this happens?

Error Log:
03/24/2022 10:30:20   SQLExecuteMaps 2:
            select isp.*, prd.productname,prd.productcode from  outbound_delivery_products isp inner join products prd on prd.id = isp.productid
            where deliveryid = 29181 and productidactive = 1  AND isp.verifiedby IS NOT null AND isp.pickedby IS NOT null  order by createddate desc LIMIT  0, 10000
            
(MyMap) {phase=outverify, clienttype=External, productcode=SASOLWAX_M3B_PPE20, producttypeflag=2, bayno=NA, palletno=1, isexported=0, packeddate=, producttype=2, productidactive=1, isdamaged=0, productbatch=2201WD2034, labno=, deliveryid=29181, hku=100000000000157218, warehouseid=4, productquantity=35.0, productdeliveryno=85114176, movement=0, remarks=}
Pool Data : pool connections = 39 out of a max. 100
03/24/2022 10:30:24   SQLExecuteMap 1: SELECT * FROM outbound_delivery WHERE id= ? AND deliveryactive= ?
Init Svr Inbound Schedule
Svr Current Thread: qtp783191662-11614
Svr Current Thread: 100
1313
(MyMap) {action=[Ljava.lang.String;@45d25624, pdata=[Ljava.lang.String;@25199514, post2=[Ljava.lang.String;@e8a9f7c, post1=[Ljava.lang.String;@455e7dc9}
(HttpInputOverHTTP) HttpInputOverHTTP@126a7030[c=132,q=0,[0]=null,s=EOF]
ABMShared.NeedsAuthorization true
Done checking authorization
actionvalue(0) getquantity
Pool Data : pool connections = 39 out of a max. 100
java.lang.RuntimeException: java.sql.SQLException: An SQLException was provoked by the following failure: java.lang.InterruptedException
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:138)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:96)
    at anywheresoftware.b4j.object.JServlet$Handle.run(JServlet.java:130)
    at anywheresoftware.b4j.object.JServlet.Handle(JServlet.java:110)
    at anywheresoftware.b4j.object.JServlet.doPost(JServlet.java:80)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)
    at org.eclipse.jetty.servlets.DoSFilter.doFilterChain(DoSFilter.java:482)
    at org.eclipse.jetty.servlets.DoSFilter.doFilter(DoSFilter.java:327)
    at org.eclipse.jetty.servlets.DoSFilter.doFilter(DoSFilter.java:297)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
    at anywheresoftware.b4j.object.JServlet$Handle.run(JServlet.java:135)
    at anywheresoftware.b4j.object.JServlet.Handle(JServlet.java:110)
    at anywheresoftware.b4j.object.JServlet.doFilter(JServlet.java:72)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
    at anywheresoftware.b4j.object.JServlet$Handle.run(JServlet.java:135)
    at anywheresoftware.b4j.object.JServlet.Handle(JServlet.java:110)
    at anywheresoftware.b4j.object.JServlet.doFilter(JServlet.java:72)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
    at org.eclipse.jetty.servlets.CrossOriginFilter.handle(CrossOriginFilter.java:311)
    at org.eclipse.jetty.servlets.CrossOriginFilter.doFilter(CrossOriginFilter.java:265)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
    at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
    at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)
    at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:724)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
    at org.eclipse.jetty.server.Server.handle(Server.java:531)
    at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)
    at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
    at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)
    at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)
    at org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:291)
    at org.eclipse.jetty.io.ssl.SslConnection$3.succeeded(SslConnection.java:151)
    at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)
    at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
    at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
    at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
    at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
    at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
    at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:760)
    at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:678)
    at java.base/java.lang.Thread.run(Thread.java:831)
Caused by: java.sql.SQLException: An SQLException was provoked by the following failure: java.lang.InterruptedException
    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:77)
    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:74)
    at com.mchange.v2.c3p0.stmt.GooGooStatementCache.acquireStatement(GooGooStatementCache.java:579)
    at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkoutStatement(GooGooStatementCache.java:204)
    at com.mchange.v2.c3p0.impl.NewPooledConnection.checkoutStatement(NewPooledConnection.java:321)
    at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:553)
    at anywheresoftware.b4j.objects.SQL.ExecQuery2(SQL.java:365)
    at za.co.irays.slms.abmshared._sqlexecutemap(abmshared.java:18631)
    at za.co.irays.slms.abmshared._sqlrecordread(abmshared.java:19156)
    at za.co.irays.slms.svrinboundschedule._loadoutbounddeliverydetails(svrinboundschedule.java:2793)
    at za.co.irays.slms.svrinboundschedule._handle(svrinboundschedule.java:1546)
    at jdk.internal.reflect.GeneratedMethodAccessor38.invoke(Unknown Source)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:567)
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:109)
    ... 54 more
Caused by: java.lang.InterruptedException
    at java.base/java.lang.Object.wait(Native Method)
    at java.base/java.lang.Object.wait(Object.java:320)
    at com.mchange.v2.c3p0.stmt.GooGooStatementCache.acquireStatement(GooGooStatementCache.java:569)
    ... 66 more
Init Svr Inbound Schedule
Svr Current Thread: qtp783191662-11631
Svr Current Thread: 99
1323
(MyMap) {action=[Ljava.lang.String;@1e667f9b, schstatus=[Ljava.lang.String;@5b64e233, pagecount=[Ljava.lang.String;@3fb98cf8, userid=[Ljava.lang.String;@6af53aaf}
(HttpInputOverHTTP) HttpInputOverHTTP@4687c3f1[c=58,q=0,[0]=null,s=EOF]
ABMShared.NeedsAuthorization true
Done checking authorization
actionvalue(0) outbounddelivery
Pool Data : pool connections = 39 out of a max. 100
Init Svr Inbound Schedule
Svr Current Thread: qtp783191662-11626
Svr Current Thread: 99
1324
(MyMap) {action=[Ljava.lang.String;@73e5a79d, pdata=[Ljava.lang.String;@359ef848, post2=[Ljava.lang.String;@425cd6c0, post1=[Ljava.lang.String;@4dcdd7b9}
(HttpInputOverHTTP) HttpInputOverHTTP@13ca58d2[c=284,q=0,[0]=null,s=EOF]
ABMShared.NeedsAuthorization true
Done checking authorization
actionvalue(0) getproductscount
Pool Data : pool connections = 39 out of a max. 100
java.lang.RuntimeException: java.sql.SQLException: An SQLException was provoked by the following failure: java.lang.InterruptedException
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:138)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:96)
    at anywheresoftware.b4j.object.JServlet$Handle.run(JServlet.java:130)
    at anywheresoftware.b4j.object.JServlet.Handle(JServlet.java:110)
    at anywheresoftware.b4j.object.JServlet.doPost(JServlet.java:80)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)
    at org.eclipse.jetty.servlets.DoSFilter.doFilterChain(DoSFilter.java:482)
    at org.eclipse.jetty.servlets.DoSFilter.doFilter(DoSFilter.java:327)
    at org.eclipse.jetty.servlets.DoSFilter.doFilter(DoSFilter.java:297)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
    at anywheresoftware.b4j.object.JServlet$Handle.run(JServlet.java:135)
    at anywheresoftware.b4j.object.JServlet.Handle(JServlet.java:110)
    at anywheresoftware.b4j.object.JServlet.doFilter(JServlet.java:72)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
    at anywheresoftware.b4j.object.JServlet$Handle.run(JServlet.java:135)
    at anywheresoftware.b4j.object.JServlet.Handle(JServlet.java:110)
    at anywheresoftware.b4j.object.JServlet.doFilter(JServlet.java:72)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
    at org.eclipse.jetty.servlets.CrossOriginFilter.handle(CrossOriginFilter.java:311)
    at org.eclipse.jetty.servlets.CrossOriginFilter.doFilter(CrossOriginFilter.java:265)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
    at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
    at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)
    at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:724)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
    at org.eclipse.jetty.server.Server.handle(Server.java:531)
    at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)
    at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
    at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)
    at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)
    at org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:291)
    at org.eclipse.jetty.io.ssl.SslConnection$3.succeeded(SslConnection.java:151)
    at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)
    at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
    at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
    at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
    at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
    at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
    at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:760)
    at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:678)
    at java.base/java.lang.Thread.run(Thread.java:831)
Caused by: java.sql.SQLException: An SQLException was provoked by the following failure: java.lang.InterruptedException
    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:77)
    at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:74)
    at com.mchange.v2.c3p0.stmt.GooGooStatementCache.acquireStatement(GooGooStatementCache.java:579)
    at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkoutStatement(GooGooStatementCache.java:204)
    at com.mchange.v2.c3p0.impl.NewPooledConnection.checkoutStatement(NewPooledConnection.java:321)
    at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:553)
    at anywheresoftware.b4j.objects.SQL.ExecQuery2(SQL.java:365)
    at za.co.irays.slms.abmshared._sqlexecutemap(abmshared.java:18631)
    at za.co.irays.slms.abmshared._sqlrecordread(abmshared.java:19156)
    at za.co.irays.slms.svrinboundschedule._loadoutbounddeliverydetails(svrinboundschedule.java:2793)
    at za.co.irays.slms.svrinboundschedule._handle(svrinboundschedule.java:1546)
    at jdk.internal.reflect.GeneratedMethodAccessor38.invoke(Unknown Source)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:567)
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:109)
    ... 54 more
Caused by: java.lang.InterruptedException
    at java.base/java.lang.Object.wait(Native Method)
    at java.base/java.lang.Object.wait(Object.java:320)
    at com.mchange.v2.c3p0.stmt.GooGooStatementCache.acquireStatement(GooGooStatementCache.java:569)
    ... 66 more
Init Svr Inbound Schedule
Svr Current Thread: qtp783191662-11630
Svr Current Thread: 99
1325
(MyMap) {action=[Ljava.lang.String;@5d14770, pdata=[Ljava.lang.String;@123ee5fe, post2=[Ljava.lang.String;@341e64e7, post1=[Ljava.lang.String;@6a1b98cb}
(HttpInputOverHTTP) HttpInputOverHTTP@79009f3e[c=132,q=0,[0]=null,s=EOF]
ABMShared.NeedsAuthorization true
Done checking authorization
actionvalue(0) getquantity
Pool Data : pool connections = 39 out of a max. 100
Init Svr Inbound Schedule
Svr Current Thread: qtp783191662-11623
Svr Current Thread: 99
1316
(MyMap) {action=[Ljava.lang.String;@2c69bad4, pdata=[Ljava.lang.String;@65ef557, post2=[Ljava.lang.String;@24a3283c, post1=[Ljava.lang.String;@1b427b5f}
(HttpInputOverHTTP) HttpInputOverHTTP@7a9ccdf9[c=132,q=0,[0]=null,s=EOF]
ABMShared.NeedsAuthorization true
Done checking authorization
actionvalue(0) getquantity
Pool Data : pool connections = 39 out of a max. 100
Init Svr Inbound Schedule
Svr Current Thread: qtp783191662-11622
Svr Current Thread: 99
1317
(MyMap) {action=[Ljava.lang.String;@4488a0f0, schstatus=[Ljava.lang.String;@47436bc3, pagecount=[Ljava.lang.String;@531fb5e4, userid=[Ljava.lang.String;@6fac6d73}
(HttpInputOverHTTP) HttpInputOverHTTP@588efbd5[c=58,q=0,[0]=null,s=EOF]
ABMShared.NeedsAuthorization true
Done checking authorization
actionvalue(0) outbounddelivery
Pool Data : pool connections = 39 out of a max. 100
Init Svr Inbound Schedule
Svr Current Thread: qtp783191662-11628
Svr Current Thread: 99
1319
(MyMap) {action=[Ljava.lang.String;@7fdd1e6f, pdata=[Ljava.lang.String;@562c050c, post2=[Ljava.lang.String;@3a376fb7, post1=[Ljava.lang.String;@76c666d7}
(HttpInputOverHTTP) HttpInputOverHTTP@61ff2006[c=284,q=0,[0]=null,s=EOF]
ABMShared.NeedsAuthorization true
Done checking authorization
actionvalue(0) getproductscount
Pool Data : pool connections = 39 out of a max. 100
Init Svr Inbound Schedule
Svr Current Thread: qtp783191662-11505
Svr Current Thread: 99
1273
(MyMap) {cc=[Ljava.lang.String;@3e87a323, action=[Ljava.lang.String;@28c08c89, ver=[Ljava.lang.String;@66a3290f, pdata=[Ljava.lang.String;@10d97644, uname=[Ljava.lang.String;@134441c7}
(HttpInputOverHTTP) HttpInputOverHTTP@3f4c33e2[c=626,q=0,[0]=null,s=EOF]
ABMShared.NeedsAuthorization true
IsAuthorized is null
Pool Data : pool connections = 39 out of a max. 100
Init Svr Inbound Schedule
Svr Current Thread: qtp783191662-11583
Svr Current Thread: 99
1303
(MyMap) {action=[Ljava.lang.String;@3586a272, schstatus=[Ljava.lang.String;@457525f1, pagecount=[Ljava.lang.String;@1d21cb6c, userid=[Ljava.lang.String;@20868510}
(HttpInputOverHTTP) HttpInputOverHTTP@20933640[c=58,q=0,[0]=null,s=EOF]
ABMShared.NeedsAuthorization true
Done checking authorization
actionvalue(0) outbounddelivery
Pool Data : pool connections = 39 out of a max. 100
Init Svr Inbound Schedule
Svr Current Thread: qtp783191662-11603
Svr Current Thread: 99
1310
(MyMap) {action=[Ljava.lang.String;@4d094e4e, pdata=[Ljava.lang.String;@601a6910, post2=[Ljava.lang.String;@7f132a7e, post1=[Ljava.lang.String;@5a30f9b9}
(HttpInputOverHTTP) HttpInputOverHTTP@5d4ca78f[c=284,q=0,[0]=null,s=EOF]
ABMShared.NeedsAuthorization true
Done checking authorization
actionvalue(0) getproductscount
Pool Data : pool connections = 39 out of a max. 100
(MyMap) {phase=outverify, clienttype=External, warehouseid=4, phaseid=29181, deliveryref=85114176, status=60, producttype=2}
Pool Data : pool connections = 39 out of a max. 100
Pool Data : pool connections = 39 out of a max. 100
03/24/2022 10:30:52   SQLExecuteMaps 2:
            select isp.*, prd.productname,prd.productcode from  outbound_delivery_products isp inner join products prd on prd.id = isp.productid
            where deliveryid = 29181 and productidactive = 1   order by createddate desc LIMIT  0, 10000
            
03/24/2022 10:30:52   SQLExecuteMaps 2: Select ins.*,cl.clientname,wr.warehousename,cws.status_name,IFNULL(idp.count,0) AS prodcount, cpt.product_type_name
                from  outbound_delivery ins
                inner join clients cl on cl.id = ins.clientid inner join warehouses wr on wr.id = ins.warehouseid
                inner join config_workflow_status_mobile cws on cws.id = ins.schstatus
                inner join config_product_type cpt on ins.producttype = cpt.product_type_stage_id
                LEFT JOIN (SELECT COUNT(DISTINCT idp.id) count, idp.deliveryid
                           FROM outbound_delivery_products  idp
                           WHERE idp.productidactive = 1
                           GROUP BY idp.deliveryid) idp
                           ON idp.deliveryid = ins.id
                where ins.schstatus in (60) AND deliveryactive = 1 And producttype in (31,32,33)
                GROUP BY ins.id
                 order by updateddate desc  LIMIT 0 , 50
(MyMap) {phase=outverify, clienttype=External, warehouseid=4, phaseid=29181, deliveryref=85114176, status=60, producttype=2}
Pool Data : pool connections = 39 out of a max. 100
Pool Data : pool connections = 39 out of a max. 100
Pool Data : pool connections = 39 out of a max. 100
03/24/2022 10:30:52   SQLExecuteMaps 2:
            select isp.*, prd.productname,prd.productcode from  outbound_delivery_products isp inner join products prd on prd.id = isp.productid
            where deliveryid = 29181 and productidactive = 1   order by createddate desc LIMIT  0, 10000
            
(MyMap) {phase=outverify, clienttype=External, warehouseid=4, phaseid=29181, deliveryref=85114176, status=60, producttype=2}
Pool Data : pool connections = 39 out of a max. 100
03/24/2022 10:30:52   SQLExecuteMaps 2:
            select productquantityperpackage,producttype from  products
            where productcode = 'HKQ205_P' and productactive = 1  AND producttype = 32
            
03/24/2022 10:30:52   SQLExecuteMaps 2: Select ins.*,cl.clientname,wr.warehousename,cws.status_name,IFNULL(idp.count,0) AS prodcount, cpt.product_type_name
                from  outbound_delivery ins
                inner join clients cl on cl.id = ins.clientid inner join warehouses wr on wr.id = ins.warehouseid
                inner join config_workflow_status_mobile cws on cws.id = ins.schstatus
                inner join config_product_type cpt on ins.producttype = cpt.product_type_stage_id
                LEFT JOIN (SELECT COUNT(DISTINCT idp.id) count, idp.deliveryid
                           FROM outbound_delivery_products  idp
                           WHERE idp.productidactive = 1
                           GROUP BY idp.deliveryid) idp
                           ON idp.deliveryid = ins.id
                where ins.schstatus in (60) AND deliveryactive = 1 And producttype in (31,32,33,4,5)
                GROUP BY ins.id
                 order by updateddate desc  LIMIT 0 , 50
03/24/2022 10:30:52   SQLExecuteMaps 2:
            select isp.*, prd.productname,prd.productcode from  outbound_delivery_products isp inner join products prd on prd.id = isp.productid
            where deliveryid = 29181 and productidactive = 1   order by createddate desc LIMIT  0, 10000
            
Pool Data : pool connections = 39 out of a max. 100
Pool Data : pool connections = 39 out of a max. 100
Pool Data : pool connections = 39 out of a max. 100
Pool Data : pool connections = 39 out of a max. 100
03/24/2022 10:30:52   SQLExecuteMaps 2:
            select productquantityperpackage,producttype from  products
            where productcode = 'H1PJ700_N' and productactive = 1  AND producttype = 1
            
03/24/2022 10:30:52   SQLExecuteMaps 2:
            select productquantityperpackage,producttype from  products
            where productcode = 'HRV140_P' and productactive = 1  AND producttype = 32
            
03/24/2022 10:30:52   SQLExecuteMaps 2: Select ins.*,cl.clientname,wr.warehousename,cws.status_name,IFNULL(idp.count,0) AS prodcount, cpt.product_type_name
                from  outbound_delivery ins
                inner join clients cl on cl.id = ins.clientid inner join warehouses wr on wr.id = ins.warehouseid
                inner join config_workflow_status_mobile cws on cws.id = ins.schstatus
                inner join config_product_type cpt on ins.producttype = cpt.product_type_stage_id
                LEFT JOIN (SELECT COUNT(DISTINCT idp.id) count, idp.deliveryid
                           FROM outbound_delivery_products  idp
                           WHERE idp.productidactive = 1
                           GROUP BY idp.deliveryid) idp
                           ON idp.deliveryid = ins.id
                where ins.schstatus in (60) AND deliveryactive = 1 And producttype in (31,32,33)
                GROUP BY ins.id
                 order by updateddate desc  LIMIT 0 , 50
03/24/2022 10:30:52   SQLExecuteMaps 2: SELECT * FROM products WHERE productactive= ? AND productcode= ? AND producttype= ?
(ArrayList) [29181, 744, 2201WD2034, 35.0, 100000000000157218]

                Select id from outbound_delivery_products where productidactive=1 AND deliveryid =? AND productid = ? AND productbatch=? AND productquantity=?  AND hku=?
    
(MyMap) {clienttype=External, productcode=SASOLWAX_M3B_PPE20, producttypeflag=2, bayno=NA, palletno=1, isexported=0, packeddate=, producttype=2, productidactive=1, isdamaged=0, productbatch=2201WD2034, labno=, deliveryid=29181, hku=100000000000157218, warehouseid=4, productquantity=35.0, productdeliveryno=85114176, movement=0, createddate=1648110652700, userid=160, productid=744, source=2}
Pool Data : pool connections = 42 out of a max. 100
Pool Data : pool connections = 45 out of a max. 100
03/24/2022 10:30:52   SQLExecuteMap 1: SELECT * FROM drpw_users WHERE email= ?
AppPackage za.co.sammarlogistics.live
Pool Data : pool connections = 45 out of a max. 100
 

prajinpraveen

Active Member
Licensed User
Longtime User
B4X:
msoutdeliveryCreateUpdate
java.lang.RuntimeException: java.io.IOException: java.lang.InterruptedException
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:138)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:96)
    at anywheresoftware.b4j.object.JServlet$Handle.run(JServlet.java:130)
    at anywheresoftware.b4j.object.JServlet.Handle(JServlet.java:110)
    at anywheresoftware.b4j.object.JServlet.doPost(JServlet.java:80)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)
    at org.eclipse.jetty.servlets.DoSFilter.doFilterChain(DoSFilter.java:482)
    at org.eclipse.jetty.servlets.DoSFilter.doFilter(DoSFilter.java:327)
    at org.eclipse.jetty.servlets.DoSFilter.doFilter(DoSFilter.java:297)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
    at anywheresoftware.b4j.object.JServlet$Handle.run(JServlet.java:135)
    at anywheresoftware.b4j.object.JServlet.Handle(JServlet.java:110)
    at anywheresoftware.b4j.object.JServlet.doFilter(JServlet.java:72)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
    at anywheresoftware.b4j.object.JServlet$Handle.run(JServlet.java:135)
    at anywheresoftware.b4j.object.JServlet.Handle(JServlet.java:110)
    at anywheresoftware.b4j.object.JServlet.doFilter(JServlet.java:72)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
    at org.eclipse.jetty.servlets.CrossOriginFilter.handle(CrossOriginFilter.java:311)
    at org.eclipse.jetty.servlets.CrossOriginFilter.doFilter(CrossOriginFilter.java:265)
    at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
    at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
    at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)
    at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:724)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
    at org.eclipse.jetty.server.Server.handle(Server.java:531)
    at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)
    at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
    at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)
    at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)
    at org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:291)
    at org.eclipse.jetty.io.ssl.SslConnection$3.succeeded(SslConnection.java:151)
    at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)
    at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
    at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
    at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
    at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
    at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
    at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:760)
    at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:678)
    at java.base/java.lang.Thread.run(Thread.java:831)
Caused by: java.io.IOException: java.lang.InterruptedException
    at org.eclipse.jetty.server.HttpInput$ErrorState.noContent(HttpInput.java:1075)
    at org.eclipse.jetty.server.HttpInput.read(HttpInput.java:313)
    at java.base/java.io.InputStream.read(InputStream.java:218)
    at anywheresoftware.b4a.objects.streams.File.Copy2(File.java:375)
    at za.co.irays.slms.upload._handle(upload.java:451)
    at jdk.internal.reflect.GeneratedMethodAccessor45.invoke(Unknown Source)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:567)
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:109)
    ... 54 more
Caused by: java.lang.InterruptedException
    at java.base/java.lang.Object.wait(Native Method)
    at java.base/java.lang.Object.wait(Object.java:320)
    at org.eclipse.jetty.server.HttpInput.blockForContent(HttpInput.java:570)
    at org.eclipse.jetty.server.HttpInput$1.blockForContent(HttpInput.java:1090)
    at org.eclipse.jetty.server.HttpInput.read(HttpInput.java:310)
    ... 61 more
    Suppressed: java.lang.Throwable: HttpInput failure
        at org.eclipse.jetty.server.HttpInput.failed(HttpInput.java:821)
        at org.eclipse.jetty.server.HttpConnection$BlockingReadCallback.failed(HttpConnection.java:649)
        at org.eclipse.jetty.server.HttpConnection.blockingReadFailure(HttpConnection.java:590)
        at org.eclipse.jetty.server.HttpChannelOverHttp.onBlockWaitForContentFailure(HttpChannelOverHttp.java:266)
        at org.eclipse.jetty.server.HttpInput.blockForContent(HttpInput.java:577)
        ... 63 more
 
Upvote 0

prajinpraveen

Active Member
Licensed User
Longtime User
Thanks Erel. the downside is that the pool connections keeps increasing with every failure. I have moved to Hikari CP and monitoring the pool utilization.
 
Upvote 0
Cookies are required to use this site. You must accept them to continue using the site. Learn more…