pimatic 0.9.37 stopped working and doesn' start again

---

Hey,

i got a problem. My pimatic stopped working and i don’t get it back running

sudo /home/pi/pimatic-app/node_modules/pimatic/pimatic.js
19:16:16.985 2016-11-23 Wednesday
19:16:28.961 [pimatic] Starting pimatic version 0.9.37
19:16:34.815 [pimatic] settings.debug is true, showing debug output for pimatic core.
19:17:36.431 [pimatic] Startup error: TimeoutError: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?
19:17:36.431 [pimatic]>    at null._onTimeout (/home/pi/pimatic-app/node_modules/pimatic/node_modules/knex/lib/client.js:279:18)
19:17:36.431 [pimatic]>    at Timer.listOnTimeout (timers.js:92:15)
19:17:36.452 [pimatic] exiting...

Any idea what the problem is?

daice

This has to do with the database using pooled connections (for parallel transactions).
I’m indeed afrais it has to do with the 0.9.37 update in this part.

OK, i have deleted my database and it seems to come up again. Lets see how long it runs…

Sorry, guys. I had tested this on three different platforms and the update succeeded without flaws.

It doesn’t have to be an issue with that update but it is a strange coincidence.

daice could have tried to see if the database could be recovered.
sqlite3 dbpimatic-database.sqlite ".dump" | sqlite3 new-dbpimatic-database.sqlite
and then rename it to the old name.