- 09 Jul, 2006 7 commits
-
-
guilhem@gbichot3.local authored
into gbichot3.local:/home/mysql_src/mysql-5.1
-
guilhem@gbichot3.local authored
-
guilhem@gbichot3.local authored
-
guilhem@gbichot3.local authored
into gbichot3.local:/home/mysql_src/mysql-5.1
-
guilhem@gbichot3.local authored
were copied/split between 5.0 and 5.1).
-
guilhem@gbichot3.local authored
into gbichot3.local:/home/mysql_src/mysql-5.1
-
guilhem@gbichot3.local authored
1) Fix for BUG#19630 "stored function inserting into two auto_increment breaks statement-based binlog": a stored function inserting into two such tables may fail to replicate (inserting wrong data in the slave's copy of the second table) if the slave's second table had an internal auto_increment counter different from master's. Because the auto_increment value autogenerated by master for the 2nd table does not go into binlog, only the first does, so the slave lacks information. To fix this, if running in mixed binlogging mode, if the stored function or trigger plans to update two different tables both having auto_increment columns, we switch to row-based for the whole function. We don't have a simple solution for statement-based binlogging mode, there the bug remains and will be documented as a known problem. Re-enabling rpl_switch_stm_row_mixed. 2) Fix for BUG#20630 "Mixed binlogging mode does not work with stored functions, triggers, views", which was a documented limitation (in mixed mode, we didn't detect that a stored function's execution needed row-based binlogging (due to some UUID() call for example); same for triggers, same for views (a view created from a SELECT UUID(), and doing INSERT INTO sometable SELECT theview; would not replicate row-based). This is implemented by, after parsing a routine's body, remembering in sp_head that this routine needs row-based binlogging. Then when this routine is used, the caller is marked to require row-based binlogging too. Same for views: when we parse a view and detect that its SELECT needs row-based binary logging, we mark the calling LEX as such. 3) Fix for BUG#20499 "mixed mode with temporary table breaks binlog": a temporary table containing e.g. UUID has its changes not binlogged, so any query updating a permanent table with data from the temporary table will run wrongly on slave. Solution: in mixed mode we don't switch back from row-based to statement-based when there exists temporary tables. 4) Attempt to test mysqlbinlog on a binlog generated by mysqlbinlog; impossible due to BUG#11312 and BUG#20329, but test is in place for when they are fixed.
-
- 08 Jul, 2006 1 commit
-
-
mats@romeo.(none) authored
Fixing typo and potential memory problem. Reducing number of concurrent mysqlslap threads since tests fail in pushbuild due to too many threads.
-
- 07 Jul, 2006 10 commits
-
-
mats@romeo.(none) authored
-
mats@romeo.(none) authored
-
mats@romeo.(none) authored
Previous patch didn't work: moving variable settings inside critical region.
-
mats@romeo.(none) authored
into romeo.(none):/home/bk/b20821-mysql-5.1-new-rpl
-
mats@romeo.(none) authored
in pushbuild on Replication/Backup team tree.
-
mats@romeo.(none) authored
into romeo.(none):/home/bkroot/mysql-5.1-new-rpl
-
grog@eucla.lemis.com authored
into eucla.lemis.com:/home/MySQL/5.1-Bug-20850
-
grog@eucla.lemis.com authored
BUG#20850: Assert during slave shutdown in many rpl_* tests. This was caused by a race condition at the end of handle_slave_io which under some circumstances allowed the cleanup to proceed before the thread had completed.
-
grog@eucla.lemis.com authored
Tidy up white space.
-
mats@romeo.(none) authored
-
- 06 Jul, 2006 8 commits
-
-
guilhem@gbichot3.local authored
statement-based" (bugfix was committed today): we verify that now it works in mixed mode. And a comment.
-
guilhem@gbichot3.local authored
mysql_client_test like mysql-test-run". Nothing to document.
-
guilhem@gbichot3.local authored
into gbichot3.local:/home/mysql_src/mysql-5.1-new-WL3146-handler
-
guilhem@gbichot3.local authored
The bug was that if the server was running in mixed binlogging mode, and an INSERT DELAYED used some needing-row-based components like UUID(), the server didn't binlog this row-based but statement-based, which thus failed to insert correct data on the slave. This changeset implements that when a delayed_insert thread is created, if the server's global binlog mode is "mixed", that thread will use row-based. This also fixes BUG#20633 "INSERT DELAYED RAND() or @user_var does not replicate statement-based": we don't fix it in statement-based mode (would require bookeeping of rand seeds and user variables used by each row), but at least it will now work in mixed mode (as row-based will be used). We re-enable rpl_switch_stm_row_mixed.test (so BUG#18590 which was about re-enabling this test, will be closed) to test the fixes. Between when it was disabled and now, some good changes to row-based binlogging (no generation of table map events for non-changed tables) induce changes in the test's result file.
-
guilhem@gbichot3.local authored
by default we never run disabled tests (even if they're explicitely listed on the command-line). We add an option --enable-disabled which will run tests even though they are disabled, and will print, for each such test, the comment explaining why it was disabled. The reason for the change is when you want to run "all tests which are about NDB" for example: mysql-test-run.pl t/*ndb*.test used to run some disabled NDB tests, causing failures, causing investigations. Code amended and approved by Kent.
-
guilhem@gbichot3.local authored
into gbichot3.local:/home/mysql_src/mysql-5.0
-
guilhem@gbichot3.local authored
into gbichot3.local:/home/mysql_src/mysql-5.0
-
guilhem@mysql.com authored
a too large value": the bug was that if MySQL generated a value for an auto_increment column, based on auto_increment_* variables, and this value was bigger than the column's max possible value, then that max possible value was inserted (after issuing a warning). But this didn't honour auto_increment_* variables (and so could cause conflicts in a master-master replication where one master is supposed to generated only even numbers, and the other only odd numbers), so now we "round down" this max possible value to honour auto_increment_* variables, before inserting it.
-
- 05 Jul, 2006 4 commits
-
-
mats@mysql.com authored
-
mats@romeo.(none) authored
into mysql.com:/home/bk/b20821-mysql-5.1-new-rpl
-
mats@mysql.com authored
Reverting to old behaviour of writing the query before all rows have been written.
-
guilhem@mysql.com authored
auto_increment breaks binlog": if slave's table had a higher auto_increment counter than master's (even though all rows of the two tables were identical), then in some cases, REPLACE and INSERT ON DUPLICATE KEY UPDATE failed to replicate statement-based (it inserted different values on slave from on master). write_record() contained a "thd->next_insert_id=0" to force an adjustment of thd->next_insert_id after the update or replacement. But it is this assigment introduced indeterminism of the statement on the slave, thus the bug. For ON DUPLICATE, we replace that assignment by a call to handler::adjust_next_insert_id_after_explicit_value() which is deterministic (does not depend on slave table's autoinc counter). For REPLACE, this assignment can simply be removed (as REPLACE can't insert a number larger than thd->next_insert_id). We also move a too early restore_auto_increment() down to when we really know that we can restore the value.
-
- 03 Jul, 2006 5 commits
-
-
lars@mysql.com authored
into mysql.com:/users/lthalmann/bkroot/mysql-5.0-rpl
-
aivanov@mysql.com authored
Disabling 'rpl_openssl'.
-
aivanov@mysql.com authored
Enabling rpl_openssl.test for Windows to check that currently it still hangs (because I can't reproduce this on my machine).
-
lars@dl145j.mysql.com authored
into mysql.com:/users/lthalmann/bk/MERGE/mysql-5.1-merge
-
lars@mysql.com authored
into mysql.com:/users/lthalmann/bk/MERGE/mysql-5.0-merge
-
- 01 Jul, 2006 5 commits
-
-
mikael@dator5.(none) authored
into dator5.(none):/home/pappa/bug17138
-
mikael@dator5.(none) authored
into dator5.(none):/home/pappa/bug17138
-
mikael@dator5.(none) authored
into dator5.(none):/home/pappa/bug20583
-
mikael@dator5.(none) authored
into dator5.(none):/home/pappa/bug17138
-
mikael@dator5.(none) authored
Last round of review fixes
-