From: Thimble Smith
Date: February 22 2000 8:04am
Subject: Re: corrupt mysql/{db,user}.MYI after GRANT
List-Archive: http://lists.mysql.com/bugs/11
Message-Id: <20000222030443.A33412@threads.polyesthetic.msg>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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.