- discuss - lists.mariadb.org

[Maria-discuss] mydumper halting replication by creating innodb table in mysql db
by Daniel Black 18 Jan '14

18 Jan '14

1 1

[Maria-discuss] Galera on Fedora
by David Timothy Strauss 15 Jan '14

15 Jan '14

The documentation currently warns against using Galera with Fedora [1]. Is that advice still true with Fedora 19+, which defaults to MariaDB? I can see some activity in the bug tracker [2], but nothing the last few months. In a related topic, when are RPMs for Fedora 20 [3] planned? Is there any way I can sponsor work to improve the situation? [1] https://mariadb.com/kb/en/installing-mariadb-with-yum/#installing-mariadb-g… [2] https://mariadb.atlassian.net/browse/MDEV-4141 [3] http://yum.mariadb.org/5.5-galera/

2 1

[Maria-discuss] trademarks
by Federico Razzoli 08 Jan '14

08 Jan '14

I found contradictory information about whom the MariaDB trademark belongs to: "The MariaDB Foundation also holds the trademark of the MariaDB server and owns mariadb.org. This ensures that the official MariaDB development tree will always be open for the MariaDB developer community." https://mariadb.com/kb/en/mariadb-foundation/ "SkySQL and MariaDB are trademarks or registered trademarks of SkySQL Corporation Ab in the European Union and United States of America and/or other countries." http://www.skysql.com/about/legal/trademarks If the last statement is true, I have several questions about the other statement I quoted and some other statements in the Foundation's site. If the last statement is false, I suggest it is fixed, because it is confusing. Regards, Federico

3 2

[Maria-discuss] MariaDB Developer meetings still public?
by Jeremy Cole 07 Jan '14

07 Jan '14

In the past, MariaDB Developer meetings have been open invitation and pre-announced, e.g.: - https://mariadb.org/en/developer-meetings/ - http://planet.mysql.com/entry/?id=30418 - http://monty-says.blogspot.com/2011/02/come-to-lisbon-and-meet-mariadb.html - http://monty-says.blogspot.com/2011/11/mariadb-developer-meeting-in-athens.… And this was even included in Monty's presentation as recently as a couple weeks ago: http://www.slideshare.net/skysql/mariadb-100-skysql-paris-meetup-171220113 >From Slide 47: "Open source development: Anyone can be part of the development at all stages. Developer meetings are public!" Yet, I've heard from a casual mention on IRC that there is such a meeting next week in Barcelona, and I haven't seen any mention of it on this list or elsewhere: <montywi> prohaska7: we will have a mariadb developers meeting in Barcelona next week Are the meetings still public/open? If so, what happened here? Is this a policy change? (I've also seen no private invitation, in case that were in question.) Regards, Jeremy

2 1

[Maria-discuss] failing test: rpl.rpl_stm_sql_mode
by Reindl Harald 07 Jan '14

07 Jan '14

i see the error below over many months, AFAIK also with mySQL "This operation cannot be performed with a running slave; run STOP SLAVE first" is nice but out of scope due running the auto-tests /usr/bin/su -c 'cd /usr/share/mysql-test; ./mysql-test-run.pl --default-myisam --parallel=1 --max-test-fail=0 --mysqld=--binlog-format=mixed --skip-ndb --force' mysql __________________________________________________ rpl.rpl_stm_sql_mode 'stmt' [ fail ] Test ended at 2014-01-07 20:27:05 CURRENT_TEST: rpl.rpl_stm_sql_mode 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_stm_sql_mode.test at line 2: At line 179: query 'RESET SLAVE' failed: 1198: This operation cannot be performed with 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_stm_sql_mode-stmt/' to '/usr/share/mysql-test/var/log/rpl.rpl_stm_sql_mode-stmt/' rpl.rpl_stm_user_variables 'stmt' [ skipped ] Not STATEMENT format

1 0

[Maria-discuss] New Question: MariaDB Galera Cluster Questions
by AskMonty KB 04 Jan '14

04 Jan '14

Hello, A new question has been asked in "MariaDB FAQ" by pranava: -------------------------------- I have some questions on Maria DB Galera Cluster. Q1) If I partition a table in a schema which is part of MariaDB Galera Cluster, can i configure partitions in such a way that a one partition resides in one Node, another partition resides in second Node and so on? I'm trying to shard the data and use Galera cluster nodes to accommodate parts of that shard. Q2) Scenario - During replication of MariaDB Galera Cluster, the Master node gets a request, it processes it and then sends to other nodes for approval, followed by a commit at every node. What if commit happens on majority of nodes except one or two? What happens to that transaction and how about Data consistency among all nodes? Q3) Which protocol is used for communicating between nodes during data replication in MariaDB Galera Cluster? Is it TCP or a Broadcast to all other nodes or Some customized protocol between nodes that enables replication in the cluster. Thanks a lot in advance. Thanks Pranav. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-galera-cluster-questions/

3 2

[Maria-discuss] question about mariadb threadpools and file descriptors
by Rohan M C 31 Dec '13

31 Dec '13

Hi All, We're considering a switch to mariadb (5.5.33a) from mysql (5.5.31) for our production servers. First, some background info about our system 1) ~2000 tables. 3/4th of them are innodb, the rest are myisam 2) All tables are partitioned with ~100 partitions each 3) our largest tables are partitioned (~200 partitions each) and they're all myisam due to space constraints (and other reasons) 4) all our instances are on amazon ec2 on ephemeral store Some of our config parameters open-files-limit 131072 innodb-open-files 16384 table-open-cache 4096 innodb-buffer-pool-size 256M One of the problems we're facing with mysql, and we're hoping to solve with mariadb, is the blowup of the number of open file descriptors when some of our long-running/heavier scripts run. So far we've been able to keep it in control by having our scripts flush at intervals, as well as making individual threads hit different read slaves so as to not open up mulitple copies of myisam fds on a single machine. I do know that the above parameters could be tweaked to set a cap on the number of file descriptors (innodb seems to be a hard limit, so thats under control), but we've set table-open-cache at a high number for performance reasons. Our ideal solution would be to keep the above parameters and not run into a situation where the number of file descriptors grow uncontrollably beyond 70k-80k. It would be preferable to have mariadb close file descriptors once queries are done. We were interested in the mariadb threadpool option as it launches threads dynamically when needed and closes them once it's done. I'm currently testing on a mariadb instance with the default parameters. One of my assumptions with threadpools was that when additional threads were closed, the file descriptors opened for them would also be closed, but upon testing I've seen that this is not the case, and that mariadb behavior as far as threadpools are concerned is exactly the same as mysql. For example, with thread_pool_size=1 and max_threads at 500, if I run 10 identical concurrent queries from different connections on mariadb on a myisam table, it opens up 10 sets of 200 file descriptors. Threadpool_threads spikes up to 10 and drops back down after some time, but all the file descriptors initially opened are still in the open state (2200 fds ). Is this intended behavior for threadpools? I would also be grateful for any tips, reading material or knowledge regarding how mariadb handles file descriptors and if there are any additional parameters that can be tuned to keep the number of file descriptors under control, while not impacting performance too much Thanks in advance. Rohan

1 0

[Maria-discuss] MariaDB 10.0.7 Now Available
by Daniel Bartholomew 27 Dec '13

27 Dec '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.7. This is a Beta release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.7 - Release Notes: https://mariadb.com/kb/en/mariadb-1007-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1007-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.7 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 - - - - - - - - - - - - - - - - - - - - - - - - - SkySQL has had several MariaDB focused Webinars recently which are available on an on-demand basis at: - http://www.skysql.com/why-skysql/webinars/ They are also planning several more MariaDB-focused webinars that will be held over the comming months. Details available at the above link. - - New MariaDB Book - - - - - - - - - - - - - - - - - - - - - - - - - A new MariaDB book has been released! Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB, no previous MariaDB or MySQL experience required. It's available from several booksellers in both paperback and DRM-free epub, mobi and pdf formats. See the PacktPub website for details: - http://www.packtpub.com/getting-started-with-mariadb/book - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] New Question: Debug files not written by client lib
by AskMonty KB 26 Dec '13

26 Dec '13

Hello, A new question has been asked in "MariaDB Client Library for C" by sruliganor: -------------------------------- Hi, I have a C program that uses mariadbclient.lib. I added this line to generatate a trace file from the lib: mysql_debug("d:t:O,e:\\Temp\\MysqlClient.log"); In addition I set environmant variable MYSQL_DEBUG. However, no debug file was created anywhere. What should I do to see trace files? I tried the client lib 1.0 binary downloaded fron your site, as well as the source code complied in DEBUG. Thanks -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/debug-files-not-written-by-client-lib/

1 0

[Maria-discuss] Change from MySQL to MariaDB - Problem with EVENTS-Table in information_schema
by Frank Röhm 21 Dec '13

21 Dec '13

Hello day before yesterday I updated my MySQL Server 5.5.34 to MariaDB 5.5.34 on my Ubuntu 12.04 Server. All went fine but next day, I noticed that the automatic backup script (automysqlbackup) had errors, I read: mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM `EVENTS`': Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577) mysqldump: Couldn't execute 'show events': Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577) I searched about it and found the hint to do the command mysql_upgrade (I needed the option --force) and restart the server. This didn't help, no change. When I manually select * from EVENTS from information_schema I get the same error 1577. When I upgraded I made a backup before, so could I just overwrite the existing information_schema with the dump from my backup? Could I destroy something? Thank you. frank

2 8

Re: [Maria-discuss] INSERT IGNORE (and other SQL commands) fail with: Deadlock found when trying to get lock;
by Benoit Panizzon 20 Dec '13

20 Dec '13

Hi > If memory serves me, the first timestamp, will be set > to current universal time. Like db.table.last_changed Ok, I replaced NOW() with a generated timestamp to avoid that NOW() deadlock. sub mysql_now() { my($sec,$min,$hour,$mday,$mon,$year,$wday, $yday, $isdst)=localtime(time); my($result)=sprintf("%4d-%02d-%02d %02d:%02d:%02d",$year+1900,$mon+1, $mday,$hour,$min,$sec); return $result; } [...] my $mysqltimestamp = mysql_now(); my $timestamph = $dbh->prepare("UPDATE user SET lastActive = ". $dbh- >quote($mysqltimestamp) ." WHERE userid = ". $dbh->quote($user) ." and domain = ". $dbh->quote($domain)); $timestamph->execute(); Still in about 1 of 10 updates, this causes that wrenched Deadlock error, causing the email not being processed correctly and in the case the email is not for local but being forwarded, the email is not forwarded to the correct destination. Dec 18 14:12:34 asterix mimedefang-multiplexor[8019]: NOQUEUE: Slave 0 stderr: DBD::mysql::st execute failed: Deadlock found when trying to get lock; try restarting transaction at /etc/mimedefang-filter.mx line 316. Is there any known way to circumvent that Deadlock Problem? Kind regards Benoit Panizzon -- I m p r o W a r e A G - ______________________________________________________ Zurlindenstrasse 29 Tel +41 61 826 93 07 CH-4133 Pratteln Fax +41 61 826 93 02 Schweiz Web http://www.imp.ch ______________________________________________________

3 9

[Maria-discuss] New Question: MySQL 5.6 function
by AskMonty KB 20 Dec '13

20 Dec '13

Hello, A new question has been asked in "Miscellaneous Functions" by ymhuang0808: -------------------------------- Hello! My MariaDB version is 10.0.6. I found it dosen't support some MySQL 5.6 functions, like INET6_ATON(), INET6_NTOA(), IS_IPV4(), etc. Hope new version MaraiDB support those functions. Thank you. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mysql-56-function/

1 0

[Maria-discuss] MariaDB Galera Cluster 5.5.34 Now Available
by Daniel Bartholomew 18 Dec '13

18 Dec '13

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.34. This is a Stable (GA) maintenance (bug fix) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 5.5.34 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-5534-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-5534-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.34 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 Webinars - - - - - - - - - - - - - - - - - - - - - - - - - SkySQL has had several MariaDB focused Webinars recently which are available on an on-demand basis at: - http://www.skysql.com/why-skysql/webinars/ They are also planning several more MariaDB-focused webinars that will be held over the comming months. Details available at the above link. - - New MariaDB Book - - - - - - - - - - - - - - - - - - - - - - - - - A new MariaDB book has been released! Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB, no previous MariaDB or MySQL experience required. It's available from several booksellers in both paperback and DRM-free epub, mobi and pdf formats. See the PacktPub website for details: - http://www.packtpub.com/getting-started-with-mariadb/book - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] INSERT IGNORE (and other SQL commands) fail with: Deadlock found when trying to get lock;
by Benoit Panizzon 14 Dec '13

14 Dec '13

Hello We have migrated a mailserver project from MySQL NDBCluster to MariaDB Gallera Cluster because we often had sync problems with NDBCluster. Now we found that various of our tools and also our SOAP API Server do not work anymore because some SQL Statements that used to work on NDBCluster do not work with Gallera anymore. I wonder if we stumbled over bugs or if this is some kind of expected behaviour and if yes, how to work around them. We run the most actual version: 5.5.33a Some examples: We have a skript, that from time to time wants to completely delete some statistics data. We don't know if there is already data in that table, we just want to get rid of it... Just some examples how to reproduce the problem: === DELETE on EMPTY TABLE === MariaDB [maildb]> create table statistics (id int(11) primary key, data varchar(30)); Query OK, 0 rows affected (0.80 sec) MariaDB [maildb]> insert into statistics set id=1,data="FooBar"; Query OK, 1 row affected (0.04 sec) MariaDB [maildb]> delete from statistics; Query OK, 1 row affected (0.26 sec) MariaDB [maildb]> delete from statistics; ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction Why the heck do we get a severe error when deleting data from an empty table. This causes the perl skipt to die and not continue it's execution. === INSERT IGNORE === We merge information about users from two sources. One source contains the password. One source might contain additional user which were not added from the first source, but do not contain the passwort. But they also contain users already inserted from the first source, so if a unique key exists, it must not be overwroten. Therefore we can not use REPLACE INTO but would use INSERT IGNORE: MariaDB [maildb]> show create table user\G *************************** 1. row *************************** Table: user Create Table: CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `userid` varchar(30) DEFAULT NULL, `passwd` varchar(30) DEFAULT NULL, `domain` varchar(30) DEFAULT NULL, `homeserver` varchar(30) DEFAULT NULL, `quotaInMiB` int(11) DEFAULT '100', `password_type` varchar(10) DEFAULT 'plain', `spamaction` enum('REJECT','ACCEPT','TAGGING') DEFAULT 'REJECT', `spampoint` decimal(5,1) DEFAULT '5.2', `virusaction` enum('REJECT','ACCEPT','REPLACE') DEFAULT 'REJECT', `keepFwdCopy` tinyint(1) DEFAULT '0', `quotaUsed` int(11) DEFAULT '0', `extRef` varchar(12) DEFAULT NULL, `mandate` int(11) DEFAULT '0', `FwdBounceCount` decimal(1,0) DEFAULT '0', `FwdActive` tinyint(1) DEFAULT '0', `lastActive` datetime DEFAULT '0000-00-00 00:00:00', `lastLogin` datetime DEFAULT '0000-00-00 00:00:00', `disabled` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `userid` (`userid`,`domain`) ) ENGINE=InnoDB AUTO_INCREMENT=1808 DEFAULT CHARSET=utf8 First Source: MariaDB [maildb]> insert into user set userid="dummyuser",domain="example.com",passwd="verysecret"; Query OK, 1 row affected (0.00 sec) Second Source: Now we get a user that does not already exist, but for which we do not have a password: MariaDB [maildb]> INSERT IGNORE user set userid="otheruser",domain="example.com",passwd="random1"; Query OK, 1 row affected (0.00 sec) Now that second source provides another user, which already exists in the database, so we do want to ignore that insert: MariaDB [maildb]> INSERT IGNORE user set userid="dummyuser",domain="example.com",passwd="otherrandom1"; ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction What happened there? In NDBCluster this works perfectly. Gallera fails, that merge skipt stopps. Google suggested replacing INSERT IGNORE by ON DUPLICATE KEY update id=id to just do a dummy update, but that fails too: MariaDB [maildb]> INSERT user set userid="dummyuser",domain="example.com",passwd="otherrandom1" ON DUPLICATE KEY UPDATE id=id; ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction Any suggestions? Benoit Panizzon -- I m p r o W a r e A G - ______________________________________________________ Zurlindenstrasse 29 Tel +41 61 826 93 07 CH-4133 Pratteln Fax +41 61 826 93 02 Schweiz Web http://www.imp.ch ______________________________________________________

3 3

[Maria-discuss] warning 1292
by Federico Razzoli 12 Dec '13

12 Dec '13

Hi! MySQL 5.6 returns a warning for wrong datatypes, with any SQL_MODE: mysql> CREATE TABLE t (c TIMESTAMP) ENGINE=InnoDB; Query OK, 0 rows affected (0,31 sec) mysql> SELECT c FROM t WHERE c = 1; Empty set, 1 warning (0,00 sec) Warning (Code 1292): Incorrect datetime value: '1' for column 'c' at row 1 Will this be done in MariaDB 10 too? Currently, no warning is issued. Federico

3 5

[Maria-discuss] New Question: Simple cluster two nodes, error.
by AskMonty KB 11 Dec '13

11 Dec '13

Hello, A new question has been asked in "MariaDB FAQ" by maximilianodipietro: -------------------------------- Hi people, i have a two nodes cluster of MariaDb, and i need some help, i have this simple script to do a solve failover, the script works like this: if the master node dies, the script kills the slave and restart it as master, and then the master as slave when the script detects that the process is down, here's the code: ---------------------------------------------------------------------------------------------------------------------------------- #!/bin/bash if [ $1 = "start" ] then PidMaria=$(ps -ef | grep wsrep_cluster | grep -v grep | awk {'print $2'}) Server2=$(nmap -v ipnodo2 | grep 3306 | tail -n1 | awk {'print $2'}) TipoPid=$(ssh ipnodo2 "ps -ef |grep mysql | grep -v grep | cut -d "=" -f 2 | cut -d "/" -f 3 | cut -d "-" -f 1 | cut -d "." -f 1") TipoPidLocal=$(ps -ef |grep mysql | grep -v grep | cut -d "=" -f 2 | cut -d "/" -f 3 | cut -d "-" -f 1 | cut -d "." -f 1) if [ -z $PidMaria ] then #sleep 20 Server2=$(nmap -v ipnodo2 | grep 3306 | tail -n1 | awk {'print $2'}) if [ -z $Server2 ] then if [ -z $TipoPid ] then if [ -z $(ssh ipnodo2 "ps -ef |grep mysql | grep -v grep " | awk {'print $2'}) ] then /usr/sbin/mysqld --wsrep_cluster_address=gcomm:// --user=mysql --wsrep_sst_auth=root:root --wsrep_provider=/usr/lib64/galera/libgalera_smm.so fi else /usr/sbin/mysqld --wsrep_cluster_address=gcomm://ipnodo2 --wsrep_sst_auth=root:root --user=mysql --wsrep_provider=/usr/lib64/galera/libgalera_smm.so fi else if [ -z $TipoPid ] then /usr/sbin/mysqld --wsrep_cluster_address=gcomm://ipnodo2 --user=mysql --wsrep_sst_auth=root:root --wsrep_provider=/usr/lib64/galera/libgalera_smm.so fi fi else if [ -z $Server2 ] then if [ -z $TipoPidLocal ] then echo "hola" else kill -9 $PidMaria /usr/sbin/mysqld --wsrep_cluster_address=gcomm:// --wsrep_sst_auth=root:root --user=mysql --wsrep_provider=/usr/lib64/galera/libgalera_smm.so fi else if [ -z $PidMaria ] then /usr/sbin/mysqld --wsrep_cluster_address=gcomm://ipnodo2 --user=mysql --wsrep_sst_auth=root:root --wsrep_provider=/usr/lib64/galera/libgalera_smm.so fi fi fi fi -------------------------------------------------------------------------------------------------------------------------------- This is the error i get in the slave output when i run the script by hand. --------------------------------------------------------------------------------------------------------------------------- + /usr/sbin/mysqld --wsrep_cluster_address=gcomm://IPMASTER --user=mysql --wsrep_sst_auth=root:root --wsrep_provider=/usr/lib64/galera/libgalera_smm.so 131211 20:04:35 [Note] WSREP: Read nil XID from storage engines, skipping position init 131211 20:04:35 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so' 131211 20:04:35 [Note] WSREP: wsrep_load(): Galera 23.2.7(r157) by Codership Oy <info(a)codership.com> loaded succesfully. 131211 20:04:35 [Note] WSREP: Found saved state: 1503cc31-6281-11e3-abfc-5bf96ca010d8:-1 131211 20:04:35 [Note] WSREP: Reusing existing '/var/lib/mysql//galera.cache'. 131211 20:04:35 [Note] WSREP: Passing config to GCS: base_host = IPLOCALHOST; base_port = 4567; cert.log_conflicts = no; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = NO; replicator.causal_read_timeout = PT30S; replicator.commit_order = 3 131211 20:04:35 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1 131211 20:04:35 [Note] WSREP: wsrep_sst_grab() 131211 20:04:35 [Note] WSREP: Start replication 131211 20:04:35 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 131211 20:04:35 [Note] WSREP: protonet asio version 0 131211 20:04:35 [Note] WSREP: backend: asio 131211 20:04:35 [Note] WSREP: GMCast version 0 131211 20:04:35 [Note] WSREP: (74e621f3-629f-11e3-a86f-0adb496b3ff6, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 131211 20:04:35 [Note] WSREP: (74e621f3-629f-11e3-a86f-0adb496b3ff6, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 131211 20:04:35 [Note] WSREP: EVS version 0 131211 20:04:35 [Note] WSREP: PC version 0 131211 20:04:35 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer '162.243.62.104:' 131211 20:04:35 [Note] WSREP: declaring 15031b4b-6281-11e3-9ad7-8a59b1f0cba0 stable 131211 20:04:35 [Note] WSREP: view(view_id(NON_PRIM,15031b4b-6281-11e3-9ad7-8a59b1f0cba0,8) memb { 15031b4b-6281-11e3-9ad7-8a59b1f0cba0, 74e621f3-629f-11e3-a86f-0adb496b3ff6, } joined { } left { } partitioned { 18299990-6281-11e3-a268-975810126780, a6d47aea-6281-11e3-b007-16991d53e685, d52af178-6281-11e3-871d-03c1e15f1ac4, }) 131211 20:05:05 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view: 110 (Connection timed out) at gcomm/src/pc.cpp:connect():139 131211 20:05:05 [ERROR] WSREP: gcs/src/gcs_core.c:gcs_core_open():195: Failed to open backend connection: -110 (Connection timed out) 131211 20:05:05 [ERROR] WSREP: gcs/src/gcs.c:gcs_open():1289: Failed to open channel 'my_wsrep_cluster' at 'gcomm://IPMASTER': -110 (Connection timed out) 131211 20:05:05 [ERROR] WSREP: gcs connect failed: Connection timed out 131211 20:05:05 [ERROR] WSREP: wsrep::connect() failed: 6 131211 20:05:05 [ERROR] Aborting 131211 20:05:05 [Note] WSREP: Service disconnected. 131211 20:05:06 [Note] WSREP: Some threads may fail to exit. 131211 20:05:06 [Note] /usr/sbin/mysqld: Shutdown complete ------------------------------------------------------------------------------------------------ When the script starts the master from the crontab, the PID is already up, and i can access to the mariadb, but i cant write any database, only list the databases. [root@xxx ~]# mysql -uxxx -pxxxx Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 24 Server version: 5.5.33a-MariaDB Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> create database TESTEOKILL2; ERROR 1047 (08S01): Unknown command MariaDB [(none)]> Any idea?. Thanks in advance! -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/simple-cluster-two-nodes-error/

3 2

[Maria-discuss] INFORMATION_SCHEMA.PROCESSLIST values of PROGRESS, STAGE and STAGE_MAX
by Jean Weisbuch 11 Dec '13

11 Dec '13

Hello, Lately, i did modify mytop (https://mariadb.atlassian.net/browse/MDEV-4476) to use INFORMATION_SCHEMA.PROCESSLIST instead of SHOW PROCESSLIST (when available) to gather running processes informations as it's more flexible and has more informations but the value of the PROGRESS column on both is different, so i wondered if the PROGRESS value on SHOW PROCESSLIST was using a simple formula like this one or something more complex : (STAGE-1)/MAX_STAGE + {decimal progress on the actual stage}/MAX_STAGE There seems to be a broken alinea about that on the KB page of the PROCESSLIST : https://mariadb.com/kb/en/show-processlist/ In any case, what would be the best way to go with mytop, add columns with the actual_stage/max_stage or only keep the progress of the actual stage or only the "total" progress using the formula previously shown? Putting an option and keystroke to show/hide these columns could be another solution as these values might be of use on only "rare" cases depending on the workload. Regards.

3 3

[Maria-discuss] New Question: mariadb run failed on Centos 6.4
by AskMonty KB 09 Dec '13

09 Dec '13

Hello, A new question has been asked in "MariaDB community" by kimbg: -------------------------------- my server installed centos 6.4(32bit) i'll source compile maria db 5.1.67/5.5.34 and yum install. but, i looking error message mysql_install_db. how fixed? maria source version : 5.1.67/5.1.62 5.5.34 (https://downloads.mariadb.org/interstitial/mariadb-5.1.67/kvm-tarbake-jaunt…) compile option [root@localhost var]# ./configure --prefix=/usr/local/mysql --with-extra-charsets=all --with-readline mysql_install_db command [root@localhost ~]# /usr/local/mysql/bin/mysql_install_db Installing MariaDB/MySQL system tables... 131209 11:07:26 [ERROR] /usr/local/mysql/libexec/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 131209 11:07:26 [ERROR] Aborting Installation of system tables failed! Examine the logs in /usr/local/mysql/var for more information. You can try to start the mysqld daemon with: shell> /usr/local/mysql/libexec/mysqld --skip-grant & and use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/local/mysql/bin/mysql -u root mysql mysql> show tables Try 'mysqld --help' if you have problems with paths. Using --general-log gives you a log in /usr/local/mysql/var that may be helpful. The latest information about mysql_install_db is available at http://kb.askmonty.org/v/installing-system-tables-mysql_install_db. MariaDB is hosted on launchpad; You can find the latest source and email lists at http://launchpad.net/maria Please check all of the above before mailing us! And remember, if you do mail us, you should use the /usr/local/mysql/bin/mysqlbug script! [root@localhost ~]# /usr/local/mysql/libexec/mysqld --skip-grant & [1] 1402 [root@localhost ~]# 131209 11:20:11 [ERROR] /usr/local/mysql/libexec/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 131209 11:20:11 [ERROR] Aborting [1]+ Exit 1 /usr/local/mysql/libexec/mysqld --skip-grant [root@localhost ~]# cat /usr/local/mysql/var/localhost.localdomain.err 131209 11:08:40 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var 131209 11:08:40 [ERROR] /usr/local/mysql/libexec/mysqld: ambiguous option '--o' (old-alter-table, optimizer_switch) 131209 11:08:40 [ERROR] Aborting 131209 11:08:40 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended [root@localhost ~]# -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-run-failed-on-centos-64/

1 0

[Maria-discuss] New Question: CMAKE settings to include TokuDB in 5.5.34
by AskMonty KB 02 Dec '13

02 Dec '13

Hello, A new question has been asked in "TokuDB" by markdiener: -------------------------------- I am trying to build 5.5.34 from source on Linux x64 (Fedora 14). I was looking at the readme files and could not find anything about building 5.5.34 from source and including TokuDB (which has the source code in the /storage/TokuDB/ directory) into the build. I was looking for something like: -DWITH_TOKUDB_STORAGE_ENGINE=ON but did not stumble across anything. Anybody got some ideas? Here is my build script: rm -f CMakeCache.txt make clean cmake \ -DCMAKE_BUILD_TYPE=Release \ -DCMAKE_INSTALL_PREFIX=/mysql \ -DENABLED_PROFILING=OFF \ -DENABLE_DEBUG_SYNC=ON \ -DENABLE_GCOV=OFF \ -DINSTALL_LAYOUT=STANDALONE \ -DMYSQL_DATADIR=/mysql/data \ -DINSTALL_INCLUDEDIR=include/mysql \ -DINSTALL_UNIX_ADDRDIR=/mysql/mysql.sock \ -DUSE_ARIA_FOR_TMP_TABLES=ON \ -DWITHOUT_PBXT_STORAGE_ENGINE=ON \ -DWITHOUT_SERVER=OFF \ -DWITH_ARCHIVE_STORAGE_ENGINE=OFF \ -DWITH_EMBEDDED_SERVER=OFF \ -DWITH_FAST_MUTEXES=OFF \ -DWITH_FEDERATEDX_STORAGE_ENGINE=OFF \ -DWITH_FEEDBACK=OFF \ -DWITH_LIBWRAP=OFF \ -DWITH_PIC=ON \ -DWITH_PARTITION_STORAGE_ENGINE=OFF \ -DWITH_PERFSCHEMA_STORAGE_ENGINE=ON \ -DWITH_SPHINX_STORAGE_ENGINE=OFF \ -DWITH_SSL=OFF \ -DWITH_UNIT_TESTS=OFF \ -DWITH_VALGRIND=OFF \ -DWITH_XTRADB_STORAGE_ENGINE=ON \ -DWITHOUT_OQGRAPH=ON \ -DWITH_ZLIB=bundled make (now compiling your program) -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/cmake-settings-to-include-tokudb-in-5534/

1 0

[Maria-discuss] Fw: [Website feedback] galera mariadb compiled using msvc
by Yann Nayn 02 Dec '13

02 Dec '13

On Monday, December 2, 2013 11:46 AM, Yann Nayn <yann.nayn(a)yahoo.fr> wrote: >Yes, we're reading mariadb mailing list ... I realized that while reading mailing lists archives . galera is now running using mysqldump as the wsrep sst backup method I didnt dig the details yet and will compile percona xtrabackup next Im tested the deployment with two nodes(...) and still find bootstrapping "tiedeous". I will go with basic sql manipulations in the next coming hours I just tested create database on one node , the database is visible from the other node . I might provide soon msi installation packages to ease testing https://github.com/YannNayn

1 0

[Maria-discuss] Mroonga storage engine is merged into MariaDB 10.0
by kentoku 01 Dec '13

01 Dec '13

Hi! We just pushed Mroonga storage engine into "lp:~mroonga/maria/mroonga". Mroonga is a fulltext/geo search storage engine. Would you please bundle Mroonga into MariaDB? Mroonga's strong points are - High-speed updating with multiple thread searching. (lock-free model) - Support CJK languages. - Support wrapper mode. Wrapper mode works adding fulltext/geo index for other storage engines. Mroonga is tested on the following 64bit OS. Debian GNU/Linux squeeze Debian GNU/Linux wheezy Debian GNU/Linux jessie Debian GNU/Linux sid Ubuntu 10.04 LTS Lucid Lynx Ubuntu 12.04 Precise Pangolin Ubuntu 12.10 Quantal Quetzal Ubuntu 13.04 Raring Ringtail Ubuntu 13.10 Saucy Salamander CentOS 5 CentOS 6 Fedora 19 Mac OS X Windows 7 Mroonga documents (English & Japanease) are available on http://mroonga.org/docs/index.html Test command is the followings. The command calls mysql-test-run.plinternally. > ./storage/mroonga/test/run-sql-test.sh Thanks, Kentoku

6 6

[Maria-discuss] Tr : mariadb galera msvc
by Yann Nayn 30 Nov '13

30 Nov '13

>Le Mercredi 27 novembre 2013 9h33, Colin Charles <byte(a)mariadb.com> a écrit : >does this also include the galera library? or is this just straight mariadb? >Colin Charles, Chief Evangelist >MariaDB | t: +6-012-204-3201 | Skype: colincharles This is not intended to be left undone half the way ... Right now most of galera tests are passing and galera_smm.dll is produced. a more detailed instruction set can be found at: https://github.com/YannNayn/galera-build-msvc/blob/master/build.bat the C89 features have been rewritten Next a pre production deployment is going to be tested Have a Happy ThanksGiving Day when relevant

2 6

[Maria-discuss] New Question: Mariadb refuses to stay confined to install directory
by AskMonty KB 29 Nov '13

29 Nov '13

Hello, A new question has been asked in "Compiling MariaDB From Source" by openiduser33: -------------------------------- I've been struggling with this off and on for weeks. I need a contained MariaDB install running in the home directory. My most recent attempt (and what would be my preferred method) is compiling from source. No matter what I do though MariaDB insists on trying to create /var/run/mysqld/mysqld.sock on every run and fails. I compiled it from source with --prefix pointing to my home directory. I ran mysql with --basedir and --defaults-file. The defaults-file I used contains the location of my mysql.sock file in the home directory but MariaDB will not use it. I even tried recompiling with --exec-prefix as per the MySQL 5.5 documentation but this screws the entire installation up, causing MariaDB to recreate the entire prefix path from root underneath src/efix=/ where I'm storing the source while I install. Here is my configure options: ##./configure --prefix=/home/user/web/servers/mariadb --enable-assembler \ --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables \ --with-plugin-maria --with-aria-tmp-tables --without-plugin-innodb_plugin --without-plugin=tokudb \ --with-mysqld-ldflags=-static --with-client-ldflags=-static --with-readline \ --with-ssl --with-plugins=max-no-ndb --with-embedded-server --with-libevent \ --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static \ --with-zlib-dir=bundled --enable-local-infile## And here is what happens when I try to launch MariaDB: ##$ bin/mysqld_safe --basedir=/home/user/web/servers/mariadb --defaults-file=/home/user/web/servers/mariadb/my.cnf 131128 16:20:20 mysqld_safe Logging to '/home/user/web/servers/mariadb/log/error.log'. mkdir: cannot create directory ‘/var/run/mysqld’: Permission denied Fatal error Can't create database directory '/var/run/mysqld/mysqld.sock'## My socket file is specific in the given my.cnf file as /home/user/web/servers/mariadb/run/mysql.sock No matter what I do I can't get MariaDB to behave and run in user land. What am I doing wrong? I've tried the Linux binaries with slightly more success but I still felt like I was fighting the server to get it to read files from the correct location. I'd like to have it compiled from source though and it *should* be easier this way since I can specify a prefix. How can I get MariaDB to follow the set prefix for all files? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-refuses-to-stay-confined-to-install-direct…

1 0

[Maria-discuss] plans for MDL
by MARK CALLAGHAN 28 Nov '13

28 Nov '13

Do you have any plans for MDL in MariaDB 10+ that might do something better for workloads that need to do some DDL concurrent with some long-running SELECT statements? https://www.facebook.com/MySQLatFacebook/posts/10151939557456696 -- Mark Callaghan mdcallag(a)gmail.com

2 1

[Maria-discuss] New Question: Build fails at "Linking CXX executable tdb-recover"
by AskMonty KB 26 Nov '13

26 Nov '13

Hello, A new question has been asked in "Compiling MariaDB From Source" by openiduser33: -------------------------------- I'm trying to compile MariaDB on Ubuntu 13.10. I've followed all the directions here on the KB in regards to compiling. I meet all the package requirements listed. This is the output where make fails: Linking CXX executable tdb-recover cd /home/chris/web/servers/mariadb/src/mariadb-5.5.34/storage/tokudb/ft-index/ft && /usr/bin/cmake -E cmake_link_script CMakeFiles/tdb-recover.dir/link.txt --verbose=1 /usr/bin/c++ -std=c++11 -Wall -Werror -Wcast-align -Wshadow -Wmissing-format-attribute -Wpointer-arith -Wmissing-declarations -Wno-missing-noreturn -Wextra -Wno-error=strict-overflow -Wpacked -fno-exceptions -fno-rtti -Wno-error=missing-format-attribute -Wmissing-format-attribute -Wlogical-op -Wtrampolines -Wswitch -Winit-self -Wstrict-null-sentinel -Wno-missing-field-initializers -Wall -Wno-unused-parameter -fno-implicit-templates -fno-exceptions -fno-rtti -fimplicit-templates -flto -fuse-linker-plugin -O2 -g -DNDEBUG -DDBUG_OFF -g -O3 -UNDEBUG -g -fuse-linker-plugin -Wno-error=strict-overflow CMakeFiles/tdb-recover.dir/tdb-recover.cc.o -o tdb-recover -lpthread libft_static.a ../util/libutil_static.a ../../../../zlib/libzlib.a .././xz/lib/liblzma.a ../portability/libtokuportability_static.a -lpthread -ldl -lrt /home/chris/web/servers/mariadb/src/mariadb-5.5.34/storage/tokudb/ft-index/ft/ft-ops.cc: In function ‘ft_leaf_run_gc’: /home/chris/web/servers/mariadb/src/mariadb-5.5.34/storage/tokudb/ft-index/ft/ft-ops.cc:2261:26: error: ‘leaf_entry’ may be used uninitialized in this function [-Werror=maybe-uninitialized] if (leaf_entry->type != LE_MVCC) { ^ lto1: all warnings being treated as errors lto-wrapper: /usr/bin/g++-4.8.real returned 1 exit status /usr/bin/ld.bfd.real: lto-wrapper failed collect2: error: ld returned 1 exit status Pastebin for easier reading: http://pastebin.com/wGzHpD2p I'm using the default compile option list posted here: https://mariadb.com/kb/en/generic-build-instructions/ The only thing I've changed is the prefix. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/build-fails-at-linking-cxx-executable-tdb-recover/

1 0

[Maria-discuss] New Question: Link MariaDB Client Library for C with specific external zlib and openssl
by AskMonty KB 26 Nov '13

26 Nov '13

Hello, A new question has been asked in "MariaDB Client Library for C" by trsystran: -------------------------------- Hi, I am trying to link the mariadb client library with zlib and openssl which are neither embedded in mariadb (for zlib), nor the one available on the system: I want to force cmake to use zlib and openssl from a given path. How can I do that? Is there another way than creating my own FindZLIB.cmake and force it via CMAKE_MODULE_PATH ? Thank you. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/link-mariadb-client-library-for-c-with-specific-ex…

1 0

[Maria-discuss] New Question: SphinxSE gone from MariaDB 10.0.6?
by AskMonty KB 26 Nov '13

26 Nov '13

Hello, A new question has been asked in "Development" by robertmedeksza: -------------------------------- I recently ran apt-get upgrade and this updated my MariaDB 10.0.4 to 10.0.6. After the update the SphinxSE engine is gone and my Sphinx tables no longer function. How can I get SphinxSE back and can this be fixed in 10.0.7? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/sphinxse-gone-from-mariadb-1006/

1 0

[Maria-discuss] mariadb galera msvc
by Yann Nayn 25 Nov '13

25 Nov '13

Hi this is my first post to this list I just setup a github repository with version 5.5.33.a compiling version using msvc 1600 at: https://github.com/YannNayn/mariadb-galera-msvc any tests and suggestions are welcome

2 4

[Maria-discuss] Table Change notification to all Clients?
by SARTrack Admin 21 Nov '13

21 Nov '13

I develop a Windows application for Search and Rescue (using Delphi and MyDAC components), which gets a stream of "APRS" data packets, up to 10 per second. These are saved in the SQL database, but all Clients which are connected to the database MUST be notified when a Table change has occured, so that they then can update their internal tables. Which in turn update their Maps (GPS location of moving items) and other data, which MUST be up-to-date. Currently I am having all Clients polling the database every 5 seconds, which really sucks, and causes all kinds of other problems. Is there any chance that MariaDB will have some kind of Client Notification system when a Table has changed, as some other SQL databases seem to have? Thanks Bart Kindt SARTrack Limited http://www.sartrack.co.nz/ -- SARTrack Developer and CEO

6 5

[Maria-discuss] MariaDB 5.5.34 now available
by Daniel Bartholomew 21 Nov '13

21 Nov '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.34. This is a Stable (GA) maintenance (bug fix) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.34 - Release Notes: https://mariadb.com/kb/en/mariadb-5534-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-5534-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.34 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 - - - - - - - - - - - - - - - - - - - - - - - - - SkySQL has had several MariaDB focused Webinars recently, including one about MariaDB 10.0 that was held earlier today. It and the other MariaDB webinars are (or will be, in the case of the one held today) available on an on-demand basis at: - http://www.skysql.com/why-skysql/webinars/ They are also planning several more MariaDB-focused webinars that will be held over the comming months. Details available at the above link. - - New MariaDB Book - - - - - - - - - - - - - - - - - - - - - - - - - A new MariaDB book has been released! Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB, no previous MariaDB or MySQL experience required. It's available from several booksellers in both paperback and DRM-free epub, mobi and pdf formats. See the PacktPub website for details: - http://www.packtpub.com/getting-started-with-mariadb/book - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

4 5

[Maria-discuss] MariaDB 10.0.6 Beta now available
by Daniel Bartholomew 18 Nov '13

18 Nov '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.6. This is a Beta release. It includes new features and bug fixes. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0 Beta Blog Posts - https://blog.mariadb.org/mariadb-10-0-6-now-available/ - https://blog.mariadb.org/mariadb-10-0-beta-launched-an-important-milestone/ MariaDB 10.0.6 Beta - Release Notes: https://mariadb.com/kb/en/mariadb-1006-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1006-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.6 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/ - - New MariaDB Book - - - - - - - - - - - - - - - - - - - - - - - - - A new MariaDB book has been released! Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB, no previous MariaDB or MySQL experience required. It's available from several booksellers in both paperback and DRM-free epub, mobi and pdf. See the PacktPub website for details: - http://www.packtpub.com/getting-started-with-mariadb/book - - 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 (my.ini on Windows) 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 MariaDB, please see our "contributing" and "donations" pages. We also have merchandise available in a cafepress store. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] Maria DB 10.0 Roles Usage
by Adam Scott 13 Nov '13

13 Nov '13

Roles are supported according to ( https://blog.mariadb.org/mariadb-10-0-beta-launched-an-important-milestone/) So the following commands worked: create role read_only;grant select on example.* to read_only;grant usage on example.* to read_only; grant select on example.* to app_report@'localhost';When i logged in as app_report, show databases did not show the example database. And selects against tables in the example database did not work. What am I missing? Thanks, Adam C. Scott

4 4

[Maria-discuss] MySQL Workbench 6 & MariaDB
by Colin Charles 12 Nov '13

12 Nov '13

Hi! I now notice that MySQL Workbench connecting to MariaDB 10.0.5 will tell you that the server version 10 is not supported. Is this a bug worthy of reporting to Oracle upstream at bugs.mysql.com or do we just list it as an incompatibility here: https://mariadb.com/kb/en/mariadb-vs-mysql-compatibility/ Would be interested in hearing your thoughts on this matter cheers, -colin -- Colin Charles, Chief Evangelist MariaDB | t: +6-012-204-3201 | Skype: colincharles

2 2

[Maria-discuss] Is OQGRAPH back in 10.0.5?
by Colin Charles 11 Nov '13

11 Nov '13

Hi! I noticed that ha_oqgraph.so exists in /usr/lib64/mysql/plugin on the 10.0.5 packages. So I just installed it, and it shows up in SHOW ENGINES output. I tried creating a table, and it worked (confirmed via output in SHOW TABLE STATUS) So, is this something we are planning on shipping in 10.0? This is version 2 of the plugin and it is now marked to be Beta quality (from INFORMATION_SCHEMA.PLUGINS) If we are shipping this in 10.0, we really need to improve the documentation around it in the Knowledgebase cheers, -colin -- Colin Charles, Chief Evangelist MariaDB | t: +6-012-204-3201 | Skype: colincharles

1 0

[Maria-discuss] New Question: mariadb RAM usage
by AskMonty KB 08 Nov '13

08 Nov '13

Hello, A new question has been asked in "MariaDB Performance & Advanced Configurations" by ferreirah: -------------------------------- When you bundle your app with mysql or mariadb, you don't want mysql or mariadb to devour all your RAM, especially if the database is installed on a desktop operating system. I haven't recently tried out mysql or mariadb, but I was wondering about the minimum memory required on windows. I sent a question to mysql and they told me it only requires 1 MB RAM minimum. At that stage they still supported windows 2000 and windows xp, which isn't supported any more. I remember installing mysql on windows xp and you could configure it through a wizard. You could either set it to dedicated server, shared server or developer install. I suppose developer install will use the least amount of RAM. How much RAM would mariadb use with a developer install if you had to install it on windows vista/7/8/8.1? Does it matter which engine you are using? XtraDB? Thanks H.F. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-ram-usage/

1 0

[Maria-discuss] New Question: licencing of mariadb and mysql dot net connector
by AskMonty KB 08 Nov '13

08 Nov '13

Hello, A new question has been asked in "Client libraries" by ferreirah: -------------------------------- Hi I agree with one of the previous posts that licencing is such a tricky aspect of IT. I read in previous posts that when using mariadb with the odbc framework that you can distribute both the odbc connector and mariadb with your closed source commercial application. It said in the post if you use a framework to access the database then both the connector and mariadb are free for commercial use. What about dot net? Dot net is a framework through which you can access mariadb? Does this mean that both the dot net connector as well as mariadb are free for closed source commercial use? I suppose the downside is that you can't use any mariadb specific features if you are using the mysql connector? Thanks H.F. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/licencing-of-mariadb-and-mysql-dot-net-connector/

1 0

[Maria-discuss] MariaDB 10.0.5 Beta Now Available
by Daniel Bartholomew 07 Nov '13

07 Nov '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.5. This is a Beta release. It includes new features and bug fixes. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.5 Beta Blog Post - https://blog.mariadb.org/mariadb-10-0-beta-launched-an-important-milestone/ MariaDB 10.0.5 Beta - Release Notes: https://mariadb.com/kb/en/mariadb-1005-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1005-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.5 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/ - - New MariaDB Book - - - - - - - - - - - - - - - - - - - - - - - - - A new MariaDB book has been released! Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB, no previous MariaDB or MySQL experience required. It's available from several booksellers in both paperback and DRM-free epub, mobi and pdf. See the PacktPub website for details: - http://www.packtpub.com/getting-started-with-mariadb/book - - 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 (my.ini on Windows) 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 MariaDB, please see our "contributing" and "donations" pages. We also have merchandise available in a cafepress store. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] Downloads page should be updated soon.
by Peter Laursen 06 Nov '13

06 Nov '13

(to whom it concerns) *B*log post at https://mariadb.com/blog/mariadb-100-beta-launched-important-milestoneurges to download 10.05 but downlods page https://downloads.mariadb.org/ give access to 10.0.4 only. Thanks! (I could not comment in the blog as it requires authentication from services where I don't have an account. Why is Google/gmail not an option here BTW?) -- Peter -- Webyog

2 1

[Maria-discuss] New Question: Client for Mysql - zeroDateTimeBehavior=convertToNull key
by AskMonty KB 05 Nov '13

05 Nov '13

Hello, A new question has been asked in "MariaDB Java Client" by netanel: -------------------------------- Hi, Does it possible to use the "zeroDateTimeBehavior=convertToNull" to the jdbc url connection string like in the original mysql driver? Is there a workaround? Netanel -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/client-for-mysql-zerodatetimebehaviorconverttonull…

1 0

[Maria-discuss] New Question: XtraDB and Workbench CE compatibility?
by AskMonty KB 04 Nov '13

04 Nov '13

Hello, A new question has been asked in "XtraDB and InnoDB" by ferreirah: -------------------------------- Hi I read here that there are some issues with Aria and Workbench? Are there any issues with XtraDB and Workbench CE? People have mentioned HeidiSQL but can it do diagrams of your table structure? Will HeidiSQL work with XtraDB? Any other free for commercial use, alternatives? Thanks H.F. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/xtradb-and-workbench-ce-compatibility/

1 0

[Maria-discuss] New Question: XtraDB and ODBC compatibility?
by AskMonty KB 04 Nov '13

04 Nov '13

Hello, A new question has been asked in "XtraDB and InnoDB" by ferreirah: -------------------------------- Hi How compatible is XtraDB with the myodbc driver? Any issues that you know about? Thanks H.F. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/xtradb-and-odbc-compatibility/

1 0

[Maria-discuss] New Question: mysql_secure_installation does not work with socket locations other than /tmp/mysql.sock
by AskMonty KB 03 Nov '13

03 Nov '13

Hello, A new question has been asked in "MariaDB community" by openiduser32: -------------------------------- The only information I could find on this is a MySQL bug report dating back to 2009: http://bugs.mysql.com/bug.php?id=46842 I've tried passing the basedir to mysql_secure_installation as well as --defaults-file and --socket but it refuses to look anywhere but /tmp/mysql.sock. I'm running MariaDB in userland and except for this script everything is working fine. My socket file is in ~/mariadb/mysql/run/mysql.sock. Mediawiki has no problem connecting to it using localhost when it's set as the default socket in php.ini. I have network connections disabled in my.cnf to only allowed Unix socket connections. I've tried to fix it myself but I've exhausted my command line scripting knowledge. Can someone please help me get this script working again? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mysql_secure_installation-does-not-work-with-socke…

1 0

[Maria-discuss] Problem when all galera nodes are down
by Guillaume Hilt 29 Oct '13

29 Oct '13

Hi again, We're running 3 galera mariadb 5.5 servers on Ubuntu 12.04 AMD 64 server. With one drbd server on another host. We have a specific case in our dev environment. All the hosts are stopped at night. So when they all boot up at the same time in the morning, each server is looking for another one up. Since there are no other server up, they refuse to start. I have to edit the wsrep_cluster_address variable on one server to set it back to "gcomm://" and start it. Then start the 2 others servers and once everything is up, put back the wsrep_cluster_address variable to its previous value and restart the server. Galera isn't prepared having all its nodes down ? Thanks, -- Guillaume Hilt

2 2

[Maria-discuss] MariaDB 10 compatibility with MySQL
by Colin Charles 29 Oct '13

29 Oct '13

Picked from the debian-mysql discussion list: > Separately has your company considered MariaDB 10.0? Once we get the 5.5 line uploaded I'd like to package 10.0. Providing 10.0 is also compatible with MySQL and wouldn't require any apps to be updated I'm sure we could consider it. I would have difficulty getting developer resources to modify existing apps though. I think the above is very important to always remember for real world users... -- Colin Charles, Chief Evangelist MariaDB | t: +6-012-204-3201 | Skype: colincharles

1 0

Re: [Maria-discuss] crashed tables (mariadb-5.5.33a)
by Reindl Harald 27 Oct '13

27 Oct '13

yes they are because *any* tables are created this way for years also in production for around 10000 tables and that is why this scares me to replace MySQL with MariaDB for now Am 23.10.2013 17:38, schrieb Jocelyn Fournier: > I suspect the DELAY_KEY_WRITE to be guilty in your case, are all the crashed table created with DELAY_KEY_WRITE=1 ? > > Le 23/10/2013 17:24, Reindl Harald a écrit : >> this seems to happen daily on different tables of the same type >> which in fact have one record and not for other tables because >> all the *_meta are from the same self developed CMS >> >> rh_meta | CREATE TABLE `rh_meta` ( >> `mid` mediumint(7) unsigned NOT NULL AUTO_INCREMENT, >> `mlastcheck` int(10) unsigned NOT NULL DEFAULT '0', >> `mcounter` mediumint(7) unsigned NOT NULL DEFAULT '0', >> `mecardcount` mediumint(7) unsigned NOT NULL DEFAULT '0', >> `mheisenews` text COLLATE latin1_german1_ci NOT NULL, >> `mheisetimestamp` int(10) unsigned NOT NULL DEFAULT '0', >> `mnewsticker_timeout` varchar(255) COLLATE latin1_german1_ci NOT NULL DEFAULT '', >> `mnewsticker_wait` varchar(255) COLLATE latin1_german1_ci NOT NULL DEFAULT '', >> `mstartseite` text COLLATE latin1_german1_ci NOT NULL, >> `mstartseite_en` text COLLATE latin1_german1_ci NOT NULL, >> `mstartseite_link` varchar(255) COLLATE latin1_german1_ci NOT NULL DEFAULT '', >> `pz_start1_titel` text COLLATE latin1_german1_ci NOT NULL, >> `pz_start2_titel` text COLLATE latin1_german1_ci NOT NULL, >> `pz_start3_titel` text COLLATE latin1_german1_ci NOT NULL, >> `pz_start4_titel` text COLLATE latin1_german1_ci NOT NULL, >> `pz_start1_bild` text COLLATE latin1_german1_ci NOT NULL, >> `pz_start2_bild` text COLLATE latin1_german1_ci NOT NULL, >> `pz_start3_bild` text COLLATE latin1_german1_ci NOT NULL, >> `pz_start4_bild` text COLLATE latin1_german1_ci NOT NULL, >> `pz_start1_text` text COLLATE latin1_german1_ci NOT NULL, >> `pz_start2_text` text COLLATE latin1_german1_ci NOT NULL, >> `pz_start3_text` text COLLATE latin1_german1_ci NOT NULL, >> `pz_start4_text` text COLLATE latin1_german1_ci NOT NULL, >> `pz_start_metatext` text COLLATE latin1_german1_ci NOT NULL, >> `mfailedlogins` mediumint(7) unsigned NOT NULL DEFAULT '0', >> `mlocktime` int(10) unsigned NOT NULL DEFAULT '0', >> `m_trans_cleanup` int(10) unsigned NOT NULL DEFAULT '0', >> `m_trans_move` tinyint(1) unsigned NOT NULL DEFAULT '0', >> `m_trans_replace` tinyint(1) unsigned NOT NULL DEFAULT '0', >> PRIMARY KEY (`mid`) >> ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci PACK_KEYS=0 DELAY_KEY_WRITE=1 >> >> 131023 10:37:54 [Note] Slave: connected to master 'replication@*****:3306',replication resumed in log 'bin.000060' >> at position 424439 >> 131023 11:30:02 [ERROR] mysqld: Table './hvb/andersentag_meta' is marked as crashed and should be repaired >> 131023 11:30:02 [Warning] Checking table: './hvb/andersentag_meta' >> 131023 11:30:02 [ERROR] hvb.andersentag_meta: 1 client is using or hasn't closed the table properly >> 131023 11:30:03 [ERROR] mysqld: Table './hvb/buchwoche_meta' is marked as crashed and should be repaired >> 131023 11:30:03 [Warning] Checking table: './hvb/buchwoche_meta' >> 131023 11:30:03 [ERROR] hvb.buchwoche_meta: 1 client is using or hasn't closed the table properly >> >> Am 22.10.2013 15:43, schrieb Reindl Harald: >>> i see randomly such messages in the mysql_error.log >>> there was no hard shutdown or killed process and so i am somehow out of ideas >>> >>> 131022 11:30:05 [ERROR] mysqld: Table './musikarchiv/rh_meta' is marked as crashed and should be repaired >>> 131022 11:30:05 [Warning] Checking table: './musikarchiv/rh_meta' >>> >>> the only time i can remember such issues was http://lists.mysql.com/mysql/226361 >>> but in the current situation i see nothing similar in the logs or any hint >>> >>> there are two instances (port 3306 / 3307) with to different systemd-units and >>> configurations to replicate my home-machine over openvpn to the office and >>> my office-workstation at home >>> >>> below the whole configuration, logfile and build-options while MySQL 5.5.34 >>> in production is using practically the same RPM-SPEC without issues >>> ________________________________________________________________________________________________ >>> >>> [root@srv-rhsoft:~]$ cat /etc/my.cnf >>> [mysqld] >>> socket = /var/lib/mysql/mysql.sock >>> datadir = /mnt/data/db/mysql-srv >>> pid-file = /mnt/data/db/mysql-srv/mysql.pid >>> tmpdir = /tmp >>> character-set-server = latin1 >>> collation-server = latin1_german1_ci >>> default-time-zone = "Europe/Vienna" >>> default-storage-engine = myisam >>> lower_case_table_names = 1 >>> log-error = /var/log/mysql_error.log >>> log_warnings = 1 >>> slow_query_log = 1 >>> slow_query_log_file = /var/log/mysql_slow_query.log >>> long_query_time = 1 >>> log_queries_not_using_indexes = 0 >>> general_log = 0 >>> general_log_file = /var/log/mysql_query.log >>> port = 3306 >>> old_passwords = 0 >>> local-infile = 0 >>> sql-mode = STRICT_ALL_TABLES >>> >>> ssl-ca = /etc/mysql-ssl/ca.crt >>> ssl-cert = /etc/mysql-ssl/server.pem >>> ssl-key = /etc/mysql-ssl/server.pem >>> ssl-cipher = >>> EECDH+ECDSA+AESGCM:EECDH+aRSA+AESGCM:EECDH+ECDSA+SHA384:EECDH+ECDSA+SHA256:EECDH+aRSA+SHA384:EECDH+aRSA+SHA256:EECDH:EDH+aRSA:HIGH:!3DES:!aNULL:!DSS:!eNULL:!EXP:!MD5:!PSK:!RC4:!SRP:!SSLv2:!LOW:!MEDIUM >>> >>> delay-key-write = ALL >>> concurrent_insert = 2 >>> open-files-limit = 500000 >>> myisam-recover-options = "FORCE" >>> myisam_use_mmap = 1 >>> performance_schema = 0 >>> >>> wait_timeout = 86400 >>> interactive_timeout = 86400 >>> >>> max_allowed_packet = 250M >>> max_connections = 300 >>> max_tmp_tables = 100 >>> max_connect_errors = 200 >>> max_delayed_threads = 30 >>> >>> flush_time = 0 >>> >>> query_cache_limit = 150K >>> query_cache_min_res_unit = 2K >>> query_cache_size = 128M >>> query_cache_type = 1 >>> >>> table_cache = 5000 >>> table_definition_cache = 512 >>> thread_cache_size = 100 >>> tmp_table_size = 256M >>> max_heap_table_size = 256M >>> >>> key_buffer_size = 128M >>> sort_buffer_size = 128K >>> myisam_sort_buffer_size = 15M >>> join_buffer_size = 1M >>> preload_buffer_size = 128K >>> read_buffer_size = 128K >>> read_rnd_buffer_size = 128K >>> >>> innodb_buffer_pool_size = 64M >>> innodb_buffer_pool_instances = 1 >>> innodb_purge_threads = 1 >>> innodb_max_purge_lag = 200000 >>> innodb_max_dirty_pages_pct = 60 >>> innodb_additional_mem_pool_size = 3M >>> innodb_log_file_size = 80M >>> innodb_log_buffer_size = 2M >>> innodb_thread_concurrency = 0 >>> innodb_thread_sleep_delay = 10 >>> innodb_flush_log_at_trx_commit = 2 >>> innodb_support_xa = 1 >>> innodb_lock_wait_timeout = 50 >>> innodb_table_locks = 0 >>> innodb_checksums = 0 >>> innodb_file_format = barracuda >>> innodb_file_per_table = 1 >>> innodb_open_files = 300 >>> innodb_io_capacity = 600 >>> innodb_read_io_threads = 4 >>> innodb_write_io_threads = 4 >>> innodb_adaptive_flushing_method = keep_average >>> innodb_flush_method = ALL_O_DIRECT >>> transaction-isolation = READ-COMMITTED >>> >>> server-id = 1 >>> log-bin = /mnt/data/db/mysql-srv/bin.log >>> log-bin-index = /mnt/data/db/mysql-srv/bin.index >>> expire_logs_days = 21 >>> max_binlog_size = 256M >>> binlog-format = ROW >>> binlog_stmt_cache_size = 256K >>> binlog_cache_size = 256K >>> sync_binlog = 30 >>> >>> low-priority-updates >>> skip-federated >>> skip-symbolic-links >>> skip-name-resolve >>> safe-user-create >>> skip-partition >>> slave_compressed_protocol >>> >>> [mariadb] >>> aria_pagecache_buffer_size = 32m >>> aria_sort_buffer_size = 32m >>> aria_page_checksum = 0 >>> key_cache_segments = 8 >>> thread_handling = one-thread-per-connection >>> thread_pool_idle_timeout = 60 >>> >>> [client] >>> socket = /var/lib/mysql/mysql.sock >>> port = 3306 >>> user = root >>> ssl-ca = /etc/mysql-ssl/ca.crt >>> ssl-cert = /etc/mysql-ssl/client.pem >>> ssl-key = /etc/mysql-ssl/client.pem >>> ssl-cipher = >>> EECDH+ECDSA+AESGCM:EECDH+aRSA+AESGCM:EECDH+ECDSA+SHA384:EECDH+ECDSA+SHA256:EECDH+aRSA+SHA384:EECDH+aRSA+SHA256:EECDH:EDH+aRSA:HIGH:!3DES:!aNULL:!DSS:!eNULL:!EXP:!MD5:!PSK:!RC4:!SRP:!SSLv2:!LOW:!MEDIUM >>> >>> [mysqladmin] >>> socket = /var/lib/mysql/mysql.sock >>> port = 3306 >>> user = root >>> >>> [mysqld_safe] >>> socket = /var/lib/mysql/mysql.sock >>> port = 3306 >>> log-error = /var/log/mysql_error.log >>> ________________________________________________________________________________________________ >>> >>> 31022 9:02:20 [Note] Event Scheduler: Purging the queue. 0 events >>> 131022 9:02:20 [Note] Error reading relay log event: slave SQL thread was killed >>> 131022 9:02:20 [Note] Slave I/O thread killed during or after a reconnect done to recover from failed read >>> 131022 9:02:20 [Note] Slave I/O thread exiting, read up to log 'bin.000058', position 952251 >>> 131022 9:02:21 InnoDB: Starting shutdown... >>> 131022 9:02:22 InnoDB: Shutdown completed; log sequence number 2638210237 >>> 131022 9:02:22 [Note] /usr/libexec/mysqld: Shutdown complete >>> 131022 9:02:27 [Note] /usr/libexec/mysqld: Normal shutdown >>> 131022 9:02:27 [Note] Event Scheduler: Purging the queue. 0 events >>> 131022 9:02:28 InnoDB: Starting shutdown... >>> 131022 9:02:29 InnoDB: Shutdown completed; log sequence number 14738980420 >>> 131022 9:02:29 [Note] /usr/libexec/mysqld: Shutdown complete >>> 131022 9:03:01 InnoDB: The InnoDB memory heap is disabled >>> 131022 9:03:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins >>> 131022 9:03:01 InnoDB: Compressed tables use zlib 1.2.7 >>> 131022 9:03:01 InnoDB: Using Linux native AIO >>> 131022 9:03:01 InnoDB: Initializing buffer pool, size = 50.0M >>> 131022 9:03:01 InnoDB: Completed initialization of buffer pool >>> 131022 9:03:02 InnoDB: highest supported file format is Barracuda. >>> 131022 9:03:02 InnoDB: The InnoDB memory heap is disabled >>> 131022 9:03:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins >>> 131022 9:03:02 InnoDB: Compressed tables use zlib 1.2.7 >>> 131022 9:03:02 InnoDB: Using Linux native AIO >>> 131022 9:03:02 InnoDB: Initializing buffer pool, size = 64.0M >>> 131022 9:03:02 InnoDB: Completed initialization of buffer pool >>> 131022 9:03:02 InnoDB: highest supported file format is Barracuda. >>> 131022 9:03:11 InnoDB: Waiting for the background threads to start >>> 131022 9:03:11 InnoDB: Waiting for the background threads to start >>> 131022 9:03:12 Percona XtraDB (http://www.percona.com) 5.5.33a-MariaDB-31.1 started; log sequence number 2638210237 >>> 131022 9:03:12 [Note] Plugin 'FEDERATED' is disabled. >>> 131022 9:03:12 [Note] Plugin 'FEEDBACK' is disabled. >>> 131022 9:03:12 [Note] Plugin 'partition' is disabled. >>> 131022 9:03:12 [Note] Server socket created on IP: '127.0.0.1'. >>> 131022 9:03:12 Percona XtraDB (http://www.percona.com) 5.5.33a-MariaDB-31.1 started; log sequence number 14738980420 >>> 131022 9:03:12 [Note] Plugin 'FEDERATED' is disabled. >>> 131022 9:03:12 [Note] Plugin 'FEEDBACK' is disabled. >>> 131022 9:03:12 [Note] Plugin 'partition' is disabled. >>> 131022 9:03:14 [Note] Slave SQL thread initialized, starting replication in log 'bin.000058' at position 952251, >>> relay log './mysql-relay-bin.000140' position: 952529 >>> 131022 9:03:14 [Note] Server socket created on IP: '0.0.0.0'. >>> 131022 9:03:14 [Note] Slave I/O thread: connected to master 'replication@10.0.0.99:3306',replication started in >>> log 'bin.000058' at position 952251 >>> 131022 9:03:14 [Note] Event Scheduler: Loaded 0 events >>> 131022 9:03:14 [Note] /usr/libexec/mysqld: ready for connections. >>> Version: '5.5.33a-MariaDB' socket: '/var/lib/mysql/mysql_replication.sock' port: 3307 thelounge >>> 131022 9:03:14 [Note] Event Scheduler: Loaded 0 events >>> 131022 9:03:14 [Note] /usr/libexec/mysqld: ready for connections. >>> Version: '5.5.33a-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 thelounge >>> 131022 11:30:05 [ERROR] mysqld: Table './musikarchiv/rh_meta' is marked as crashed and should be repaired >>> 131022 11:30:05 [Warning] Checking table: './musikarchiv/rh_meta' >>> 131022 11:30:05 [ERROR] musikarchiv.rh_meta: 1 client is using or hasn't closed the table properly >>> 131022 11:30:07 [ERROR] mysqld: Table './lounge_panel/cms1_meta' is marked as crashed and should be repaired >>> 131022 11:30:07 [Warning] Checking table: './lounge_panel/cms1_meta' >>> 131022 11:30:07 [ERROR] lounge_panel.cms1_meta: 1 client is using or hasn't closed the table properly >>> ________________________________________________________________________________________________ >>> >>> [builduser@testserver:~]$ cat .rpmrc >>> optflags: x86_64 -m64 -O2 -march=corei7 -mtune=corei7 -fopenmp -mmmx -msse2 -msse3 -msse4.1 -msse4.2 -maes >>> -mfpmath=sse -pipe -fomit-frame-pointer -finline-functions -finline-limit=60 -fexceptions -fstack-protector-strong >>> --param=ssp-buffer-size=8 -D_FORTIFY_SOURCE=2 >>> >>> export CFLAGS="%{optflags} -O3 -fno-stack-protector -fstack-protector --param=ssp-buffer-size=8 -fPIC >>> -fomit-frame-pointer -fno-exceptions -ffixed-ebp -fwrapv -fno-strict-aliasing -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 >>> -D_LARGEFILE_SOURCE" >>> export CXXFLAGS="$CFLAGS" >>> export FFLAGS="$CFLAGS" >>> export FCFLAGS="$CFLAGS" >>> export LDFLAGS="-Wl,-z,now -Wl,-z,relro,-z,noexecstack -pie" >>> export SH_LDFLAGS="$LDFLAGS" >>> >>> cmake . -DBUILD_CONFIG=mysql_release \ >>> -DFEATURE_SET="community" \ >>> -DCMAKE_INSTALL_PREFIX="%{_prefix}" \ >>> -DINSTALL_INCLUDEDIR=include/mysql \ >>> -DINSTALL_LAYOUT=RPM \ >>> -DINSTALL_LIBDIR="%{_lib}/mysql" \ >>> -DINSTALL_MANDIR=share/man \ >>> -DINSTALL_MYSQLSHAREDIR=share/mysql \ >>> -DINSTALL_MYSQLTESTDIR=share/mysql-test \ >>> -DINSTALL_PLUGINDIR="%{_lib}/mysql/plugin" \ >>> -DINSTALL_SBINDIR=libexec \ >>> -DINSTALL_SCRIPTDIR=bin \ >>> -DINSTALL_SQLBENCHDIR= \ >>> -DINSTALL_SUPPORTFILESDIR=share/mysql \ >>> -DMYSQL_DATADIR="%{_sharedstatedir}/mysql" \ >>> -DMYSQL_UNIX_ADDR="%{_sharedstatedir}/mysql/mysql.sock" \ >>> -DWITH_XTRADB_STORAGE_ENGINE=ON \ >>> -DWITH_PARTITION_STORAGE_ENGINE=ON \ >>> -DWITH_ARCHIVE_STORAGE_ENGINE=OFF \ >>> -DWITH_BLACKHOLE_STORAGE_ENGINE=OFF \ >>> -DWITH_SPHINX_STORAGE_ENGINE=OFF \ >>> -DENABLED_PROFILING=OFF \ >>> -DENABLE_DTRACE=OFF \ >>> -DENABLE_DEBUG_SYNC=OFF \ >>> -DWITHOUT_TOKUDB=ON \ >>> -DWITH_VALGRIND=OFF \ >>> -DWITH_SAFEMALLOC=OFF \ >>> -DWITH_EMBEDDED_SERVER=OFF \ >>> -DWITH_FEEDBACK=OFF \ >>> -DWITH_LIBWRAP=OFF \ >>> -DWITH_QUERY_CACHE_INFO=OFF \ >>> -DWITH_READLINE=OFF \ >>> -DUSE_NEW_READLINE_INTERFACE=ON \ >>> -DENABLED_LOCAL_INFILE=ON \ >>> -DNOT_FOR_DISTRIBUTION=ON \ >>> -DWITH_FAST_MUTEXES=ON \ >>> -DWITH_ATOMIC_OPS=smp \ >>> -DWITHOUT_DYNAMIC_PLUGINS=ON \ >>> -DWITH_PIC=ON \ >>> -DWITH_JEMALLOC=system \ >>> -DWITH_SSL=system \ >>> -DWITH_ZLIB=system \ >>> -DCOMPILATION_COMMENT="thelounge"

2 2

[Maria-discuss] New Question: MariaDB Partitioning and Stored Procedure Support
by AskMonty KB 26 Oct '13

26 Oct '13

Hello, A new question has been asked in "MariaDB FAQ" by htaylor: -------------------------------- Does MariaDB support the use of stored procedures with partitioning of tables. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-partitioning-and-stored-procedure-support/

1 0

[Maria-discuss] Synchronization down after reboot
by Guillaume Hilt 25 Oct '13

25 Oct '13

Hello, I'm using MariaDB with Galera replication on 3 Ubuntu 12.04 servers : Server version: 5.5.33a-MariaDB-1~precise mariadb.org binary distribution, wsrep_23.7.6.rXXXX They're all development servers, in the same local network, so there's no firewall between them. They were all working fine until a reboot. Now node 2 and 3 aren't in sync anymore and mysql refuse to start. Replication is done using xtrabackup. I can start over by doing a mysqlhotcopy on node1 and put the data on node2 and node3 but i'd like to understand why it didn't survived a reboot. Here's my nodes : * Node 1 : dev-sql-001 / 192.168.3.121 * Node 2 : dev-sql-002 / 192.168.3.221 * Node 3 : dev-sql-003 / 192.168.3.222 Here's the log on node 1 when I try to start node 2 : Oct 22 10:19:29 dev-sql-001 mysqld: 131022 10:19:29 [Note] WSREP: declaring abbffcb5-3af2-11e3-a043-5b38dfb689cf stable Oct 22 10:19:29 dev-sql-001 mysqld: 131022 10:19:29 [Note] WSREP: Node f743192f-3aee-11e3-a47b-97626a725dde state prim Oct 22 10:19:29 dev-sql-001 mysqld: 131022 10:19:29 [Note] WSREP: view(view_id(PRIM,abbffcb5-3af2-11e3-a043-5b38dfb689cf,6) memb { Oct 22 10:19:29 dev-sql-001 mysqld: #011abbffcb5-3af2-11e3-a043-5b38dfb689cf, Oct 22 10:19:29 dev-sql-001 mysqld: #011f743192f-3aee-11e3-a47b-97626a725dde, Oct 22 10:19:29 dev-sql-001 mysqld: } joined { Oct 22 10:19:29 dev-sql-001 mysqld: } left { Oct 22 10:19:29 dev-sql-001 mysqld: } partitioned { Oct 22 10:19:29 dev-sql-001 mysqld: }) Oct 22 10:19:29 dev-sql-001 mysqld: 131022 10:19:29 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2 Oct 22 10:19:29 dev-sql-001 mysqld: 131022 10:19:29 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. Oct 22 10:19:29 dev-sql-001 mysqld: 131022 10:19:29 [Note] WSREP: STATE EXCHANGE: sent state msg: ac5a1fa8-3af2-11e3-ba64-7e36060f57f6 Oct 22 10:19:29 dev-sql-001 mysqld: 131022 10:19:29 [Note] WSREP: STATE EXCHANGE: got state msg: ac5a1fa8-3af2-11e3-ba64-7e36060f57f6 from 0 (dev-sql-002) Oct 22 10:19:29 dev-sql-001 mysqld: 131022 10:19:29 [Note] WSREP: STATE EXCHANGE: got state msg: ac5a1fa8-3af2-11e3-ba64-7e36060f57f6 from 1 (dev-sql-001) Oct 22 10:19:29 dev-sql-001 mysqld: 131022 10:19:29 [Note] WSREP: Quorum results: Oct 22 10:19:29 dev-sql-001 mysqld: #011version = 2, Oct 22 10:19:29 dev-sql-001 mysqld: #011component = PRIMARY, Oct 22 10:19:29 dev-sql-001 mysqld: #011conf_id = 5, Oct 22 10:19:29 dev-sql-001 mysqld: #011members = 1/2 (joined/total), Oct 22 10:19:29 dev-sql-001 mysqld: #011act_id = 968, Oct 22 10:19:29 dev-sql-001 mysqld: #011last_appl. = 0, Oct 22 10:19:29 dev-sql-001 mysqld: #011protocols = 0/4/2 (gcs/repl/appl), Oct 22 10:19:29 dev-sql-001 mysqld: #011group UUID = 2896facc-2110-11e3-0800-717f6d7ec2af Oct 22 10:19:29 dev-sql-001 mysqld: 131022 10:19:29 [Note] WSREP: Flow-control interval: [23, 23] Oct 22 10:19:29 dev-sql-001 mysqld: 131022 10:19:29 [Note] WSREP: New cluster view: global state: 2896facc-2110-11e3-0800-717f6d7ec2af:968, view# 6: Primary, number of nodes: 2, my index: 1, protocol version 2 Oct 22 10:19:29 dev-sql-001 mysqld: 131022 10:19:29 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Oct 22 10:19:29 dev-sql-001 mysqld: 131022 10:19:29 [Note] WSREP: Assign initial position for certification: 968, protocol version: 2 Oct 22 10:19:32 dev-sql-001 mysqld: 131022 10:19:32 [Note] WSREP: Node 0 (dev-sql-002) requested state transfer from '*any*'. Selected 1 (dev-sql-001)(SYNCED) as donor. Oct 22 10:19:32 dev-sql-001 mysqld: 131022 10:19:32 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 968) Oct 22 10:19:32 dev-sql-001 mysqld: 131022 10:19:32 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Oct 22 10:19:32 dev-sql-001 mysqld: 131022 10:19:32 [Note] WSREP: Running: 'wsrep_sst_xtrabackup --role 'donor' --address '192.168.3.221:4444/xtrabackup_sst' --auth 'root:test' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --gtid '2896facc-2110-11e3-0800-717f6d7ec2af:968'' Oct 22 10:19:32 dev-sql-001 mysqld: 131022 10:19:32 [Note] WSREP: sst_donor_thread signaled with 0 Oct 22 10:19:32 dev-sql-001 mysqld: WSREP_SST: [INFO] Streaming with tar (20131022 10:19:32.294) Oct 22 10:19:32 dev-sql-001 mysqld: WSREP_SST: [INFO] Note: Advanced xtrabackup features - encryption,compression etc. not available with tar. (20131022 10:19:32.301) Oct 22 10:19:32 dev-sql-001 mysqld: WSREP_SST: [INFO] Streaming the backup to joiner at 192.168.3.221 4444 (20131022 10:19:32.330) Oct 22 10:19:32 dev-sql-001 mysqld: WSREP_SST: [ERROR] innobackupex finished with error: 1. Check /var/lib/mysql//innobackup.backup.log (20131022 10:19:32.662) Oct 22 10:19:32 dev-sql-001 mysqld: WSREP_SST: [ERROR] Cleanup after exit with status:22 (20131022 10:19:32.668) Oct 22 10:19:32 dev-sql-001 mysqld: 131022 10:19:32 [ERROR] WSREP: Failed to read from: wsrep_sst_xtrabackup --role 'donor' --address '192.168.3.221:4444/xtrabackup_sst' --auth 'root:test' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --gtid '2896facc-2110-11e3-0800-717f6d7ec2af:968' Oct 22 10:19:32 dev-sql-001 mysqld: 131022 10:19:32 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup --role 'donor' --address '192.168.3.221:4444/xtrabackup_sst' --auth 'root:test' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --gtid '2896facc-2110-11e3-0800-717f6d7ec2af:968': 22 (Invalid argument) Oct 22 10:19:32 dev-sql-001 mysqld: 131022 10:19:32 [Warning] WSREP: 1 (dev-sql-001): State transfer to 0 (dev-sql-002) failed: -1 (Operation not permitted) Oct 22 10:19:32 dev-sql-001 mysqld: 131022 10:19:32 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 968) Oct 22 10:19:33 dev-sql-001 mysqld: 131022 10:19:33 [Note] WSREP: Member 1 (dev-sql-001) synced with group. Oct 22 10:19:33 dev-sql-001 mysqld: 131022 10:19:33 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 968) Oct 22 10:19:33 dev-sql-001 mysqld: 131022 10:19:33 [Note] WSREP: Synchronized with group, ready for connections Oct 22 10:19:33 dev-sql-001 mysqld: 131022 10:19:33 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Oct 22 10:19:33 dev-sql-001 mysqld: 131022 10:19:33 [Note] WSREP: Node f743192f-3aee-11e3-a47b-97626a725dde state prim Oct 22 10:19:33 dev-sql-001 mysqld: 131022 10:19:33 [Note] WSREP: view(view_id(PRIM,f743192f-3aee-11e3-a47b-97626a725dde,7) memb { Oct 22 10:19:33 dev-sql-001 mysqld: #011f743192f-3aee-11e3-a47b-97626a725dde, Oct 22 10:19:33 dev-sql-001 mysqld: } joined { Oct 22 10:19:33 dev-sql-001 mysqld: } left { Oct 22 10:19:33 dev-sql-001 mysqld: } partitioned { Oct 22 10:19:33 dev-sql-001 mysqld: #011abbffcb5-3af2-11e3-a043-5b38dfb689cf, Oct 22 10:19:33 dev-sql-001 mysqld: }) Oct 22 10:19:33 dev-sql-001 mysqld: 131022 10:19:33 [Note] WSREP: forgetting abbffcb5-3af2-11e3-a043-5b38dfb689cf (tcp://192.168.3.221:4567) Oct 22 10:19:33 dev-sql-001 mysqld: 131022 10:19:33 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 Oct 22 10:19:33 dev-sql-001 mysqld: 131022 10:19:33 [Note] WSREP: STATE_EXCHANGE: sent state UUID: ae9636c9-3af2-11e3-b69e-0fef55014e34 Oct 22 10:19:33 dev-sql-001 mysqld: 131022 10:19:33 [Note] WSREP: STATE EXCHANGE: sent state msg: ae9636c9-3af2-11e3-b69e-0fef55014e34 Oct 22 10:19:33 dev-sql-001 mysqld: 131022 10:19:33 [Note] WSREP: STATE EXCHANGE: got state msg: ae9636c9-3af2-11e3-b69e-0fef55014e34 from 0 (dev-sql-001) Oct 22 10:19:33 dev-sql-001 mysqld: 131022 10:19:33 [Note] WSREP: Quorum results: Oct 22 10:19:33 dev-sql-001 mysqld: #011version = 2, Oct 22 10:19:33 dev-sql-001 mysqld: #011component = PRIMARY, Oct 22 10:19:33 dev-sql-001 mysqld: #011conf_id = 6, Oct 22 10:19:33 dev-sql-001 mysqld: #011members = 1/1 (joined/total), Oct 22 10:19:33 dev-sql-001 mysqld: #011act_id = 968, Oct 22 10:19:33 dev-sql-001 mysqld: #011last_appl. = 0, Oct 22 10:19:33 dev-sql-001 mysqld: #011protocols = 0/4/2 (gcs/repl/appl), Oct 22 10:19:33 dev-sql-001 mysqld: #011group UUID = 2896facc-2110-11e3-0800-717f6d7ec2af Oct 22 10:19:33 dev-sql-001 mysqld: 131022 10:19:33 [Note] WSREP: Flow-control interval: [16, 16] Oct 22 10:19:33 dev-sql-001 mysqld: 131022 10:19:33 [Note] WSREP: New cluster view: global state: 2896facc-2110-11e3-0800-717f6d7ec2af:968, view# 7: Primary, number of nodes: 1, my index: 0, protocol version 2 Oct 22 10:19:33 dev-sql-001 mysqld: 131022 10:19:33 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Oct 22 10:19:33 dev-sql-001 mysqld: 131022 10:19:33 [Note] WSREP: Assign initial position for certification: 968, protocol version: 2 Oct 22 10:19:38 dev-sql-001 mysqld: 131022 10:19:38 [Note] WSREP: cleaning up abbffcb5-3af2-11e3-a043-5b38dfb689cf (tcp://192.168.3.221:4567) /var/lib/mysql//innobackup.backup.log on node1 : 131022 10:19:32 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/etc/mysql/my.cnf;mysql_read_default_group=xtrabackup;mysql_socket=/var/run/mysqld/mysqld.sock' as 'root' (using password: YES). innobackupex: Error: Failed to connect to MySQL server: DBI connect(';mysql_read_default_file=/etc/mysql/my.cnf;mysql_read_default_group=xtrabackup;mysql_socket=/var/run/mysqld/mysqld.sock','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /usr//bin/innobackupex line 2902 As for node2 logs : Oct 22 10:19:25 dev-sql-002 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql Oct 22 10:19:25 dev-sql-002 mysqld_safe: WSREP: Running position recovery with --log_error=/tmp/tmp.gp3R8iSBdK --pid-file=/var/lib/mysql/dev-sql-002-recover.pid Oct 22 10:19:25 dev-sql-002 mysqld: 131022 10:19:25 [Warning] option 'table_cache': unsigned value 2097152 adjusted to 524288 Oct 22 10:19:28 dev-sql-002 mysqld_safe: WSREP: Recovered position 2896facc-2110-11e3-0800-717f6d7ec2af:370 Oct 22 10:19:28 dev-sql-002 mysqld: 131022 10:19:28 [Warning] option 'table_cache': unsigned value 2097152 adjusted to 524288 Oct 22 10:19:28 dev-sql-002 mysqld: 131022 10:19:28 [Note] WSREP: wsrep_start_position var submitted: '2896facc-2110-11e3-0800-717f6d7ec2af:370' Oct 22 10:19:28 dev-sql-002 mysqld: 131022 10:19:28 [Note] WSREP: Read nil XID from storage engines, skipping position init Oct 22 10:19:28 dev-sql-002 mysqld: 131022 10:19:28 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so' Oct 22 10:19:28 dev-sql-002 mysqld: 131022 10:19:28 [Note] WSREP: wsrep_load(): Galera 23.2.7-wheezy(r) by Codership Oy <info(a)codership.com> loaded succesfully. Oct 22 10:19:28 dev-sql-002 mysqld: 131022 10:19:28 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1 Oct 22 10:19:28 dev-sql-002 mysqld: 131022 10:19:28 [Note] WSREP: Reusing existing '/var/lib/mysql//galera.cache'. Oct 22 10:19:28 dev-sql-002 mysqld: 131022 10:19:28 [Note] WSREP: Passing config to GCS: base_host = 192.168.3.221; base_port = 4567; cert.log_conflicts = no; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = NO; replicator.causal_read_timeout = PT30S; replicator.commit_order = 3 Oct 22 10:19:28 dev-sql-002 mysqld: 131022 10:19:28 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1 Oct 22 10:19:28 dev-sql-002 mysqld: 131022 10:19:28 [Note] WSREP: wsrep_sst_grab() Oct 22 10:19:28 dev-sql-002 mysqld: 131022 10:19:28 [Note] WSREP: Start replication Oct 22 10:19:28 dev-sql-002 mysqld: 131022 10:19:28 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 Oct 22 10:19:28 dev-sql-002 mysqld: 131022 10:19:28 [Note] WSREP: protonet asio version 0 Oct 22 10:19:28 dev-sql-002 mysqld: 131022 10:19:28 [Note] WSREP: backend: asio Oct 22 10:19:28 dev-sql-002 mysqld: 131022 10:19:28 [Note] WSREP: GMCast version 0 Oct 22 10:19:28 dev-sql-002 mysqld: 131022 10:19:28 [Note] WSREP: (abbffcb5-3af2-11e3-a043-5b38dfb689cf, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 Oct 22 10:19:28 dev-sql-002 mysqld: 131022 10:19:28 [Note] WSREP: (abbffcb5-3af2-11e3-a043-5b38dfb689cf, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 Oct 22 10:19:28 dev-sql-002 mysqld: 131022 10:19:28 [Note] WSREP: EVS version 0 Oct 22 10:19:28 dev-sql-002 mysqld: 131022 10:19:28 [Note] WSREP: PC version 0 Oct 22 10:19:28 dev-sql-002 mysqld: 131022 10:19:28 [Note] WSREP: gcomm: connecting to group 'dev-sql', peer 'dev-sql-001:,dev-sql-002:' Oct 22 10:19:28 dev-sql-002 mysqld: 131022 10:19:28 [Warning] WSREP: (abbffcb5-3af2-11e3-a043-5b38dfb689cf, 'tcp://0.0.0.0:4567') address 'tcp://192.168.3.221:4567' points to own listening address, blacklisting Oct 22 10:19:28 dev-sql-002 mysqld: 131022 10:19:28 [Note] WSREP: (abbffcb5-3af2-11e3-a043-5b38dfb689cf, 'tcp://0.0.0.0:4567') address 'tcp://192.168.3.221:4567' pointing to uuid abbffcb5-3af2-11e3-a043-5b38dfb689cf is blacklisted, skipping Oct 22 10:19:29 dev-sql-002 mysqld: 131022 10:19:29 [Note] WSREP: declaring f743192f-3aee-11e3-a47b-97626a725dde stable Oct 22 10:19:29 dev-sql-002 mysqld: 131022 10:19:29 [Note] WSREP: Node f743192f-3aee-11e3-a47b-97626a725dde state prim Oct 22 10:19:29 dev-sql-002 mysqld: 131022 10:19:29 [Note] WSREP: view(view_id(PRIM,abbffcb5-3af2-11e3-a043-5b38dfb689cf,6) memb { Oct 22 10:19:29 dev-sql-002 mysqld: #011abbffcb5-3af2-11e3-a043-5b38dfb689cf, Oct 22 10:19:29 dev-sql-002 mysqld: #011f743192f-3aee-11e3-a47b-97626a725dde, Oct 22 10:19:29 dev-sql-002 mysqld: } joined { Oct 22 10:19:29 dev-sql-002 mysqld: } left { Oct 22 10:19:29 dev-sql-002 mysqld: } partitioned { Oct 22 10:19:29 dev-sql-002 mysqld: }) Oct 22 10:19:29 dev-sql-002 mysqld: 131022 10:19:29 [Note] WSREP: gcomm: connected Oct 22 10:19:29 dev-sql-002 mysqld: 131022 10:19:29 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 Oct 22 10:19:29 dev-sql-002 mysqld: 131022 10:19:29 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) Oct 22 10:19:29 dev-sql-002 mysqld: 131022 10:19:29 [Note] WSREP: Opened channel 'dev-sql' Oct 22 10:19:29 dev-sql-002 mysqld: 131022 10:19:29 [Note] WSREP: Waiting for SST to complete. Oct 22 10:19:29 dev-sql-002 mysqld: 131022 10:19:29 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2 Oct 22 10:19:29 dev-sql-002 mysqld: 131022 10:19:29 [Note] WSREP: STATE_EXCHANGE: sent state UUID: ac5a1fa8-3af2-11e3-ba64-7e36060f57f6 Oct 22 10:19:29 dev-sql-002 mysqld: 131022 10:19:29 [Note] WSREP: STATE EXCHANGE: sent state msg: ac5a1fa8-3af2-11e3-ba64-7e36060f57f6 Oct 22 10:19:29 dev-sql-002 mysqld: 131022 10:19:29 [Note] WSREP: STATE EXCHANGE: got state msg: ac5a1fa8-3af2-11e3-ba64-7e36060f57f6 from 0 (dev-sql-002) Oct 22 10:19:29 dev-sql-002 mysqld: 131022 10:19:29 [Note] WSREP: STATE EXCHANGE: got state msg: ac5a1fa8-3af2-11e3-ba64-7e36060f57f6 from 1 (dev-sql-001) Oct 22 10:19:29 dev-sql-002 mysqld: 131022 10:19:29 [Note] WSREP: Quorum results: Oct 22 10:19:29 dev-sql-002 mysqld: #011version = 2, Oct 22 10:19:29 dev-sql-002 mysqld: #011component = PRIMARY, Oct 22 10:19:29 dev-sql-002 mysqld: #011conf_id = 5, Oct 22 10:19:29 dev-sql-002 mysqld: #011members = 1/2 (joined/total), Oct 22 10:19:29 dev-sql-002 mysqld: #011act_id = 968, Oct 22 10:19:29 dev-sql-002 mysqld: #011last_appl. = -1, Oct 22 10:19:29 dev-sql-002 mysqld: #011protocols = 0/4/2 (gcs/repl/appl), Oct 22 10:19:29 dev-sql-002 mysqld: #011group UUID = 2896facc-2110-11e3-0800-717f6d7ec2af Oct 22 10:19:29 dev-sql-002 mysqld: 131022 10:19:29 [Note] WSREP: Flow-control interval: [23, 23] Oct 22 10:19:29 dev-sql-002 mysqld: 131022 10:19:29 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 968) Oct 22 10:19:29 dev-sql-002 mysqld: 131022 10:19:29 [Note] WSREP: State transfer required: Oct 22 10:19:29 dev-sql-002 mysqld: #011Group state: 2896facc-2110-11e3-0800-717f6d7ec2af:968 Oct 22 10:19:29 dev-sql-002 mysqld: #011Local state: 00000000-0000-0000-0000-000000000000:-1 Oct 22 10:19:29 dev-sql-002 mysqld: 131022 10:19:29 [Note] WSREP: New cluster view: global state: 2896facc-2110-11e3-0800-717f6d7ec2af:968, view# 6: Primary, number of nodes: 2, my index: 0, protocol version 2 Oct 22 10:19:29 dev-sql-002 mysqld: 131022 10:19:29 [Warning] WSREP: Gap in state sequence. Need state transfer. Oct 22 10:19:31 dev-sql-002 mysqld: 131022 10:19:31 [Note] WSREP: Running: 'wsrep_sst_xtrabackup --role 'joiner' --address '192.168.3.221' --auth 'root:test' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --parent '13950'' Oct 22 10:19:31 dev-sql-002 mysqld: WSREP_SST: [INFO] Streaming with tar (20131022 10:19:31.981) Oct 22 10:19:31 dev-sql-002 mysqld: WSREP_SST: [INFO] Note: Advanced xtrabackup features - encryption,compression etc. not available with tar. (20131022 10:19:31.988) Oct 22 10:19:31 dev-sql-002 mysqld: WSREP_SST: [INFO] However, xbstream requires manual cleanup of data directory before SST - lp:1193240. (20131022 10:19:31.994) Oct 22 10:19:32 dev-sql-002 mysqld: 131022 10:19:32 [Note] WSREP: Prepared SST request: xtrabackup|192.168.3.221:4444/xtrabackup_sst Oct 22 10:19:32 dev-sql-002 mysqld: 131022 10:19:32 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Oct 22 10:19:32 dev-sql-002 mysqld: 131022 10:19:32 [Note] WSREP: Assign initial position for certification: 968, protocol version: 2 Oct 22 10:19:32 dev-sql-002 mysqld: 131022 10:19:32 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (2896facc-2110-11e3-0800-717f6d7ec2af): 1 (Operation not permitted) Oct 22 10:19:32 dev-sql-002 mysqld: #011 at galera/src/replicator_str.cpp:prepare_for_IST():436. IST will be unavailable. Oct 22 10:19:32 dev-sql-002 mysqld: 131022 10:19:32 [Note] WSREP: Node 0 (dev-sql-002) requested state transfer from '*any*'. Selected 1 (dev-sql-001)(SYNCED) as donor. Oct 22 10:19:32 dev-sql-002 mysqld: 131022 10:19:32 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 968) Oct 22 10:19:32 dev-sql-002 mysqld: 131022 10:19:32 [Note] WSREP: Requesting state transfer: success, donor: 1 Oct 22 10:19:32 dev-sql-002 mysqld: tar: This does not look like a tar archive Oct 22 10:19:32 dev-sql-002 mysqld: tar: Exiting with failure status due to previous errors Oct 22 10:19:32 dev-sql-002 mysqld: WSREP_SST: [ERROR] Error while getting data from donor node: exit codes: 0 2 (20131022 10:19:32.659) Oct 22 10:19:32 dev-sql-002 mysqld: WSREP_SST: [ERROR] Data directory /var/lib/mysql/ needs to be empty for SST: Manual intervention required in that case (20131022 10:19:32.666) Oct 22 10:19:32 dev-sql-002 mysqld: WSREP_SST: [ERROR] Cleanup after exit with status:32 (20131022 10:19:32.672) Oct 22 10:19:32 dev-sql-002 mysqld: 131022 10:19:32 [Warning] WSREP: 1 (dev-sql-001): State transfer to 0 (dev-sql-002) failed: -1 (Operation not permitted) Oct 22 10:19:32 dev-sql-002 mysqld: 131022 10:19:32 [ERROR] WSREP: gcs/src/gcs_group.c:gcs_group_handle_join_msg():719: Will never receive state. Need to abort. Oct 22 10:19:32 dev-sql-002 mysqld: 131022 10:19:32 [Note] WSREP: gcomm: terminating thread Oct 22 10:19:32 dev-sql-002 mysqld: 131022 10:19:32 [Note] WSREP: gcomm: joining thread Oct 22 10:19:32 dev-sql-002 mysqld: 131022 10:19:32 [Note] WSREP: gcomm: closing backend Oct 22 10:19:32 dev-sql-002 mysqld: WSREP_SST: [ERROR] Killing nc pid (20131022 10:19:32.707) Oct 22 10:19:32 dev-sql-002 mysqld: WSREP_SST: [INFO] Removing the sst_in_progress file (20131022 10:19:32.725) Oct 22 10:19:32 dev-sql-002 mysqld: 131022 10:19:32 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup --role 'joiner' --address '192.168.3.221' --auth 'root:test' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --parent '13950': 32 (Broken pipe) Oct 22 10:19:32 dev-sql-002 mysqld: 131022 10:19:32 [ERROR] WSREP: Failed to read uuid:seqno from joiner script. Oct 22 10:19:32 dev-sql-002 mysqld: 131022 10:19:32 [ERROR] WSREP: SST failed: 32 (Broken pipe) Oct 22 10:19:32 dev-sql-002 mysqld: 131022 10:19:32 [ERROR] Aborting Oct 22 10:19:32 dev-sql-002 mysqld: Oct 22 10:19:33 dev-sql-002 mysqld: 131022 10:19:33 [Note] WSREP: view(view_id(NON_PRIM,abbffcb5-3af2-11e3-a043-5b38dfb689cf,6) memb { Oct 22 10:19:33 dev-sql-002 mysqld: #011abbffcb5-3af2-11e3-a043-5b38dfb689cf, Oct 22 10:19:33 dev-sql-002 mysqld: } joined { Oct 22 10:19:33 dev-sql-002 mysqld: } left { Oct 22 10:19:33 dev-sql-002 mysqld: } partitioned { Oct 22 10:19:33 dev-sql-002 mysqld: #011f743192f-3aee-11e3-a47b-97626a725dde, Oct 22 10:19:33 dev-sql-002 mysqld: }) Oct 22 10:19:33 dev-sql-002 mysqld: 131022 10:19:33 [Note] WSREP: view((empty)) Oct 22 10:19:33 dev-sql-002 mysqld: 131022 10:19:33 [Note] WSREP: gcomm: closed Oct 22 10:19:33 dev-sql-002 mysqld: 131022 10:19:33 [Note] WSREP: /usr/sbin/mysqld: Terminated. Oct 22 10:19:33 dev-sql-002 mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended Oct 22 10:19:55 dev-sql-002 /etc/init.d/mysql[14428]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Oct 22 10:19:55 dev-sql-002 /etc/init.d/mysql[14428]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed Oct 22 10:19:55 dev-sql-002 /etc/init.d/mysql[14428]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)' Oct 22 10:19:55 dev-sql-002 /etc/init.d/mysql[14428]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Oct 22 10:19:55 dev-sql-002 /etc/init.d/mysql[14428]: WSREP status on node1 : MariaDB [(none)]> SHOW STATUS LIKE 'wsrep_%' -> ; +----------------------------+--------------------------------------+ | Variable_name | Value | +----------------------------+--------------------------------------+ | wsrep_local_state_uuid | 2896facc-2110-11e3-0800-717f6d7ec2af | | wsrep_protocol_version | 4 | | wsrep_last_committed | 968 | | wsrep_replicated | 0 | | wsrep_replicated_bytes | 0 | | wsrep_received | 12 | | wsrep_received_bytes | 1126 | | wsrep_local_commits | 0 | | wsrep_local_cert_failures | 0 | | wsrep_local_bf_aborts | 0 | | wsrep_local_replays | 0 | | wsrep_local_send_queue | 0 | | wsrep_local_send_queue_avg | 0.500000 | | wsrep_local_recv_queue | 0 | | wsrep_local_recv_queue_avg | 0.000000 | | wsrep_flow_control_paused | 0.000000 | | wsrep_flow_control_sent | 0 | | wsrep_flow_control_recv | 0 | | wsrep_cert_deps_distance | 0.000000 | | wsrep_apply_oooe | 0.000000 | | wsrep_apply_oool | 0.000000 | | wsrep_apply_window | 0.000000 | | wsrep_commit_oooe | 0.000000 | | wsrep_commit_oool | 0.000000 | | wsrep_commit_window | 0.000000 | | wsrep_local_state | 4 | | wsrep_local_state_comment | Synced | | wsrep_cert_index_size | 0 | | wsrep_causal_reads | 0 | | wsrep_incoming_addresses | 192.168.3.121:3306 | | wsrep_cluster_conf_id | 5 | | wsrep_cluster_size | 1 | | wsrep_cluster_state_uuid | 2896facc-2110-11e3-0800-717f6d7ec2af | | wsrep_cluster_status | Primary | | wsrep_connected | ON | | wsrep_local_index | 0 | | wsrep_provider_name | Galera | | wsrep_provider_vendor | Codership Oy <info(a)codership.com> | | wsrep_provider_version | 23.2.7-wheezy(r) | | wsrep_ready | ON | +----------------------------+--------------------------------------+ 40 rows in set (0.00 sec) Thanks, -- Guillaume Hilt

2 3

[Maria-discuss] Parallel build support for v10?
by jen142＠promessage.com 24 Oct '13

24 Oct '13

Hi, I build MariaDB v10 from src on linux/64. If, after `cmake` configure I attempt a parallel build, make -j4 VERBOSE=1 I get numerous/sequential build failures. ALL of the related failures vanish if I simple single-thread the build, make -j1 VERBOSE=1 *IS* MarbiDB v10 currently intended to be parallel-buildable? jen

2 2

[Maria-discuss] How to disable TokuDB libtokuportability.so check in 10.0.4/r3863 source build?
by jen142＠promessage.com 24 Oct '13

24 Oct '13

I'm building v10.0.4/r3863 on opensuse/64. This latest-version build newly fails @ cd /usr/local/src/mariadb/bld/storage/tokudb/ft-index/ft && ./logformat . ./logformat: error while loading shared libraries: libtokuportability.so: cannot open shared object file: No such file or directory This is changed behavior. I'm currently not interested in TokuDB. Reading @ https://mariadb.com/kb/en/how-to-enable-tokudb-in-mariadb/#enabling-tokudb it's not supported on my platform anyway. There's info on how to ENABLE it, but not how to DISABLE it -- so the build doesn't complain. How do I correctly DISABLE it in my build? Jen

2 1

[Maria-discuss] maria certifications?
by Federico Razzoli 24 Oct '13

24 Oct '13

I found a site about MariaDB certifications: http://www.mariadbcertification.org/ However, it looks like a sort of work in progress. Also, I don't understand if it is something official, or at least recommended by the Foundation. And, if it is not, is any official certification planned? Ciao Federico

2 2