Hi! On Dec 29, Derek J wrote: > Hello, > First, Yes I can create repeatable test case, I still have live > server with the same problem. and another Dual opteron server, which i > created the same database there as a test to make sure there are no > hardware faliures casuing this probles, but i still had the same problem > there too. I can give full access to any of MySQL team to check this > problem. I had aleaddy 2 DBA's fail to Identify the problem in there. > > mysql> show table status like 'keywordlog'; > > +---------------------+---------------------+----------------+---------+ > | Name | Type | Row_format | Rows | Avg_row_length | Data_length > | Max_data_length | Index_length | Data_free | Auto_increment | > Create_time | Update_time | Check_time | Create_options > | Comment | > +------------+--------+------------+------+----------------+----------- > | keywordlog | MyISAM | Fixed | 518 | 267 | 138306 > | 1146756268031 | 77824 | 0 | NULL | > 2003-12-27 19:21:28 | 2003-12-28 02:40:00 | 2003-12-27 21:40:36
Great, table is 138306 bytes only - relatively small, that is. Then, the fastest way to get this fixed is to create a bugreport at http://bugs.mysql.com (just copy-paste your first mail and information from the your last reply) and to attach a (compressed) table dump to a bugreport using [Files] tab (mark it "private" if you want it to be visible to MySQL AB staff only). As far as I understand, the table in the dump should be created without indexes (this is your point, isn't it?), and if one adds to the end of the dump "ALTER TABLE keywordlog ADD INDEX ...; INSERT keywordlog ..." then "mysql < keywordlog.dump" will hang. Did I understand you correctly ? Then, as I advised above, just create a bugreport and attach a dump (that ends with "ALTER TABLE ... ; INSERT ...") to it - with a repeatable test case the bug will be fixed very quickly. No need to waste the time sending emails back and forth and speculating, when your test case is small enough :) Regards, Sergei -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
