Hi,
One of my users ran multiple route reports one after another which caused all my Teltonika devices to stop communicating with the server.
On my log file I can see messages from Teltonika and WLI devices up until the user ran the route report, after that I can only see messages from WLI devices. Maybe the server panicked but it is strange that only Teltonika devices stopped to communicate.
Rebooting the server sorted the issue but I was hoping someone can give me some advice on how to prevent this from happening in the future. Is there perhaps a setting I could change on the server or maybe on the Teltonika device itself? I did not get any warnings in my log files.
2021-12-20 15:32:38 INFO: user: 50, report: route, from: 2021-12-14 11:36, to: 2021-12-14 11:37, devices: [194], groups: []
2021-12-20 15:32:44 INFO: user: 50, report: route, from: 2021-12-14 11:37, to: 2021-12-14 11:38, devices: [194], groups: []
2021-12-20 15:32:53 INFO: user: 50, report: route, from: 2021-12-15 06:50, to: 2021-12-15 07:03, devices: [194], groups: []
2021-12-20 15:33:04 INFO: user: 50, report: route, from: 2021-12-15 10:29, to: 2021-12-15 10:53, devices: [194], groups: []
2021-12-20 15:33:22 INFO: user: 50, report: route, from: 2021-12-15 10:59, to: 2021-12-15 10:59, devices: [194], groups: []
2021-12-20 15:33:27 INFO: user: 50, report: route, from: 2021-12-15 11:07, to: 2021-12-15 11:16, devices: [194], groups: []
2021-12-20 15:33:33 INFO: user: 50, report: route, from: 2021-12-15 13:56, to: 2021-12-15 14:08, devices: [194], groups: []
You can try increasing connection pool size.
Thanks for the quick reply Anton, with connection pool size are you referring to the "Increasing connection limit on linux" as per the Optimization document or the "innodb_buffer_pool_size" as per MySQL Database Optimization document?
Thanks Anton,
So I'll include below in the traccar.xml. What would be a good value for me to try as a start? I've searched forum but did not find a answer.
<entry key='database.maxPoolSize'>value</entry>
I think the default value is 10.
Hi,
One of my users ran multiple route reports one after another which caused all my Teltonika devices to stop communicating with the server.
On my log file I can see messages from Teltonika and WLI devices up until the user ran the route report, after that I can only see messages from WLI devices. Maybe the server panicked but it is strange that only Teltonika devices stopped to communicate.
Rebooting the server sorted the issue but I was hoping someone can give me some advice on how to prevent this from happening in the future. Is there perhaps a setting I could change on the server or maybe on the Teltonika device itself? I did not get any warnings in my log files.