Vehicles disappearing from database

[speedweasel 276]

Around 1 in 10 locked vehicles disappear from my server.  I've done some testing and after a reboot, those vehicles simply aren't in the database any more.  Some of the vehicles were in safe zones, some weren't.  100% of the missing vehicles were locked.

unlockInSafeZonesAfterRestart = 0;

^ I've turned off unlocking vehicles in safe zones.  Is anyone else seeing this on their servers?

[Brun 88]

Are you sure they aren't being remove by the garbage collector at restart ?

@ExileServer\extDB\sql_custom_v2\exile.ini

; Removes vehicles that were not used within ? days
[deleteOldVehicles]
SQL1_1 = DELETE FROM vehicle WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY)
Number Of Inputs = 1
SQL1_INPUTS = 1

@ExileServer\addons\exile_server_config\config.cpp
Line 2706 - 2721
 

class Database 
{
	// Remove all territories (and contructions + containers in it) that were not paid after X days
	territoryLifeTime = 7;

	// Remove all containers outside of territories that have not been used for X days
	// Example: Tents
	containerLifeTime = 7;

	// Remove all constructions outside of territories that are older than X days or not moved for X days 
	// Example: Work Benches
	constructionLifeTime = 2;

	// Remove all vehicles that were not moved/used for X days
	vehicleLifeTime = 3;
};

 

[speedweasel 276]

Thanks for this.  I have all my database cleanup values set to 7 days (small server.)  The vehicles disappeared overnight and I know they were used in the last 24 hours.

At least some of the vehicles were locked on piers over the ocean.  Maybe the server spawned them in but the ATL wasn't found, vehicles were critically damaged and cleaned up?  Not sure.

[da1geek 13]

Same here. Can't find an explanation. 

[xZEUZYx 5]

I have been told this is happening on our server too anyone have any ideas?

[da1geek 13]

None. As far as I can tell, there is no "similar occurrence" causing them. 

[[TWG]Alex 6]

I think is a DB problem ,

I've some problem on my server ..... 

Vehicle come back to spawn point (SAFE ZONE) or Disappears.

i've other one server (test) and not disappears vehicle.....

I want try to reset my DB ....

[Malankore 0]

Issue here as well, they either disappear completely, or revert to safe zone.

[ynpMOOSE 122]

Others having the same problem:

 

[UCJOHN 37]

I can verify this is a ongoing issue with our server right now.