lp:mysql-server/5.1
NOTE: The MySQL Server repositories on Launchpad have been frozen. Future updates will be published on github instead.
- Get this branch:
- bzr branch lp:mysql-server/5.1
Branch merges
Branch information
Recent revisions
- 4061. By Tor Didriksen <email address hidden>
-
Bug#17617945 BUFFER OVERFLOW IN GET_MERGE_
MANY_BUFFS_ COST WITH SMALL SORT_BUFFER_SIZE get_cost_
calc_buff_ size() could return wrong value for the size of imerge_cost_buff. - 4059. By Venkata Sidagam <email address hidden>
-
Bug #12917164 DROP USER CAN'T DROP USERS WITH LEGACY
UPPER CASE HOST NAME ANYMOREDescription:
It is not possible to drop users with host names with upper case
letters in them. i.e DROP USER 'root'@'Tmp_Host_ Name'; is failing
with error.Analysis: Since the fix 11748570 we came up with lower case hostnames
as standard. But in the current bug the hostname is created by
mysql_install_db script is still having upper case hostnames.
So, if we have the hostname with upper case letters like(Tmp_Host_Name)
then we will have as it is stored in the mysql.user table.
In this case if use "'DROP USER 'root'@'Tmp_Host_ Name';" it gives
error because we do compare with the lower case of hostname since the
11748570 fix.Fix: We need to convert the hostname to lower case before storing into
the mysql.user table when we run the mysql_install_db script. - 4057. By Tor Didriksen <email address hidden>
-
Bug#17326567 MYSQL SERVER FILESORT IMPLEMENTATION HAS A VERY SERIOUS BUG
The filesort implementation needs space for at least 15 records
(plus some internal overhead) in its main sort buffer. - 4056. By Aditya A <email address hidden>
-
Bug#17559867 AFTER REBUILDING,A MYISAM PARTITION ENDS UP
AS A INNODB PARTITTION.PROBLEM
-------
The correct engine_type was not being set during
rebuild of the partition due to which the handler
was always created with the default engine,
which is innodb for 5.5+ ,therefore even if the
table was myisam, after rebuilding the partitions
ended up as innodb partitions.FIX
---
Set the correct engine type during rebuild.[Approved by mattiasj #rb3599]
- 4055. By Venkatesh Duggirala<email address hidden>
-
Bug#17234370 LAST_INSERT_ID IS REPLICATED INCORRECTLY IF
REPLICATION FILTERS ARE USED.Problem:
When Filtered-slave applies Int_var_log_event and when it
tries to write the event to its own binlog, LAST_INSERT_ID
value is written wrongly.Analysis:
THD::stmt_depends_ on_first_ successful_ insert_ id_in_prev_ stmt
is a variable which is set when LAST_INSERT_ID() is used by
a statement. If it is set, first_successful_insert_ id_in_
prev_stmt_for_binlog will be stored in the statement-based
binlog. This variable is CUMULATIVE along the execution of
a stored function or trigger: if one substatement sets it
to 1 it will stay 1 until the function/trigger ends,
thus making sure that first_successful_insert_ id_in_
prev_stmt_for_binlog does not change anymore and is
propagated to the caller for binlogging. This is achieved
using the following code
if(!stmt_depends_ on_first_ successful_ insert_ id_in_prev_ stmt)
{
/* It's the first time we read it */
first_successful_ insert_ id_in_prev_ stmt_for_ binlog=
first_successful_ insert_ id_in_prev_ stmt;
stmt_depends_ on_first_ successful_ insert_ id_in_prev_ stmt= 1;
}Slave server, after receiving Int_var_log_event event from
master, it is setting
stmt_depends_on_first_ successful_ insert_ id_in_prev_ stmt
to true(*which is wrong*) and not setting
first_successful_insert_ id_in_prev_ stmt_for_ binlog. Because
of this problem, when the actual DML statement with
LAST_INSERT_ID() is parsed by slave SQL thread,
first_successful_insert_ id_in_prev_ stmt_for_ binlog is not
set. Hence the value zero (default value) is written to
slave's binlog.Why only *Filtered slave* is effected when the code is
in common place:
-------------- ------- ------- ------- ------- ------- ------
In Query_log_event:: do_apply_ event,
THD::stmt_depends_ on_first_ successful_ insert_ id_in_prev_ stmt
is reset to zero at the end of the function. In case of
normal slave (No Filters), this variable will be reset.
In Filtered slave, Slave SQL thread defers all IRU events's
execution until IRU's Query_log event is received. Once it
receives Query_log_event it executes all pending IRU events
and then it executes Query_log_event. Hence the variable is
not getting reset to 0, causing this bug.Fix: As described above, the root cause was setting
THD::stmt_depends_ on_first_ successful_ insert_ id_in_prev_ stmt
when Int_var_log_event was executed by a SQL thread. Hence
removing the problematic line from the code. - 4054. By Venkata Sidagam <email address hidden>
-
Bug#16900358 FIX FOR CVE-2012-5611 IS INCOMPLETE
Description: Fix for bug CVE-2012-5611 (bug 67685) is
incomplete. The ACL_KEY_LENGTH- sized buffers in acl_get() and
check_grant_db() can be overflown by up to two bytes. That's
probably not enough to do anything more serious than crashing
mysqld.
Analysis: In acl_get() when "copy_length" is calculated it
just adding the variable lengths. But when we are using them
with strmov() we are adding +1 to each. This will lead to a
three byte buffer overflow (i.e two +1's at strmov() and one
byte for the null added by strmov() function). Similarly it
happens for check_grant_db() function as well.
Fix: We need to add "+2" to "copy_length" in acl_get()
and "+1" to "copy_length" in check_grant_db(). - 4053. By Nuno Carvalho <email address hidden>
-
WL#7266: Dump-thread additional concurrency tests
This worklog aims at testing the two following scenarios:
1) Whenever the mysql_binlog_send method (dump thread)
reaches the end of file when reading events from the binlog, before
checking if it should wait for more events, there was a test to
check if the file being read was still active, i.e, it was the last
known binlog. However, it was possible that something was written to
the binary log and then a rotation would happen, after EOF was
detected and before the check for active was performed. In this
case, the end of the binary log would not be read by the dump
thread, and this would cause the slave to lose updates.
This test verifies that the problem has been fixed. It waits during
this window while forcing a rotation in the binlog.2) Verify dump thread can send events in active file, correctly after
encountering an IO error.
Branch metadata
- Branch format:
- Branch format 7
- Repository format:
- Bazaar repository format 2a (needs bzr 1.16 or later)
- Stacked on:
- lp:~dannythefool/+junk/trunk-outdated