Malformed packet

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

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

--------------040805080306040107000304--

Re: Malformed packet

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:
>=20
> 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 '
>=20
> 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.
>=20
> Anyone know how to solve it out?
>=20
> Achilleterzo
>=20
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Malformed packet

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

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
>>
>>
>>
>>
>
>
>
>

--------------030404080507090401000008--