Bug #47646 rpl.rpl_innodb_bug30888 fails sporadically on Solaris

• Submitted: 25 Sep 2009 9:35
• Modified: 4 Nov 2010 3:24
• Reporter: Alexander Nozdrin
• Status: Can't repeat
• Category: Tests: Replication
• Severity: S3 (Non-critical)
• Version: 5.1
• OS: Solaris
• Assigned to: Libing Song
• CPU Architecture: Any
• Tags: experimental, pb2, sporadic, test failure

[25 Sep 2009 9:35] Alexander Nozdrin

Description:
rpl.rpl_innodb_bug30888 fails sporadically on Solaris.

Symptoms:
--------------------------------------------
rpl.rpl_innodb_bug30888 w6 [ fail ] timeout after 900 seconds
        Test ended at 2009-09-24 18:18:40

Test case timeout after 900 seconds

== /export/home/pb2/test/sb_6-765532-1253799900.54/mysql-5.4.5-beta-solaris10-i386-test/mysql-test/var-ps_row/6/log/rpl_innodb_bug30888.log == 
BEGIN
DECLARE ins_count INT DEFAULT 1000; 
DECLARE del_count INT;
DECLARE cur_user VARCHAR(255);
DECLARE local_uuid VARCHAR(255);
DECLARE local_time TIMESTAMP;
SET local_time= NOW();
SET cur_user= CURRENT_USER();
SET local_uuid= UUID();
WHILE ins_count > 0 DO
INSERT INTO test.regular_tbl VALUES (NULL, NOW(), USER() , UUID(),
ins_count,'Going to test MBR for MySQL');
SET ins_count = ins_count - 1;
END WHILE;
SELECT MAX(id) FROM test.regular_tbl INTO del_count;
WHILE del_count > 0 DO
DELETE FROM test.regular_tbl WHERE id = del_count;
SET del_count = del_count - 2;
END WHILE;
END|
--------------------------------------------

An extract from the log is attached.

A test case is marked experimental starting from mysql-trunk.

How to repeat:
5.1 failures:

http://pb2.norway.sun.com/web.py?template=mysql_show_test_failure&test_failure_id=2337599&...

Failures in all trees:

http://pb2.norway.sun.com/web.py?template=mysql_show_test_failure&test_failure_id=2337599&...

[25 Sep 2009 9:39] Alexander Nozdrin

Log

Attachment: bug47646.log (text/x-log), 32.38 KiB.

[29 Sep 2009 23:39] Omer Barnir

triage: setting tag to SR51TEST

[28 Jan 2010 11:56] Libing Song

Only happened seventh Oct. 2009 ago.
It probably had be solved before that time.

[29 Jan 2010 7:19] Libing Song

http://pb2.norway.sun.com/web.py?template=mysql_show_test_failure&test_failure_id=2337599&...;...
Can't repeated after 7th Oct. 2009

Failures in all trees:

http://pb2.norway.sun.com/web.py?template=mysql_show_test_failure&test_failure_id=2337599&...;...
The problem will be fixed by the patch for bug#50414

[10 Feb 2010 10:39] Luis Soares

The test case is still listed in default.experimental in mysql-trunk
(revid:[e-mail]-20100209101036-copgamva3qvs4cc8)

"rpl.rpl_innodb_bug30888* @solaris        # Bug#47646 2009-09-25 alik rpl.rpl_innodb_bug30888 fails sporadically on Solaris"

Please fix this.

[15 Jun 2010 8:29] Bugs System

Pushed into mysql-next-mr (revid:[e-mail]-20100615080558-cw01bzdqr1bdmmec) (version source revid:[e-mail]-20100415070122-1nxji8ym4mao13ao) (pib:16)

[4 Aug 2010 8:06] Bugs System

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804080001-bny5271e65xo34ig) (version source revid:[e-mail]-20100415070122-1nxji8ym4mao13ao) (merge vers: 5.1.47) (pib:18)

[4 Aug 2010 8:13] Bugs System

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804080001-bny5271e65xo34ig) (version source revid:[e-mail]-20100415070122-1nxji8ym4mao13ao) (merge vers: 5.1.47) (pib:18)

[4 Aug 2010 8:14] Bugs System

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804080001-bny5271e65xo34ig) (version source revid:[e-mail]-20100415070122-1nxji8ym4mao13ao) (merge vers: 5.1.47) (pib:18)

[4 Aug 2010 8:15] Bugs System

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804080001-bny5271e65xo34ig) (version source revid:[e-mail]-20100415070122-1nxji8ym4mao13ao) (merge vers: 5.1.47) (pib:18)

[4 Aug 2010 8:16] Bugs System

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804080001-bny5271e65xo34ig) (version source revid:[e-mail]-20100415070122-1nxji8ym4mao13ao) (merge vers: 5.1.47) (pib:18)

[4 Aug 2010 8:17] Bugs System

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804080001-bny5271e65xo34ig) (version source revid:[e-mail]-20100415070122-1nxji8ym4mao13ao) (merge vers: 5.1.47) (pib:18)

[4 Aug 2010 8:22] Bugs System

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804081533-c1d3rbipo9e8rt1s) (version source revid:[e-mail]-20100415070122-1nxji8ym4mao13ao) (merge vers: 5.1.47) (pib:18)

[4 Aug 2010 9:00] Bugs System

Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804081533-c1d3rbipo9e8rt1s) (version source revid:[e-mail]-20100415070122-1nxji8ym4mao13ao) (merge vers: 5.1.47) (pib:20)

[18 Oct 2010 10:33] Sven Sandberg

rpl.rpl_innodb_bug30888 was marked experimental because of this bug. Please re-enable the test before closing this bug.