Help With This Error !i Will Pay !

[PlayErtheia]

I have this problem ,and started when i open the server ,i had it online for few months and i didn t had this problem ! IM RUNNING with protection OFF now if i activate it in few minutes server will be stuck........ if i let like this the errors will start in 6-7 hours....

 

 

Edited July 31, 2014 by Evo Owner

[SpirakosDafuq™]

reupload the images i see this

[PlayErtheia]

reupload the images i see this

done

[Boorinio]

can't see the pictures...

[PlayErtheia]

can't see the pictures...

 

do you can see now ?

 

Edited July 31, 2014 by Evo Owner

[Tryskell]

It seems you use big queries which haven't enough time to be processed, reaching the default transactions maximum.

 

You can up the default value innodb_lock_wait_timeout on your mySQL server, but it's only a temporary fix. You will normally always end with that issue, no matter how big is the number, if I'm correct. The solution ? Find and fix the query which deadlocks your server.

[PlayErtheia]

It seems you use big queries which haven't enough time to be processed, reaching the default transactions maximum.

 

You can up the default value innodb_lock_wait_timeout on your mySQL server, but it's only a temporary fix. You will normally always end with that issue, no matter how big is the number, if I'm correct. The solution ? Find and fix the query which deadlocks your server.

so this is from mysql ....not from my server ?...

[Extreamer]

so this is from mysql ....not from my server ?...

 

Yes it is from mysql, "SQL" should give you a clue :)

[PlayErtheia]

Yes it is from mysql, "SQL" should give you a clue :)

do you know how to fix it ?

[SweeTs]

do you know how to fix it ?

Tk already told you. Increase the value. And its caused by some crappy code.

[Tryskell]

As I said, it's one of the query of your GAMESERVER which is the problem. You can temporary fix it editing properties of your mySQL server, but if I'm write about first statement, then it should come back few times later (you will only save some times before it deadlocks again).

 

So the problem is normally the GAMESERVER. Whatever you added as customs, I suggest you to test and read all mySQL queries you added, one is probably particularly heavy to process.

 

PS : I see it's on a restart process. Does the problem occur in regular running state or only during restart ?

[Extreamer]

My guess might be that Force inventory update can cause the issue.

[PlayErtheia]

As I said, it's one of the query of your GAMESERVER which is the problem. You can temporary fix it editing properties of your mySQL server, but if I'm write about first statement, then it should come back few times later (you will only save some times before it deadlocks again).

 

So the problem is normally the GAMESERVER. Whatever you added as customs, I suggest you to test and read all mySQL queries you added, one is probably particularly heavy to process.

 

PS : I see it's on a restart process. Does the problem occur in regular running state or only during restart ?

yes  also in running state...but i think is fixed ....also i find a config about deadlock in gameserver...

[Tryskell]

Deadlock checker from L2J isn't made for your problem. You got a mySQL transaction issues.

[PlayErtheia]

so anyone of u can fix my problem ? i will pay  ofc...

Edited August 2, 2014 by Evo Owner

[PlayErtheia]

fixed