Bug #47660 main.archive fails sporadically
Submitted: 27 Sep 2009 20:41
Reporter: Alexander Nozdrin Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Archive storage engine Severity:S3 (Non-critical)
Version:6.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: experimental, pb2, test failure
Triage: Triaged: D2 (Serious)

[27 Sep 2009 20:41] Alexander Nozdrin
Description:
CURRENT_TEST: main.archive
*** /export/tmp/pb2/test/sb_1-769026-1253951202.46/mysql-6.0.14-alpha-hpux11.31-ia64-test/mysql-test/r/archive.result Sat Sep 26 00:49:56 2009
--- /export/tmp/pb2/test/sb_1-769026-1253951202.46/mysql-6.0.14-alpha-hpux11.31-ia64-test/mysql-test/r/archive.reject	Sat Sep 26 11:19:47 2009
*************** *** 12708,12714 ****
  SELECT DATA_LENGTH, AVG_ROW_LENGTH FROM
  INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1' AND TABLE_SCHEMA='test';
  DATA_LENGTH	AVG_ROW_LENGTH
! 8700	4350
  DROP TABLE t1;
  SET @save_join_buffer_size= @@join_buffer_size;
  SET @@join_buffer_size= 8228;
--- 12708,12714 ----
  SELECT DATA_LENGTH, AVG_ROW_LENGTH FROM
  INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1' AND TABLE_SCHEMA='test';
  DATA_LENGTH	AVG_ROW_LENGTH
! 8701	4350
  DROP TABLE t1;
  SET @save_join_buffer_size= @@join_buffer_size;
  SET @@join_buffer_size= 8228;

mysqltest: Result content mismatch

 - saving '/export/tmp/pb2/test/sb_1-769026-1253951202.46/mysql-6.0.14-alpha-hpux11.31-ia64-test/mysql-test/var/log/main.archive/' to '/export/tmp/pb2/test/sb_1-769026-1253951202.46/mysql-6.0.14-alpha-hpux11.31-ia64-test/mysql-test/var/log/main.archive/'

Retrying test, attempt(2/3)...

main.archive                             [ retry-fail ]

How to repeat:
XRef: http://pb2.norway.sun.com/web.py?template=mysql_show_test_failure&test_failure_id=2341494&...
[27 Sep 2009 20:41] Alexander Nozdrin
The test case has been marked experimental due to this bug.