Database does NOT update in last hour

[SwissArmy1984 7]

Hi,

the database for vehicles DOES NOT UPDATE in the last hour before reset.  If you change position of the vehicle, move inventory, or lock/unlock it, it DOES NOT update the database and upon restart you have to go looking for your vehicle wherever an in whatever state it was at reset minus one hour.

This can easily lead to duping exploits beyond the frustration of having to look for a vehicle (that may be unlocked) on the map, remembering what you were doing an hour before restart.

This needs an IMMEDIATE fix.

Thank you.

[simon1603 7]

I have noticed this issue also, I actually thought it was just a problem at my side.

[WickedMoonShiner 10]

Hi,

the database for vehicles DOES NOT UPDATE in the last hour before reset.  If you change position of the vehicle, move inventory, or lock/unlock it, it DOES NOT update the database and upon restart you have to go looking for your vehicle wherever an in whatever state it was at reset minus one hour.

This can easily lead to duping exploits beyond the frustration of having to look for a vehicle (that may be unlocked) on the map, remembering what you were doing an hour before restart.

This needs an IMMEDIATE fix.

Thank you.

I have this issue also on my server the last hour just all is screwed up. 

[sandstorm 3]

are your servers on 4 hour restarts?

if so you need to make them 3 hours.

the servers i admin had the same issue and 3 hour restarts helped it.

[WD-40 25]

Is there any way to force server to update db? I would add it to restart script.

[Eichi 4505]

Can you provide more info? Please post your server RPT, some rough marma data like FPS/CPS and your extDB2 log.

Exile does a force update of EVERYTHING before the server restart, if you use that system. Do you use auto-locking? If so, what are your server restart times? Do they match your exile_server_config settings?

[xK3v | Burns *2-Play.de 0]

We had the Same problem with 6 hour-restarts.

We got reports, that after 3 hours there were already problems with saving the db, so now i set Restarttimer to 3hrs, hoping this will fix it

[Fishy 1]

This also happens on the server I play on, Exile Mayhem #1. The database is slow and often unresponsive. Saves are erratic at best. Often vehicles will not be saved from out to 1 hour to restart. It's also on a 3 hour cycle.

[WickedMoonShiner 10]

Can you provide more info? Please post your server RPT, some rough marma data like FPS/CPS and your extDB2 log.

Exile does a force update of EVERYTHING before the server restart, if you use that system. Do you use auto-locking? If so, what are your server restart times? Do they match your exile_server_config settings?

Since update 0.9.20 I am not using the restart auto locking now going to see if I still have issues. Let me see how this goes then report back to you

[Irok 11]

Is it still people that have this problem?

[iCEtIMed 65]

Im also having an issue with saving to database in the last hour or so. My cycle is every 6 hours and I use BEC for my restarts.

Has this issue been resolved? If anyone knows a script that can run on the database to update, thatd be great!

Could I create a global event to update the database?

Make sure its turned on;

SET GLOBAL event_scheduler = ON;
SET @@global.event_scheduler = ON;
SET GLOBAL event_scheduler = 1;
SET @@global.event_scheduler = 1;

Then;

UPDATE 'clan'

UPDATE 'construction'

UPDATE 'container'

UPDATE 'player'

UPDATE 'territory'

UPDATE 'vehicle'

 

or something with an event squeduled daily for a specific time and then every 6 hours after that for teh 24 hours??

Thanks!

 

~iCE

Edited September 27, 2015 by iCEtIMed