Bug #58171 server_uuid_embedded fails sporadically
Submitted: 13 Nov 2010 7:03 Modified: 7 Dec 2010 12:57
Reporter: Alexander Nozdrin Email Updates:
Status: Closed Impact on me:
None 
Category:Tools: MTR / mysql-test-run Severity:S3 (Non-critical)
Version:5.6 (Dahlia, Erica) OS:Any
Assigned to: Bjørn Munch CPU Architecture:Any
Tags: experimental, pb2, sporadic, test failure

[13 Nov 2010 7:03] Alexander Nozdrin
Description:
main.server_uuid_embedded [ fail ]
        Test ended at 2010-11-12 16:10:58

CURRENT_TEST: main.server_uuid_embedded
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
101112 16:10:56  InnoDB: Initializing buffer pool, size = 8.0M
101112 16:10:56  InnoDB: Completed initialization of buffer pool
101112 16:10:56  InnoDB: highest supported file format is Barracuda.
'diff' is not recognized as an internal or external command,
operable program or batch file.
--- H:/pb2/test/sb_2-2520173-1289569354.31/mysql-5.6.99-m5-win-x86-test/mysql-test/r/server_uuid_embedded.result	2010-11-12 15:33:02.000000000 +0300
+++ H:\pb2\test\sb_2-2520173-1289569354.31\mysql-5.6.99-m5-win-x86-test\mysql-test\r\server_uuid_embedded.reject	2010-11-12 18:10:57.017426500 +0300
@@ -8,3 +8,4 @@
 # Case 2:
 # SERVER_UUID is not null
 -----------------------------------------------------------------------------
+server's UUID is null

mysqltest: Result length mismatch

 - saving 'H:/pb2/test/sb_2-2520173-1289569354.31/mysql-5.6.99-m5-win-x86-test/mysql-test/var-emebbed/log/main.server_uuid_embedded/' to 'H:/pb2/test/sb_2-2520173-1289569354.31/mysql-5.6.99-m5-win-x86-test/mysql-test/var-emebbed/log/main.server_uuid_embedded/'

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

main.server_uuid_embedded                [ retry-fail ]
        Test ended at 2010-11-12 16:11:00

CURRENT_TEST: main.server_uuid_embedded
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
101112 16:10:59  InnoDB: Initializing buffer pool, size = 8.0M
101112 16:10:59  InnoDB: Completed initialization of buffer pool
101112 16:10:59  InnoDB: highest supported file format is Barracuda.
'diff' is not recognized as an internal or external command,
operable program or batch file.
--- H:/pb2/test/sb_2-2520173-1289569354.31/mysql-5.6.99-m5-win-x86-test/mysql-test/r/server_uuid_embedded.result	2010-11-12 15:33:02.000000000 +0300
+++ H:\pb2\test\sb_2-2520173-1289569354.31\mysql-5.6.99-m5-win-x86-test\mysql-test\r\server_uuid_embedded.reject	2010-11-12 18:10:59.245649300 +0300
@@ -8,3 +8,4 @@
 # Case 2:
 # SERVER_UUID is not null
 -----------------------------------------------------------------------------
+server's UUID is null

mysqltest: Result length mismatch

How to repeat:
XRef: http://pb2.norway.sun.com/?template=mysql_show_test_failure&test_failure_id=&test_output_i...
[13 Nov 2010 7:04] Alexander Nozdrin
The test case has been made experimental due to this bug.
[24 Nov 2010 13:38] Bjørn Munch
I've committed my fix twice but the bug hasn't got updated. here's the patch:

=== modified file 'mysql-test/t/server_uuid_embedded.test'
--- mysql-test/t/server_uuid_embedded.test      2010-10-21 12:36:16 +0000
+++ mysql-test/t/server_uuid_embedded.test      2010-11-24 12:18:50 +0000
@@ -25,7 +25,8 @@
 --echo # SERVER_UUID is not null
 --echo -----------------------------------------------------------------------------
 --let $server_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
-if (!$server_uuid)
+# Cannot use !$server_uuid since it may begin with 0
+if ($server_uuid == '')
 {
   --echo server's UUID is null
 }
[24 Nov 2010 17:16] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/124874

2990 Bjorn Munch	2010-11-24
      Bug #58171 server_uuid_embedded fails sporadically
      Fixed if condition to explicitly test for empty string as it used to
[24 Nov 2010 17:16] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/124858

2990 Bjorn Munch	2010-11-24
      Bug #58171 server_uuid_embedded fails sporadically
      Fixed if condition to explicitly test for empty string as it used to
[24 Nov 2010 20:42] Bjørn Munch
Pushed to trunk-mtr.
[5 Dec 2010 12:40] Bugs System
Pushed into mysql-trunk 5.6.1 (revid:alexander.nozdrin@oracle.com-20101205122447-6x94l4fmslpbttxj) (version source revid:alexander.nozdrin@oracle.com-20101205122447-6x94l4fmslpbttxj) (merge vers: 5.6.1) (pib:23)
[7 Dec 2010 12:57] Paul DuBois
Changes to test suite. No changelog entry needed.