Error 1213 on UDDEIM pages

1 year 2 days ago - 1 year 2 days ago #294192 by testeuse
Hi,

I am having an issue on uddeim pages.

When i try to send a message (same for my users) this message appears and we have to create the message from the star :

The page you are looking for can't be found
Error 1213 - Deadlock found when trying to get lock; try restarting transaction


It only appears on UDDEIM pages.

This is really disturbing and appearing more and more.

What caused this please? how can i make it not appearing anymore ?

Thank you for your help.

PS : I also have another error with "totrashoutbox"- I have added screencapture for this one.

Attachments:
1 year 1 day ago #294204 by slabbi
Very strange. I have no idea why this error appears. How many users does your site have?

uddeIM & uddePF Development
Google+ profile: plus.google.com/u/0/b/117839921924782901705/
CB Language Workgroup
CB 3rd Party Developer
1 year 1 day ago #294205 by testeuse
Hi,
thank you for your answer.

I have more thank 50 000 members using uddeim but not 50 000 a day.

What could cause this please? Uddeim is a huge part of my site and i can't do without it but with those errors, it became a real problem for me.

Thank you for your help.
1 year 1 day ago #294210 by slabbi
Well, I googled for this error and found several entries related with the InnoDB engine.

stackoverflow.com/questions/2596005/working-around-mysql-error-deadlock-found-when-trying-to-get-lock-try-restarti

The solution to use try/catch statements is not practical since it requires to touch a lot of code. I recommend to switch the engine back to MyISAM.

The mysql manual gives some warnings about InnoDB:
dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
To switch the engine:
dev.mysql.com/doc/refman/5.5/en/storage-engine-setting.html

uddeIM & uddePF Development
Google+ profile: plus.google.com/u/0/b/117839921924782901705/
CB Language Workgroup
CB 3rd Party Developer
Moderators: beatnantslabbikrileon
Time to create page: 0.171 seconds
Facebook Twitter Google LinkedIn