Hi everyone,
I'm having a problem specifically with the events report. If I run the report repeatedly in quick succession (e.g., if I change the date range from "today" → Generate, then "yesterday" → Generate, and so on) about 8 or 10 times, the server starts crashing with a timeout.
Error:
org.traccar.storage.StorageException: java.sql.SQLTransientConnectionException:
HikariPool-1 - Connection is not available, request timed out after 30000ms
(total=10, active=10, idle=0, waiting=0)
at org.traccar.storage.DatabaseStorage.getObjectsStream(DatabaseStorage.java:86)
at org.traccar.storage.Storage.getObject(Storage.java:52)
at org.traccar.api.resource.ServerResource.get(ServerResource.java:97)...
What’s interesting:
The issue is only reproducible (for me) with the Events report.
Running the Stops report in the same way (>30 runs back-to-back) does not exhaust the pool.
Environment
Traccar: 6.9.1
Not a bug, but you just used up all your database connection pool. Increase it if you need more.
Actually wait. You might be right.
Thank you very much Anton!
Hi everyone,
I'm having a problem specifically with the events report. If I run the report repeatedly in quick succession (e.g., if I change the date range from "today" → Generate, then "yesterday" → Generate, and so on) about 8 or 10 times, the server starts crashing with a timeout.
Error:
What’s interesting:
The issue is only reproducible (for me) with the Events report.
Running the Stops report in the same way (>30 runs back-to-back) does not exhaust the pool.
Environment
Traccar: 6.9.1