- discuss - lists.mariadb.org

[Maria-discuss] Upgrade error: mariadb 10.1.16 to 10.1.17
by Erik de Waard 01 Sep '16

01 Sep '16

Hello, When upgrading from 10.1.16 to 10.1.17 on Debian Jessie i've received the following error: aptitude upgrade <snip> dpkg: error processing package mariadb-server-10.1 (--configure): subprocess installed post-installation script returned error exit status 1 Processing triggers for libc-bin (2.19-18+deb8u4) ... Errors were encountered while processing: mariadb-server-10.1 E: Sub-process /usr/bin/dpkg returned an error code (1) Failed to perform requested operation on package. Trying to recover: Setting up mariadb-server-10.1 (10.1.17+maria-1~jessie) ... dpkg: error processing package mariadb-server-10.1 (--configure): subprocess installed post-installation script returned error exit status 1 Errors were encountered while processing: mariadb-server-10.1 Current status: 0 updates [-14] <snip> /var/log/syslog mysqld_safe[44689]: ERROR: 1136 Column count doesn't match value count at row 1 Was able to fix by running. /usr/sbin/mysqld --skip-grant --general-log & And running the upgrade again. See attached full logs.

2 1

[Maria-discuss] New Question: AES_ENCRYPT() and AES_DECRYPT() with other than ECB mode?
by AskMonty KB 01 Sep '16

01 Sep '16

Hello, A new question has been asked in "MariaDB Community" by w3goodies.com_64477. Please answer it at http://mariadb.com/kb/en/aes_encrypt-and-aes_decrypt-with-other-than-ecb-mo… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Since MySQL 5.6.17, MySQL supports block_encryption_mode to change encryption mode from ECB to other modes like 256-CBC http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_… I think MariaDB currently only supports 128-ECB for AES_ENCRYPT() and AES_DECRYPT(), will there be update in MariaDB to merge this block_encryption_mode feature any soon? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/aes_encrypt-and-aes_decrypt-with-other-than-ecb-mo…

1 0

[Maria-discuss] InnoDB plugin maturity
by Ian Gilfillan 01 Sep '16

01 Sep '16

If you look at the list of plugin maturities, say with: SELECT plugin_name,plugin_version,plugin_maturity FROM information_schema.plugins ORDER BY plugin_name; I notice that in 10.1, InnoDB/XtraDB is listed as Gamma (changed from Beta in 10.1.13), while in 10.0, with the same version of XtraDB, it's listed as Stable. What's the basis of the distinction between the two, especially since 10.1 itself is a stable release? It seems strange to have InnoDB listed as the same maturity as Spider :)

2 1

Re: [Maria-discuss] Don't replicate procedures in the mysql database
by Federico Razzoli 01 Sep '16

01 Sep '16

I never used replicate_ignore_db='mysql'. But I know some people does. Did you check if it has side effects? Federico -------------------------------------------- Mer 31/8/16, Игорь Пашев <pashev.igor(a)gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] Don't replicate procedures in the mysql database A: "MariaDB discuss" <maria-discuss(a)lists.launchpad.net> Data: Mercoledì 31 agosto 2016, 23:39 Thanks to everyone Here is the solution: On the slave: Replicate_Ignore_DB: mysql Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: foo.% Replicate_Wild_Ignore_Table: On the master: USE mysql; CREATE PROCEDURE whatever() BEGIN END; _______________________________________________ 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] Don't replicate procedures in the mysql database
by Игорь Пашев 31 Aug '16

31 Aug '16

Hi all, I'm using multi-source replication with "white list" options only: foo.replicate_wild_do_table = foo.% foo.replicate_ignore_table = foo.beep foo.replicate_ignore_table = foo.tmp The masters are writing row-based binary logs as is (no filtering at masters). This works almost as expected: only the `foo` database gets updates, the mentioned tables are ignored. The `mysql` database does not get updates, even when I run GRANT / REVOKE on the masters quite often. But when I create a procedure on the master it get propagated to the slave: When I execute `CREATE PROCEDURE mysql.bar` on the master, this procedure appears on the slave. How could I avoid that? Did I miss some options? Is this a bug?

4 5

[Maria-discuss] New Question: MONyog Cluster Monitoring
by AskMonty KB 31 Aug '16

31 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/monyog-cluster-monitoring/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it possible to see all the monitoring information for galera cluster together..for eg In charts we get collected information of all the nodes of a cluster? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-cluster-monitoring/

1 0

[Maria-discuss] optimize table wait table level lock in MairaDB 10.1.16 ?
by Ljr Yang 31 Aug '16

31 Aug '16

Hi, all Today, we use optimize table in MariaDB 10.1.16. Table test01 have about 2 millions records. session 1: optimize table test01; session 2: select count(*) from test01 ; when session 1 run, In processlist session 2 state: Waiting FOR TABLE LEVEL LOCK we had set innodb_defragment=1 in my.cnf ,but run optimize table still have table lock？ reference link: https://mariadb.com/kb/en/mariadb/defragmenting-innodb-tablespaces/ -- Ljr

2 1

[Maria-discuss] MariaDB 10.1.17 and MariaDB Galera Cluster 10.0.27 now available
by Daniel Bartholomew 30 Aug '16

30 Aug '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.17 and MariaDB Galera Cluster 10.0.27. These are both Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.17 - Release Notes: https://mariadb.com/kb/en/mdb-10117-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10117-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.17 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 Galera Cluster 10.0.27 - Release Notes: https://mariadb.com/kb/en/mgc-10027-rn/ - Changelog: https://mariadb.com/kb/en/mgc-10027-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.27/ About MariaDB Galera Cluster: - https://mariadb.com/kb/en/about-mariadb-galera-cluster/ - - 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/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] geo replication?
by l vic 29 Aug '16

29 Aug '16

Is replication between different data centers supported in MariaDB and is it supported in open source version, or in enterprise only? Thank you, -V

4 4

[Maria-discuss] Reg custom port for maxscale binlog router
by Karthick Subramanian 29 Aug '16

29 Aug '16

Hi all, When I try to configure maxscale for binlogrouter, I noticed that documentation examples using port as 5308. When I try to configure similarly, it says, 111 connection refused or unable to connect master from maxscale. I have enabled the port in centOs7 using firewalld on both master server as well maxscale server: firewall-cmd --add-port=5308/tcp But still,I couldn't able to establish connection from maxscale server to mariadb server(master): mysql -u maxscaleoper -h ip:ip:ip:ip --port 5308 -p ERROR 2003 (HY000): Can't connect to MySQL server on 'ip:ip:ip:ip' (111 "Connection refused") Can anyone please help me on how to resolve this error. Because of this error, I couldn't make maxscale up and running. Regards, Karthick S

2 2