Magento和Amazon RDS-超时 [英] Magento and Amazon RDS - timeouts

问题描述

我在Amazon EC2实例上安装了Magento CE 1.7，并在Amazon RDS Large数据库实例上安装了Magento数据库.一般来说，一切似乎都可以配置.

I have a Magento CE 1.7 installation on an Amazon EC2 instance with the Magento database on an Amazon RDS Large database instance. Generally things seems to be configured ok.

但是，在执行批量导入操作时，我遇到了某种120秒的故障.我启动了导入过程，Chrome中恰好120秒告诉我:

However, when performing bulk import operations I am hitting some sort of 120 second failure. I kick off the import process and exactly 120 seconds in Chrome tells me:

错误324(net :: ERR_EMPTY_RESPONSE):服务器关闭了连接，但未发送任何数据

Error 324 (net::ERR_EMPTY_RESPONSE): The server closed the connection without sending any data

果然导入失败.

我尝试了php.ini设置中经常给出的建议:

I have tried the often given advice of the php.ini settings:

memory_limit = 256M

memory_limit = 256M

max_execution_time = 1800

max_execution_time = 1800

但是他们没有解决它.我还调整了许多RDS参数组设置:

But they don't fix it. I have tuned a number of RDS Parameter Group settings as well:

innodb_lock_wait_timeout=120

例如-但还是没有成功.

for example - but again no success.

很明显，某个地方有一些硬编码的120秒限制(我已经定时了很多次！)，但是我无法确定是什么参数导致了此问题.

It is clear that there is some hard-coded 120 second limit somewhere (i've timed it many times!) but i cannot work out what parameter is causing the issue.

我尝试将导入文件切成小段，当我这样做时，它运行得很好.因此它也不与输入数据相关

I have tried cutting up the import file into small sections and it runs just fine when i do that. So its not input data related either

任何帮助，我们都感激不已-已经解决了2天:(

Any help much appreciated - have pushed 2 days into this issue already :(

TIA！

推荐答案

我认为ELB负载平衡器的超时设置有硬性限制.

I believe that there's a hard limit for timeouts on ELB load balancers.

这篇关于Magento和Amazon RDS-超时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！