Service stopping tc_positions

Congratulations on the excellent Platform. I have the following problem, I have 15 devices connected to my server. When it reaches approximately 15 days or 100,000 rows in tc_positions the service stops working. And back only when I delete using DELETE from tc_positions WHERE id BETWEEN 1 AND 100000 ;. The database is no larger than 35mb. Can you please help me? Thanks.

What stops working? Have you checked logs?

I need to reboot and delete data from tc_positions. I notice that the service has stopped when I try to log in with my admin user and I get the following message. "Blocked user".

2020-01-03 21:49:08  WARN: Update device status error - HikariPool-1 - Connection is not available, request timed out after 30000ms. - SQLTransientConnectionException (... < QueryBuilder:59 < *:135 < DataManager:337 < DeviceManager:250 < ...)
2020-01-03 21:49:08  WARN: An exceptionCaught() event was fired, and it reached at the tail of the pipeline. It usually means the last handler in the pipeline did not handle the exception. - Too many open files - IOException (...)
2020-01-03 21:49:09  WARN: Too many open files - IOException (...)
2020-01-03 21:49:09  WARN: An exceptionCaught() event was fired, and it reached at the tail of the pipeline. It usually means the last handler in the pipeline did not handle the exception. - Too many open files - IOException (...)
...
2020-01-03 21:49:10  WARN: An exceptionCaught() event was fired, and it reached at the tail of the pipeline. It usually means the last handler in the pipeline did not handle the exception. - Too many open files - IOException (...)
2020-01-03 21:49:10  WARN: An exceptionCaught() event was fired, and it reached at the tail of the pipeline. It usually means the last handler in the pipeline did not handle the exception. - Too many open files - IOException (...)
2020-01-03 21:49:11  WARN: Too many open files - IOException (...)

Have you tried searching Too many open files?

I incremented the lines LimitNOFILE = 50000
Restart = Always.
I will follow. Thank you.

This is an issue of the system if you are on linux, I have 1500+ device sending data every 5 seconds when setup well you will not get that error
traccar_optimization
configure tcp connections
More on unlimit: