spurious warnings about empty rbr buffer for update queries

Bug #994494 reported by Seppo Jaakola
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Fix Released
Low
Seppo Jaakola
5.5
Fix Released
Low
Seppo Jaakola

Bug Description

Error log shows warnings like:

120504 11:01:01 [Warning] WSREP: empty rbr buffer, query: UPDATE `instance`
SET `instance_name` = 'Nagios Cygnus' WHERE `instance_id` = '1' LIMIT 1,

These can be false positives, and due to case where update matches some rows, buit update is not effective. i.e. row before image == row after image

=> change the condition for the warning more strict to filter out such non-effective update cases

Related branches

Changed in codership-mysql:
importance: Undecided → Low
milestone: none → 5.5.23-23.6
Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :

Cannot reproduce this issue. Tested scenarios:

1. non effective update on table with PK
2. non effective update on table without PK
3. non effective transaction (set...reset)
4. voluntary transaction rollbacks
5. BF aborts (idle, exec, commit phases)

Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :

The application producing these is centreon 2.3.8. And problem has been diagnosed only with a private Solaris build.
I have not been able to reproduce this with Ubuntu build, at least so far.

Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :

bad diagnosis above, the problem happens with official 5.5.23-23.5 build.
Also Drupal (probably apache-solr module) used in master-slave mode generates such warnings

Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :

affected rows statistics cannot be trusted, demoted the warning to debug level and pushed in: http://bazaar.launchpad.net/~codership/codership-mysql/wsrep-5.5/revision/3756

Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :

ok, the plan is now to leave the message demoted to debug level for now, and design a comprehensive commit-time consistency assert in the future.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.