Lost connection to MySQL server during query

[Gustavo A. Baratto]

This old bug reappeared after the upgrading mysql from version 3.23.54a (rpm provided by mysql.com) to version 4.0.8-gamma (binary provided by mysql.com as well).

Using redhat 7.1 glibc 2.2.4-31 (which is supposed to fix this problem)
This server has glibc 2.2.4-31 installed for quite a while, and mysql 3.23.54a was working just fine with it.

Mysql 4.0.8 stopped crashing when I added --skip-name-resolve in the mysql startup... but some tables are getting corrupted very often, and I can't find a reason. It doesn't the tables are getting corrupted because of mysql is crashing, because bin-log index is not increasing, and there is nothing in the logs saying it was restarted.

This is one example of check table:
--------
alpgrafik_com_1.kent_session_info warning Not used space is supposed to be: 30612 but is: 30404
alpgrafik_com_1.kent_session_info error record delete-link-chain corrupted
alpgrafik_com_1.kent_session_info error Corrupt
-------

I searched for delete-link-chain on google but I didn't have much luck

Not all clients (eg, php) have been upgraded to version 4, but the mysql docs say there shouldn't be a problem if we are not using the new features.

Ideias?

--
--------------------------------------------------------------------------
Gustavo Baratto - Programming and Technical Support
[EMAIL PROTECTED] * (604) 638-2525 ext. 408

Technical support web-site: http://support.superb.net
Superb Internet Corp. "Ahead of the Rest"
-------------------------------------------------------------------------


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php