MySQL Community Server 5.1.35 has been released

Dear MySQL users,

MySQL Community Server 5.1.35, a new version of the popular Open
Source Database Management System, has been released. MySQL 5.1.35 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

For information on installing MySQL 5.1.35 on new servers or upgrading
to MySQL 5.1.35 from previous MySQL releases, please see

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/

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

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

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-35.html

Enjoy!

Timothy Smith
The MySQL build team at Sun Microsystems

============================================================ ===========

This release of MySQL has two known outstanding issues for
Windows:

* The .msi installer does not detect an existing root password
on the initial configuration attempt. To work around this,
install and configure MySQL as normal, but skip any changes to
security. (There is a checkbox that allows this on the
security screen of the configuration wizard.) Then check your
settings:

+ If the old root password and security settings are okay,
you are done and can proceed to use MySQL.

+ Otherwise, reconfigure with the wizard and make any
changes on the second configuration attempt. The wizard
will properly prompt for the existing root password and
allow changes to be made.

This issue has been filed as
Bug#45200: http://bugs.mysql.com/45200 for correction in a
future release.

* The Windows configuration wizard allows changes to InnoDB
settings during a reconfiguration operation. For an upgrade,
this may cause difficulties. To work around this, use one of
the following alternatives:

+ Do not change InnoDB settings.

+ Copy files from the old InnoDB location to the new one.

This issue has been filed as
Bug#45201: http://bugs.mysql.com/45201 for correction in a
future release.

Bugs fixed:

* Important Change: Replication: The transactional behavior of
STOP SLAVE has changed. Formerly, it took effect immediately,
even inside a transaction; now, it waits until the current
replication event group (if any) has finished executing, or
until the user issues a KILL QUERY or KILL CONNECTION
statement.

This was done in order to solve the problem encountered when
replication was stopped while a nontransactional slave was
replicating a transaction on the master. (It was impossible to
roll back a mixed-engines transaction when one of the engines
was nontransactional, which meant that the slave could not
safely re-apply any transaction that had been interrupted by
STOP SLAVE.) (Bug#319: http://bugs.mysql.com/319,
Bug#38205: http://bugs.mysql.com/38205)
See also Bug#43217: http://bugs.mysql.com/43217.

* Partitioning: When a value was equal to a PARTITION ... VALUES
LESS THAN (value) value other than MAXVALUE, the corresponding
partition was not pruned.
(Bug#42944: http://bugs.mysql.com/42944)

* Replication: Unrelated errors occurring during the execution
of RESET SLAVE could cause the slave to crash.
(Bug#44179: http://bugs.mysql.com/44179)

* Replication: The --slave-skip-errors option had no effect when
using row-based logging format.
(Bug#39393: http://bugs.mysql.com/39393)

* Replication: The following erors were not correctly reported:

+ Failures during slave thread initialization

+ Failures while initializing the relay log position
(immediately following the starting of the slave thread)

+ Failures while processing queries passed through the
--init_slave option.

Information about these types of failures can now be found in
the output of SHOW SLAVE STATUS.
(Bug#38197: http://bugs.mysql.com/38197)

* Replication: Killing the thread executing a DDL statement,
after it had finished its execution but before it had written
the binlog event, caused the error code in the binlog event to
be set (incorrectly) to ER_SERVER_SHUTDOWN or
ER_QUERY_INTERRUPTED, which caused replication to fail.
(Bug#37145: http://bugs.mysql.com/37145)

See also Bug#27571: http://bugs.mysql.com/27571,
Bug#22725: http://bugs.mysql.com/22725.

* Replication: Column alises used inside subqueries were ignored
in the binary log. (Bug#35515: http://bugs.mysql.com/35515)

* Valgrind warnings for the DECODE(), ENCRYPT(), and
FIND_IN_SET() functions were corrected.
(Bug#44358: http://bugs.mysql.com/44358,
Bug#44365: http://bugs.mysql.com/44365,
Bug#44367: http://bugs.mysql.com/44367)

* On Windows, entries for build-vs9.bat and build-vs9_x64.bat
were missing in win/Makefile.am.
(Bug#44353: http://bugs.mysql.com/44353)

* Incomplete cleanup of JOIN_TAB::select during the filesort of
rows for a GROUP BY clause inside a subquery caused a server
crash. (Bug#44290: http://bugs.mysql.com/44290)

* Not all lock types had proper descriptive strings, resulting
in garbage output from mysqladmin debug.
(Bug#44164: http://bugs.mysql.com/44164)

* Use of HANDLER statements with INFORMATION_SCHEMA tables
caused a server crash. Now HANDLER is prohibited with such
tables. (Bug#44151: http://bugs.mysql.com/44151)

* Invoking SHOW TABLE STATUS from within a stored procedure
could cause a Packets out of order error.
(Bug#43962: http://bugs.mysql.com/43962)

* myisamchk could display a negative Max keyfile length value.
(Bug#43950: http://bugs.mysql.com/43950)

* On 64-bit systems, a key_buffer_size value larger than 4GB
could couse MyISAM index corruption.
(Bug#43932: http://bugs.mysql.com/43932)

* mysqld_multi incorrectly passed --no-defaults to mysqld_safe.
(Bug#43876: http://bugs.mysql.com/43876)

* SHOW VARIABLES did not properly display the value of
slave_skip_errors. (Bug#43835: http://bugs.mysql.com/43835)

* On Windows, a server crash occurred for attempts to insert a
floating-point value into a CHAR column with a maximum length
less than the converted floating-point value length.
(Bug#43833: http://bugs.mysql.com/43833)

* Incorrect initialization of MyISAM table indexes could cause
incorrect query results.
(Bug#43737: http://bugs.mysql.com/43737)

* libmysqld crashed when it was reinitialized.
(Bug#43706: http://bugs.mysql.com/43706,
Bug#44091: http://bugs.mysql.com/44091)

* InnoDB uses random numbers to generate dives into indexes for
calculating index cardinality. However, under certain
conditions, the algorithm did not generate random numbers, so
ANALYZE TABLE did not update cardinality estimates properly. A
new algorithm has been introduced with better randomization
properties, together with a system variable,
innodb_use_legacy_cardinality_algorithm, that controls which
algorithm to use. The default value of the variable is 1 (ON),
to use the original algorithm for compatibility with existing
applications. The variable can be set to 0 (OFF) to use the
new algorithm with improved randomness.
(Bug#43660: http://bugs.mysql.com/43660)

* UNION of floating-point numbers did unnecessary rounding.
(Bug#43432: http://bugs.mysql.com/43432)

* ALTER DATABASE ... UPGRADE DATA DIRECTORY NAME failed when the
database contained views.
(Bug#43385: http://bugs.mysql.com/43385)

* Certain statements might open a table and then wait for an
impending global read lock without noticing whether they hold
a table being waiting for by the global read lock, causing a
hang. Affected statements are SELECT ... FOR UPDATE, LOCK
TABLES ... WRITE, TRUNCATE TABLE, and LOAD DATA INFILE.
(Bug#43230: http://bugs.mysql.com/43230)

* Using an XML function such as ExtractValue() more than once in
a single query could produce erroneous results.
(Bug#43183: http://bugs.mysql.com/43183)
See also Bug#43937: http://bugs.mysql.com/43937.

* Full-text prefix searches could hang the connection and cause
100% CPU consumption. (Bug#42907: http://bugs.mysql.com/42907)

* InnoDB had excessive contention for a character set mutex.
(Bug#42649: http://bugs.mysql.com/42649)

* Incorrect elevation of warning messages to error messages for
unsafe statements caused a server crash.
(Bug#42640: http://bugs.mysql.com/42640)

* CHECK TABLE suggested use of REPAIR TABLE for corrupt tables
for storage engines not supported by REPAIR TABLE. Now CHECK
TABLE suggests that the user dump and reload the table.
(Bug#42563: http://bugs.mysql.com/42563)

* Compressing a table with the myisampack utility caused the
server to produce Valgrind warnings when it opened the table.
(Bug#41541: http://bugs.mysql.com/41541)

* For a MyISAM table with DELAY_KEY_WRITE enabled, the index
file could be corrupted without the table being marked as
crashed if the server was killed.
(Bug#41330: http://bugs.mysql.com/41330)

* Killing an INSERT ... SELECT statement for a MyISAM table
could cause table corruption if the table had indexes.
(Bug#40827: http://bugs.mysql.com/40827)

* A multiple-table DELETE IGNORE statement involving a foreign
key constraint caused an assertion failure.
(Bug#40127: http://bugs.mysql.com/40127)

* Multiple-table UPDATE statements did not properly activate
triggers. (Bug#39953: http://bugs.mysql.com/39953)

* The mysql_setpermission operation for removing database
privileges removed global privileges instead.
(Bug#39852: http://bugs.mysql.com/39852)

* A stored routine contain a C-style comment could not be dumped
and reloaded. (Bug#39559: http://bugs.mysql.com/39559)

* In an UPDATE or DELETE via a secondary index, InnoDB did not
store the cursor position. This made InnoDB crash in
semi-consistent read while attempting to unlock a nonmatching
record. (Bug#39320: http://bugs.mysql.com/39320)

* The functions listed in Section 11.13.4.2.3, "Creating
Geometry Values Using MySQL-Specific Functions," previously
accepted WKB arguments and returned WKB values. They now
accept WKB or geometry arguments and return geometry values.
The functions listed in Section 11.13.4.2.2, "Creating
Geometry Values Using WKB Functions," previously accepted WKB
arguments and returned geometry values. They now accept WKB or
geometry arguments and return geometry values.
(Bug#38990: http://bugs.mysql.com/38990)

* On WIndows, running the server with myisam_use_mmap enabled
caused MyISAM table corruption.
(Bug#38848: http://bugs.mysql.com/38848)

* CHECK TABLE did not properly check whether MyISAM tables
created by servers from MySQL 4.0 or older needed to be
upgraded. This could cause problems upgrading to MySQL 5.1 or
higher. (Bug#37631: http://bugs.mysql.com/37631)

* An UPDATE statement that updated a column using the same
DES_ENCRYPT() value for each row actually updated different
rows with different values.
(Bug#35087: http://bugs.mysql.com/35087)

* For shared-memory connections, the read and write methods did
not properly handle asynchronous close events, which could
lead to the client locking up waiting for a server response.
For example, a call to mysql_real_query() would block forever
on the client side if the executed statement was aborted on
the server side. Thanks to Armin Schöffmann for the bug report
and patch. (Bug#33899: http://bugs.mysql.com/33899)

* CHECKSUM TABLE was not killable with KILL QUERY.
(Bug#33146: http://bugs.mysql.com/33146)

* myisamchk and myisampack were not being linked with the
library that enabled support for * filename pattern expansion.
(Bug#29248: http://bugs.mysql.com/29248)

* For InnoDB tables that have their own .ibd tablespace file, a
superfluous ibuf cursor restoration fails! message could be
written to the error log. This warning has been suppressed.
(Bug#27276: http://bugs.mysql.com/27276)

* COMMIT did not delete savepoints if there were no changes in
the transaction. (Bug#26288: http://bugs.mysql.com/26288)

* Several memory allocation functions were not being checked for
out-of-memory return values.
(Bug#25058: http://bugs.mysql.com/25058)


Timothy Smith, Product Engineering, MySQL
Database Technology Group, Sun Microsystems


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: MySQL Community Server 5.1.35 has been released

On Thu, Jun 04, 2009 at 01:27:34PM -0600, Timothy Smith wrote:
> Dear MySQL users,
>
> MySQL Community Server 5.1.35, a new version of the popular Open
> Source Database Management System, has been released. MySQL 5.1.35 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
>
> For information on installing MySQL 5.1.35 on new servers or upgrading
> to MySQL 5.1.35 from previous MySQL releases, please see
>
> 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/
>
> 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
>
> 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
>
> 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-35.html
>
> Enjoy!
>
> Timothy Smith
> The MySQL build team at Sun Microsystems
>
> ============================================================ ===========
>
> This release of MySQL has two known outstanding issues for
> Windows:
>
> * The .msi installer does not detect an existing root password
> on the initial configuration attempt. To work around this,
> install and configure MySQL as normal, but skip any changes to
> security. (There is a checkbox that allows this on the
> security screen of the configuration wizard.) Then check your
> settings:
>
> + If the old root password and security settings are okay,
> you are done and can proceed to use MySQL.
>
> + Otherwise, reconfigure with the wizard and make any
> changes on the second configuration attempt. The wizard
> will properly prompt for the existing root password and
> allow changes to be made.
>
> This issue has been filed as
> Bug#45200: http://bugs.mysql.com/45200 for correction in a
> future release.
>
> * The Windows configuration wizard allows changes to InnoDB
> settings during a reconfiguration operation. For an upgrade,
> this may cause difficulties. To work around this, use one of
> the following alternatives:
>
> + Do not change InnoDB settings.
>
> + Copy files from the old InnoDB location to the new one.
>
> This issue has been filed as
> Bug#45201: http://bugs.mysql.com/45201 for correction in a
> future release.
>
> Bugs fixed:
>
> * Important Change: Replication: The transactional behavior of
> STOP SLAVE has changed. Formerly, it took effect immediately,
> even inside a transaction; now, it waits until the current
> replication event group (if any) has finished executing, or
> until the user issues a KILL QUERY or KILL CONNECTION
> statement.
>
> This was done in order to solve the problem encountered when
> replication was stopped while a nontransactional slave was
> replicating a transaction on the master. (It was impossible to
> roll back a mixed-engines transaction when one of the engines
> was nontransactional, which meant that the slave could not
> safely re-apply any transaction that had been interrupted by
> STOP SLAVE.) (Bug#319: http://bugs.mysql.com/319,
> Bug#38205: http://bugs.mysql.com/38205)
> See also Bug#43217: http://bugs.mysql.com/43217.
>
> * Partitioning: When a value was equal to a PARTITION ... VALUES
> LESS THAN (value) value other than MAXVALUE, the corresponding
> partition was not pruned.
> (Bug#42944: http://bugs.mysql.com/42944)
>
> * Replication: Unrelated errors occurring during the execution
> of RESET SLAVE could cause the slave to crash.
> (Bug#44179: http://bugs.mysql.com/44179)
>
> * Replication: The --slave-skip-errors option had no effect when
> using row-based logging format.
> (Bug#39393: http://bugs.mysql.com/39393)
>
> * Replication: The following erors were not correctly reported:
>
> + Failures during slave thread initialization
>
> + Failures while initializing the relay log position
> (immediately following the starting of the slave thread)
>
> + Failures while processing queries passed through the
> --init_slave option.
>
> Information about these types of failures can now be found in
> the output of SHOW SLAVE STATUS.
> (Bug#38197: http://bugs.mysql.com/38197)
>
> * Replication: Killing the thread executing a DDL statement,
> after it had finished its execution but before it had written
> the binlog event, caused the error code in the binlog event to
> be set (incorrectly) to ER_SERVER_SHUTDOWN or
> ER_QUERY_INTERRUPTED, which caused replication to fail.
> (Bug#37145: http://bugs.mysql.com/37145)
>
> See also Bug#27571: http://bugs.mysql.com/27571,
> Bug#22725: http://bugs.mysql.com/22725.
>
> * Replication: Column alises used inside subqueries were ignored
> in the binary log. (Bug#35515: http://bugs.mysql.com/35515)
>
> * Valgrind warnings for the DECODE(), ENCRYPT(), and
> FIND_IN_SET() functions were corrected.
> (Bug#44358: http://bugs.mysql.com/44358,
> Bug#44365: http://bugs.mysql.com/44365,
> Bug#44367: http://bugs.mysql.com/44367)
>
> * On Windows, entries for build-vs9.bat and build-vs9_x64.bat
> were missing in win/Makefile.am.
> (Bug#44353: http://bugs.mysql.com/44353)
>
> * Incomplete cleanup of JOIN_TAB::select during the filesort of
> rows for a GROUP BY clause inside a subquery caused a server
> crash. (Bug#44290: http://bugs.mysql.com/44290)
>
> * Not all lock types had proper descriptive strings, resulting
> in garbage output from mysqladmin debug.
> (Bug#44164: http://bugs.mysql.com/44164)
>
> * Use of HANDLER statements with INFORMATION_SCHEMA tables
> caused a server crash. Now HANDLER is prohibited with such
> tables. (Bug#44151: http://bugs.mysql.com/44151)
>
> * Invoking SHOW TABLE STATUS from within a stored procedure
> could cause a Packets out of order error.
> (Bug#43962: http://bugs.mysql.com/43962)
>
> * myisamchk could display a negative Max keyfile length value.
> (Bug#43950: http://bugs.mysql.com/43950)
>
> * On 64-bit systems, a key_buffer_size value larger than 4GB
> could couse MyISAM index corruption.
> (Bug#43932: http://bugs.mysql.com/43932)
>
> * mysqld_multi incorrectly passed --no-defaults to mysqld_safe.
> (Bug#43876: http://bugs.mysql.com/43876)
>
> * SHOW VARIABLES did not properly display the value of
> slave_skip_errors. (Bug#43835: http://bugs.mysql.com/43835)
>
> * On Windows, a server crash occurred for attempts to insert a
> floating-point value into a CHAR column with a maximum length
> less than the converted floating-point value length.
> (Bug#43833: http://bugs.mysql.com/43833)
>
> * Incorrect initialization of MyISAM table indexes could cause
> incorrect query results.
> (Bug#43737: http://bugs.mysql.com/43737)
>
> * libmysqld crashed when it was reinitialized.
> (Bug#43706: http://bugs.mysql.com/43706,
> Bug#44091: http://bugs.mysql.com/44091)
>
> * InnoDB uses random numbers to generate dives into indexes for
> calculating index cardinality. However, under certain
> conditions, the algorithm did not generate random numbers, so
> ANALYZE TABLE did not update cardinality estimates properly. A
> new algorithm has been introduced with better randomization
> properties, together with a system variable,
> innodb_use_legacy_cardinality_algorithm, that controls which
> algorithm to use. The default value of the variable is 1 (ON),
> to use the original algorithm for compatibility with existing
> applications. The variable can be set to 0 (OFF) to use the
> new algorithm with improved randomness.
> (Bug#43660: http://bugs.mysql.com/43660)
>
> * UNION of floating-point numbers did unnecessary rounding.
> (Bug#43432: http://bugs.mysql.com/43432)
>
> * ALTER DATABASE ... UPGRADE DATA DIRECTORY NAME failed when the
> database contained views.
> (Bug#43385: http://bugs.mysql.com/43385)
>
> * Certain statements might open a table and then wait for an
> impending global read lock without noticing whether they hold
> a table being waiting for by the global read lock, causing a
> hang. Affected statements are SELECT ... FOR UPDATE, LOCK
> TABLES ... WRITE, TRUNCATE TABLE, and LOAD DATA INFILE.
> (Bug#43230: http://bugs.mysql.com/43230)
>
> * Using an XML function such as ExtractValue() more than once in
> a single query could produce erroneous results.
> (Bug#43183: http://bugs.mysql.com/43183)
> See also Bug#43937: http://bugs.mysql.com/43937.
>
> * Full-text prefix searches could hang the connection and cause
> 100% CPU consumption. (Bug#42907: http://bugs.mysql.com/42907)
>
> * InnoDB had excessive contention for a character set mutex.
> (Bug#42649: http://bugs.mysql.com/42649)
>
> * Incorrect elevation of warning messages to error messages for
> unsafe statements caused a server crash.
> (Bug#42640: http://bugs.mysql.com/42640)
>
> * CHECK TABLE suggested use of REPAIR TABLE for corrupt tables
> for storage engines not supported by REPAIR TABLE. Now CHECK
> TABLE suggests that the user dump and reload the table.
> (Bug#42563: http://bugs.mysql.com/42563)
>
> * Compressing a table with the myisampack utility caused the
> server to produce Valgrind warnings when it opened the table.
> (Bug#41541: http://bugs.mysql.com/41541)
>
> * For a MyISAM table with DELAY_KEY_WRITE enabled, the index
> file could be corrupted without the table being marked as
> crashed if the server was killed.
> (Bug#41330: http://bugs.mysql.com/41330)
>
> * Killing an INSERT ... SELECT statement for a MyISAM table
> could cause table corruption if the table had indexes.
> (Bug#40827: http://bugs.mysql.com/40827)
>
> * A multiple-table DELETE IGNORE statement involving a foreign
> key constraint caused an assertion failure.
> (Bug#40127: http://bugs.mysql.com/40127)
>
> * Multiple-table UPDATE statements did not properly activate
> triggers. (Bug#39953: http://bugs.mysql.com/39953)
>
> * The mysql_setpermission operation for removing database
> privileges removed global privileges instead.
> (Bug#39852: http://bugs.mysql.com/39852)
>
> * A stored routine contain a C-style comment could not be dumped
> and reloaded. (Bug#39559: http://bugs.mysql.com/39559)
>
> * In an UPDATE or DELETE via a secondary index, InnoDB did not
> store the cursor position. This made InnoDB crash in
> semi-consistent read while attempting to unlock a nonmatching
> record. (Bug#39320: http://bugs.mysql.com/39320)
>
> * The functions listed in Section 11.13.4.2.3, "Creating
> Geometry Values Using MySQL-Specific Functions," previously
> accepted WKB arguments and returned WKB values. They now
> accept WKB or geometry arguments and return geometry values.
> The functions listed in Section 11.13.4.2.2, "Creating
> Geometry Values Using WKB Functions," previously accepted WKB
> arguments and returned geometry values. They now accept WKB or
> geometry arguments and return geometry values.
> (Bug#38990: http://bugs.mysql.com/38990)
>
> * On WIndows, running the server with myisam_use_mmap enabled
> caused MyISAM table corruption.
> (Bug#38848: http://bugs.mysql.com/38848)
>
> * CHECK TABLE did not properly check whether MyISAM tables
> created by servers from MySQL 4.0 or older needed to be
> upgraded. This could cause problems upgrading to MySQL 5.1 or
> higher. (Bug#37631: http://bugs.mysql.com/37631)
>
> * An UPDATE statement that updated a column using the same
> DES_ENCRYPT() value for each row actually updated different
> rows with different values.
> (Bug#35087: http://bugs.mysql.com/35087)
>
> * For shared-memory connections, the read and write methods did
> not properly handle asynchronous close events, which could
> lead to the client locking up waiting for a server response.
> For example, a call to mysql_real_query() would block forever
> on the client side if the executed statement was aborted on
> the server side. Thanks to Armin Schöffmann for the bug report
> and patch. (Bug#33899: http://bugs.mysql.com/33899)
>
> * CHECKSUM TABLE was not killable with KILL QUERY.
> (Bug#33146: http://bugs.mysql.com/33146)
>
> * myisamchk and myisampack were not being linked with the
> library that enabled support for * filename pattern expansion.
> (Bug#29248: http://bugs.mysql.com/29248)
>
> * For InnoDB tables that have their own .ibd tablespace file, a
> superfluous ibuf cursor restoration fails! message could be
> written to the error log. This warning has been suppressed.
> (Bug#27276: http://bugs.mysql.com/27276)
>
> * COMMIT did not delete savepoints if there were no changes in
> the transaction. (Bug#26288: http://bugs.mysql.com/26288)
>
> * Several memory allocation functions were not being checked for
> out-of-memory return values.
> (Bug#25058: http://bugs.mysql.com/25058)
>
>
> Timothy Smith, Product Engineering, MySQL
> Database Technology Group, Sun Microsystems
>
>
> --
> MySQL Announce Mailing List
> For list archives: http://lists.mysql.com/announce
> To unsubscribe: http://lists.mysql.com/announce?unsub=root@nk.ca
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.


Error in compiling:

mv -f .deps/liboptions_la-priv.Tpo .deps/liboptions_la-priv.Plo
/bin/sh ../../libtool --preserve-dup-deps --tag=CXX --mode=link g++ -O3 -fno-implicit-templates -fno-exceptions -fno-rtti -DDEFAULT_PID_FILE_NAME="/usr/contrib/mysqld/mysqlmanager.pi d" -DDEFAULT_LOG_FILE_NAME="/usr/contrib/mysqld/mysqlmanager.lo g" -DDEFAULT_SOCKET_FILE_NAME="/tmp/mysqlmanager.sock" -DDEFAULT_PASSWORD_FILE_NAME="/etc/mysqlmanager.passwd" -DDEFAULT_MYSQLD_PATH="/usr/contrib/libexec/mysqld" -DDEFAULT_CONFIG_FILE="my.cnf" -DPROTOCOL_VERSION=10 -O3 -fno-implicit-templates -fno-exceptions -fno-rtti -o liboptions.la liboptions_la-options.lo liboptions_la-priv.lo ../../libmysql/get_password.lo -lm
test: unrecognized integer ` ar cru .libs/liboptions.a .libs/liboptions_la-options.o .libs/liboptions_la-priv.o ../../libmysql/.libs/get_password.o ~ranlib .libs/liboptions.a/liboption'
.../../libtool: arith: syntax error: " 47 + .libs/liboptions_la-options.o~RANLI "

gmake[2]: *** [liboptions.la] Error 2
gmake[2]: Leaving directory `/usr/src/contrib/mysql/mysql-5.1.35/server-tools/instance-m anager'
gmake[1]: *** [all-recursive] Error 1
gmake[1]: Leaving directory `/usr/src/contrib/mysql/mysql-5.1.35/server-tools'
gmake: *** [all-recursive] Error 1
*** Error code 2

Stop.

Help!!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Compile problem (was: MySQL Community Server 5.1.35 has beenreleased)

Dave,


do you really consider it helpful to do "reply all" to a release
announcement, trying to send it to the "announce" and "packagers" lis=
t,
including a full quote of the announcement text, and using the origin=
al
subject line,
when you are asking for help about a compile problem?


Dave Shariff Yadallee - System Administrator a.k.a. The Root of the
Problem wrote:
> [[...]]
>=20
>=20
> Error in compiling:
>=20
> mv -f .deps/liboptions_la-priv.Tpo .deps/liboptions_la-priv.Plo
> /bin/sh ../../libtool --preserve-dup-deps --tag=3DCXX --mode=3Dli=
nk g++ -O3 -fno-implicit-templates -fno-exceptions -fno-rtti -DDEF=
AULT_PID_FILE_NAME=3D"/usr/contrib/mysqld/mysqlmanager.pid" -DDEFAULT=
_LOG_FILE_NAME=3D"/usr/contrib/mysqld/mysqlmanager.log" -DDEFAULT_SOC=
KET_FILE_NAME=3D"/tmp/mysqlmanager.sock" -DDEFAULT_PASSWORD_FILE_NAME=
=3D"/etc/mysqlmanager.passwd" -DDEFAULT_MYSQLD_PATH=3D"/usr/contrib/l=
ibexec/mysqld" -DDEFAULT_CONFIG_FILE=3D"my.cnf" -DPROTOCOL_VERSION=
=3D10 -O3 -fno-implicit-templates -fno-exceptions -fno-rtti -o l=
iboptions.la liboptions_la-options.lo liboptions_la-priv.lo ../../li=
bmysql/get_password.lo -lm
> test: unrecognized integer ` ar cru .libs/liboptions.a .libs/libopt=
ions_la-options.o .libs/liboptions_la-priv.o ../../libmysql/.libs/get=
_password.o ~ranlib .libs/liboptions.a/liboption'
> ../../libtool: arith: syntax error: " 47 + .libs/liboptions_la-opti=
ons.o~RANLI "
>=20
> gmake[2]: *** [liboptions.la] Error 2
> gmake[2]: Leaving directory `/usr/src/contrib/mysql/mysql-5.1.35/se=
rver-tools/instance-manager'
> gmake[1]: *** [all-recursive] Error 1
> gmake[1]: Leaving directory `/usr/src/contrib/mysql/mysql-5.1.35/se=
rver-tools'
> gmake: *** [all-recursive] Error 1
> *** Error code 2
>=20
> Stop. =20
>=20
> Help!!
>=20

I can't.
I cannot even try to help you, if you do not provide the necessary
information.

All I can do is give you the corresponding line from my log,
split into several lines for better readability:

/bin/sh ../../libtool --preserve-dup-deps --tag=3DCXX --mode=3Dlink=
gcc
-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W
-Wchar-subscripts -Wformat -Wparentheses -Wsign-compare
-Wwrite-strings -Wunused-function -Wunused-label -Wunused-value
-Wunused-variable -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor
-felide-constructors -fno-exceptions -fno-rtti -mtune=3Dnative -O3
-fno-omit-frame-pointer -g -fno-implicit-templates -fno-exception=
s
-fno-rtti
-DDEFAULT_PID_FILE_NAME=3D"/usr/local/mysql/var/mysqlmanager .pid"
-DDEFAULT_LOG_FILE_NAME=3D"/usr/local/mysql/var/mysqlmanager .log"
-DDEFAULT_SOCKET_FILE_NAME=3D"/tmp/mysqlmanager.sock"
-DDEFAULT_PASSWORD_FILE_NAME=3D"/etc/mysqlmanager.passwd"
-DDEFAULT_MYSQLD_PATH=3D"/usr/local/mysql/libexec/mysqld"
-DDEFAULT_CONFIG_FILE=3D"my.cnf" -DPROTOCOL_VERSION=3D10
-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W
-Wchar-subscripts -Wformat -Wparentheses -Wsign-compare
-Wwrite-strings -Wunused-function -Wunused-label -Wunused-value
-Wunused-variable -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor
-felide-constructors -fno-exceptions -fno-rtti -mtune=3Dnative -O3
-fno-omit-frame-pointer -g -fno-implicit-templates -fno-exception=
s
-fno-rtti
-rdynamic -o liboptions.la
liboptions_la-options.lo liboptions_la-priv.lo
../../libmysql/get_password.lo
-lpthread -lcrypt -lnsl -lm -lpthread

This was running on Linux (SuSE 10.3) running on an Athlon,
using libtool 1.5.24 and gcc 4.2.1.

Looking at the text you quote, it seems the commands executed by
"libtool" got garbled:
A command starting with "ar cru" suddenly continues with "~ranlib" wh=
ich
doesn't make any sense to me.

I suspect some problem around your "libtool" installation, or with yo=
ur
file system (affecting some generated files).


Jörg

--=20
Joerg Bruehe, MySQL Build Team, Joerg.Bruehe@Sun.com (+49 30) 417 01 =
487
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstett=
en
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boem=
er
Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB1610=
28


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg