I just ran the test again with debugging on:
tim@threads:~$ mysql -e 'show tables from foobar';
tim@threads:~$ mysql -e 'select user, host from user; select user, host, db from db' mysql
+------+-----------+
| user | host |
+------+-----------+
| root | localhost |
| tim | localhost |
+------+-----------+
+------+------+---------+
| user | host | db |
+------+------+---------+
| | % | test |
| | % | test\_% |
+------+------+---------+
tim@threads:~$ mysqladmin shutdown
tim@threads:~$ mysqld daemon ended
[ Right here I ran myisamchk -s mysql/*.MYI; there were no errors. ]
tim@threads:~$ (sudo safe_mysqld --debug &)
tim@threads:~$ Starting mysqld daemon with databases from /var/db/mysql
tim@threads:~$ mysql < corrupt.sql
user host
root localhost
tim localhost
user host db
% test
% test\\_%
user host
root localhost
tim localhost
user1 localhost
user host db
% test
% test\\_%
user1 localhost foobar
tim@threads:~$ mysqladmin shutdown
tim@threads:~$ mysqld daemon ended
[ Right here, if I run myisamchk -s mysql/*.MYI; I get:
myisamchk: ISAM file mysql/db.MYI
myisamchk: error: record delete-link-chain corrupted
myisamchk: error: Found 3 keys of 2
MyISAM-table 'mysql/db.MYI' is corrupted
Fix it using switch "-r" or "-o"
myisamchk: ISAM file mysql/user.MYI
myisamchk: error: record delete-link-chain corrupted
myisamchk: error: Found 3 keys of 2
MyISAM-table 'mysql/user.MYI' is corrupted
Fix it using switch "-r" or "-o"
]
The debugging output is at:
http://www.hcisp.net/~tim/mysqld.trace
(It's about a 200K file.)
I still don't know what is causing this problem.
Tim
--
Tim Smith < tim@stripped > :MySQL Development Team: Boone, NC USA.
