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,817 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

770 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