| 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: | |
| Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
| Version: | 5.1.6-alpha | OS: | Linux (Linux) |
| Assigned to: | Jon Stephens | CPU Architecture: | Any |
[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.
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.