Database Issues

[Tricks]

Ok I am having an issue with slow traders on Epoch Chernarus. I have added only one custom trader and I'm sure he is not being used anywhere else. It has been fine for months now. We even did a database wipe last week to give our players a fresh start. Now in less then a week there is such major lag with all our traders (default and custom). Vehicles don't lock right away after purchase and players are getting locked inside because they don't wait. That's if the vehicle even appears, most times it takes the players money but doesn't spawn in the car. Even with our admin tools, vehicles disappear after we spawn them in. Our server host customer support says we probably have too many dead bodies and bases on the map. But it's only been a week since the database wipe, before that we ran for months without issues.

We have the multi-character script running, would this cause errors like this?

[avdieking]

use config traders they are really fast

[Tricks]

Anyone else can confirm this?

 

Have a link?

[StiflersM0M]

Anyone else can confirm this?

 

Have a link?

yes, but i cant find the link

[MGT]

Its not database related. We have config traders and it happens to us too.

On 1042 it was fine, when Epoch moved to 105/1051 was when it started.

The first 45-60mins after a restart its fine, then it takes longer and longer for purchased vehicles to spawn and lock.

I would suggest its an error with server monitor or server publish vehicle.

[Tricks]

Its not database related. We have config traders and it happens to us too.

On 1042 it was fine, when Epoch moved to 105/1051 was when it started.

The first 45-60mins after a restart its fine, then it takes longer and longer for purchased vehicles to spawn and lock.

I would suggest its an error with server monitor or server publish vehicle.

 

Hey MGT,

 

Did you manage to get the issue resolved in anyway?

[StiflersM0M]

Its not database related. We have config traders and it happens to us too.

On 1042 it was fine, when Epoch moved to 105/1051 was when it started.

The first 45-60mins after a restart its fine, then it takes longer and longer for purchased vehicles to spawn and lock.

I would suggest its an error with server monitor or server publish vehicle.

nvm, did not read the complete qustion, yes i have it 2. Trader itself dont lag, but the vehicle buy, the thing with locked inside and so on.

[Tricks]

This is causing sooooo many issues and it JUST started after our database wipe... Was fine for months before even after our 1.0.5.1 update.

[Tricks]

We just recently increased our trader inventories all to 500, could this be a cause?

[SideShowFreak]

Doubt it I routinely stock my traders to 5k for each item and don't have this issue. I had it happen before and traced it back to the drink water from sources script. Removed that and viola lag was gone.

[StiflersM0M]

We just recently increased our trader inventories all to 500, could this be a cause?

No, i use config traders (like MGT i think) where you cant set how much stock a trader have, and we have to same problem.

[DeanReid]

This has been happening to us too, especially if we do it through infiSTAR I didn't really think much of it though

[MGT]

I've checked all the files that spawn vehicles and there's no loops or anything like that, changed some counts back to foreach, no difference.

[justchil]

I have the same problem with config traders. I've been trying a lot of things with no luck D:

[Tricks]

I can't believe we are all having this issue..... MGT your server is ranked 7th and players to flock to your awesome server. I guess I will just have to explain to my players that this is an Epoch issue, not a server issue.

Is it still worth putting config traders in, what see the benefits?

[Externized]

We had this issue for the first time yesterday, i'm thinking about getting config based traders but i don't find a good link also i found a topic where someone said he restarts hes database everytime the server restarted and that helped for him?  :blink:

 

EDIT: found this topic right now, 

[Tricks]

Can anyone link a working config traders script please?

[Pro_Speedy]

Can anyone link a working config traders script please?

 

It's not a script just read my topic that Externized linked you to

[ghosted2014]

hiya please let me know if in wrong place i want to change the texture of large wooden walls but i dont know where to fin the files to edit it please can anyone helpt hanks

[Tricks]

Wrong thread.... this is about database lag and ISSUES.

[Sukkaed]

Same problem here. Config based traders won't make any difference with this problem. Bought vehicles can take up to 10 minutes to spawn. I have gone through all files related to vehicle spawning and I can't see a thing that could cause this but something in 1051 started it.

[SideShowFreak]

I don't have this issue. Vehicles spawn right away and I do not use config traders. The only time I had this issue I was able to trace it to the drink water from sources script. Running 1.0.5.1 as well. Any new scripts installed? If by chance you run the drink water script try removing that first. Just trying to think here. If you run infiSTAR for shits and giggles you could try changing the setting for vehicle Id check to false. Not sure if its related but worth a shot.

[MGT]

I don't have this issue. Vehicles spawn right away and I do not use config traders. The only time I had this issue I was able to trace it to the drink water from sources script. Running 1.0.5.1 as well. Any new scripts installed? If by chance you run the drink water script try removing that first. Just trying to think here. If you run infiSTAR for shits and giggles you could try changing the setting for vehicle Id check to false. Not sure if its related but worth a shot.

 

Happens with or without infiSTAR installed

[Externized]

I don't have this issue. Vehicles spawn right away and I do not use config traders. The only time I had this issue I was able to trace it to the drink water from sources script. Running 1.0.5.1 as well. Any new scripts installed? If by chance you run the drink water script try removing that first. Just trying to think here. If you run infiSTAR for shits and giggles you could try changing the setting for vehicle Id check to false. Not sure if its related but worth a shot.

Me neither, i only get it when there are like over 25 players online.. i think it has to do with the server being too busy..  :angry:

[Defent]

We have this problem too. However, wiping the database did stop a lot of our problems (We had over 9000 items in the object_data part). Although, it seems to be returning ever so slightly. The thing is, before 2 hours and 30 mins it is pretty much fine but after a while it starts going haywire with seagulls and slow buy time and stuck on retrying authentication. This leads me to believe that there is some problem with how the cache or data is handled between the server scripts and the database. 

Look for major changes in the code and compare them to 1.0.4.2 and see if you can identify anything. We have managed to limit most of these problems but sometimes the buy time reaches 1 minute at most. 

[Storm]

I am running cfg traders as well.

Don't really have much of an issue with cfg except for that it will help reduce d'sync since the server doesn't have to query that data.

 

90% of the time wiping the object data in the sql will help clear up lag, What I found to be the issue is that objects cause a lot of d'syc and lag on on the server.

That being said I believe it would help out more if base maintain was on and that the server deleted all objects (including vehicles) if not unlocked, drove or maintained in the last 15 days... I feel this would reduce the d'sync and lag issues.

I do wish vbawol would look into a better way on quering the player objects.