MySQL Drops Connection After Consecutive Queries

Question

Anyone have any idea why this is happening? It started happening after I implemented mysql_multi to run multiple instances of the MySQL service (one on port 3306, one on port 3307). I'm running MySQL on Ubuntu server.

Here's what happens:

Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
Operation failed: Can't connect to MySQL server on '192.168.1.40' (10061)
Fetching table list.
Operation failed: Can't connect to MySQL server on '192.168.1.40' (10061)
Fetching table list.
Operation failed: Can't connect to MySQL server on '192.168.1.40' (10061)
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query

Answer 1

I believe that you had set the timeout to low on my.cnf