Solved

phpMyAdmin says: Gateway Time-out  The gateway did not receive a timely response from the upstream server or application.

Posted on 2011-02-15
4
4,020 Views
Last Modified: 2012-05-11
Hi folks,

I'm trying to look at one my databases using phpMyAdmin.  I'm able to login and see the tables just fine but as soon as I click a table to view details, the browser just sits there and spins for 5 minutes before reporting:

Gateway Time-out

The gateway did not receive a timely response from the upstream server or application.

This happens with any table.  There are two "big" tables in this system (~188,000 and ~ 275,000 rows) but each table only has five and seven columns and only stores small integer and text values (no huge values in any table cells).

Any ideas?
0
Comment
Question by:Jason C. Levine
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 3

Expert Comment

by:thecrew
ID: 34899889
You can feel good that the problem is not with your computer or Internet connection.

A 504 Gateway Timeout Error is a network error between servers on the Internet or an issue with an actual server.

This problem is due to slow IP communication between back-end computers (possibly including the Web server).
There really isn't much you can do except contact the server company...
0
 
LVL 70

Author Comment

by:Jason C. Levine
ID: 34899918
>> This problem is due to slow IP communication between back-end computers (possibly including the Web server).

Ack.  I'll check with the ISP but here's a fun one for you:  This is a dedicated server so web sites and MySQL are all hosted on the same box.  Out of a hundred or so mysql databases, this is the only one coming up with problems.

Does the above still apply?
0
 
LVL 3

Accepted Solution

by:
thecrew earned 500 total points
ID: 34900258
Hmm... that is interesting for sure! I might be wrong but I think the 504 can be related to any "link in the chain" on the server side of things. Perhaps there is a proxy or gateway server somewhere? I don't think it has to be a communication break specifically between a hosting server and a database server. But I can't figure out why one database would have the problem but another wouldn't!

I'd contact your ISP to make sure they know and then wait it out I suppose. I know that's always a crappy answer but it's all I can figure.
Let me know what happens, I'm curious!
-Logan
0
 
LVL 70

Author Closing Comment

by:Jason C. Levine
ID: 35024705
Yep, ISP issue.  Sorry for the delay in getting back to you.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When crafting your “Why Us” page, there are a plethora of pitfalls to avoid. Follow these five tips, and you’ll be well on your way to creating an effective page.
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

749 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