Skip to Content Skip to Menu

Error 1213 on UDDEIM pages

  • testeuse
  • testeuse
  • OFFLINE
  • Posts: 93
  • Thanks: 2
  • Karma: 0
7 years 6 months ago - 7 years 6 months ago #294192 by testeuse
Error 1213 on UDDEIM pages was created 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:
Last edit: 7 years 6 months ago by testeuse.

Please Log in or Create an account to join the conversation.

  • slabbi
  • slabbi
  • OFFLINE
  • Posts: 3709
  • Thanks: 250
  • Karma: 153
7 years 6 months ago #294204 by slabbi
Replied by slabbi on topic Error 1213 on UDDEIM pages
Very strange. I have no idea why this error appears. How many users does your site have?

uddeIM & uddePF Development
CB Language Workgroup
CB 3rd Party Developer

Please Log in or Create an account to join the conversation.

  • testeuse
  • testeuse
  • OFFLINE
  • Posts: 93
  • Thanks: 2
  • Karma: 0
7 years 6 months ago #294205 by testeuse
Replied by testeuse on topic Error 1213 on UDDEIM pages
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.

Please Log in or Create an account to join the conversation.

  • slabbi
  • slabbi
  • OFFLINE
  • Posts: 3709
  • Thanks: 250
  • Karma: 153
7 years 5 months ago #294210 by slabbi
Replied by slabbi on topic Error 1213 on UDDEIM pages
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
CB Language Workgroup
CB 3rd Party Developer

Please Log in or Create an account to join the conversation.

Moderators: beatnantslabbikrileon
Powered by Kunena Forum