tc_actions table
What is it reading?
It looks like it repeatedly requests events report, which is definitely a misuse of the API.
To answer your original question, there's no rotation in place, but truncating the table shouldn't be a problem. For now it's just a log that is never read from by Traccar.
Just adding a related question: How many different values do actiontype and objecttype columns have? Here's what I have so far, but are there any others I should be aware of? Not sure how it works under the hood.
actiontype: accumulators, command, create, denied, edit, link, login, logout, remove, report, unlink.
objecttype: attribute, command, device, geofence, managedUser, notification, user.
Check this source code file:
https://github.com/traccar/traccar/blob/master/src/main/java/org/traccar/helper/LogAction.java
Thanks, additional question, what is this supposed to do exactly?
I see records like this in db:
3045 2025-06-06 15:31:59.000 <ip_address> <userid> accumulators device <objectid> {}
All I got searching through the repo was this file that has some set/get methods for hours and total distance, but idk whether is relevant at all
I'd like to know what each field means because I'll be using that table to do something like this:
hello,
I see that in traccar 6.7.1 the login/report logs are written in tc_actions
Having home assistant reading every 30 seconds from traccar, this table will increase in size very quickly.
Is there a rotation policy in place?
If I periodically do a TRUNCATE TABLE will I create problems?
Thanks in advance