Hi, I'm using traccar integration with Open Gts it works great but I have a problem with one device. In the logs I get
2019-05-04 11:22:07 WARN: Duplicate entry 'sysadmin-azul-1556980574-0' for key 'PRIMARY' - com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException (NativeConstructorAcc$
2019-05-04 11:22:09 WARN: Connection reset by peer - java.io.IOException (FileDispatcherImpl.java:-2)
The question is what I should search to find the duplicate entry?
SELECT accountID, deviceID, uniqueID, imeiNumber FROM Device WHERE imeiNumber <> '' order by deviceID;
+-----------+------------+-----------------+-----------------+
| accountID | deviceID | uniqueID | imeiNumber |
+-----------+------------+-----------------+-----------------+
| latser | 110 | | 400 |
| latser | 129 | 129 | 129 |
| sysadmin | ab236px | 225 | 225 |
| latser | ab941jl | 227 | 227 |
| latser | ab941jm | 2287527 | 2287527 |
| latser | ab941jo | 228 | 228 |
| latser | ab941jp | 190 | 190 |
| sysadmin | ac146xz | 101010 | 101010 |
| latser | ac825li | 865205031451692 | 865205031451692 |
| latser | ac825lj | 206 | 206 |
| latser | ac825ll | 865205031546582 | 865205031546582 |
| latser | ac875br | 010101 | 010101 |
| sysadmin | azul | 50419 | 50419 |
| latser | boc051 | 012896008559509 | 012896008559509 |
| latser | boj454 | 118 | 118 |
| sysadmin | cargo | 012896005324824 | 012896005324824 |
| sysadmin | cari-celu | 720841 | 720841 |
| sysadmin | cmateos | 850779 | 850779 |
| test | ct58 | 352024020989327 | 352024020989327 |
| latser | dda417 | 108 | 108 |
| latser | dda424 | 109 | 109 |
| palpala | dqi652 | 012896005353591 | 012896005353591 |
| latser | fqq930 | 112 | 112 |
| latser | goq963 | 102 | 102 |
| latser | hmc211 | 105 | 105 |
| latser | hmc212 | 012896005319055 | 012896005319055 |
| latser | hmc213 | 104 | 104 |
| latser | hmc214 | 103 | 103 |
| latser | hov903 | 106 | 106 |
| latser | hyj491 | 116 | 116 |
| latser | ick127 | 200 | 200 |
| latser | ick129 | 865205031546913 | 865205031546913 |
| latser | ick927 | 013226000083796 | 013226000083796 |
| latser | idt367 | 107 | 107 |
| latser | ifi306 | 120 | 120 |
| latser | igx457 | 013226000013991 | 013226000013991 |
| latser | igx458 | 114 | 114 |
| latser | iid381 | 381 | 381 |
| latser | ipj867 | 012896008548312 | 012896008548312 |
| latser | jee547 | 115 | 115 |
| latser | jwf379 | 012896008510015 | 012896008510015 |
| test | kangoo | 100 | 100 |
| latser | laa269 | 012896005278905 | 012896005278905 |
| sysadmin | lsq922 | 110 | 110 |
| sysadmin | lsq923 | 113 | 113 |
| latser | luq941 | 02717 | 02717 |
| latser | luq942 | 119 | 119 |
| latser | lwz047 | 201 | 201 |
| sysadmin | mb710 | 226 | 226 |
| latser | mbj774 | 101 | 101 |
| palpala | mcz872 | 013226007839752 | 013226007839752 |
| palpala | mcz874 | 012896005337214 | 012896005337214 |
| latser | mhq169 | 012896005328726 | 012896005328726 |
| palpala | nuevo | 012896005320178 | 012896005320178 |
| test | recolector | 220 | 220 |
| sysadmin | volvo | 013226001431440 | 013226001431440 |
+-----------+------------+-----------------+-----------------+
84 rows in set (0.00 sec)
The problem was that the device broke and I change it, change the imei in the same vehicle to mantain the older logs, but I'm doing something wrong.
Thanks in advance.
Best Regards
Carina
Hi, I'm using traccar integration with Open Gts it works great but I have a problem with one device. In the logs I get
The question is what I should search to find the duplicate entry?
The problem was that the device broke and I change it, change the imei in the same vehicle to mantain the older logs, but I'm doing something wrong.
Thanks in advance.
Best Regards
Carina