I have an issue that I likely caused and I was wondering if someone could give me some pointers.
Other than in the logs, I believe Traccar is recording correctly (position history supports this for each device), however in the Logs page I'm seeing positions come in under the wrong device identifier. See screenshot below.
It's only one device, and so far it appears limited to just the logs page.
Background info is that I previously ran Traccar with the default database until a 5-6 months ago when I migrated to Timescale DB. That took a little work, but I got it going. A couple weeks ago I added a second device, all good. A few days ago I tried adding two devices and I was getting ERROR: duplicate key value violates unique constraint "tc_devices_pkey" when I try to add a new device.
I got that fixed with a little help (SELECT setval(pg_get_serial_sequence('tc_devices','id'), COALESCE((SELECT MAX(id) FROM tc_devices), 1));) and both new devices added without error. All appeared well.
Today I was checking logs and noticed that one device (mine, the original) is showing up in the logs with the Identifier of the 4th device. That 4th device also shows in the logs with its correct Identifier.
I checked Timescale DB and the position is correctly added to the right deviceid on the tc_positions table.
Any ideas where to look to track down my mistake (assuming it's my mistake). Thank you!
You should check real server logs to see if those devices are potentially reporting via the same network connection.
I have an issue that I likely caused and I was wondering if someone could give me some pointers.
Other than in the logs, I believe Traccar is recording correctly (position history supports this for each device), however in the Logs page I'm seeing positions come in under the wrong device identifier. See screenshot below.
It's only one device, and so far it appears limited to just the logs page.
Background info is that I previously ran Traccar with the default database until a 5-6 months ago when I migrated to Timescale DB. That took a little work, but I got it going. A couple weeks ago I added a second device, all good. A few days ago I tried adding two devices and I was getting
ERROR: duplicate key value violates unique constraint "tc_devices_pkey"when I try to add a new device.I got that fixed with a little help (
SELECT setval(pg_get_serial_sequence('tc_devices','id'), COALESCE((SELECT MAX(id) FROM tc_devices), 1));) and both new devices added without error. All appeared well.Today I was checking logs and noticed that one device (mine, the original) is showing up in the logs with the
Identifierof the 4th device. That 4th device also shows in the logs with its correctIdentifier.I checked Timescale DB and the position is correctly added to the right
deviceidon thetc_positionstable.Any ideas where to look to track down my mistake (assuming it's my mistake). Thank you!