Bug #18027 IM: Server_ID differs
Submitted: 7 Mar 2006 12:48 Modified: 31 Aug 2006 18:27
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:Instance Manager Severity:S3 (Non-critical)
Version:5.0.19 OS:Solaris (Solaris 9 (x86) + others)
Assigned to: Alexander Nozdrin CPU Architecture:Any

[7 Mar 2006 12:48] Joerg Bruehe
Description:
Release build of 5.0.19.
Not observed in previous releases, but already in a 5.0.19 test build on March 2
(but then only once on "cane", assuming all tests were run).

-------------------------------------------------------
*** r/im_options_unset.result
--- r/im_options_unset.reject
***************
*** 2,15
  server_id           =2
  SHOW VARIABLES LIKE 'server_id';
  Variable_name Value
! server_id     1
  UNSET mysqld1.server_id;
  server_id           =2
  SHOW VARIABLES LIKE 'server_id';
  Variable_name Value
! server_id     1
  UNSET mysqld2.server_id;
  FLUSH INSTANCES;
  SHOW VARIABLES LIKE 'server_id';
  Variable_name Value
! server_id     1
--- 2,15
  server_id           =2
  SHOW VARIABLES LIKE 'server_id';
  Variable_name Value
! server_id     11
  UNSET mysqld1.server_id;
  server_id           =2
  SHOW VARIABLES LIKE 'server_id';
  Variable_name Value
! server_id     11
  UNSET mysqld2.server_id;
  FLUSH INSTANCES;
  SHOW VARIABLES LIKE 'server_id';
  Variable_name Value
! server_id     11
-------------------------------------------------------

Occurred:
cane-5.0-debug.log   normal
cane-5.0-max.log   normal
sol9x86-5.0-pro-gpl.log   normal
sol9x86-5.0-standard.log   normal

How to repeat:
Test suite failure.
[12 Apr 2006 10:13] Alexander Barkov
See also:
http://bugs.mysql.com/bug.php?id=18982
[12 Apr 2006 14:20] Brian Pontz
Increasing priority as this affects 5.1.9-pre as per 
18982
[6 May 2006 10:41] Alexander Nozdrin
It seems the cause of the bug is the same as for BUG#14106.
[22 May 2006 12:32] Alexander Nozdrin
This bug is expected to be fixed by a patch for BUG#14106.
Please, re-verify it again.
[22 Jun 2006 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[24 Aug 2006 11:38] Joerg Bruehe
The fix for bug #14106 is included in 5.0.23, but:
This bug still occurs in that release (5.0.23) and in 5.0.24
(like in all releases since 5.0.19).
It is also still found in a test build of 5.0.25-prerelease on August 20, 2006.

Effect seems random, occurs on varying platforms and in few test runs only.
One of these had "server_id 0" (expected 1, in this bug 11).
With 5.0.25-pre, it was sol9x86, "normal" test, and hpita2-64bit, NDB test.
[29 Aug 2006 11:50] Alexander Nozdrin
A patch for this bug:
http://lists.mysql.com/commits/10998

See BUG#21331 for more info.
[31 Aug 2006 9:55] Alexander Nozdrin
Merged into 5.0 tree, currently tagged 5.0.25;
merged into 5.1 tree, currently tagged 5.1.12-beta.
[31 Aug 2006 18:27] Paul DuBois
Test suite change. No changelog entry needed.