+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Dealock Error 1213 (/showthread.php?tid=49257)
Dealock Error 1213 - El Forum - 02-13-2012
[eluser]xerosis[/eluser]
Hi,
I keep getting a deadlock on my site:
Code:
A Database Error Occurred
Error Number: 1213
Deadlock found when trying to get lock; try restarting transaction
UPDATE `adp_session` SET `last_activity` = 1329129920, `session_id` = '5334161763893b01ac8a472075b736ee' WHERE session_id = 'eac2b882436365c0cf5b48a7a49883ec'
Filename: libraries/Session.php
Line Number: 382This is starting to happen frequently.
What are the different reasons something like this happens? If someone could help me.
Thanks.
Dealock Error 1213 - El Forum - 02-13-2012
[eluser]InsiteFX[/eluser]
Because CodeIgniter handles all of the internal and you should not be messingwith it.
Also CI stores all that in a cookie.
If you need to keep track of that information create your own database table.