- discuss - lists.mariadb.org

[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

[Maria-discuss] Test failure with 5.5.22 on plugins.unix_socket
by Brian Evans 30 Mar '12

30 Mar '12

I'm getting a strange error with 5.5.22 (and 5.5.21) in the test runs. plugins.unix_socket [ fail ] Test ended at 2012-03-30 11:16:46 CURRENT_TEST: plugins.unix_socket mysqltest: At line 15: Can't initialize replace from 'replace_result $USER USER' The result from queries just before the failure was: install plugin unix_socket soname 'auth_socket.so'; # # with named user # Is this a test program issue? Brian

2 2

[Maria-discuss] MariaDB 5.5.22 release candidate now available
by Daniel Bartholomew 30 Mar '12

30 Mar '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.22 release candidate (RC). MariaDB 5.5.22 is the first RC release in the 5.5 series. We hope to follow it up soon with a stable (GA) 5.5 release. Please test this release thoroughly! This is the third 5.5-based release. The MariaDB 5.5 series is the combination of MariaDB 5.3 and MySQL 5.5 with a few extra features and bug fixes. Please read the "What is MariaDB 5.5" page for an overview: http://kb.askmonty.org/en/what-is-mariadb-55 - - MariaDB 5.5.22 RC Release Notes, Changelog, Downloads - - - - - - - The release notes for MariaDB 5.5.22 RC are available at: http://kb.askmonty.org/en/mariadb-5522-release-notes A changelog for this release is available at: http://kb.askmonty.org/en/mariadb-5522-changelog Sources, binaries and packages can be downloaded from: http://downloads.askmonty.org/mariadb/5.5.22/ Debian and Ubuntu packages are available from our mirrored apt repositories. A sources.list generator can be found at: http://downloads.askmonty.org/mariadb/repositories/ - - About MariaDB 5.5 - - - - - - - - - - - - - - - - - - - - - - - - - The MariaDB 5.5 series is the combination of MariaDB 5.3 and MySQL 5.5. Please read the "What is MariaDB 5.5" page for details: 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. - - 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] Blog post: What about the subqueries?
by Colin Charles 30 Mar '12

30 Mar '12

Hi! This came up on my radar: http://mysqlmaniac.com/2012/what-about-the-subqueries/ MariaDB does wonderfully for Q1, but not so well for Q2 on some specific queries. These were made with the MediaWiki extension called DynamicPageList (http://www.mediawiki.org/wiki/Extension:DynamicPageList_%28third-party%29) -- Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: colincharles MariaDB: Community developed. Feature enhanced. Backward compatible. Download it at: http://www.mariadb.org/ Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/

1 0

Re: [Maria-discuss] Compiling 5.5.20 on OS X
by Richard Dunn 27 Mar '12

27 Mar '12

Hi Colin, I actually get a little farther along (83% instead of 77%), but it looks like we're failing at the same spot -- Linking CXX executable ma_pagecache_consist_1k-t [ 83%] Building C object storage/maria/unittest/CMakeFiles/ma_control_file-t.dir/ma_control_file-t.c.o Linking CXX executable ma_control_file-t [ 83%] Built target ma_control_file-t Scanning dependencies of target ma_pagecache_consist_1k-t [ 83%] Building C object storage/maria/unittest/CMakeFiles/ma_pagecache_consist_1k-t.dir/ma_pagecache_consist.c.o [ 83%] Building C object storage/maria/unittest/CMakeFiles/ma_pagecache_consist_1k-t.dir/test_file.c.o 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 collect2: ld returned 1 exit status make[2]: *** [storage/maria/unittest/ma_pagecache_consist_1k-t] Error 1 make[1]: *** [storage/maria/unittest/CMakeFiles/ma_pagecache_consist_1k-t.dir/all] Error 2 make: *** [all] Error 2 Richard On Mar 27, 2012, at 04:52 , Colin Charles wrote: > Hi! > > On 17 Mar 2012, at 19:21, Richard Dunn wrote: > >> Same problem with MariaDB 5.5.21... >> > > Is this what you see currently? Produced this using 5.5.21 using BUILD/compile-pentium64-max > > [ 77%] Building C object storage/maria/unittest/CMakeFiles/ma_pagecache_consist_64k-t.dir/test_file.c.o > Linking CXX executable ma_pagecache_consist_1kRD-t > Linking CXX executable ma_pagecache_consist_1kWR-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 > collect2: ld returned 1 exit status > 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 > collect2: ld returned 1 exit status > make[2]: *** [storage/maria/unittest/ma_pagecache_consist_1kRD-t] Error 1 > make[1]: *** [storage/maria/unittest/CMakeFiles/ma_pagecache_consist_1kRD-t.dir/all] Error 2 > make[2]: *** [storage/maria/unittest/ma_pagecache_consist_1kWR-t] Error 1 > make[1]: *** [storage/maria/unittest/CMakeFiles/ma_pagecache_consist_1kWR-t.dir/all] Error 2 > Linking CXX executable ma_pagecache_consist_64k-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 > collect2: ld returned 1 exit status > make[2]: *** [storage/maria/unittest/ma_pagecache_consist_64k-t] Error 1 > make[1]: *** [storage/maria/unittest/CMakeFiles/ma_pagecache_consist_64k-t.dir/all] Error 2 > [ 88%] Built target sql > make: *** [all] Error 2 > > >> >> On Mar 4, 2012, at 07:53 , Richard Dunn wrote: >> >>> 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? >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~maria-discuss >> Post to : maria-discuss(a)lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp > > -- > Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: colincharles > MariaDB: Community developed. Feature enhanced. Backward compatible. > Download it at: http://www.mariadb.org/ > Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/ >

1 0