Hi there, I'm running MySQL-server-4.0.10-0.i386 on a Linux Box (SuSE 8.1) and all tables are MyISM. Today a made strange observation. All update statements on one table where completely "ignored" by the server. There was no error message - just a "0 rows affected". After restart of mysqld everyting worked fine and the privious statement was successful. Since I don't know how to reproduce this a more generall question. Does anybody know of bugs under 4.0.10-0 which prevent write access to MyISAM tables without affecting read access. Might it be that a lock on this table was stuck...
Always thankful for help in any way Jerg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]