#3923 (ok 4.0.10) Import with nginx + php-fpm fails with 504 Gateway Timeout

4.0.0
fixed
None
1
2013-12-12
2013-05-11
MikeH
No

I've upgraded from 3.5.8 to 4.0.0 and now if I try to import a gzipped export file that i created from another PMA installation, I get a 504 Gateway Timeout even though the file is very small. If i downgrade to 3.5.8 again, the same file is importet in less than 5 s.

I've tested in both, Chrome and Firefox. The MySQL version is 5.5.31-0ubuntu0.12.10.1-log - (Ubuntu).

The only log output is:

2013/05/11 10:40:11 [error] 13561#0: 34069 upstream timed out (110: Connection timed out) while reading response header from upstream, client: ...7, server: ssl..de, request: "GET /pma/import_status.php?message=true&token=HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "ssl..de", referrer: "https://ssl..de/pma/index.php?token=***"

Discussion

  • oksiquatzel

    oksiquatzel - 2013-05-28

    Hi,

    i had the same problem with Large Database and many tables(1000+). The Timeout comes from nginx. Adjust the Following Parameters for your needs in your nginx host conf
    fastcgi_connect_timeout 300s;
    fastcgi_send_timeout 300s;
    fastcgi_read_timeout 300s;

    for me 300 seconds was working.

    mfg djm

     
  • MikeH

    MikeH - 2013-05-28

    Thanks, but this does not explain, why the import takes only a couple of seconds in 3.5.8. Waiting for more than 5 minutes for a tiny import is not really acceptable. So i wonder, what has changed in 4.0.0 in the import routine? Can't it be improved?

     
  • Marc Delisle

    Marc Delisle - 2013-10-10

    MikeH,
    can you try again with version 4.0.8 to see if the problem persists?

     
  • Marc Delisle

    Marc Delisle - 2013-10-10
    • status: open --> pending
     
  • Marc Delisle

    Marc Delisle - 2013-12-10

    MikeH, feedback please?

     
  • MikeH

    MikeH - 2013-12-11

    I've tested with pma 4.0.10 and the problem seems to be gone.

     
  • Marc Delisle

    Marc Delisle - 2013-12-11

    Thanks MikeH.

     
  • Marc Delisle

    Marc Delisle - 2013-12-11
    • summary: Import with nginx + php-fpm fails with 504 Gateway Timeout --> (ok 4.0.10) Import with nginx + php-fpm fails with 504 Gateway Timeout
    • status: pending --> resolved
    • assigned_to: Marc Delisle
    • Priority: 5 --> 1
     
  • Marc Delisle

    Marc Delisle - 2013-12-12
    • Status: resolved --> fixed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks