averyanov@stripped 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?
Check this for more help http://dev.mysql.com/doc/mysql/en/gone-away.html
Try this query and output the result
SHOW VARIABLES LIKE '%time%';
if you don't find a solution.
--
Nuno Pereira
email: nuno.pereira@stripped
