MySQL Bugs: #36116: Nondet. failures in rpl_slave

Bug #36116	Nondet. failures in rpl_slave_status test
Submitted:	16 Apr 2008 7:56	Modified:	28 Apr 2008 13:26
Reporter:	Rafal Somla	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Tests	Severity:	S3 (Non-critical)
Version:	6.0.5-alpha	OS:	Any
Assigned to:	Rafal Somla	CPU Architecture:	Any

Description:
Sometimes this test fails in PB with errors like

> +Last_SQL_Errno    1032
> +Last_SQL_Error    Could not execute Delete_rows event on table mysql.user; Can't find record in 'user', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log master-bin.000001, end_log_pos 890

This happens when executing "delete from mysql.user where user='rpl';" inside the test.

A probable cause of this problem is that a new user created by the test is kept in memory cache and not saved into mysql.uset table before the above statement is executed.

How to repeat:
Depends on timing and shows only from time to time on PB.

Suggested fix:
1. FLUSH PRIVILEGES
2. use DROP USER, not DELETE FROM mysql.user

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/45466

ChangeSet@1.2614, 2008-04-16 10:02:48+02:00, rafal@quant.(none) +2 -0
  BUG#36116 (Nondet. failures in rpl_slave_status test)
  
  Probable cause of the failures is missing FLUSH PRIVILEGES after creating a new user and directly
  manipulating mysql.user table instead of using DROP USER. The patch fixes these issues.

Pushed into 6.0.5-alpha

This is already pushed into the main tree.

Test case change. No changelog entry needed.