Bug #18754 "xid" (transaction id ?) not stable across platforms: test fails
Submitted: 3 Apr 2006 19:20 Modified: 14 Sep 2006 20:04
Reporter: Joerg Bruehe Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.20 OS:Other (SCO OSR 6)
Assigned to: Lars Thalmann CPU Architecture:Any

[3 Apr 2006 19:20] Joerg Bruehe 
Description:
(Release ?) build of 5.0.20, based on ChangeSet
  1.2117 06/03/31 11:48:08 lars@mysql.com +1 -0
  BUG#18116: Changed of how mutex is handled for XA and rotating binlog

Bug is specific to SCO, but occurs reliably in all tests.

Bug starts thus:
-------------------------------------------------------
*** r/mix_innodb_myisam_binlog.result
--- r/mix_innodb_myisam_binlog.reject
***************
*** 101,107
  show binlog events from 98;
  Log_name      Pos     Event_type      Server_id       End_log_pos     Info
  master-bin.000001     98      Query   1       #       use `test`; insert into t1 values(9)
! master-bin.000001     185     Xid     1       #       COMMIT /* xid=60 */
  master-bin.000001     212     Query   1       #       use `test`; insert into t2 select * from t1
  delete from t1;
  delete from t2;
--- 101,107
  show binlog events from 98;
  Log_name      Pos     Event_type      Server_id       End_log_pos     Info
  master-bin.000001     98      Query   1       #       use `test`; insert into t1 values(9)
! master-bin.000001     185     Xid     1       #       COMMIT /* xid=118 */
  master-bin.000001     212     Query   1       #       use `test`; insert into t2 select * from t1
  delete from t1;
  delete from t2;
***************
...

As the "xid" values are modified using lines like
   --replace_result "xid=119" "xid=60"
in reality the values may be off by only one, but still ...

How to repeat:
Run the test on SCO.
[3 Apr 2006 19:22] Joerg Bruehe 
Forgot to mention an important fact:
Happens only in "--ps-protocol" run.
[14 Sep 2006 20:04] Lars Thalmann 
The XIDs can change depending on if one is using ps-protocol or not
and this is normal.