April 2012 - discuss - lists.mariadb.org

[Maria-discuss] Compiling 5.5.20 on OS X
by Richard Dunn 03 Jun '12

03 Jun '12

I've been compiling MySQL and MariaDB on OS X for quite some time now, but this is the first time that I have ever used CMake to build an application. The 'make' step consistently fails with the following: Linking CXX executable ma_pagecache_consist_1k-t Undefined symbols for architecture x86_64: "_key_PAGECACHE_cache_lock", referenced from: _init_pagecache in libaria.a(ma_pagecache.c.o) ld: symbol(s) not found for architecture x86_64 I assume libaria.a is Maria specific. As a sanity check, I downloaded the MySQL source code for 5.5.21 from the MySQL site and I successfully compiled everything with CMake. Has anyone else successfully compiled a 64 bit 5.5.20 MariaDB on OS X? What am I missing?

5 9

Re: [Maria-discuss] Maria/Aria unit test failures
by Brian Evans 25 Apr '12

25 Apr '12

On 4/14/2012 1:31 AM, Oleksandr Byelkin wrote: > 11.04.2012 23:51, Brian Evans написал: >> I'm trying to pin down why unit tests fail for the 5.1, 5.2 and 5.3 >> series of the (m)aria engine. >> >> My build tool runs 'make test-unit' and the following errors appear. >> The build tool does strip out some environment variables, but running >> from bash directly doesn't change anything. >> >> Can anyone provide pointers? >> >> Thanks >> >> (This is from MariaDB 5.1.62) >> >> [16:34:05] ../storage/maria/unittest/ma_test_all-t ..................... >> 73/830 >> Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 >> -e4096 -K ' (loop iteration 8.) at line 316 >> (errcode: 256, test: 83) >> [16:34:05] ../storage/maria/unittest/ma_test_all-t ..................... > > Could you describe condition of running (OS, 32/64 bit and so on). I > can't repeat it so need more information. > > [skip] Sure. This is output from my build tool which lists important libraries and the environment used. OS is Gentoo Linux. Architecture is x86_64. Portage 2.1.10.49 (default/linux/amd64/10.0, gcc-4.5.3, glibc-2.13-r4, 2.6.38-gentoo-r6 x86_64) ================================================================= System uname: Linux-2.6.38-gentoo-r6-x86_64-Intel-R-_Xeon-TM-_CPU_3.40GHz-with-gentoo-2.0.3 Timestamp of tree: Thu, 29 Mar 2012 19:30:01 +0000 app-shells/bash: 4.2_p20 dev-lang/python: 2.7.2-r3, 3.1.4-r3, 3.2.2 dev-util/cmake: 2.8.6-r4 dev-util/pkgconfig: 0.26 sys-apps/baselayout: 2.0.3 sys-apps/openrc: 0.9.8.4 sys-apps/sandbox: 2.5 sys-devel/autoconf: 2.68 sys-devel/automake: 1.9.6-r3, 1.11.1 sys-devel/binutils: 2.21.1-r1 sys-devel/gcc: 4.5.3-r1 sys-devel/gcc-config: 1.5-r2 sys-devel/libtool: 2.4-r1 sys-devel/make: 3.82-r1 sys-kernel/linux-headers: 3.1 (virtual/os-headers) sys-libs/glibc: 2.13-r4 CBUILD="x86_64-pc-linux-gnu" CFLAGS="-O2 -pipe -march=nocona" CHOST="x86_64-pc-linux-gnu" CXXFLAGS="-O2 -pipe -march=nocona" LANG="en_US.UTF-8" LDFLAGS="-Wl,-O1 -Wl,--as-needed" MAKEOPTS="-j5"

2 3

Re: [Maria-discuss] MariaDB & InnoDB native aio disabled
by Axel Schwenke 25 Apr '12

25 Apr '12

Hi Jocelyn, jocelyn fournier wrote: > > I've just figured out after installing MariaDB 5.5.23 on two server (one > directly from the x64 binary, and the other using the debian packing) > that innodb_use_native_aio is OFF on the two servers. ... > Am I missing something ? No, you are right. It seems both the tar.gz and deb packages provided by us are built without libaio. For the deb packages, we regard this a bug and I created this bug report: https://bugs.launchpad.net/maria/+bug/988204 For the tar.gz packages, we are rather reluctant to add additional dependencies like libaio. Unless deb, a tar.gz package cannot announce such dependencies, so users might end with a dysfunctional installation without a warning. We will review this decision internally. Thank you for reporting this problem! Axel Schwenke Senior Performance Engineer, MariaDB Services AB

1 0

[Maria-discuss] getting all name-value pairs from a dynamic column
by MARK CALLAGHAN 13 Apr '12

13 Apr '12

These docs are excellent -- http://kb.askmonty.org/en/dynamic-columns How do you fetch all name-value pairs from a dynamic column in a format that can be consumed by a client? The client can select the column as is but then must know how mariadb encoded it. The function column_list returns the column names. If there were a function that encoded all name-value pairs as JSON, then the client could do something like this and be able to decode the result: select column_json(dynamic_column_name) from t where ... -- Mark Callaghan mdcallag(a)gmail.com

4 9

[Maria-discuss] Maria/Aria unit test failures
by Brian Evans 11 Apr '12

11 Apr '12

I'm trying to pin down why unit tests fail for the 5.1, 5.2 and 5.3 series of the (m)aria engine. My build tool runs 'make test-unit' and the following errors appear. The build tool does strip out some environment variables, but running from bash directly doesn't change anything. Can anyone provide pointers? Thanks (This is from MariaDB 5.1.62) [16:34:05] ../storage/maria/unittest/ma_test_all-t ..................... 73/830 Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e4096 -K ' (loop iteration 8.) at line 316 (errcode: 256, test: 83) [16:34:05] ../storage/maria/unittest/ma_test_all-t ..................... 85/830 Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e8192 -K ' (loop iteration 9.) at line 316 (errcode: 256, test: 85) Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e16384 -E16384 -K -L ' (loop iteration 10.) at line 316 (errcode: 256, test: 87) [16:34:05] ../storage/maria/unittest/ma_test_all-t ..................... 238/830 Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e4096 -K -S' (loop iteration 8.) at line 316 (errcode: 256, test: 242) Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e8192 -K -S' (loop iteration 9.) at line 316 (errcode: 256, test: 244) [16:34:05] ../storage/maria/unittest/ma_test_all-t ..................... 246/830 Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e16384 -E16384 -K -L -S' (loop iteration 10.) at line 316 (errcode: 256, test: 246) [16:34:05] ../storage/maria/unittest/ma_test_all-t ..................... 399/830 Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e4096 -K -M' (loop iteration 8.) at line 316 (errcode: 256, test: 401) Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e8192 -K -M' (loop iteration 9.) at line 316 (errcode: 256, test: 403) Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e16384 -E16384 -K -L -M' (loop iteration 10.) at line 316 (errcode: 256, test: 405) [16:34:05] ../storage/maria/unittest/ma_test_all-t ..................... 557/830 Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e4096 -K -M -T' (loop iteration 8.) at line 316 (errcode: 256, test: 560) Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e8192 -K -M -T' (loop iteration 9.) at line 316 (errcode: 256, test: 562) [16:34:05] ../storage/maria/unittest/ma_test_all-t ..................... 564/830 Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e16384 -E16384 -K -L -M -T' (loop iteration 10.) at line 316 (errcode: 256, test: 564) [16:34:05] ../storage/maria/unittest/ma_test_all-t ..................... 716/830 Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e4096 -K -M -T -C' (loop iteration 8.) at line 316 (errcode: 256, test: 719) [16:34:05] ../storage/maria/unittest/ma_test_all-t ..................... 721/830 Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e8192 -K -M -T -C' (loop iteration 9.) at line 316 (errcode: 256, test: 721) Failed test '../storage/maria/unittest/../ma_test2 -s -htmp -m10000 -e16384 -E16384 -K -L -M -T -C' (loop iteration 10.) at line 316 (errcode: 256, test: 723) [16:34:05] ../storage/maria/unittest/ma_test_all-t ..................... Dubious, test returned 1 (wstat 256, 0x100) Failed 15/830 subtests

1 0

[Maria-discuss] MariaDB 5.5.23 stable (GA) now available
by Daniel Bartholomew 11 Apr '12

11 Apr '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.23. This is a stable (GA) release. It includes MariaDB 5.3.6 and MySQL 5.5.23, some performance improvements, and bug fixes. This is the first stable (GA) release in the MariaDB 5.5 series. - - MariaDB 5.5 Links - - - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-5523-release-notes Changelog: http://kb.askmonty.org/en/mariadb-5523-changelog Downloads: http://downloads.askmonty.org/mariadb/5.5.23 .deb Repositories: http://downloads.askmonty.org/mariadb/repositories/ Overview of MariaDB 5.5: http://kb.askmonty.org/en/what-is-mariadb-55 - - SkySQL and MariaDB: Solutions Day - - - - - - - - - - - - - - - - - We'll be co-hosting the the "SkySQL & MariaDB: Solutions Day for the MySQL® Database" one day event on 13 April, 2012, at the Hyatt Regency Santa Clara. During this event, attendees will receive free, hands-on training and consulting on MariaDB and MySQL® database solutions from the experts at SkySQL, MariaDB, Continuent, ScaleDB, Severalnines, Sphinx, and Webyog, among others. SkySQL and MariaDB will bring together industry visionaries, including Michael (Monty) Widenius and David Axmark, the original authors of the MySQL database, to share their insights on current and future trends pertaining to the world's most popular open source database. To learn more about this free event, visit: http://www.skysql.com/events/mysql-solutions-day The schedule for the event is here: http://www.skysql.com/events/mysql-solutions-day/schedule Attendees are also invited to participate in Drizzle Day - a parallel event co-hosted by SkySQL, Percona, and the Drizzle Development Team, featuring tutorials on the Drizzle database. - - MariaDB Crash Course - - - - - - - - - - - - - - - - - - - - - - - The MariaDB-specific book, MariaDB Crash Course, by Ben Forta, is an excellent way to learn more about MariaDB. This book - for beginner to intermediate level users - will get you up and running with MariaDB, even if you've never used a database before. More information is available at: http://forta.com/books/0321799941/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "plugin-load=feedback.so" to your my.cnf file! On Windows, add "feedback=ON" to your my.ini file, or click the checkbox during the installation of the MSI package. See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: https://bugs.launchpad.net/maria - - Where else to find us - - - - - - - - - - - - - - - - - - - - - - - We're on Facebook: http://www.facebook.com/MariaDB.dbms We're on Twitter: http://twitter.com/#!/mariadb We're on Google Plus: http://gplus.to/mariadb We hope you enjoy MariaDB! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] MariaDB 5.3.6 now available
by Daniel Bartholomew 09 Apr '12

09 Apr '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.3.6. This is a stable (GA) release. It includes MySQL 5.1.62, some performance improvements, and several bug fixes. Most importantly, MariaDB 5.3.6 includes a fix for a bug which, under certain rare circumstances, allowed a user to connect with an invalid password. This is a serious security issue. We recommend upgrading from older versions as soon as possible. - - MariaDB 5.3 Links - - - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-536-release-notes Changelog: http://kb.askmonty.org/en/mariadb-536-changelog Downloads: http://downloads.askmonty.org/mariadb/5.3.6 .deb Repositories: http://downloads.askmonty.org/mariadb/repositories/ Overview of MariaDB 5.3: http://kb.askmonty.org/en/what-is-mariadb-53 - - SkySQL and MariaDB: Solutions Day - - - - - - - - - - - - - - - - - We'll be co-hosting the the "SkySQL & MariaDB: Solutions Day for the MySQL® Database" one day event on 13 April, 2012, at the Hyatt Regency Santa Clara. During this event, attendees will receive free, hands-on training and consulting on MariaDB and MySQL® database solutions from the experts at SkySQL, MariaDB, Continuent, ScaleDB, Severalnines, Sphinx, and Webyog, among others. SkySQL and MariaDB will bring together industry visionaries, including Michael (Monty) Widenius and David Axmark, the original authors of the MySQL database, to share their insights on current and future trends pertaining to the world's most popular open source database. To learn more about this free event, visit: http://www.skysql.com/events/mysql-solutions-day The schedule for the event is here: http://www.skysql.com/events/mysql-solutions-day/schedule Attendees are also invited to participate in Drizzle Day - a parallel event co-hosted by SkySQL, Percona, and the Drizzle Development Team, featuring tutorials on the Drizzle database. - - MariaDB Crash Course - - - - - - - - - - - - - - - - - - - - - - - The MariaDB-specific book, MariaDB Crash Course, by Ben Forta, is an excellent way to learn more about MariaDB. This book - for beginner to intermediate level users - will get you up and running with MariaDB, even if you've never used a database before. More information is available at: http://forta.com/books/0321799941/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "plugin-load=feedback.so" to your my.cnf file! On Windows, add "feedback=ON" to your my.ini file, or click the checkbox during the installation of the MSI package. See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: https://bugs.launchpad.net/maria - - Where else to find us - - - - - - - - - - - - - - - - - - - - - - - We're on Facebook: http://www.facebook.com/MariaDB.dbms We're on Twitter: http://twitter.com/#!/mariadb We're on Google Plus: http://gplus.to/mariadb We hope you enjoy MariaDB! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] MariaDB 5.1.62 and 5.2.12 now available
by Daniel Bartholomew 06 Apr '12

06 Apr '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.1.62 and 5.2.12. Both of these are stable (RC) releases and include MySQL 5.1.62 and several bug fixes. Most importantly, MariaDB 5.1.62 and 5.2.12 include a fix for a bug that under certain rare circumstances allowed a user to connect with an invalid password. This is a serious security issue. We recommend upgrading from older versions as soon as possible. - - MariaDB 5.1.62 Links - - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-5162-release-notes Changelog: http://kb.askmonty.org/en/mariadb-5162-changelog Downloads: http://downloads.askmonty.org/mariadb/5.1.62 .deb Repositories: http://downloads.askmonty.org/mariadb/repositories/ Overview of MariaDB 5.1: http://kb.askmonty.org/en/what-is-mariadb-51 - - MariaDB 5.2.12 Links - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-5212-release-notes Changelog: http://kb.askmonty.org/en/mariadb-5212-changelog Downloads: http://downloads.askmonty.org/mariadb/5.2.12 .deb Repositories: http://downloads.askmonty.org/mariadb/repositories/ Overview of MariaDB 5.2: http://kb.askmonty.org/en/what-is-mariadb-52 - - SkySQL and MariaDB: Solutions Day - - - - - - - - - - - - - - - - - We'll be co-hosting the the "SkySQL & MariaDB: Solutions Day for the MySQL® Database" one day event on 13 April, 2012, at the Hyatt Regency Santa Clara. During this event, attendees will receive free, hands-on training and consulting on MariaDB and MySQL® database solutions from the experts at SkySQL, MariaDB, Continuent, ScaleDB, Severalnines, Sphinx, and Webyog, among others. SkySQL and MariaDB will bring together industry visionaries, including Michael (Monty) Widenius and David Axmark, the original authors of the MySQL database, to share their insights on current and future trends pertaining to the world's most popular open source database. To learn more about this free event, visit: http://www.skysql.com/events/mysql-solutions-day The schedule for the event is here: http://www.skysql.com/events/mysql-solutions-day/schedule Attendees are also invited to participate in Drizzle Day - a parallel event co-hosted by SkySQL, Percona, and the Drizzle Development Team, featuring tutorials on the Drizzle database. - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "plugin-load=feedback.so" to your my.cnf file! On Windows, add "feedback=ON" to your my.ini file, or click the checkbox during the installation of the MSI package. See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: https://bugs.launchpad.net/maria - - Where else to find us - - - - - - - - - - - - - - - - - - - - - - - We're on Facebook: http://www.facebook.com/MariaDB.dbms We're on Twitter: http://twitter.com/#!/mariadb We're on Google Plus: http://gplus.to/mariadb We hope you enjoy MariaDB! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 1

[Maria-discuss] MariaDB 5.1.61 and 5.2.11 now available
by Daniel Bartholomew 02 Apr '12

02 Apr '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.1.61 and 5.2.11. Both of these are stable (RC) releases and include MySQL 5.1.61 and several bug fixes. Please see the "What is MariaDB 5.1" page for an overview of MariaDB 5.1: http://kb.askmonty.org/en/what-is-mariadb-51 Please see the "What is MariaDB 5.2" page for an overview of MariaDB 5.2: http://kb.askmonty.org/en/what-is-mariadb-52 - - MariaDB 5.1.61 Release Notes, Changelog, Downloads - - - - - - - The release notes for MariaDB 5.1.61 are available at: http://kb.askmonty.org/en/mariadb-5161-release-notes A changelog for this release is available at: http://kb.askmonty.org/en/mariadb-5161-changelog Sources, binaries and packages can be downloaded from: http://downloads.askmonty.org/mariadb/5.1.61 - - MariaDB 5.2.11 Release Notes, Changelog, Downloads - - - - - - - The release notes for MariaDB 5.2.11 are available at: http://kb.askmonty.org/en/mariadb-5211-release-notes A changelog for this release is available at: http://kb.askmonty.org/en/mariadb-5211-changelog Sources, binaries and packages can be downloaded from: http://downloads.askmonty.org/mariadb/5.2.11 Debian and Ubuntu packages for both releases are available from our mirrored apt repositories. A sources.list generator can be found at: http://downloads.askmonty.org/mariadb/repositories/ - - SkySQL and MariaDB: Solutions Day - - - - - - - - - - - - - - - - - We'll be co-hosting the the "SkySQL & MariaDB: Solutions Day for the MySQL® Database" one day event on 13 April, 2012, at the Hyatt Regency Santa Clara. During this event, attendees will receive free, hands-on training and consulting on MariaDB and MySQL® database solutions from the experts at SkySQL, MariaDB, Continuent, ScaleDB, Severalnines, Sphinx, and Webyog, among others. SkySQL and MariaDB will bring together industry visionaries, including Michael (Monty) Widenius and David Axmark, the original authors of the MySQL database, to share their insights on current and future trends pertaining to the world's most popular open source database. To learn more about this free event, visit http://www.skysql.com/events/mysql-solutions-day The schedule for the event is here: http://www.skysql.com/events/mysql-solutions-day/schedule Attendees are also invited to participate in Drizzle Day - a parallel event co-hosted by SkySQL, Percona, and the Drizzle Development Team, featuring tutorials on the Drizzle database. - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "plugin-load=feedback.so" to your my.cnf file! On Windows, add "feedback=ON" to your my.ini file, or click the checkbox during the installation of the MSI package. See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: https://bugs.launchpad.net/maria - - Where else to find us - - - - - - - - - - - - - - - - - - - - - - - We're on Facebook: http://www.facebook.com/MariaDB.dbms We're on Twitter: http://twitter.com/#!/mariadb We're on Google Plus: http://gplus.to/mariadb We hope you enjoy MariaDB! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0