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
3,750 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
  • 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

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.
Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

863 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

20 Experts available now in Live!

Get 1:1 Help Now