● traccar.service - traccar
Loaded: loaded (/etc/systemd/system/traccar.service; enabled; vendor preset: disabled)
Active: activating (auto-restart) (Result: exit-code) since Wed 2023-10-04 05:52:12 UTC; 2s ago
Process: 79870 ExecStart=/opt/traccar/jre/bin/java -jar tracker-server.jar conf/traccar.xml (code=exited, status=1/FAILURE)
Main PID: 79870 (code=exited, status=1/FAILURE)
Oct 04 05:52:12 103-31-81-103.multi.net.pk systemd[1]: Unit traccar.service entered failed state.
Oct 04 05:52:12 103-31-81-103.multi.net.pk systemd[1]: traccar.service failed.
Database Error:::
2023-10-04 05:42:27 DEBUG: HandlerList@1051817b{STOPPED} added {GzipHandler@57f791c6{STOPPED,min=32,inflate=-1},AUTO}
2023-10-04 05:42:27 DEBUG: Server@7fc44dec{STOPPED}[10.0.7,sto=0] added {HandlerList@1051817b{STOPPED},MANAGED}
2023-10-04 05:42:27 WARN: Refresh server config error - Unknown column 'latitude' in 'field list' - SQLSyntaxErrorException (... < QueryBuilder:405 < DatabaseStorage:39 < Storage:26 < ...)
2023-10-04 05:42:27 WARN: Refresh device permissions error - Table 'hypegps_traccar.tc_user_group' doesn't exist - SQLSyntaxErrorException (... < QueryBuilder:479 < DatabaseStorage:104 < DataManager:240 < ...)
2023-10-04 05:42:27 WARN: Error refreshing items - Unknown column 'calendarid' in 'field list' - SQLSyntaxErrorException (... < QueryBuilder:405 < DatabaseStorage:39 < DataManager:259 < ...)
2023-10-04 05:42:27 WARN: Error getting permissions - Table 'hypegps_traccar.tc_user_geofence' doesn't exist - SQLSyntaxErrorException (... < QueryBuilder:479 < DatabaseStorage:104 < DataManager:240 < ...)
2023-10-04 05:42:27 WARN: Refresh permissions error - Table 'hypegps_traccar.tc_device_geofence' doesn't exist - SQLSyntaxErrorException (... < QueryBuilder:479 < DatabaseStorage:104 < DataManager:240 < ...)
2023-10-04 05:42:27 ERROR: Main method error - IllegalMonitorStateException (... < BaseObjectManager:63 < ExtendedObjectManager:139 < GeofenceManager:34 < ...)
You can see from the log that there are tables and columns that do not exist in your database.
It doesn't look like you upgraded it correctly. You have to check the whole log and see if any of the schema migrations failed.
Database Error:::