- discuss - lists.mariadb.org

[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