Magento -SQL 2002错误
Magento -SQL 2002错误
提问于 2013-04-21 23:55:05
我有一个关于EC2大型实例的magento网站，与RDS上的数据库，这也是一个大型实例。现在，1。我的网站上最多有25个人的流量。2.我正在及时面对下面的sql错误，有时6-7小时后出现，有时一天后出现，有人能帮我吗? 3.为了摆脱这个错误，我重新启动了服务，它恢复正常，但过了一段时间，这个错误又出现了！
处理您的请求SQLSTATEHY000连接超时时出错
跟踪：
#0 /opt/bitnami/apps/magento/htdocs/lib/Zend/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /opt/bitnami/apps/magento/htdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(313): Zend_Db_Adapter_Pdo_Mysql->_connect()
#2 /opt/bitnami/apps/magento/htdocs/lib/Zend/Db/Adapter/Abstract.php(459): Varien_Db_Adapter_Pdo_Mysql->_connect()
#3 /opt/bitnami/apps/magento/htdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SET NAMES utf8', Array)
#4 /opt/bitnami/apps/magento/htdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('SET NAMES utf8', Array)
#5 /opt/bitnami/apps/magento/htdocs/app/code/core/Mage/Core/Model/Resource.php(169): Varien_Db_Adapter_Pdo_Mysql->query('SET NAMES utf8')
#6 /opt/bitnami/apps/magento/htdocs/app/code/core/Mage/Core/Model/Resource.php(110): Mage_Core_Model_Resource->_newConnection('pdo_mysql', Object(Mage_Core_Model_Config_Element))
#7 /opt/bitnami/apps/magento/htdocs/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(320): Mage_Core_Model_Resource->getConnection('core_write')
#8 /opt/bitnami/apps/magento/htdocs/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(350): Mage_Core_Model_Resource_Db_Abstract->_getConnection('write')
#9 /opt/bitnami/apps/magento/htdocs/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(335): Mage_Core_Model_Resource_Db_Abstract->_getWriteAdapter()
#10 /opt/bitnami/apps/magento/htdocs/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(360): Mage_Core_Model_Resource_Db_Abstract->_getReadAdapter()
#11 /opt/bitnami/apps/magento/htdocs/app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php(134): Mage_Core_Model_Resource_Db_Abstract->getReadConnection()
#12 /opt/bitnami/apps/magento/htdocs/app/code/core/Mage/Core/Model/Config.php(1348): Mage_Core_Model_Resource_Db_Collection_Abstract->__construct(Object(Mage_Core_Model_Resource_Website))
#13 /opt/bitnami/apps/magento/htdocs/app/code/core/Mage/Core/Model/Config.php(1380): Mage_Core_Model_Config->getModelInstance('core_resource/w...', Object(Mage_Core_Model_Resource_Website))
#14 /opt/bitnami/apps/magento/htdocs/app/Mage.php(490): Mage_Core_Model_Config->getResourceModelInstance('core/website_co...', Object(Mage_Core_Model_Resource_Website))
#15 /opt/bitnami/apps/magento/htdocs/app/code/core/Mage/Core/Model/Abstract.php(208): Mage::getResourceModel('core/website_co...', Object(Mage_Core_Model_Resource_Website))
#16 /opt/bitnami/apps/magento/htdocs/app/code/core/Mage/Core/Model/Abstract.php(213): Mage_Core_Model_Abstract->getResourceCollection()
#17 /opt/bitnami/apps/magento/htdocs/app/code/core/Mage/Core/Model/App.php(608): Mage_Core_Model_Abstract->getCollection()
#18 /opt/bitnami/apps/magento/htdocs/app/code/core/Mage/Core/Model/App.php(466): Mage_Core_Model_App->_initStores()
#19 /opt/bitnami/apps/magento/htdocs/app/code/core/Mage/Core/Model/App.php(349): Mage_Core_Model_App->_initCurrentStore('', 'store')
#20 /opt/bitnami/apps/magento/htdocs/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#21 /opt/bitnami/apps/magento/htdocs/index.php(86): Mage::run('', 'store')
#22 {main}回答 2
Stack Overflow用户
发布于 2013-04-22 01:31:56
这是一些数据库连接错误。检查本地xml文件中的数据库连接设置。您的数据库是否在同一台服务器上，否则使用套接字
Stack Overflow用户
发布于 2015-09-10 20:10:29
我在RDS实例上遇到了同样的问题。通过同一服务器上的单独文件检查连通性。
$link = mysqli_connect("host", "username", "password", "database");
if (!$link) {
echo "Error: Unable to connect to MySQL." . PHP_EOL;
echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
exit;
}
echo "Success: A proper connection to MySQL was made! The my_db database is great." . PHP_EOL;
echo "Host information: " . mysqli_get_host_info($link) . PHP_EOL;
mysqli_close($link);页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/16133092
复制相关文章
相似问题
腾讯云开发者
