This has definitely been an interesting read and fortunately something I have not experienced. I thought I would provide some data points about my setup in case it helps anyone or the HE staff in troubleshooting. I wouldn't say I have an overly complex/automated setup and most things happen with button presses or physical switches, doors opening/closing, etc. All of the following runs on a single hub.
235 Total Devices:
90 Zwave (55 Plus, 35 non-plus)
51 Zigbee
24 Lutron
70 Virtual and Other Devices
Since LAN/Web Services integrations were identified as possible culprits, here are mine:
Lutron Telnet
Denon AVR
Onkyo AVR
Network UPS - telnet to my NAS for UPS status every 10 seconds
Ecobee Integration - 2 thermostats
Lennox iComfort - 1 thermostat
Alexa TTS
MyQ Garage Door
Twilio SMS - only a few a day
NodeRed via web socket for Grafana logging and calendar integration
HubConnect with SmartThings for 2 locks - I could never get my Schlage locks to pair with HE so left them on ST and use HubConnect to integrate.
Last event I had was 630am - left the house at 8am and typically would of got a push that I left the geo-fence. Any way to stop these hub lockups ?
[app:322](http://192.168.1.140/logs/past#app322)2019-08-03 12:19:22.533 pm [error](http://192.168.1.140/installedapp/configure/322)java.sql.SQLException: Connections could not be acquired from the underlying database! (updateMembers)
[dev:262](http://192.168.1.140/logs/past#dev262)2019-08-03 12:19:22.495 pm [error](http://192.168.1.140/device/edit/262)java.sql.SQLException: Connections could not be acquired from the underlying database! on line 333 (generatePresenceEvent)
[dev:262](http://192.168.1.140/logs/past#dev262)2019-08-03 12:19:22.470 pm [error](http://192.168.1.140/device/edit/262)java.sql.SQLException: An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool cannot acquire a new resource -- the factory or source appears to be down. on line 110 (extraInfo)
[dev:261](http://192.168.1.140/logs/past#dev261)2019-08-03 12:19:22.346 pm [error](http://192.168.1.140/device/edit/261)java.sql.SQLException: An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool cannot acquire a new resource -- the factory or source appears to be down. on line 370 (generatePresenceEvent)