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:
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:6.0.5-alpha OS:Any
Assigned to: Rafal Somla CPU Architecture:Any

[16 Apr 2008 7:56] Rafal Somla
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:
2. use DROP USER, not DELETE FROM mysql.user
[16 Apr 2008 8:04] 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:


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.
[16 Apr 2008 18:06] Bugs System
Pushed into 6.0.5-alpha
[28 Apr 2008 8:56] Rafal Somla
This is already pushed into the main tree.
[28 Apr 2008 13:26] Paul DuBois
Test case change. No changelog entry needed.