Bug #43692 Maria: table corrupted after Recovery (pushbuild2)
Submitted: 17 Mar 2009 9:09 Modified: 26 May 2010 17:52
Reporter: Guilhem Bichot Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server: Maria storage engine Severity:S3 (Non-critical)
Version:6.0-maria OS:Any
Assigned to: CPU Architecture:Any

[17 Mar 2009 9:09] Guilhem Bichot 
Description:
After Recovery, the same SELECT executed with different access paths gives different results, and when I run CHECK TABLE EXTENDED it seems to be because the table is corrupted.

How to repeat:
see pushbuild2 URL for the log
[17 Mar 2009 12:37] Guilhem Bichot 
Here are 3 testcases. When running any of those, after kill-9 was issued and Recovery ran, tables were corrupted. Machines were Solaris10SPARC and Linux i686.

# 12:55:09 # runall.pl \ 
# 12:55:09 # --basedir=... \ 
# 12:55:09 # --mysqld=--loose-innodb-lock-wait-timeout=5 \ 
# 12:55:09 # --mysqld=--table-lock-wait-timeout=5 \ 
# 12:55:09 # --mysqld=--loose-falcon-lock-wait-timeout=5 \ 
# 12:55:09 # --mysqld=--loose-falcon-debug-mask=2 \ 
# 12:55:09 # --mysqld=--skip-safemalloc \ 
# 12:55:09 # --grammar=conf/maria_bulk_insert.yy \ 
# 12:55:09 # --reporters=Deadlock,ErrorLog,Backtrace,Recovery,WinPackage,Shutdown \ 
# 12:55:09 # --duration=1200 \ 
# 12:55:09 # --vardir=... \ 
# 12:55:09 # --mysqld=--log-output=file \ 
# 12:55:09 # --queries=100000 \ 
# 12:55:09 # --engine=maria

# 13:17:11 # runall.pl \ 
# 13:17:11 # --basedir=... \ 
# 13:17:11 # --mysqld=--loose-innodb-lock-wait-timeout=5 \ 
# 13:17:11 # --mysqld=--table-lock-wait-timeout=5 \ 
# 13:17:11 # --mysqld=--loose-falcon-lock-wait-timeout=5 \ 
# 13:17:11 # --mysqld=--loose-falcon-debug-mask=2 \ 
# 13:17:11 # --mysqld=--skip-safemalloc \ 
# 13:17:11 # --grammar=conf/many_indexes.yy \ 
# 13:17:11 # --gendata=conf/many_indexes.zz \ 
# 13:17:11 # --reporters=Deadlock,ErrorLog,Backtrace,Recovery,WinPackage,Shutdown \ 
# 13:17:11 # --duration=1200 \ 
# 13:17:11 # --vardir=... \ 
# 13:17:11 # --mysqld=--log-output=file \ 
# 13:17:11 # --queries=100000 \ 
# 13:17:11 # --engine=maria

# 14:17:12 # runall.pl \ 
# 14:17:12 # --basedir=... \ 
# 14:17:12 # --mysqld=--loose-innodb-lock-wait-timeout=5 \ 
# 14:17:12 # --mysqld=--table-lock-wait-timeout=5 \ 
# 14:17:12 # --mysqld=--loose-falcon-lock-wait-timeout=5 \ 
# 14:17:12 # --mysqld=--loose-falcon-debug-mask=2 \ 
# 14:17:12 # --mysqld=--skip-safemalloc \ 
# 14:17:12 # --gendata=conf/maria.zz \ 
# 14:17:12 # --grammar=conf/maria_mostly_selects.yy \ 
# 14:17:12 # --reporters=Deadlock,ErrorLog,Backtrace,Recovery,WinPackage,Shutdown \ 
# 14:17:12 # --duration=1200 \ 
# 14:17:12 # --vardir=... \ 
# 14:17:12 # --mysqld=--log-output=file \ 
# 14:17:12 # --queries=100000 \ 
# 14:17:12 # --engine=maria