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]
