Bug #16680 Cluster RBR: Injector thread unaware of SET SQL_LOG_BIN = {0|1}
Submitted: 20 Jan 2006 18:06 Modified: 16 Mar 2006 19:48
Reporter: Jonathan Miller Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.1.6-alpha OS:Linux (Linux)
Assigned to: Jon Stephens CPU Architecture:Any
Triage: D4 (Minor)

[20 Jan 2006 18:06] Jonathan Miller
Description:
SET SQL_LOG_BIN = {0|1}

Disables or enables binary logging for the current connection (SQL_LOG_BIN is a session variable) if the client connects using an account that has the SUPER privilege. A statement is refused with an error if the client does not have that privilege. 

test rpl000009.test fails due to the bin log being updated by the injector thread when the test think that the bin log logging has been disabled.

rpl000009                      [ fail ]

Errors are (from /home/ndbdev/jmiller/clones/mysql-5.1-new/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 65: could not sync with master ('select master_pos_wait('master-bin.000001', 2547)' returned NULL)
(the last lines may be the most important ones)

How to repeat:
./mysql-test-run --do-test=rpl000009 --with-ndbcluster-all --mysqld=--default-storage-engine=ndb

Suggested fix:
injector thread should check to see if bin log has been disabled for current thread.
[26 Jan 2006 8:58] Tomas Ulin
please document this is as a limitation of cluster
[16 Mar 2006 19:48] Jon Stephens
Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant
product(s).

Additional info:

Updated Cluster Limitations section of 5.1 Manual per note from Tomas. Changed category from Cluster to Docs. Closed.