Pimatic crashes at different times

---

Hello,

my pimatic crash at diffrent times. It runs allways 2 or 3 days then crash it.

I have run pimatic in a terminal and log the outputt,

07:00:00.441 [pimatic] rule handyautoladung-aus: press button funk1-aus of devic e Funk1
10:32:49.781 [pimatic] rule multimediageratesteuerung-fernsehgerate-aus: press b utton funk2-aus of device Funk2
10:32:52.879 [pimatic] rule multimediageratesteuerung-fernsehgerate-aus: press b utton funk3-aus of device Funk3
10:32:55.805 [pimatic] rule multimediageratesteuerung-fernsehgerate-aus: press b utton funk4-aus of device Funk4
Fatal TimeoutError: Knex: Timeout acquiring a connection. The pool is probably f ull. Are you missing a .transacting(trx) call?
at null._onTimeout (/home/pimatic-app/node_modules/pimatic/node_modules/knex /lib/client.js:279:18)
at Timer.listOnTimeout (timers.js:92:15)

I have deleted the last rule but the error persists.
Pimatic is up to date.

What can i do ?

Could be a problem with the connection handling of the knex library.

Do you use a dedicated database?

If not, maybe the db file is still locked.

There is already an issue open for that: https://github.com/pimatic/pimatic/issues/876

@SaxnPaule said in Pimatic crash at diffrent times:

Could be a problem with the connection handling of the knex library.

Do you use a dedicated database?

If not, maybe the db file is still locked.

There is already an issue open for that: https://github.com/pimatic/pimatic/issues/876

I dont use a dedecaded database. Its all standard.

I dont use the pimatic-max plugin. Use a another plugin the knex library?

Is this a bug in pimatic? Do i have to wait for a update now?

As far as I understand, pimatic itself uses the knex library to handle the persistence in the database.

@SaxnPaule said in Pimatic crash at diffrent times:

As far as I understand, pimatic itself uses the knex library to handle the persistence in the database.

Okay, then i wait and hope for a bug fix.

Thanks for your reply !

Now i have update Pimatic to 9.39 but i have the same problem with the database.

Fatal TimeoutError: Knex: Timeout acquiring a connection. The pool is probably f ull. Are you missing a .transacting(trx) call?
at null.<anonymous> (/home/pimatic-app/node_modules/pimatic/node_modules/kne x/lib/client.js:287:18)
at Timer.listOnTimeout (timers.js:92:15)

How can i fix it ? Thanks for help

@Arlive which plugins do you use?

@mwittig
today i get this error too. twice. one at running after 3 hour, and one at restart.
my plugins:

“plugins”: [
{
“plugin”: “cron”
},
{
“plugin”: “mobile-frontend”
},
{
“plugin”: “homeduino”,
“driver”: “serialport”,
“driverOptions”: {
“serialDevice”: “/dev/ttyACM0”,
“baudrate”: 115200
},
“receiverPin”: 0,
“transmitterPin”: 4
},
{
“plugin”: “sysinfo”
},
{
“plugin”: “ds18b20”
},
{
“plugin”: “chronotherm”
},
{
“plugin”: “metar-weather”,
“active”: true
}

the error log:

.
.
.
20:56:06.831 [pimatic] info: rule ct-dummy-off: set presence Kazán - fűtés to absent
20:56:07.797 [pimatic] info: rule ct-off-secure: turned Kazán - Manuális off
Fatal TimeoutError: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?
22:17:19.355 2018-10-03 Wednesday
22:17:27.789 [pimatic] info: Starting pimatic version 0.9.42
22:17:28.743 [pimatic] warn: Could not find a device with the ID “l110” from page “lights_2” in devices config section.
22:17:28.747 [pimatic] warn: Could not find a device with the ID “uelck1” from page “security” in devices config section.
22:27:55.622 [pimatic] error: Startup error: TimeoutError: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?
22:27:55.622 [pimatic] error:> at null._onTimeout (/home/pi/pimatic-app/node_modules/pimatic/node_modules/knex/lib/client.js:287:18)
22:27:55.622 [pimatic] error:> at Timer.listOnTimeout (timers.js:92:15)
22:27:55.636 [pimatic] info: exiting…
22:29:06.027 2018-10-03 Wednesday
22:29:14.395 [pimatic] info: Starting pimatic version 0.9.42
.
.
.

@zoltán said in Pimatic crashes at different times:

Are you missing a .transacting(trx) call?

Looks like the database is corrupt. You should also check the integrity of the file system.

https://forum.pimatic.org/topic/2068/solved-knex-warning
https://forum.pimatic.org/topic/3855/pimatic-stürzt-ab-knex-timeout (German)

See here on how to repair a broken DB
https://forum.pimatic.org/topic/2253/repair-broken-db
https://forum.pimatic.org/topic/14/database-tips