GolovaRaoul

Deadlock found when trying to get lock; try restarting transaction

4 posts in this topic

Hello all,

I'm running Exile server and everything SEEMS to be working fine, but I'm finding these errors in extDB2 Logs:

Spoiler

extDB2: Version: 70
extDB2: https://github.com/Torndeco/extDB2
extDB2: Windows Version
Message: All development for extDB2 is done on a Linux Dedicated Server
Message: If you would like to Donate to extDB2 Development
Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2
Message: Also leave a message if there is any particular feature you would like to see added.
Message: Thanks for all the people that have donated.
Message: Torndeco: 20/02/15


extDB2: Found extdb-conf.ini
extDB2: Detected 8 Cores, Setting up 6 Worker Threads


[15:34:20:335878 +00:-1] [Thread 5504] extDB2: Database Type: MySQL
[15:34:20:347157 +00:-1] [Thread 5504] extDB2: Database Session Pool Started
[15:34:20:349007 +00:-1] [Thread 5504] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\Arma\chernarus\@exileserver\extDB\sql_custom_v2\exile.ini
[15:34:20:349137 +00:-1] [Thread 5504] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[15:34:20:727084 +00:-1] [Thread 5432] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error    [mysql_stmt_error]: Deadlock found when trying to get lock; try restarting transaction    [mysql_stmt_errno]: 1213    [mysql_stmt_sqlstate]: 40001    [statemnt]: UPDATE territory SET deleted_at = NOW() WHERE last_paid_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND deleted_at IS NULL
[15:34:20:727124 +00:-1] [Thread 5432] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[15:34:20:727136 +00:-1] [Thread 5432] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: markDeleteUnpaidTerritories:7
[15:34:20:727280 +00:-1] [Thread 4796] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_execute error    [mysql_stmt_error]: Deadlock found when trying to get lock; try restarting transaction    [mysql_stmt_errno]: 1213    [mysql_stmt_sqlstate]: 40001    [statemnt]: DELETE FROM territory WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY)
[15:34:20:727313 +00:-1] [Thread 4796] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[15:34:20:727324 +00:-1] [Thread 4796] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteUnpaidTerritories:2
 

These seem to happen almost every restart. Should I be concerned about this? And what is exactly happening? My shot would be that it can't delete a territory because it's locked by something else... Not sure, if anyone could help me out that'd be great ^^

Thanks for responding
GolovaRaoul

Share this post


Link to post
Share on other sites

Hello Golova,

 

It would appear several items are trying to access the same item more than once.

 

See:  http://stackoverflow.com/questions/2332768/how-to-avoid-mysql-deadlock-found-when-trying-to-get-lock-try-restarting-trans

 

Google:  https://www.google.com/search?q=Deadlock+found+when+trying+to+get+lock%3B+try+restarting+transaction&ie=utf-8&oe=utf-8#q="Deadlock+found+when+trying+to+get+lock%3B+try+restarting+transaction"

 

I would suspect it is a mod that you have created, modified, or installed.  Which one?  Who knows.

Best bet is to start with a default exile install and check, then add ONE mod AT A TIME and check.  When you see the error, it is the last mod installed.

 

Good luck to ya!

:)

 

Share this post


Link to post
Share on other sites
Advertisement
On 22-10-2016 at 10:17 PM, Z80CPU said:

Hello Golova,

 

It would appear several items are trying to access the same item more than once.

 

See:  http://stackoverflow.com/questions/2332768/how-to-avoid-mysql-deadlock-found-when-trying-to-get-lock-try-restarting-trans

 

Google:  https://www.google.com/search?q=Deadlock+found+when+trying+to+get+lock%3B+try+restarting+transaction&ie=utf-8&oe=utf-8#q="Deadlock+found+when+trying+to+get+lock%3B+try+restarting+transaction"

 

I would suspect it is a mod that you have created, modified, or installed.  Which one?  Who knows.

Best bet is to start with a default exile install and check, then add ONE mod AT A TIME and check.  When you see the error, it is the last mod installed.

 

Good luck to ya!

:)

 

Yeej... Rebuilding the server completly...  Not exact the answer I was hoping for, but thank you anyway ;)

Share this post


Link to post
Share on other sites

Well, see, that is the problem.  I bet anything you had multiple mods installed along with the fact that you did not give any 'background' on anything except that error.

 

Without complete info, it's kinda hard to help.  But, what I provided should 'point you' in the correct direction.  Sadly, I am not a MySQL expert.

 

Hope it works for ya!

 

Remember ONE MOD AT A TIME AND CHECK!

 

:)

 

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.