Hello Averyanov,

[EMAIL PROTECTED] wrote:
Hello Nuno,

Tuesday, July 26, 2005, 8:53:33 PM, you wrote:


[EMAIL PROTECTED] wrote:
(...)

When i try to execute the following query

(...)

i get this error:

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    6
Current database: test
ERROR 2013 (HY000): Lost connection to MySQL server during query


but if i change my query to this one everything is fine
SELECT COUNT(DISTINCT field1) as value1,
       CONCAT(field2, '') as value2
FROM table1,
       table2
GROUP BY value2

(here CONCAT(field2, '-') is replaced with CONCAT(field2, '') )

does anyone know what the matter is?


Did you try to make the first query for a second time, when you execute
the second query? It seems that the server abords or closes the connection meanwhile. Did you waited too long to write/send the query?

Each time i try to execute the 'buggy' query the server crashet.
It crashes IMMEDIATELY (without any human-perceptible timeout)

Can you provide the output of the logs?

Check this for more help
http://dev.mysql.com/doc/mysql/en/gone-away.html

Does following the steps in that page helps?

Try this query and output the result


SHOW VARIABLES LIKE '%time%';

mysql> SHOW VARIABLES LIKE '%time%';
+--------------------------+-------------------+
| Variable_name            | Value             |
+--------------------------+-------------------+
| connect_timeout          | 5                 |
| datetime_format          | %Y-%m-%d %H:%i:%s |
| delayed_insert_timeout   | 300               |
| flush_time               | 0                 |
| innodb_lock_wait_timeout | 50                |
| interactive_timeout      | 28800             |
| long_query_time          | 10                |
| net_read_timeout         | 30                |
| net_write_timeout        | 60                |
| slave_net_timeout        | 3600              |
| slow_launch_time         | 2                 |
| sync_replication_timeout | 0                 |
| system_time_zone         | MSD               |
| time_format              | %H:%i:%s          |
| time_zone                | SYSTEM            |
| wait_timeout             | 28800             |
+--------------------------+-------------------+
16 rows in set (0.00 sec)

The variables seems OK.

Next time reply TO THE LIST, others could help.

--
Nuno Pereira
email: [EMAIL PROTECTED]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to