Hi,
Once 3 or 4 days, nginx server gives 500 internet server error, and then we restart mysql (percona), and for 3 days problem is being solved. Then same problem occurs agains.
In config.php there is a row:
ini_set('memory_limit', '-1');
And our server is pretty strong which is a dedicated stand alone server with 16GB memory.
I know this problem is occured because AdManager plugin but 3 weeks ago there were not any error about this plugin. Any advice please?
******
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : The table 'merc_ad_view' is full - library/Zend/Db/Statement/Mysqli.php:214
#0 /home/nginx/domains/bodyforumtr.com/public/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/nginx/domains/bodyforumtr.com/public/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/nginx/domains/bodyforumtr.com/public/library/Merc/AdManager/Model/Ad.php(203): Zend_Db_Adapter_Abstract->query('\n\t\t\tINSERT INTO...')
#3 /home/nginx/domains/bodyforumtr.com/public/library/Merc/AdManager/Listener/TemplatePostRender.php(25): Merc_AdManager_Model_Ad->countAdView(Array)
#4 /home/nginx/domains/bodyforumtr.com/public/library/Merc/AdManager/Listener/TemplatePostRender.php(33): Merc_AdManager_Listener_TemplatePostRender->execute('PAGE_CONTAINER', '<!DOCTYPE html>...', Array, Object(XenForo_Template_Public))
#5 [internal function]: Merc_AdManager_Listener_TemplatePostRender::listen2('PAGE_CONTAINER', '<!DOCTYPE html>...', Array, Object(XenForo_Template_Public))
#6 /home/nginx/domains/bodyforumtr.com/public/library/XenForo/CodeEvent.php(58): call_user_func_array(Array, Array)
#7 /home/nginx/domains/bodyforumtr.com/public/library/XenForo/Template/Abstract.php(195): XenForo_CodeEvent::fire('template_post_r...', Array, 'PAGE_CONTAINER')
#8 /home/nginx/domains/bodyforumtr.com/public/library/XenForo/Template/Public.php(110): XenForo_Template_Abstract->render()
#9 /home/nginx/domains/bodyforumtr.com/public/library/XenForo/ViewRenderer/HtmlPublic.php(135): XenForo_Template_Public->render()
#10 /home/nginx/domains/bodyforumtr.com/public/library/XenForo/FrontController.php(604): XenForo_ViewRenderer_HtmlPublic->renderContainer(Object(XenForo_Template_Public), Array)
#11 /home/nginx/domains/bodyforumtr.com/public/library/XenForo/FrontController.php(158): XenForo_FrontController->renderView(Object(XenForo_ControllerResponse_View), Object(XenForo_ViewRenderer_HtmlPublic), Array)
#12 /home/nginx/domains/bodyforumtr.com/public/index.php(13): XenForo_FrontController->run()
#13 {main}
array(3) {
["url"] => string(43) "http://www.bodyforumtr.com/members/xxxx/"
["_GET"] => array(1) {
["/members/xxxx/"] => string(0) ""
}
["_POST"] => array(0) {
}
}
Once 3 or 4 days, nginx server gives 500 internet server error, and then we restart mysql (percona), and for 3 days problem is being solved. Then same problem occurs agains.
In config.php there is a row:
ini_set('memory_limit', '-1');
And our server is pretty strong which is a dedicated stand alone server with 16GB memory.
I know this problem is occured because AdManager plugin but 3 weeks ago there were not any error about this plugin. Any advice please?
******
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : The table 'merc_ad_view' is full - library/Zend/Db/Statement/Mysqli.php:214
#0 /home/nginx/domains/bodyforumtr.com/public/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/nginx/domains/bodyforumtr.com/public/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/nginx/domains/bodyforumtr.com/public/library/Merc/AdManager/Model/Ad.php(203): Zend_Db_Adapter_Abstract->query('\n\t\t\tINSERT INTO...')
#3 /home/nginx/domains/bodyforumtr.com/public/library/Merc/AdManager/Listener/TemplatePostRender.php(25): Merc_AdManager_Model_Ad->countAdView(Array)
#4 /home/nginx/domains/bodyforumtr.com/public/library/Merc/AdManager/Listener/TemplatePostRender.php(33): Merc_AdManager_Listener_TemplatePostRender->execute('PAGE_CONTAINER', '<!DOCTYPE html>...', Array, Object(XenForo_Template_Public))
#5 [internal function]: Merc_AdManager_Listener_TemplatePostRender::listen2('PAGE_CONTAINER', '<!DOCTYPE html>...', Array, Object(XenForo_Template_Public))
#6 /home/nginx/domains/bodyforumtr.com/public/library/XenForo/CodeEvent.php(58): call_user_func_array(Array, Array)
#7 /home/nginx/domains/bodyforumtr.com/public/library/XenForo/Template/Abstract.php(195): XenForo_CodeEvent::fire('template_post_r...', Array, 'PAGE_CONTAINER')
#8 /home/nginx/domains/bodyforumtr.com/public/library/XenForo/Template/Public.php(110): XenForo_Template_Abstract->render()
#9 /home/nginx/domains/bodyforumtr.com/public/library/XenForo/ViewRenderer/HtmlPublic.php(135): XenForo_Template_Public->render()
#10 /home/nginx/domains/bodyforumtr.com/public/library/XenForo/FrontController.php(604): XenForo_ViewRenderer_HtmlPublic->renderContainer(Object(XenForo_Template_Public), Array)
#11 /home/nginx/domains/bodyforumtr.com/public/library/XenForo/FrontController.php(158): XenForo_FrontController->renderView(Object(XenForo_ControllerResponse_View), Object(XenForo_ViewRenderer_HtmlPublic), Array)
#12 /home/nginx/domains/bodyforumtr.com/public/index.php(13): XenForo_FrontController->run()
#13 {main}
array(3) {
["url"] => string(43) "http://www.bodyforumtr.com/members/xxxx/"
["_GET"] => array(1) {
["/members/xxxx/"] => string(0) ""
}
["_POST"] => array(0) {
}
}
