XxUnkn0wnxX
Active member
i have two page full of this error:
Mysqli statement execute error : Deadlock found when trying to get lock; try restarting transaction - library/Zend/Db/Statement/Mysqli.php:214
every day i get errors something like or similar
how do i stop them from occoring at all? is it the lack of ram for the Mysql data base? to many threads happening at the same time? is there a way to reduce/stop these errors from happening ?
i wish to run a clean and healthy server and site with no errors....
i have also been experiencing error pages when i save large amounts of data say i change 15-20 fields in permissions on a user group i also have around 10+ different user groups.
like when i would save the loading indicator on my browser keeps spinning i tends to get this error when it times out. and i have to press the back button and try again 3 times before it actually saves.
i also get this same issue when trying to update my add ones when i try to import/upload 3-5 zip files or xml files at the same time or check for updates. this all using the Add One Install and upgrade (add one) i also sometimes get the internal server error pages when i am rebuilding templates its like it times out...
it is like there is some much going on real time data being stored and obtained while me trying to store more data the data base cannot handle it..
this cannot go on any more how do i stop and fix this what do i need to do to improve the performance on my server? what services such as Mysql how should they be improved..
but i am unsure what the error could be
could be to much information processed by the data base at the same time
+ how would i fix this? how would i limit this what multi threading module would i need for Mysql?
this the error i get when it times out..
and as you can see i get a 500 error code when i preform the action save/POST
Mysqli statement execute error : Deadlock found when trying to get lock; try restarting transaction - library/Zend/Db/Statement/Mysqli.php:214
every day i get errors something like or similar
how do i stop them from occoring at all? is it the lack of ram for the Mysql data base? to many threads happening at the same time? is there a way to reduce/stop these errors from happening ?
i wish to run a clean and healthy server and site with no errors....
Code:
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Deadlock found when trying to get lock; try restarting transaction - library/Zend/Db/Statement/Mysqli.php:214
Generated By: 2pac, Today at 1:43 AM
Stack Trace
#0 /home/unkn0wn/public_html/forums/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/unkn0wn/public_html/forums/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/unkn0wn/public_html/forums/library/XenForo/Model/Like.php(186): Zend_Db_Adapter_Abstract->query('?????INSERT IGN...', Array)
#3 /home/unkn0wn/public_html/forums/library/Waindigo/Rewards/Extend/XenForo/Model/Like.php(37): XenForo_Model_Like->likeContent('post', 8879, 1, 20, NULL)
#4 /home/unkn0wn/public_html/forums/library/XenForo/ControllerPublic/Post.php(393): Waindigo_Rewards_Extend_XenForo_Model_Like->likeContent('post', 8879, 1)
#5 /home/unkn0wn/public_html/forums/library/XenForo/FrontController.php(347): XenForo_ControllerPublic_Post->actionLike()
#6 /home/unkn0wn/public_html/forums/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#7 /home/unkn0wn/public_html/forums/index.php(13): XenForo_FrontController->run()
#8 {main}
Request State
array(3) {
["url"] => string(47) "http://portalcentric.net/forums/posts/8879/like"
["_GET"] => array(0) {
}
["_POST"] => array(4) {
["_xfRequestUri"] => string(49) "/forums/threads/regarding-rte-modding-tools.1403/"
["_xfNoRedirect"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfResponseType"] => string(4) "json"
}
}i have also been experiencing error pages when i save large amounts of data say i change 15-20 fields in permissions on a user group i also have around 10+ different user groups.
like when i would save the loading indicator on my browser keeps spinning i tends to get this error when it times out. and i have to press the back button and try again 3 times before it actually saves.
i also get this same issue when trying to update my add ones when i try to import/upload 3-5 zip files or xml files at the same time or check for updates. this all using the Add One Install and upgrade (add one) i also sometimes get the internal server error pages when i am rebuilding templates its like it times out...
it is like there is some much going on real time data being stored and obtained while me trying to store more data the data base cannot handle it..
this cannot go on any more how do i stop and fix this what do i need to do to improve the performance on my server? what services such as Mysql how should they be improved..
but i am unsure what the error could be
could be to much information processed by the data base at the same time
+ how would i fix this? how would i limit this what multi threading module would i need for Mysql?
this the error i get when it times out..
Code:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@portalcentric.net and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.and as you can see i get a 500 error code when i preform the action save/POST
Code:
Hidden - [19/Apr/2014:15:14:33 +1000] "POST /forums/admin.php?user-group-permissions/new-member.2/save HTTP/1.1" 500 547 "http://portalcentric.net/forums/admin.php?user-group-permissions/new-member.2/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:28.0) Gecko/20100101 Firefox/28.0"
Last edited:
