MySQL folks,

I've got an index corruption bug that's been confirmed on multiple operating systems (Linux 2.2.16, FreeBSD 3.4) with multiple versions my MySQL. I've built 3.23.24 from source on FreeBSD and tried the Linux binary distribution for 3.23.22 (which we're running in production) on Linux 2.2.16.

The files required to reproduce it are on ftp://support.mysql.com/pub/mysql/secret/

LinkLog.sql.bz2 LinkLog.readme

LinkLog.readme is simply a copy of this message.

The bug is this:

(1) Run `mysql < LinkLog.sql' to crate and fill the LinkLog table.

(2) Run `CHECK TABLE LinkLog' to make sure it's okay. It probably won't be. I get errors like this:

mysql> check table LinkLog; +--------------+-------+----------+----------------------------------------+ | Table | Op | Msg_type | Msg_text | +--------------+-------+----------+----------------------------------------+ | LinkLog | check | error | Key in wrong position at page 70865920 | | test.LinkLog | check | status | Corrupt | +--------------+-------+----------+----------------------------------------+

(3) Run `REPAIR TABLE LinkLog'. It will repair okay.

(4) Run this query: delete from LinkLog where Time < 20000911162908;

The query will run for a while and bomb with an error message about a corrupt index like this:

ERROR 1034: Incorrect key file for table: 'LinkLog'. Try to repair it

(5) Repair the table and start over at step #4.

Please let me know if you cannot reproduce the bug.

Here is the output of SHOW VARIABLES on the FreeBSD 3.4 and MySQL 3.23.24 setup:

---snip---

+-------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value
| +-------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------+ | ansi_mode | OFF
| | back_log | 50
| | basedir | /home/mysql/
| | character_set | latin1
| | character_sets | latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7
cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250
croat cp1257 | | connect_timeout | 5
| | concurrent_insert | ON
| | datadir | /home/mysql/var/
| | delay_key_write | ON
| | delayed_insert_limit | 100
| | delayed_insert_timeout | 300
| | delayed_queue_size | 1000
| | join_buffer_size | 33550336
| | flush | OFF
| | flush_time | 0
| | init_file |
| | interactive_timeout | 28800
| | key_buffer_size | 33550336
| | language | /home/mysql/share/mysql/english/
| | log | OFF
| | log_update | OFF
| | log_bin | ON
| | log_slave_updates | OFF
| | long_query_time | 10
| | low_priority_updates | OFF
| | lower_case_table_names | 0
| | max_allowed_packet | 1048576
| | max_connections | 100
| | max_connect_errors | 10
| | max_delayed_threads | 20
| | max_heap_table_size | 16777216
| | max_join_size | 4294967295
| | max_sort_length | 1024
| | max_tmp_tables | 32
| | max_write_lock_count | 4294967295
| | myisam_sort_buffer_size | 8388608
| | net_buffer_length | 16384
| | net_retry_count | 1000000
| | pid_file | /home/mysql/var/museful.yahoo.com.pid
| | port | 3306
| | protocol_version | 10
| | record_buffer | 16773120
| | skip_locking | OFF
| | skip_networking | OFF
| | skip_show_database | OFF
| | slow_launch_time | 2
| | socket | /tmp/mysql.sock
| | sort_buffer | 8388600
| | table_cache | 64
| | table_type | MYISAM
| | thread_stack | 65536
| | thread_cache_size | 0
| | timezone | PDT
| | tmp_table_size | 25165816
| | tmpdir | /var/tmp/
| | version | 3.23.24-beta-log
| | wait_timeout | 28800
| +-------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------+

---snip---

Jeremy