List:Packagers« Previous MessageNext Message »
From:Hai Zhang Date:November 26 2011 1:01pm
Subject:Re: MySQL Community Server 5.1.60 has been released
View as plain text  
any one would like to explain bug #11878104 ?

Regards,
ZhangHai

On Thu, Nov 24, 2011 at 6:54 PM, Hai Zhang <vj.zhanghai@stripped> wrote:

> Replication: Issuing the following statements, in the order
>       shown, could cause a deadlock between the user thread and I/O
>       thread:
> START SLAVE;
> STOP SLAVE SQL_THREAD;
> START SLAVE;
>       (Bug #11878104)
>
> Who could be free to explain the reason about the above bug? In my point
> there is no any relation btw user thread and i/o thread. why some
> contention could happen btw them?
> Thanks in advance :P
>
>
> Regards,
> ZhangHai(Mysql DBA)
> www.mysqlsystems.com
>
> On Fri, Nov 18, 2011 at 11:21 PM, Karen Langford <
> karen.langford@stripped> wrote:
>
>> Dear MySQL users,
>>
>> MySQL Server 5.1.60, a new version of the popular Open Source
>> Database Management System, has been released. MySQL 5.1.60 is
>> recommended for use on production systems.
>>
>> For an overview of what's new in MySQL 5.1, please see
>>
>>   
> http://dev.mysql.com/doc/**refman/5.1/en/mysql-nutshell.**html<http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.html>
>>
>> For information on installing MySQL 5.1.60 on new servers or upgrading
>> to MySQL 5.1.60 from previous MySQL releases, please see
>>
>>   
> http://dev.mysql.com/doc/**refman/5.1/en/installing.html<http://dev.mysql.com/doc/refman/5.1/en/installing.html>
>>
>> MySQL Server is available in source and binary form for a number of
>> platforms from our download pages at
>>
>>    http://dev.mysql.com/**downloads/ <http://dev.mysql.com/downloads/>
>>
>> Not all mirror sites may be up to date at this point in time, so if you
>> can't find this version on some mirror, please try again later or choose
>> another download site.
>>
>> We welcome and appreciate your feedback, bug reports, bug fixes,
>> patches, etc:
>>
>>   
> http://forge.mysql.com/wiki/**Contributing<http://forge.mysql.com/wiki/Contributing>
>>
>> For information on open issues in MySQL 5.1, please see the errata
>> list at
>>
>>   
> http://dev.mysql.com/doc/**refman/5.1/en/open-bugs.html<http://dev.mysql.com/doc/refman/5.1/en/open-bugs.html>
>>
>> The following section lists the changes in the MySQL source code since
>> the previous released version of MySQL 5.1. It may also be viewed
>> online at
>>
>>   
> http://dev.mysql.com/doc/**refman/5.1/en/news-5-1-60.html<http://dev.mysql.com/doc/refman/5.1/en/news-5-1-60.html>
>>
>> Enjoy!
>>
>> ==============================**==============================**
>> ===========
>> D.1.1. Changes in MySQL 5.1.60 (16 November, 2011)
>>
>>   Functionality Added or Changed
>>
>>     * Upgrading from an Advanced GPL RPM package to an Advanced RPM
>>       package did not work. Now on Linux it is possible to use rpm
>>       -U to replace any installed MySQL product by any other of the
>>       same release family. It is not necessary to remove the old
>>       produce with rpm -e first. (Bug #11886309)
>>
>>     * MEMORY table creation time is now available in the CREATE_TIME
>>       column of the INFORMATION_SCHEMA.TABLES table and the
>>       Create_time column of SHOW TABLE STATUS output. (Bug #51655,
>>       Bug #11759349)
>>
>>   Bugs Fixed
>>
>>     * InnoDB Storage Engine: This fix improves the performance of
>>       instrumentation code for InnoDB buffer pool operations. (Bug
>>       #12950803, Bug #62294)
>>
>>     * InnoDB Storage Engine: Data from BLOB columns could be lost if
>>       the server crashed at a precise moment when other columns were
>>       being updated in an InnoDB table. (Bug #12704861)
>>
>>     * InnoDB Storage Engine: Lookups using secondary indexes could
>>       give incorrect matches under a specific set of conditions. The
>>       conditions involve an index defined on a column prefix, for a
>>       BLOB or other long column stored outside the index page, with
>>       a table using the Barracuda file format. (Bug #12601439)
>>
>>     * InnoDB Storage Engine: This fix corrects cases where the MySQL
>>       server could hang or abort with a long semaphore wait message.
>>       (This is a different issue than when these symptoms occurred
>>       during a CHECK TABLE statement.) (Bug #11766591, Bug #59733)
>>
>>     * Replication: Issuing the following statements, in the order
>>       shown, could cause a deadlock between the user thread and I/O
>>       thread:
>> START SLAVE;
>> STOP SLAVE SQL_THREAD;
>> START SLAVE;
>>       (Bug #11878104)
>>       See also Bug #44312, Bug #11752963, Bug #38715, Bug #38716.
>>
>>     * Internal conversion of zero to binary and back could yield a
>>       result with incorrect precision. (Bug #12911710)
>>
>>     * Valgrind warnings generated by filesort operations were fixed.
>>       (Bug #12856915)
>>
>>     * Several improvements were made to the libedit library bundled
>>       with MySQL distributions, and that is available for all
>>       platforms that MySQL supports except Windows.
>>
>>          + Navigation keys did not work for UTF-8 input.
>>
>>          + Word navigation and delete operations did not work for
>>            UTF-8 input with Cyrillic characters.
>>
>>          + Nonlatin characters were corrupted in overwrite mode for
>>            UTF-8 input.
>>
>>          + Long queries caused the statement history file to become
>>            corrupted.
>>
>>          + The Alt key caused history operations to fail.
>>       (Bug #12605400, Bug #12613725, Bug #12618092, Bug #12624155,
>>       Bug #12617651, Bug #12605388)
>>
>>     * The help message for mysql_install_db did not indicate that it
>>       supports the --defaults-file, --defaults-extra-file and
>>       --no-defaults options. (Bug #58898, Bug #11765888)
>>
>>     * An assertion designed to detect zero-length sort keys also was
>>       raised when the entire key set fit in memory. (Bug #58200, Bug
>>       #11765254)
>>
>>     * myisampack could create corrupt FULLTEXT indexes when
>>       compressing tables. (Bug #53646, Bug #11761180)
>>
>>     * OPTIMIZE TABLE could corrupt MyISAM tables if myisam_use_mmap
>>       was enabled. (Bug #49030, Bug #11757032)
>>
>>     * If MySQL was configured with --without-plugin-innobase and
>>       --with-plugin-innodb_plugin, to suppress building the built-in
>>       InnoDB storage engine and build the InnoDB Plugin instead, the
>>       innochecksum utility was not built. (Bug #47337, Bug
>>       #11755544)
>>
>>     * A linking problem prevented the FEDERATED storage engine
>>       plugin from loading. (Bug #40942, Bug #11750417)
>>
>>     * On Fedora, certain accesses to /var/lib/mysql/HOSTNAME.err
>>       were blocked by SELinux policy, which made the server fail at
>>       startup with the message: Manager of pid-file quit without
>>       updating file (Bug #37165, Bug #12927740)
>>
>>     * For FEDERATED tables, loss of connection to the remote table
>>       during some insert operations could cause a server crash. (Bug
>>       #34660, Bug #11747970)
>>
>> Thanks,
>> MySQL RE Team
>> Database Group, Oracle.
>>
>>
>> --
>> MySQL Packagers Mailing List
>> For list archives:
> http://lists.mysql.com/**packagers<http://lists.mysql.com/packagers>
>> To unsubscribe:    http://lists.mysql.com/**packagers?unsub=1
>> *gmail.com <http://lists.mysql.com/packagers?unsub=1
>>
>>
>

Thread
MySQL Community Server 5.1.60 has been releasedKaren Langford18 Nov
  • Re: MySQL Community Server 5.1.60 has been releasedhu dai18 Nov
  • Re: MySQL Community Server 5.1.60 has been releasedHai Zhang24 Nov
    • Re: MySQL Community Server 5.1.60 has been releasedHai Zhang26 Nov