Magento and Amazon RDS - timeouts

Posted on 2012-08-21
Last Modified: 2012-08-22
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.

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:

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

Open in new window

Sure enough the import has failed.

I have tried the often given advice of the php.ini settings:
memory_limit = 256M

max_execution_time = 1800

Open in new window

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


Open in new window

for example - but again no success.

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

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

Question by:arndale65
    LVL 58

    Expert Comment

    Have you looked at Magmi - may not solve the timeout but it is sure damn faster than using native Magento import.
    LVL 15

    Expert Comment

    by:Ess Kay

    Author Comment

    GaryC123 -
    I have tried an alternative to Magmi (another bulk import module) and that also hits to 120 second limit - thanks for the suggestion though

    esskayb2d -
    Yes i have tried the htaccess and php.ini for the parameters i mention in the post - same result - but thanks for the suggestion
    LVL 58

    Accepted Solution

    This related issue

    with a 'solution' but not a proper solution
    LVL 15

    Expert Comment

    by:Ess Kay
    try switching the php version

    Author Closing Comment

    Yes the issue was around the related issue. Work around i have put in place is for back end access (i.e. for large batch jobs of any flavour) to be on a separate, directly addressable via  EIP sub-domain. Thanks a million for the pointer.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Every business owner understands the significance of online customer reviews and the impact it can have on sales and revenues. With technology advancing at such a rapid pace, getting online reviews has never been easier, especially when many regions…
    Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
    The viewer will learn how to dynamically set the form action using jQuery.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now