FutureQuest, Inc. FutureQuest, Inc. FutureQuest, Inc.
Knowledgebase: PHP/MySQL
phpMyAdmin: Lost connection to MySQL server during query?
Posted on 27 January 2004 08:42 PM
Question:

Browsing from MyPHPAdmin is working for most of the databases/tables, but for database "xdomain_5" table "MemFull" browsing is returning:

"SQL-query:

SELECT * FROM MemFull
MySQL said: Lost connection to MySQL server during query"

Doing a specific "SELECT * FROM MemFull LIMIT 0,30" results in:

"Error
SQL-query:

select * from MemFull limit 0,30
MySQL said: "

(i.e., a really vague error message). Browsing is working for the other tables in that database and other databases, but the query is not. The query works fine from an SSH session using the 'mysql" client program. The phpMyAdmin software has not been altered in many months, and most DB connectivity still appears to work fine, so this isn't a time-critical problem, but I would like to know that the table isn't corrupted or anything like that.

Answer:

This is normal behavior, especially when working with interactive clients...

Basically, you have opened a connection to the MySQL server but have idled for too long in between sent queries.

The timeout is 300 seconds or 5 minutes.

When you go to send another query, it sees that the connection has been closed by the MySQL server and phpMyAdmin issues an error. Technically, phpMyAdmin should be more resilient than that and recover transparently. When you resend the query, it will reconnect to the MySQL server and proceed normally.

You may want to bring this issue up with the program's developers and seek resolve there.