2.0 DB Connection Errors

🛎️ Get Help
1

As soon as I upgraded to 2.0 I saw very slow performance with lots of DB Connection errors in the logs:

app:4272018-11-15 06:36:31.973 am errorUnhandled exception 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. in ecobee polling pollAttempt:1, isThermostatPolled:true, isSwitchesPolled:true
dev:7212018-11-15 06:36:31.962 am errorjava.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. (generateEvent)
dev:7202018-11-15 06:36:31.819 am errorjava.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. (generateEvent)
app:5592018-11-15 06:36:31.701 am errorjava.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 542 (softPoll)
app:7482018-11-15 06:36:31.705 am errorjava.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 971 (initialize)

I have a ticket into support, but was wondering if I'm alone.

2

My hub has been acting up lately as well. I have 2 cases into support (haven't heard anything back).
It messed up again tonight and was almost not navigable. It kept throwing 500 errors.
I was able to get logging pulled up and then saw several of the errors that you mentioned:

app:10432019-01-20 08:04:32.091 pm errorjava.sql.SQLException: Connections could not be acquired from the underlying database! on line 909 (refreshDeviceStateCache)
dev:3822019-01-20 08:03:37.021 pm errorjava.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. (parse)
3

I haven't figured it out quite yet. After a db restore my hub can work great for weeks. But i've never figured out the root cause. I am running LOTS of custom code including Alexa TTS, WebCORE, InfluxDB, MQTTBridge, Konnected, IP2IR and SmartTiles. So I'm really running quite a bit of custom code on this little box successfully. By 2.0.4 I feel like the hub is actually running it pretty well.