- discuss - lists.mariadb.org

[Maria-discuss] Debian 9.2 - Kytea
by Guillermo Cespedes 30 Nov '17

30 Nov '17

Hi, I'm compiling MariaDb in Debian 9.2. Is dependence on Kytea necessary? I need to compile Kytea previously. As you know, the Kytea package is no longer available in the Debian repositories. http://www.phontron.com/kytea/ <http://www.phontron.com/kytea/> https://github.com/dertin/lemp-stack-debian/blob/develop/install.sh#L105 <https://github.com/dertin/lemp-stack-debian/blob/develop/install.sh#L105> regards Guillermo Céspedes Full Stack Developer

3 2

[Maria-discuss] Mariadb-10.2.11 missing tokudb rpm
by Reinis Rozitis 29 Nov '17

29 Nov '17

Hi, the mariadb-10.2.11 release (all distros) is missing *-tokudb-engine.rpm package. Is this a build/packaging error or something more (though nothing in the Release notes)? rr

2 1

[Maria-discuss] MariaDB 10.2 now available on CentOS 6 &7 via SCL !!
by Michal Schorm 29 Nov '17

29 Nov '17

Hello everybody, In case you missed it, I just want to share an announce of availability of MariaDB 10.2 on CentOS 6 & 7 as a Software collections. Here are the announce emails from CentOS mailing list, which contains most basic howto: https://lists.centos.org/pipermail/centos-announce/2017-November/022640.html https://lists.centos.org/pipermail/centos-announce/2017-November/022642.html -- This made MariaDB 10.2 a big step closer to a new mass of users, because the standard MDB version in CentOS & RHEL is 5.5. It took quite an effort to fine-tune and perk-up the MDB 10.2 since its first attemps in Fedora, however it is always pleasure to cooperate with developers like you :) -- Michal Schorm Associate Software Engineer Core Services - Databases Team Red Hat

1 0

[Maria-discuss] installing mariadb using rpm
by Mark Edwards 28 Nov '17

28 Nov '17

hello - i was following an earlier thread titled: [Maria-discuss] Install MariaDB repo official Centos-7 this is the first time i have attempted an RPM install. so i decided to try it myself, using 10.2 on a new Centos7 installation created in google-console. the installation went perfectly, but now i have a question. i let mariadb generate my repo using this link: https://downloads.mariadb.org/mariadb/repositories/#mirror=jaleco&distro=Ce… and the following repo was generated: # MariaDB 10.2 CentOS repository list - created 2017-11-28 17:28 UTC # http://downloads.mariadb.org/mariadb/repositories/ [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.2/centos7-amd64 gpgkey= https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1 my question: when i cat /proc/cpuinfo, i see the following: vendor_id : GenuineIntel model name : Intel(R) Xeon(R) CPU @ 2.30GHz and yet the repo specifies "centos7-amd64". does it matter that amd64 is being specified rather than Intel? Thank you, Mark Edwards

2 2

[Maria-discuss] Install MariaDB repo official Centos-7
by Wilmer Arambula 28 Nov '17

28 Nov '17

Hi, install MariaDB from the official repository [mariadb.org] for Centos-7: 1.- yum install MariaDB-server MariaDB-client When executing: 2.- systemctl start mariadb.service Error: Failed to start mariadb.service: Unit not found. Thks,

4 4

[Maria-discuss] MariaDB won't start after updating Fedora 26 to Fedora 27
by Bill Damage 23 Nov '17

23 Nov '17

After checking the logs I see mysqld: Can't create/write to file '/var/run/mariadb/mariadb.pid' (Errcode: 2 "No such file or directory")If I manually create this dir I can then start it ... until the next reboot. What is the correct fix to ensure its works as it did before the update please?

3 4

[Maria-discuss] ALTER TABLE removes check constraint
by Peter Laursen 22 Nov '17

22 Nov '17

Test case: CREATE TABLE checks (a INT CHECK (a>2), b INT CHECK (b>2), CONSTRAINT a_greater CHECK (a>b)); SHOW CREATE TABLE checks; ALTER TABLE `test`.`checks` CHANGE `a` `a` INT(11) NULL; SHOW CREATE TABLE checks; /' -- and now one constraint is gone! CREATE TABLE `checks` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL CHECK (`b` > 2), CONSTRAINT `a_greater` CHECK (`a` > `b`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 */ This docs page https://mariadb.com/kb/en/library/constraint/ does not say that (unnamed) CHECK constraints (ie. defined "column-wise") may be removed like this. In this case the ALTER changes one column to what it already was and still the CONSTRAINT is removed. A more realistic scenario is that someone has an INT column that is about to overflow and wants to change it to a BIGINT. I am not sure if this is an oversight/a bug or not. But if it is not, I think the docs page should clearly state that "an unnamed CHECK constraint is droppped implicitly when an ALTER TABLE statement is executed and this ALTER TABLE statement references the particular column and the ALTER TABLE statement does not recreate the CONSTRAINT". There will be other cases where such ALTER TABLE would violate the CONSTRAINT due to already existing data. Wasn't it better if the ALTER TABLE failed then, rather than dropping the CONSTRAINT? What do standards say? How do other RDBMS behave with this? Does somebody know more about this? What say? -- Peter -- Webyog

3 5

[Maria-discuss] innodb and corrupted tables
by Federico Razzoli 20 Nov '17

20 Nov '17

I just noticed this old MySQL bug:https://bugs.mysql.com/bug.php?id=10132 In the comments (2005 to 2014) everyone seems to agree that current behaviour should be treated as a bug.The main commenter now works for MariaDB.What is currently your opinion? Will this behaviour change at some point? If so, what will be the consequences for Galera? Federico

3 3

[Maria-discuss] MariaDB GUI: BSL 1.1 - Debate
by Juan Telleria 19 Nov '17

19 Nov '17

Dear MariaDb Developers, I am writing because I would like to open a debate whether if MariaDB, now that has gained investment from Microsoft, Alibaba, and the European Union, shall create its own SQL Graphical User Interface, as good as (or better than) MySQL Workbench. I agree that MariaDB includes by default HeidiSQL in its Windows builds, but in my opinion, if MariaDB really wants to look Oracle's MySQL face to face, HeidiSQL is not nearly as good as MySQL Workbench. If this wants to be done: 1st) The brand new GUI shall have a Business Source Licence v1.1, which only companies which invest in MariaDB would be able to use. 2nd) In 3 years now, MariaDB would be better positioned and have a fully Open Source GUI which would allow MariaDB to look face to face to Oracle. 3rd) And in 4/5 years now, MariaDB Corporation shall be brave enough to to continue Developing this GUI as a truly open source product, without the BSL, and adopting a purely GPLv2 with incremental improvements, distributing it through the MariaDB Foundation Webpage, as individuals or other companies apart from MariaDB Corporation, will not support the product if it is not totally Open Source. So BSL v1.1 might prove useful to launch the project, but with time, it shall have a GPLv2 for gaining investment from third companies. ¿What do you thing on the topic? Thank you all, Juan Telleria

1 1

[Maria-discuss] MariaDB upgrade 10.1 to 10.2 CentOS7
by Karthick Subramanian 13 Nov '17

13 Nov '17

All, Did anyone face issues after upgrading the mariadb from 10.1 to 10.2 to login to root user as shown below: mysql -u root I got the error - unix_socket not loaded. I noticed that the unix_socket authentication is required after the upgrade for root login from localhost. Can anyone confirm whether this is part of the feature after upgrades. In my previous version: select user, plugin from mysql.user; +-----------+------+-------------+ | Host | User | plugin | +-----------+------+-------------+ | localhost | root | | ------------------------------------ After upgrade: select user, plugin from mysql.user; +-----------+------+-------------+ | Host | User | plugin | +-----------+------+-------------+ | localhost | root | unix_socket | --------------------------------------- Regards, Karthick

3 9