mysqltest returned unexpected code 15872, it has probably crashed

MySQL Linux

MySQL4.1.14をソースからビルド/インストールで上手くいかなかった。

[現象]
make test でエラー

[mysql@myhost mysql-4.1.14]$ make test
cd mysql-test; perl mysql-test-run.pl && perl mysql-test-run.pl --ps-protocol
No ndbcluster support
Killing Possible Leftover Processes
Removing Stale Files
Installing Master Databases
Installing Master Databases
Installing Slave Databases
Installing Slave Databases
Installing Slave Databases
=======================================================
Finding  Tests in the 'main' suite
Starting Tests in the 'main' suite

TEST                            RESULT
-------------------------------------------------------

alias                           [ pass ]   
alter_table                     [ pass ]   
analyse                         [ pass ]   
analyze                         [ pass ]   
ansi                            [ pass ]   
archive                         [ fail ]
Errors are (from /var/src/mysql-4.1.14/mysql-test/var/log/mysqltest-time) :
This test is not supported by this installation
mysqltest returned unexpected code 15872, it has probably crashed
(the last lines may be the most important ones)


Aborting: archive failed. To continue, re-run with '--force'.
Ending Tests
Shutting-down MySQL daemon


Master(s) shutdown finished
Slave(s) shutdown finished
make: *** [test] エラー 1


[原因]
新しいストレージエンジンであるarchiveが、デフォルトだとDisableなため
検索したら出てきた掲示板の投稿
MySQL :: Developer Zone


[対策]
１．--force で強制的にテストを進める
$ cd mysql-version/mysql-test
$ ./mysql-test-run --force


２．configure時に、--with-archive-storage-engine を追加する
"--with-archive-storage-engine" を追加しても、他にも同じ原因で"make test"が失敗する。


３．"make test"しない
make install して、動かないなら１．を実施する。


[./mysql-test-run --force エラー内容]
mysql-test が予期している結果と異なるため出力されるそう。
問題の箇所はスレーブのステイタスについて。
スレーブを利用しない場合は無視してもよさそうだが、バグかもしれないとのことなのでうーん。
http://dev.mysql.com/doc/refman/4.1/ja/reporting-mysqltest-bugs.html


./mysql-test-run --force でエラー

Errors are (from /var/src/mysql-4.1.14/mysql-test/var/log/mysqltest-time) :
/var/src/mysql-4.1.14/client/.libs/lt-mysqltest: At line 31: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/rpl_slave_status.result   Wed Aug 17 20:16:59 2005
--- r/rpl_slave_status.reject   Wed Oct 19 09:04:57 2005
***************
*** 19,25 ****
  stop slave;
  start slave;
  show slave status;
! Slave_IO_State        Connecting to master
  Master_Host   127.0.0.1
  Master_User   rpl
  Master_Port   MASTER_MYPORT
--- 19,25 ----
  stop slave;
  start slave;
  show slave status;
! Slave_IO_State        Waiting for master update
  Master_Host   127.0.0.1
  Master_User   rpl
  Master_Port   MASTER_MYPORT
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.


結局RPMを使うことにしました。
http://download.softagency.net/MySQL/downloads/mysql/4.1.html