Problem registering the notification token

Steffen 10 hours ago

I am on 6.14.5 and my Traccar Manager app does not generate a token. I can see in the logs the following entry upon login via the app:

WARN: Failed to store action create

Is this related to the token generation? I am using newest Android app from google play store.

Anton Tananaev 8 hours ago

Are you sure you have official Traccar without any modifications?

Anton Tananaev 8 hours ago

This error likely means you have some database schema issue.

Steffen 8 hours ago

I am using traccar with docker with a very basic yml. I am not aware of any schema issues.

services:
traccar:
image: traccar/traccar:latest
container_name: traccar
restart: always
ports:
- "10.252.1.1:8082:8082"
- "10.252.1.1:5055:5055"
volumes:
- ./logs:/opt/traccar/logs
- ./data:/opt/traccar/data
- ./traccar.xml:/opt/traccar/conf/traccar.xml:ro
environment:
TZ: Europe/Berlin


traccar.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM 'http://java.sun.com/dtd/properties.dtd'>
<properties>

    <!-- Documentation: https://www.traccar.org/configuration-file/ -->

    <entry key='database.driver'>org.h2.Driver</entry>
    <entry key='database.url'>jdbc:h2:./data/database</entry>
    <entry key='database.user'>sa</entry>
    <entry key='database.password' />
<entry key='event.status.enable'>true</entry>
<entry key='notificator.types'>traccar,web,sms</entry>
<entry key='notificator.traccar.key'><API-KEY></entry>
<entry key='status.timeout'>10</entry>
<entry key='logger.level'>debug</entry>
</properties>
Steffen 2 hours ago

I've reinstalled the docker image with mysql from scratch. Same issue. I've found out (with the help of Claude) that according to the log there is an suspicious INSERT query related to "token":

INSERT INTO tc_actions(actionType, actionTime, address, attributes, userId, objectId, objectType) VALUES ('create', '2026-07-22 18:32:52.711', '10.252.1.3', '{}', 1, 3073803337116921467, 'token')

If I execute this query manually I receive the error:

ERROR 1264 (22003): Out of range value for column 'objectid' at row 1

The value 3073803337116921467 is a 19-digit number. That far exceeds the range of MySQL INT (maximum 2147483647, i.e. 10 digits). The reason is that Traccar appears to generate token IDs as long random long values (64-bit), while the objectId column in tc_actions is likely defined as INT (32-bit) instead of BIGINT.

If I modify the type to BIGINT and re-execute the query manually, the error is gone:

"Query OK, 1 row affected (0.005 sec)"

The error in the tracker-server.log "WARN: Failed to store action create" is gone.
Nevertheless, the token under attributes in user is still not generated after re-login.