ERROR 2006:MySQL server has gone away

Hi,

I have a table with the following description:
mysql> describe xoops_groups_modules_link;
+---------+---------+------+-----+---------+-------+
| Field   | Type    | Null | Key | Default | Extra |
+---------+---------+------+-----+---------+-------+
| groupid | int(5)  |      | MUL | 0       |       |
| mid     | int(5)  |      |             | 0       |       |
| type    | char(1) |      |             |         |       |
+---------+---------+------+-----+---------+-------+
with the folloing contents in it:
mysql> select * from xoops_groups_modules_link;
+---------+-----+------+
| groupid | mid | type |
+---------+-----+------+
|       1     |   1 | A    |
|       1     |   2 | A    |
|       1     |   1 | R    |
|       1     |   2 | R    |
|       2     |   1 | R    |
|       2     |   2 | R    |
|       3     |   1 | R    |
|       3     |   2 | R    |
+---------+-----+------+
Now, when i run the following query:
mysql> select * from xoops_groups_modules_link where type='R' and mid=2 and
groupid=3 ;
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    1
Current database: xoops

ERROR 2013: Lost connection to MySQL server during query

I cant find out why its happening so!!
Can someone plz help me.

Infact this table is dumped from a dump. If i create a same table by myself
and then run the same query it executes fine. Isn't that strange!!

thanx
anil



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread113341@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail 
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php