[Maria-discuss] MariaDB 10.0.15 now available
The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.15
This is a Stable (GA) release. See the Release Notes and Changelog for details.
- - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
MariaDB 10.0.15 - Release Notes: https://mariadb.com/kb/en/mariadb-10015-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10015-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.15
About MariaDB 10.0: - https://mariadb.com/kb/en/what-is-mariadb-100/
APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/
- - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - -
There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at:
- https://mariadb.com/news-events/webinars
- - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - -
There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links:
- https://mariadb.com/kb/en/mariadb/books/
- - 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 "feedback=ON" to your my.cnf or my.ini file!
See http://mariadb.com/kb/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:
- - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - -
If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation.
- https://mariadb.com/kb/en/contributing
- https://mariadb.org/en/donate/
- http://www.cafepress.com/mariadb
We hope you enjoy MariaDB!
-- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb
I *CERTAINLY* think this https://downloads.mariadb.org/mariadb/repositories/#mirror=23Media&versi... is premature taken this discussion into account!
And I believe this "You will also be prompted about a conflict between openSUSE's own MariaDB 5.5 client package and the MariaDB client package" is wrong. It may be correct for 12.2 but 12.3 does not have the MariaDB 5.5 client package. It had 10.0.13 (and I think also some client package from Oracle - probably for some compability reason.
What about the conflicts on OpenSuSE 12.3 *1) with KDE and *2) with MariaDB 10.0.13 as installed from the distro DVD?
-- Peter
On Tue, Nov 25, 2014 at 5:17 PM, Daniel Bartholomew dbart@mariadb.com wrote:
The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.15
This is a Stable (GA) release. See the Release Notes and Changelog for details.
- - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
MariaDB 10.0.15 - Release Notes: https://mariadb.com/kb/en/mariadb-10015-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10015-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.15
About MariaDB 10.0: - https://mariadb.com/kb/en/what-is-mariadb-100/
APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/
- - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - -
There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at:
- https://mariadb.com/news-events/webinars
- - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - -
There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links:
- https://mariadb.com/kb/en/mariadb/books/
- - 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 "feedback=ON" to your my.cnf or my.ini file!
See http://mariadb.com/kb/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:
- - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - -
If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation.
- https://mariadb.com/kb/en/contributing
- https://mariadb.org/en/donate/
- http://www.cafepress.com/mariadb
We hope you enjoy MariaDB!
-- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Hi, Daniel!
Perhaps we should put a note for every new platform that we add (was CentOS 7, now it's openSUSE) that this is a new platform, just added, a first release for it, so while binaries are same as everywhere and stable, the packaging (conflicts, dependencies) is new and might have some rough edges?
Peter, I've created MDEV-7211 for this issue to make sure it won't be forgotten.
Regards, Sergei
On Nov 25, Peter Laursen wrote:
I *CERTAINLY* think this https://downloads.mariadb.org/mariadb/repositories/#mirror=23Media&versi... is premature taken this discussion into account!
And I believe this "You will also be prompted about a conflict between openSUSE's own MariaDB 5.5 client package and the MariaDB client package" is wrong. It may be correct for 12.2 but 12.3 does not have the MariaDB 5.5 client package. It had 10.0.13 (and I think also some client package from Oracle - probably for some compability reason.
What about the conflicts on OpenSuSE 12.3 *1) with KDE and *2) with MariaDB 10.0.13 as installed from the distro DVD?
-- Peter
OK! :-)
I'll summarize the points as I see them.
1) document what must be removed in advance if MySQL was installed with the distro CD/DVD and/or offficial repo's of the distro. 2) figure out the problem with KDE and take a decision if this will be fixed or not (I think it will be difficult) 3) expose packages installed in "rpm -qa" command 4) support activating/deactivating and starting/stopping service from YaST "Service Management" GUI.
(and please add TokuDB and InfiniDB soon. ¨'playing around' with TokuDB was my primary motivation for all this)
-- Peter
On Wed, Nov 26, 2014 at 9:38 AM, Sergei Golubchik serg@mariadb.org wrote:
Hi, Daniel!
Perhaps we should put a note for every new platform that we add (was CentOS 7, now it's openSUSE) that this is a new platform, just added, a first release for it, so while binaries are same as everywhere and stable, the packaging (conflicts, dependencies) is new and might have some rough edges?
Peter, I've created MDEV-7211 for this issue to make sure it won't be forgotten.
Regards, Sergei
On Nov 25, Peter Laursen wrote:
I *CERTAINLY* think this
https://downloads.mariadb.org/mariadb/repositories/#mirror=23Media&versi...
is premature taken this discussion into account!
And I believe this "You will also be prompted about a conflict between openSUSE's own MariaDB 5.5 client package and the MariaDB client package" is wrong. It may be correct for 12.2 but 12.3 does not have the MariaDB
5.5
client package. It had 10.0.13 (and I think also some client package from Oracle - probably for some compability reason.
What about the conflicts on OpenSuSE 12.3 *1) with KDE and *2) with
MariaDB
10.0.13 as installed from the distro DVD?
-- Peter
Additionally this https://downloads.mariadb.org/mariadb/repositories/#mirror=23Media&versi... oly descirebsan option to add the repository from command line. YasT GUI has an entry for "software repositories".
Please *do not think command-line* (or not only) . SuSE users often don't! For some people the primary reason to use SuSE is that it has a very strong GUI for managing the system. You can manage SuSE 95% without command line at all.
-- Peter
On Wed, Nov 26, 2014 at 10:12 AM, Peter Laursen peter_laursen@webyog.com wrote:
OK! :-)
I'll summarize the points as I see them.
1) document what must be removed in advance if MySQL was installed with the distro CD/DVD and/or offficial repo's of the distro. 2) figure out the problem with KDE and take a decision if this will be fixed or not (I think it will be difficult) 3) expose packages installed in "rpm -qa" command 4) support activating/deactivating and starting/stopping service from YaST "Service Management" GUI.
(and please add TokuDB and InfiniDB soon. ¨'playing around' with TokuDB was my primary motivation for all this)
-- Peter
On Wed, Nov 26, 2014 at 9:38 AM, Sergei Golubchik serg@mariadb.org wrote:
Hi, Daniel!
Perhaps we should put a note for every new platform that we add (was CentOS 7, now it's openSUSE) that this is a new platform, just added, a first release for it, so while binaries are same as everywhere and stable, the packaging (conflicts, dependencies) is new and might have some rough edges?
Peter, I've created MDEV-7211 for this issue to make sure it won't be forgotten.
Regards, Sergei
On Nov 25, Peter Laursen wrote:
I *CERTAINLY* think this
https://downloads.mariadb.org/mariadb/repositories/#mirror=23Media&versi...
is premature taken this discussion into account!
And I believe this "You will also be prompted about a conflict between openSUSE's own MariaDB 5.5 client package and the MariaDB client
package"
is wrong. It may be correct for 12.2 but 12.3 does not have the MariaDB
5.5
client package. It had 10.0.13 (and I think also some client package
from
Oracle - probably for some compability reason.
What about the conflicts on OpenSuSE 12.3 *1) with KDE and *2) with
MariaDB
10.0.13 as installed from the distro DVD?
-- Peter
Hi, Peter!
On Nov 26, Peter Laursen wrote:
(and please add TokuDB and InfiniDB soon. ¨'playing around' with TokuDB was my primary motivation for all this)
As far as I can see, tokudb is present in MariaDB-10.0.15-opensuse13_1-x86_64-server.rpm.
Did you install the plugin?
INSTALL SONAME 'ha_tokudb'
Regards, Sergei
NO.. I thought it would bea separate RPM (Like the OQGraph). I will check when I get time. it coudl take a day or two now. Sorry for false alarm.
ButSuSE should be listed here https://mariadb.com/kb/en/mariadb/documentation/storage-engines/tokudb/how-t... then, right?
-- Peter
On Wed, Nov 26, 2014 at 12:12 PM, Sergei Golubchik serg@mariadb.org wrote:
Hi, Peter!
On Nov 26, Peter Laursen wrote:
(and please add TokuDB and InfiniDB soon. ¨'playing around' with TokuDB
was
my primary motivation for all this)
As far as I can see, tokudb is present in MariaDB-10.0.15-opensuse13_1-x86_64-server.rpm.
Did you install the plugin?
INSTALL SONAME 'ha_tokudb'
Regards, Sergei
Please read https://en.opensuse.org/SDB:Add_package_repositories on how to add a software repository to Suse (commandline "zypper ar -f <URL> <alias>"). Updating the file /etc/zypp/repos.d/ manually may wrk - but I am not perfectly convinced that it will not cause problems if you later want to use zypper command or GUI.
-- Peter
On Wed, Nov 26, 2014 at 12:37 PM, Peter Laursen peter_laursen@webyog.com wrote:
NO.. I thought it would bea separate RPM (Like the OQGraph). I will check when I get time. it coudl take a day or two now. Sorry for false alarm.
ButSuSE should be listed here https://mariadb.com/kb/en/mariadb/documentation/storage-engines/tokudb/how-t... then, right?
-- Peter
On Wed, Nov 26, 2014 at 12:12 PM, Sergei Golubchik serg@mariadb.org wrote:
Hi, Peter!
On Nov 26, Peter Laursen wrote:
(and please add TokuDB and InfiniDB soon. ¨'playing around' with TokuDB
was
my primary motivation for all this)
As far as I can see, tokudb is present in MariaDB-10.0.15-opensuse13_1-x86_64-server.rpm.
Did you install the plugin?
INSTALL SONAME 'ha_tokudb'
Regards, Sergei
Hi, Peter!
On Nov 26, Peter Laursen wrote:
NO.. I thought it would bea separate RPM (Like the OQGraph). I will check when I get time. it coudl take a day or two now. Sorry for false alarm.
As a general rule we put in separage packages plugins that require additional dependencies. OQGraph requires libJudy, so if one doesn't use OQGraph, she shouldn't be required to install libJudy. CONNECT needs odbc, xml, etc. TokuDB doesn't bring in extra dependencies, so it's included into the server package.
ButSuSE should be listed here https://mariadb.com/kb/en/mariadb/documentation/storage-engines/tokudb/how-t... then, right?
Added, thanks.
Regards, Sergei
If TokuDB has no dependencies, that the server does not have, why is it then not available on Windows? If it is, then Windows should be listed on same page.
-- Peter
On Wed, Nov 26, 2014 at 1:30 PM, Sergei Golubchik serg@mariadb.org wrote:
Hi, Peter!
On Nov 26, Peter Laursen wrote:
NO.. I thought it would bea separate RPM (Like the OQGraph). I will check when I get time. it coudl take a day or two now. Sorry for false alarm.
As a general rule we put in separage packages plugins that require additional dependencies. OQGraph requires libJudy, so if one doesn't use OQGraph, she shouldn't be required to install libJudy. CONNECT needs odbc, xml, etc. TokuDB doesn't bring in extra dependencies, so it's included into the server package.
ButSuSE should be listed here
https://mariadb.com/kb/en/mariadb/documentation/storage-engines/tokudb/how-t...
then, right?
Added, thanks.
Regards, Sergei
OK .. but did the TokuDB guys ever try to figure out why?
It could be a good idea to do. Because if it fails with Visual Studio, it may fail with other compilers as well. GCC is only one compiler and not the most standards-compliant as far as I understand.
-- Peter
On Wed, Nov 26, 2014 at 4:02 PM, Sergei Golubchik serg@mariadb.org wrote:
Hi, Peter!
On Nov 26, Peter Laursen wrote:
If TokuDB has no dependencies, that the server does not have, why is it then not available on Windows? If it is, then Windows should be listed on same page.
It doesn't compile on Windows, as far as I understand.
Regards, Sergei
One more thing I thought of.
I wrote ""Updating the file /etc/zypp/repos.d/ manually may work,but .. ". If SuSE runs on btrfs file system (what is default from 12.3 - and it works like a charm for me), I believe a file system snapshot will not be created if you edit the file as you describe it. Using zypper command or YaST GUI will generate a snapshot and you can revert to it with the "Snapper" application.
- Peter
On Wed, Nov 26, 2014 at 4:36 PM, Peter Laursen peter_laursen@webyog.com wrote:
OK .. but did the TokuDB guys ever try to figure out why?
It could be a good idea to do. Because if it fails with Visual Studio, it may fail with other compilers as well. GCC is only one compiler and not the most standards-compliant as far as I understand.
-- Peter
On Wed, Nov 26, 2014 at 4:02 PM, Sergei Golubchik serg@mariadb.org wrote:
Hi, Peter!
On Nov 26, Peter Laursen wrote:
If TokuDB has no dependencies, that the server does not have, why is it then not available on Windows? If it is, then Windows should be listed
on
same page.
It doesn't compile on Windows, as far as I understand.
Regards, Sergei
Was there some fixes to the repo? Something has improved, I think!
I can now install as a GUI user would (adding the repo to Yast's GUI interface for 'software repositories' and next search the packages with Yast 'Software Management' GUI). Conflicts with native SuSE MariaDB 10.0.13 packages are now detected and resolved. Some imperfections still though:
* I needed to restart the OS in order to start the server. Only after that it appears in the 'Service management' GUI (and server can be managed from there now) * Packages are still not listed by "rpm -qa" command * I could only use commandline clients as root. Only mysql:mysql had privileges to access them. Fixed by adding read privilege for all users.
But most important TokuDB plugin does not load. This may because this is SuSE 12.3 (that may ship with another C-runtime etc. than what 12.1 and 12.2 did). INSTALL SONAME 'ha_tokudb'; -- Error Code: 1123 -- Can't initialize function 'TokuDB'; Plugin initialization function failed.
If I add INSTALL SONAME .. to configuration the server will not start.
BTW: I also had some communication on Fedora's mailinglist. They have MariaDB 10.0.14 in Fedora 21 repos. But without TokuDB. They cannot build it. They have reported to MariaDB (they say).
-Peter
On Wed, Nov 26, 2014 at 4:43 PM, Peter Laursen peter_laursen@webyog.com wrote:
One more thing I thought of.
I wrote ""Updating the file /etc/zypp/repos.d/ manually may work,but .. ". If SuSE runs on btrfs file system (what is default from 12.3 - and it works like a charm for me), I believe a file system snapshot will not be created if you edit the file as you describe it. Using zypper command or YaST GUI will generate a snapshot and you can revert to it with the "Snapper" application.
- Peter
On Wed, Nov 26, 2014 at 4:36 PM, Peter Laursen peter_laursen@webyog.com wrote:
OK .. but did the TokuDB guys ever try to figure out why?
It could be a good idea to do. Because if it fails with Visual Studio, it may fail with other compilers as well. GCC is only one compiler and not the most standards-compliant as far as I understand.
-- Peter
On Wed, Nov 26, 2014 at 4:02 PM, Sergei Golubchik serg@mariadb.org wrote:
Hi, Peter!
On Nov 26, Peter Laursen wrote:
If TokuDB has no dependencies, that the server does not have, why is it then not available on Windows? If it is, then Windows should be listed
on
same page.
It doesn't compile on Windows, as far as I understand.
Regards, Sergei
Hi, Peter!
On Dec 09, Peter Laursen wrote:
But most important TokuDB plugin does not load. This may because this is SuSE 12.3 (that may ship with another C-runtime etc. than what 12.1 and 12.2 did). INSTALL SONAME 'ha_tokudb'; -- Error Code: 1123 -- Can't initialize function 'TokuDB'; Plugin initialization function failed.
See the error log, it might contain more specific error messages. One probable reason could be transparent_hugepage enabled on your computer.
BTW: I also had some communication on Fedora's mailinglist. They have MariaDB 10.0.14 in Fedora 21 repos. But without TokuDB. They cannot build it. They have reported to MariaDB (they say).
Yes, there were issues with TokuDB and gcc 4.9 (MDEV-6446, MDEV-6449), but they were fixed.
And there was binutils bug in Fedora (it resulted in crashes when compiling TokuDB): https://bugzilla.redhat.com/show_bug.cgi?id=1149660 As far as I understand, it's also fixed by now.
Regards, Sergei
It seems they are not yet in the RPMs of the MariaDB repo for OpenSuSE. At least they were not 5-6 hours ago. But I am not in a hurry.
-- Peter
On Tue, Dec 9, 2014 at 2:41 PM, Sergei Golubchik serg@mariadb.org wrote:
Hi, Peter!
On Dec 09, Peter Laursen wrote:
But most important TokuDB plugin does not load. This may because this is SuSE 12.3 (that may ship with another C-runtime etc. than what 12.1 and 12.2 did). INSTALL SONAME 'ha_tokudb'; -- Error Code: 1123 -- Can't initialize function 'TokuDB'; Plugin initialization function failed.
See the error log, it might contain more specific error messages. One probable reason could be transparent_hugepage enabled on your computer.
BTW: I also had some communication on Fedora's mailinglist. They have MariaDB 10.0.14 in Fedora 21 repos. But without TokuDB. They cannot
build
it. They have reported to MariaDB (they say).
Yes, there were issues with TokuDB and gcc 4.9 (MDEV-6446, MDEV-6449), but they were fixed.
And there was binutils bug in Fedora (it resulted in crashes when compiling TokuDB): https://bugzilla.redhat.com/show_bug.cgi?id=1149660 As far as I understand, it's also fixed by now.
Regards, Sergei
You were right .. error log snippet:
Transparent huge pages are enabled, according to /sys/kernel/mm/transparent_hugepage/enabled 141209 12:26:00 [ERROR] TokuDB: Huge pages are enabled, disable them before continuing
141209 12:26:00 [ERROR] ************************************************************ 141209 12:26:00 [ERROR]
141209 12:26:00 [ERROR] @@@@@@@@@@@
141209 12:26:00 [ERROR] @@' '@@
141209 12:26:00 [ERROR] @@ _ _ @@
141209 12:26:00 [ERROR] | (.) (.) |
141209 12:26:00 [ERROR] | ` |
141209 12:26:00 [ERROR] | > ' |
141209 12:26:00 [ERROR] | .----. |
141209 12:26:00 [ERROR] .. |.----.| ..
141209 12:26:00 [ERROR] .. ' ' ..
141209 12:26:00 [ERROR] .._______,.
141209 12:26:00 [ERROR]
141209 12:26:00 [ERROR] TokuDB will not run with transparent huge pages enabled. 141209 12:26:00 [ERROR] Please disable them to continue.
141209 12:26:00 [ERROR] (echo never > /sys/kernel/mm/transparent_hugepage/enabled) 141209 12:26:00 [ERROR]
141209 12:26:00 [ERROR] ************************************************************ 141209 12:26:00 [ERROR] Plugin 'TokuDB' init function returned error. 141209 12:26:00 [ERROR] Plugin 'TokuDB' registration as a STORAGE ENGINE failed. 141209 12:35:03 [Note] /usr/sbin/mysqld: Normal shutdown
141209 12:35:03 [Note] Event Scheduler: Purging the queue. 0 events 141209 12:35:03 [Note] InnoDB: FTS optimize thread exiting. 141209 12:35:03 [Note] InnoDB: Starting shutdown... 141209 12:35:04 [Note] InnoDB: Shutdown completed; log sequence number 1617333 141209 12:35:04 [Note] /usr/sbin/mysqld: Shutdown complete
I found this https://mariadb.com/kb/en/mariadb/documentation/storage-engines/tokudb/how-t... and after
linux-hwpu:/home/peter # echo never > /sys/kernel/mm/transparent_hugepage/enabled linux-hwpu:/home/peter # echo never > /sys/kernel/mm/transparent_hugepage/defrag
(and next from any MySQL client as root) INSTALL SONAME 'ha_tokudb'; SHOW WARNINGS; -- Warning 1105 Cannot enable tc-log at run-time. XA features of TokuDB are disabled (so I will need to add it during boot as the link also describes) SHOW ENGINES;--and it *IS* there NOW.
-- Peter
On Tue, Dec 9, 2014 at 2:46 PM, Peter Laursen peter_laursen@webyog.com wrote:
It seems they are not yet in the RPMs of the MariaDB repo for OpenSuSE. At least they were not 5-6 hours ago. But I am not in a hurry.
-- Peter
On Tue, Dec 9, 2014 at 2:41 PM, Sergei Golubchik serg@mariadb.org wrote:
Hi, Peter!
On Dec 09, Peter Laursen wrote:
But most important TokuDB plugin does not load. This may because this is SuSE 12.3 (that may ship with another C-runtime etc. than what 12.1 and 12.2 did). INSTALL SONAME 'ha_tokudb'; -- Error Code: 1123 -- Can't initialize function 'TokuDB'; Plugin initialization function failed.
See the error log, it might contain more specific error messages. One probable reason could be transparent_hugepage enabled on your computer.
BTW: I also had some communication on Fedora's mailinglist. They have MariaDB 10.0.14 in Fedora 21 repos. But without TokuDB. They cannot
build
it. They have reported to MariaDB (they say).
Yes, there were issues with TokuDB and gcc 4.9 (MDEV-6446, MDEV-6449), but they were fixed.
And there was binutils bug in Fedora (it resulted in crashes when compiling TokuDB): https://bugzilla.redhat.com/show_bug.cgi?id=1149660 As far as I understand, it's also fixed by now.
Regards, Sergei
Please ignore my post starting "It seems they are not yet .." -- Peter
On Tue, Dec 9, 2014 at 3:18 PM, Peter Laursen peter_laursen@webyog.com wrote:
You were right .. error log snippet:
Transparent huge pages are enabled, according to /sys/kernel/mm/transparent_hugepage/enabled 141209 12:26:00 [ERROR] TokuDB: Huge pages are enabled, disable them before continuing
141209 12:26:00 [ERROR] ************************************************************ 141209 12:26:00 [ERROR]
141209 12:26:00 [ERROR] @@@@@@@@@@@
141209 12:26:00 [ERROR] @@' '@@
141209 12:26:00 [ERROR] @@ _ _ @@
141209 12:26:00 [ERROR] | (.) (.) |
141209 12:26:00 [ERROR] | ` |
141209 12:26:00 [ERROR] | > ' |
141209 12:26:00 [ERROR] | .----. |
141209 12:26:00 [ERROR] .. |.----.| ..
141209 12:26:00 [ERROR] .. ' ' ..
141209 12:26:00 [ERROR] .._______,.
141209 12:26:00 [ERROR]
141209 12:26:00 [ERROR] TokuDB will not run with transparent huge pages enabled. 141209 12:26:00 [ERROR] Please disable them to continue.
141209 12:26:00 [ERROR] (echo never > /sys/kernel/mm/transparent_hugepage/enabled) 141209 12:26:00 [ERROR]
141209 12:26:00 [ERROR] ************************************************************ 141209 12:26:00 [ERROR] Plugin 'TokuDB' init function returned error. 141209 12:26:00 [ERROR] Plugin 'TokuDB' registration as a STORAGE ENGINE failed. 141209 12:35:03 [Note] /usr/sbin/mysqld: Normal shutdown
141209 12:35:03 [Note] Event Scheduler: Purging the queue. 0 events 141209 12:35:03 [Note] InnoDB: FTS optimize thread exiting. 141209 12:35:03 [Note] InnoDB: Starting shutdown... 141209 12:35:04 [Note] InnoDB: Shutdown completed; log sequence number 1617333 141209 12:35:04 [Note] /usr/sbin/mysqld: Shutdown complete
I found this
https://mariadb.com/kb/en/mariadb/documentation/storage-engines/tokudb/how-t... and after
linux-hwpu:/home/peter # echo never > /sys/kernel/mm/transparent_hugepage/enabled linux-hwpu:/home/peter # echo never > /sys/kernel/mm/transparent_hugepage/defrag
(and next from any MySQL client as root) INSTALL SONAME 'ha_tokudb'; SHOW WARNINGS; -- Warning 1105 Cannot enable tc-log at run-time. XA features of TokuDB are disabled (so I will need to add it during boot as the link also describes) SHOW ENGINES;--and it *IS* there NOW.
-- Peter
On Tue, Dec 9, 2014 at 2:46 PM, Peter Laursen peter_laursen@webyog.com wrote:
It seems they are not yet in the RPMs of the MariaDB repo for OpenSuSE. At least they were not 5-6 hours ago. But I am not in a hurry.
-- Peter
On Tue, Dec 9, 2014 at 2:41 PM, Sergei Golubchik serg@mariadb.org wrote:
Hi, Peter!
On Dec 09, Peter Laursen wrote:
But most important TokuDB plugin does not load. This may because this
is
SuSE 12.3 (that may ship with another C-runtime etc. than what 12.1
and
12.2 did). INSTALL SONAME 'ha_tokudb'; -- Error Code: 1123 -- Can't initialize function 'TokuDB'; Plugin initialization function failed.
See the error log, it might contain more specific error messages. One probable reason could be transparent_hugepage enabled on your computer.
BTW: I also had some communication on Fedora's mailinglist. They have MariaDB 10.0.14 in Fedora 21 repos. But without TokuDB. They cannot
build
it. They have reported to MariaDB (they say).
Yes, there were issues with TokuDB and gcc 4.9 (MDEV-6446, MDEV-6449), but they were fixed.
And there was binutils bug in Fedora (it resulted in crashes when compiling TokuDB): https://bugzilla.redhat.com/show_bug.cgi?id=1149660 As far as I understand, it's also fixed by now.
Regards, Sergei
The page https://mariadb.com/kb/en/mariadb/documentation/storage-engines/tokudb/how-t...
.. should have added for SuSE "YAST2 -> Bootloader -> Kernel Parameters. Add transparent_hugepage=never to Optional Kernel Command Line Parameter at the end, like after "showopts" and press OK. And you're done. It'll take effect on the next reboot."
(according to the reply I had here https://forums.opensuse.org/showthread.php/503373-How-to-disable-Transparent... - I have not tried yet myself).
-- Peter
On Tue, Dec 9, 2014 at 3:21 PM, Peter Laursen peter_laursen@webyog.com wrote:
Please ignore my post starting "It seems they are not yet .." -- Peter
On Tue, Dec 9, 2014 at 3:18 PM, Peter Laursen peter_laursen@webyog.com wrote:
You were right .. error log snippet:
Transparent huge pages are enabled, according to /sys/kernel/mm/transparent_hugepage/enabled 141209 12:26:00 [ERROR] TokuDB: Huge pages are enabled, disable them before continuing
141209 12:26:00 [ERROR] ************************************************************ 141209 12:26:00 [ERROR]
141209 12:26:00 [ERROR] @@@@@@@@@@@
141209 12:26:00 [ERROR] @@' '@@
141209 12:26:00 [ERROR] @@ _ _ @@
141209 12:26:00 [ERROR] | (.) (.) |
141209 12:26:00 [ERROR] | ` |
141209 12:26:00 [ERROR] | > ' |
141209 12:26:00 [ERROR] | .----. |
141209 12:26:00 [ERROR] .. |.----.| ..
141209 12:26:00 [ERROR] .. ' ' ..
141209 12:26:00 [ERROR] .._______,.
141209 12:26:00 [ERROR]
141209 12:26:00 [ERROR] TokuDB will not run with transparent huge pages enabled. 141209 12:26:00 [ERROR] Please disable them to continue.
141209 12:26:00 [ERROR] (echo never > /sys/kernel/mm/transparent_hugepage/enabled) 141209 12:26:00 [ERROR]
141209 12:26:00 [ERROR] ************************************************************ 141209 12:26:00 [ERROR] Plugin 'TokuDB' init function returned error. 141209 12:26:00 [ERROR] Plugin 'TokuDB' registration as a STORAGE ENGINE failed. 141209 12:35:03 [Note] /usr/sbin/mysqld: Normal shutdown
141209 12:35:03 [Note] Event Scheduler: Purging the queue. 0 events 141209 12:35:03 [Note] InnoDB: FTS optimize thread exiting. 141209 12:35:03 [Note] InnoDB: Starting shutdown... 141209 12:35:04 [Note] InnoDB: Shutdown completed; log sequence number 1617333 141209 12:35:04 [Note] /usr/sbin/mysqld: Shutdown complete
I found this
https://mariadb.com/kb/en/mariadb/documentation/storage-engines/tokudb/how-t... and after
linux-hwpu:/home/peter # echo never > /sys/kernel/mm/transparent_hugepage/enabled linux-hwpu:/home/peter # echo never > /sys/kernel/mm/transparent_hugepage/defrag
(and next from any MySQL client as root) INSTALL SONAME 'ha_tokudb'; SHOW WARNINGS; -- Warning 1105 Cannot enable tc-log at run-time. XA features of TokuDB are disabled (so I will need to add it during boot as the link also describes) SHOW ENGINES;--and it *IS* there NOW.
-- Peter
On Tue, Dec 9, 2014 at 2:46 PM, Peter Laursen peter_laursen@webyog.com wrote:
It seems they are not yet in the RPMs of the MariaDB repo for OpenSuSE. At least they were not 5-6 hours ago. But I am not in a hurry.
-- Peter
On Tue, Dec 9, 2014 at 2:41 PM, Sergei Golubchik serg@mariadb.org wrote:
Hi, Peter!
On Dec 09, Peter Laursen wrote:
But most important TokuDB plugin does not load. This may because this
is
SuSE 12.3 (that may ship with another C-runtime etc. than what 12.1
and
12.2 did). INSTALL SONAME 'ha_tokudb'; -- Error Code: 1123 -- Can't initialize function 'TokuDB'; Plugin initialization function failed.
See the error log, it might contain more specific error messages. One probable reason could be transparent_hugepage enabled on your computer.
BTW: I also had some communication on Fedora's mailinglist. They have MariaDB 10.0.14 in Fedora 21 repos. But without TokuDB. They cannot
build
it. They have reported to MariaDB (they say).
Yes, there were issues with TokuDB and gcc 4.9 (MDEV-6446, MDEV-6449), but they were fixed.
And there was binutils bug in Fedora (it resulted in crashes when compiling TokuDB): https://bugzilla.redhat.com/show_bug.cgi?id=1149660 As far as I understand, it's also fixed by now.
Regards, Sergei
On 12/9/2014 11:01 AM, Peter Laursen wrote:
The page https://mariadb.com/kb/en/mariadb/documentation/storage-engines/tokudb/how-t...
.. should have added for SuSE "YAST2 -> Bootloader -> Kernel Parameters. Add transparent_hugepage=never to Optional Kernel Command Line Parameter at the end, like after "showopts" and press OK. And you're done. It'll take effect on the next reboot."
(according to the reply I had here https://forums.opensuse.org/showthread.php/503373-How-to-disable-Transparent... - I have not tried yet myself).
It already says: "To disable them, pass "transparent_hugepage=never" to the kernel in your bootloader (grub, lilo, etc.)."
You should know how to control your bootloader.
Brian
Thanks Peter, I've added this to the page.
On 12/09/2014 06:01 PM, Peter Laursen wrote:
The page https://mariadb.com/kb/en/mariadb/documentation/storage-engines/tokudb/how-t...
.. should have added for SuSE "YAST2 -> Bootloader -> Kernel Parameters. Add transparent_hugepage=never to Optional Kernel Command Line Parameter at the end, like after "showopts" and press OK. And you're done. It'll take effect on the next reboot."
@Brian .. your reply is just *noise*. It is complete irrelevant for all the people following this maililng list what you think, I should know. But it is not irrelevant to point to a docs/wiki page that needs an update, as I did.
-- Peter
On Tue, Dec 9, 2014 at 5:17 PM, Ian Gilfillan ian@mariadb.org wrote:
Thanks Peter, I've added this to the page.
On 12/09/2014 06:01 PM, Peter Laursen wrote:
The page https://mariadb.com/kb/en/mariadb/documentation/storage-engines/tokudb/how-t...
.. should have added for SuSE "YAST2 -> Bootloader -> Kernel Parameters. Add transparent_hugepage=never to Optional Kernel Command Line Parameter at the end, like after "showopts" and press OK. And you're done. It'll take effect on the next reboot."
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Am 09.12.2014 um 19:00 schrieb Peter Laursen:
@Brian .. your reply is just *noise*. It is complete irrelevant for all the people following this maililng list what you think, I should know
no it is not irrelevant what somebody thinks that's the purpose of a mailing-list at all
But it is not irrelevant to point to a docs/wiki page that needs an update, as I did.
On Tue, Dec 9, 2014 at 5:17 PM, Ian Gilfillan <ian@mariadb.org mailto:ian@mariadb.org> wrote:
Thanks Peter, I've added this to the page.
On 12/09/2014 06:01 PM, Peter Laursen wrote:
The page https://mariadb.com/kb/en/mariadb/documentation/storage-engines/tokudb/how-t...
.. should have added for SuSE "YAST2 -> Bootloader -> Kernel Parameters. Add transparent_hugepage=never to Optional Kernel Command Line Parameter at the end, like after "showopts" and press OK. And you're done. It'll take effect on the next reboot."
On 12/9/2014 1:00 PM, Peter Laursen wrote:
@Brian .. your reply is just *noise*. It is complete irrelevant for all the people following this maililng list what you think, I should know. But it is not irrelevant to point to a docs/wiki page that needs an update, as I did.
-- Peter
So duplicating the info on the same page is grounds for an attack on me?
Using your logic, I must go list every single possible combination of bootloaders and every OS version that is out there so no one else can complain. Should I include a tutorial on how to turn on your system? That's not written either.
I'm done with this thread.
Since the page already had specific instructions for Fedara etc., I think it should also have for SuSE.
I did not attack you. I just asked you not to spam the mailling list with comments to me personnally. You could have replied to me only. You have proved that you think that you know a lot about what other people should know. And you have also proved that you don't know how to behave on a mailing list.
-- Peter
On Tue, Dec 9, 2014 at 7:18 PM, Brian Evans grknight@scent-team.com wrote:
On 12/9/2014 1:00 PM, Peter Laursen wrote:
@Brian .. your reply is just *noise*. It is complete irrelevant for all the people following this maililng list what you think, I should know. But it is not irrelevant to point to a docs/wiki page that needs an update, as I did.
-- Peter
So duplicating the info on the same page is grounds for an attack on me?
Using your logic, I must go list every single possible combination of bootloaders and every OS version that is out there so no one else can complain. Should I include a tutorial on how to turn on your system? That's not written either.
I'm done with this thread.
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Am 09.12.2014 um 20:25 schrieb Peter Laursen:
Since the page already had specific instructions for Fedara etc., I think it should also have for SuSE.
I did not attack you. I just asked you not to spam the mailling list with comments to me personnally. You could have replied to me only. You have proved that you think that you know a lot about what other people should know. And you have also proved that you don't know how to behave on a mailing list
and you know? you decide what is noise and what not?
who do *you* think you are?
I noticed in https://downloads.mariadb.org/mariadb/repositories/#mirror=ulakbim&versi...
"After the installation finishes, start MariaDB with: sudo service mysql start"
"service" is not installed on SuSE as default and even not available from SuSE repos. You have to copy it from a Redhat/Fedora system if you want it.
Refer https://www.novell.com/coolsolutions/trench/15089.html (or use the 'Service Management' control from YaST GUI).
-- Peter
On Tue, Dec 9, 2014 at 5:17 PM, Ian Gilfillan ian@mariadb.org wrote:
Thanks Peter, I've added this to the page.
On 12/09/2014 06:01 PM, Peter Laursen wrote:
The page https://mariadb.com/kb/en/mariadb/documentation/storage-engines/tokudb/how-t...
.. should have added for SuSE "YAST2 -> Bootloader -> Kernel Parameters. Add transparent_hugepage=never to Optional Kernel Command Line Parameter at the end, like after "showopts" and press OK. And you're done. It'll take effect on the next reboot."
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
It seem that you guys think that SuSE is just *another Red Hat flavor". It is not!
-- Peter
On Wed, Dec 10, 2014 at 5:02 PM, Peter Laursen peter_laursen@webyog.com wrote:
I noticed in https://downloads.mariadb.org/mariadb/repositories/#mirror=ulakbim&versi...
"After the installation finishes, start MariaDB with: sudo service mysql start"
"service" is not installed on SuSE as default and even not available from SuSE repos. You have to copy it from a Redhat/Fedora system if you want it.
Refer https://www.novell.com/coolsolutions/trench/15089.html (or use the 'Service Management' control from YaST GUI).
-- Peter
On Tue, Dec 9, 2014 at 5:17 PM, Ian Gilfillan ian@mariadb.org wrote:
Thanks Peter, I've added this to the page.
On 12/09/2014 06:01 PM, Peter Laursen wrote:
The page https://mariadb.com/kb/en/mariadb/documentation/storage-engines/tokudb/how-t...
.. should have added for SuSE "YAST2 -> Bootloader -> Kernel Parameters. Add transparent_hugepage=never to Optional Kernel Command Line Parameter at the end, like after "showopts" and press OK. And you're done. It'll take effect on the next reboot."
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Hi, Peter!
On Nov 26, Peter Laursen wrote:
OK .. but did the TokuDB guys ever try to figure out why?
It could be a good idea to do. Because if it fails with Visual Studio, it may fail with other compilers as well. GCC is only one compiler and not the most standards-compliant as far as I understand.
This is something that TokuDB developers need to do. They apparently don't build on Windows yet. If upstream will support Windows, we will most certainly include TokuDB in our Windows packages.
May be if you'd ask them... :)
Regards, Sergei
-- Peter
On Wed, Nov 26, 2014 at 4:02 PM, Sergei Golubchik serg@mariadb.org wrote:
On Nov 26, Peter Laursen wrote:
If TokuDB has no dependencies, that the server does not have, why is it then not available on Windows? If it is, then Windows should be listed on same page.
It doesn't compile on Windows, as far as I understand.
participants (7)
-
Brian Evans -
Daniel Bartholomew -
Ian Gilfillan -
klrumpf -
Peter Laursen -
Reindl Harald -
Sergei Golubchik