[Fwd: Re: Malformed packet]

--------------000203080101050801070107
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


Nothing... same error,... same problem... my old solution too in the new
4.1.12 fail and the error come until i restart the service....

MySQL error, 'Malformed packet, SELECT * FROM swx_databank_text WHERE
tid>0 ORDER BY title ASC Lost connection to MySQL server during query,
DELETE FROM swx_sessions WHERE run_time<1116311415 '



-------- Original Message --------
Subject: Re: Malformed packet
Date: Wed, 18 May 2005 10:34:59 +0200
From: Achilleterzo
To: MySQL Win32 List
References: <42899F76.8080503@g32.it>
<342e10905051707362747ef97@mail.gmail.com>



Thanks a lot!
I have installed the last 4.1.12 for solve out possible bugs but i find
finilly a solution (bit slow).
In the disconnect section of my mysql class i have put a optional last
query before closing connection:

$Sql->Close("FLUSH QUERY CACHE");

with flush the problem is worked out but the total execution time become
a bit slow.
Now I want to try to a normal close for verify if it work correctly.

Thanks again.
Achilleterzo

Daniel da Veiga wrote:

>I had the same error here bud, just let me tell you that I tried
>EVERYTHING, upgrade to 4.1.11!!! It seems there is a bug related to
>some operators used together, couldn't find the exact change at the
>logs, but its related to ORDER BY and LIMIT. After the upgrade, the
>errors where gone.
>
>Good luck,
>
>On 5/17/05, Achilleterzo wrote:
>
>
>>Hi all,
>>i have a problem with MySql 4.1.10 like:
>>
>>MySQL error, 'Malformed packet, SELECT * FROM swx_databank_text WHERE
>>tid>0 ORDER BY title ASC Lost connection to MySQL server during query,
>>DELETE FROM swx_sessions WHERE run_time<1116311415 '
>>
>>I have read a lot of post on the net, changed the max_allowed_packet up
>>to 128MB / 256MB (now), tuned up the server into a dedicate server with
>>1GB of ram and 3.2Ghz cpu but nothing.... still the same problem.
>>
>>Anyone know how to solve it out?
>>
>>Achilleterzo
>>
>>
>>
>>
>
>
>
>

--------------000203080101050801070107--