Hello,
We migrated a forum to AWS and it is plagued with deadlocks several times a day. The initial deadlock usually happens on add-reply and then they continue until other errors appear and then goes back to deadlock errors. The lastest even produced over 6000 deadlocks. We have tried increasing memory and cores, disabling addons and changing cron times. I do know that there was an issue when it was migrated and not all the database tables were imported and we had to repeat the migration. Advice on how to resolve this is much appreciated.
Thanks!
We migrated a forum to AWS and it is plagued with deadlocks several times a day. The initial deadlock usually happens on add-reply and then they continue until other errors appear and then goes back to deadlock errors. The lastest even produced over 6000 deadlocks. We have tried increasing memory and cores, disabling addons and changing cron times. I do know that there was an issue when it was migrated and not all the database tables were imported and we had to repeat the migration. Advice on how to resolve this is much appreciated.
Thanks!
Last edited: