- discuss - lists.mariadb.org

[Maria-discuss] MariaDB 10.1.9 now available
by Daniel Bartholomew 23 Nov '15

23 Nov '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.9. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.9 - Release Notes: https://mariadb.com/kb/en/mariadb-1019-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1019-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.1.9 About MariaDB 10.1: - https://mariadb.com/kb/en/what-is-mariadb-101/ 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: - http://mariadb.org/jira - - 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/ 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

1 0

[Maria-discuss] Problems installing MariaDB 10.1 on LEAP.
by Peter Laursen 23 Nov '15

23 Nov '15

I am facing problems installing MariaDB 10.1 on OpenSuSE LEAP (42.1) from the MariaDB repository for OpenSUSE 13. Even though built on/for SuSE 13.1 it worked fine on SuSE 13.2 as well. But not on LEAP: Please see attached screenshot from YaST (GUI) installer environment. I think that tells everything. 10.1 packages displayed here are from MariaDB repo (that registers with no problem with YaST/zypper, BTW). 10.0 and other packages displayed are from official SuSE repo. The 10.0 server from SuSE repo works fine, but I prefer 10.1 on this new VM. I am not interested in a 'hack-solution'. I can wait for a proper solution. But something (the memory allocation manager, seemingly) seems changed in OpenSuSE between-from 13.2 and LEAP creating a dependency problem with **MariaDB_from_MariaDB**. Is a new repo required to support OpenSUSE LEAP? @Daniel? -- Peter -- Webyog

2 3

[Maria-discuss] New Question: changing thelangauge of error messages in MySQL
by AskMonty KB 22 Nov '15

22 Nov '15

Hello, A new question has been asked in "SQL Language Structure" by mallika shaik. Please answer it at http://mariadb.com/kb/en/changing-thelangauge-of-error-messages-in-mysql/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi every one. I want to change MySQL error message language into Hindi. is it possible? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/changing-thelangauge-of-error-messages-in-mysql/

1 0

[Maria-discuss] per session query rewrite?
by James Leu 21 Nov '15

21 Nov '15

Hello, I've recently discovered the QueryRewrite plugin. I was wondering if there was any thought, or active work on making the rewrite rules associated with a connection/session. If there is not any active work on this, would the community find this useful? If so I would be willing to start development towards it. Any guidance would be greatly appreciated. -- James R. Leu jleu(a)mindspring.com

2 1

[Maria-discuss] New Question: Plugin DLL not working in Windows Server 2012 R2
by AskMonty KB 21 Nov '15

21 Nov '15

Hello, A new question has been asked in "MariaDB Community" by plcfischer. Please answer it at http://mariadb.com/kb/en/plugin-dll-not-working-in-windows-server-2012-r2/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have a modified version of lib_mysqludf_sys (limits the programs that can be run). On Windows 7 Ultimate SP 1 64 bit) it works just fine. On Windows Server 2012 R2 I get: ERROR 1126 (HY000): Can't open shared library 'mysql_UDF.dll' (errno: 2, The specified module could not be found. Following is more information: /-------------------------------------------------------------------------------------------------------------------------------------------------------------------- C:\Program Files\MariaDB 10.1\lib\plugin>dir /q *.dll Volume in drive C has no label. Volume Serial Number is 1EBA-5D2D Directory of C:\Program Files\MariaDB 10.1\lib\plugin . . . 10/15/2015 04:42 PM 48,456 NT AUTHORITY\SYSTEM metadata_lock_info.dll 11/19/2015 06:46 PM 44,032 NT AUTHORITY\SYSTEM mysql_UDF.dll 10/15/2015 04:42 PM 48,456 NT AUTHORITY\SYSTEM query_cache_info.dll . . . 19 File(s) 5,186,832 bytes 0 Dir(s) 338,428,325,888 bytes free C:\Program Files\MariaDB 10.1\lib\plugin>mysql -h 127.0.0.1 -u root -p Enter password: ********* Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 2 Server version: 10.1.8-MariaDB mariadb.org binary distribution Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> create database EMR; Query OK, 1 row affected (0.00 sec) MariaDB [(none)]> CREATE FUNCTION sys_exec RETURNS int SONAME 'mysql_UDF.dll'; ERROR 1126 (HY000): Can't open shared library 'mysql_UDF.dll' (errno: 2, The specified module could not be found. ) MariaDB [(none)]> show variables like '%plug%'; +-----------------+-------------------------------------------+ | Variable_name | Value | +-----------------+-------------------------------------------+ | plugin_dir | C:\Program Files\MariaDB 10.1\lib\plugin\ | | plugin_maturity | unknown | +-----------------+-------------------------------------------+ 2 rows in set (0.00 sec) MariaDB [(none)]> --------------------------------------------------------------------------------------------------------------------------------------------------------------------/ I tried mysql version 5.7.9 and have the same error. Any ideas? Thanks, Charles Fischer -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/plugin-dll-not-working-in-windows-server-2012-r2/

1 0

[Maria-discuss] Connect Engine with ODBC
by Bruce Carlson 20 Nov '15

20 Nov '15

Hi, I've been experimenting with the new Connect engine and the ODBC table type. I've installed MariaDB 10.1.17 on a test machine. I have an ODBC diver connected to a C-ISAM database. I am able to use this ODBC to connect from a MS Access 2013 database and despite some restrictions related to the C-ISAM DB it works well I have also been able to connect successfully from MariaDB and create connect tables. The only issue I'm having with the ODBC table type is the lack of indexes. However, I have noticed that in the MariaDB documentation accessible from https://mariadb.com/kb/en/mariadb/connect-table-types-odbc-table-type-acces… there is a note :- "Version 1.04 (from MariaDB 10.1.6<https://mariadb.com/kb/en/mariadb-1016-release-notes/>) adds remote indexing facility to the ODBC table type." As I've now installed 10.1.17 on my test machine, would someone be able to provide more information on the status of remote indexing, how it works and on how I may be able to make use of this? I am using HeidiSQL (Vers. 9.1.0.4867) as a front end tool and when I try to create indexes for the connect tables I get a message "SQL Error (1105): Table type ODBC is not indexable". Kind Regards, Bruce Carlson

3 6

[Maria-discuss] New Question: Error exporting from MySQL to MariaDB
by AskMonty KB 19 Nov '15

19 Nov '15

Hello, A new question has been asked in "MariaDB Documentation" by jayres. Please answer it at http://mariadb.com/kb/en/error-exporting-from-mysql-to-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I am attempting to move a wordpress db from a server running MySQL to one running MariaDb. It stops and throws this error: 2 errors were found during analysis. Ending quote ' was expected. (near "" at position 16695) 4 values were expected, but found 3. (near "(" at position 16587) SQL query: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''<a href="/locations/about/" class="right-side-footer-link">About Us</a>&nbsp' at line 116 Apparently that is within this line in the db: (405, 'woo_footer_right_text', '<a href="/locations/about/" class="right-side-footer-link">About Us</a>   <a href="/contact/" class="right-side-footer-link">Contact Us</a>   <a href="/appointments-bill-pay/medical-forms/" class="right-side-footer-link">Medical Forms</a><br /><a href="/legal/" class="right-side-footer-link">Legal</a>   <a href="/sitemap/" class="right-side-footer-link">Sitemap</a>   <a href="/professionals/partner-links/" class="right-side-footer-link">Partner Links</a>   <a href="https://access.domain.com/+CSCOE+/logon.html" class="right-side-footer-link" target="_blank">PACS Login</a>', 'yes'), Is it the multiple non-breaking space codes? Do I need to escape them (and how to escape them for MariaDb) or replace them (if so, with what?) -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/error-exporting-from-mysql-to-mariadb/

1 0

[Maria-discuss] MariaDB Galera Cluster 10.0.22 and updated connectors now available
by Daniel Bartholomew 19 Nov '15

19 Nov '15

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.22, MariaDB Connector/C 2.2.1, and MariaDB Connector/J 1.3.1. All of these are Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 10.0.22-stable (GA) - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-10022-release-notes/ - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-10022-changelog/ - Downloads: http://downloads.mariadb.org/mariadb-galera/10.0.22 - About MariaDB Galera Cluster: https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ MariaDB Connector/Java 1.3.1-stable (GA) - Release Notes: https://mariadb.com/kb/en/mariadb-connector-j-131-release-notes/ - Changelog: https://mariadb.com/kb/en/mariadb-connector-j-131-changelog/ - Downloads: https://downloads.mariadb.org/connector-java/1.3.1/ - About MariaDB Connector/J: https://mariadb.com/kb/en/about-mariadb-connector-j/ MariaDB Connector/C 2.2.1-stable (GA) - Release Notes: https://mariadb.com/kb/en/mariadb-connector-c-221-release-notes/ - Changelog: https://mariadb.com/kb/en/mariadb-connector-c-221-changelog/ - Downloads: http://downloads.mariadb.org/connector-c/2.2.1/ - About MariaDB Connector/ODBC: https://mariadb.com/kb/en/about-mariadb-connector-c/ - - 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: - http://mariadb.org/jira - - 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/ 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

1 0

[Maria-discuss] New Question: Install Maria DB Audit plugin to mysql
by AskMonty KB 19 Nov '15

19 Nov '15

Hello, A new question has been asked in "MariaDB Community" by udara_ranawakaarachchi_g. Please answer it at http://mariadb.com/kb/en/install-maria-db-audit-plugin-to-mysql/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi I tired to installed maria db audit plugin to mysql community server 5.7.I used below command to install plugin to database. Command INSTALL PLUGIN server_audit SONAME 'server_audit.so' However I received below error message. Error 1126(HY000):Can't open shared library sr/lib64/mysq;/plugin/server_audit.so' (errorno:2 /usr/lib64/nysql/plugin/server_audit.so: undefined symbol:safe_mutex_lock) Pls let me know how to overcome above issue. Thank -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/install-maria-db-audit-plugin-to-mysql/

1 0

[Maria-discuss] New Question: Using MariaDB on Linux from C++ ODBC
by AskMonty KB 18 Nov '15

18 Nov '15

Hello, A new question has been asked in "MariaDB Connector/C" by jimbrownsmart. Please answer it at http://mariadb.com/kb/en/using-mariadb-on-linux-from-c-odbc/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is the connector what I need to use ODBC from C++ on opensuse 13? It would be great if you could point me to a document that says how to get mariadb set up so I can contact it with ODBC from C++ I extacted mariadb-connector-c-2.2.1-linux-x86_64 but I don't know what to do next. mariadb_config has a bunch of options.but I can't find any documentation. I have installed already these: MyODBC-unixODBC; unixODBC; mariadb; mariadb-client; mariadb-errormessages. odbc.ini is empty odbsinst.ini only has postgreseql which is my backup if I can't get mariadb to work. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/using-mariadb-on-linux-from-c-odbc/

1 0

[Maria-discuss] Replication to galera cluster
by Igor Mazur 18 Nov '15

18 Nov '15

Hi, I've tried to setup replication from production MariaDB (lets name proddb) to a data warehouse on Galera cluster (dw1, dw2 and dwarbitrator - last is a node with garb). Made master-slave link between proddb and dw1. And on dw1 I have actual data, but they are not updated on dw2. Other schemas successfully transfer their updates between dw1 and dw2 as required. Looks like only difference that other schemas are updated with direct requests to dw1 and dw2, and replicated schema is updated only through replication. Does anyone have experience with a similar configuration? Igor

2 2

[Maria-discuss] New Question: Buffer size issue?
by AskMonty KB 18 Nov '15

18 Nov '15

Hello, A new question has been asked in "General FAQ" by Bytesmiths. Please answer it at http://mariadb.com/kb/en/buffer-size-issue/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have a query that returns a string considerably longer than 1024 characters. It was working properly in MariaDB 5.1. I have upgraded to 10.1.8, and it appears that the query return is being truncated at 1024 characters. I see this behaviour in three separate tools, including php mysql calls, phpMyAdmin, and the mysql command line tool. (It was the mysql CLI, piped to wc, that told me that exactly 1024 characters were being sent, but no more.) Assuming this is not a bug, but rather some variable to be tweaked, can someone point me in the right direction? Thanks in advance! BTW: Here is the query, which has not changed since it was written in 5.1: <pre>SELECT GROUP_CONCAT(DISTINCT '<a href="/wiki/', p.family, '" title="', f.explanation, '">', p.family, '</a>' ORDER BY p.family SEPARATOR ', ') FROM s_plants p LEFT JOIN s_plant_families f ON p.family = f.family</pre> This query basically returns a string containing a long list of plant family names, wrapped in HTML links. This is what I get back: <pre><a href="/wiki/Agavaceae" title="Agave family">Agavaceae</a>, <a href="/wiki/Aizoaceae" title="Fig-Marigold or Ice Plant family">Aizoaceae</a>, <a href="/wiki/Alliaceae" title="Onion and Garlic family">Alliaceae</a>, <a href="/wiki/Amaranthaceae" title="Amaranth family">Amaranthaceae</a>, <a href="/wiki/Anacardiaceae" title="Cashew or Sumac family">Anacardiaceae</a>, <a href="/wiki/Apiaceae" title="Celery or Carrot family, formerly Umbelliferae">Apiaceae</a>, <a href="/wiki/Apocynaceae" title="Periwinkle family">Apocynaceae</a>, <a href="/wiki/Araliaceae" title="Ginseng family">Araliaceae</a>, <a href="/wiki/Asteraceae" title="Daisy family, formerly Compositae">Asteraceae</a>, <a href="/wiki/Boraginaceae" title="Forget-me-Not family">Boraginaceae</a>, <a href="/wiki/Brassicaceae" title="Cabbage family, formerly Cruciferae">Brassicaceae</a>, <a href="/wiki/Campanulaceae" title="Bellflower Family">Campanulaceae</a>, <a href="/wiki/Caprifoliaceae" title="Honeysuckle family" >Caprifoliaceae</a>, <a href="/wiki/Car</pre> That last link with the open quote in the open anchor tag sure plays havoc with the rest of the page... :-) -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/buffer-size-issue/

1 0

[Maria-discuss] (no subject)
by 林澤宇 17 Nov '15

17 Nov '15

Hi guy, I have two database server used the Replication + MHA + MaxScale . When the master(mdb1) went down ,I had select "show slave status" on slave(mdb2) , the slave database show "No query specified". So I can sure the slave database was be a master database. I had used maxscale commad "list servers" to show servers status : that show the mdb1 was down and mdb2 was runnung . But I can't connect to mysql via Maxscale, I got an error message : failed to create new session . How to use the Maxscale in two server replication ? The minimum database server node of MaxScale are 3 servers ?

1 0

[Maria-discuss] New MariaDB Connector Releases
by Daniel Bartholomew 16 Nov '15

16 Nov '15

The MariaDB project is pleased to announce the immediate availability of MariaDB Connector/Java 1.3.0-stable (GA) and MariaDB Connector/ODBC 2.0.9-beta. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Connector/Java 1.3.0-stable (GA) - Release Notes: https://mariadb.com/kb/en/mariadb-connector-j-130-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-connector-j-130-changelog - Downloads: https://downloads.mariadb.org/connector-java/1.3.0/ - About MariaDB Connector/J: https://mariadb.com/kb/en/about-mariadb-connector-j/ MariaDB Connector/ODBC 2.0.9-beta - Release Notes: https://mariadb.com/kb/en/mariadb-connector-odbc-209-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-connector-odbc-209-changelog - Downloads: http://downloads.mariadb.org/connector-odbc/2.0.9/ - About MariaDB Connector/ODBC: https://mariadb.com/kb/en/about-mariadb-connector-odbc/ - - 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: - http://mariadb.org/jira - - 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/ 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

1 0

[Maria-discuss] MariaDB 10.0.22 now available
by Daniel Bartholomew 16 Nov '15

16 Nov '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.22. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.22 - Release Notes: https://mariadb.com/kb/en/mariadb-10022-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10022-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.22 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: - http://mariadb.org/jira - - 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/ 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

5 8

[Maria-discuss] New Question: Cluster node sizes are different
by AskMonty KB 16 Nov '15

16 Nov '15

Hello, A new question has been asked in "MariaDB Galera Cluster" by chen-lin_li_g. Please answer it at http://mariadb.com/kb/en/cluster-node-sizes-are-different/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have three node MariaDB Galera Cluster. At first the databases size in all the three nodes were same. However now it has been noticed that database size are different on three node. But the three status(wsrep_local_state_comment) of the three nodes are synced. Could you let me know whether it is an expected behavior? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/cluster-node-sizes-are-different/

1 0

[Maria-discuss] R: doubt trigger
by Federico Razzoli 14 Nov '15

14 Nov '15

Standard SQL has triggers FOR EACH STATEMENT, but MariaDB has not. I would use a stored procedure instead. Regards Federico -------------------------------------------- Ven 13/11/15, Roberto Spadim <roberto(a)spadim.com.br> ha scritto: Oggetto: [Maria-discuss] doubt trigger A: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Venerdì 13 novembre 2015, 21:50 hi guy, i'm with a doubt thre's a trigger to execute after insert/update/delete complete? not row by rowi want to change some tables and automatically execute a procedure to recalculate some values, but i will insert/update/delete many rows, that's why i want to execute it after query execution, but with a CALL PROCEDURE() any idea? -- Roberto Spadim -----Segue allegato----- _______________________________________________ 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

2 1

[Maria-discuss] doubt trigger
by Roberto Spadim 13 Nov '15

13 Nov '15

hi guy, i'm with a doubt thre's a trigger to execute after insert/update/delete complete? not row by row i want to change some tables and automatically execute a procedure to recalculate some values, but i will insert/update/delete many rows, that's why i want to execute it after query execution, but with a CALL PROCEDURE() any idea? -- Roberto Spadim

1 0

[Maria-discuss] mysql_install_db as user
by Felipe Gasper 13 Nov '15

13 Nov '15

Hello, Is this script supposed to be runnable as a normal (i.e., non-root) user? In MySQL 5.6 there is logic that prevents the chown() of the mysql data dir when running as non-root. MariaDB 10.1.8 doesn’t seem to have this logic, so the script fails when chown() fails. Is this change intended? We have tests that verify functionality of user-created, UNIX-socket-only MySQL/MariaDB servers. These work on MySQL 5.6 but not on MariaDB 10.1. Here is the command-line output: --------------- ~/temp $ /usr/bin/mysql_install_db --datadir=mysqldata chown: changing ownership of `mysqldata': Operation not permitted Cannot change ownership of the database directories to the 'mysql' user. Check that you have the necessary permissions and try again. bash: __git_ps1: command not found --------------- Thank you for your time! -Felipe Gasper Houston, TX

2 4

[Maria-discuss] Donating during the downloads
by Colin Charles 12 Nov '15

12 Nov '15

Hi, Today I downloaded Ubuntu and saw this awesome page for donations. Do you think we should do this for the MariaDB Server / Connectors / etc. so that the MariaDB Foundation gets funded as well? I know that even LibreOffice has done this (http://donate.libreoffice.org/) We should consider this. Otto, what do you think? -- Colin Charles, Chief Evangelist, MariaDB Corporation blog: http://bytebot.net/blog/ | t: +1-347-903-3201 | Skype: colincharles | Twitter: @bytebot

3 2

[Maria-discuss] GRANT error - undocumented?
by Felipe Gasper 12 Nov '15

12 Nov '15

Hello, I’ve found an apparent discrepancy between MySQL 5.6 and MariaDB 10.1. When you GRANT ALL PRIVILEGES on a DB to a user/host that is not in the mysql.users table, MariaDB 10.1 throws ER_PASSWORD_NO_MATCH, whereas MySQL 5.6 creates the user/host entry. Is this by design? I don’t see the behavior discussed at https://mariadb.com/kb/en/mariadb/grant/. Thank you for your time! Below I am including the client outputs for both servers. -Felipe Gasper Houston, TX -------------------------- Server version: 10.1.8-MariaDB-log MariaDB Server Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> create database fgtemp; Query OK, 1 row affected (0.00 sec) MariaDB [(none)]> use fgtemp; Database changed MariaDB [fgtemp]> grant all on fgtemp.* to 'root'@'nowhere'; ERROR 1133 (28000): Can't find any matching row in the user table MariaDB [fgtemp]> -------------------------- Server version: 5.6.27-log MySQL Community Server (GPL) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> create database fgtemp; Query OK, 1 row affected (0.00 sec) mysql> use fgtemp; Database changed mysql> grant all on fgtemp.* to 'root'@'nowhere'; Query OK, 0 rows affected (0.05 sec) --------------------------

4 5

Re: [Maria-discuss] Donating during the downloads
by Federico Razzoli 12 Nov '15

12 Nov '15

If you are talking about donations to the foundation (not the company) I agree that it's a great idea. If small donations are welcome, many people will probably donate (and I'm one of them). Just a hint: maybe you could even advertise merchandising in the download page. Regards Federico -------------------------------------------- Gio 12/11/15, Stephane VAROQUI <stephane(a)mariadb.com> ha scritto: Oggetto: Re: [Maria-discuss] Donating during the downloads A: "Colin Charles" <colin(a)mariadb.org> Cc: "Maria Discuss (maria-discuss(a)lists.launchpad.net)" <maria-discuss(a)lists.launchpad.net> Data: Giovedì 12 novembre 2015, 09:06 Hi Colin! Indeed that's an excellent idea for the foundation.Would enjoy an online shop for market place (maxscale commercial modules), rdba credits, foundation donations . /stephane Stéphane Varoqui, Senior ConsultantPhone: +33 695-926-401, skype: svaroquihttp://www.mariadb.com Le Nov 12, 2015 à 7:28 AM, Colin Charles a écrit : Hi, Today I downloaded Ubuntu and saw this awesome page for donations. Do you think we should do this for the MariaDB Server / Connectors / etc. so that the MariaDB Foundation gets funded as well? I know that even LibreOffice has done this (http://donate.libreoffice.org/) We should consider this. Otto, what do you think? -- Colin Charles, Chief Evangelist, MariaDB Corporation blog: http://bytebot.net/blog/ | t: +1-347-903-3201 | Skype: colincharles | Twitter: @bytebot <Contribute_to_Ubuntu___Ubuntu___Ubuntu.png>_______________________________________________ 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 -----Segue allegato----- _______________________________________________ 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

1 0

[Maria-discuss] doubt with thread pool
by Roberto Spadim 11 Nov '15

11 Nov '15

i'm with a doubt if i have a thread pool with 1000 threads and a max_connections with 100 connections can i have more than 100 clients connected (1000 threads for example)? dos thread pool size limit the max connections, or max connections limite the thread pol size? -- Roberto Spadim

4 7

[Maria-discuss] TokuDB + virtual column
by Roberto Spadim 09 Nov '15

09 Nov '15

Hi guys, there's a plan to include virtual column to tokudb storage? /* Erro SQL (1910): TokuDB storage engine does not support computed columns */ thanks -- Roberto Spadim

3 4

[Maria-discuss] New Question: Install problem on Mac OSX 10.10.2
by AskMonty KB 09 Nov '15

09 Nov '15

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by 7stud. Please answer it at http://mariadb.com/kb/en/install-problem-on-mac-osx-10102/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I would love to switch to MariaDB, but over the last year I've tried installing it twice on different versions of Mac OSX and failed. I don't use Homebrew because generally it causes more problems than installing from source. So, I followed the Generic Build instructions: https://mariadb.com/kb/en/mariadb/generic-build-instructions/ And here were my results trying to install: **MariaDB 10.1.8**\\ on **Mac OSX 10.10.2 **\\ with **Xcode 6.3.2**\\ {{{ $ cmake --version cmake version 3.4.0-rc3 CMake suite maintained and supported by Kitware (kitware.com/cmake) $ cmake . -DBUILD_CONFIG=mysql_release $ make --version GNU Make 3.81 Copyright (C) 2006 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. This program built for i386-apple-darwin11.3.0 $ make ... ... Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:191:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:222:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:423:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:452:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:465:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:552:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:576:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:592:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:617:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:616:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:652:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:651:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:703:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:811:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:864:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:921:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:969:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:1007:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:1101:3: error: cannot use 'try' with exceptions disabled try { ^ fatal error: too many errors emitted, stopping now [-ferror-limit=] 20 errors generated. make[2]: *** [storage/mroonga/vendor/groonga/lib/CMakeFiles/libgroonga.dir/dat.cpp.o] Error 1 make[1]: *** [storage/mroonga/vendor/groonga/lib/CMakeFiles/libgroonga.dir/all] Error 2 make: *** [all] Error 2 }}} -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/install-problem-on-mac-osx-10102/

1 0

[Maria-discuss] New Question: I would love to switch to MariaDB, but over the last year I've tried installing it twice on different versions of Mac OSX and failed.
by AskMonty KB 08 Nov '15

08 Nov '15

Hello, A new question has been asked in "Downloads" by 7stud. Please answer it at http://mariadb.com/kb/en/i-would-love-to-switch-to-mariadb-but-over-the-las… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I don't use Homebrew because it causes more problems than installing from source. So I followed the Generic Build instructions: https://mariadb.com/kb/en/mariadb/generic-build-instructions/ And here were my results trying to install on Mac OSX 10.10.2 with Xcode 6.3.2: $ cmake --version cmake version 3.4.0-rc3 CMake suite maintained and supported by Kitware (kitware.com/cmake) $ cmake . -DBUILD_CONFIG=mysql_release $ make --version GNU Make 3.81 Copyright (C) 2006 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. This program built for i386-apple-darwin11.3.0 $ make ... ... Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:191:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:222:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:423:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:452:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:465:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:552:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:576:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:592:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:617:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:616:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:652:5: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:651:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:703:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:811:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:864:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:921:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:969:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:1007:3: error: cannot use 'try' with exceptions disabled try { ^ /Users/7stud/Downloads/mariadb-10.1.8/storage/mroonga/vendor/groonga/lib/dat.cpp:1101:3: error: cannot use 'try' with exceptions disabled try { ^ fatal error: too many errors emitted, stopping now [-ferror-limit=] 20 errors generated. make[2]: *** [storage/mroonga/vendor/groonga/lib/CMakeFiles/libgroonga.dir/dat.cpp.o] Error 1 make[1]: *** [storage/mroonga/vendor/groonga/lib/CMakeFiles/libgroonga.dir/all] Error 2 make: *** [all] Error 2 -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/i-would-love-to-switch-to-mariadb-but-over-the-las…

1 0

[Maria-discuss] Compiling maxscale
by Justin Swanhart 08 Nov '15

08 Nov '15

Hi, When I try to compile maxscale, the classifier won't compile because it needs server headers. How do I tell it where to find the source. It uses multiple headers in multiple directories so adding the server source via a simple -I to CXXFLAGS doesn't work. Am I missing something? Sent from my iPhone

2 2

[Maria-discuss] Bad file descriptor mariadb 10.1.
by joao＠7lan.net 07 Nov '15

07 Nov '15

Hi List, Sometimes, my mysqld daemon begin to consumes 100% the connection to the server gets unstable and I get flooded in the mysql error log with these messages: Nov 4 06:17:01 db1 mysqld: 2015-11-04 6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor Nov 4 06:17:01 db1 mysqld: 2015-11-04 6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor Nov 4 06:17:01 db1 mysqld: 2015-11-04 6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor Nov 4 06:17:01 db1 mysqld: 2015-11-04 6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor Nov 4 06:17:01 db1 mysqld: 2015-11-04 6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor Nov 4 06:17:01 db1 mysqld: 2015-11-04 6:17:01 140682979031168 [ERROR] Error in accept: Bad file descriptor it only stops when I restart the daemon, no query is shown in "show full processlist". Maybe some kernel adjustment? Any ideia? Running centos 7 at the lastest version. [root@db1 scripts]# yum -y update Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * base: ftpmirror.your.org * epel: mirror.nexcess.net * extras: ftpmirror.your.org * updates: mirrors.lga7.us.voxel.net No packages marked for update [root@db1 scripts]# rpm -qa|grep -i MariaDB MariaDB-shared-10.1.8-1.el7.centos.x86_64 MariaDB-client-10.1.8-1.el7.centos.x86_64 MariaDB-common-10.1.8-1.el7.centos.x86_64 MariaDB-server-10.1.8-1.el7.centos.x86_64 Thanks! João Reis.

4 5

[Maria-discuss] New Question: Downgrade MariaDB
by AskMonty KB 04 Nov '15

04 Nov '15

Hello, A new question has been asked in "Upgrading MariaDB" by areno. Please answer it at http://mariadb.com/kb/en/downgrade-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello, I recently upgraded MariaDB 10.0.21 to 10.1.8. Our program that interacts with it is tossing errors and we found out it's not supported by the program. We were directed from the application dev team to install 10.0.21 back. I cannot find any documentation on how to properly downgrade the DB and move the data to an older version. Any specific process to follow? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/downgrade-mariadb/

1 0

[Maria-discuss] LOAD FILE and BIT datatype
by Roberto Spadim 03 Nov '15

03 Nov '15

hi guys, how could i send bit data to mysql with LOAD FILE? a table example: create table t (i bit not null default 0); LOAD DATA LOCAL INFILE "file.csv" IGNORE INTO TABLE `t` FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' (i) the data file is simple: 0 1 0 1 0 1 but i got Warning 1024: Out of range value for column 'i' at row 1 ... to last row any idea? i tried b'0' b'1' '0' '1' 0 1 but no one work, i don't know what happen but it's cast always to 1 (maybe convert from string to binary?)

2 12

[Maria-discuss] New Question: my_config.h is missing from Connector 2.2.0 for Windows
by AskMonty KB 01 Nov '15

01 Nov '15

Hello, A new question has been asked in "MariaDB Community" by sruliganor. Please answer it at http://mariadb.com/kb/en/my_configh-is-missing-from-connector-220-for-windo… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I downloaded and ran mariadb-connector-c-2.2.0-win64.msi. Instead of my_config.h, directory include contains only my_config.h.in. Where is the mssing file? Thanks Sruli -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/my_configh-is-missing-from-connector-220-for-windo…

1 0

[Maria-discuss] New Question: Spider
by AskMonty KB 30 Oct '15

30 Oct '15

Hello, A new question has been asked in "MariaDB Community" by siliconplains44. Please answer it at http://mariadb.com/kb/en/mariadb-community-spider/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, we are looking for scale up options for mariadb. We wanted to try spider out but there was not enough information on this site. Some of the questions I had were what is the maxiumum number of nodes you can have. Does the database balance the shards, etc.? I am looking to see how much storage we can get out of spider. Can anyone out there help us with this request? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-community-spider/

1 0

[Maria-discuss] Slave SQL: Fatal error: ... Slave SQL Thread stopped with incomplete event group having non-transactional changes
by Reindl Harald 29 Oct '15

29 Oct '15

* why does that happen at all instead finish whatever is not finished after get SIGTERM * "try to restart the slave with --slave-exec-mode=IDEMPOTENT" must be a joke when "slave-exec-mode = IDEMPOTENT" is part of my.cnf for years *because* of that failure happening randomly when stop a slave at a wrong moment 151029 9:15:44 [ERROR] Slave SQL: Fatal error: ... Slave SQL Thread stopped with incomplete event group having non-transactional changes. If the group consists solely of row-based events, you can try to restart the slave with --slave-exec-mode=IDEMPOTENT, which ignores duplicate key, key not found, and similar errors (see documentation for details). Gtid 0-1-2058483, Internal MariaDB error code: 1593

1 0

[Maria-discuss] New Question: Want to start contributing in MariaDB
by AskMonty KB 28 Oct '15

28 Oct '15

Hello, A new question has been asked in "MariaDB Community" by aman_var. Please answer it at http://mariadb.com/kb/en/want-to-start-contributing-in-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello all, I want to contribute to this project. I have ample knowledge of C,C++ and want to start my open source contribution. It would be great if i get some directions from you all guys as to where to start from. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/want-to-start-contributing-in-mariadb/

1 0

[Maria-discuss] New Question: Want to start contributing in MariaDB
by AskMonty KB 28 Oct '15

28 Oct '15

Hello, A new question has been asked in "MariaDB Community" by aman_var. Please answer it at http://mariadb.com/kb/en/want-to-start-contributing-in-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello all, I want to contribute to this project. I have ample knowledge of C,C++ and want to start my open source contribution. It would be great if i get some directions from you all guys as to where to start from. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/want-to-start-contributing-in-mariadb/

1 0

[Maria-discuss] New Question: MariaDB Error Code -> Windows ERRORLEVEL
by AskMonty KB 26 Oct '15

26 Oct '15

Hello, A new question has been asked in "Error Codes" by patkoshar. Please answer it at http://mariadb.com/kb/en/mariadb-error-code-windows-errorlevel/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello, Is there a known issue or problem with how/when MariaDB returns error codes from calling '--execute' on *.sql scripts in Windows? It seems like certain errors are detected and returned as such, and others are not. For example, a *.sql file of completely random bytes will set the Windows ERRORLEVEL=1 after failing, reporting the following error: ERROR: ASCII '\0' appeared in the statement... Another *.sql file that references an unknown database will set the Windows ERRORLEVEL=0, but still textually report an error after failing: ERROR 1049 (42000) at line 1 in file... Any ideas? Thank you! -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-error-code-windows-errorlevel/

1 0

[Maria-discuss] New Question: Converting unix timestamp stored as bigint to readable date time
by AskMonty KB 26 Oct '15

26 Oct '15

Hello, A new question has been asked in "MariaDB Documentation" by thanmaya. Please answer it at http://mariadb.com/kb/en/converting-unix-timestamp-stored-as-bigint-to-read… as the person asking the question may not be subscribed to the mailing list. -------------------------------- We are storing the timestamp as a bigint. In the SQL query trying to convert this timestamp to date time. have used the function FROM_UNIXTIME but it just returns a NULL value. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/converting-unix-timestamp-stored-as-bigint-to-read…

1 0

[Maria-discuss] MySQL Meetup NL slides
by Colin Charles 25 Oct '15

25 Oct '15

Hi! So we had many MariaDB Server and other developers speak at the MySQL Meetup NL in Amsterdam a week ago. The slides (except Otto’s — it’ll be added soon!) are all at: https://drive.google.com/folderview?id=0B7HE7L1OgKJFcXVrX05Ea25zb2c&usp=sha… I wrote a quick post with an index — http://www.bytebot.net/blog/archives/2015/10/24/mysql-nl-community-meetup-w… I think the attendees had a great time overall, and there was plenty of good conversation. Also, much thanks to eBay (venue, food, drink), Booking.com (Daniël van Eeden organised, and JF ensured we were all appropriately whipped to make this happen!), and all the speakers. cheers, -colin -- Colin Charles, Chief Evangelist, MariaDB Corporation blog: http://bytebot.net/blog/ | t: +1-347-903-3201 | Skype: colincharles | Twitter: @bytebot

3 3

[Maria-discuss] MariaDB Galera Cluster Wrsep not ready
by Bertrand Caplet 24 Oct '15

24 Oct '15

Hi all, I have a galera cluster of 4 MariaDB server and sometimes a node fail. But when a node fail, others nodes doesn't want to respond to query. I have in log : "MYSQL: query failed: WSREP has not yet prepared node for application use" It's really embarrassing, because it happen like once a week. Is there a parameter to modify to get this working even when split brain ? Like If 2 of the 4 server are ok, I can still make query ? Thanks in advance, -- CHUNKZ.NET - script kiddie and computer technician Bertrand Caplet, Flers (FR) Feel free to send encrypted/signed messages Key ID: 37F70C30 GPG FP: 134A 4027 518B 5F4D D409 558D BA9B 7BF0 37F7 0C30

2 2

Re: [Maria-discuss] CentOS Docker Container Image not only for OpenShift
by Honza Horak 24 Oct '15

24 Oct '15

Thanks for the feedback, Kolbe. On 10/23/2015 06:41 PM, Kolbe Kegel wrote: > I find the use of environment variables to hold passwords to be a really troubling feature of the way many Docker images are built and used. I agree this is not a very good solution and we need to come up with something better, that will also work in kubernetes. If anybody knows about something handy, I'd be glad to hear about it. So far, we've just used what other images do, which is not ideal at all. > In an environment where Docker linking is not used, perhaps the environment variable problem is somewhat less severe. But I'm really troubled by this statement: > > "Changing database passwords through SQL statements or any way other than through > the environment variables aforementioned will cause a mismatch between the > values stored in the variables and the actual passwords. Whenever a database > container starts it will reset the passwords to the values stored in the > environment variables." > > That sounds to me like a security catastrophe. In cases user cares about keeping the container password unknown to other containers and docker daemon itself, the stack can be initialized with some init-only root password and changed afterwards. If I understand what your concern is, it's the reset of the password, right? I guess we may change that behavior to not do anything if password is not set and data directory is already initialized. Is it something what would help here from your point of view? Honza > Kolbe > >> On Oct 22, 2015, at 11:26 PM, Honza Horak <hhorak(a)redhat.com> wrote: >> >> For those who are interested in containers, I'd like to share a Docker image that we've produced in Red Hat in cooperation with OpenShift guys. And will be really glad for any feedback you have. >> >> The image can be used in OpenShift or run directly. But what I find really interesting is a PoC implementation of master/slave, that is not documented as official feature yet, but it can be used as simple as that: >> >> docker pull centos/mariadb-100-centos7 >> >> docker run -e MYSQL_MASTER_USER=master \ >> -e MYSQL_MASTER_PASSWORD=master \ >> -e MYSQL_DATABASE=db \ >> -e MYSQL_USER=user \ >> -e MYSQL_PASSWORD=foo \ >> -e MYSQL_ROOT_PASSWORD=rootpasswd \ >> -d centos/mariadb-100-centos7 mysqld-master >> >> docker run -e MYSQL_MASTER_USER=master \ >> -e MYSQL_MASTER_PASSWORD=master \ >> -e MYSQL_DATABASE=db \ >> -e MYSQL_MASTER_SERVICE_NAME=<master_ip> \ >> -d centos/mariadb-100-centos7 mysqld-slave >> >> More info about the image available here: >> https://hub.docker.com/r/centos/mariadb-100-centos7/ >> >> As said above, any feedback welcome :) >> >> Honza >> >> _______________________________________________ >> 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 >

2 1

[Maria-discuss] mysql_install_db.exe failing on Dutch Windows Machine(s) on some Folders
by Derek R Magee 23 Oct '15

23 Oct '15

Hi, I'm trying to debug a mariadb failure on a machine in Holland. It seems mysql_install_db doesn't work for some folders, but does for others (e.g. c:\temp\db). We've typed exactly the same thing into the Dutch machine as my UK machine. On the UK machine it works fine, on the dutch machine it claims to work, but the mysql folder is empty on completion (and sunsequently the database doesn't start for obvious reasons). I've asked the guy in Holland to check folder write permissions on the parent folders created, and obviously the logged in user must be the owner as they are created with mkdir (see below): =========================================================== Dutch machine: =========================================================== Microsoft Windows [versie 6.1.7601] Copyright (c) 2009 Microsoft Corporation. Alle rechten voorbehouden. C:\Users\g10031702>cd c:\ c:\>mkdir MIM c:\>cd MIM c:\MIM>mkdir MIMDB c:\MIM>cd "c:\program files\mariadb 10.1\BIN" c:\Program Files\MariaDB 10.1\bin>mysql_install_db.exe --datadir=c:/MIM/MIMDB/db --password=password Running bootstrap Creation of the database was successfull c:\Program Files\MariaDB 10.1\bin> [On exit the db sub-folder is created, as is the mysql sub-folder, but the latter is empty. N.B. We tried both 5.5 and 10.1 versions, same issue, same output.] =========================================================== UK Machine =========================================================== C:\Users\cscdrm>cd c:\ c:\>mkdir MIM c:\>cd MIM c:\MIM>mkdir MIMDB c:\MIM>cd "c:\Program Files\MariaDB 5.5\bin" c:\Program Files\MariaDB 5.5\bin>mysql_install_db.exe --datadir=c:/MIM/MIMDB/db --password=password Running bootstrap Removing default user <------- Extra Setting root password <------- Extra Creating my.ini file <------- Extra Creation of the database was successfull c:\Program Files\MariaDB 5.5\bin> [On exit the db sub-folder is created, as is the mysql sub-folder, and the lattercontains ~80 files] Has anyone got an idea how to fix this? We've seen similar things on a range of Dutch machines in the same institution where it always works if you use a sub folder of c:\temp, but other locations fail (e.g. under c:\Users, c:\). I've never seen it fail on a UK machine. Thanks a lot Derek

1 0

[Maria-discuss] CentOS Docker Container Image not only for OpenShift
by Honza Horak 23 Oct '15

23 Oct '15

For those who are interested in containers, I'd like to share a Docker image that we've produced in Red Hat in cooperation with OpenShift guys. And will be really glad for any feedback you have. The image can be used in OpenShift or run directly. But what I find really interesting is a PoC implementation of master/slave, that is not documented as official feature yet, but it can be used as simple as that: docker pull centos/mariadb-100-centos7 docker run -e MYSQL_MASTER_USER=master \ -e MYSQL_MASTER_PASSWORD=master \ -e MYSQL_DATABASE=db \ -e MYSQL_USER=user \ -e MYSQL_PASSWORD=foo \ -e MYSQL_ROOT_PASSWORD=rootpasswd \ -d centos/mariadb-100-centos7 mysqld-master docker run -e MYSQL_MASTER_USER=master \ -e MYSQL_MASTER_PASSWORD=master \ -e MYSQL_DATABASE=db \ -e MYSQL_MASTER_SERVICE_NAME=<master_ip> \ -d centos/mariadb-100-centos7 mysqld-slave More info about the image available here: https://hub.docker.com/r/centos/mariadb-100-centos7/ As said above, any feedback welcome :) Honza

1 0

[Maria-discuss] mysqldump mishandling DB name?
by Felipe Gasper 23 Oct '15

23 Oct '15

In client/mysqldump.c, there is a command: mysql_real_escape_string(mysql, db_name_buff, db, strlen(db)); … which appears to be doubling up and backslashes in the database name when the “--routines” argument is passed to mysqldump. This bug affects MySQL 5.7.9 (and back at least to 5.1); I’ve filed a MySQL bug here: https://bugs.mysql.com/bug.php?id=78932 -FG

1 0

[Maria-discuss] New Question: Where is the "Restrictions and Limitations" documentation of MariaDB?
by AskMonty KB 22 Oct '15

22 Oct '15

Hello, A new question has been asked in "MariaDB Documentation" by openiduser59. Please answer it at http://mariadb.com/kb/en/where-is-the-restrictions-and-limitations-document… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi! MySQL has the "Restrictions and Limitations" documentation section: http://dev.mysql.com/doc/mysql-reslimits-excerpt/5.7/en/subquery-restrictio… Where is the same section of MariaDB docs? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/where-is-the-restrictions-and-limitations-document…

1 0

[Maria-discuss] New Question: Unable to create after insert trigger on mariadb
by AskMonty KB 22 Oct '15

22 Oct '15

Hello, A new question has been asked in "SQL Structure and Commands" by girish2477. Please answer it at http://mariadb.com/kb/en/unable-to-create-after-insert-trigger-on-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I followed trigger instructions from documentation. When i run the script from command line, cursor does not come back. i have to kill the execution Server version: 5.5.46-MariaDB MariaDB Server Tried various formats CREATE TRIGGER company_insert AFTER INSERT ON companyMain FOR EACH ROW INSERT INTO companytest (ID, Value) VALUES (20, CONCAT(NEW.`Code`,' - ',NEW.`Name`)); ------------ DELIMITER // DROP TRIGGER IF EXISTS company_insert ; CREATE TRIGGER company_insert AFTER INSERT ON companyMainFOR EACH ROW BEGIN DECLARE vFormatID int; SET vFormatID=20; INSERT INTO companytest (ID,Value) VALUES ( vFormatID,NEW.`Name`); END; // DELIMITER; Tried running from command directly or pass as .sql file. both ways its stuck no response back on command. Have to kill. ^CCtrl-C -- query killed. Continuing normally. ERROR 1317 (70100) at line 3: Query execution was interrupted Your help will be appreciated. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/unable-to-create-after-insert-trigger-on-mariadb/

1 0

[Maria-discuss] CONJ SSL connection with client cert and key
by Beeton, Carolyn (Carolyn) 20 Oct '15

20 Oct '15

From: Beeton, Carolyn (Carolyn) Sent: Monday, October 19, 2015 3:39 PM To: 'maria-discuss(a)lists.launchpad.net' Subject: CONJ SSL connection with client cert and key I am using the MariaDb Connector/J to connect to a remote database which requires a client cert and key in addition to the server cert. Is there any way to configure this (similar to MySql clientCertificateKeyStoreUrl)? Thanks, Carolyn

1 0

[Maria-discuss] New Question: Please update procedures to upgrade Galera cluster from MariaDB 10.0.21/22 to MariaDB 10.1.8
by AskMonty KB 19 Oct '15

19 Oct '15

Hello, A new question has been asked in "MariaDB Documentation" by robin_anil_g. Please answer it at http://mariadb.com/kb/en/please-update-procedures-to-upgrade-galera-cluster… as the person asking the question may not be subscribed to the mailing list. -------------------------------- It seems like wserp replication is now part of MariaDB. I would appreciate insights into correct rolling upgrade procedure for the same. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/please-update-procedures-to-upgrade-galera-cluster…

1 0

[Maria-discuss] Moving from Launchpad lists to something else... ?
by Colin Charles 19 Oct '15

19 Oct '15

Hi, I was speaking to Otto (CEO, MariaDB Foundation) and discussing that we should move the lists from Launchpad to something else. We obviously want to preserve the archives, and this isn’t going to happen overnight (something like an aim by the end of the year). Would you be ok with running on Google Groups? Would you prefer being on Mailman? Do you have another self-hosted or (preferably free) hosted solution as your preference? Today, we have several lists (maria-discuss, maria-developers, maria-docs) that are hosted on Launchpad. We also have a few lists (ambassadors, announce, commits, mirroring, maria-buildbot-reports) hosted on Mailman at lists.askmonty.org. Let us know what you think about this Kind Regards, Colin Charles -- Colin Charles, Chief Evangelist, MariaDB Corporation blog: http://bytebot.net/blog/ | t: +1-347-903-3201 | Skype: colincharles | Twitter: @bytebot

6 6

[Maria-discuss] New Question: Couldn't execute 'show events': Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577)
by AskMonty KB 17 Oct '15

17 Oct '15

Hello, A new question has been asked in "MariaDB Community" by wraith. Please answer it at http://mariadb.com/kb/en/couldnt-execute-show-events-cannot-proceed-because… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi! Being new to MariaDB, I'm unsure if this is the correct forum to pose my question. Please forgive and forward me in the right direction if it is not :) I've recently upgraded from MySQL to MariaDB on my QNAP TS-410 server and commenced using. I've recently attempted to backup my tables and have been faced with a "Couldn't execute 'show events': Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577)". I've browsed the web and the "mysql_upgrade" command is regularly touted; however, this doesn't appear to be on my TS-410. I've also attempted restarting the server via the TS-410 web interface. I approached QNAP who responded they were unable to assist. Which leads me here. Has anyone encountered a similar or same scenario? And able to provide assistance in resolving? Thanks in advance -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/couldnt-execute-show-events-cannot-proceed-because…

1 0

[Maria-discuss] MariaDB version string in initial handshake
by Felipe Gasper 17 Oct '15

17 Oct '15

Hi all, I’m seeing a version string like this from the server in the initial handshake: 5.5.5-10.1.16-MariaDB Why does MariaDB negotiate with a different-format version string than MySQL? Is this documented somewhere? -FG

3 2

[Maria-discuss] New Question: INSERT IGNORE refuses to ignore foreign key constraints. Bug maybe?
by AskMonty KB 15 Oct '15

15 Oct '15

Hello, A new question has been asked in "MariaDB Documentation" by stillsmil. Please answer it at http://mariadb.com/kb/en/insert-ignore-refuses-to-ignore-foreign-key-constr… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is this a bug? INSERT IGNORE refuses to ignore ERROR 1452, as is described in http://stackoverflow.com/questions/6849393/mysqls-insert-ignore-into-foreig…. To regenerate the error: CREATE TABLE parent (id INT AUTO_INCREMENT NOT NULL , PRIMARY KEY (id) ) ENGINE=INNODB; CREATE TABLE child ( id INT AUTO_INCREMENT , parent_id INT , INDEX par_ind (parent_id) , PRIMARY KEY (id) , FOREIGN KEY (parent_id) REFERENCES parent(id) ) ENGINE=INNODB; INSERT INTO parent VALUES (1) (2); INSERT IGNORE INTO child VALUES (NULL, 3); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`financedb`.`child`, CONSTRAINT `child_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`)) Server version: 10.0.21-MariaDB-log MariaDB Server -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/insert-ignore-refuses-to-ignore-foreign-key-constr…

1 0

[Maria-discuss] New Question: Unable to build mariadb connector 2.2.0
by AskMonty KB 12 Oct '15

12 Oct '15

Hello, A new question has been asked in "MariaDB Community" by johnnyoj. Please answer it at http://mariadb.com/kb/en/unable-to-build-mariadb-connector-220/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- How do I debug why cmake is failing? -- Performing Test ICONV_SECOND_ARGUMENT_IS_CONST -- Performing Test ICONV_SECOND_ARGUMENT_IS_CONST - Success -- Found Iconv: /usr/lib/libc.so CMake Error: File /root/mariadb-connector-c-2.2.0/mariadb-connector-c-2.2.0-src/mariadb_config/mariadb_config.c.in does not exist. CMake Error at mariadb_config/CMakeLists.txt:27 (CONFIGURE_FILE): configure_file Problem configuring file -- MariaDB Connector/c configuration: -- CPack generation: TGZ -- SSL support: ON -- Experimental Sqlite support: -- Zlib support: yes (using bundled zlib) -- Installation layout: DEFAULT -- Include files will be installed in /usr/local/include/mariadb -- Libraries will be installed in /usr/local/lib/mariadb -- Binaries will be installed in /usr/local/bin -- Required: -- Configuring incomplete, errors occurred! See also "/root/mariadb-connector-c-2.2.0/mariadb-connector-c-2.2.0-src/CMakeFiles/CMakeOutput.log". See also "/root/mariadb-connector-c-2.2.0/mariadb-connector-c-2.2.0-src/CMakeFiles/CMakeError.log". make: *** No targets specified and no makefile found. Stop. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/unable-to-build-mariadb-connector-220/

1 0

[Maria-discuss] New Question: Cannot change socket location in 10.0.21
by AskMonty KB 12 Oct '15

12 Oct '15

Hello, A new question has been asked in "MariaDB Community" by bits45. Please answer it at http://mariadb.com/kb/en/cannot-change-socket-location-in-10021/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm trying to change the socket file location to anything other than /var/lib/mysql on Red Hat 6.6 x64. Using the socket variable in server.cnf or even in my.cnf does not appear to honor the varable. I've tried placing the variable setting in various locations in the server.cnf file, but nothing seems to work. The socket file is always created in /var/lib/mysql, or the database has problems starting up. Where else do I search for this? Could it have been compiled in by accident? If I try this with MySQL 5.6 Community version it works without issue - I placed the variable in /etc/my.cnf file under [mysqld] Again, I'm using the non enterprise version of MariaDB 10.0.21 with RHEL 6.6. I downloaded MariaDB from the yum repositories via MariaDB.com Thanks, -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/cannot-change-socket-location-in-10021/

1 0

[Maria-discuss] MariaDB 5.5.46 now available
by Daniel Bartholomew 12 Oct '15

12 Oct '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.46. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.46 - Release Notes: https://mariadb.com/kb/en/mariadb-5546-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-5546-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.46 About MariaDB 5.5: - https://mariadb.com/kb/en/what-is-mariadb-55/ 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: - http://mariadb.org/jira - - 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/ 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

1 0

[Maria-discuss] Mariadb galera cluster ipv6
by Bertrand Caplet 11 Oct '15

11 Oct '15

Hey guys, I trying to get up running a galera cluster with IPv6 But right know, it's not working. I'm trying to join the cluster with node 2 and the rsync sst isn't listening on IPv6. Here the node 2 log : 151010 13:21:49 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '192.168.1.220' --auth '' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --defaults-group-suffix '' --parent '6363' --binlog '/var/log/mysql/mariadb-bin' ' Here's my mariadb parameters : wsrep_provider=/usr/lib/galera/libgalera_smm.so wsrep_cluster_name="chunkz_cluster" wsrep_cluster_address="gcomm://dbcluster1,dbcluster2,dbcluster3,dbcluster4" wsrep_sst_method=rsync wsrep_provider_options = "gmcast.listen_addr=tcp://[::]:4567;" wsrep_node_name="dbcluster1" Do you have any idea for making it work over IPv6 ? Thanks in advance, Regards. -- CHUNKZ.NET - script kiddie and computer technician Bertrand Caplet, Flers (FR) Feel free to send encrypted/signed messages Key ID: 37F70C30 GPG FP: 134A 4027 518B 5F4D D409 558D BA9B 7BF0 37F7 0C30

2 1

[Maria-discuss] writing plugin with .net language (C#)
by Roberto Spadim 10 Oct '15

10 Oct '15

Hi guys, I have a program wrote in c#, it process some code and the result is a struct (an array of string/double/int) I want to include this program inside mariadb server as a daemon plugin (to process data) + a storage engine (to read struct data) is that possible? considering that i can write dll with .net? what about write this to linux (.so files) ? any help is very very very welcome -- Roberto Spadim

6 18

[Maria-discuss] New Question: 64bit compile of MariaDB 10.0.21 for Solaris 10 (sparc)
by AskMonty KB 09 Oct '15

09 Oct '15

Hello, A new question has been asked in "MariaDB Community" by troglodyte. Please answer it at http://mariadb.com/kb/en/64bit-compile-of-mariadb-10021-for-solaris-10-spar… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm having a really rough time with this. Both using the BUILD/compile_solaris_spac, cmake . -DBUILD_CONFIG=mysql_release and just going through regular config script. Compiling in 32bit wasn't an issue, but I need a 64bit installation. I've set all of my flags to inclued -m64: # env | grep FLAGS CPPFLAGS=-m64 CMAKE_C_FLAGS=-m64 CXXFLAGS=-m64 CMAKE_CXX_FLAGS=-m64 CFLAGS=-m64 And my library path is correct - as far as I can tell. # echo $LD_LIBRARY_PATH /usr/lib/sparcv9:/usr/sfw/lib/sparcv9:/lib/sparcv9:/lib:/usr/lib So far I've had to manually change all of the link.txt files to add the -m64 switch. That got me past the initial problem, but now I'm running into the following: [ 18%] Building C object mysys/CMakeFiles/mysys.dir/my_atomic.c.o cd /opt/install/mariadb-10.0.21/mysys && /usr/sfw/bin/gcc -DHAVE_CONFIG_H -DHAVE_RWLOCK_T -m64 -O3 -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -Wno-uninitialized -DDBUG_OFF -I/opt/install/mariadb-10.0.21/include -I/opt/install/mariadb-10.0.21/mysys -m64 -fPIC -o CMakeFiles/mysys.dir/my_atomic.c.o -c /opt/install/mariadb-10.0.21/mysys/my_atomic.c /opt/install/mariadb-10.0.21/mysys/my_atomic.c: In function `my_atomic_initialize': /opt/install/mariadb-10.0.21/mysys/my_atomic.c:30: error: size of array `compile_time_assert' is negative *** Error code 1 make: Fatal error: Command failed for target `mysys/CMakeFiles/mysys.dir/my_atomic.c.o' Current working directory /opt/install/mariadb-10.0.21 *** Error code 1 make: Fatal error: Command failed for target `mysys/CMakeFiles/mysys.dir/all' Current working directory /opt/install/mariadb-10.0.21 *** Error code 1 make: Fatal error: Command failed for target `all' Any and all help would be greatly appreciated. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/64bit-compile-of-mariadb-10021-for-solaris-10-spar…

1 0

[Maria-discuss] New Question: Why does libmariadb require libssl.so.1.0.0(OPENSSL_1.0.0)?
by AskMonty KB 09 Oct '15

09 Oct '15

Hello, A new question has been asked in "MariaDB Community" by johnnyoj. Please answer it at http://mariadb.com/kb/en/why-does-libmariadb-require-libsslso100openssl_100/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I’m currently using MariaDB C Connector 2.2 and it has a dependency on OpenSSL 1.0.0 (libssl.so.1.0.0 with version definition OPENSSL_1.0.0). [root@server5088-vm07 2.2.0]# ldd reporter ./reporter: /root/2.2.0-redhat/./libssl.so.1.0.0: version `OPENSSL_1.0.0' not found (required by /root/2.2.0-redhat/./libmariadb.so.2) libmariadb.so.2 => /root/2.2.0-redhat/./libmariadb.so.2 (0x0019e000) libssl.so.1.0.0 => /root/2.2.0-redhat/./libssl.so.1.0.0 (0x0021c000) [stuff del] Why? All OpenSSL 1.0.x releases are binary compatible (https://www.openssl.org/docs/faq.html#MISC8) In addition my RH release ships with OpenSSL 1.0.1 and there should be no reason I need to maintain 2 versions of OpenSSL. Any guidance would be appreciated. [root@server5088-vm07 2.2.0-redhat]# objdump -p libssl.so.1.0.0 | grep OPENSSL_ 3 0x00 0x066a2b21 OPENSSL_1.0.1 4 0x00 0x02b21533 OPENSSL_1.0.1_EC 0x02b21533 0x00 08 OPENSSL_1.0.1_EC [root@server5088-vm07 2.2.0-redhat]# ls -al total 1756 drwxr-xr-x. 2 root root 4096 Oct 9 10:10 . dr-xr-x---. 12 root root 4096 Oct 9 10:04 .. -r-x------. 1 root root 1281934 Oct 9 10:05 libmariadb.so.2 lrwxrwxrwx. 1 root root 25 Oct 9 10:10 libssl.so.1.0.0 -> /usr/lib/libssl.so.1.0.1e -r-x------. 1 root root 507756 Oct 9 10:05 reporter -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/why-does-libmariadb-require-libsslso100openssl_100/

1 0

[Maria-discuss] Can someone explain odd InnoDB locking behavior
by Yuri Karaban 09 Oct '15

09 Oct '15

Hi I'm trying to understand why InnoDB locks two next-key intervals higher than needed. If you try to run conn-a.sql from one connection, and then run conn-b.sql from other connection, conn-b.sql would be locked. I have a feeling that it locks two next-key intervals: (5 to 7 and 7 to positive infinity). Because I can insert values higher than 7 in conn-b only if condition is WHERE n <= 4 (or lower than 4). TokuDB locks just one next-key interval (with WHERE n <= 7, TokuDB locks from -infinity to +infinity, but with condition WHERE n <= 6, it locks from -infinity to 6). Please help me to understand why ever both engines need to lock gap after the upper end of range scan. And why InnoDB needs to lock even two next-key gaps. I tried this on MariaDB 10.0.21 ----------------------[conn-a.sql]-------------------------------- DROP TABLES IF EXISTS innosel, innoin; CREATE TABLE innosel (n INT UNSIGNED PRIMARY KEY) ENGINE InnoDB; CREATE TABLE innoin (n INT UNSIGNED PRIMARY KEY) ENGINE InnoDB; INSERT INTO innosel values (1), (3), (5), (7); SET tx_isolation = 'REPEATABLE-READ'; START TRANSACTION; INSERT IGNORE INTO innoin (n) SELECT n FROM innosel WHERE n <= 5; SELECT SLEEP(100); ROLLBACK; ----------------------[conn-a.sql]-------------------------------- ----------------------[conn-b.sql]-------------------------------- START TRANSACTION; INSERT INTO innosel VALUES (9); ROLLBACK; ----------------------[conn-b.sql]-------------------------------- -- Nemo iudex in causa sua.

2 2

[Maria-discuss] New Question: Problems with user access to db
by AskMonty KB 08 Oct '15

08 Oct '15

Hello, A new question has been asked in "Downloads" by mathman54. Please answer it at http://mariadb.com/kb/en/problems-with-user-access-to-db/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have MariaDB 10.1 installed. I am trying to get some software installed but am running into problems. I have created a database and user for that database, but when I run the software it cannot connect to the database. The user I created was on the database sam I used the command MySQL -u sam -p'sam's password' sam's database I get access denied for user 'sam'@'localhost' I used the command "grant all privileges on newdb.* to sam@localhost;" I also did a "grant usage on *.* to sam@localhost identified by 'sams password'; Is there something I am doing wrong? Is there something I am missing? Your help is appreciated. Thank you, Mark -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/problems-with-user-access-to-db/

1 0

[Maria-discuss] New Question: Need help modifing the mysqld_multi script
by AskMonty KB 08 Oct '15

08 Oct '15

Hello, A new question has been asked in "MariaDB Community" by cisaksen. Please answer it at http://mariadb.com/kb/en/need-help-modifing-the-mysqld_multi-script/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I running a multi instance mariadb cluster with 3 nodes. The nodes are all SUSE (SLES) 12. I have copied the mysqld_multi script form /usr/bin to /etc/init.d to enable the startup and shutdown of all the databases when the system starts and stops. Problem I'm having is that if I use mysqld_mult stop/start (to stop/start them all) only one or two will actually stop/start the rest just won't work. But I f I start/stop them one at a time with a few seconds delay between commands it works just fine. So what I'm looking to do is to modify the mysqld_multi script to add a 5 sec delay in between each instances start/stop. Just not where the best place in the script to do this. Any ideas ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/need-help-modifing-the-mysqld_multi-script/

1 0

[Maria-discuss] New Question: Galera Documentation
by AskMonty KB 07 Oct '15

07 Oct '15

Hello, A new question has been asked in "MariaDB Documentation" by cisaksen. Please answer it at http://mariadb.com/kb/en/galera-documentation/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Can someone point me in the right direction for setting up a MariaDB galera cluster. I see all the MariaDB documentation but I don't see any cluster info ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/galera-documentation/

1 0

[Maria-discuss] MariaDB / Sysbench TPS question
by J. Cassidy 07 Oct '15

07 Oct '15

Hello all, I am running MariaDB 10.1.5 with Sysbench 0.5 (lua) against an IBM Blade (Haswell) using Hitachi 15K SAS Hdd's. Operating system is RHEL 7. Hyperthreading is turned off. System memory is 48GB. Up to now, I have ran extensive Sysbench tests against MariaDB using RAM as the datastore with no appreciable problems. Now I have switched the datastore to normal disk (see above) and am seeing the Sysbench R/W TPS rate take a hit after approximately 3 minutes (180 seconds) into the run (runtime is 600 seconds) and every three minutes thereafter. I am seeing nothing in the MariaDB logs (error and Slow queries), nor in Linux itself, nor is Sysbench telling me anything (I have debug rurned on and verbosity set to 5). Here is an excerpt from one of the R/W Sysbench runs [ 168s] threads: 128, tps: 26262.00, reads: 367679.02, writes: 105188.51, response time: 50.12ms (99%), errors: 0.00, reconnects: 0.00 [ 170s] threads: 128, tps: 25913.49, reads: 362826.86, writes: 103670.96, response time: 49.08ms (99%), errors: 0.00, reconnects: 0.00 [ 172s] threads: 128, tps: 26271.51, reads: 367736.58, writes: 105009.52, response time: 50.34ms (99%), errors: 0.00, reconnects: 0.00 [ 174s] threads: 128, tps: 26059.52, reads: 364822.73, writes: 104187.07, response time: 44.69ms (99%), errors: 0.00, reconnects: 0.00 [ 176s] threads: 128, tps: 26394.00, reads: 369573.99, writes: 105652.50, response time: 52.28ms (99%), errors: 0.00, reconnects: 0.00 [ 178s] threads: 128, tps: 26248.49, reads: 367422.90, writes: 104927.97, response time: 49.85ms (99%), errors: 0.00, reconnects: 0.00 [ 180s] threads: 128, tps: 26549.00, reads: 371726.52, writes: 106166.01, response time: 60.01ms (99%), errors: 0.00, reconnects: 0.00 [ 182s] threads: 128, tps: 21493.92, reads: 301020.88, writes: 86033.18, response time: 47.29ms (99%), errors: 0.00, reconnects: 0.00 [ 184s] threads: 128, tps: 174.00, reads: 2435.96, writes: 706.99, response time: 2245.86ms (99%), errors: 0.00, reconnects: 0.00 [ 186s] threads: 128, tps: 185.50, reads: 2597.00, writes: 760.50, response time: 2334.28ms (99%), errors: 0.00, reconnects: 0.00 [ 188s] threads: 128, tps: 269.00, reads: 3766.00, writes: 1066.50, response time: 2314.11ms (99%), errors: 0.00, reconnects: 0.00 [ 190s] threads: 128, tps: 153.50, reads: 2149.00, writes: 619.50, response time: 2121.06ms (99%), errors: 0.00, reconnects: 0.00 [ 192s] threads: 128, tps: 552.00, reads: 7728.00, writes: 2199.50, response time: 1440.33ms (99%), errors: 0.00, reconnects: 0.00 [ 194s] threads: 128, tps: 615.00, reads: 8610.00, writes: 2450.00, response time: 1414.69ms (99%), errors: 0.00, reconnects: 0.00 [ 196s] threads: 128, tps: 908.00, reads: 12712.00, writes: 3650.00, response time: 950.93ms (99%), errors: 0.00, reconnects: 0.00 [ 198s] threads: 128, tps: 1579.00, reads: 22052.47, writes: 6283.99, response time: 932.61ms (99%), errors: 0.00, reconnects: 0.00 [ 200s] threads: 128, tps: 1562.00, reads: 21921.53, writes: 6257.01, response time: 748.43ms (99%), errors: 0.00, reconnects: 0.00 [ 202s] threads: 128, tps: 4166.00, reads: 58323.95, writes: 16652.49, response time: 445.78ms (99%), errors: 0.00, reconnects: 0.00 [ 204s] threads: 128, tps: 11574.99, reads: 161931.90, writes: 46264.97, response time: 263.77ms (99%), errors: 0.00, reconnects: 0.00 [ 206s] threads: 128, tps: 17420.50, reads: 244004.98, writes: 69714.50, response time: 103.69ms (99%), errors: 0.00, reconnects: 0.00 [ 208s] threads: 128, tps: 19833.49, reads: 277626.90, writes: 79424.97, response time: 93.88ms (99%), errors: 0.00, reconnects: 0.00 [ 210s] threads: 128, tps: 24994.00, reads: 349910.48, writes: 99975.49, response time: 48.12ms (99%), errors: 0.00, reconnects: 0.00 [ 212s] threads: 128, tps: 25129.50, reads: 351825.03, writes: 100549.51, response time: 52.12ms (99%), errors: 0.00, reconnects: 0.00 [ 214s] threads: 128, tps: 24982.99, reads: 349739.36, writes: 99821.46, response time: 47.66ms (99%), errors: 0.00, reconnects: 0.00 My.cnf - [mysqld_safe] user=root password='' [mysqld] open_files_limit = 102400 max_allowed_packet = 768M connect_timeout = 120 # was 60 performance-schema = false net_read_timeout = 720 log-warnings=2 #####files and sockets pid-file=/tmp/mysqld.pid.sysbench log_warnings=2 log-error=/var/log/mariadb/mariadb-error-john.log long_query_time = 1 slow_query_log = 1 slow_query_log_file = /var/log/mariadb/mariadb-slowquery.log log_queries_not_using_indexes = 1 # general-log # general-log-file=/var/log/mariadb/mariadb-general.log # general_log_file=/var/log/mariadb/mariadb-general.log ##### MariaDB temporary tables tmpdir = /mnt/ramdisk #####non innodb options (fixed) max_connections = 8000 # was 4000 back_log = 150 table_open_cache = 4000 # was 8000 key_buffer_size = 16M query_cache_type = 1 # was 0 join_buffer_size = 32K sort_buffer_size = 32K #####use InnoDB plugin #ignore-builtin-innodb #plugin-load=innodb=ha_innodb.so #####fixed innodb options innodb_file_per_table = true innodb_open_files = 8192 # was 4096 innodb_data_file_path = ibdata1:250M:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT_NO_FSYNC innodb_log_buffer_size = 256M innodb_log_file_size = 4G innodb_log_files_in_group = 2 innodb_buffer_pool_size = 40G innodb_buffer_pool_instances = 32 innodb_adaptive_hash_index_partitions = 32 innodb_thread_concurrency = 0 #####Power8 specific #innodb_spin_wait_delay = 0 #####tuning for SAN storage innodb_adaptive_flushing = 1 innodb_flush_neighbors = 1 innodb_io_capacity = 4000 innodb_io_capacity_max = 6000 innodb_lru_scan_depth = 4096 innodb_purge_threads = 2 innodb_read_io_threads = 8 # was 8 innodb_write_io_threads = 16 ####tuning for RAM disk #innodb_adaptive_flushing = 1 #innodb_flush_neighbors = 0 #innodb_io_capacity = 20000 #innodb_io_capacity_max = 40000 #innodb_lru_scan_depth = 4096 #innodb_purge_threads = 2 #innodb_read_io_threads = 2 #innodb_write_io_threads = 2 Would anyone be able to enlighten me as to why I am getting this TPS performance hit after approximately three minutes? Any pointers much appreciated. Regards, Aubrey

2 1

[Maria-discuss] New Question: PHP source for UDF in Maria
by AskMonty KB 07 Oct '15

07 Oct '15

Hello, A new question has been asked in "Plugins" by ronijoven. Please answer it at http://mariadb.com/kb/en/php-source-for-udf-in-maria/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is there a way to create a UDF in Maria using the PHP method in a class. There are a lot of PHP sites, this is in relation to encrypt data in MariaDB and the encryption algorithm is based on PHP. Thanks. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/php-source-for-udf-in-maria/

1 0

[Maria-discuss] Group Concat and Sub Query
by Roberto Spadim 04 Oct '15

04 Oct '15

Hi guys I have a problem and a possible solution, that i think is relative easy to develop (i didn't tested but i think the source is easy to change) i have some queries like: SELECT date, (SELECT value FROM some_table WHERE date=a.date ORDER BY date ASC LIMIT 1) AS first, (SELECT value FROM some_table WHERE date=a.date ORDER BY date DESC LIMIT 1) AS last FROM some_table AS a GROUP BY date i want to "convert" the complex sub query, to a agregate function, and i thinking about group concat: from mysql docs: GROUP_CONCAT([DISTINCT] *expr* [,*expr* ...] [ORDER BY {*unsigned_integer* | *col_name* | *expr*} [ASC | DESC] [,*col_name* ...]] [SEPARATOR *str_val*]) we have ORDER BY if we could include a "LIMIT" clause, i could rewrite this query to: SELECT date, GROUP_CONCAT(value ORDER BY date ASC LIMIT 1) AS first, GROUP_CONCAT(value ORDER BY date DESC LIMIT 1) AS last FROM some_table AS a GROUP BY date i know that i could have stats tables / materialized views (with flexview, i already tested :) ), but i want something more "easy to use" and not "very fast", just a "feature" to solve small problems it's a nice idea? does anyone have this "problem" and solve with other solutions? -- Roberto Spadim

3 11

[Maria-discuss] spider connections
by Federico Razzoli 01 Oct '15

01 Oct '15

Hi all. I'm trying to troubleshoot a weird situation, and I have processes like this: *************************** 3. row *************************** Id: 122884 User: root Host: 127.0.0.1:52222 db: dpp_ela Command: Query Time: 276 State: After opening tables Info: show table status from `dpp_ela` like 'access' Progress: 0.000 The query seems to be issued by SPIDER when "SHOW CREATE TABLE $spider_table" is issued. But why should this require a connection at all? I'd expect that query to show the local table definition. Am I missing something? Regards Federico

1 0

[Maria-discuss] what is adding the -g compile parm?
by Reindl Harald 01 Oct '15

01 Oct '15

"-O3 -g" appears in the cmake output, that likely breaks ld.gold / -flto and so the question: who the explain the build *not* add that useless param for production builds like most oterh software don't without one could also remove the strip-calls in rpm-spec-files!

2 4

[Maria-discuss] Error when migrating from TokuDB 7.5.2 to MariaDB 5.5.44 (works with 5.5.41)
by Fernando Marcelo 01 Oct '15

01 Oct '15

I'm trying to migrate a TokuDB 7.5.2 server to MariaDB 5.5.44. Since I can't stop the production server, I got a snapshot of the running instance. So MariaDB will have to recover. Unfortunately i get an error when TokuDB recovery is running in version 5.5.44. Previously I tried with MariaDB 5.5.41 which worked fine. But since I'm upgrading, I would like to use the latest version. Mon Sep 28 03:53:37 2015 TokuFT recovery bw_begin_checkpoint at 158147092471 timestamp 1443133470008593 (bw_between) Mon Sep 28 03:53:37 2015 TokuFT recovery turning around at begin checkpoint 158147092471 time 181293960 Mon Sep 28 03:53:37 2015 TokuFT recovery starts scanning forward to 158147993496 from 158147092471 left 901025 (fw_between) /home/buildbot/buildbot/build/mariadb-5.5.44/storage/tokudb/ft-index/ft/serialize/ft-serialize.cc:275 deserialize_ft_versioned: Assertion `readsz >= translation_size_on_disk' failed (errno=2) : No such file or directory Backtrace: (Note: toku_do_assert=0x0x7f769b49cf30) /usr/lib64/mysql/plugin/ha_tokudb.so(_Z19db_env_do_backtraceP8_IO_FILE+0x1b)[0x7f769b4996fb] /usr/lib64/mysql/plugin/ha_tokudb.so(+0x80823)[0x7f769b499823] /usr/lib64/mysql/plugin/ha_tokudb.so(+0x8089a)[0x7f769b49989a] /usr/lib64/mysql/plugin/ha_tokudb.so(_Z24deserialize_ft_versionediP4rbufPP2ftj+0xc32)[0x7f769b525622] /usr/lib64/mysql/plugin/ha_tokudb.so(_Z24toku_deserialize_ft_fromi10__toku_lsnPP2ft+0x229)[0x7f769b525949] /usr/lib64/mysql/plugin/ha_tokudb.so(_Z35toku_read_ft_and_store_in_cachefileP9ft_handleP9cachefile10__toku_lsnPP2ft+0x76)[0x7f769b525bb6] /usr/lib64/mysql/plugin/ha_tokudb.so(+0x11e20a)[0x7f769b53720a] /usr/lib64/mysql/plugin/ha_tokudb.so(_Z28toku_ft_handle_open_recoveryP9ft_handlePKciiP10cachetableP7tokutxn7FILENUM10__toku_lsn+0x2d)[0x7f769b53938d] /usr/lib64/mysql/plugin/ha_tokudb.so(+0x1204aa)[0x7f769b5394aa] /usr/lib64/mysql/plugin/ha_tokudb.so(_Z14tokuft_recoverP13__toku_db_envPFvS0_P7tokutxnEPFvS0_P10cachetableEP10tokuloggerPKcSC_PFiP9__toku_dbPK10__toku_dbtSH_EPFiSE_SH_SH_SH_PFvSH_PvESK_EPFiSE_SE_P9DBT_ARRAY SQ_SH_SH_EPFiSE_SE_SQ_SH_SH_Em+0x2538)[0x7f769b5017b8] /usr/lib64/mysql/plugin/ha_tokudb.so(+0x1107b0)[0x7f769b5297b0] /usr/lib64/mysql/plugin/ha_tokudb.so(+0x5195f)[0x7f769b46a95f] /usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x48)[0x6e4018] /usr/sbin/mysqld[0x5b254d] /usr/sbin/mysqld(_Z11plugin_initPiPPci+0x833)[0x5b7573] /usr/sbin/mysqld[0x51c638] /usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x47f)[0x52119f] /lib64/libc.so.6(__libc_start_main+0xf5)[0x7f769e590af5] /usr/sbin/mysqld[0x518239] Engine status function not available Memory usage: Arena 0: system bytes = 0 in use bytes = 0 Total (incl. mmap): system bytes = 0 in use bytes = 0 max mmap regions = 0 max mmap bytes = 0 150928 3:53:37 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Any ideas about how to fix this issue?

2 1

[Maria-discuss] New Question: MariaDB on SGE with environmental modules
by AskMonty KB 28 Sep '15

28 Sep '15

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by netzach. Please answer it at http://mariadb.com/kb/en/mariadb-on-sge-with-environmental-modules/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi The title says it all. How do I setup MariaDB on a computer cluster using SGE and environmental modules with one shared place for the databases? I want the databases to be in /databases which is exported through a local network to the computational nodes. All computers run centos 7. Thank you Jonas Söderberg -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-on-sge-with-environmental-modules/

1 0

[Maria-discuss] MariaDB Crashes due to Stored Procedure
by Joseph Onyilo 28 Sep '15

28 Sep '15

I created two Store procedures to time table scheduling some months back and test it at the time which was fine. The first procedure has a cursor to navigate a list of records and call the second procedure. The Second Procedure has two cursors for different scenarios. Now trying to a final test before moving to production and it crashes my MariaDB Server mid way. Even when I called the Second Procedure individually with static parameters, after three to five calls MariaDB still crashes. The Operating system is Centos 6.6, MariaDB 10.0.21 and error from log displays is as follows |This could be because you hit a bug.It isalso possible that this binary orone ofthe libraries it was linked against iscorrupt,improperly built,ormisconfigured.This error can also be caused bymalfunctioning hardware.Toreport this bug,see http://kb.askmonty.org/en/reporting-bugs We will try our best toscrape up someinfo that will hopefully help diagnose the problem,but since we have already crashed,something isdefinitely wrong andthis may fail.Server version:10.0.21-MariaDB key_buffer_size=134217728read_buffer_size=131072max_used_connections=3max_threads=153thread_count=2It ispossible that mysqld could useup tokey_buffer_size +(read_buffer_size +sort_buffer_size)*max_threads =467003K bytes ofmemory Hope that's ok;ifnot,decrease somevariables inthe equation.Thread pointer:0x0x7fdac266f008 Attempting backtrace.You can usethe followinginformation tofind out wheremysqld died.Ifyou see no messages after this,something went terribly wrong...stack_bottom =0x7fdad74cfd30thread_stack 0x48000/usr/sbin/mysqld(my_print_stacktrace+0x2b)[0xb7f84b]/usr/sbin/mysqld(handle_fatal_signal+0x398)[0x72b758]/lib64/libpthread.so.0(+0xf710)[0x7fdad710b710]/usr/sbin/mysqld(_ZN13st_select_lex17mark_as_dependentEP3THDPS_P4Item+0xa0)[0x5c8410]/usr/sbin/mysqld[0x73c544]/usr/sbin/mysqld(_ZN10Item_field15fix_outer_fieldEP3THDPP5FieldPP4Item+0x62f)[0x74c78f]/usr/sbin/mysqld(_ZN10Item_field10fix_fieldsEP3THDPP4Item+0x432)[0x74ce72]/usr/sbin/mysqld(_Z12setup_fieldsP3THDPP4ItemR4ListIS1_E17enum_mark_columnsPS5_b+0x163)[0x594a03]/usr/sbin/mysqld[0x6168f3]/usr/sbin/mysqld(_ZN18st_select_lex_unit7prepareEP3THDP13select_resultm+0x39c)[0x6648ac]/usr/sbin/mysqld(_Z21mysql_derived_prepareP3THDP3LEXP10TABLE_LIST+0x206)[0x5b4bc6]/usr/sbin/mysqld(_Z27mysql_handle_single_derivedP3LEXP10TABLE_LISTj+0x193)[0x5b5bd3]/usr/sbin/mysqld(_ZN13st_select_lex14handle_derivedEP3LEXj+0x47)[0x5ca857]/usr/sbin/mysqld(_ZN10TABLE_LIST14handle_derivedEP3LEXj+0x4f)[0x679f2f]/usr/sbin/mysqld(_Z28mysql_handle_list_of_derivedP3LEXP10TABLE_LISTj+0x3f)[0x5b5d4f]/usr/sbin/mysqld(_Z20mysql_prepare_insertP3THDP10TABLE_LISTP5TABLER4ListI4ItemEPS7_S8_S8_15enum_duplicatesPPS6_bbb+0xb8)[0x5c09a8]/usr/sbin/mysqld(_Z27mysql_insert_select_prepareP3THD+0x72)[0x5c0e62]/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x556f)[0x5d94bf]/usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x1e)[0x81d26e]/usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x8b)[0x82285b]/usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x155)[0x822d45]/usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x6c9)[0x820529]/usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x5f6)[0x821796]/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x31f9)[0x5d7149]/usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x1e)[0x81d26e]/usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x8b)[0x82285b]/usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x155)[0x822d45]/usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x6c9)[0x820529]/usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x5f6)[0x821796]/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x31f9)[0x5d7149]/usr/sbin/mysqld[0x5da9d7]/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1d0d)[0x5dce4d]/usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x453)[0x69a2d3]/usr/sbin/mysqld(handle_one_connection+0x42)[0x69a3a2]/lib64/libpthread.so.0(+0x79d1)[0x7fdad71039d1]/lib64/libc.so.6(clone+0x6d)[0x7fdad581d8fd]Trying toget somevariables.Somepointers may be invalid andcause the dumptoabort.Query (0x7fdaa8818548):isan invalid pointer Connection ID (thread ID):3Status:NOT_KILLED Optimizer switch:index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=onThe manual page at http://dev.mysql.com/doc/mysql/en/crashing.html containsinformation that should help you find out what iscausing the crash.| I also did a test on MariaDB 10.0.17 on windows still no luck.

1 1

[Maria-discuss] select using date_sub produces unwanted milliseconds in results
by Dan Ragle 26 Sep '15

26 Sep '15

We're converting from MySQL 5.1 to MariaDB 5.5.44 and I'm hoping someone can help clarify for me what's going on in the following scenario. In brief, we're getting milliseconds displayed in a particular date_sub calculation (and possibly other selects with date arithmetic, trying to figure out how to track them down is part of the goal of this post) where we aren't expecting them. MariaDB [testdb]> show variables like '%version%'; +-------------------------+---------------------+ | Variable_name | Value | +-------------------------+---------------------+ | innodb_version | 5.5.43-MariaDB-37.2 | | protocol_version | 10 | | slave_type_conversions | | | version | 5.5.44-MariaDB-log | | version_comment | MariaDB Server | | version_compile_machine | x86_64 | | version_compile_os | Linux | +-------------------------+---------------------+ 7 rows in set (0.00 sec) MariaDB [testdb]> show create table test \G *************************** 1. row *************************** Table: test Create Table: CREATE TABLE `test` ( `datetime` datetime NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 1 row in set (0.00 sec) MariaDB [testdb]> select datetime from test; Field 1: `datetime` Catalog: `def` Database: `velocitynorep` Table: `test` Org_table: `test` Type: DATETIME Collation: binary (63) Length: 19 Max_length: 19 Decimals: 0 Flags: NOT_NULL BINARY NO_DEFAULT_VALUE +---------------------+ | datetime | +---------------------+ | 2015-09-18 09:23:21 | +---------------------+ 1 row in set (0.00 sec) MariaDB [testdb]> select date_sub(datetime,interval 1 second) from test; Field 1: `date_sub(datetime,interval 1 second)` Catalog: `def` Database: `` Table: `` Org_table: `` Type: DATETIME Collation: binary (63) Length: 19 Max_length: 19 Decimals: 0 Flags: BINARY +--------------------------------------+ | date_sub(datetime,interval 1 second) | +--------------------------------------+ | 2015-09-18 09:23:20 | +--------------------------------------+ 1 row in set (0.00 sec) MariaDB [testdb]> select substr(datetime,1,13) from test; Field 1: `substr(datetime,1,13)` Catalog: `def` Database: `` Table: `` Org_table: `` Type: VAR_STRING Collation: utf8_general_ci (33) Length: 39 Max_length: 13 Decimals: 31 Flags: NOT_NULL +-----------------------+ | substr(datetime,1,13) | +-----------------------+ | 2015-09-18 09 | +-----------------------+ 1 row in set (0.00 sec) MariaDB [testdb]> select concat(substr(datetime,1,13),':00:00') -> from test; Field 1: `concat(substr(datetime,1,13),':00:00')` Catalog: `def` Database: `` Table: `` Org_table: `` Type: VAR_STRING Collation: utf8_general_ci (33) Length: 57 Max_length: 19 Decimals: 31 Flags: NOT_NULL +----------------------------------------+ | concat(substr(datetime,1,13),':00:00') | +----------------------------------------+ | 2015-09-18 09:00:00 | +----------------------------------------+ 1 row in set (0.00 sec) MariaDB [testdb]> select concat('2015-09-18 09',':00:00'); Field 1: `concat('2015-09-18 09',':00:00')` Catalog: `def` Database: `` Table: `` Org_table: `` Type: VAR_STRING Collation: utf8_general_ci (33) Length: 57 Max_length: 19 Decimals: 31 Flags: NOT_NULL +----------------------------------+ | concat('2015-09-18 09',':00:00') | +----------------------------------+ | 2015-09-18 09:00:00 | +----------------------------------+ 1 row in set (0.00 sec) MariaDB [testdb]> select date_sub(concat('2015-09-18 09',':00:00'), -> interval 1 second); Field 1: `date_sub(concat('2015-09-18 09',':00:00'), interval 1 second)` Catalog: `def` Database: `` Table: `` Org_table: `` Type: STRING Collation: binary (63) Length: 19 Max_length: 19 Decimals: 0 Flags: BINARY +---------------------------------------------------------------+ | date_sub(concat('2015-09-18 09',':00:00'), interval 1 second) | +---------------------------------------------------------------+ | 2015-09-18 08:59:59 | +---------------------------------------------------------------+ 1 row in set (0.00 sec) MariaDB [testdb]> select -> date_sub(concat(substr(datetime,1,13),':00:00'), -> interval 1 second) from test; Field 1: `date_sub(concat(substr(datetime,1,13),':00:00'), interval 1 second)` Catalog: `def` Database: `` Table: `` Org_table: `` Type: STRING Collation: binary (63) Length: 26 Max_length: 26 Decimals: 6 Flags: BINARY +---------------------------------------------------------------------+ | date_sub(concat(substr(datetime,1,13),':00:00'), interval 1 second) | +---------------------------------------------------------------------+ | 2015-09-18 08:59:59.000000 | +---------------------------------------------------------------------+ 1 row in set (0.00 sec) The last one is the one that has me stumped. 1.) Why does it include milliseconds in the output? According to this page: https://mariadb.com/kb/en/mariadb/microseconds-in-mariadb/ where no precision is specified the result should not display milliseconds, which is what happens in all the other examples above except this one. 2.) The statement on a 5.1 MySQL server (5.1.73-log, also 64 bit Linux) produces this: mysql> select date_sub(concat(substr(datetime,1,13),':00:00'), -> interval 1 second) from test; Field 1: `date_sub(concat(substr(datetime,1,13),':00:00'), interval 1 second)` Catalog: `def` Database: `` Table: `` Org_table: `` Type: STRING Collation: binary (63) Length: 29 Max_length: 19 Decimals: 31 Flags: BINARY +---------------------------------------------------------------------+ | date_sub(concat(substr(datetime,1,13),':00:00'), interval 1 second) | +---------------------------------------------------------------------+ | 2015-09-18 08:59:59 | +---------------------------------------------------------------------+ 1 row in set (0.00 sec) Is there some global variable I can set to revert to the 5.1 behavior? I realize I can CAST the result to a datetime to make sure I don't get the fractional seconds, but as I mentioned we're converting our system over to 5.5 and there's boatloads of code that I would have to scan through to try and find these differences. 3.) If there is no way to revert to the 5.1 behavior, can someone help me to understand the exact reason why the milliseconds get displayed on the final select in MariaDB 5.5? I'll need to look for any similar types of results and other than the exact reduction above I'm not sure what statements I would need to identify and test. Thanks for any assistance! Dan Ragle

3 7

[Maria-discuss] doubt about merge table (10000+) with same structure
by Roberto Spadim 23 Sep '15

23 Sep '15

Hi again guys :) i'm with a new problem i have MANY (10000+) tables with same struct, and i want to execute a select from "some" (100+) tables i was thinking about creating a view with all tables, something like: CREATE VIEW view_name AS SELECT * FROM table1 WHERE primary_key=<a value only at table1> UNION ALL SELECT * FROM table2 WHERE primary_key=<a value only at table2> UNION ALL SELECT * FROM table3 WHERE primary_key=<a value only at table3> UNION ALL SELECT * FROM table4 WHERE primary_key=<a value only at table4> UNION ALL ... SELECT * FROM tablen WHERE primary_key=<a value only at tablen> but i don't know if mysql optimizer will do a good job when i execute something like: SELECT * FROM view_name WHERE primary_key=<a value only located at table1> and just execute the query at table1 instead of alllllllll 10000+ tables i'm considering restruture database to a spider engine or any other method if i don't have other option any idea is well come -- Roberto Spadim

3 4

[Maria-discuss] WHY re TMM files never removed in 10.0.x
by Reindl Harald 20 Sep '15

20 Sep '15

i was flooded once again with mcron-mails "ERROR 144 (HY000) at line 1: Table './asterisk/cdr' is marked as crashed and last (automatic?) repair failed" well, because mariadb creates such temp files and don't remove them which makes myisam-recover-options = "FORCE" useless -rw-rw---- 1 mysql mysql 0 2015-08-21 13:47 cdr.TMM MariaDB [asterisk]> optimize table cdr; +--------------+----------+----------+------------------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +--------------+----------+----------+------------------------------------------------------------------------+ | asterisk.cdr | optimize | error | Can't create new tempfile: '/Volumes/dune/mysql_data/asterisk/cdr.TMM' | | asterisk.cdr | optimize | status | Operation failed | +--------------+----------+----------+------------------------------------------------------------------------+

2 5

[Maria-discuss] Cross compile issue
by Johnson Cheng 18 Sep '15

18 Sep '15

Hi, I have problem to do cross compile on mariadb-10.0.21. Where can I find the relative document? Best Regards, Johnson

2 17

[Maria-discuss] New Question: Which is the best solution to re-sync data if one of my mariadb servers was offline for few days?
by AskMonty KB 18 Sep '15

18 Sep '15

Hello, A new question has been asked in "MariaDB Community" by long_beo_g. Please answer it at http://mariadb.com/kb/en/which-is-the-best-solution-to-re-sync-data-if-one-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi all, In our system, we built only two Mariadb Galera servers. We use keepalived module to load balancing IP address . But we found out one of two servers offline for few days. When I start the offline server (server A), the online one (server B) take a long time to replicate to server A, run out of the server's resources. Could Mariadb masters tell me how to deal with this issue ? How could I sync online data to offline one, and make two servers run well online ? Thank you. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/which-is-the-best-solution-to-re-sync-data-if-one-…

1 0

[Maria-discuss] ODBC.NET DOWNLOAD
by Bruce Carlson 17 Sep '15

17 Sep '15

Hi, I'm trying to download the latest stable version of the MariaDB .net ODBC install MSI but every time I try I get directed to a log in page where I can't get any further unless I create some sort of personal information divulgence account. I have never had to do this before with any open source software. Where can I go to download the MSI without having to create an account that I have no intentions of ever doing. I have been using MySQL ever since the early days of version 3 something and have been using MariaDB ever since inception after the split with MySQL. I'm a dedicated and heavy user and supporter of MariaDB and have been for decades. If I am no longer able to download updates etc. without having to create some sort of GOOGLE account then I will not use MariaDB, I will find an alternative. Please advise. Bruce Carlson

3 3

Re: [Maria-discuss] ODBC.NET DOWNLOAD
by Bruce Carlson 17 Sep '15

17 Sep '15

Hi Jan, Appreciate your comments however the issue is not the availability of the source or my ability to compile my own binaries from the source and I would even be glad to pay a fee for the convenience of downloading a pre built MSI when installing on windows machines and I am reasonably happy with the occasional donations to open source I've been able to extract from my clients. (Although, I admit, we could all possibly do more in the area of digging up donations and raising funds is a constant issue for all open source organisations). My complaint is I object to being SPECIFICALLY targeted by advertising. The only benefit derived from insisting on this type of "account" is to directly target advertising. THERE IS NO OTHER BENEFIT. I do not object to advertising. When I'm browsing MariaDB I expect to get advertising from MariaDB and maybe some affiliates. And MariaDB has some excellent affiliates. I'm on the mailing lists and forums of several open source communities. They constantly send me advertising matter. I contribute. I donate. I do OBJECT to DIRECT TARGETING. Here is just one example of how this works :- Every time I use a web browser to search for any subject, the search engine will target me with advertising from those businesses that have specified my credentials with the search provider thereby denying me access to alternatives. And that is a very real concern and in my opinion is totally contrary to the principles of open source. It's at least contrary to my principles. Now you may think this is trivial and I'm over reacting but I want to be the person in charge of what information I'm fed. No matter how trivial that sounds to you. In the end, if the only way I can get hold of the binaries is to download the source and build my own, I will or find an alternative product. On a completely separate note, Whilst I disagree with you on the subject of direct targeting I completely agree with your attitude to renewables. And I feel just as strongly about both subjects. Regards, Bruce Carlson -----Original Message----- From: Jan Steinman [mailto:Jan@EcoReality.org] Sent: Thursday, 17 September 2015 12:26 PM To: Bruce Carlson Cc: Rasmus Johansson; Maria Discuss (maria-discuss(a)lists.launchpad.net) Subject: Re: [Maria-discuss] ODBC.NET DOWNLOAD On 2015-09-16, at 18:13, Bruce Carlson wrote: > the openness of open SOURCE [emphasis mine] Do you think you may be over-reacting just a bit? My understanding -- correct me if I'm wrong -- is that the SOURCE is freely downloadable, and that the extra content you vociferously object to is only presented if you choose to download a BINARY. Compiling, maintaining, and debugging binaries is NOT part of the "open source" agreement! Rather, it is a service for which one might expect to be compensated. If you want to compile and maintain and debug the SOURCE and provide binaries without advertising, YOU CAN! NO ONE IS STOPPING YOU! Again, my apology if I'm misunderstanding something, but I used Homebrew to download and compile the SOURCE for MariaDB, and I don't recall seeing ANY advertising of any sort. :::: We are like tenant farmers chopping down the fence around our house for fuel when we should be using nature's inexhaustible sources of energy - sun, wind and tide. I'd put my money on the sun and solar energy. What a source of power! I hope we don't have to wait until oil and coal run out before we tackle that. -- Thomas Alva Edison :::: Jan Steinman, EcoReality Co-op ::::

1 0

[Maria-discuss] New Question: Galera mysqld_multi - possible bug
by AskMonty KB 16 Sep '15

16 Sep '15

Hello, A new question has been asked in "MariaDB Community" by cisaksen. Please answer it at http://mariadb.com/kb/en/galera-mysqld_multi-possible-bug/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Not sure where to post this but I've come across this on a SLES 12 system. Running Galera 25.3.9-1 / MariaDB 10.1.6-1. Using the Mysqld_multi init.d script to start and stop multiple mysql instances through service or systemd commands I have found that the starting works just fine but stopping them doesn't. It will stop all the instances but the last one. Just for clarification cmd is : service mysqld_multi stop or systemctl stop mysqld_multi. I tried this with 2 and 3 mysql instances. With 2 instances, #1 would stop but #2 wouldn't. With 3 instances #1 & #2 would stop and #3 wouldn't. I have verified that the mysqladmin command works to shut the DB down with the multi_admin account I use. Now running mysqld_multi directly works just fine. Whether it's one specific instance or all of them. That is running the script directly /etc/init.d/mysqd_multi or the actual /usr/bin/mysqld_multi command directly. Both work as expected. I honestly don't know if this is a script problem or a systemd problem. I do know that in SLES 12, SUSE rewrote the mysql init.d script to include mysqld_multi if multiple instances were discovered in the my.cnf file. And this work great using systemd. Anyway there it is, if anyone has come across this on other systems it might be worth noting. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/galera-mysqld_multi-possible-bug/

1 0

[Maria-discuss] New Question: Connecting Issue
by AskMonty KB 13 Sep '15

13 Sep '15

Hello, A new question has been asked in "Development" by isyed. Please answer it at http://mariadb.com/kb/en/connecting-issue/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello. I've just downloaded and started using the C/C++ connector library (v.2.1.0), libmariadb.dll. I had simply dropped it in as a direct replacement for the MySQL C connector library (v.6.1.6 x64), libmysql.dll. While it works as expected, there is an unduly long lapse during mysql_real_connect(), lasting for about fifteen seconds, before the connection is established. With libmysql.dll, the connection is almost immediate. Might there be any additional setting that I may have missed to prevent this lapse? Thank you. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/connecting-issue/

1 0

[Maria-discuss] mycli
by Otto Kekäläinen 11 Sep '15

11 Sep '15

Hello! Have you seen this before http://mycli.net/ ? Has anybody used it, do you have an opinion if it is of good quality or not? This kind of autocomplete definitely helps newbies in remembering the correct SQL terms and I think the idea is great. - Otto

2 1

[Maria-discuss] New Question: Hybrid replication - issue
by AskMonty KB 11 Sep '15

11 Sep '15

Hello, A new question has been asked in "Replication, Cluster, & Multi-Master" by truptimali. Please answer it at http://mariadb.com/kb/en/hybrid-replication-issue/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I have been trying to implement a Hybrid replication. There is Async replication configured between two galera clusters. To begin with I have been trying this out on two datacenters dc1 and dc2. dc1 has two node galera cluster -- node1_dc1 , node2_dc1 dc2 has one node - just one primary galera node . node1_dc2 I have configured async replication between node1_dc1 and node1_dc2. But I am facing strange problem here. I could see replication happening nicely on all the three nodes involved. But When i tried to restart node2_dc1 ,(the secondary node from dc1's galera cluster) - i am not able to login to this node's mysql with root user. Or any user for that matter. Upon investigation using skip grant, found that the mysql.user table is emptied. (You can refer to the attached logs of node2_dc1 where I have highlighted removal messages in log). My doubts/concerns - 1) I am not sure what could have triggered this mysql table's removal in first place. 2) Inspite of this - I could get this node join the cluster. (Atleast as per the wsrep_cluster_size attribute on primary node) sharing my configurations on all the three nodes - 1) node1_dc1 (Primary Node) galera_cnf : [mysqld] #mysql settings binlog_format=ROW default-storage-engine=innodb innodb_autoinc_lock_mode=2 query_cache_size=0 query_cache_type=0 bind-address=0.0.0.0 log_slave_updates=1 #galera settings wsrep_provider=/usr/lib/galera/libgalera_smm.so wsrep_cluster_name=london_galera_cluster wsrep_cluster_address=gcomm:// wsrep_sst_method=xtrabackup-v2 wsrep_sst_auth="root:XXX" wsrep_restart_slave=1 # Galera Node Configuration wsrep_node_address="192.168.XXX.YYY" wsrep_node_name="192.168.XXX.YYY" ************************************ wan.cnf: [mysqld] server-id=101 gtid-domain-id=1 binlog-format=ROW log-slave-updates=1 log-bin=binlog wsrep-restart-slave=1 slave-skip-errors=1396 2) node2_dc1 (Secondary node): galera.cnf: [mysqld] #mysql settings binlog_format=ROW default-storage-engine=innodb innodb_autoinc_lock_mode=2 query_cache_size=0 query_cache_type=0 bind-address=0.0.0.0 log_slave_updates=1 #galera settings wsrep_provider=/usr/lib/galera/libgalera_smm.so wsrep_cluster_name=london_galera_cluster wsrep_cluster_address=gcomm://192.168.XXX.YYY,192.168.YYY.ZZ wsrep_sst_method=xtrabackup-v2 wsrep_sst_auth="root:XXX" wsrep_restart_slave=1 # Galera Node Configuration wsrep_node_address="192.168.YYY.ZZ" wsrep_node_name="192.168.YYY.ZZ" wan.cnf: [mysqld] server-id=102 gtid-domain-id=1 binlog-format=ROW log-slave-updates=1 log-bin=binlog wsrep-restart-slave=1 slave-skip-errors=1396 Node1_dc2 - Single node on datacenter-2 : galera.cnf: [mysqld] #mysql settings binlog_format=ROW default-storage-engine=innodb innodb_autoinc_lock_mode=2 query_cache_size=0 query_cache_type=0 bind-address=0.0.0.0 log_slave_updates=1 #galera settings wsrep_provider=/usr/lib/galera/libgalera_smm.so wsrep_cluster_name=calif_galera_cluster wsrep_cluster_address=gcomm:// wsrep_sst_method=xtrabackup-v2 wsrep_sst_auth="root:XXX wsrep_restart_slave=1 # Galera Node Configuration wsrep_node_address="192.168.ZZZ.XXX" wsrep_node_name="192.168.ZZZ.XXX" wan_repl.cnf: [mysqld] server-id=201 gtid-domain-id=1 binlog-format=ROW log-slave-updates=1 log-bin=binlog wsrep-restart-slave=1 slave-skip-errors=1396 ~ Note unique server-ids and common gtid-domain-id. Attaching logs of both the nodes in galera cluster in datacenter 1. lines to look for in node2.txt - file *********** Sep 10 21:06:21 localhost mysqld: 150910 21:06:21 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 0) Sep 10 21:06:21 localhost mysqld: 150910 21:06:21 [Note] WSREP: Requesting state transfer: success, donor: 0 Sep 10 21:06:22 localhost mysqld: WSREP_SST: [INFO] Proceeding with SST (20150910 21:06:22.394) Sep 10 21:06:22 localhost mysqld: WSREP_SST: [INFO] Cleaning the existing datadir (20150910 21:06:22.400) Sep 10 21:06:22 localhost mysqld: removed ?~@~X/var/lib/mysql/mysql_upgrade_info?~@~Y Sep 10 21:06:22 localhost mysqld: removed ?~@~X/var/lib/mysql/multi-master.info?~@~Y Sep 10 21:06:22 localhost mysqld: removed ?~@~X/var/lib/mysql/mysql/procs_priv.MYI?~@~Y Sep 10 21:06:22 localhost mysqld: removed ?~@~X/var/lib/mysql/mysql/user.MYI?~@~Y ***************** Sep 10 21:25:51 localhost /etc/mysql/debian-start[16787]: Triggering myisam-recover for all MyISAM tables Sep 10 21:25:53 localhost mysqld: 150910 21:25:53 [Note] WSREP: (81dce617, 'tcp://0.0.0.0:4567') turning message relay requesting off Sep 10 21:32:01 localhost mysqld: 150910 21:32:01 [ERROR] Slave SQL: Error 'Can't find any matching row in the user table' on query. Default database: 'mysql'. Query: 'SET PASSWORD FOR 'root'@'localhost'='*FD9D25929BE2AE3A18896D5D93AB9A7DD78D22E4'', Internal MariaDB error code: 1133 Sep 10 21:32:01 localhost mysqld: 150910 21:32:01 [Warning] WSREP: RBR event 1 Query apply warning: 1, 19504 ****************** -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/hybrid-replication-issue/

1 0

[Maria-discuss] New Question: MariaDB Galera bootstrap
by AskMonty KB 10 Sep '15

10 Sep '15

Hello, A new question has been asked in "MariaDB Community" by cisaksen. Please answer it at http://mariadb.com/kb/en/mariadb-galera-bootstrap/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Are there any references for a MariaDB Galera setup on a systemd system (SUSE 12). Having trouble getting the bootstrap to work. I can get the db to run but it won't connect to the galera provider. Not only that but i have to run /etc/init.d/mysql start --wsrep-new-cluster to get the script to accept the parameter. If I use service or systemctl they both return invalid parameter or option. Another thing is when I do run /etc/init.d/mysql it will start but systemctl status mysql won't know about it. Thnaks -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-galera-bootstrap/

1 0

[Maria-discuss] MariaDB 10.1.7 RC now available
by Daniel Bartholomew 09 Sep '15

09 Sep '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.7. This is the first Release Candidate (RC) release in the MariaDB 10.1 series. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.7 - Release Notes: https://mariadb.com/kb/en/mariadb-1017-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1017-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.1.7 About MariaDB 10.1: - https://mariadb.com/kb/en/what-is-mariadb-101/ 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: - http://mariadb.org/jira - - 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/ 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

1 0

[Maria-discuss] MySQL 5.7 JSON
by Tom Worster 04 Sep '15

04 Sep '15

Are MySQL 5.7 JSON features <http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-8.html#mysqld-5-7-8 -json> likely to end up in MariaDB anytime? If so, would it be 10.2? Tom

2 1

[Maria-discuss] New Question: Table replication with xtra column on slave
by AskMonty KB 01 Sep '15

01 Sep '15

Hello, A new question has been asked in "MariaDB Community" by rahularman. Please answer it at http://mariadb.com/kb/en/table-replication-with-xtra-column-on-slave/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have one table DailyMetrics on Interim server like below. Mater DB->Secondary DB--> Interim DB Master DB: Table DailyMetrics ( a char,b char Secondary DB: Table DailyMetrics ( a char,b char Interim DB: Table DailyMetrics ( a char,b char, InsertTime timestamp default current_timestamp) Replication is working fine but added column InsertTime on interim DB is storing 000.000.00 00-00-00 value. It is not storing current system timestamp. When I issue separate insert statement on slave side, it is storing system time but nor with replication. Can anyone suggest me how to achieve system timestamp on slave side. Other details as follows: MySQl DB: MariaDB 5.5.23 Replication Type: Row based. Platform: Linux -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/table-replication-with-xtra-column-on-slave/

1 0

[Maria-discuss] New Question: Login Question
by AskMonty KB 31 Aug '15

31 Aug '15

Hello, A new question has been asked in "MariaDB Documentation" by cisaksen. Please answer it at http://mariadb.com/kb/en/login-question/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm trying to log into a remote MairaDB and keep getting Host [IP] is not allowed to connect to this mariadb server. {client side} tried both mysql -p --port=3307 -h [hostname] mysql -p --port=3307 -h [hostname.domain.xxx] {server side} mysql login accounts tried user/root @ %.domain.xxx user/root @ hostname% Both client and server are in DNS and resolvable. What or how does mariadb determine when to use an IP vs hostname with connection security ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/login-question/

1 0

[Maria-discuss] Double linked list
by Roberto Spadim 28 Aug '15

28 Aug '15

hi guys, i'm with some doibts... I'm trying to replicate a double linked list, my information is: 1) insert at position xxx (and move others to next position) 2) update position yyyy 3) change position zzz with www 4) delete position xxxx to vvvv 5) return all positions 6) return positions with value > zzz My doubt is... I have only one writer and many many readers, writer can't be blocked for more than 1-3 seconds Some times i need to read history (functions 1 to 6) and recreate the linked list at a point in time List is something like: Position - json structure (arraylist in c#) like 0-[0,1,2,4,5] 1-[2.3,4,8,0] It update very fast, minimal update interval is 0.001second (max of 1000updates per second) for each list I will have 100-2000 lists --- Doubts : 1) Whats the best method to create the current double linked list? (The list positioned at last operatiom) A memory table? A row level lock table? A cache solution (memcached) with only one key-value and value with the full list? 2) considering a table: 2.1)what the best method to change position? Update set position=if() where position in (xxx, yyy) In this case what should be the primary key? If i use positionas primary key in this update i cam have non unique values... 2.2) ehat to do with delete/inserts? Insert+update positions? Delete+update positions? 3) any idea if oqgraph could solve this or if there's a storage engine solving this problem? Thanks guys :) -- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle

1 0

[Maria-discuss] random non-zero exit status 1
by Reindl Harald 26 Aug '15

26 Aug '15

on machines mysqld mysqld regulary for backup reasons i observe over months now *randomly* starting mysqld fails because exit-code 1 leading in systemd stop the service and start it again while the is no single indication on the mysqld error-log anybody else? ________________________________________________________________________________ Aug 26 01:45:02 buildserver systemd: Stopping MariaDB Database... Aug 26 01:45:03 buildserver systemd: Stopped MariaDB Database. Aug 26 01:45:10 buildserver systemd: Starting MariaDB Database... Aug 26 01:45:10 buildserver mysqld: 150826 1:45:10 [Note] /usr/libexec/mysqld (mysqld 10.0.21-MariaDB) starting as process 31936 ... Aug 26 01:45:10 buildserver systemd: mysqld.service: control process exited, code=exited status=1 Aug 26 01:45:12 buildserver systemd: Failed to start MariaDB Database. Aug 26 01:45:12 buildserver systemd: Unit mysqld.service entered failed state. Aug 26 01:45:12 buildserver systemd: mysqld.service failed. Aug 26 01:45:13 buildserver systemd: mysqld.service holdoff time over, scheduling restart. Aug 26 01:45:14 buildserver systemd: Stopping MariaDB Database... Aug 26 01:45:14 buildserver systemd: Starting MariaDB Database... Aug 26 01:45:14 buildserver mysqld: 150826 1:45:14 [Note] /usr/libexec/mysqld (mysqld 10.0.21-MariaDB) starting as process 31988 ... Aug 26 01:45:14 buildserver systemd: Started MariaDB Database. ________________________________________________________________________________ 150826 1:45:02 [Note] /usr/libexec/mysqld: Normal shutdown 150826 1:45:02 [Note] Event Scheduler: Purging the queue. 0 events 150826 1:45:02 [Note] InnoDB: FTS optimize thread exiting. 150826 1:45:02 [Note] InnoDB: Starting shutdown... 150826 1:45:03 [Note] InnoDB: Shutdown completed; log sequence number 17271831 150826 1:45:03 [Note] /usr/libexec/mysqld: Shutdown complete 150826 1:45:10 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150826 1:45:10 [Note] InnoDB: The InnoDB memory heap is disabled 150826 1:45:10 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150826 1:45:10 [Note] InnoDB: Memory barrier is not used 150826 1:45:10 [Note] InnoDB: Compressed tables use zlib 1.2.8 150826 1:45:10 [Note] InnoDB: Using Linux native AIO 150826 1:45:10 [Note] InnoDB: Using CPU crc32 instructions 150826 1:45:10 [Note] InnoDB: Initializing buffer pool, size = 16.0M 150826 1:45:10 [Note] InnoDB: Completed initialization of buffer pool 150826 1:45:10 [Note] InnoDB: Highest supported file format is Barracuda. 150826 1:45:10 [Note] InnoDB: 128 rollback segment(s) are active. 150826 1:45:10 [Note] InnoDB: Waiting for purge to start 150826 1:45:10 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 17271831 150826 1:45:10 [Note] Plugin 'FEEDBACK' is disabled. 150826 1:45:10 [Note] Server socket created on IP: '127.0.0.1'. 150826 1:45:10 [Note] /usr/libexec/mysqld: Normal shutdown 150826 1:45:10 [Note] Event Scheduler: Loaded 0 events 150826 1:45:10 [Note] /usr/libexec/mysqld: ready for connections. Version: '10.0.21-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 thelounge 150826 1:45:10 [Note] Event Scheduler: Purging the queue. 0 events 150826 1:45:10 [Note] InnoDB: FTS optimize thread exiting. 150826 1:45:10 [Note] InnoDB: Starting shutdown... 150826 1:45:12 [Note] InnoDB: Shutdown completed; log sequence number 17271841 150826 1:45:12 [Note] /usr/libexec/mysqld: Shutdown complete 150826 1:45:14 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150826 1:45:14 [Note] InnoDB: The InnoDB memory heap is disabled 150826 1:45:14 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150826 1:45:14 [Note] InnoDB: Memory barrier is not used 150826 1:45:14 [Note] InnoDB: Compressed tables use zlib 1.2.8 150826 1:45:14 [Note] InnoDB: Using Linux native AIO 150826 1:45:14 [Note] InnoDB: Using CPU crc32 instructions 150826 1:45:14 [Note] InnoDB: Initializing buffer pool, size = 16.0M 150826 1:45:14 [Note] InnoDB: Completed initialization of buffer pool 150826 1:45:14 [Note] InnoDB: Highest supported file format is Barracuda. 150826 1:45:14 [Note] InnoDB: 128 rollback segment(s) are active. 150826 1:45:14 [Note] InnoDB: Waiting for purge to start 150826 1:45:14 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 17271841 150826 1:45:14 [Note] Plugin 'FEEDBACK' is disabled. 150826 1:45:14 [Note] Server socket created on IP: '127.0.0.1'. 150826 1:45:14 [Note] Event Scheduler: Loaded 0 events 150826 1:45:14 [Note] /usr/libexec/mysqld: ready for connections. Version: '10.0.21-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 thelounge

1 0

[Maria-discuss] New Question: MariaDB 10.1 system variables
by AskMonty KB 26 Aug '15

26 Aug '15

Hello, A new question has been asked in "What is in the Different MariaDB Releases?" by diptijoshi. Please answer it at http://mariadb.com/kb/en/mariadb-101-system-variables/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- What is the difference between MariaDB 10.1 and MySQL 5.6 system variables ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-101-system-variables/

1 0

[Maria-discuss] New Question: SET Variable statement
by AskMonty KB 24 Aug '15

24 Aug '15

Hello, A new question has been asked in "MariaDB Community" by cisaksen. Please answer it at http://mariadb.com/kb/en/set-variable-statement/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm trying to write a SQL script that creates a database and a few other things. I'm having trouble with a user defined variable statement. SET @dbname = CAST(trees AS VARCHAR(10)); comes directly from https://mariadb.com/kb/en/mariadb/user-defined-variables/ And I keep getting --> Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'VARCHAR(10))' at line 1 Running MariaDB 10.0.20 on SLES 12, I have no idea what the problem is ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/set-variable-statement/

1 0

[Maria-discuss] New Question: Visual Studio - MariaDB - Entity Framework 6+
by AskMonty KB 23 Aug '15

23 Aug '15

Hello, A new question has been asked in "MariaDB FAQ" by vaclav. Please answer it at http://mariadb.com/kb/en/visual-studio-mariadb-entity-framework-6/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Dear Specialists, We can use at the moment "Visual Studio ADO.NET Driver for MySQL" (https://www.mysql.com/products/connector/) and also there was lots of work done with Visual Studio Integration for MySQL. (http://dev.mysql.com/doc/connector-net/en/connector-net-visual-studio.html) The question is while now it is compatible with MariaDB and I can use MariaDB instead of MySQL, how long if at all there will be a point when this won't become anymore compatible. Is this connection compatibility related with a core or some layer in MariaDB which doesn't change and so it should be working in the future. The reason I am asking is to decide with the strategy. I am testing MariaDB with Entity Framework and the driver/connection mentioned above and it is working but what if you deviate from the connectivity at certain point? Thank you. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/visual-studio-mariadb-entity-framework-6/

1 0

[Maria-discuss] problem with optimizer
by Roberto Spadim 21 Aug '15

21 Aug '15

Hi guys I'm running two queries: first: explain SELECT lote_spa,mov_id FROM est_mov WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa IN (1150150.0,1150532.0,1152187.0,1152361.0,1155813.0,1156244.0,1156654.0) AND item_id=67 AND item_id_red=1423 it use primary key and key_len =16 but including a new = element [AND oe_tipo='oe' ]: explain SELECT lote_spa,mov_id FROM est_mov WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa IN (1150150.0,1150532.0,1152187.0,1152361.0,1155813.0,1156244.0,1156654.0) AND item_id=67 AND item_id_red=1423 AND oe_tipo='oe' it use primary key but key_len=4 (near to a full table scan) what's wrong? -- Roberto Spadim

1 2

[Maria-discuss] New Question: Multiple DB instances - in multiple cnf files
by AskMonty KB 20 Aug '15

20 Aug '15

Hello, A new question has been asked in "MariaDB Community" by cisaksen. Please answer it at http://mariadb.com/kb/en/multiple-db-instances-in-multiple-cnf-files/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it possible to breakup the [mysqldx] [mysqld1] .. [mysqld2] .. and so on into multiple cnf. files (like one each) and include them using the !includedir statement ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/multiple-db-instances-in-multiple-cnf-files/

1 0

[Maria-discuss] New Question: PDF or search area
by AskMonty KB 20 Aug '15

20 Aug '15

Hello, A new question has been asked in "MariaDB Documentation" by cisaksen. Please answer it at http://mariadb.com/kb/en/pdf-or-search-area/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is there a PDF version of the documentation or a way to search the online documentation ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/pdf-or-search-area/

1 0

[Maria-discuss] Mariadb 10.1.6, total cluster recovery - gvwstate.dat
by Max Zulio 19 Aug '15

19 Aug '15

Hi, I am using a Mariadb 10.1.6 three node cluster with wsrep. There is a gvwstate.dat file created in /var/lib/mysql, but in the log file when restarting the nodes I see: [Warning] WSREP: access file(gvwstate.dat) failed(No such file or directory). This seems to be the only thing stopping automatic cluster recovery. Where is mariadb looking for the file, or is there a way of configuring the file location? Thanks, M

4 5

[Maria-discuss] New Question: Fitting index not used
by AskMonty KB 19 Aug '15

19 Aug '15

Hello, A new question has been asked in "Query Optimizations" by mandark. Please answer it at http://mariadb.com/kb/en/fitting-index-not-used/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- MariaDB version: mysql Ver 15.1 Distrib 10.1.2-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 Here is the simplified situation (Query with like 10 joins, so I simplify to the simpliest query still reproducing the problem when working on slow queries): ``` SELECT article.article_id FROM article -- USE INDEX (s_ti_pd) LEFT JOIN member ON member.member_id = article.member_id WHERE article.thema_id = 29 AND article.state = 1 ORDER BY published_date LIMIT 0, 3; ``` - I have an index on `state, thema_id, published_date` which fit particularly well from my point of view (Query run in a few milliseconds using it) - When using `state, thema_id, published_date` index, explain give me: key_len: 8, ref: const,const, rows: 15006, filter: 100.00, Using where - I have another index on `published_date` only (Query run in ~1s using it) - When using `published_date` index, explain give me: key_len: 9, rows: 94, filtered: 100.00, Using where - Table have a few other indexes... - Forcing the usage of the index ran my query in a few milliseconds, without, one second. - Removing the LEFT JOIN makes MariaDB use the good index - Changing the thema_id sometimes change the index used I dont see any factor that may tell the query optimizer to use published_date. In fact I see only one, it's shorter, so faster to read. But the `status, thema_id, published_date` index seems, for me, obviously better, as it starts with two consts, and also can be used for the ORDER BY. What can I do to understand MariaDB on this choice ? I only tried an "analyze table" but engine side, not "table side", for the moment, it changed nothing. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/fitting-index-not-used/

1 0

[Maria-discuss] MariaDB Galera Cluster 10.0.21 and 5.5.45 now available
by Daniel Bartholomew 18 Aug '15

18 Aug '15

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.21 and 5.5.45. These are both Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 10.0.21 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-10021-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-10021-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.21 MariaDB Galera Cluster 5.5.45 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-5545-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-5545-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.45 About MariaDB Galera Cluster: https://mariadb.com/kb/en/what-is-mariadb-galera-cluster 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: - http://mariadb.org/jira - - 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/ 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

1 0

[Maria-discuss] New Question: Mariadb match against a view (fulltext search) fails; succeeds in MySql
by AskMonty KB 18 Aug '15

18 Aug '15

Hello, A new question has been asked in "Moving to MariaDB" by henrik_bechmann_g. Please answer it at http://mariadb.com/kb/en/mariadb-match-against-a-view-fulltext-search-fails… as the person asking the question may not be subscribed to the mailing list. -------------------------------- The fulltext search query below fails in mariadb, but succeeds in mysql (mariadb database imported from mysql database using phpmyadmin). If a base table is substituted, the query succeeds in both mariadb and mysql. So apparently mariadb cannot match against views. Is there a solution to this? It's messing up my migration. Using 10.0.21. Thanks. SELECT Title FROM Nodes_View WHERE (MATCH(Title,Caption,Description,Location,Body) AGAINST ('something')) -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-match-against-a-view-fulltext-search-fails…

1 0

[Maria-discuss] New Question: Mariadb match against a view (fulltext search) fails; succeeds in MySql
by AskMonty KB 18 Aug '15

18 Aug '15

Hello, A new question has been asked in "Moving to MariaDB" by henrik_bechmann_g. Please answer it at http://mariadb.com/kb/en/mariadb-match-against-a-view-fulltext-search-fails… as the person asking the question may not be subscribed to the mailing list. -------------------------------- The fulltext search query below fails in mariadb, but succeeds in mysql (mariadb database imported from mysql database using phpmyadmin). If a base table is substituted, the query succeeds in both mariadb and mysql. So apparently mariadb cannot match against views. Is there a solution to this? It's messing up my migration. Using 10.0.21. Thanks. SELECT Title FROM Nodes_View WHERE (MATCH(Title,Caption,Description,Location,Body) AGAINST ('something')) -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-match-against-a-view-fulltext-search-fails…

1 0

[Maria-discuss] Latest round of Oracle CVE status on MariaDB
by Brian Evans 13 Aug '15

13 Aug '15

The quarterly CVE list from oracle was published[1]. The following CVEs are listed there affecting 5.5, but not listed on the MariaDB security page[2]. CVE-2015-4757 CVE-2015-4752 CVE-2015-4737 CVE-2015-2648 CVE-2015-2643 CVE-2015-2620 CVE-2015-2582 Are they fixed with 5.5.45 and 10.0.21, or any other version? Brian [1] http://www.oracle.com/technetwork/topics/security/cpujul2015-2367936.html#A… [2] https://mariadb.com/kb/en/mariadb/security/

2 1