mycontroller-org / mycontroller-v1-legacy

The Open Source Controller
http://www.MyController.org
Apache License 2.0
148 stars 90 forks source link

Invalid nodes, sensors and variables appearing #484

Open seant100 opened 5 years ago

seant100 commented 5 years ago

If the database fails to read / fetch node details, sensor details etc then new items are created and appear randomly. It therefore appears error handling for database reads does not prevent code from continuing to execute. This is causing all sorts of false nodes, sensors and variables to appear in the resources list.

jkandasa commented 5 years ago

@seant100 good catch!

jkandasa commented 5 years ago

@seant100 I have added a fix for this issue, could you please check it in SNAPSHOT version?

seant100 commented 5 years ago

@jkandasa Thank you. I have installed the new snapshot version. I will monitor over next few days

seant100 commented 5 years ago

@jkandasa Logs showing a lot of errors. Not sure if all are related to this issue. Here is log :

2018-11-28 13:09:24,955 INFO [main] [org.mycontroller.standalone.StartApp:101] 

****************************************** Data Processing Agreement *******************************************
By using this software you agree that the following non-PII (non personally identifiable information data       
will be collected, processed and used by MyController.org for the purpose of improving quality of this software.
----------------------------------------------------------------------------------------------------------------
If you do not like to share anonymous data(non-PII), disable it in 'mycontroller/conf/mycontroller.properties'  
by setting 'mcc.collect.anonymous.data=false' and **restart** this server and **logout and login** in the UI.   
                                          ------ Thank you! ------                                              
****************************************************************************************************************

2018-11-28 13:09:25,040 INFO [main] [org.mycontroller.standalone.AppProperties:527] Created directory location: [/opt/mycontroller/conf/resources/scripts/conditions]
2018-11-28 13:09:25,237 INFO [main] [org.mycontroller.standalone.db.DataBaseUtils:117] Checking migration...
2018-11-28 13:09:39,903 INFO [main] [org.mycontroller.standalone.db.DataBaseUtils:168] Application information: [Version:1.4.0-SNAPSHOT, Database(type:H2 database embedded, version:1.4.194 (2017-03-10), schema version:1.04.05 - 2018 Sep 11), Built on:2018-11-28T10:00:16+0530, Git commit:416799039a8912365b9fa6fd3a8b765112acb59f:development]
2018-11-28 13:09:40,376 INFO [main] [org.mycontroller.standalone.offheap.OffHeapFactory:95] Cleared McPersistent location[../conf/persistent_stores/mc/]
2018-11-28 13:09:40,378 INFO [main] [org.mycontroller.standalone.AppProperties:527] Created directory location: [/opt/mycontroller/conf/persistent_stores/mc]
2018-11-28 13:09:41,457 ERROR [mc-th-pool-1] [org.mycontroller.standalone.McUncaughtException:73] Exception,
java.lang.NullPointerException: null
    at org.mycontroller.standalone.gateway.mqtt.MQTTDriver.connect(MQTTDriver.java:102)
    at org.mycontroller.standalone.gateway.mqtt.GatewayMQTT.connect(GatewayMQTT.java:50)
    at org.mycontroller.standalone.provider.EngineAbstract.run(EngineAbstract.java:127)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
2018-11-28 13:09:41,569 INFO [mc-th-pool-0] [org.mycontroller.standalone.gateway.mqtt.MQTTDriver:94] MQTT Gateway[name:MySensors-RF24, URI:tcp://localhost:1883, NetworkType:MySensors] connected successfully..
2018-11-28 13:09:44,557 INFO [main] [org.mycontroller.standalone.StartApp:238] TJWS server started successfully, HTTPS Enabled?:true, HTTP(S) Port: [8443]
2018-11-28 13:09:45,149 INFO [main] [org.mycontroller.standalone.api.GoogleAnalyticsApi:94] Google analytics details[enabled:false, ga_anonymous_id:da465915-c942-4a3e-a26a-6865fd5dce55]
2018-11-28 13:09:45,150 INFO [main] [org.mycontroller.standalone.StartApp:136] MyController.org server started in [19585] ms
2018-11-28 13:11:05,846 WARN [mc-th-pool-9] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:11:36,215 WARN [mc-th-pool-5] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:12:05,129 INFO [mc-th-pool-10] [org.mycontroller.standalone.gateway.mqtt.MQTTDriver:94] MQTT Gateway[name:MySensors-BatteryMonitor, URI:tcp://localhost:1883, NetworkType:MySensors] connected successfully..
2018-11-28 13:12:09,092 WARN [mc-th-pool-3] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:12:12,480 WARN [mc-th-pool-2] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:12:12,512 WARN [mc-th-pool-6] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:12:19,930 WARN [mc-th-pool-8] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:12:27,237 WARN [mc-th-pool-3] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:12:27,248 WARN [mc-th-pool-9] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:12:31,783 WARN [mc-th-pool-8] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:12:31,783 WARN [mc-th-pool-2] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:12:34,618 WARN [mc-th-pool-6] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:12:38,779 WARN [mc-th-pool-4] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:12:38,801 WARN [mc-th-pool-2] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:12:46,158 WARN [mc-th-pool-3] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:12:50,290 WARN [mc-th-pool-4] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:12:50,326 WARN [mc-th-pool-7] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:13:20,459 WARN [mc-th-pool-3] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:13:20,496 WARN [mc-th-pool-8] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:13:50,397 WARN [mc-th-pool-7] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:13:50,498 WARN [mc-th-pool-5] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:14:20,614 WARN [mc-th-pool-6] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:14:20,615 WARN [mc-th-pool-8] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:14:50,198 WARN [mc-th-pool-9] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:14:50,209 WARN [mc-th-pool-8] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:14:50,341 WARN [mc-th-pool-2] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:14:50,371 WARN [mc-th-pool-6] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:14:50,423 WARN [mc-th-pool-3] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:15:21,434 WARN [mc-th-pool-7] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:15:21,435 WARN [mc-th-pool-5] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:15:52,193 WARN [mc-th-pool-8] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:15:52,219 WARN [mc-th-pool-7] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:15:56,125 WARN [mc-th-pool-2] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:15:59,208 WARN [mc-th-pool-9] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:16:26,198 WARN [mc-th-pool-5] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:16:26,249 WARN [mc-th-pool-7] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:16:56,818 WARN [mc-th-pool-3] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:16:57,037 WARN [mc-th-pool-7] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:16:57,140 WARN [mc-th-pool-6] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:17:01,021 WARN [mc-th-pool-9] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:18:43,579 WARN [mc-th-pool-7] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:19:10,234 WARN [mc-th-pool-8] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:19:10,251 WARN [mc-th-pool-6] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:19:38,348 WARN [mc-th-pool-4] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
[Wed Nov 28 13:19:38 SAST 2018] Unexpected problem running servlet
org.jboss.resteasy.spi.UnhandledException: RESTEASY003770: Response is committed, can't handle exception
    at org.jboss.resteasy.core.SynchronousDispatcher.writeException(SynchronousDispatcher.java:167)
    at org.jboss.resteasy.core.SynchronousDispatcher.writeResponse(SynchronousDispatcher.java:471)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:415)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:202)
    at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:221)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
    at org.jboss.resteasy.plugins.server.tjws.TJWSServletDispatcher.service(TJWSServletDispatcher.java:40)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at Acme.Serve.Serve$ServeConnection.runServlet(Serve.java:2328)
    at Acme.Serve.Serve$ServeConnection.parseRequest(Serve.java:2282)
    at Acme.Serve.Serve$ServeConnection.run(Serve.java:2054)
    at Acme.Utils$ThreadPool$PooledThread.run(Utils.java:1402)
    at java.lang.Thread.run(Thread.java:748)
Caused by: java.net.SocketException: Broken pipe (Write failed)
    at java.net.SocketOutputStream.socketWrite0(Native Method)
    at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)
    at java.net.SocketOutputStream.write(SocketOutputStream.java:155)
    at sun.security.ssl.OutputRecord.writeBuffer(OutputRecord.java:431)
    at sun.security.ssl.OutputRecord.write(OutputRecord.java:417)
    at sun.security.ssl.SSLSocketImpl.writeRecordInternal(SSLSocketImpl.java:886)
    at sun.security.ssl.SSLSocketImpl.writeRecord(SSLSocketImpl.java:857)
    at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:123)
    at java.io.OutputStream.write(OutputStream.java:75)
    at Acme.Serve.Serve$ServeOutputStream.flush(Serve.java:4893)
    at Acme.Serve.Serve$ServeOutputStream.close(Serve.java:4923)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletResponseWrapper$DeferredOutputStream.close(HttpServletResponseWrapper.java:58)
    at org.jboss.resteasy.util.CommitHeaderOutputStream.close(CommitHeaderOutputStream.java:87)
    at org.jboss.resteasy.util.DelegatingOutputStream.close(DelegatingOutputStream.java:60)
    at com.fasterxml.jackson.core.json.UTF8JsonGenerator.close(UTF8JsonGenerator.java:1060)
    at org.jboss.resteasy.plugins.providers.jackson.ResteasyJackson2Provider.writeTo(ResteasyJackson2Provider.java:209)
    at org.mycontroller.standalone.api.jaxrs.mixins.McJacksonJson2Provider.writeTo(McJacksonJson2Provider.java:120)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.writeTo(AbstractWriterInterceptorContext.java:131)
    at org.jboss.resteasy.core.interception.ServerWriterInterceptorContext.writeTo(ServerWriterInterceptorContext.java:60)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.proceed(AbstractWriterInterceptorContext.java:120)
    at org.jboss.resteasy.plugins.interceptors.encoding.GZIPEncodingInterceptor.aroundWriteTo(GZIPEncodingInterceptor.java:100)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.proceed(AbstractWriterInterceptorContext.java:124)
    at org.jboss.resteasy.core.ServerResponseWriter.writeNomapResponse(ServerResponseWriter.java:98)
    at org.jboss.resteasy.core.SynchronousDispatcher.writeResponse(SynchronousDispatcher.java:466)
    ... 12 more

[Wed Nov 28 13:19:38 SAST 2018] Unexpected problem running servlet: org.jboss.resteasy.spi.UnhandledException: RESTEASY003770: Response is committed, can't handle exception
[Wed Nov 28 13:19:38 SAST 2018] IO error: javax.net.ssl.SSLException: Connection has been shutdown: javax.net.ssl.SSLException: java.net.SocketException: Broken pipe (Write failed) in processing a request from /192.168.1.20:8443 / sun.security.ssl.SSLSocketImpl
[Wed Nov 28 13:19:38 SAST 2018] Unexpected problem running servlet
org.jboss.resteasy.spi.UnhandledException: RESTEASY003770: Response is committed, can't handle exception
    at org.jboss.resteasy.core.SynchronousDispatcher.writeException(SynchronousDispatcher.java:167)
    at org.jboss.resteasy.core.SynchronousDispatcher.writeResponse(SynchronousDispatcher.java:471)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:415)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:202)
    at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:221)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
    at org.jboss.resteasy.plugins.server.tjws.TJWSServletDispatcher.service(TJWSServletDispatcher.java:40)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at Acme.Serve.Serve$ServeConnection.runServlet(Serve.java:2328)
    at Acme.Serve.Serve$ServeConnection.parseRequest(Serve.java:2282)
    at Acme.Serve.Serve$ServeConnection.run(Serve.java:2054)
    at Acme.Utils$ThreadPool$PooledThread.run(Utils.java:1402)
    at java.lang.Thread.run(Thread.java:748)
Caused by: java.net.SocketException: Broken pipe (Write failed)
    at java.net.SocketOutputStream.socketWrite0(Native Method)
    at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)
    at java.net.SocketOutputStream.write(SocketOutputStream.java:155)
    at sun.security.ssl.OutputRecord.writeBuffer(OutputRecord.java:431)
    at sun.security.ssl.OutputRecord.write(OutputRecord.java:417)
    at sun.security.ssl.SSLSocketImpl.writeRecordInternal(SSLSocketImpl.java:886)
    at sun.security.ssl.SSLSocketImpl.writeRecord(SSLSocketImpl.java:857)
    at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:123)
    at java.io.OutputStream.write(OutputStream.java:75)
    at Acme.Serve.Serve$ServeOutputStream.flush(Serve.java:4889)
    at Acme.Serve.Serve$ServeOutputStream.close(Serve.java:4923)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletResponseWrapper$DeferredOutputStream.close(HttpServletResponseWrapper.java:58)
    at org.jboss.resteasy.util.CommitHeaderOutputStream.close(CommitHeaderOutputStream.java:87)
    at org.jboss.resteasy.util.DelegatingOutputStream.close(DelegatingOutputStream.java:60)
    at com.fasterxml.jackson.core.json.UTF8JsonGenerator.close(UTF8JsonGenerator.java:1060)
    at org.jboss.resteasy.plugins.providers.jackson.ResteasyJackson2Provider.writeTo(ResteasyJackson2Provider.java:209)
    at org.mycontroller.standalone.api.jaxrs.mixins.McJacksonJson2Provider.writeTo(McJacksonJson2Provider.java:120)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.writeTo(AbstractWriterInterceptorContext.java:131)
    at org.jboss.resteasy.core.interception.ServerWriterInterceptorContext.writeTo(ServerWriterInterceptorContext.java:60)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.proceed(AbstractWriterInterceptorContext.java:120)
    at org.jboss.resteasy.plugins.interceptors.encoding.GZIPEncodingInterceptor.aroundWriteTo(GZIPEncodingInterceptor.java:100)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.proceed(AbstractWriterInterceptorContext.java:124)
    at org.jboss.resteasy.core.ServerResponseWriter.writeNomapResponse(ServerResponseWriter.java:98)
    at org.jboss.resteasy.core.SynchronousDispatcher.writeResponse(SynchronousDispatcher.java:466)
    ... 12 more

[Wed Nov 28 13:19:38 SAST 2018] Unexpected problem running servlet: org.jboss.resteasy.spi.UnhandledException: RESTEASY003770: Response is committed, can't handle exception
[Wed Nov 28 13:19:38 SAST 2018] IO error: javax.net.ssl.SSLException: Connection has been shutdown: javax.net.ssl.SSLException: java.net.SocketException: Broken pipe (Write failed) in processing a request from /192.168.1.20:8443 / sun.security.ssl.SSLSocketImpl
[Wed Nov 28 13:20:36 SAST 2018] Unexpected problem running servlet
org.jboss.resteasy.spi.UnhandledException: RESTEASY003770: Response is committed, can't handle exception
    at org.jboss.resteasy.core.SynchronousDispatcher.writeException(SynchronousDispatcher.java:167)
    at org.jboss.resteasy.core.SynchronousDispatcher.writeResponse(SynchronousDispatcher.java:471)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:415)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:202)
    at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:221)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
    at org.jboss.resteasy.plugins.server.tjws.TJWSServletDispatcher.service(TJWSServletDispatcher.java:40)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at Acme.Serve.Serve$ServeConnection.runServlet(Serve.java:2328)
    at Acme.Serve.Serve$ServeConnection.parseRequest(Serve.java:2282)
    at Acme.Serve.Serve$ServeConnection.run(Serve.java:2054)
    at Acme.Utils$ThreadPool$PooledThread.run(Utils.java:1402)
    at java.lang.Thread.run(Thread.java:748)
Caused by: javax.net.ssl.SSLException: Connection has been shutdown: javax.net.ssl.SSLException: java.net.SocketException: Broken pipe (Write failed)
    at sun.security.ssl.SSLSocketImpl.checkEOF(SSLSocketImpl.java:1551)
    at sun.security.ssl.SSLSocketImpl.checkWrite(SSLSocketImpl.java:1563)
    at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:71)
    at java.io.OutputStream.write(OutputStream.java:75)
    at Acme.Serve.Serve$ServeOutputStream.flush(Serve.java:4889)
    at Acme.Serve.Serve$ServeOutputStream.close(Serve.java:4923)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletResponseWrapper$DeferredOutputStream.close(HttpServletResponseWrapper.java:58)
    at org.jboss.resteasy.util.CommitHeaderOutputStream.close(CommitHeaderOutputStream.java:87)
    at org.jboss.resteasy.util.DelegatingOutputStream.close(DelegatingOutputStream.java:60)
    at com.fasterxml.jackson.core.json.UTF8JsonGenerator.close(UTF8JsonGenerator.java:1060)
    at org.jboss.resteasy.plugins.providers.jackson.ResteasyJackson2Provider.writeTo(ResteasyJackson2Provider.java:209)
    at org.mycontroller.standalone.api.jaxrs.mixins.McJacksonJson2Provider.writeTo(McJacksonJson2Provider.java:120)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.writeTo(AbstractWriterInterceptorContext.java:131)
    at org.jboss.resteasy.core.interception.ServerWriterInterceptorContext.writeTo(ServerWriterInterceptorContext.java:60)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.proceed(AbstractWriterInterceptorContext.java:120)
    at org.jboss.resteasy.plugins.interceptors.encoding.GZIPEncodingInterceptor.aroundWriteTo(GZIPEncodingInterceptor.java:100)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.proceed(AbstractWriterInterceptorContext.java:124)
    at org.jboss.resteasy.core.ServerResponseWriter.writeNomapResponse(ServerResponseWriter.java:98)
    at org.jboss.resteasy.core.SynchronousDispatcher.writeResponse(SynchronousDispatcher.java:466)
    ... 12 more
Caused by: javax.net.ssl.SSLException: java.net.SocketException: Broken pipe (Write failed)
    at sun.security.ssl.Alerts.getSSLException(Alerts.java:208)
    at sun.security.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1959)
    at sun.security.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1916)
    at sun.security.ssl.SSLSocketImpl.handleException(SSLSocketImpl.java:1880)
    at sun.security.ssl.SSLSocketImpl.handleException(SSLSocketImpl.java:1825)
    at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:128)
    at java.io.OutputStream.write(OutputStream.java:75)
    at Acme.Serve.Serve$ServeOutputStream.write(Serve.java:4854)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletResponseWrapper$DeferredOutputStream.write(HttpServletResponseWrapper.java:46)
    at org.jboss.resteasy.util.CommitHeaderOutputStream.write(CommitHeaderOutputStream.java:71)
    at org.jboss.resteasy.util.DelegatingOutputStream.write(DelegatingOutputStream.java:48)
    at com.fasterxml.jackson.core.json.UTF8JsonGenerator._flushBuffer(UTF8JsonGenerator.java:2003)
    at com.fasterxml.jackson.core.json.UTF8JsonGenerator.flush(UTF8JsonGenerator.java:1019)
    at com.fasterxml.jackson.databind.ObjectMapper.writeValue(ObjectMapper.java:2385)
    at org.mycontroller.standalone.api.jaxrs.mixins.GatewayTableSerializer.serialize(GatewayMixin.java:64)
    at org.mycontroller.standalone.api.jaxrs.mixins.GatewayTableSerializer.serialize(GatewayMixin.java:59)
    at com.fasterxml.jackson.databind.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:693)
    at com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:675)
    at com.fasterxml.jackson.databind.ser.BeanSerializer.serialize(BeanSerializer.java:157)
    at com.fasterxml.jackson.databind.ser.impl.IndexedListSerializer.serializeContents(IndexedListSerializer.java:119)
    at com.fasterxml.jackson.databind.ser.impl.IndexedListSerializer.serialize(IndexedListSerializer.java:79)
    at com.fasterxml.jackson.databind.ser.impl.IndexedListSerializer.serialize(IndexedListSerializer.java:18)
    at com.fasterxml.jackson.databind.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:693)
    at com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:675)
    at com.fasterxml.jackson.databind.ser.BeanSerializer.serialize(BeanSerializer.java:157)
    at com.fasterxml.jackson.databind.ser.DefaultSerializerProvider.serializeValue(DefaultSerializerProvider.java:130)
    at com.fasterxml.jackson.databind.ObjectWriter$Prefetch.serialize(ObjectWriter.java:1387)
    at com.fasterxml.jackson.databind.ObjectWriter.writeValue(ObjectWriter.java:889)
    at org.jboss.resteasy.plugins.providers.jackson.ResteasyJackson2Provider.writeTo(ResteasyJackson2Provider.java:207)
    ... 20 more
Caused by: java.net.SocketException: Broken pipe (Write failed)
    at java.net.SocketOutputStream.socketWrite0(Native Method)
    at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)
    at java.net.SocketOutputStream.write(SocketOutputStream.java:155)
    at sun.security.ssl.OutputRecord.writeBuffer(OutputRecord.java:431)
    at sun.security.ssl.OutputRecord.write(OutputRecord.java:417)
    at sun.security.ssl.SSLSocketImpl.writeRecordInternal(SSLSocketImpl.java:886)
    at sun.security.ssl.SSLSocketImpl.writeRecord(SSLSocketImpl.java:857)
    at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:123)
    ... 43 more

[Wed Nov 28 13:20:36 SAST 2018] Unexpected problem running servlet: org.jboss.resteasy.spi.UnhandledException: RESTEASY003770: Response is committed, can't handle exception
[Wed Nov 28 13:20:36 SAST 2018] IO error: javax.net.ssl.SSLException: Connection has been shutdown: javax.net.ssl.SSLException: java.net.SocketException: Broken pipe (Write failed) in processing a request from /192.168.1.20:8443 / sun.security.ssl.SSLSocketImpl
2018-11-28 13:21:48,472 ERROR [mc-th-pool-3] [org.mycontroller.standalone.db.dao.BaseAbstractDaoImpl:431] unable to get all items key:conditionType, value:THRESHOLD
org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-194]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    at org.h2.message.DbException.get(DbException.java:168)
    at org.h2.message.DbException.convert(DbException.java:295)
    at org.h2.message.DbException.toSQLException(DbException.java:268)
    at org.h2.message.TraceObject.logAndConvert(TraceObject.java:352)
    at org.h2.jdbc.JdbcResultSet.findColumn(JdbcResultSet.java:188)
    at com.j256.ormlite.jdbc.JdbcDatabaseResults.findColumn(JdbcDatabaseResults.java:103)
    at com.j256.ormlite.field.FieldType.resultToJava(FieldType.java:826)
    at com.j256.ormlite.stmt.mapped.BaseMappedQuery.mapRow(BaseMappedQuery.java:61)
    at com.j256.ormlite.stmt.SelectIterator.getCurrent(SelectIterator.java:284)
    at com.j256.ormlite.stmt.SelectIterator.nextThrow(SelectIterator.java:168)
    at com.j256.ormlite.stmt.StatementExecutor.query(StatementExecutor.java:202)
    at com.j256.ormlite.dao.BaseDaoImpl.query(BaseDaoImpl.java:277)
    at com.j256.ormlite.stmt.QueryBuilder.query(QueryBuilder.java:366)
    at com.j256.ormlite.stmt.Where.query(Where.java:480)
    at org.mycontroller.standalone.db.dao.BaseAbstractDaoImpl.getAll(BaseAbstractDaoImpl.java:429)
    at org.mycontroller.standalone.rule.McRuleEngine.run(McRuleEngine.java:200)
    at org.mycontroller.standalone.provider.ExecuteMessageDependentTask.executeDependentTask(ExecuteMessageDependentTask.java:74)
    at org.mycontroller.standalone.provider.ExecuteMessageDependentTask.run(ExecuteMessageDependentTask.java:84)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.NullPointerException: null
    at org.h2.util.StringUtils.toUpperEnglish(StringUtils.java:106)
    at org.h2.jdbc.JdbcResultSet.getColumnIndex(JdbcResultSet.java:3129)
    at org.h2.jdbc.JdbcResultSet.findColumn(JdbcResultSet.java:186)
    ... 16 common frames omitted
2018-11-28 13:21:48,474 ERROR [mc-th-pool-3] [org.mycontroller.standalone.rule.McRuleEngine:228] Exception on ondemand thread job, 
org.mycontroller.standalone.exceptions.McDatabaseException: org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-194]
    at org.mycontroller.standalone.db.dao.BaseAbstractDaoImpl.getAll(BaseAbstractDaoImpl.java:432)
    at org.mycontroller.standalone.rule.McRuleEngine.run(McRuleEngine.java:200)
    at org.mycontroller.standalone.provider.ExecuteMessageDependentTask.executeDependentTask(ExecuteMessageDependentTask.java:74)
    at org.mycontroller.standalone.provider.ExecuteMessageDependentTask.run(ExecuteMessageDependentTask.java:84)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-194]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    at org.h2.message.DbException.get(DbException.java:168)
    at org.h2.message.DbException.convert(DbException.java:295)
    at org.h2.message.DbException.toSQLException(DbException.java:268)
    at org.h2.message.TraceObject.logAndConvert(TraceObject.java:352)
    at org.h2.jdbc.JdbcResultSet.findColumn(JdbcResultSet.java:188)
    at com.j256.ormlite.jdbc.JdbcDatabaseResults.findColumn(JdbcDatabaseResults.java:103)
    at com.j256.ormlite.field.FieldType.resultToJava(FieldType.java:826)
    at com.j256.ormlite.stmt.mapped.BaseMappedQuery.mapRow(BaseMappedQuery.java:61)
    at com.j256.ormlite.stmt.SelectIterator.getCurrent(SelectIterator.java:284)
    at com.j256.ormlite.stmt.SelectIterator.nextThrow(SelectIterator.java:168)
    at com.j256.ormlite.stmt.StatementExecutor.query(StatementExecutor.java:202)
    at com.j256.ormlite.dao.BaseDaoImpl.query(BaseDaoImpl.java:277)
    at com.j256.ormlite.stmt.QueryBuilder.query(QueryBuilder.java:366)
    at com.j256.ormlite.stmt.Where.query(Where.java:480)
    at org.mycontroller.standalone.db.dao.BaseAbstractDaoImpl.getAll(BaseAbstractDaoImpl.java:429)
    ... 6 common frames omitted
Caused by: java.lang.NullPointerException: null
    at org.h2.util.StringUtils.toUpperEnglish(StringUtils.java:106)
    at org.h2.jdbc.JdbcResultSet.getColumnIndex(JdbcResultSet.java:3129)
    at org.h2.jdbc.JdbcResultSet.findColumn(JdbcResultSet.java:186)
    ... 16 common frames omitted
2018-11-28 13:23:42,097 WARN [mc-th-pool-5] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:24:11,009 WARN [mc-th-pool-7] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:24:11,010 WARN [mc-th-pool-4] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:24:11,289 WARN [mc-th-pool-5] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:24:11,366 WARN [mc-th-pool-3] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
[Wed Nov 28 13:26:37 SAST 2018] Unexpected problem running servlet
org.jboss.resteasy.spi.UnhandledException: RESTEASY003770: Response is committed, can't handle exception
    at org.jboss.resteasy.core.SynchronousDispatcher.writeException(SynchronousDispatcher.java:167)
    at org.jboss.resteasy.core.SynchronousDispatcher.writeResponse(SynchronousDispatcher.java:471)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:415)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:202)
    at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:221)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
    at org.jboss.resteasy.plugins.server.tjws.TJWSServletDispatcher.service(TJWSServletDispatcher.java:40)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at Acme.Serve.Serve$ServeConnection.runServlet(Serve.java:2328)
    at Acme.Serve.Serve$ServeConnection.parseRequest(Serve.java:2282)
    at Acme.Serve.Serve$ServeConnection.run(Serve.java:2054)
    at Acme.Utils$ThreadPool$PooledThread.run(Utils.java:1402)
    at java.lang.Thread.run(Thread.java:748)
Caused by: javax.net.ssl.SSLException: Connection has been shutdown: javax.net.ssl.SSLException: java.net.SocketException: Broken pipe (Write failed)
    at sun.security.ssl.SSLSocketImpl.checkEOF(SSLSocketImpl.java:1551)
    at sun.security.ssl.SSLSocketImpl.checkWrite(SSLSocketImpl.java:1563)
    at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:71)
    at java.io.OutputStream.write(OutputStream.java:75)
    at Acme.Serve.Serve$ServeOutputStream.flush(Serve.java:4889)
    at Acme.Serve.Serve$ServeOutputStream.close(Serve.java:4923)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletResponseWrapper$DeferredOutputStream.close(HttpServletResponseWrapper.java:58)
    at org.jboss.resteasy.util.CommitHeaderOutputStream.close(CommitHeaderOutputStream.java:87)
    at org.jboss.resteasy.util.DelegatingOutputStream.close(DelegatingOutputStream.java:60)
    at com.fasterxml.jackson.core.json.UTF8JsonGenerator.close(UTF8JsonGenerator.java:1060)
    at org.jboss.resteasy.plugins.providers.jackson.ResteasyJackson2Provider.writeTo(ResteasyJackson2Provider.java:209)
    at org.mycontroller.standalone.api.jaxrs.mixins.McJacksonJson2Provider.writeTo(McJacksonJson2Provider.java:120)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.writeTo(AbstractWriterInterceptorContext.java:131)
    at org.jboss.resteasy.core.interception.ServerWriterInterceptorContext.writeTo(ServerWriterInterceptorContext.java:60)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.proceed(AbstractWriterInterceptorContext.java:120)
    at org.jboss.resteasy.plugins.interceptors.encoding.GZIPEncodingInterceptor.aroundWriteTo(GZIPEncodingInterceptor.java:100)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.proceed(AbstractWriterInterceptorContext.java:124)
    at org.jboss.resteasy.core.ServerResponseWriter.writeNomapResponse(ServerResponseWriter.java:98)
    at org.jboss.resteasy.core.SynchronousDispatcher.writeResponse(SynchronousDispatcher.java:466)
    ... 12 more
Caused by: javax.net.ssl.SSLException: java.net.SocketException: Broken pipe (Write failed)
    at sun.security.ssl.Alerts.getSSLException(Alerts.java:208)
    at sun.security.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1959)
    at sun.security.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1916)
    at sun.security.ssl.SSLSocketImpl.handleException(SSLSocketImpl.java:1880)
    at sun.security.ssl.SSLSocketImpl.handleException(SSLSocketImpl.java:1825)
    at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:128)
    at java.io.OutputStream.write(OutputStream.java:75)
    at Acme.Serve.Serve$ServeOutputStream.write(Serve.java:4854)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletResponseWrapper$DeferredOutputStream.write(HttpServletResponseWrapper.java:46)
    at org.jboss.resteasy.util.CommitHeaderOutputStream.write(CommitHeaderOutputStream.java:71)
    at org.jboss.resteasy.util.DelegatingOutputStream.write(DelegatingOutputStream.java:48)
    at com.fasterxml.jackson.core.json.UTF8JsonGenerator._flushBuffer(UTF8JsonGenerator.java:2003)
    at com.fasterxml.jackson.core.json.UTF8JsonGenerator.writeRaw(UTF8JsonGenerator.java:597)
    at com.fasterxml.jackson.core.json.UTF8JsonGenerator.writeRaw(UTF8JsonGenerator.java:542)
    at com.fasterxml.jackson.core.util.DefaultPrettyPrinter.writeObjectFieldValueSeparator(DefaultPrettyPrinter.java:287)
    at com.fasterxml.jackson.core.json.UTF8JsonGenerator._verifyPrettyValueWrite(UTF8JsonGenerator.java:991)
    at com.fasterxml.jackson.core.json.UTF8JsonGenerator._verifyValueWrite(UTF8JsonGenerator.java:980)
    at com.fasterxml.jackson.core.json.UTF8JsonGenerator.writeString(UTF8JsonGenerator.java:424)
    at org.mycontroller.standalone.api.jaxrs.mixins.serializers.MessageTypeSerializer.serialize(MessageTypeSerializer.java:39)
    at org.mycontroller.standalone.api.jaxrs.mixins.serializers.MessageTypeSerializer.serialize(MessageTypeSerializer.java:33)
    at com.fasterxml.jackson.databind.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:693)
    at com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:675)
    at com.fasterxml.jackson.databind.ser.BeanSerializer.serialize(BeanSerializer.java:157)
    at com.fasterxml.jackson.databind.ser.impl.IndexedListSerializer.serializeContents(IndexedListSerializer.java:119)
    at com.fasterxml.jackson.databind.ser.impl.IndexedListSerializer.serialize(IndexedListSerializer.java:79)
    at com.fasterxml.jackson.databind.ser.impl.IndexedListSerializer.serialize(IndexedListSerializer.java:18)
    at com.fasterxml.jackson.databind.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:693)
    at com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:675)
    at com.fasterxml.jackson.databind.ser.BeanSerializer.serialize(BeanSerializer.java:157)
    at com.fasterxml.jackson.databind.ser.DefaultSerializerProvider.serializeValue(DefaultSerializerProvider.java:130)
    at com.fasterxml.jackson.databind.ObjectWriter$Prefetch.serialize(ObjectWriter.java:1387)
    at com.fasterxml.jackson.databind.ObjectWriter.writeValue(ObjectWriter.java:889)
    at org.jboss.resteasy.plugins.providers.jackson.ResteasyJackson2Provider.writeTo(ResteasyJackson2Provider.java:207)
    ... 20 more
Caused by: java.net.SocketException: Broken pipe (Write failed)
    at java.net.SocketOutputStream.socketWrite0(Native Method)
    at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)
    at java.net.SocketOutputStream.write(SocketOutputStream.java:155)
    at sun.security.ssl.OutputRecord.writeBuffer(OutputRecord.java:431)
    at sun.security.ssl.OutputRecord.write(OutputRecord.java:417)
    at sun.security.ssl.SSLSocketImpl.writeRecordInternal(SSLSocketImpl.java:886)
    at sun.security.ssl.SSLSocketImpl.writeRecord(SSLSocketImpl.java:857)
    at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:123)
    ... 47 more

[Wed Nov 28 13:26:37 SAST 2018] Unexpected problem running servlet: org.jboss.resteasy.spi.UnhandledException: RESTEASY003770: Response is committed, can't handle exception
[Wed Nov 28 13:26:37 SAST 2018] IO error: javax.net.ssl.SSLException: Connection has been shutdown: javax.net.ssl.SSLException: java.net.SocketException: Broken pipe (Write failed) in processing a request from /192.168.1.20:8443 / sun.security.ssl.SSLSocketImpl
[Wed Nov 28 13:27:35 SAST 2018] Unexpected problem running servlet
org.jboss.resteasy.spi.UnhandledException: RESTEASY003770: Response is committed, can't handle exception
    at org.jboss.resteasy.core.SynchronousDispatcher.writeException(SynchronousDispatcher.java:167)
    at org.jboss.resteasy.core.SynchronousDispatcher.writeResponse(SynchronousDispatcher.java:471)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:415)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:202)
    at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:221)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
    at org.jboss.resteasy.plugins.server.tjws.TJWSServletDispatcher.service(TJWSServletDispatcher.java:40)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at Acme.Serve.Serve$ServeConnection.runServlet(Serve.java:2328)
    at Acme.Serve.Serve$ServeConnection.parseRequest(Serve.java:2282)
    at Acme.Serve.Serve$ServeConnection.run(Serve.java:2054)
    at Acme.Utils$ThreadPool$PooledThread.run(Utils.java:1402)
    at java.lang.Thread.run(Thread.java:748)
Caused by: java.net.SocketException: Broken pipe (Write failed)
    at java.net.SocketOutputStream.socketWrite0(Native Method)
    at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)
    at java.net.SocketOutputStream.write(SocketOutputStream.java:155)
    at sun.security.ssl.OutputRecord.writeBuffer(OutputRecord.java:431)
    at sun.security.ssl.OutputRecord.write(OutputRecord.java:417)
    at sun.security.ssl.SSLSocketImpl.writeRecordInternal(SSLSocketImpl.java:886)
    at sun.security.ssl.SSLSocketImpl.writeRecord(SSLSocketImpl.java:857)
    at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:123)
    at java.io.OutputStream.write(OutputStream.java:75)
    at Acme.Serve.Serve$ServeOutputStream.close(Serve.java:4928)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletResponseWrapper$DeferredOutputStream.close(HttpServletResponseWrapper.java:58)
    at org.jboss.resteasy.util.CommitHeaderOutputStream.close(CommitHeaderOutputStream.java:87)
    at org.jboss.resteasy.util.DelegatingOutputStream.close(DelegatingOutputStream.java:60)
    at com.fasterxml.jackson.core.json.UTF8JsonGenerator.close(UTF8JsonGenerator.java:1060)
    at org.jboss.resteasy.plugins.providers.jackson.ResteasyJackson2Provider.writeTo(ResteasyJackson2Provider.java:209)
    at org.mycontroller.standalone.api.jaxrs.mixins.McJacksonJson2Provider.writeTo(McJacksonJson2Provider.java:120)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.writeTo(AbstractWriterInterceptorContext.java:131)
    at org.jboss.resteasy.core.interception.ServerWriterInterceptorContext.writeTo(ServerWriterInterceptorContext.java:60)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.proceed(AbstractWriterInterceptorContext.java:120)
    at org.jboss.resteasy.plugins.interceptors.encoding.GZIPEncodingInterceptor.aroundWriteTo(GZIPEncodingInterceptor.java:100)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.proceed(AbstractWriterInterceptorContext.java:124)
    at org.jboss.resteasy.core.ServerResponseWriter.writeNomapResponse(ServerResponseWriter.java:98)
    at org.jboss.resteasy.core.SynchronousDispatcher.writeResponse(SynchronousDispatcher.java:466)
    ... 12 more

[Wed Nov 28 13:27:35 SAST 2018] Unexpected problem running servlet: org.jboss.resteasy.spi.UnhandledException: RESTEASY003770: Response is committed, can't handle exception
[Wed Nov 28 13:27:35 SAST 2018] IO error: javax.net.ssl.SSLException: Connection has been shutdown: javax.net.ssl.SSLException: java.net.SocketException: Broken pipe (Write failed) in processing a request from /192.168.1.20:8443 / sun.security.ssl.SSLSocketImpl
[Wed Nov 28 13:27:36 SAST 2018] Unexpected problem running servlet
org.jboss.resteasy.spi.UnhandledException: RESTEASY003770: Response is committed, can't handle exception
    at org.jboss.resteasy.core.SynchronousDispatcher.writeException(SynchronousDispatcher.java:167)
    at org.jboss.resteasy.core.SynchronousDispatcher.writeResponse(SynchronousDispatcher.java:471)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:415)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:202)
    at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:221)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
    at org.jboss.resteasy.plugins.server.tjws.TJWSServletDispatcher.service(TJWSServletDispatcher.java:40)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at Acme.Serve.Serve$ServeConnection.runServlet(Serve.java:2328)
    at Acme.Serve.Serve$ServeConnection.parseRequest(Serve.java:2282)
    at Acme.Serve.Serve$ServeConnection.run(Serve.java:2054)
    at Acme.Utils$ThreadPool$PooledThread.run(Utils.java:1402)
    at java.lang.Thread.run(Thread.java:748)
Caused by: java.net.SocketException: Broken pipe (Write failed)
    at java.net.SocketOutputStream.socketWrite0(Native Method)
    at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)
    at java.net.SocketOutputStream.write(SocketOutputStream.java:155)
    at sun.security.ssl.OutputRecord.writeBuffer(OutputRecord.java:431)
    at sun.security.ssl.OutputRecord.write(OutputRecord.java:417)
    at sun.security.ssl.SSLSocketImpl.writeRecordInternal(SSLSocketImpl.java:886)
    at sun.security.ssl.SSLSocketImpl.writeRecord(SSLSocketImpl.java:857)
    at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:123)
    at java.io.OutputStream.write(OutputStream.java:75)
    at Acme.Serve.Serve$ServeOutputStream.flush(Serve.java:4893)
    at Acme.Serve.Serve$ServeOutputStream.close(Serve.java:4923)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletResponseWrapper$DeferredOutputStream.close(HttpServletResponseWrapper.java:58)
    at org.jboss.resteasy.util.CommitHeaderOutputStream.close(CommitHeaderOutputStream.java:87)
    at org.jboss.resteasy.util.DelegatingOutputStream.close(DelegatingOutputStream.java:60)
    at com.fasterxml.jackson.core.json.UTF8JsonGenerator.close(UTF8JsonGenerator.java:1060)
    at org.jboss.resteasy.plugins.providers.jackson.ResteasyJackson2Provider.writeTo(ResteasyJackson2Provider.java:209)
    at org.mycontroller.standalone.api.jaxrs.mixins.McJacksonJson2Provider.writeTo(McJacksonJson2Provider.java:120)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.writeTo(AbstractWriterInterceptorContext.java:131)
    at org.jboss.resteasy.core.interception.ServerWriterInterceptorContext.writeTo(ServerWriterInterceptorContext.java:60)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.proceed(AbstractWriterInterceptorContext.java:120)
    at org.jboss.resteasy.plugins.interceptors.encoding.GZIPEncodingInterceptor.aroundWriteTo(GZIPEncodingInterceptor.java:100)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.proceed(AbstractWriterInterceptorContext.java:124)
    at org.jboss.resteasy.core.ServerResponseWriter.writeNomapResponse(ServerResponseWriter.java:98)
    at org.jboss.resteasy.core.SynchronousDispatcher.writeResponse(SynchronousDispatcher.java:466)
    ... 12 more

[Wed Nov 28 13:27:36 SAST 2018] Unexpected problem running servlet: org.jboss.resteasy.spi.UnhandledException: RESTEASY003770: Response is committed, can't handle exception
[Wed Nov 28 13:27:36 SAST 2018] IO error: javax.net.ssl.SSLException: Connection has been shutdown: javax.net.ssl.SSLException: java.net.SocketException: Broken pipe (Write failed) in processing a request from /192.168.1.20:8443 / sun.security.ssl.SSLSocketImpl
[Wed Nov 28 13:27:36 SAST 2018] Unexpected problem running servlet
org.jboss.resteasy.spi.UnhandledException: RESTEASY003770: Response is committed, can't handle exception
    at org.jboss.resteasy.core.SynchronousDispatcher.writeException(SynchronousDispatcher.java:167)
    at org.jboss.resteasy.core.SynchronousDispatcher.writeResponse(SynchronousDispatcher.java:471)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:415)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:202)
    at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:221)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
    at org.jboss.resteasy.plugins.server.tjws.TJWSServletDispatcher.service(TJWSServletDispatcher.java:40)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at Acme.Serve.Serve$ServeConnection.runServlet(Serve.java:2328)
    at Acme.Serve.Serve$ServeConnection.parseRequest(Serve.java:2282)
    at Acme.Serve.Serve$ServeConnection.run(Serve.java:2054)
    at Acme.Utils$ThreadPool$PooledThread.run(Utils.java:1402)
    at java.lang.Thread.run(Thread.java:748)
Caused by: java.net.SocketException: Broken pipe (Write failed)
    at java.net.SocketOutputStream.socketWrite0(Native Method)
    at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)
    at java.net.SocketOutputStream.write(SocketOutputStream.java:155)
    at sun.security.ssl.OutputRecord.writeBuffer(OutputRecord.java:431)
    at sun.security.ssl.OutputRecord.write(OutputRecord.java:417)
    at sun.security.ssl.SSLSocketImpl.writeRecordInternal(SSLSocketImpl.java:886)
    at sun.security.ssl.SSLSocketImpl.writeRecord(SSLSocketImpl.java:857)
    at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:123)
    at java.io.OutputStream.write(OutputStream.java:75)
    at Acme.Serve.Serve$ServeOutputStream.flush(Serve.java:4893)
    at Acme.Serve.Serve$ServeOutputStream.close(Serve.java:4923)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletResponseWrapper$DeferredOutputStream.close(HttpServletResponseWrapper.java:58)
    at org.jboss.resteasy.util.CommitHeaderOutputStream.close(CommitHeaderOutputStream.java:87)
    at org.jboss.resteasy.util.DelegatingOutputStream.close(DelegatingOutputStream.java:60)
    at com.fasterxml.jackson.core.json.UTF8JsonGenerator.close(UTF8JsonGenerator.java:1060)
    at org.jboss.resteasy.plugins.providers.jackson.ResteasyJackson2Provider.writeTo(ResteasyJackson2Provider.java:209)
    at org.mycontroller.standalone.api.jaxrs.mixins.McJacksonJson2Provider.writeTo(McJacksonJson2Provider.java:120)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.writeTo(AbstractWriterInterceptorContext.java:131)
    at org.jboss.resteasy.core.interception.ServerWriterInterceptorContext.writeTo(ServerWriterInterceptorContext.java:60)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.proceed(AbstractWriterInterceptorContext.java:120)
    at org.jboss.resteasy.plugins.interceptors.encoding.GZIPEncodingInterceptor.aroundWriteTo(GZIPEncodingInterceptor.java:100)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.proceed(AbstractWriterInterceptorContext.java:124)
    at org.jboss.resteasy.core.ServerResponseWriter.writeNomapResponse(ServerResponseWriter.java:98)
    at org.jboss.resteasy.core.SynchronousDispatcher.writeResponse(SynchronousDispatcher.java:466)
    ... 12 more

[Wed Nov 28 13:27:36 SAST 2018] Unexpected problem running servlet: org.jboss.resteasy.spi.UnhandledException: RESTEASY003770: Response is committed, can't handle exception
[Wed Nov 28 13:27:36 SAST 2018] IO error: javax.net.ssl.SSLException: Connection has been shutdown: javax.net.ssl.SSLException: java.net.SocketException: Broken pipe (Write failed) in processing a request from /192.168.1.20:8443 / sun.security.ssl.SSLSocketImpl
[Wed Nov 28 13:27:36 SAST 2018] Unexpected problem running servlet
org.jboss.resteasy.spi.UnhandledException: RESTEASY003770: Response is committed, can't handle exception
    at org.jboss.resteasy.core.SynchronousDispatcher.writeException(SynchronousDispatcher.java:167)
    at org.jboss.resteasy.core.SynchronousDispatcher.writeResponse(SynchronousDispatcher.java:471)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:415)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:202)
    at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:221)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
    at org.jboss.resteasy.plugins.server.tjws.TJWSServletDispatcher.service(TJWSServletDispatcher.java:40)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at Acme.Serve.Serve$ServeConnection.runServlet(Serve.java:2328)
    at Acme.Serve.Serve$ServeConnection.parseRequest(Serve.java:2282)
    at Acme.Serve.Serve$ServeConnection.run(Serve.java:2054)
    at Acme.Utils$ThreadPool$PooledThread.run(Utils.java:1402)
    at java.lang.Thread.run(Thread.java:748)
Caused by: java.net.SocketException: Broken pipe (Write failed)
    at java.net.SocketOutputStream.socketWrite0(Native Method)
    at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)
    at java.net.SocketOutputStream.write(SocketOutputStream.java:155)
    at sun.security.ssl.OutputRecord.writeBuffer(OutputRecord.java:431)
    at sun.security.ssl.OutputRecord.write(OutputRecord.java:417)
    at sun.security.ssl.SSLSocketImpl.writeRecordInternal(SSLSocketImpl.java:886)
    at sun.security.ssl.SSLSocketImpl.writeRecord(SSLSocketImpl.java:857)
    at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:123)
    at java.io.OutputStream.write(OutputStream.java:75)
    at Acme.Serve.Serve$ServeOutputStream.close(Serve.java:4928)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletResponseWrapper$DeferredOutputStream.close(HttpServletResponseWrapper.java:58)
    at org.jboss.resteasy.util.CommitHeaderOutputStream.close(CommitHeaderOutputStream.java:87)
    at org.jboss.resteasy.util.DelegatingOutputStream.close(DelegatingOutputStream.java:60)
    at com.fasterxml.jackson.core.json.UTF8JsonGenerator.close(UTF8JsonGenerator.java:1060)
    at org.jboss.resteasy.plugins.providers.jackson.ResteasyJackson2Provider.writeTo(ResteasyJackson2Provider.java:209)
    at org.mycontroller.standalone.api.jaxrs.mixins.McJacksonJson2Provider.writeTo(McJacksonJson2Provider.java:120)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.writeTo(AbstractWriterInterceptorContext.java:131)
    at org.jboss.resteasy.core.interception.ServerWriterInterceptorContext.writeTo(ServerWriterInterceptorContext.java:60)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.proceed(AbstractWriterInterceptorContext.java:120)
    at org.jboss.resteasy.plugins.interceptors.encoding.GZIPEncodingInterceptor.aroundWriteTo(GZIPEncodingInterceptor.java:100)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.proceed(AbstractWriterInterceptorContext.java:124)
    at org.jboss.resteasy.core.ServerResponseWriter.writeNomapResponse(ServerResponseWriter.java:98)
    at org.jboss.resteasy.core.SynchronousDispatcher.writeResponse(SynchronousDispatcher.java:466)
    ... 12 more

[Wed Nov 28 13:27:37 SAST 2018] Unexpected problem running servlet: org.jboss.resteasy.spi.UnhandledException: RESTEASY003770: Response is committed, can't handle exception
[Wed Nov 28 13:27:37 SAST 2018] IO error: javax.net.ssl.SSLException: Connection has been shutdown: javax.net.ssl.SSLException: java.net.SocketException: Broken pipe (Write failed) in processing a request from /192.168.1.20:8443 / sun.security.ssl.SSLSocketImpl
[Wed Nov 28 13:27:37 SAST 2018] Unexpected problem running servlet
org.jboss.resteasy.spi.UnhandledException: RESTEASY003770: Response is committed, can't handle exception
    at org.jboss.resteasy.core.SynchronousDispatcher.writeException(SynchronousDispatcher.java:167)
    at org.jboss.resteasy.core.SynchronousDispatcher.writeResponse(SynchronousDispatcher.java:471)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:415)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:202)
    at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:221)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
    at org.jboss.resteasy.plugins.server.tjws.TJWSServletDispatcher.service(TJWSServletDispatcher.java:40)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at Acme.Serve.Serve$ServeConnection.runServlet(Serve.java:2328)
    at Acme.Serve.Serve$ServeConnection.parseRequest(Serve.java:2282)
    at Acme.Serve.Serve$ServeConnection.run(Serve.java:2054)
    at Acme.Utils$ThreadPool$PooledThread.run(Utils.java:1402)
    at java.lang.Thread.run(Thread.java:748)
Caused by: java.net.SocketException: Broken pipe (Write failed)
    at java.net.SocketOutputStream.socketWrite0(Native Method)
    at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)
    at java.net.SocketOutputStream.write(SocketOutputStream.java:155)
    at sun.security.ssl.OutputRecord.writeBuffer(OutputRecord.java:431)
    at sun.security.ssl.OutputRecord.write(OutputRecord.java:417)
    at sun.security.ssl.SSLSocketImpl.writeRecordInternal(SSLSocketImpl.java:886)
    at sun.security.ssl.SSLSocketImpl.writeRecord(SSLSocketImpl.java:857)
    at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:123)
    at java.io.OutputStream.write(OutputStream.java:75)
    at Acme.Serve.Serve$ServeOutputStream.close(Serve.java:4928)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletResponseWrapper$DeferredOutputStream.close(HttpServletResponseWrapper.java:58)
    at org.jboss.resteasy.util.CommitHeaderOutputStream.close(CommitHeaderOutputStream.java:87)
    at org.jboss.resteasy.util.DelegatingOutputStream.close(DelegatingOutputStream.java:60)
    at com.fasterxml.jackson.core.json.UTF8JsonGenerator.close(UTF8JsonGenerator.java:1060)
    at org.jboss.resteasy.plugins.providers.jackson.ResteasyJackson2Provider.writeTo(ResteasyJackson2Provider.java:209)
    at org.mycontroller.standalone.api.jaxrs.mixins.McJacksonJson2Provider.writeTo(McJacksonJson2Provider.java:120)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.writeTo(AbstractWriterInterceptorContext.java:131)
    at org.jboss.resteasy.core.interception.ServerWriterInterceptorContext.writeTo(ServerWriterInterceptorContext.java:60)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.proceed(AbstractWriterInterceptorContext.java:120)
    at org.jboss.resteasy.plugins.interceptors.encoding.GZIPEncodingInterceptor.aroundWriteTo(GZIPEncodingInterceptor.java:100)
    at org.jboss.resteasy.core.interception.AbstractWriterInterceptorContext.proceed(AbstractWriterInterceptorContext.java:124)
    at org.jboss.resteasy.core.ServerResponseWriter.writeNomapResponse(ServerResponseWriter.java:98)
    at org.jboss.resteasy.core.SynchronousDispatcher.writeResponse(SynchronousDispatcher.java:466)
    ... 12 more

[Wed Nov 28 13:27:37 SAST 2018] Unexpected problem running servlet: org.jboss.resteasy.spi.UnhandledException: RESTEASY003770: Response is committed, can't handle exception
[Wed Nov 28 13:27:37 SAST 2018] IO error: javax.net.ssl.SSLException: Connection has been shutdown: javax.net.ssl.SSLException: java.net.SocketException: Broken pipe (Write failed) in processing a request from /192.168.1.20:8443 / sun.security.ssl.SSLSocketImpl
2018-11-28 13:29:04,204 WARN [mc-th-pool-7] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:29:09,208 WARN [mc-th-pool-8] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:29:09,474 WARN [mc-th-pool-5] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:29:09,474 WARN [mc-th-pool-6] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:29:35,728 ERROR [mc-th-pool-0] [org.mycontroller.standalone.db.dao.NodeDaoImpl:68] unable to get Node. gatewayId:1, nodeEui:6
org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-194]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    at org.h2.message.DbException.get(DbException.java:168)
    at org.h2.message.DbException.convert(DbException.java:295)
    at org.h2.message.DbException.toSQLException(DbException.java:268)
    at org.h2.message.TraceObject.logAndConvert(TraceObject.java:352)
    at org.h2.jdbc.JdbcResultSet.findColumn(JdbcResultSet.java:188)
    at com.j256.ormlite.jdbc.JdbcDatabaseResults.findColumn(JdbcDatabaseResults.java:103)
    at com.j256.ormlite.field.FieldType.resultToJava(FieldType.java:826)
    at com.j256.ormlite.stmt.mapped.BaseMappedQuery.mapRow(BaseMappedQuery.java:61)
    at com.j256.ormlite.stmt.StatementExecutor.queryForFirst(StatementExecutor.java:109)
    at com.j256.ormlite.dao.BaseDaoImpl.queryForFirst(BaseDaoImpl.java:239)
    at com.j256.ormlite.stmt.QueryBuilder.queryForFirst(QueryBuilder.java:380)
    at org.mycontroller.standalone.db.dao.NodeDaoImpl.get(NodeDaoImpl.java:66)
    at org.mycontroller.standalone.provider.ExecuterAbstract.getNode(ExecuterAbstract.java:480)
    at org.mycontroller.standalone.provider.ExecuterAbstract.execute(ExecuterAbstract.java:121)
    at org.mycontroller.standalone.provider.EngineAbstract.auditQueue(EngineAbstract.java:274)
    at org.mycontroller.standalone.provider.EngineAbstract.run(EngineAbstract.java:133)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.NullPointerException: null
    at org.h2.util.StringUtils.toUpperEnglish(StringUtils.java:106)
    at org.h2.jdbc.JdbcResultSet.getColumnIndex(JdbcResultSet.java:3129)
    at org.h2.jdbc.JdbcResultSet.findColumn(JdbcResultSet.java:186)
    ... 14 common frames omitted
2018-11-28 13:29:35,730 ERROR [mc-th-pool-0] [org.mycontroller.standalone.db.dao.NodeDaoImpl:70] PrepareStatement:[SELECT * FROM `node` WHERE (`gatewayId` = 1 AND `eui` = '6' ) ]
2018-11-28 13:29:35,731 ERROR [mc-th-pool-0] [org.mycontroller.standalone.provider.EngineAbstract:279] Throws exception while processing!, [MessageImpl(gatewayId=1, nodeEui=6, sensorId=2, type=Set, subType=Temperature, ack=0, payload=24.19, isTxMessage=false, timestamp=1543404486646, properties=null)]
org.mycontroller.standalone.exceptions.McDatabaseException: org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-194]
    at org.mycontroller.standalone.db.dao.NodeDaoImpl.get(NodeDaoImpl.java:74)
    at org.mycontroller.standalone.provider.ExecuterAbstract.getNode(ExecuterAbstract.java:480)
    at org.mycontroller.standalone.provider.ExecuterAbstract.execute(ExecuterAbstract.java:121)
    at org.mycontroller.standalone.provider.EngineAbstract.auditQueue(EngineAbstract.java:274)
    at org.mycontroller.standalone.provider.EngineAbstract.run(EngineAbstract.java:133)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-194]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    at org.h2.message.DbException.get(DbException.java:168)
    at org.h2.message.DbException.convert(DbException.java:295)
    at org.h2.message.DbException.toSQLException(DbException.java:268)
    at org.h2.message.TraceObject.logAndConvert(TraceObject.java:352)
    at org.h2.jdbc.JdbcResultSet.findColumn(JdbcResultSet.java:188)
    at com.j256.ormlite.jdbc.JdbcDatabaseResults.findColumn(JdbcDatabaseResults.java:103)
    at com.j256.ormlite.field.FieldType.resultToJava(FieldType.java:826)
    at com.j256.ormlite.stmt.mapped.BaseMappedQuery.mapRow(BaseMappedQuery.java:61)
    at com.j256.ormlite.stmt.StatementExecutor.queryForFirst(StatementExecutor.java:109)
    at com.j256.ormlite.dao.BaseDaoImpl.queryForFirst(BaseDaoImpl.java:239)
    at com.j256.ormlite.stmt.QueryBuilder.queryForFirst(QueryBuilder.java:380)
    at org.mycontroller.standalone.db.dao.NodeDaoImpl.get(NodeDaoImpl.java:66)
    ... 7 common frames omitted
Caused by: java.lang.NullPointerException: null
    at org.h2.util.StringUtils.toUpperEnglish(StringUtils.java:106)
    at org.h2.jdbc.JdbcResultSet.getColumnIndex(JdbcResultSet.java:3129)
    at org.h2.jdbc.JdbcResultSet.findColumn(JdbcResultSet.java:186)
    ... 14 common frames omitted
2018-11-28 13:30:00,201 INFO [Quartz_Scheduler_Worker-2] [org.mycontroller.standalone.scripts.api.LoggerApi:42] Borehole pump on control script started ...
2018-11-28 13:30:00,374 INFO [Quartz_Scheduler_Worker-2] [org.mycontroller.standalone.scripts.api.LoggerApi:42] pumpState = 0
2018-11-28 13:30:00,379 INFO [Quartz_Scheduler_Worker-2] [org.mycontroller.standalone.scripts.api.LoggerApi:42] tankLevel = 95.14
2018-11-28 13:30:00,383 INFO [Quartz_Scheduler_Worker-2] [org.mycontroller.standalone.scripts.api.LoggerApi:42] Battery voltage = 24.77
2018-11-28 13:30:00,388 INFO [Quartz_Scheduler_Worker-2] [org.mycontroller.standalone.scripts.api.LoggerApi:42] Battery Current In = 12.58
2018-11-28 13:30:00,392 INFO [Quartz_Scheduler_Worker-2] [org.mycontroller.standalone.scripts.api.LoggerApi:42] Battery Current Out = 32.56
2018-11-28 13:30:00,397 INFO [Quartz_Scheduler_Worker-2] [org.mycontroller.standalone.scripts.api.LoggerApi:42] Battery Current In - Out = -19.980000000000004
2018-11-28 13:30:00,433 INFO [Quartz_Scheduler_Worker-2] [org.mycontroller.standalone.scripts.api.LoggerApi:42] Battery voltage low. No pumping now
2018-11-28 13:30:00,441 INFO [Quartz_Scheduler_Worker-2] [org.mycontroller.standalone.scripts.api.LoggerApi:42] Borehole pump on control script ended ...
2018-11-28 13:33:39,320 WARN [mc-th-pool-8] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 13:33:39,321 WARN [mc-th-pool-5] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
jkandasa commented 5 years ago

@seant100 Thanks for the log file, I see two errors related to this change.

Seems you have some issue with one of your MQTT gateway,

2018-11-28 13:09:41,457 ERROR [mc-th-pool-1] [org.mycontroller.standalone.McUncaughtException:73] Exception,
java.lang.NullPointerException: null
    at org.mycontroller.standalone.gateway.mqtt.MQTTDriver.connect(MQTTDriver.java:102)
    at org.mycontroller.standalone.gateway.mqtt.GatewayMQTT.connect(GatewayMQTT.java:50)
    at org.mycontroller.standalone.provider.EngineAbstract.run(EngineAbstract.java:127)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)

Other errors related to UI. I hope these errors will go off, when you reload your page on the browser.

seant100 commented 5 years ago

@jkandasa What sort of issue could I have with MQTT gateway? I have 2 gateways setup. Both seem to be working fine.

It seems to me the key here is "null pointer exception". As this appears on all of those issues. This to me indicates some object is not being instantiated properly.

seant100 commented 5 years ago

@jkandasa Here is a snippet of the logs some more errors.

2018-11-28 15:12:50,033 ERROR [Quartz_Scheduler_Worker-1] [org.mycontroller.standalone.db.dao.BaseAbstractDaoImpl:431] unable to get all items key:resourceType, value:GATEWAY
org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-194]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    at org.h2.message.DbException.get(DbException.java:168)
    at org.h2.message.DbException.convert(DbException.java:295)
    at org.h2.message.DbException.toSQLException(DbException.java:268)
    at org.h2.message.TraceObject.logAndConvert(TraceObject.java:352)
    at org.h2.jdbc.JdbcResultSet.findColumn(JdbcResultSet.java:188)
    at com.j256.ormlite.jdbc.JdbcDatabaseResults.findColumn(JdbcDatabaseResults.java:103)
    at com.j256.ormlite.field.FieldType.resultToJava(FieldType.java:826)
    at com.j256.ormlite.stmt.mapped.BaseMappedQuery.mapRow(BaseMappedQuery.java:61)
    at com.j256.ormlite.stmt.SelectIterator.getCurrent(SelectIterator.java:284)
    at com.j256.ormlite.stmt.SelectIterator.nextThrow(SelectIterator.java:168)
    at com.j256.ormlite.stmt.StatementExecutor.query(StatementExecutor.java:202)
    at com.j256.ormlite.dao.BaseDaoImpl.query(BaseDaoImpl.java:277)
    at com.j256.ormlite.stmt.QueryBuilder.query(QueryBuilder.java:366)
    at com.j256.ormlite.stmt.Where.query(Where.java:480)
    at org.mycontroller.standalone.db.dao.BaseAbstractDaoImpl.getAll(BaseAbstractDaoImpl.java:429)
    at org.mycontroller.standalone.rule.McRuleEngine.doRun(McRuleEngine.java:133)
    at org.knowm.sundial.Job.execute(Job.java:56)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:178)
    at org.quartz.core.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:515)
Caused by: java.lang.NullPointerException: null
    at org.h2.util.StringUtils.toUpperEnglish(StringUtils.java:106)
    at org.h2.jdbc.JdbcResultSet.getColumnIndex(JdbcResultSet.java:3129)
    at org.h2.jdbc.JdbcResultSet.findColumn(JdbcResultSet.java:186)
    ... 14 common frames omitted
2018-11-28 15:12:50,037 ERROR [Quartz_Scheduler_Worker-1] [org.mycontroller.standalone.rule.McRuleEngine:163] Exception on scheduled job, 
org.mycontroller.standalone.exceptions.McDatabaseException: org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-194]
    at org.mycontroller.standalone.db.dao.BaseAbstractDaoImpl.getAll(BaseAbstractDaoImpl.java:432)
    at org.mycontroller.standalone.rule.McRuleEngine.doRun(McRuleEngine.java:133)
    at org.knowm.sundial.Job.execute(Job.java:56)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:178)
    at org.quartz.core.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:515)
Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-194]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    at org.h2.message.DbException.get(DbException.java:168)
    at org.h2.message.DbException.convert(DbException.java:295)
    at org.h2.message.DbException.toSQLException(DbException.java:268)
    at org.h2.message.TraceObject.logAndConvert(TraceObject.java:352)
    at org.h2.jdbc.JdbcResultSet.findColumn(JdbcResultSet.java:188)
    at com.j256.ormlite.jdbc.JdbcDatabaseResults.findColumn(JdbcDatabaseResults.java:103)
    at com.j256.ormlite.field.FieldType.resultToJava(FieldType.java:826)
    at com.j256.ormlite.stmt.mapped.BaseMappedQuery.mapRow(BaseMappedQuery.java:61)
    at com.j256.ormlite.stmt.SelectIterator.getCurrent(SelectIterator.java:284)
    at com.j256.ormlite.stmt.SelectIterator.nextThrow(SelectIterator.java:168)
    at com.j256.ormlite.stmt.StatementExecutor.query(StatementExecutor.java:202)
    at com.j256.ormlite.dao.BaseDaoImpl.query(BaseDaoImpl.java:277)
    at com.j256.ormlite.stmt.QueryBuilder.query(QueryBuilder.java:366)
    at com.j256.ormlite.stmt.Where.query(Where.java:480)
    at org.mycontroller.standalone.db.dao.BaseAbstractDaoImpl.getAll(BaseAbstractDaoImpl.java:429)
    ... 4 common frames omitted
Caused by: java.lang.NullPointerException: null
    at org.h2.util.StringUtils.toUpperEnglish(StringUtils.java:106)
    at org.h2.jdbc.JdbcResultSet.getColumnIndex(JdbcResultSet.java:3129)
    at org.h2.jdbc.JdbcResultSet.findColumn(JdbcResultSet.java:186)
    ... 14 common frames omitted
2018-11-28 15:13:36,230 WARN [mc-th-pool-6] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 15:13:36,260 WARN [mc-th-pool-9] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 15:13:39,144 WARN [mc-th-pool-8] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 15:18:35,853 WARN [mc-th-pool-8] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 15:19:08,526 WARN [mc-th-pool-2] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 15:19:08,898 WARN [mc-th-pool-4] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 15:21:09,013 WARN [Quartz_Scheduler_Worker-7] [org.mycontroller.standalone.rule.McRuleEngine:120] Scheduled Rule execution skipped. Engine not available for more than 4000 ms
2018-11-28 15:21:14,006 WARN [Quartz_Scheduler_Worker-3] [org.mycontroller.standalone.rule.McRuleEngine:120] Scheduled Rule execution skipped. Engine not available for more than 4000 ms
2018-11-28 15:21:19,004 WARN [Quartz_Scheduler_Worker-6] [org.mycontroller.standalone.rule.McRuleEngine:120] Scheduled Rule execution skipped. Engine not available for more than 4000 ms
2018-11-28 15:21:24,089 WARN [Quartz_Scheduler_Worker-5] [org.mycontroller.standalone.rule.McRuleEngine:120] Scheduled Rule execution skipped. Engine not available for more than 4000 ms
2018-11-28 15:21:29,005 WARN [Quartz_Scheduler_Worker-4] [org.mycontroller.standalone.rule.McRuleEngine:120] Scheduled Rule execution skipped. Engine not available for more than 4000 ms
2018-11-28 15:23:36,578 WARN [mc-th-pool-8] [org.mycontroller.standalone.rule.McRuleEngine:184] Scheduled Rule exuection skipped. Engine not available for more than 4000 ms
2018-11-28 15:26:53,167 ERROR [mc-th-pool-5] [org.mycontroller.standalone.db.dao.RuleDefinitionDaoImpl:109] unable to get rule definitions for ResourceTye:SENSOR_VARIABLE, ResourceId:526
org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-194]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    at org.h2.message.DbException.get(DbException.java:168)
    at org.h2.message.DbException.convert(DbException.java:295)
    at org.h2.message.DbException.toSQLException(DbException.java:268)
    at org.h2.message.TraceObject.logAndConvert(TraceObject.java:352)
    at org.h2.jdbc.JdbcResultSet.findColumn(JdbcResultSet.java:188)
    at com.j256.ormlite.jdbc.JdbcDatabaseResults.findColumn(JdbcDatabaseResults.java:103)
    at com.j256.ormlite.field.FieldType.resultToJava(FieldType.java:826)
    at com.j256.ormlite.stmt.mapped.BaseMappedQuery.mapRow(BaseMappedQuery.java:61)
    at com.j256.ormlite.stmt.SelectIterator.getCurrent(SelectIterator.java:284)
    at com.j256.ormlite.stmt.SelectIterator.nextThrow(SelectIterator.java:168)
    at com.j256.ormlite.stmt.StatementExecutor.query(StatementExecutor.java:202)
    at com.j256.ormlite.dao.BaseDaoImpl.query(BaseDaoImpl.java:277)
    at com.j256.ormlite.stmt.QueryBuilder.query(QueryBuilder.java:366)
    at com.j256.ormlite.stmt.Where.query(Where.java:480)
    at org.mycontroller.standalone.db.dao.RuleDefinitionDaoImpl.getAll(RuleDefinitionDaoImpl.java:107)
    at org.mycontroller.standalone.rule.McRuleEngine.run(McRuleEngine.java:194)
    at org.mycontroller.standalone.provider.ExecuteMessageDependentTask.executeDependentTask(ExecuteMessageDependentTask.java:74)
    at org.mycontroller.standalone.provider.ExecuteMessageDependentTask.run(ExecuteMessageDependentTask.java:84)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.NullPointerException: null
    at org.h2.util.StringUtils.toUpperEnglish(StringUtils.java:106)
    at org.h2.jdbc.JdbcResultSet.getColumnIndex(JdbcResultSet.java:3144)
    at org.h2.jdbc.JdbcResultSet.findColumn(JdbcResultSet.java:186)
    ... 16 common frames omitted
2018-11-28 15:26:53,169 ERROR [mc-th-pool-5] [org.mycontroller.standalone.rule.McRuleEngine:228] Exception on ondemand thread job, 
org.mycontroller.standalone.exceptions.McDatabaseException: org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-194]
    at org.mycontroller.standalone.db.dao.RuleDefinitionDaoImpl.getAll(RuleDefinitionDaoImpl.java:111)
    at org.mycontroller.standalone.rule.McRuleEngine.run(McRuleEngine.java:194)
    at org.mycontroller.standalone.provider.ExecuteMessageDependentTask.executeDependentTask(ExecuteMessageDependentTask.java:74)
    at org.mycontroller.standalone.provider.ExecuteMessageDependentTask.run(ExecuteMessageDependentTask.java:84)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-194]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    at org.h2.message.DbException.get(DbException.java:168)
    at org.h2.message.DbException.convert(DbException.java:295)
    at org.h2.message.DbException.toSQLException(DbException.java:268)
    at org.h2.message.TraceObject.logAndConvert(TraceObject.java:352)
    at org.h2.jdbc.JdbcResultSet.findColumn(JdbcResultSet.java:188)
    at com.j256.ormlite.jdbc.JdbcDatabaseResults.findColumn(JdbcDatabaseResults.java:103)
    at com.j256.ormlite.field.FieldType.resultToJava(FieldType.java:826)
    at com.j256.ormlite.stmt.mapped.BaseMappedQuery.mapRow(BaseMappedQuery.java:61)
    at com.j256.ormlite.stmt.SelectIterator.getCurrent(SelectIterator.java:284)
    at com.j256.ormlite.stmt.SelectIterator.nextThrow(SelectIterator.java:168)
    at com.j256.ormlite.stmt.StatementExecutor.query(StatementExecutor.java:202)
    at com.j256.ormlite.dao.BaseDaoImpl.query(BaseDaoImpl.java:277)
    at com.j256.ormlite.stmt.QueryBuilder.query(QueryBuilder.java:366)
    at com.j256.ormlite.stmt.Where.query(Where.java:480)
    at org.mycontroller.standalone.db.dao.RuleDefinitionDaoImpl.getAll(RuleDefinitionDaoImpl.java:107)
    ... 6 common frames omitted
Caused by: java.lang.NullPointerException: null
    at org.h2.util.StringUtils.toUpperEnglish(StringUtils.java:106)
    at org.h2.jdbc.JdbcResultSet.getColumnIndex(JdbcResultSet.java:3144)
    at org.h2.jdbc.JdbcResultSet.findColumn(JdbcResultSet.java:186)
    ... 16 common frames omitted
jkandasa commented 5 years ago

@seant100 seems like your RPI works under heavy load? more frequently database throws the exception.

seant100 commented 5 years ago

@jkandasa I only have 7 nodes. One node is setup as a 2nd gateway so as to use an ESP8266 without radio. If I disable this gateway it still logs errors and CPU is sometimes still stuck on 100%.

On the Raspberry Pi I am only running Mycontroller and its dependencies. Plus node-red for sending data to weather underground.

Is MyController limited to less than 7 nodes ?

image

jkandasa commented 5 years ago

@seant100 No, MyController is not limited to 7 nodes.

seant100 commented 5 years ago

@jkandasa

  1. I am running headless - no desktop
  2. not much CPU / resources is used by node-red. All is taken by Java / MyController. See screenshot below. WeatherUnderground is not properly supported ... see issue i logged here : https://github.com/mycontroller-org/mycontroller/issues/381
  3. Yes
  4. Screenshot attached

image

image

jkandasa commented 5 years ago

@seant100

seant100 commented 5 years ago

@jkandasa

image

seant100 commented 5 years ago

@jkandasa Perhaps also there is something wrong with my database. Here is says "Column "registrationState" not found"

2018-11-28 16:08:31,931 ERROR [mc-th-pool-2] [org.mycontroller.standalone.provider.ResourcesLogger:209] Error on MessageImpl(gatewayId=66, nodeEui=0, sensorId=1, type=Set, subType=Voltage, ack=0, payload=26.15, isTxMessage=false, timestamp=1543414085680, properties=null),
org.mycontroller.standalone.exceptions.McDatabaseException: org.h2.jdbc.JdbcSQLException: Column "registrationState" not found [42122-194]
    at org.mycontroller.standalone.db.dao.NodeDaoImpl.get(NodeDaoImpl.java:74)
    at org.mycontroller.standalone.provider.ResourcesLogger.getResourceId(ResourcesLogger.java:72)
jkandasa commented 5 years ago

@seant100 Thank you for your patience and quick response, Binary data: Yes, ON/OFF data Looks like all ok, other than the binary data, Seems like you are receiving very often and keeping it for a year may lead slow database.

Can you send your database backup to my email address? (remove sensitive information) jkandasa at gmail dot com

can you increase java heap to 512MB(-Xmx512m) and try?

seant100 commented 5 years ago

@jkandasa Where do i put the "-Xmx512m" ? is that in the start.sh script?

jkandasa commented 5 years ago

@seant100 Yes, in the start.sh

seant100 commented 5 years ago

@jkandasa I've emailed database backup to you and increased the heap MAX setting in start.sh

seant100 commented 5 years ago

@jkandasa With the new snapshot it is still creating random nodes, sensors and sensor variables

jkandasa commented 5 years ago

@seant100 MyController might receive random node from MySensors gateway. Can you delete a random node and enable DEBUG raw log from gateway?, we can confirm where the issue is.

DEBUG raw log: https://github.com/mycontroller-org/mycontroller/issues/473

seant100 commented 5 years ago

@jkandasa It is not only new nodes - see screenshot. MyController is creating invalid sensors and invalid sensor variables. The "200" and "201" sensors at the top that are invalid are not sent from a gateway and "SENSOR_BC" I have no idea what that means. image

jkandasa commented 5 years ago

@seant100 ah, looks like we have an issue with MyController. Can you send mycontroller.log to my email address?

seant100 commented 5 years ago

@jkandasa I've sent the log file via email.

Jordan-Szwejda commented 4 years ago

I also experienced such problems on my RPI. At certain point of time mycontroller started eating all CPU time. Mycontroller's web server became unresponsive because of that. It looked like problem with corrupted database. I transferred this database into my laptop and there also observed significantly high CPU consumption on a temporarily configured mycontroller. I did not succeed in recovering this database and had to create a new one from scratch. After that everything started working properly again. I also observe the problem with 'ghost' nodes and sensors but I am not sure if it is a mycontroller issue or just kind of failure in nrf24l01 transmission.