speedweasel

Vehicles disappearing from database

9 posts in this topic

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?

1 person likes this

Share this post


Link to post
Share on other sites

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;
};

 

Share this post


Link to post
Share on other sites
Advertisement

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 ....

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.