Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Problem with deadlock and broken tree when performing new registrations. #574

Open
betgamesnetwork opened this issue Feb 10, 2023 · 0 comments

Comments

@betgamesnetwork
Copy link

Hello, we are having the following deadlock issue in our application. The system is running with two instances of mysql on digitalocean.

Error (Illuminate\Database\QueryException):
File : /var/www/staging/back-end/vendor/laravel/framework/src/Illuminate/Database/Connection.php
Line: 671

Message:
SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction (SQL: insert into credit_account_movements
(------, -------, -----, ----, ----, credit_account_id) values (ENTRY, GA, ------,--------, 2408, 557))

Another problem we have is in relation to the broken tree, at times when there are several entries the tree breaks and we have to keep monitoring and executing the commands below to correct it.

\App\Models\User::isBroken()

\App\Models\User::fixTree()

Is there any way to fix this or create a job/cron to perform this tree fix every minute, for example?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant