July 2015 - discuss - lists.mariadb.org

[Maria-discuss] MariaDB 10.1.6 beta now available
by Daniel Bartholomew 27 Jul '15

27 Jul '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.6. This is a Beta release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.6 - Release Notes: https://mariadb.com/kb/en/mariadb-1016-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1016-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.1.6 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] Travis-CI and MariaDB
by Daniel Black 24 Jul '15

24 Jul '15

For those that use or develop open source or commercial projects that use Travis CI MariaDB has been added as a plugin. This installs either 5.5, 10.0 or 10.1 from the latest MariaDB repo against for testing. Documentation isn't up yet however it is planned. ref: https://github.com/travis-ci/travis-build/pull/303 As an example of Syntax (https://github.com/grooverdan/PyMySQL/blob/c05bf7c6d0f3161d91b3e1418ac185b8…) to test against all MariaDB versions as well as the pre-installed MySQL. Quick snippet: matrix: include: - addons: mariadb: 5.5 - addons: mariadb: 10.0 - addons: mariadb: 10.1 So add it to your own project's .travis.yml or send a PR to your favourite github project that can use MariaDB and Travis-ci. As for MariaDB-server in Travis-CI? we'll see if the bug committing fairies decide https://github.com/MariaDB/server/pull/84 is useful. -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise & maintenance for MySQL/MariaDB server environments.

2 3

[Maria-discuss] stored procedures external languages
by Federico Razzoli 23 Jul '15

23 Jul '15

Hi all I remember these slides and this worklog about supporting external languages for stored procedures: * http://www.slideshare.net/AntonyTCurtis/external-stored-proceduresformysql2… * http://www.slideshare.net/AntonyTCurtis/a-tour-of-external-language-stored-… * https://dev.mysql.com/worklog/task/?id=820 As far as I can guess from the slides, there has been some active work on this idea, and some working code. I hoped so badly that I could see this in 5.x, and then in10.0, and then in 10.1. Is there any chance to see this feature in a future release, or should I just stop waiting? Please, consider all the benefits that would come from this: using a "real" language, using existing libraries, getting rid of almost all current stored procedures limitations... Regards Federico

4 5

[Maria-discuss] New Question: Installing on Windows 2008
by AskMonty KB 22 Jul '15

22 Jul '15

Hello, A new question has been asked in "MariaDB Community" by meysey. Please answer it at http://mariadb.com/kb/en/installing-on-windows-2008/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- We are currently MySQL users at the school and I want to migrate us to MariaDB. I tried installing mariadb-5.5.44-winx64.msi and although it installed fine there was no option to migrate the MySQL databases while I installed and there is no migration wizard in the stat menu too. Can anyone help me get up and running. TIA Charlie Markwick -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/installing-on-windows-2008/

1 0

[Maria-discuss] will maria db overcome mysqls feature limitations? (foreign keys+triggers, recursive triggers)
by Ludwig Gramberg 19 Jul '15

19 Jul '15

Hi, I was wondering if mariadb plans to overcome mysqls limitations such as - foreign key operations do not start triggers - triggers can’t be recursive (error 1442) I know that mariadb wants to be compatible with mysql but maybe these features could be optional? The mysql/mariadb comparison shows additional features which wont break compatibility I guess because they don’t exist in mysql (yet?). But besides additional features, is there a chance that mariadb could ever overcome limitations? Is this even a goal of this project? So far I only found postgres to support these features. Background of this question: I am developing an object relational mapper and my goal is to have the database enforce the consistency. So triggers and foreign key constraints working together are vital for this. regards Ludwig

4 5

[Maria-discuss] INSERT IGNORE and triggers
by Federico Razzoli 19 Jul '15

19 Jul '15

Hello. As we all know, IGNORE "catches" some errors and turns them into warnings. But I've noticed that it does not catch the same errors if they were issued by a trigger (using SIGNAL). * Is this by design? * Is this standard SQL behaior? Here is a trigger example to show what I mean: CREATE TRIGGER bi_t BEFORE INSERT ON t FOR EACH ROW BEGIN SIGNAL SQLSTATE '23000' SET MYSQL_ERRNO = 1048; END Regards Federico

2 1

[Maria-discuss] mysqlbinlog
by Rhys.Campbell＠swisscom.com 18 Jul '15

18 Jul '15

Hello All, I've been playing with mysqlbinlog today. I'm Looking at performing backups of the binary logs. The MariaDB<https://mariadb.com/kb/en/mariadb/mysqlbinlog-options/> mysqlbinlog lags behind the MySQL<https://mariadb.com/kb/en/mariadb/mysqlbinlog-options/> version in the sense it's missing a few features. Namely the ability to 'tail' a live binary log... mysqlbinlog --read-from-remote-server --host=host_name --raw --stop-never binlog.000999 I haven't fully tested this but running the MySQL version against MariaDB doesn't appear viable. I'm probably going to fall back to a FLUSH LOGS / file copy solution for the moment. What would be the chances of back-porting these features into the MariaDB version? Cheers, Rhys

4 13

[Maria-discuss] New Question: Ubuntu vivid package missing virtual-mysql-server-core
by AskMonty KB 17 Jul '15

17 Jul '15

Hello, A new question has been asked in "MariaDB Galera Cluster" by wolfgang-baron. Please answer it at http://mariadb.com/kb/en/ubuntu-vivid-package-missing-virtual-mysql-server-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- On ubuntu vivid, the current mariadb-galera-server-10.0 package does not provide virtual package virtual-mysql-server-core (it only provides virtual-mysql-server), which disables the installation of akonadi-backend-mysql, which is obligatory for akonadi-server and thus all akonadi using programs. Is there a way to fake this provision? How do I report a bug like this? Thanks for any help! -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/ubuntu-vivid-package-missing-virtual-mysql-server-…

1 0

[Maria-discuss] Getting PAM auth to work with JDBC
by Troels Arvin 16 Jul '15

16 Jul '15

I've got the PAM authentication to work, as long as I use a plain command line MariaDB client or HeidiSQL. But I need things to work with JDBC as well. I've found some instructions what seem to indicate that I need to somehow make the JDBC connection use SQL and plain-text authentication. But I have not been able to find specific instructions on doing that. (The instructions, I've seen seem to mainly point to other documents in a circular/byzantine way.) Has someone got the combination of a JDBC client and an PAM-enabled MariaDB server to work? If so: Can you shed some light on the steps you went through? Thanks in advance. -- Regards, Troels Arvin http://troels.arvin.dk

3 2

[Maria-discuss] New Question: ERROR 1932 on a table with recently added VIRTUAL column
by AskMonty KB 16 Jul '15

16 Jul '15

Hello, A new question has been asked in "MariaDB Community" by Bytesmiths. Please answer it at http://mariadb.com/kb/en/error-1932-on-a-table-with-recently-added-virtual-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Using version "10.1.0-MariaDB-log - Source distribution" on MacOS X Server 10.6.8 via phpMyAdmin 4.1.8 using raw SQL, I recently used ALTER TABLE to add a VIRTUAL column to a table that was the simple difference between two columns: "ALTER TABLE s_vehicle_log ADD COLUMN v_distance INT(5) AS (odometer - begin) AFTER odometer". This first appeared to work; I could see the new column in phpMyAdmin and it appeared to have the proper values. But within an hour, I could no longer access that table. Going into the mysql CLI, executing "SELECT count(*) FROM s_vehicle_log;" yields "ERROR 1932 (42S02): Table 'EcoReality.s_vehicle_log' doesn't exist in engine" (I do the same on other tables in the same database successfully.) Going into the shell (bash), I can see the proper files, and they have the same perms as other tables that work properly: # ls -l s_vehicle_* -rw-rw---- 1 _mysql _mysql 1264 Feb 12 18:40 s_vehicle_cost.frm -rw-rw---- 1 _mysql _mysql 98304 Feb 12 18:40 s_vehicle_cost.ibd -rw-rw---- 1 _mysql _mysql 3796 Jul 15 15:56 s_vehicle_log.frm -rw-rw---- 1 _mysql _mysql 688128 Jul 15 15:56 s_vehicle_log.ibd -rw-rw---- 1 _mysql _mysql 2583 Feb 12 18:40 s_vehicle_monthly_query.frm It is interesting that, though ERROR 1932 says the table doesn't exist, phpMyAdmin shows it in the list of tables, showing "in use" as its table type: s_vehicle_cost Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~11 InnoDB latin1_swedish_ci 16 KiB - s_vehicle_log Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop in use mysql SHOW TABLE STATUS isn't very helpful, either: MariaDB [EcoReality]> show table status like 's_vehicle_%' -> ; +-------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+----------------------------------------------------------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +-------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+----------------------------------------------------------+ | s_vehicle_cost | InnoDB | 10 | Compact | 11 | 1489 | 16384 | 0 | 0 | 0 | NULL | 2015-02-12 18:40:32 | NULL | NULL | latin1_swedish_ci | NULL | | Cost per km of vehicles over time. | | s_vehicle_log | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Table 'EcoReality.s_vehicle_log' doesn't exist in engine | | s_vehicle_monthly_query | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Table 'EcoReality.s_vehicle_log' doesn't exist in engine | +-------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+----------------------------------------------------------+ 3 rows in set, 2 warnings (0.00 sec) Looking at the most recent file that seems to be a binlog reveals nothing of interest; just phpMyAdmin logging queries about the damaged table: # mysqlbinlog ../mysql-bin.000127 | fgrep s_vehicle_log REPLACE INTO `phpmyadmin`.`pma__table_uiprefs` VALUES ('root', 'EcoReality', 's_vehicle_log', '[]', NULL) REPLACE INTO `phpmyadmin`.`pma__recent` (`username`, `tables`) VALUES ('root', '[{"db":"EcoReality","table":"s_where_heard"},{"db":"EcoReality","table":"s_product_sales_log"},{"db":"EcoReality","table":"s_animal_notes"},{"db":"EcoReality","table":"s_product_harvest"},{"db":"EcoReality","table":"s_timelog"},{"db":"EcoReality","table":"s_project"},{"db":"EcoReality","table":"s_product"},{"db":"Personal","table":"Weight"},{"db":"EcoReality","table":"s_vehicle_log"},{"db":"EcoReality","table":"s_shares"}]') REPLACE INTO `phpmyadmin`.`pma__recent` (`username`, `tables`) VALUES ('root', '[{"db":"EcoReality","table":"s_timelog"},{"db":"EcoReality","table":"s_where_heard"},{"db":"EcoReality","table":"s_product_sales_log"},{"db":"EcoReality","table":"s_animal_notes"},{"db":"EcoReality","table":"s_product_harvest"},{"db":"EcoReality","table":"s_project"},{"db":"EcoReality","table":"s_product"},{"db":"Personal","table":"Weight"},{"db":"EcoReality","table":"s_vehicle_log"},{"db":"EcoReality","table":"s_shares"}]') REPLACE INTO `phpmyadmin`.`pma__recent` (`username`, `tables`) VALUES ('root', '[{"db":"EcoReality","table":"s_product_sales_log"},{"db":"EcoReality","table":"s_timelog"},{"db":"EcoReality","table":"s_where_heard"},{"db":"EcoReality","table":"s_animal_notes"},{"db":"EcoReality","table":"s_product_harvest"},{"db":"EcoReality","table":"s_project"},{"db":"EcoReality","table":"s_product"},{"db":"Personal","table":"Weight"},{"db":"EcoReality","table":"s_vehicle_log"},{"db":"EcoReality","table":"s_shares"}]') repair table s_vehicle_log REPLACE INTO `phpmyadmin`.`pma__recent` (`username`, `tables`) VALUES ('root', '[{"db":"EcoReality","table":"s_timelog"},{"db":"EcoReality","table":"s_product_sales_log"},{"db":"EcoReality","table":"s_where_heard"},{"db":"EcoReality","table":"s_animal_notes"},{"db":"EcoReality","table":"s_product_harvest"},{"db":"EcoReality","table":"s_project"},{"db":"EcoReality","table":"s_product"},{"db":"Personal","table":"Weight"},{"db":"EcoReality","table":"s_vehicle_log"},{"db":"EcoReality","table":"s_shares"}]') REPLACE INTO `phpmyadmin`.`pma__recent` (`username`, `tables`) VALUES ('root', '[{"db":"EcoReality","table":"s_vehicle"},{"db":"EcoReality","table":"s_timelog"},{"db":"EcoReality","table":"s_product_sales_log"},{"db":"EcoReality","table":"s_where_heard"},{"db":"EcoReality","table":"s_animal_notes"},{"db":"EcoReality","table":"s_product_harvest"},{"db":"EcoReality","table":"s_project"},{"db":"EcoReality","table":"s_product"},{"db":"Personal","table":"Weight"},{"db":"EcoReality","table":"s_vehicle_log"}]') ---------------- Anyone know what's going on, and what to do about it? (Besides "restore from backup," which is a bit old.) -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/error-1932-on-a-table-with-recently-added-virtual-…

1 0