- discuss - lists.mariadb.org

[Maria-discuss] Problem Upgrade MariaDb 5.5.52 MariaDb 10.1.22
by Wilmer Arambula 21 Mar '17

21 Mar '17

Hi, i have a system running perfectly on mariadb 5.5.52, i will change everything to a new server with mariadb 10.1.22, but running the installation script gives me problems, this is the error, is there any way to configure mariadb 10.1.22 To omit this error, since mariadb 10.1.22 works with strict-trans-table, there is some old_mode feature that allows this. QUERY: CREATE TABLE `media_gallery_music` ( `gallery_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `value_id` INT(11) UNSIGNED NOT NULL, `artwork_url` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL, `name` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL, `position` INT(11) NOT NULL, PRIMARY KEY (`gallery_id`) ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; CREATE TABLE `media_gallery_music_album` ( `album_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `gallery_id` INT(11) UNSIGNED NOT NULL, `name` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL, `artwork_url` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL, `podcast_url` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL, `artist_name` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL, `type` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`album_id`), KEY `KEY_GALLERY_ID` (`gallery_id`) ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; CREATE TABLE `media_gallery_music_elements` ( `position_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `gallery_id` INT(11) UNSIGNED DEFAULT NULL, `album_id` INT(11) UNSIGNED DEFAULT NULL, `track_id` INT(11) UNSIGNED DEFAULT NULL, `position` INT(11) NOT NULL, PRIMARY KEY (`position_id`), KEY `KEY_GALLERY_ID` (`gallery_id`), KEY `KEY_ALBUM_ID` (`album_id`), KEY `KEY_TRACK_ID` (`track_id`) ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; CREATE TABLE `media_gallery_music_track` ( `track_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `album_id` INT(11) UNSIGNED DEFAULT NULL, `gallery_id` INT(11) UNSIGNED DEFAULT NULL, `name` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL, `duration` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL, `artwork_url` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL, `artist_name` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL, `album_name` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL, `price` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL, `currency` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL, `purchase_url` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL, `stream_url` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL, `type` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL, `position` INT(11) NOT NULL, PRIMARY KEY (`track_id`), KEY `KEY_ALBUM_ID` (`album_id`), KEY `KEY_GALLERY_ID` (`gallery_id`) ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; ALTER TABLE `media_gallery_music_album` ADD FOREIGN KEY `FK_GALLERY_ID`(`gallery_id`) REFERENCES `media_gallery_music` (`gallery_id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `media_gallery_music_elements` ADD FOREIGN KEY `FK_GALLERY_ID` (`gallery_id`) REFERENCES `media_gallery_music` (`gallery_id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD FOREIGN KEY `FK_ALBUM_ID` (`album_id`) REFERENCES `media_gallery_music_album` (`album_id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD FOREIGN KEY `FK_TRACK_ID` (`track_id`) REFERENCES `media_gallery_music_track` (`track_id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `media_gallery_music_track` ADD FOREIGN KEY `FK_ALBUM_ID` (`album_id`) REFERENCES `media_gallery_music_album` (`album_id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD FOREIGN KEY `FK_GALLERY_ID` (`gallery_id`) REFERENCES `media_gallery_music` (`gallery_id`) ON DELETE CASCADE ON UPDATE CASCADE; Work perfect MariaDb 5.5.52. Error MariaDb 10.1.22: Query : ALTER TABLE `media_gallery_music_elements` ADD FOREIGN KEY `FK_GALLERY_ID` (`gallery_id`) REFERENCES `media_gallery_musi... Error Code : 1005 Can't create table `test`.`#sql-c82_1086` (errno: 121 "Duplicate key on write or update") Execution Time : 00:00:00:000 Transfer Time : 00:00:00:000 Total Time : 00:00:00:000 I can manually modify and fix the error, but it is a system with many scripts and updates, is there any way to omit this error in Mariadb 10.1.22. Thks, -- *Wilmer.*

3 2

[Maria-discuss] sst failure?
by l vic 21 Mar '17

21 Mar '17

What can case the following problem? [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (2cd97600-0e4e-11e7-997a-0a414b1bb17e): 1 (Operation not permitted) at galera/src/replicator_str.cpp:prepare_for_IST():482. IST will be unavailable. [Note] WSREP: Member 1.0 () requested state transfer from '*any*'.

1 0

Re: [Maria-discuss] Problem Upgrade MariaDb 5.5.52 MariaDb 10.1.22
by Wilmer Arambula 21 Mar '17

21 Mar '17

Thanks for your answer, I understand perfectly, but this is an old system, I understand the procedure of the update, but I thought there was some old_mode configuration only to run that database with the options of mariadb 5.5.52 in mariadb 10.1.22. Thks, Wilmer. 2017-03-21 16:19 GMT-04:00 Reindl Harald <h.reindl(a)thelounge.net>: > >> >> >> Am 21.03.2017 um 21:08 schrieb Wilmer Arambula: >> >>> Hi, ihave a system running perfectly on mariadb 5.5.52, i will change >>> everything to a new server with mariadb 10.1.22, but running the >>> installation script gives me problems, this is the error, is there any >>> way to configure mariadb 10.1.22 To omit this error, since mariadb >>> 10.1.22 works with strict-trans-table, there is some old_mode feature >>> that allows this. >>> >>> Query : ALTER TABLE `media_gallery_music_elements` ADD FOREIGN >>> KEY `FK_GALLERY_ID` (`gallery_id`) REFERENCES `media_gallery_musi... >>> >>> Error Code : 1005 >>> Can't create table `test`.`#sql-c82_1086` (errno: 121 "Duplicate key on >>> write or update") >>> >>> Execution Time : 00:00:00:000 >>> Transfer Time : 00:00:00:000 >>> Total Time : 00:00:00:000 >>> >>> I can manually modify and fix the error, but it is a system with many >>> scripts and updates, is there any way to omit this error in Mariadb >>> 10.1.22 >>> >> >> either you have unique keys or not >> >> however why not first upgrade to 10.0.x and why working with dumps >> instead just as others do for many many years an dbrought their server from >> mysql3 to mariadb 10.1 - this is not postgresql >> >> * upgrade 10.x >> * mysql_upgrade -u root -p >> * upgrade 10.1.x >> * mysql_upgrade -u root -p >> >> no, not on the live-server, on a virtual machine where you first rsync >> your datadir, play the upgrades and finally when you have a working plan >> after the last retry rsync the datadir to the new liveserver >> >> >> _______________________________________________ >> 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 >> > > >

1 0

[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] Questions to temporary myisam table files
by Hempel, Sebastian 20 Mar '17

20 Mar '17

Hallo, there is a known issue with the repair table function (MDEV-5871, MDEV-8475), which was fixed in MariaDB 10. Which is fine, but we have still MariaDB 5.5 server running. So we created our own repairtable function to work around this problem. For that function I like to know all possible file extensions for temporary myisam table files. For me temporary myisam table files are these files which are generated when calling "check table", "repair table" or other database functions. Thanks Sebastian

2 3

[Maria-discuss] Exclusive lock not working
by Jesse Schalken 20 Mar '17

20 Mar '17

I have a transaction that checks if a row exists with a particular value and if not, generates the data for that row and inserts it: -- schema CREATE TABLE test ( col INT, data TEXT, KEY (col) ); -- transaction START TRANSACTION; SELECT * FROM test WHERE col = 4 FOR UPDATE; -- If no results, generate data and insert INSERT INTO test SET col = 4, data = 'generated data goes here'; COMMIT; The problem I have is that if two copies of this transaction run concurrently (with the queries interleaved), they both pass the SELECT and deadlock on the INSERT. I would expect that the SELECT would acquire an exclusive lock on "col = 4" so only one transaction will proceed to insert, but the "FOR UPDATE" seems to behave as a shared lock instead. What is the correct way to write this transaction so only one copy proceeds to generate the "data" string and insert the row? (I originally posted this on Stack Overflow here <https://stackoverflow.com/questions/42547629/insert-row-if-not-exists-witho…> .) Thanks

2 2

[Maria-discuss] MariaDB 10.1.22 now available
by Daniel Bartholomew 19 Mar '17

19 Mar '17

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.22. This is a stable (GA) release. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.22 - Release Notes: https://mariadb.com/kb/en/mdb-10122-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10122-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.22 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/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

3 11

[Maria-discuss] Fix different gtid-positions on domain 0 in multi-master
by Reinder Cuperus 17 Mar '17

17 Mar '17

Hello, After moving half of the databases on our primary master-master-cluster to a different cluster, we have a problem on our backup-server which is now a slave of both servers. Topology before: master1 <-> master2 -> backup-slave Topology during migrations: master1 <-> master2 -> backup-slave <-> master3 <-> master4 Final topology: master1 <-> master2 -> backup-slave <- master3 <-> master master4 The gtid_domain_ids before/during the migration were: master1/master2 : 0 master3/master4 : 20 Replication-settings: master2 -> backup: Replicate_Do_Domain_Ids: 0 master3 -> backup: Replicate_Do_Domain_Ids: 20 backup->master3: Replicate_Do_DB: DbToMigrate1,DbToMigrate2,etc Server version: 10.1.9 So after the migration, a typical gtid_position would be on: master1/2: 0-1-12345 master3/4: 0-1-12345,20-21-5678 As long as I keep the connection backup->master running (safe, because no new transactions on the migrated databases are occurring anymore on master1/2), the position on domain 0 gets recorded on master3. The problem is, as soon as I stop that connection, that master2 and master3 have different gtid-positions for domain0, and stop/start on replication master3->backup results in the error: "Got fatal error 1236 from master when reading data from binary log: 'Error: connecting slave requested to start from GTID 0-1-3898746614, which is not in the master's binlog' I have tried moving master1/2 to domain_id:1, and removing the domain_id:0 from the gtid_slave_pos on backup, but starting the replication master2->backup results in the error: Got fatal error 1236 from master when reading data from binary log: 'Could not find GTID state requested by slave in any binlog files. Probably the slave state is too old and required binlog files have been purged.' I have tried to find a way to insert an empty transaction, with the last gtid on domain_id:0 on the master3, to bring master2/master3 in sync again on that domain, but I could not find a way to do that on MariaDB. I tried finding a way to purge domain:0 from master3/master4, but the only way sofar I have found is doing a "RESET MASTER" on master3, which would break replication between master3 and master4. Are there other ways to fix this issue, so I can have reliable replication master3->backup without having to keep the dummy replication backup->master3 indefinitely? Regards, Reinder Cuperus

2 2

[Maria-discuss] Partition a Huge table
by Suresh Rajagopal 15 Mar '17

15 Mar '17

Hi, What is the fastest approach to partition a huge table with 2 additional columns? How safe its to alter table on slave and promote slave as master? It takes 25 hours to alter the table for now on slave. MariaDB Version : 10.1.18OS : Centos 6 ThanksSuresh

4 6

[Maria-discuss] [Warning] WSREP: Send action {(nil), 785, TORDERED} returned -103 (Software caused connection abort)
by Robbi Nespu 10 Mar '17

10 Mar '17

Hi there, I need to ask a guide from here. I have 5 galera cluster using mariadb 10.1 on centos 7 hosted on VPS for a few month. It running well until a weeks ago, during my leave, our VPS hosting rebooted our server. I create a backups and reboot the clusters1 till cluster2 (I don't enable auto start services on my box). Then on galera cluster 1, I ran command "galera_new_cluster" and start services on others clusters. cluster 2 - cluster 5 are working great. But it seems, cluster1 has problem. I checked services status and I got lot of this message : Mar 10 15:04:05 galera1 mysqld[6628]: 2017-03-10 15:04:05 139929087744768 [Warning] WSREP: Send action {(nil), 520, TORDERED} returned -103 (Software caused connection abort) Mar 10 15:04:05 galera1 mysqld[6628]: 2017-03-10 15:04:05 139929087744768 [Warning] WSREP: Send action {(nil), 520, TORDERED} returned -103 (Software caused connection abort) I tried to connect mariadb galera on cluster 1, seem the data are not synced unlike the others 4 cluster. Anyone face the same problem? Any guideline for me to troubleshoot this problem is most appreciated.

1 0

[Maria-discuss] Multiple Mariadb 10.1 instances on Centos 7
by Sales 09 Mar '17

09 Mar '17

I don’t see a mariadb@.service file on centos 7. I need to install multiple instances of mariadb 10.1 though and have them run from systemd (on the same server). The doc page https://mariadb.com/kb/en/mariadb/systemd/ <https://mariadb.com/kb/en/mariadb/systemd/> says that it’s installed on “some” systems. Apparently, some does not include Centos 7. So, is there a way to obtain a copy of the relevant file(s) needed to run multiple instances? Perhaps from another distribution? Seems like it’s a much better starting point than trying to create all that myself. Or, will it simply not work? What is the best way then to run multiple instances on Centos 7? Steve

2 3

[Maria-discuss] Maria db read/write configuration issues
by Chaitanya Cheekate 09 Mar '17

09 Mar '17

Hi We have configured maxscale in our environment using the links http://karlssonondatabases.blogspot.in/2014/02/maxscale-for-rest-of-us-part…, 2, 3 . We have two slaves and one master and the replication between them is working well. But after configuring read/write split the select queries are being executed in master itself, not routing to the slaves. Please find the attached documents of maxscale configuration, maxscale commands maxscale log and. Please help with maxscale read/write split. Attached documentsdetails 1. maxsconf.txt from the location /etc/maxscale.cnf 2. maxscale-commands.txt, coomands like maxadmin -pmariadb list servers, maxadmin -pmariadb list services, maxadmin -pmariadb show service "Splitter Service", 3. maxscale-log.txt from /var/log/maxscale Thanks Chaitu -- Thanks.

4 4

[Maria-discuss] slave_compressed_protocol = 1 has no effect
by Phil Sweeney 09 Mar '17

09 Mar '17

Hi there, I've been trying to make use of the compressed replication protocol between two existing MariaDB 10.1.21 boxes. Replication itself has been working fine for a while. I do: SET GLOBAL slave_compressed_protocol = 1; On both master and slave. Then stop/start slave. However, when I monitor the network usage, I see no reduction in network traffic. However, I tried compression via an ssh tunnel and saw a big reduction (ssh doing the compression, not MariaDB). So the traffic is definitely compressible. I tried setting the param via my.cnf and also restarting both master and slave to see if that would make a difference - no luck. Have confirmed the global variable shows 'ON' after the change, and was 'OFF' before. Is there potentially an issue with this working with the MariaDB supplied binary tarball (e.g. some compression lib dependency?) I see nothing in error.log to show an issue. Any other useful ways to debug this? Thanks! Phil

2 1

[Maria-discuss] MariaDB 10.0.30 now available
by Daniel Bartholomew 08 Mar '17

08 Mar '17

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.30. This is a stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.30 - Release Notes: https://mariadb.com/kb/en/mdb-10030-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10030-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.0.30 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

4 5

[Maria-discuss] Change to innodb_large_prefix with respect to creating long indexes
by Marco Nicosia 07 Mar '17

07 Mar '17

Hi there, We noticed a change between MariaDB 10.1.18 and 10.1.20, but I haven't been able to find anything in the changelogs or JIRA that would help me understand what changed, and why. On 10.1.18, if I set `innodb_large_prefix=OFF` I can create indexes with lengths greater than 767 bytes and MariaDB only issues a warning. If I configure `innodb_large_prefix=ON` I get an error and the index fails to create. This seems like a bug? On 10.1.20, mysql fails to create the index regardless of how innodb_large_prefix is configured. We think that the result is that in 10.1.20, tables must be created or altered to use `ROW_FORMAT DYNAMIC` or `ROW_FORMAT COMPRESSED` if they are to contain an index with greater than 767 bytes in it. Is this the desired behavior? Was there a bug in 10.1.18 (and maybe previous)? I'm trying to understand the context better so that when devs ask us why index creation is failing, we give them the correct answer for why it used to work, and what they should be doing differently now that we're on 10.1.20. Thanks! -- Marco Nicosia Pivotal Software, Inc.

4 3

[Maria-discuss] Replication-manager + Maxscale
by Karthick Subramanian 02 Mar '17

02 Mar '17

Hi Experts, I have a 2 db server with one as master and another one as slave. Maxscale implemented with below monitor config: *[MySQL Monitor]* *type=monitor* *module=mysqlmon* *servers=master1,slave1* *monitor_interval=500* *script=/usr/bin/replication-manager --user root:password --rpluser replusr:password * *--hosts $INITIATOR,$NODELIST --failover=force --interactive=false* *events=master_down* When I shutdown master, failover is not automated. MRM (Replication Manager) is not promoting the slave to master automatically. In maxscale log, I noticed below: *2017-03-02 03:33:36 notice : Executed monitor script '/usr/bin/replication-manager --user root:password --rpluser replusr:password --hosts $INITIATOR,$NODELIST --failover=force --interactive=false' on event 'master_down'.* *2017-03-02 03:33:36 error : No Master can be determined.* Is this because I didn't have the quorum (no slave) since its one master and one slave set-up. Is there any workaround. Regards, Kart

3 4

[Maria-discuss] latin1 to utf8 conversion
by Suresh Rajagopal 25 Feb '17

25 Feb '17

Hi, I have a database(MariaDB 10.1.18) with latin1 characterset and a table with utf8 characterset.I can query the data only if i set names to latin1. How to convert the data to utf8 ? I have tried export/import,iconv. But still data doesn't show up. show create database test;+----------+----------------------------------------------------------------+| Database | Create Database |+----------+----------------------------------------------------------------+| test | CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET latin1 */ |+----------+----------------------------------------------------------------+1 row in set (0.00 sec) CREATE TABLE `Test` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL) ENGINE=InnoDB AUTO_INCREMENT=4312 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci | set names utf8;Query OK, 0 rows affected (0.00 sec) SELECT * FROM Test WHERE name = '2%Ss 60°C';Empty set (0.00 sec) set names latin1;Query OK, 0 rows affected (0.00 sec) SELECT name FROM Test WHERE name = '2%Ss 60°C';+------------+| name |+------------+| 2%Ss 60°C|| 2%Ss 60°C|+------------+2 rows in set (0.01 sec) ThanksSuresh

1 0

[Maria-discuss] Upgrading From MySQL 5.6 to MariaDB 10.1
by Michael Caplan 24 Feb '17

24 Feb '17

Hi there, I'm not seeing any concise information in the MariaDB docs about the recommended upgrade plan from MySQL 5.6 to MariaDB 10.1. Should I install MariaDB 10.0 and then 10.1? Or can I run right to 10.1? I'm running an older version of Ubuntu (12.04 Precise). Looking at the repo, it looks like I can stick with Precise, and hand that upgrade later. Or are there recommended min version of Ubuntu I should hit first? Thanks! Mike

5 9

[Maria-discuss] timestamp with time zone support mariaDB 10.1.14
by Karthick Subramanian 23 Feb '17

23 Feb '17

Hi Experts, I got this error, not sure whether maria db supports time zone: MariaDB [devdb]> create table ts (dt datetime, tz timestamp with time zone); ERROR 1064 (42000): 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 'time zone)' at line 1 My application team is looking for time zone support. Any thought please. reference: https://mariadb.com/kb/en/sql-99/temporal-data-types/#time-with-time-zone

3 3

[Maria-discuss] MariaDB 10.2.4 RC now available
by Daniel Bartholomew 17 Feb '17

17 Feb '17

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.4 Release Candidate (RC). See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.2.4 - Release Notes: https://mariadb.com/kb/en/mdb-1024-rn/ - Changelog: https://mariadb.com/kb/en/mdb-1024-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.2.4 About MariaDB 10.2: - https://mariadb.com/kb/en/what-is-mariadb-102/ 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

Re: [Maria-discuss] 10.1.x: Got packet bigger than 'max_allowed_packet' bytes
by Reindl Harald 17 Feb '17

17 Feb '17

Am 17.02.2017 um 18:26 schrieb Chris Calender: > Hello, > > On 2/17/2017 9:51 AM, Reindl Harald wrote: >> Am 16.02.2017 um 10:04 schrieb Peter Laursen: >>> The particular error message "Got packet bigger than >>> 'max_allowed_packet' bytes" is returned from the client and not the >>> server. >>> >>> Both the server and the client has a "max_allowed_packet" setting. The >>> client-one is listed >>> here https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html >> >> well, tell that "mysql_upgrade" (part of mariadb) and "myqltuner" >> (mysqtuner pretends "[!!] Attempted to use login credentials, but they >> were invalid" when this is ste in the [client] section >> >> mysql_upgrade >> /usr/bin/mysql_upgrade: unknown variable 'max_allowed_packet=200M' > > I'm sure you're already aware of this, but for anyone else out there > following along that does not know, cases like this are exactly what the > --loose- prefix is for. That way one should be able to prefix such > variables with --loose-, under say the [client] section, and then client > programs that understand the variable should work, and those that do not > *should* not fail (though I cannot comment specifically on mysqltuner, > as I've not used it before). But that is the general premise of the > --loose-* prefix. no, i am not aware of this and to be honest have zero understanding when client software from the same build don't understand and or at least just ignores options it don't understand we can dicsuss about server better safe than sorry, but frankly i am not a big fan of things not doing anything because they don't understand a future or removed config param > For instance, if you set: > > [client] > loose-max_allowed_packet=200M > > Then mysql_upgrade will only throw a warning and continue on: > > shell> mysql_upgrade -uroot -ppass -P3366 > Warning: mysql_upgrade: unknown variable 'loose-max_allowed_packet=200M' > Phase 1/6: Checking and upgrading mysql database > Processing databases > ... > >> so currently "mysql" is the only client which a) understands it and b) >> proceeeds it correctly - what a mess > > Also, mysqldump does read and process max_allowed_packet correctly. So > for anyone out there reading this strictly in regards to > max_allowed_packet, don't forget mysqldump needs it too (which it would > read it from [client], [mysqldump], or the command line invocation itself)

1 0

[Maria-discuss] 10.1.x: Got packet bigger than 'max_allowed_packet' bytes
by Reindl Harald 17 Feb '17

17 Feb '17

/etc/my.cnf (for many years now) max_allowed_packet = 200M how can it be that when the whole table file is 54MB large with a setting of 200MB that something is larger then 200MB while obviously it was not too large at insert time at 2016-10-06 but with MariaDB 10.0.x instead 10.1.x? PHP says mysqli_fetch_assoc() [<a href='http://at.php.net/manual/de/function.mysqli-fetch-assoc.php'>function.mysqli-fetch-assoc.php</a>]: Malformed server packet. Field length pointing 22 bytes after end of packet MariaDB [afi]> select * from cms1_docmgmt_entrys where doc_id=19; ERROR 2020 (HY000): Got packet bigger than 'max_allowed_packet' bytes MariaDB [afi]> show variables like 'max_allowed_packet'; +--------------------+-----------+ | Variable_name | Value | +--------------------+-----------+ | max_allowed_packet | 209715200 | +--------------------+-----------+ 1 row in set (0,00 sec) MariaDB [afi]> select doc_file_download_size from cms1_docmgmt_entrys where doc_id=19; +------------------------+ | doc_file_download_size | +------------------------+ | 15838399 | +------------------------+ 1 row in set (0,00 sec) -rw-rw---- 1 mysql mysql 9,3K 2017-02-04 15:39 cms1_docmgmt_entrys.frm -rw-rw---- 1 mysql mysql 54M 2017-02-10 04:05 cms1_docmgmt_entrys.MYD -rw-rw---- 1 mysql mysql 234K 2017-02-10 04:05 cms1_docmgmt_entrys.MYI

3 5

[Maria-discuss] mysqldump 10.1.16
by Karthick Subramanian 16 Feb '17

16 Feb '17

All, I got a replciation problem and planned to take master server dump using below command and tried to restore in slave server: mysqldump --skip-lock-tables --single-transaction --flush-logs --hex-blob --master-data=1 -A --routines > ~/dump.sql I got into this error: https://jira.mariadb.org/browse/MDEV-10119 Then I tried this method: http://lists.askmonty.org/pipermail/commits/2016-June/009504.html My question: Is it ok if the GIS procedure currently with definer as definer=`root@localhost` instead of blank as definer=`` for the following two procs in mysql: Slave_MariaDB [(none)]> select db, name, definer from mysql.proc; +---------+------------------------+-----------------+ | db | name | definer | +---------+------------------------+-----------------+ | mysql | AddGeometryColumn | root@localhost | | mysql | DropGeometryColumn | root@localhost | Master_MariaDB [(none)]> select db, name, definer from mysql.proc; +---------+------------------------+-----------------+ | db | name | definer | +---------+------------------------+-----------------+ | mysql | AddGeometryColumn | @ | | mysql | DropGeometryColumn | @ |

2 2

[Maria-discuss] LOAD DATA LOCAL INFILE
by Karthick Subramanian 15 Feb '17

15 Feb '17

HI All, Even after enabling --local-infile=1 at mysql user login, I couldn't load the file locally. mysql -u root --local-infile=1 LOAD DATA LOCAL INFILE ERROR 1148 (42000): The used command is not allowed with this MariaDB version show variables like '%local%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | local_infile | OFF | +---------------+-------+ Even though i enable --local-infile=1, the local-infile still shows OFF. Pleaselet know how can I fix this.

3 4

[Maria-discuss] ROLE and DEFAULT DATABASE
by Karthick Subramanian 09 Feb '17

09 Feb '17

Hi, Can anyone assist me on this below: I have a database called appdb. I need to grant access to this db to different users say: api_user, app_user, portal_user. So I created a ROLE as APP_ROLE and GRANT as below: GRANT SELECT, INSERT, UPDATE, DELETE ON APPDB.* TO APP_ROLE; Later I assign the Role to user: GRANT APP_ROLE TO API_USER@'%' IDENTIFIED BY 'YOU'; SET DEFAULT ROLE APP_ROLE TO API_USER@'%'; But the problem now is: Application team want to choose the database when they establish connection. But they couldn't use APPDB. So they couldn't see any db objects listed in APPDB. Is there a way we can assign a default database also for user.

3 2

[Maria-discuss] default_tmp_storage_engine=NULL
by Ian Gilfillan 09 Feb '17

09 Feb '17

What is the purpose/effect of having MariaDB's default_tmp_storage_engine setting default to NULL instead of the default used in MySQL, Innodb? I can't see any obvious differences in behaviour.

3 3

Re: [Maria-discuss] R: default_tmp_storage_engine=NULL
by Federico Razzoli 09 Feb '17

09 Feb '17

Well, I can't think many cases where InnoDB is not the default engine. But, if it is not, why should you use it for temporary tables? If you mainly use TokuDB, maybe don't want to mix the engines. If you use MyISAM, maybe you don't want transactional temporary tables. I still think that MEMORY makes sense in all cases :) Federico -------------------------------------------- Gio 9/2/17, Ian Gilfillan <ian(a)mariadb.org> ha scritto: Oggetto: Re: [Maria-discuss] R: default_tmp_storage_engine=NULL A: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Giovedì 9 febbraio 2017, 10:32 > I beleive that there is a difference if default_storage_engine != innodb, because in that case, default_tmp_storage_engine will not be InnoDB. Yes, that's the case. So why is this desirable in MariaDB as opposed to MySQL's implementation? _______________________________________________ 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

1 0

[Maria-discuss] R: default_tmp_storage_engine=NULL
by Federico Razzoli 09 Feb '17

09 Feb '17

Hi Ian I beleive that there is a difference if default_storage_engine != innodb, because in that case, default_tmp_storage_engine will not be InnoDB. It is much less clear to me why default_tmp_storage_engine doesn't default to MEMORY in both MariaDB and MySQL :) Federico -------------------------------------------- Gio 9/2/17, Ian Gilfillan <ian(a)mariadb.org> ha scritto: Oggetto: [Maria-discuss] default_tmp_storage_engine=NULL A: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Giovedì 9 febbraio 2017, 09:23 What is the purpose/effect of having MariaDB's default_tmp_storage_engine setting default to NULL instead of the default used in MySQL, Innodb? I can't see any obvious differences in behaviour. _______________________________________________ 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] 2017 MariaDB Developers Conference
by Ian Gilfillan 07 Feb '17

07 Feb '17

The 2017 MariaDB Developers Conference is taking place in New York City from 9-10 April. It's free to attend for everyone interested and you are welcome to sign up on the Meetup Group, as well to propose a topic, or vote for an existing topic. Details at https://mariadb.org/2017-developers-meetup-new-york/ M|17, the MariaDB User's Conference, is taking place directly afterwards, so if you're in the area, why not attend both :) https://m17.mariadb.com/

1 1

[Maria-discuss] CentOS7 Cassandra
by Ian Gilfillan 01 Feb '17

01 Feb '17

Can someone clarify the status of Cassandra in CentOS7? It appears to have been available in 6, but not in 7.

5 5

[Maria-discuss] MariaDB Fedora update - testing
by Michal Schorm 31 Jan '17

31 Jan '17

Hello everybody, I made a (form my POV) bigger change to how MariaDB is packed, and I would be grateful for any feedback. I separated all the non-essential utilities to a standalone sub-package "server-utils". It should be installed automaticly with the "server" package as a weak dendency, so regular user should not spot any change. For example, if you don't need Perl with your server, you can save about 20MB of the space with this update. Rawhide: https://koji.fedoraproject.org/koji/taskinfo?taskID=17426872 F25: https://bodhi.fedoraproject.org/updates/FEDORA-2017-0f44f2b8c8 F24: https://bodhi.fedoraproject.org/updates/FEDORA-2017-801e01d1ed Thanks for any feedback in an advance! -- Michal Schorm Core Services - Databases Team mail: mschorm(a)redhat.com Brno-IRC: mschorm

2 3

[Maria-discuss] 10.1.21 - tests: main.analyze_format_json w4 [ fail ]
by Reindl Harald 26 Jan '17

26 Jan '17

main.analyze_format_json w4 [ fail ] Test ended at 2017-01-21 16:23:31 CURRENT_TEST: main.analyze_format_json --- /usr/share/mysql-test/r/analyze_format_json.result 2017-01-17 20:38:20.000000000 +0100 +++ /usr/share/mysql-test/r/analyze_format_json.reject 2017-01-21 16:23:31.740853974 +0100 @@ -455,7 +455,7 @@ "r_loops": 1, "rows": 10, "r_rows": 10, - "r_total_time_ms": "REPLACED", + "r_total_time_ms": "REPLACED"e-4, "filtered": 100, "r_filtered": 20, "attached_condition": "(tbl2.a in (2,3))" mysqltest: Result length mismatch

2 1

[Maria-discuss] question about generating logs on MariaDB 10.1.21
by Chris Adams 25 Jan '17

25 Jan '17

Hello, I have just moved from a MySQL 5.6 server on CentOS 6.8 to a MariaDB 10.1.21 server on CentOS 7. It is installed and working. I would like to set up some logging, but it has not gone as expected. I have binary logging working. However, I can't generate general logs or error logs. Here is part of the /etc/my.cnf file: user=mysql port = 3306 socket = /var/lib/mysql/mysql.sock datadir = /mnt/mysqldbs log_error = /var/log/mysql/error.log general_log_file = /var/log/mysql/mysql.log general_log = 1 log_bin = /mnt/mysqldbs/logs/mysql-bin I assume that after a restart, the logs will be generated, then logged to as events happen. As it is, no log files are generated. Many thanks.

4 7

[Maria-discuss] MariaDB 10.1.x: tablespace does not exist or is just being dropped
by Reindl Harald 23 Jan '17

23 Jan '17

Hi that crap temp files never deleted are from years ago and a crash until now it was enough to keep that tempfiles, with 10.1.x mariadb don't start at all - *how to get rid of that crap* the idiotic warnings are one thing but the segfauls now... it's about a decade that it's not possible to cleanup such stuff http://grokbase.com/t/mysql/mysql/136kx5qp1w/how-can-i-drop-a-table-that-is… 2017-01-23 22:01:27 139913013700928 [ERROR] InnoDB: Trying to do i/o to a tablespace which exists without .ibd data file. i/o type 10, space id 545, page no 0, i/o length 8192 bytes 2017-01-23 22:01:27 7f40097b2940 InnoDB: Error: trying to access tablespace 545 page no. 0, InnoDB: but the tablespace does not exist or is just being dropped. 2017-01-23 22:01:27 139913013700928 [ERROR] InnoDB: tablespace id is 545 in the data dictionary but in file ./dbmail/#sql2-704-271.ibd it is 690! 2017-01-23 22:01:31 140380157278528 [ERROR] InnoDB: Trying to do i/o to a tablespace which exists without .ibd data file. i/o type 10, space id 545, page no 0, i/o length 8192 bytes 2017-01-23 22:01:31 7faccd687940 InnoDB: Error: trying to access tablespace 545 page no. 0, InnoDB: but the tablespace does not exist or is just being dropped. InnoDB: Error: Unable to read tablespace 545 page no 0 into the buffer pool after 100 attempts InnoDB: The most probable cause of this error may be that the table has been corrupted. InnoDB: You can try to fix this problem by using innodb_force_recovery. InnoDB: Please see reference manual for more details. InnoDB: Aborting... 2017-01-23 22:01:31 7faccd687940 InnoDB: Assertion failure in thread 140380157278528 in file buf0buf.cc line 3080 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 170123 22:01:31 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.1.21-MariaDB key_buffer_size=33554432 read_buffer_size=131072 max_used_connections=0 max_threads=52 thread_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 53739 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x0 thread_stack 0x48400 /usr/libexec/mysqld(my_print_stacktrace+0x29)[0x560568d7a139] /usr/libexec/mysqld(handle_fatal_signal+0x3ad)[0x5605689d780d] /lib64/libpthread.so.0(+0x10c30)[0x7faccb39cc30] /lib64/libc.so.6(gsignal+0x35)[0x7faccaffe765] /lib64/libc.so.6(abort+0x16a)[0x7faccb00036a] /usr/libexec/mysqld(+0x80a9b9)[0x560568cce9b9] /usr/libexec/mysqld(+0x85426d)[0x560568d1826d] /usr/libexec/mysqld(+0x8593ca)[0x560568d1d3ca] /usr/libexec/mysqld(+0x8440b8)[0x560568d080b8] /usr/libexec/mysqld(+0x7b8978)[0x560568c7c978] /usr/libexec/mysqld(+0x702902)[0x560568bc6902] /usr/libexec/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x5d)[0x5605689d999d] /usr/libexec/mysqld(+0x3dddfb)[0x5605688a1dfb] /usr/libexec/mysqld(_Z11plugin_initPiPPci+0x782)[0x5605688a2c32] /usr/libexec/mysqld(+0x353e75)[0x560568817e75] /usr/libexec/mysqld(_Z11mysqld_mainiPPc+0x35f)[0x56056881c1ef] /lib64/libc.so.6(__libc_start_main+0xf1)[0x7faccafea731] /usr/libexec/mysqld(_start+0x29)[0x560568812eb9] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash.

1 3

[Maria-discuss] 10.1.21 - tests: main.analyze_stmt_orderby 'xtradb' w4 [ fail ]
by Reindl Harald 23 Jan '17

23 Jan '17

main.analyze_stmt_orderby 'xtradb' w4 [ fail ] Test ended at 2017-01-21 18:43:58 CURRENT_TEST: main.analyze_stmt_orderby --- /usr/share/mysql-test/r/analyze_stmt_orderby.result 2017-01-17 20:38:20.000000000 +0100 +++ /usr/share/mysql-test/r/analyze_stmt_orderby.reject 2017-01-21 18:43:58.130938437 +0100 @@ -417,7 +417,7 @@ "r_loops": 1, "rows": 10, "r_rows": 10, - "r_total_time_ms": "REPLACED", + "r_total_time_ms": "REPLACED"e-3, "filtered": 100, "r_filtered": 100 }, @@ -486,7 +486,7 @@ "r_loops": 1, "rows": 7, "r_rows": 7, - "r_total_time_ms": "REPLACED", + "r_total_time_ms": "REPLACED"e-4, "filtered": 100, "r_filtered": 100 }, mysqltest: Result length mismatch

2 2

[Maria-discuss] LTO build fails likely because -static-libgcc
by Reindl Harald 22 Jan '17

22 Jan '17

why does MariaDB use "-g -static-libgcc" in "mysql_release.cmake" and so besides override -g0 break -flto builds?

2 4

[Maria-discuss] 10.1.21 - tests: main.multi_update 'xtradb' w8 [ fail ]
by Reindl Harald 21 Jan '17

21 Jan '17

i guess that below makes not much sense when running with "--binlog-format=row" /mysql-test-run.pl --parallel=8 --max-test-fail=0 --mysqld=--binlog-format=row main.multi_update 'xtradb' w8 [ fail ] Test ended at 2017-01-21 18:43:50 CURRENT_TEST: main.multi_update --- /usr/share/mysql-test/r/multi_update.result 2017-01-17 20:38:20.000000000 +0100 +++ /usr/share/mysql-test/r/multi_update.reject 2017-01-21 18:43:49.979037948 +0100 @@ -1055,7 +1055,6 @@ Warnings: Warning 1264 Out of range value for column 'field1' at row 1 Warning 1264 Out of range value for column 'field1' at row 2 -Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. UPDATE IGNORE is unsafe because the order in which rows are updated determines which (if any) rows are ignored. This order cannot be predicted and may differ on master and the slave. UPDATE (SELECT 128 as col1) x, table_11757486 SET field1=x.col1; ERROR 22003: Out of range value for column 'field1' at row 1 UPDATE table_11757486 SET field1=128; @@ -1069,7 +1068,6 @@ Warnings: Warning 1264 Out of range value for column 'field1' at row 1 Warning 1264 Out of range value for column 'field1' at row 2 -Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. UPDATE IGNORE is unsafe because the order in which rows are updated determines which (if any) rows are ignored. This order cannot be predicted and may differ on master and the slave. DROP TABLE table_11757486; SET SESSION SQL_MODE=default; end of 10.0 tests mysqltest: Result length mismatch

1 0

[Maria-discuss] for years failing tests
by Reindl Harald 21 Jan '17

21 Jan '17

shouldn't the testsuite at some point in time run without errors? "run STOP SLAVE '' first" - uhm did i start it? it's scripted by shipped scripts [root@testserver:~]$ cat /usr/local/bin/mysql-test.sh #!/usr/bin/dash /usr/bin/su -c 'cd /usr/share/mysql-test; ./mysql-test-run.pl --parallel=1 --max-test-fail=0 --mysqld=--binlog-format=mixed --force' mysql rm -rf /usr/share/mysql-test/var/* rpl.rpl_binlog_index 'row' [ fail ] Test ended at 2017-01-20 16:56:16 CURRENT_TEST: rpl.rpl_binlog_index mysqltest: In included file "./include/rpl_init.inc": included from ./include/master-slave.inc at line 38: included from /usr/share/mysql-test/suite/rpl/t/rpl_binlog_index.test at line 20: At line 165: query 'SET GLOBAL gtid_slave_pos= ""' failed: 1198: This operation cannot be performed as you have a running slave ''; run STOP SLAVE '' first The result from queries just before the failure was: include/master-slave.inc - saving '/usr/share/mysql-test/var/log/rpl.rpl_binlog_index-row/' to '/usr/share/mysql-test/var/log/rpl.rpl_binlog_index-row/' rpl.sec_behind_master-5114 'stmt' [ fail ] Test ended at 2017-01-20 16:58:33 CURRENT_TEST: rpl.sec_behind_master-5114 mysqltest: In included file "./include/rpl_init.inc": included from ./include/master-slave.inc at line 38: included from /usr/share/mysql-test/suite/rpl/t/sec_behind_master-5114.test at line 1: At line 165: query 'SET GLOBAL gtid_slave_pos= ""' failed: 1198: This operation cannot be performed as you have a running slave ''; run STOP SLAVE '' first The result from queries just before the failure was: include/master-slave.inc rpl.rpl_semi_sync_event_after_sync 'mix,xtradb' [ fail ] Test ended at 2017-01-20 16:59:24 CURRENT_TEST: rpl.rpl_semi_sync_event_after_sync mysqltest: At line 1: query 'set global rpl_semi_sync_master_wait_point=AFTER_SYNC' failed: 1193: Unknown system variable 'rpl_semi_sync_master_wait_point' The result from queries just before the failure was: set global rpl_semi_sync_master_wait_point=AFTER_SYNC; - saving '/usr/share/mysql-test/var/log/rpl.rpl_semi_sync_event_after_sync-mix,xtradb/' to '/usr/share/mysql-test/var/log/rpl.rpl_semi_sync_event_after_sync-mix,xtradb/'

3 11

[Maria-discuss] 10.1.21 - tests: main.compound w5 [ fail ]
by Reindl Harald 21 Jan '17

21 Jan '17

main.compound w5 [ fail ] Test ended at 2017-01-21 16:21:47 CURRENT_TEST: main.compound --- /usr/share/mysql-test/r/compound.result 2017-01-17 20:38:20.000000000 +0100 +++ /usr/share/mysql-test/r/compound.reject 2017-01-21 16:21:47.413144793 +0100 @@ -28,13 +28,16 @@ include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Gtid # # BEGIN GTID #-#-# -master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (4) +master-bin.000001 # Table_map # # table_id: # (test.t1) +master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT master-bin.000001 # Gtid # # BEGIN GTID #-#-# -master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (5) +master-bin.000001 # Table_map # # table_id: # (test.t1) +master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT master-bin.000001 # Gtid # # BEGIN GTID #-#-# -master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (6) +master-bin.000001 # Table_map # # table_id: # (test.t1) +master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT DROP TABLE t1| CREATE DATABASE mysqltest1| @@ -144,12 +147,17 @@ execute stmt using @a, @b, @c| include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # GTID #-#-# -master-bin.000001 # Query # # use `test`; SELECT `test`.`fn`(9) -master-bin.000001 # Gtid # # GTID #-#-# -master-bin.000001 # Query # # use `test`; SELECT `test`.`fn`(1) master-bin.000001 # Gtid # # BEGIN GTID #-#-# -master-bin.000001 # Query # # use `test`; insert t1 values( NAME_CONST('a',4)+3) +master-bin.000001 # Table_map # # table_id: # (test.t1) +master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F +master-bin.000001 # Query # # COMMIT +master-bin.000001 # Gtid # # BEGIN GTID #-#-# +master-bin.000001 # Table_map # # table_id: # (test.t1) +master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F +master-bin.000001 # Query # # COMMIT +master-bin.000001 # Gtid # # BEGIN GTID #-#-# +master-bin.000001 # Table_map # # table_id: # (test.t1) +master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT drop function fn| drop table t1| mysqltest: Result length mismatch

1 0

[Maria-discuss] 10.1.21 - tests: main.commit_1innodb 'xtradb' w6 [ fail ]
by Reindl Harald 21 Jan '17

21 Jan '17

main.commit_1innodb 'xtradb' w6 [ fail ] Test ended at 2017-01-21 16:21:39 CURRENT_TEST: main.commit_1innodb --- /usr/share/mysql-test/r/commit_1innodb.result 2017-01-17 20:38:20.000000000 +0100 +++ /usr/share/mysql-test/r/commit_1innodb.reject 2017-01-21 16:21:39.268245094 +0100 @@ -710,12 +710,12 @@ # drop temporary table t2; call p_verify_status_increment(1, 0, 1, 0); -SUCCESS - +ERROR +Expected commit increment: 1 actual: 0 commit; call p_verify_status_increment(1, 0, 1, 0); -SUCCESS - +ERROR +Expected commit increment: 1 actual: 0 # 26. Verify that SET AUTOCOMMIT issues an implicit commit # insert t1 set a=3; @@ -831,8 +831,8 @@ Note 1050 Table 't2' already exists # Sic: first commits the statement, and then the transaction. call p_verify_status_increment(0, 0, 0, 0); -SUCCESS - +ERROR +Expected commit increment: 0 actual: 2 create table t3 select a from t2; call p_verify_status_increment(2, 0, 4, 4); SUCCESS mysqltest: Result length mismatch

1 0

[Maria-discuss] what about cleanly deprecation of config options
by Reindl Harald 20 Jan '17

20 Jan '17

what about spit some warnings in 10.0.x releases instead after update to 10.1.x service not starting and you can look what confdig options needs to be removed 2017-01-20 16:34:36 140555676232000 [ERROR] /usr/libexec/mysqld: unknown option '--skip-federated' 2017-01-20 16:34:36 140555676232000 [ERROR] Aborting

3 9

[Maria-discuss] -DWITH_INNODB_DISALLOW_WRITES=OFF and still generated files
by Reindl Harald 20 Jan '17

20 Jan '17

10.1.21 - first try build 10.1.x -DWITH_INNODB_DISALLOW_WRITES=OFF and the stuff below is still built - why? Fehler beim Bauen des RPM: Installierte (aber nicht gepackte) Datei(en) gefunden: /usr/bin/wsrep_sst_common /usr/bin/wsrep_sst_mysqldump /usr/bin/wsrep_sst_rsync /usr/bin/wsrep_sst_xtrabackup /usr/bin/wsrep_sst_xtrabackup-v2 /usr/share/mysql/wsrep.cnf /usr/share/mysql/wsrep_notify

2 2

[Maria-discuss] sanity check: mysql_upgrade MariaDB 5.5 straight to 10.1
by mike bayer 19 Jan '17

19 Jan '17

Hi all - I believe I know the answer to this question, however hoping someone can confirm all the assumptions (looks like there are three) are correct. Basically if one installs mariadb-10.1 on top of a data directory that's currently 5.5, and we run mysql_upgrade, is it as good/compatible/safe as if we had upgraded first to 10.0 in the interim? Per mariadb's documentation: https://mariadb.com/kb/en/mariadb/upgrading-from-mariadb-55-to-mariadb-100/ "There are no changes in table or index formats between MariaDB 5.5 and MariaDB 10.0" https://mariadb.com/kb/en/mariadb/upgrading-from-mariadb-100-to-101/, "There are no changes in table or index formats between MariaDB 10.0 and MariaDB 10.1" So assumption 1, transitively we can conclude there are no changes in table or index formats between 5.5 and 10.1. Next, mysql_upgrade seems like it alters some tables in the mysql database, and runs mysqlcheck --check-upgrade --auto-repair, which itself is mainly running CHECK TABLE. assumption 2 is then: the table changes in mysql_upgrade work against a 5.5 database going straight to 10.1. This would mean that if there were some tables/column changes in 5.5->10.0, and some more in 10.0->10.1, the mysql_upgrade command encapsulates both sets of changes as shipped in 10.1. It looks like this step comes from the .sql files in scripts/ by way of concatenating them into the "comp_sql" tool. Doing a diff of these scripts between 10.0.28 and 10.1.18 seems like only mysql_system_tables_fix.sql has the important bits (we don't use the performance schema stuff) and it looks like it only adds ALTER statements for more columns, the new columns from the 10.0 script are maintained. Not to mention it documents in a very open-ended way "This part converts any old privilege tables to privilege tables suitable for current version of MySQL". assumption 3 is, the Mariadb 10.1 engine running CHECK TABLE against a 5.5 database is fully compatible. The schema changes seem to be straightforward and as CHECK TABLE seems to regard the table and index formats which in assumption 1 have not changed, this should be totally fine as well. Note that I'm being kind of vague about what mysql_upgrade and mysqlcheck do, as I've only read the public documentation, browsed the source code a bit and am hoping this is all there is to it. There are a few blog posts on the web that illustrate a 5.5->10.1 direct upgrade, but these are not "official". Thanks for any guidance people can offer here!

1 0

[Maria-discuss] MariaDB 10.1.21 and other releases now available
by Daniel Bartholomew 18 Jan '17

18 Jan '17

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.21, MariaDB 10.0.29, MariaDB Galera Cluster 10.0.29, MariaDB Connector/J 1.5.7, MariaDB Connector/C 2.3.2, and MariaDB Connector/C 3.0.1 Beta. Apart from Connector/C 3.0.1 Beta, these are all stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.21 - Release Notes: https://mariadb.com/kb/en/mdb-10121-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10121-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.21 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 10.0.29 - Release Notes: https://mariadb.com/kb/en/mdb-10029-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10029-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.0.29 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 Galera Cluster 10.0.29 - Release Notes: https://mariadb.com/kb/en/mgc-10029-rn/ - Changelog: https://mariadb.com/kb/en/mgc-10029-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.29 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/J 1.5.7 - Release Notes: https://mariadb.com/kb/en/mcj-157-rn/ - Changelog: https://mariadb.com/kb/en/mcj-157-cl/ - Downloads: https://downloads.mariadb.org/connector-java/1.5.7/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-j/ MariaDB Connector/C 2.3.2 - Release Notes: https://mariadb.com/kb/en/mcc-232-rn/ - Changelog: https://mariadb.com/kb/en/mcc-232-cl/ - Downloads: https://downloads.mariadb.org/connector-c/2.3.2/ About MariaDB Connector/C: - https://mariadb.com/kb/en/about-mariadb-connector-c/ MariaDB Connector/C 3.0.1 Beta - Release Notes: https://mariadb.com/kb/en/mcc-301-rn/ - Changelog: https://mariadb.com/kb/en/mcc-301-cl/ - Downloads: https://downloads.mariadb.org/connector-c/3.0.1/ About MariaDB Connector/C: - https://mariadb.com/kb/en/about-mariadb-connector-c/ - - 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] Handlersocket and stale data
by Sales 15 Jan '17

15 Jan '17

Is it still the case that Handlersocket may return stale data when the underlying structure is updated? Since there is still no memcached plugin in Mariadb, hoping stale data is not an issue. Steve

1 0

[Maria-discuss] ON update timestamp replication
by Artem Kuchin 14 Jan '17

14 Jan '17

Hello! Both master and slave run: Server version: 10.1.14-MariaDB FreeBSD Ports Replication is based on mixed format. Slave is used for backups without locking and going off line. I have a script that runs once a day and checksums all tables, so all tables are 100% in match (it wait for sync, locks and checksums). One table is very often out of sync. ON MASTER: show create table Message193; CREATE TABLE `Message193` ( `Message_ID` int(11) NOT NULL AUTO_INCREMENT, `User_ID` int(11) NOT NULL, `Subdivision_ID` int(11) NOT NULL, `Sub_Class_ID` int(11) NOT NULL, `Priority` int(11) NOT NULL DEFAULT '0', `Keyword` char(255) NOT NULL, `ncTitle` varchar(255) DEFAULT NULL, `ncKeywords` varchar(255) DEFAULT NULL, `ncDescription` text, `ncSMO_Title` varchar(255) DEFAULT NULL, `ncSMO_Description` text, `ncSMO_Image` char(255) DEFAULT NULL, `Checked` tinyint(4) NOT NULL DEFAULT '1', `IP` char(15) DEFAULT NULL, `UserAgent` char(255) DEFAULT NULL, `Parent_Message_ID` int(11) NOT NULL DEFAULT '0', `Created` datetime NOT NULL, `LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `LastUser_ID` int(11) NOT NULL, `LastIP` char(15) DEFAULT NULL, `LastUserAgent` char(255) DEFAULT NULL, `Type` char(255) DEFAULT NULL, `Title` char(255) DEFAULT NULL, `Background` char(255) DEFAULT NULL, `Link` char(255) DEFAULT NULL, PRIMARY KEY (`Message_ID`), UNIQUE KEY `Sub_Class_ID` (`Sub_Class_ID`,`Message_ID`,`Keyword`), KEY `User_ID` (`User_ID`), KEY `LastUser_ID` (`LastUser_ID`), KEY `Subdivision_ID` (`Subdivision_ID`), KEY `Parent_Message_ID` (`Parent_Message_ID`), KEY `Priority` (`Priority`,`LastUpdated`), KEY `Checked` (`Checked`), KEY `Created` (`Created`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 | ON SLAVE CREATE TABLE `Message193` ( `Message_ID` int(11) NOT NULL AUTO_INCREMENT, `User_ID` int(11) NOT NULL, `Subdivision_ID` int(11) NOT NULL, `Sub_Class_ID` int(11) NOT NULL, `Priority` int(11) NOT NULL DEFAULT '0', `Keyword` char(255) NOT NULL, `ncTitle` varchar(255) DEFAULT NULL, `ncKeywords` varchar(255) DEFAULT NULL, `ncDescription` text, `ncSMO_Title` varchar(255) DEFAULT NULL, `ncSMO_Description` text, `ncSMO_Image` char(255) DEFAULT NULL, `Checked` tinyint(4) NOT NULL DEFAULT '1', `IP` char(15) DEFAULT NULL, `UserAgent` char(255) DEFAULT NULL, `Parent_Message_ID` int(11) NOT NULL DEFAULT '0', `Created` datetime NOT NULL, `LastUpdated` timestamp NOT NULL, `LastUser_ID` int(11) NOT NULL, `LastIP` char(15) DEFAULT NULL, `LastUserAgent` char(255) DEFAULT NULL, `Type` char(255) DEFAULT NULL, `Title` char(255) DEFAULT NULL, `Background` char(255) DEFAULT NULL, `Link` char(255) DEFAULT NULL, PRIMARY KEY (`Message_ID`), UNIQUE KEY `Sub_Class_ID` (`Sub_Class_ID`,`Message_ID`,`Keyword`), KEY `User_ID` (`User_ID`), KEY `LastUser_ID` (`LastUser_ID`), KEY `Subdivision_ID` (`Subdivision_ID`), KEY `Parent_Message_ID` (`Parent_Message_ID`), KEY `Priority` (`Priority`,`LastUpdated`), KEY `Checked` (`Checked`), KEY `Created` (`Created`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 | Notice that `LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, on slave becomes `LastUpdated` timestamp NOT NULL, This is already bad enough because if master is lost then slave will not be the same as master, trigger are not restored. Now check records: MASTER MariaDB [anapolisdom_ru]> select * from Message193 limit 1\G *************************** 1. row *************************** Created: 2016-11-25 13:25:09 LastUpdated: 2016-11-25 13:25:09 MariaDB [anapolisdom_ru]> select * from Message193 limit 1\G Created: 2016-11-25 13:25:09 LastUpdated: 0000-00-00 00:00:00 As you see lastupdated field is not replicated at all. Two questions, problems: 1) How to replicate default value and on update part for this field? 2) How to make it replicate the timestamp value? Artem

3 5

[Maria-discuss] Enabling Github integration with JIRA
by jocelyn fournier 13 Jan '17

13 Jan '17

Hi all, Currently there's no way when a JIRA ticket is closed to have a direct access to the associated commits in Github. GitHub integration with JIRA is available, and quite easy to configure, so it would be great to have it enabled on MariaDB Server. Do you think it's possible? Thanks! -- Jocelyn Fournier Founder M : +33 6 51 21 54 10 https://www.softizy.com Softizy - At your side to Optimize your PHP / MySQL applications

3 2

[Maria-discuss] Issue with MariaDB-server-5.5.54-1.el6.x86_64
by Clint Dilks 05 Jan '17

05 Jan '17

Hi, Today I have updated a CentOS 6.8 system that has MariaDB-server installed from http://yum.mariadb.org/5.5/centos6-amd64 and found that I had an SELinux issue when I tried to restart the service. Using the information at https://wiki.centos.org/HowTos/SELinux I have created a local policy that seems to fix things module marialocal 1.0; require { type mysqld_safe_t; class capability { setuid setgid }; } #============= mysqld_safe_t ============== allow mysqld_safe_t self:capability setgid; allow mysqld_safe_t self:capability setuid; This seems to fix things for me, but I thought I had better see if others are experiencing the same problem ? It may be useful to know that the particular rpms are MariaDB-server-5.5.54-1.el6.x86_64 and selinux-policy-3.7.19-292.el6_8.2.noarch. If it is a bigger issue than just myself, should I report this somewhere else to see if we can get a fix added to the next MariaDB-server rpm ? Thanks

2 2

[Maria-discuss] limiting memory use by mariadb?
by l vic 05 Jan '17

05 Jan '17

Is there some way to set hard limit for use of RAM by mariaDB server? Thanks, -V

4 16

[Maria-discuss] Fwd: Update of RPM layout
by Michal Schorm 05 Jan '17

05 Jan '17

Hello all, I went through an idea [1] to lighten the server package. I tested it, and I found out, I can save about 40MB of space, if I'd move all Perl utilites to a standalone subpackage. It would make sense to move them, so the users don't need to install Perl with the server package. Especially in technologies like containers (or cloud images) size matters. It all depends on how often are those utilities [2] used together with the server, sice we don't want to displace importatnt scripts. In case, it would look like a good idea, there is also option to move to this subpackage other - infrequently used - utilities. -> Q: Hey, Users and Admins, which utilities do you think are essential for the server? Note: It can be solved by soft dependencies, so those utils would be installed with the server by default. [1] https://bugzilla.redhat.com/show_bug.cgi?id=1205082 [2] mysql_find_rows mysqlaccess mysql_convert_table_format mysql_fix_extensions mysql_setpermission mysql_zap mysqldumpslow mysqld_multi mysqlhotcopy -- Michal Schorm Core Services - Databases Team mail: mschorm(a)redhat.com Brno-IRC: mschorm

3 3

[Maria-discuss] nofile and nproc settings for mysql user in /etc/security/limits.conf
by Kaushal Shriyan 30 Dec '16

30 Dec '16

Hi, What should be the recommended nproc and nofile settings for mariadb or mysql user in /etc/security/limits.conf or /etc/my.cnf? I am running CentOS Linux version 6.8 Any help will be highly appreciable. Regards, Kaushal

2 1

[Maria-discuss] possible bug? #innodb-encryption-threads
by lejeczek 27 Dec '16

27 Dec '16

hi everyone I'm having a peculiar situation, a problem here with my config, which config is pretty galera-vanilla. Namely, if I set these: plugin-load-add = file_key_management.so file-key-management file-key-management-filename = /var/lib/mysql/.keys.txt innodb_file_per_table = 1 innodb-encrypt-log innodb-encryption-threads = 4 <= # this ! one here I get constant load on four cores, it would fluctuate just under %400 CPU (24*7). I'd assume that innodb-encryption-threads value causes it, and whatever the value might be it will be reflected in CPU usage. I wonder if you too see it. I my case I think it does something more to one system, it crashes the bloody thing to the extent where cold reboot is needed. MariaDB-client-10.1.19-1.el7.centos.x86_64 MariaDB-shared-10.1.19-1.el7.centos.x86_64 MariaDB-common-10.1.19-1.el7.centos.x86_64 MariaDB-server-10.1.19-1.el7.centos.x86_64 best, L

3 2

[Maria-discuss] error on show status query
by l vic 26 Dec '16

26 Dec '16

Have the following error trace from running SHOW STATUS LIKE 'wsrep_%' Any idea what could cause it? 2016-12-21 3:39:24 139668819036928 [Note] InnoDB: Online DDL : End of applying row log 2016-12-21 3:39:24 139668819036928 [Note] InnoDB: Online DDL : Completed 2016-12-21 3:43:29 139668818733824 [Note] InnoDB: Online DDL : Start 2016-12-21 3:43:29 139668818733824 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files 2016-12-21 03:43:29 7f072e53ab00 InnoDB: Error: Write to file (merge) failed at offset 0. InnoDB: 1048576 bytes should have been written, only 901120 were written. InnoDB: Operating system error number 12. InnoDB: Check that your OS and file system support files of this size. InnoDB: Check also that the disk is not full or a disk quota exceeded. InnoDB: Error number 12 means 'Cannot allocate memory'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html 2016-12-21 3:43:29 139668818733824 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files java.sql.SQLNonTransientConnectionException: (conn:17945) Could not read resultset: unexpected end of stream, read 0 bytes from 4 Query is : SHOW STATUS LIKE 'wsrep_%' at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:132) at org.mariadb.jdbc.internal.util.ExceptionMapper.getException(ExceptionMapper.java:101) at org.mariadb.jdbc.internal.util.ExceptionMapper.throwAndLogException(ExceptionMapper.java:77) at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:224) at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:258) at org.mariadb.jdbc.MariaDbStatement.executeQuery(MariaDbStatement.java:371) at com.verizon.mesos.Dbcheck.getStatus(Dbcheck.java:153) at com.verizon.mesos.Dbcheck.run(Dbcheck.java:103) at com.verizon.mesos.MariadbTask.handleHealthCheck(MariadbTask.java:310) at com.verizon.mesos.MariadbTask.executeCmd(MariadbTask.java:384) at com.verizon.mesos.MariadbTask.run(MariadbTask.java:450) at com.verizon.mesos.ExecutorTask.executeCmd(ExecutorTask.java:50) at com.verizon.mesos.ExecutorTask.run(ExecutorTask.java:115) at java.lang.Thread.run(Thread.java:745)

2 4

[Maria-discuss] MariaDB 10.2.3 and 5.5.54 now available
by Daniel Bartholomew 24 Dec '16

24 Dec '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.3 beta and MariaDB 5.5.54 stable (GA). See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.2.3 - Release Notes: https://mariadb.com/kb/en/mdb-1023-rn/ - Changelog: https://mariadb.com/kb/en/mdb-1023-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.2.3 About MariaDB 10.2: - https://mariadb.com/kb/en/what-is-mariadb-102/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB 5.5.54 - Release Notes: https://mariadb.com/kb/en/mdb-5554-rn/ - Changelog: https://mariadb.com/kb/en/mdb-5554-cl/ - Downloads: https://downloads.mariadb.org/mariadb/5.5.54 About MariaDB 5.5: - https://mariadb.com/kb/en/what-is-mariadb-55/ 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] aria engine error
by Roberto Spadim 22 Dec '16

22 Dec '16

hi guys i got a crash and aria engine don't startup, any help? 161222 03:41:13 mysqld_safe Starting mysqld daemon with databases from /home/mysql/data/local/ 2016-12-22 3:41:13 139878188566400 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release. 2016-12-22 3:41:13 139878188566400 [Note] /usr/mariadb/mariadb/bin//mysqld (mysqld 10.1.5-MariaDB-log) starting as process 19217 ... 2016-12-22 3:41:13 139878188566400 [Note] mysqld: Aria engine: starting recovery recovered pages: 0% 3082852397% 0%161222 3:41:13 [ERROR] mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see http://kb.askmonty.org/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.1.5-MariaDB-log key_buffer_size=629145600 read_buffer_size=4194304 max_used_connections=0 max_threads=52 thread_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1041422 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x0 thread_stack 0x48000 mysys/stacktrace.c:247(my_print_stacktrace)[0x7f37ee645b0b] sql/signal_handler.cc:153(handle_fatal_signal)[0x7f37ee1dfdb5] /lib64/libpthread.so.0(+0x10d00)[0x7f37ecd72d00] maria/ma_recovery.c:2142(exec_REDO_LOGREC_CLR_END)[0x7f37ee5683b7] maria/ma_recovery.c:588(display_and_apply_record)[0x7f37ee56985d] maria/ma_recovery.c:350(maria_apply_log)[0x7f37ee56d45c] maria/ma_recovery.c:242(maria_recovery_from_log)[0x7f37ee56df1e] maria/ha_maria.cc:3594(ha_maria_init)[0x7f37ee546c2d] sql/handler.cc:512(ha_initialize_handlerton(st_plugin_int*))[0x7f37ee1e2518] sql/sql_plugin.cc:1403(plugin_initialize)[0x7f37ee089e65] sql/sql_plugin.cc:1675(plugin_init(int*, char**, int))[0x7f37ee08add2] sql/mysqld.cc:5064(init_server_components)[0x7f37edfc37e8] sql/mysqld.cc:5659(mysqld_main(int, char**))[0x7f37edfc61ca] /lib64/libc.so.6(__libc_start_main+0xf0)[0x7f37ec3a79f0] /usr/mariadb/mariadb/bin//mysqld(+0x39dbad)[0x7f37edfbabad]

1 2

[Maria-discuss] restore problem with xtrabackup
by l vic 21 Dec '16

21 Dec '16

i have installed mariadb 1.10.13 cluster with user "root", password "pass" I have created test database "galeratest": CREATE DATABASE galeratest;USE galeratest;CREATE TABLE test_table ( id INT PRIMARY KEY AUTO_INCREMENT, msg TEXT ) ENGINE=InnoDB;INSERT INTO test_table (msg) VALUES ("Hello cluster."); backup: xtrabackup --user=root --password=pass --backup --target-dir=/media 161219 21:06:00 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/var/run/mysqld/mysqld.sock' as 'root' (using password: YES). 161219 21:06:00 version_check Connected to MySQL server 161219 21:06:00 version_check Executing a version check against the server... ... ok .. At this point i drop my database : DROP DATABASE galeratest; and trying to restore: xtrabackup --user=root --password=pass --prepare --target-dir=/media cd /media/ rsync -rvt --exclude 'xtrabackup_checkpoints' --exclude 'xtrabackup_logfile' \ ./ /var/lib/mysql chown -R mysql:mysql /var/lib/mysql/ MariaDB [galeratest]> show tables; +----------------------+ | Tables_in_galeratest | +----------------------+ | test_table | +----------------------+ 1 row in set (0.00 sec) MariaDB [galeratest]> select * from test_table; *ERROR 1932 (42S02): Table 'galeratest.test_table' doesn't exist in engine* *Any idea what the problem is? * Thanks,

2 2

[Maria-discuss] MariaDB 10.1.20 now available
by Daniel Bartholomew 15 Dec '16

15 Dec '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.20. This is a stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.20 - Release Notes: https://mariadb.com/kb/en/mdb-10120-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10120-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.20 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/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

Re: [Maria-discuss] Semaphore hangs
by Jon Foster 15 Dec '16

15 Dec '16

On 12/08/2016 04:16 PM, Jon Foster wrote: > On 12/08/2016 03:13 PM, Daniel Black wrote: >> On 09/12/16 09:43, Jon Foster wrote: >>> On 12/07/2016 06:04 PM, Daniel Black wrote: >>>> On 08/12/16 08:51, Jon Foster wrote: >>>>> We are having trouble with MariaDB hanging due to a "semaphore wait". We >>>>> then have to shut MariaDB down as it typically won't recover, unless it >>>>> restarts itself, which happens if we wait long enough. But if its gone >>>>> on long enough MariaDB won't even shutdown, it hangs indefinitely >>>>> waiting for some other internal service. I don't remember the exact name >>>>> and we've been fast enough I haven't seen it in a while. >>>>> >>>>> We've had the database on two completely different servers and still see >>>>> the problem. Both servers were bought new for this project and are a >>>>> year or less old. They are running all SSD drives, Debian 7 64bit with >>>>> MariaDB 10.1 from the MariaDB APT repository. >>>>> >>>>> Since the XtraDB engine was usually mentioned in the logged messages we >>>>> switched back to the Oracle InnoDB engine. Although this seems to have >>>>> reduced the frequency it didn't fix it. >>>>> >>>>> Can anyone give some advice on fixing this. It really seams like a bug >>>>> in MariaDB. I'll try to provide any needed info. >> [...] So its happened again on Tuesday (12/13) morning, early enough the east coasters got it before I was aware of it (they are 3hrs ahead and I was just getting up). Unfortunately I wasn't able to try the "gdb" request from the previous discussion on this topic. So I've been looking for ways to cross reference all the thread and mutexes mentioned to try and pinpoint where the failure is happening. This crash produced over 430MB of log data. I sliced out the first InnoDB monitor dump (a mere 1.5MB) and stripped it down to just the threads and related messages. I'm still reviewing the logs but I found something I thought was interesting enough I'd throw it out here and see if anyone had any thoughts. There were 4,894 threads listed in the dump. But it appears that everyone was waiting for one thread. Here is what the log said about that one thread: 06:01:42 --Thread 139879467059968 has waited at trx0sys.ic line 431 for 0.00 seconds the semaphore: 06:01:42 Mutex at 0x7f3a09a92068 created file trx0sys.cc line 729, lock var 0 06:01:42 Last time reserved by thread 18446744073709551615 in file not yet reserved line 0, waiters flag 0 I trimmed out the data and server name to shorten the lines. Several interesting things to note: 1. Thread 18446744073709551615 doesn't exist in the InnoDB monitor dump. 2. All of the other thread IDs are 15 digits. This one is 20 digits. 3. Over a thousand other threads are waiting on this one because it apparently has the lock_sys->mutex mutex. All of the remaining threads are waiting on those others. 4. This thread shows a 0 second wait time when many of the other threads say they've been waiting over 250 seconds. Sure looks like the mutex is being held by a non-existent thread. Memory corruption? I'm still looking over the logs so I might find some other stuff or something else to point the finger at. But I thought I'd throw this out there and see if anyone has some insight. Or maybe I should be taking this issue to another list or report it as a bug? THX - Jon -- Sent from my Debian Linux workstation -- http://www.debian.org/intro/about Jon Foster JF Possibilities, Inc. jon(a)jfpossibilities.com 541-410-2760 Making computers work for you!

1 0

Re: [Maria-discuss] Semaphore hangs
by Daniel Black 09 Dec '16

09 Dec '16

On 09/12/16 09:43, Jon Foster wrote: > On 12/07/2016 06:04 PM, Daniel Black wrote: >> On 08/12/16 08:51, Jon Foster wrote: >>> We are having trouble with MariaDB hanging due to a "semaphore wait". We >>> then have to shut MariaDB down as it typically won't recover, unless it >>> restarts itself, which happens if we wait long enough. But if its gone >>> on long enough MariaDB won't even shutdown, it hangs indefinitely >>> waiting for some other internal service. I don't remember the exact name >>> and we've been fast enough I haven't seen it in a while. >>> >>> We've had the database on two completely different servers and still see >>> the problem. Both servers were bought new for this project and are a >>> year or less old. They are running all SSD drives, Debian 7 64bit with >>> MariaDB 10.1 from the MariaDB APT repository. >>> >>> Since the XtraDB engine was usually mentioned in the logged messages we >>> switched back to the Oracle InnoDB engine. Although this seems to have >>> reduced the frequency it didn't fix it. >>> >>> Can anyone give some advice on fixing this. It really seams like a bug >>> in MariaDB. I'll try to provide any needed info. Its either a bug or you are running without sufficient hardware. If you rule out the later I suggest opening a report at jira.mariadb.org >>> TIA - Jon >>> >> Needed info: >> * exact MariaDB version 10.1.X >> * mariadb configuration >> * what is the entire mysql log from the startup until the "semaphore >> wait" >> * how are you determining "semaphore wait" >> * is a SHOW FULL PROCESS LIST possible? if so contents? >> * when in a stalled state run on a commmand line (with gdb installed) >> gdb --batch --eval-command="thread apply all bt" program $(pidof mysqld) >> > Version: 10.10.19+maria-1~wheezy, but we started having problems with > 5.5.x which after a few updates prompted us to try 10.1. > > Configuration: > ----------------------- > [mysqld_safe] > socket = /var/run/mysqld/mysqld.sock > nice = -10 Niceing below 0 isn't that productive. -10 might be interfering with kernel IO processes that are needed to enable userspace threads to resume. No high IO/CPU/RAM should be running on the same host however if you do -1 or -2 might help achieve a higher priority than the other process. > [mysqld] > user = mysql > pid-file = /var/run/mysqld/mysqld.pid > socket = /var/run/mysqld/mysqld.sock > port = 3306 > basedir = /usr > datadir = /ssd/mysql > tmpdir = /ssd/tmp > lc_messages_dir = /usr/share/mysql > lc_messages = en_US > skip-external-locking > # NOTE: these two were recently added to troubleshoot > ignore_builtin_innodb > plugin_load=innodb=ha_innodb.so > bind-address = 127.0.0.1 > skip-name-resolve > max_connections = 8000 At the time of the crash you seem to have about 4k threads zgrep 12:35:18 /tmp/mozilla_dan0/mysql-crash-20161207.log.gz | grep ' --Thread' | cut -f 8 -d ' ' | sort -u | wc -l 4158 I suspect you don't have enough grunt in hardware to support this. I do suspect that this level is significantly above standard load. I'd restrict max_connections to something you have seen your hardware handle. > connect_timeout = 5 > wait_timeout = 60 > max_allowed_packet = 1M > thread_cache_size = 100 > sort_buffer_size = 1M > bulk_insert_buffer_size = 16M > tmp_table_size = 32M > max_heap_table_size = 10M > join_buffer_size = 1M > myisam_recover = BACKUP > key_buffer_size = 128M > open-files-limit = 65535 > table_open_cache = 15000 > myisam_sort_buffer_size = 128M > concurrent_insert = 2 > read_buffer_size = 256K > read_rnd_buffer_size = 256K > query_cache_limit = 1M > query_cache_size = 16M > slow_query_log=0 > slow_query_log_file = /var/log/mysql/mariadb-slow.log > long_query_time = 3 > log_slow_verbosity = query_plan > binlog_format = ROW > expire_logs_days = 10 > max_binlog_size = 100M > default_storage_engine = InnoDB > innodb_buffer_pool_size = 2600M > innodb_log_buffer_size = 256M > innodb_file_per_table = 1 > innodb_open_files = 400 > innodb_io_capacity = 400 > innodb_adaptive_hash_index = 0 > # These two were added just prior to this last crash. > innodb_buffer_pool_dump_at_shutdown = 1 > innodb_buffer_pool_load_at_startup = 1 > innodb_flush_log_at_trx_commit = 0 Setting ^ to 0 will mean less IO however it means that you can loose stuff on your expected crash. > innodb_support_xa = 0 > sync_binlog = 0 > ----------------------- > > Logs: This most recent case is about 19M uncompressed. I have hosted it > on my website here: > http://www.jfpossibilities.com/static/pickup/mysql-crash-20161207.log.gz > If you would like it delivered some other way let me know. I have about > 300M of logs from a previous crash situation. That time was particularly > bad since for some reason it would hang again within ten minutes of > being restarted. By limiting the connections on our webservers I was > able to baby it to get it going again. > > I determined "semaphore wait" from the zillions of messages in the logs > that say it. We shut down this one pretty quick. But I usually recognize > the symptoms fairly early on: the number of DB connections escalates > from ~1k up to the max 8k. The number of running queries as shown with > "show processlist" escalates along with it going from less than 10 to > hundreds or thousands depending on how long we wait. sounds like max_connections of 100 might be more suitable. Matches thread_cache_size. > Then too the Apache > connections on the web servers escalate. And of course the "load factor" > on all the servers jumps up. Icinga usually gives us the heads up. Is apache on the same machine? If so you configured Apache so that it doesn't consume more memory and leave MySQL with no headroom. Of course its better to have it on a different host. Make sure Icinga doesn't show swapping. Check your read and write latency on the SSD. > Obviously your last two requests will have to wait until we are having a > problem again. But I have gdb installed and ready to go... I think. I > don't know much about it. SHOW ENGINE INNODB STATUS would be good too. experiment with gdb on a test machine in the same way. Even if its a different process.

1 0

[Maria-discuss] HDF5 and storage engine
by Roberto Spadim 08 Dec '16

08 Dec '16

Hi guys, does anyone know if mariadb/mysql have a storage engine with read access to HDF5 file format? https://support.hdfgroup.org/HDF5/ thanks -- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle

2 1

[Maria-discuss] Semaphore hangs
by Jon Foster 08 Dec '16

08 Dec '16

We are having trouble with MariaDB hanging due to a "semaphore wait". We then have to shut MariaDB down as it typically won't recover, unless it restarts itself, which happens if we wait long enough. But if its gone on long enough MariaDB won't even shutdown, it hangs indefinitely waiting for some other internal service. I don't remember the exact name and we've been fast enough I haven't seen it in a while. We've had the database on two completely different servers and still see the problem. Both servers were bought new for this project and are a year or less old. They are running all SSD drives, Debian 7 64bit with MariaDB 10.1 from the MariaDB APT repository. Since the XtraDB engine was usually mentioned in the logged messages we switched back to the Oracle InnoDB engine. Although this seems to have reduced the frequency it didn't fix it. Can anyone give some advice on fixing this. It really seams like a bug in MariaDB. I'll try to provide any needed info. TIA - Jon -- Jon Foster jon(a)jfpossibilities.com

2 1

[Maria-discuss] dead server joins the cluster?
by l vic 05 Dec '16

05 Dec '16

Hello, I see the problem with one of the secondary nodes successfully joining the cluster: the cluster_size=3 and it stays this way but database server in container is dead, e.g. nothing listening on the port 3306 Is there possible scenario for the node with failed database server to join the cluster? Thanks,

1 0

[Maria-discuss] New MariaDB releases and EOL distros
by Ian Gilfillan 01 Dec '16

01 Dec '16

Hi From what I understand, 10.2 is currently not being built on Ubuntu 12.04, as after 10.2.2 it required lots of effort to get it working on the platform, too much for a distro about to reach end of life. Currently, it's still built on Centos5, but I understand that this also isn't ideal. The current deprecation dates are listed at: https://mariadb.com/kb/en/mariadb/deprecation-policy/ What about simplifying these decisions with a guideline, such as that major new releases will not be built on distros that reach end-of-life within, say, 6 months of the expected stable release date. So if a new release is expected to be stable in December (understandably always an estimate), we won't bother to build it on distros that EOL before June. Currently, that would mean not building 10.2 on CentOS 5, which I think would be welcomed.

1 0

[Maria-discuss] rejoin timeout
by l vic 01 Dec '16

01 Dec '16

How long can it take for a node to sync during a rejoin? Is there system variable setting that limit? Thanks, -V

1 0

[Maria-discuss] rejoin timeout?
by l vic 30 Nov '16

30 Nov '16

How long can it take for a node to sync during a rejoin? Is there environmental variable for that? Thanks, -V

1 0

Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION)
by Federico Razzoli 30 Nov '16

30 Nov '16

Woops, sorry, I missed the GLOBAL word :) Federico -------------------------------------------- Mer 30/11/16, Ian Gilfillan <ian(a)mariadb.org> ha scritto: Oggetto: Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION) A: maria-discuss(a)lists.launchpad.net Data: Mercoledì 30 novembre 2016, 15:13 On 30/11/2016 15:13, Federico Razzoli wrote: > This always shows the global value: > SHOW VARIABLES LIKE ... > > This always shows the current session value: > SHOW SESSION VARIABLES LIKE ... This is not correct. SHOW VARIABLES shows the session value: SET GLOBAL wait_timeout=601; SET SESSION wait_timeout=599; SHOW SESSION VARIABLES LIKE 'wait_%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout | 599 | +---------------+-------+ SHOW GLOBAL VARIABLES LIKE 'wait_%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout | 601 | +---------------+-------+ SHOW VARIABLES LIKE 'wait_%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout | 599 | +---------------+-------+ _______________________________________________ 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

1 0

Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION)
by Federico Razzoli 30 Nov '16

30 Nov '16

This always shows the global value: SHOW VARIABLES LIKE ... This always shows the current session value: SHOW SESSION VARIABLES LIKE ... Global value is read from the files when the server starts, and later can be changed with SET GLOBAL var = val. Session value is copied from global value when the session starts (so changing the global value doesn't affect existing sessions) and can later be changed with SET var = val. In other words, the global value is important because it is used by all new sessions by default, but the session value is what really takes effect. I beleive that your application sets a session value. Federico -------------------------------------------- Mer 30/11/16, Florent B <florent(a)coppint.com> ha scritto: Oggetto: Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION) A: "Federico Razzoli" <federico_raz(a)yahoo.it>, maria-discuss(a)lists.launchpad.net Data: Mercoledì 30 novembre 2016, 10:44 Ok, I found the problem thanks to you Federico. On Debian, mysql-common package provided by MariaDB repository contains "wait_timeout = 600" in my.cnf. This is not the default value specified in documentation (28800). And when I use "mysql -u root -p -h my_host" command to show variables, the default value is displayed (28800), I never saw 600 in here ! Why ? But displaying variables in my PHP app showed me that wait_timeout was effectively set to 600. Setting wait_timeout=28800 in a config file in /etc/mysql/conf.d directory fixes this. Should we consider "wait_timeout = 600" in my.cnf as a bug ? That's not default value... On 11/29/2016 11:17 PM, Federico Razzoli wrote: > Interesting. A couple ideas: > > 1 > Try this query: > SHOW SESSION VARIABLES LIKE '%timeout%'; > But this time, this should be executed by PHP, using the same library used by the application. Why? To check if a library changes a timeout at session level. > > 2 > Have you checked if your application reconnects N times? For example, 600 could be a 60 seconds timeout * 10 attempts. > > Federico > > > -------------------------------------------- > Mar 29/11/16, Florent B <florent(a)coppint.com> ha scritto: > > Oggetto: Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION) > A: "Reindl Harald" <h.reindl(a)thelounge.net>, maria-discuss(a)lists.launchpad.net > Data: Martedì 29 novembre 2016, 12:22 > > On 11/29/2016 12:03 PM, > Reindl Harald wrote: > > > > > > Am 29.11.2016 um > 11:49 schrieb Florent B: > >> For > example, if I try this in PHP: > >> > >> 1/ Connect to mariadb > >> > >> 2/ sleep 610 > seconds > >> > >> 3/ > ping mariadb > >> > >> => I got Server has gone away > error. > >> > >> > With a 590 sleep time, no error. > >> > >> I use MariaDB 10.1, didn't change > any "timeout" value in MariaDB : > >> interactive_timeout & wait_timeout > are 28800 > > > > http://php.net/manual/en/mysqlnd.config.php#ini.mysqlnd.net-read-timeout > > > > Hi, and > thank you. But I cannot find any timeout of 600 > seconds... > default_socket_timeout = 60 > mysqlnd.net_read_timeout = 31536000 > > And I have the exactly same > problem using this algorithm in Python, it's > not related to PHP... > > _______________________________________________ > 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 > > > _______________________________________________ > 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

Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION)
by Federico Razzoli 29 Nov '16

29 Nov '16

Interesting. A couple ideas: 1 Try this query: SHOW SESSION VARIABLES LIKE '%timeout%'; But this time, this should be executed by PHP, using the same library used by the application. Why? To check if a library changes a timeout at session level. 2 Have you checked if your application reconnects N times? For example, 600 could be a 60 seconds timeout * 10 attempts. Federico -------------------------------------------- Mar 29/11/16, Florent B <florent(a)coppint.com> ha scritto: Oggetto: Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION) A: "Reindl Harald" <h.reindl(a)thelounge.net>, maria-discuss(a)lists.launchpad.net Data: Martedì 29 novembre 2016, 12:22 On 11/29/2016 12:03 PM, Reindl Harald wrote: > > > Am 29.11.2016 um 11:49 schrieb Florent B: >> For example, if I try this in PHP: >> >> 1/ Connect to mariadb >> >> 2/ sleep 610 seconds >> >> 3/ ping mariadb >> >> => I got Server has gone away error. >> >> With a 590 sleep time, no error. >> >> I use MariaDB 10.1, didn't change any "timeout" value in MariaDB : >> interactive_timeout & wait_timeout are 28800 > > http://php.net/manual/en/mysqlnd.config.php#ini.mysqlnd.net-read-timeout > Hi, and thank you. But I cannot find any timeout of 600 seconds... default_socket_timeout = 60 mysqlnd.net_read_timeout = 31536000 And I have the exactly same problem using this algorithm in Python, it's not related to PHP... _______________________________________________ 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

1 0

Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION)
by Reindl Harald 29 Nov '16

29 Nov '16

Am 29.11.2016 um 12:22 schrieb Florent B: > On 11/29/2016 12:03 PM, Reindl Harald wrote: >> Am 29.11.2016 um 11:49 schrieb Florent B: >>> For example, if I try this in PHP: >>> >>> 1/ Connect to mariadb >>> 2/ sleep 610 seconds >>> 3/ ping mariadb >>> => I got Server has gone away error. >>> With a 590 sleep time, no error. >>> I use MariaDB 10.1, didn't change any "timeout" value in MariaDB : >>> interactive_timeout & wait_timeout are 28800 >> >> http://php.net/manual/en/mysqlnd.config.php#ini.mysqlnd.net-read-timeout > > Hi, and thank you. But I cannot find any timeout of 600 seconds... > default_socket_timeout = 60 > mysqlnd.net_read_timeout = 31536000 > > And I have the exactly same problem using this algorithm in Python, it's > not related to PHP... then pretty sure you mysqld timeouts are not what you think, otherwise we would see the same issues on our dbmail machines when after hours of idle postfix tries to re-use it's connections (and we did have such events when that values where too low) so why don't you ask the server instead pretend they are not lowered? MariaDB [(none)]> show variables like 'wait_timeout'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout | 300 | +---------------+-------+ 1 row in set (0.00 sec) MariaDB [(none)]> show variables like 'wait_timeout'; +---------------+--------+ | Variable_name | Value | +---------------+--------+ | wait_timeout | 604800 | +---------------+--------+ 1 row in set (0.00 sec) wait_timeout = 604800 interactive_timeout = 604800

1 0

Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION)
by Stephane VAROQUI 29 Nov '16

29 Nov '16

Stéphane Varoqui, Senior Consultant Phone: +33 695-926-401, skype: svaroqui http://www.mariadb.com <http://www.mariadb.com/> > Le 29 Nov 2016 à 12:22, Florent B <florent(a)coppint.com> a écrit : > > On 11/29/2016 12:03 PM, Reindl Harald wrote: >> >> >> Am 29.11.2016 um 11:49 schrieb Florent B: >>> For example, if I try this in PHP: >>> >>> 1/ Connect to mariadb >>> >>> 2/ sleep 610 seconds >>> >>> 3/ ping mariadb >>> >>> => I got Server has gone away error. >>> >>> With a 590 sleep time, no error. >>> >>> I use MariaDB 10.1, didn't change any "timeout" value in MariaDB : >>> interactive_timeout & wait_timeout are 28800 >> >> http://php.net/manual/en/mysqlnd.config.php#ini.mysqlnd.net-read-timeout >> > > Hi, and thank you. But I cannot find any timeout of 600 seconds... > default_socket_timeout = 60 > mysqlnd.net_read_timeout = 31536000 > > And I have the exactly same problem using this algorithm in Python, it's > not related to PHP… > Have you check your TCP settings or may be some firewall or proxy that would just sit in the middle ? > _______________________________________________ > 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

1 0

Re: [Maria-discuss] Aborted connection (CLOSE_CONNECTION)
by Reindl Harald 29 Nov '16

29 Nov '16

Am 29.11.2016 um 11:49 schrieb Florent B: > For example, if I try this in PHP: > > 1/ Connect to mariadb > > 2/ sleep 610 seconds > > 3/ ping mariadb > > => I got Server has gone away error. > > With a 590 sleep time, no error. > > I use MariaDB 10.1, didn't change any "timeout" value in MariaDB : > interactive_timeout & wait_timeout are 28800 http://php.net/manual/en/mysqlnd.config.php#ini.mysqlnd.net-read-timeout

1 0

[Maria-discuss] semi-sync replication issue
by Rhys.Campbell＠swisscom.com 28 Nov '16

28 Nov '16

Hello All, I recently upgraded to MariaDB 10.0.28 and I am having sporadic issues with semi-sync replicating timeouts. Lots of these are logged.... [ERROR] Read semi-sync reply network error: (errno: 1159) [ERROR] Semi-sync master failed on net_flush() before waiting for slave reply Is anyone else experiencing this? Cheers, Rhys

1 0

[Maria-discuss] jdbc failure after restart
by l vic 23 Nov '16

23 Nov '16

i have the following jdbc exception in my jdbc client for the node 1 after another node (node2) is removed: om.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: WSREP has not yet prepared node for application use at sun.reflect.GeneratedConstructorAccessor9.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) at com.mysql.jdbc.Util.getInstance(Util.java:387) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:917) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1369) at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3833) at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3283) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2297) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at sun.reflect.GeneratedConstructorAccessor5.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328) at java.sql.DriverManager.getConnection(DriverManager.java:664) I wonder why i have this failure when i just trying to read db from the unaffected node? The failure seems to be permanent, once it happened - all subsequent reads fail

2 3

Re: [Maria-discuss] master and slave binlog question?
by Pavel Ivanov 18 Nov '16

18 Nov '16

I guess you can do it like that, yes. I wonder what do you need it for though. On Thu, Nov 17, 2016 at 9:45 PM, Ljr Yang <dbmsprog(a)gmail.com> wrote: > Thank you. > > innobackup backup info on slave: > #cat xtrabackup_binlog_info > mysql-bin.000003 83882214 0-118-60061898358 > > Only filter GTID 0-118-60061898358 in all binlog file of slave ? > > mysqlbinlog -vv mysqbin.000001 | grep -B5 "0-118-60061898358" > mysqlbinlog -vv mysqbin.000002 | grep -B5 "0-118-60061898358" > ........ > > 2016-11-18 13:24 GMT+08:00 Pavel Ivanov <pivanof(a)google.com>: >> >> There is no way to find corresponding binlog file and position on the >> slave. You should use GTIDs to find corresponding binlog positions. >> >> On Thu, Nov 17, 2016 at 7:19 PM, Ljr Yang <dbmsprog(a)gmail.com> wrote: >> > >> > Hi, >> > we config master slave and set log_slave_updates = 1 on slave. >> > on master server‘s binlog file and pos , example: mysql-bin.000005 >> > 2036891 , >> > how could quick find corresponding binlog file and pos on slave? >> > Thanks. >> > >> > -- >> > Ljr >> > >> > _______________________________________________ >> > 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 >> > > > > > > -- > Ljr

1 0

[Maria-discuss] master and slave binlog question?
by Ljr Yang 18 Nov '16

18 Nov '16

Hi, we config master slave and set log_slave_updates = 1 on slave. on master server‘s binlog file and pos , example: mysql-bin.000005 2036891 , how could quick find corresponding binlog file and pos on slave? Thanks. -- Ljr

2 1

[Maria-discuss] Download speeds on archive.mariadb.org
by Guillaume Lefranc 14 Nov '16

14 Nov '16

Hi everyone, Download speeds on archive.mariadb.org have reached an abysmal level - 6kb/s today. Honestly, what is the foundation waiting for to solve this issue that has been lasting for years? I am ready to donate server space and bandwidth myself if needed.

4 7

[Maria-discuss] galera replication specs?
by l vic 14 Nov '16

14 Nov '16

Is there online docs to describe Galera in detail, such as specs/RFC? Thanks,

2 1

[Maria-discuss] rsync failure?
by l vic 08 Nov '16

08 Nov '16

Have the rsync failure (see the trace below): 2016-11-08 15:17:34 139959897945856 [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_rsync --role 'joiner' --address 'node3.frame.mesos' --datadir '/var/lib/mysql/' --parent '114' '' Read: '(null)' 2016-11-08 15:17:34 139959897945856 [ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'joiner' --address 'node3.frame.mesos' --datadir '/var/lib/mysql/' --parent '114' '' : 1 (Operation not permitted) 2016-11-08 15:17:34 139960239241984 [ERROR] WSREP: Failed to prepare for 'rsync' SST. Unrecoverable. 2016-11-08 15:17:34 139960239241984 [ERROR] Aborting Can someone with better understanding of replication process explain the nature of this problem? Can it be caused by hostname resolution failure, or would it be storage related? Thank you,

2 6

[Maria-discuss] rsync timeout?
by l vic 08 Nov '16

08 Nov '16

Is it possible to increase rsync timeout? I checked http://galeracluster.com/documentation-webpages/galeraparameters.html but couldn't find corresponding parameters... Thanks, -V

2 2

[Maria-discuss] on stored procedures
by Federico Razzoli 08 Nov '16

08 Nov '16

Some good points from Bill Karwin: https://www.quora.com/What-are-the-reasons-not-to-use-or-not-use-stored-pro… Federico

5 10

Re: [Maria-discuss] on stored procedures
by Federico Razzoli 08 Nov '16

08 Nov '16

Hi Sergei! I was wondering the same! Justin's explanation is probably correct, but I think that various discussions in this list proven that a part of the community badly wants this feature. I wrote a unit tester in SQL some time ago (I know it may sound weird, but I needed it to test several things, from procedures to query time, and even metrics). It was insanely hard. I mean - I think I can write a unit tester in JavaScript or PHP or even BASH in a few hours, with all the features I want. But SQL is full of traps, so it took weeks (of course it was not my only task). Some of the features that have been discussed in this list could have been implemented as stored procedures. For example, extensions to KILL. It may not be the perfect solution but, well, it is not reasonable to expect that you implement every single need/idea I have during my work. If I could write general purpose stored procedures in any decent language, I would do it, and then would push them to GitHub. It seems that some people agree on this but... still nothing happens. Even PL/SQL parser seems to have higher priority than external languages! :( Is there anything we can do to convince the team? Bye, Federico -------------------------------------------- Lun 7/11/16, Sergei Golubchik <serg(a)mariadb.org> ha scritto: Oggetto: Re: [Maria-discuss] on stored procedures A: "Justin Swanhart" <greenlion(a)gmail.com> Cc: "Federico Razzoli" <federico_raz(a)yahoo.it>, "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Lunedì 7 novembre 2016, 22:42 Hi, Justin! On Nov 07, Justin Swanhart wrote: > We discussed it here and it seemed vary popular. WL-820. I know, right? A cool and useful feature, I'd say. I cannot understand why it's constantly being pushed down for the last 10 years. I still hope we get it someday. > On Mon, Nov 7, 2016 at 10:43 AM, Sergei Golubchik <serg(a)mariadb.org> wrote: > > Hi, Federico! > > > > On Nov 07, Federico Razzoli wrote: > > > Some good points from Bill Karwin: > > > https://www.quora.com/What-are-the-reasons-not-to-use-or- > > not-use-stored-procedures/answer/Bill-Karwin > > > > Thanks. > > > > These are valid points, and some of them are related. > > For example, "does not have a rich library of functions or standard > > procedures" that follows from "does not support packages". > > Which might be fixed in https://jira.mariadb.org/browse/MDEV-10591 > > > > External languages for stored procedures - that's a very cool feature, > > and patches exist for many years. But, apparently, it's more cool than > > practically useful? There were almost no requests for it, not when I was > > in MySQL, not in MariaDB. And, frankly, I do not know why, this looks > > insanely useful to me. Regards, Sergei Chief Architect MariaDB and security(a)mariadb.org

1 0

[Maria-discuss] MariaDB 10.1.19 and other releases now available
by Daniel Bartholomew 07 Nov '16

07 Nov '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.19, MariaDB Galera Cluster 10.0.28, and MariaDB Connector/ODBC 2.0.13. These are all stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.19 - Release Notes: https://mariadb.com/kb/en/mdb-10119-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10119-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.19 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.28 - Release Notes: https://mariadb.com/kb/en/mgc-10028-rn/ - Changelog: https://mariadb.com/kb/en/mgc-10028-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.28 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/ODBC 2.0.13 - Release Notes: https://mariadb.com/kb/en/mco-2013-rn/ - Changelog: https://mariadb.com/kb/en/mco-2013-cl/ - Downloads: https://downloads.mariadb.org/connector-odbc/2.0.13 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/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] Community Involvement - GSoC Mentor Summit impressions
by Vicențiu Ciorbaru 07 Nov '16

07 Nov '16

Hi everyone! Since MariaDB has completed another Google Summer of Code program this year, with some great projects as well, the MariaDB Foundation was able to send 2 mentors to the summit in California this year. I was one of the people that had the privilege to go. There were a lot of talks there about community involvement and how to encourage people to contribute. I've picked the ideas that I've found to be most interesting and useful and have blogged [1] about them. I intend to try and apply some of them if possible. Since this is a community matter (albeit more GSoC related), it makes sense to ask for feedback from the community. I think some of the ideas are at least partly implemented but we can always do better. If you're interested, lets have a discussion on this. Vicențiu [1] http://vicentiu.ciorbaru.io/community-involvement-gsoc-mentor-summit-impres…

1 0

[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] MariaDB 10.1.18 server audit question?
by Ljr Yang 02 Nov '16

02 Nov '16

HI, all We use MariaDB 10.1.18 and CentOS 6.7, today, try to use server audit log. after execute SET GLOBAL server_audit_events = "query_ddl,query_dml,query_dcl" and SET GLOBAL server_audit_logging = 1 ; find have not filter "select" statement in audit log 20161102 11:08:52,fm-test-118,root,172.28.10.121,908933,2799737,QUERY,test,'select * from anv01 LIMIT 0, 100',0 -- Ljr

2 1

[Maria-discuss] upgrading galera 10.0 -> 10.1 without writes downtime
by Federico Razzoli 02 Nov '16

02 Nov '16

Hello list I have to upgrade a cluster and I hoped I can do it safely without a downtime. In my understanding though it is not possible. In my specific case, the cluster is 10.0 and must be upgraded to 10.1. There is a "master" node. Steps are: 1. I upgrade all "slave" nodes 2. I change the "master" 3. I upgrade the old master The problem is that, between 2 and 3, old master is 10.0, and it replicates from 10.1. This is not supported, based on this page: https://mariadb.com/kb/en/mariadb/upgrading-mariadb-upgrading-from-mariadb-… "to prevent 10.1 propagating to 10.0, which is not supported" So my question is, is there a way to upgrade this cluster without writes downtime? Regards, Federico

1 0

[Maria-discuss] Flashback (MDEV-10459) bikeshedding a name
by Daniel Black 02 Nov '16

02 Nov '16

During the MariaDB Developers Meetup last month we deferred deciding on a name for Flashback - a rewinding of database state using binary logs applied in reverse. It is described in MDEV-10459 (https://jira.mariadb.org/browse/MDEV-10459) If you have an opinion as to what name to choose follow the link below to start the survey. Thank you for your participation! The survey closes at the end of this month. https://www.surveymonkey.com/r/T8JVPR3 Results so far: https://www.surveymonkey.com/results/SM-DPMRQV9N

3 3

[Maria-discuss] Replication compatibility MySQL/MariaDB
by Daniel Black 02 Nov '16

02 Nov '16

Folks, At the MariaDB Developer meetup there was some discussion about the limits of compatibility especially regarding replication. I've started a section on this page: https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/ If you can identify what can/cannot work in various replication modes between MySQL and MariaDB please document it on this page. If you cannot edit this for some reason reply to the MariaDB Discuss list and eventually the results can be correlated and the page can be updated. As usual other material changes to improving the KB documentation is welcome. Daniel

1 0

[Maria-discuss] node join failure?
by l vic 01 Nov '16

01 Nov '16

I see intermittent failure for some nodes to join cluster (see below): 2016-11-01 17:24:22 140050125105920 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (fdb9a4a3-a056-11e6-a01d-5a15e8d77e80): 1 (Operation not permitted) at galera/src/replicator_str.cpp:prepare_for_IST():482. IST will be unavailable. 2016-11-01 17:24:22 140049819625216 [Note] WSREP: Member 1.0 () requested state transfer from '*any*'. Selected 0.0 ()(SYNCED) as donor. 2016-11-01 17:24:22 140049819625216 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 4) 2016-11-01 17:24:22 140050125105920 [Note] WSREP: Requesting state transfer: success, donor: 0 2016-11-01 17:24:24 140049819625216 [Warning] WSREP: 0.0 (): State transfer to 1.0 () failed: -255 (Unknown error 255) 2016-11-01 17:24:24 140049819625216 [ERROR] WSREP: gcs/src/gcs_group.cpp:gcs_group_handle_join_msg():733: Will never receive state. Need to abort. Any idea what the cause can be and how to deal with it? Thank you,

1 0

[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

[Maria-discuss] User feedback plugin - reporting broken?
by Colin Charles 26 Oct '16

26 Oct '16

Hi, See https://mariadb.org/feedback_plugin/stats/server_count_by_month/ Is the reporting broken? August to September has a huge drop in reporting servers. 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] .Net + Entity Framework
by Karthick Subramanian 26 Oct '16

26 Oct '16

All, Currently we are using below: .Net framework 4 Entity Framework ODP .Net to Oracle DB New environment: .Net framework 4 Entity Framework MariaDB 10.1.16 We would like to know on how can we connect MariaDB for the above said framework .Net + Entity Framework. We are trying to find some sources online but couldn't figure it out. Can anyone share me on how can we establish connection between .Net Entity Framework to MariaDb and what connector we need to use and any sample code on how we connect. Your help will be highly appreciated. Regards, Karthick

2 4

[Maria-discuss] wsrep-node-name vs. wsrep-node-address?
by l vic 25 Oct '16

25 Oct '16

Do I need to use "--wsrep-node-name" option with dns names to identify the node in Galera cluster instead of "wsrep-node-address", or is the "--wsrep-node-address=<dns-name>" supposed to work? Thanks,

2 1

[Maria-discuss] workaround for MDEV-9688
by Lukas Lehner 25 Oct '16

25 Oct '16

Hi https://jira.mariadb.org/browse/MDEV-9688 is there a workaround for this issue? We need it for DBaaS Lukas

4 4