October 2016 - discuss - lists.mariadb.org

[Maria-discuss] why stdout? -> [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096
by Reindl Harald 05 Jul '20

05 Jul '20

Aug 6 12:24:24 testserver mysqld: 150806 12:24:24 [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096 ... why is this now stdout instead mysql logs? on systemd based distributions that spits now to the global syslog and finally on machines restarting 2 instances every hour for backup reasons it annoys until 10.0.19 or 10.0.20 that was not this way

5 13

[Maria-discuss] Missing MariaDB Seal logos?
by Colin Charles 20 Mar '17

20 Mar '17

Hi! Visiting: https://mariadb.com/kb/en/mariadb/branding-guidelines/ You’ll note that the Powered by MariaDB badges still exist (https://mariadb.org/about/logos/) — they should really say Powered by MariaDB Server But what is missing are all the seal logos? Currently beyond the archives at Wikimedia Commons (https://commons.wikimedia.org/wiki/File:Mariadb-seal-browntext.svg), they seem to have disappeared Is this just an oversight and something that needs fixing? Thanks -- Colin Charles, http://bytebot.net/blog/ twitter: @bytebot | skype: colincharles "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

2 1

[Maria-discuss] GRANT PROXY access denied with proxied User
by Fabian Jucker 04 Nov '16

04 Nov '16

Hi, At our enterprise we have a DBA-User proxied with "GRANT PROXY ON 'dba'@'%' TO ''@'%'" and backed by pam module (roughly according to [1]) to login from our ldap-accounts. When logging in via pam into the DBA-Role I'm unable to grant the proxy privileges to other users. Following [2] (MySQL docs, because the MariaDB docs are lacking any further information about this) I already tried to "GRANT PROXY ON 'dba'@'%' TO ''@'%' WITH GRANT OPTION" and "GRANT PROXY ON ''@'' TO 'dba'@'%' WITH GRANT OPTION" (as [2] is ambiguous about if the "proxied_user" or the "proxy_user" should have the "WITH GRANT OPTION"), but neither the first grant nor the second one showed any effect. When I grant the proxy privilege with grant option to a local user, this user is able to grant the proxy privileges to other users. So my question is, if it's not possible to grant proxy privileges while one's logged in with a proxy user? Thanks in advance, Fabian References: [1]: https://mariadb.com/blog/configuring-pam-authentication-and-user-mapping-ma… [2]: https://dev.mysql.com/doc/refman/5.5/en/proxy-users.html

1 1

[Maria-discuss] MYSQL_OPT_CONNECT_TIMEOUT default?
by Peter Laursen 03 Nov '16

03 Nov '16

MySQL docs page http://dev.mysql.com/doc/refman/5.7/en/mysql-options.html *MYSQL_OPT_CONNECT_TIMEOUT (argument type: unsigned int *)* *The connect timeout in seconds.* However I don't find it documented anywhere what the default (client-initiated) connect_timeout will become if not specified in mysql_options(). Or will the client never initiate a timeout in connection phase in such case? We are usng MariaDB C-conn 2.31 so the question here on this list is specifically for MariaDB connector. I didn't find it documented here either. But both MySql and MariaDB have probably inherited this from the old LGPL 3.x connector so this are probably the same in both. Asked a docs request here as well: http://bugs.mysql.com/bug.php?id=83600 --- Peter

2 3

[Maria-discuss] Upcoming conferences for talking about MariaDB Server
by Colin Charles 31 Oct '16

31 Oct '16

Hi All, FOSDEM is Feb 4-5 2017 in Brussels and the CfP for the MySQL & friends devroom ends December 6 2016 - please submit MariaDB Server related talks (see: http://www.mysqlandfriends.eu/post/fosdem-2017s-mysql-friends-devroom-call-…) Percona Live Santa Clara is April 24-27 2017 and the CfP for this large event is November 13 2016 - please submit your MariaDB Server related talks! (see: https://www.percona.com/live/17/) Good luck in getting a talk in! cheers, -c -- Colin Charles, http://bytebot.net/blog/ twitter: @bytebot | skype: colincharles "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

1 0

[Maria-discuss] Galera backup failing with error “mysqldump: Error 1213: Deadlock found when trying to get lock; try restarting transaction when dumping table”
by Lukas Lehner 31 Oct '16

31 Oct '16

Hi please help http://dba.stackexchange.com/questions/153263/galera-backup-failing-with-er… Lukas

1 0

[Maria-discuss] Problem with Master/Slave <=> Master/Slave <=> Master/Slave Replication
by LinuXperia 29 Oct '16

29 Oct '16

Hi All! I am having a Problem with getting mariadb works flawless using a Master/Slave[1] <=> Master/Slave[2] <=> Master/Slave[3] The First Time i was able to insert a row on the Master[1] Server and the data was reproduced/replicated to all servers. At this Time i thinked everything is fine now. But then when i tryed to deleted the new Created Row on Master[1] the Data was only deleted on the Master[1] Server while the others Servers [2] and [3] still had the data! I expected that the deleted row should be also deleted on all master/slave servers but it did not! How can i solve this Problem? And what is actually the Problem with MySQL/MariaDB? I am getting the impression that MariaDB is really bad when it comes to Replication/Sync of Data in a Distributed Architecture. As a Example let say on server has to reboot because of a Cloud maintenance. From what i see this MaraiDB server will be forever corrupted after the restart and never sync again as first it has to manually be adjusted to the master bin log position and second it has also be told to work as a slave after this. Not really what i would expect from a autonomous replicating Master Slave Data Base Server after a restart! Hope somebody can tell me how to resolve all this Sync Problems so finally MariaDB Master/Slave Database Server work flawless without to worry that sooner or later a node or a few of them will get useless and corrupted! Thanks in advance for any helpful Tip and Answer! A example of my my.cnf Master/Slave[2] Server changes! server-id = 2 replicate-same-server-id = 0 auto-increment-increment = 8 auto-increment-offset = 1 log_bin = /var/log/mysql/mariadb-bin log_bin_index = /var/log/mysql/mariadb-bin.index # not fab for performance, but safer sync_binlog = 1 expire_logs_days = 10 max_binlog_size = 100M binlog_do_db = logedin_users binlog-format = ROW # slaves relay_log = /var/log/mysql/relay-bin relay_log_index = /var/log/mysql/relay-bin.index relay_log_info_file = /var/log/mysql/relay-bin.info log_slave_updates = 1 #read_only binlog-checksum = 1 master_verify_checksum = 1 relay_log_recovery = 1 slave_compressed_protocol = 1 slave_sql_verify_checksum = 1 sync_master_info = 1 sync_relay_log = 1 sync_relay_log_info = 1

2 3

[Maria-discuss] MariaDB 10.0.28 now available
by Daniel Bartholomew 28 Oct '16

28 Oct '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.28. This is a stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.28 - Release Notes: https://mariadb.com/kb/en/mdb-10028-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10028-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.0.28 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/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadbfdn - 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] Error Restoring mysqldump in MariaDB 5.5
by Jamie Jackson 28 Oct '16

28 Oct '16

I'm getting an error restoring a mysqldump. At first, I was restoring the full dump (with data), but fortunately, I'm able to elicit the same error, on the same line. Please let me know if this is user error, or whether I should file a ticket. *Dump:* $ mysqldump -h myhost -umyuser -p --no-data --routines --single-transaction mysite_cms > /vagrant/temp/downloads/misc/prod_skeleton.sql $ mysql -uroot -p mysite_raw_redacted < /vagrant/temp/downloads/misc/prod_skeleton_redacted.sql ERROR 1064 (42000) at line 1451: 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 '*/' at line 1 That line is highlighted: DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`mysite_cms`@`%`*/ /*!50003 TRIGGER cal_tbl_event_delete AFTER DELETE ON cal_tbl_event FOR EACH ROW INSERT INTO delete_log(deleted_id, deleted_date, deleted_table) VALUES (Old.id, now(), 'cal_tbl_event'); */;; DELIMITER ; *Source DB:* +-------------------------+---------------------+ | Variable_name | Value | +-------------------------+---------------------+ | innodb_version | 5.5.49-MariaDB-38.0 | | protocol_version | 10 | | slave_type_conversions | | | version | 5.5.52-MariaDB | | version_comment | MariaDB Server | | version_compile_machine | x86_64 | | version_compile_os | Linux | +-------------------------+---------------------+ *Target DB:* +-------------------------+---------------------------------+ | Variable_name | Value | +-------------------------+---------------------------------+ | innodb_version | 5.5.52-MariaDB-38.3 | | protocol_version | 10 | | slave_type_conversions | | | version | 5.5.53-MariaDB-1~precise | | version_comment | mariadb.org binary distribution | | version_compile_machine | x86_64 | | version_compile_os | debian-linux-gnu | +-------------------------+---------------------------------+ Thanks, Jamie

1 1

[Maria-discuss] Minor version upgrades across a cluster
by Craig Bailey 27 Oct '16

27 Oct '16

Hi, We have a three node MariaDB Galera cluster on version 10.1.14 an we would like to upgrade to 10.1.18. Our approach to this was to offline a node upgrade it and then add it back to the cluster and allow it to do an IST to catch up (rinse and repeat for other two nodes). However this would mean that we will have a period of time where nodes in the cluster will be on different minor versions, is this safe, or will it possibly cause some kind of data corruption or crash? Regards Evertz UK cbailey(a)evertz.com<mailto:cbailey@evertz.com> www.evertz.com This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the sender (as shown above). Kindly do not reproduce, print or forward any material received in error, please delete it immediately. Evertz UK Limited (Company No. 3458137) is incorporated in England and Wales and has its registered office at 100 Berkshire Place, Wharfedale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5RD. Evertz Singapore Pte Limited (Company No. 200817005N) is incorporated in Singapore and has its registered office at One Marina Boulevard, #28-00. Singapore 018989.

2 1