- discuss - lists.mariadb.org

[Maria-discuss] Problems with running out of connections in cluster
by Lee Bennett 13 Jun '16

13 Jun '16

Hi We are running a 7 node cluster (6 data nodes and 1 arbiter node) which span 2 data centers using version 10.1.13. We have had several occasions where the application have gone off and created so many connections that the max connections are filled up which leads to the database becoming unresponsive. The connections cannot be killed and and in the ‘killed’ state forever. Today when this occurred all six cluster node maxed out on connections. The only way to get the servers back is by restarting the databases but when the first node we restarted it tried to connect to the cluster is to IST it could not connected. After shutdown a second node the cluster seemed to sort its self out and everything came back. Is anyone aware of any bugs that might cause this issue. Regards LB

1 0

[Maria-discuss] New Question: MariaDB Monitoring Using MONyog
by AskMonty KB 13 Jun '16

13 Jun '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-monitoring-using-monyog/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- can we get summary of all the servers registered which are online and which are not with help of charts like in OEM?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-monitoring-using-monyog/

1 0

[Maria-discuss] New Question: MariaDB with Galera on RedHat 7.2 not starting
by AskMonty KB 12 Jun '16

12 Jun '16

Hello, A new question has been asked in "Starting and Stopping MariaDB" by veselin_vasilev_g. Please answer it at http://mariadb.com/kb/en/mariadb-with-galera-on-redhat-72-not-starting/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, can someone please help as I couldn't find relevant information online. When trying to initialize the first node of the cluster, I get this: Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so' Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: wsrep_load(): Galera 25.3.15(r3578) by Codership Oy <info(a)codership.com> loaded Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: CRC-32C: using hardware acceleration. Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 172.20.1.56; bas Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510378977024 [Note] WSREP: Service thread queue flushed. Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: wsrep_sst_grab() Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: Start replication Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: protonet asio version 0 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: Using CRC-32C for message checksums. Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: backend: asio Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory) Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: restore pc from disk failed Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: GMCast version 0 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: (b5e7b88e, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: (b5e7b88e, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: EVS version 0 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: gcomm: connecting to group 'galera_cluster', peer '172.20.1.56:,172.20.1.57:,17 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Warning] WSREP: (b5e7b88e, 'tcp://0.0.0.0:4567') address 'tcp://172.20.1.56:4567' points to Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:43 140510611449984 [Warning] WSREP: no nodes coming from prim view, prim not possible Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:43 140510611449984 [Note] WSREP: view(view_id(NON_PRIM,b5e7b88e,1) memb { Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: b5e7b88e,0 Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: } joined { Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: } left { Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: } partitioned { Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: }) Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:43 140510611449984 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.50184S), skipping check Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:15:13 140510611449984 [Note] WSREP: view((empty)) Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:15:13 140510611449984 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view: 11 Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: at gcomm/src/pc.cpp:connect():162 Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:15:13 140510611449984 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():208: Failed to open backend connection: - Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:15:13 140510611449984 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1379: Failed to open channel 'galera_cluster' at 'g Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:15:13 140510611449984 [ERROR] WSREP: gcs connect failed: Connection timed out Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:15:13 140510611449984 [ERROR] WSREP: wsrep::connect(gcomm://172.20.1.56,172.20.1.57,172.20.1.58) failed: 7 Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:15:13 140510611449984 [ERROR] Aborting Jun 12 11:15:14 mariadb-N1.intelligene.local systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE Jun 12 11:15:14 mariadb-N1.intelligene.local systemd[1]: Failed to start MariaDB database server. -- Subject: Unit mariadb.service has failed -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-with-galera-on-redhat-72-not-starting/

1 0

[Maria-discuss] New Question: MariaDB Galera cluster gtid's falling out of sync inspite of setting wsrep_cluster
by AskMonty KB 11 Jun '16

11 Jun '16

Hello, A new question has been asked in "MariaDB Community" by kk1674. Please answer it at http://mariadb.com/kb/en/mariadb-galera-cluster-gtids-falling-out-of-sync-i… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have asynchronous replication between 2 clusters (calling master cluster, slave cluster). As expected a node in the slave cluster receives async replication and galera transmits to the rest of the nodes of the slave cluster. When the gtid counter is being incremented on the nodes of this slave cluster, the node acting as the slave node is keeping track of master server id and incrementing the gtid by wsrep_domain_id, server_id, galera counter+1. However the other nodes of the slave cluster are not keeping track of the server id variable and increment gtid by wsrep_domain_id, galera counter+1. See below Slave node of the slave cluster show variables like '%gtid%'; +------------------------+-------------------------+ | Variable_name | Value | +------------------------+-------------------------+ | gtid_binlog_pos | 2-100-36261 | | gtid_binlog_state | 2-200-36263,2-100-36261 | | gtid_current_pos | 1-100-36261 | | gtid_domain_id | 22 | | gtid_ignore_duplicates | OFF | | gtid_seq_no | 0 | | gtid_slave_pos | 1-100-36261 | | gtid_strict_mode | OFF | | last_gtid | 2-200-36263 | | wsrep_gtid_domain_id | 2 | | wsrep_gtid_mode | ON | +------------------------+-------------------------+ 11 rows in set (0.00 sec) Another node in the slave cluster show variables like '%gtid%'; +------------------------+-------------------------+ | Variable_name | Value | +------------------------+-------------------------+ | gtid_binlog_pos | 2-100-36265 | | gtid_binlog_state | 2-200-36264,2-100-36265 | | gtid_current_pos | 1-100-36259 | | gtid_domain_id | 22 | | gtid_ignore_duplicates | OFF | | gtid_seq_no | 0 | | gtid_slave_pos | 1-100-36259 | | gtid_strict_mode | OFF | | last_gtid | | | wsrep_gtid_domain_id | 2 | | wsrep_gtid_mode | ON | +------------------------+-------------------------+ 11 rows in set (0.00 sec) This behavior has been noted in MariaDB 10.1.11, 10.1.13 and 10.1.14. In 10.1.11, gtid_slave_pos table is being replicated by galera hence if the slave node goes down it is possible to move the slave process to another node, by first setting the gtid_slave_pos variable. However starting 10.1.13 the table is not longer being replicated I see it as a fix for another issue agreeably, but now there is no means to determine the slave position to be able to start replication on another node of the cluster. Can this behavior be classified as bug and a bug request opened? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-galera-cluster-gtids-falling-out-of-sync-i…

1 0

[Maria-discuss] New Question: MariaDB relocatable rpm packages
by AskMonty KB 10 Jun '16

10 Jun '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-relocatable-rpm-packages/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I want to know if the mariadb 10.1.13 packages are relocatable or not as i want to install the rpm packages in some other directory rather than the default installation directory. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-relocatable-rpm-packages/

1 0

[Maria-discuss] Event types in performance schema
by Rhys.Campbell＠swisscom.com 10 Jun '16

10 Jun '16

Hi All, I'm doing some stuff with the performance_Schema and have a quick question about event types. These appear in the events_statements_summary_by_account_by_event_name table (and others) and look like... statement/com/Ping statement/sql/select statement/sql/insert statement/sql/commit statement/sql/update Am I correct in thinking the COMMIT type would be a total of all the events of a transaction. So if we did something like... START TRANSACTION SELECT EVENT UPDATE EVENT INSERT EVENT DELETE EVENT COMMIT The performance_schema would log this as EVENTS for SELECT, UPDATE, INSERT and DELETE individual times. While the COMMIT would be a sum of these times? Cheers, Rhys

2 1

[Maria-discuss] New Question: MyISAM plus INNODB enable query cache?
by AskMonty KB 09 Jun '16

09 Jun '16

Hello, A new question has been asked in "MariaDB Community" by chrismatthews. Please answer it at http://mariadb.com/kb/en/myisam-plus-innodb-enable-query-cache/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- We have 2GB of MyISAM plus 2GB INNODB data. Running MariaDB 10.* Should we enable or disable query_cache ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/myisam-plus-innodb-enable-query-cache/

1 0

[Maria-discuss] AUTO_COMMIT=0 for a session - READ inconsistencyi - ssue or no issue
by Karthick Subramanian 09 Jun '16

09 Jun '16

Observation: If we set the AUTOCOMMIT=0 in a session, then in that session, I noticed a data inconsistency. Whatever data committed in other sessions, when we select in this session showing until we start any new transaction in this session. The moement we sstart any new transaction in this session, then its not showing any latest data for a table (data inserted by other sessions) in this session, unless we explicitly issue the commit. Usually AUTOCOMMIT=0 means any specific transactions in that session will be visible to other sessions only when we explicitly issue a COMMIT, but we can read a consistent data from that session. It doesn't seem to be working. Is this my misunderstanding on how a Transaction management works or a bug? Session 1: MariaDB [employees]> select * from tab; Empty set (0.00 sec) MariaDB [employees]> INSERT INTO tab -> (c1, c2) -> VALUES -> ('a1', 'a11'); Query OK, 1 row affected, 1 warning (0.00 sec) MariaDB [employees]> select * from tab; +------+------+ | c1 | c2 | +------+------+ | a1 | a1 | +------+------+ 1 row in set (0.00 sec) MariaDB [employees]> Session 2: MariaDB [employees]> select * from tab; +------+------+ | c1 | c2 | +------+------+ | a1 | a1 | +------+------+ 1 row in set (0.00 sec) MariaDB [employees]> INSERT INTO tab -> (c1, c2) -> VALUES -> ('a2', 'a22'); Query OK, 1 row affected, 1 warning (0.01 sec) MariaDB [employees]> select * from tab; +------+------+ | c1 | c2 | +------+------+ | a1 | a1 | | a2 | a2 | +------+------+ 2 rows in set (0.00 sec) back to Session 1: MariaDB [employees]> select * from tab; +------+------+ | c1 | c2 | +------+------+ | a1 | a1 | | a2 | a2 | +------+------+ 2 rows in set (0.00 sec) Back to session 2: MariaDB [employees]> set auto_commit=0; ERROR 1193 (HY000): Unknown system variable 'auto_commit' MariaDB [employees]> set autocommit=0; Query OK, 0 rows affected (0.00 sec) MariaDB [employees]> Move to Session 3: MariaDB [employees]> select * from tab; +------+------+ | c1 | c2 | +------+------+ | a1 | a1 | | a2 | a2 | +------+------+ 2 rows in set (0.00 sec) MariaDB [employees]> Move to session 1: MariaDB [employees]> INSERT INTO tab -> (c1, c2) -> VALUES -> ('a3', 'a33'); Query OK, 1 row affected, 1 warning (0.00 sec) MariaDB [employees]> select * from tab; +------+------+ | c1 | c2 | +------+------+ | a1 | a1 | | a2 | a2 | | a3 | a3 | +------+------+ 3 rows in set (0.01 sec) Move to session 2: MariaDB [employees]> select * from tab; +------+------+ | c1 | c2 | +------+------+ | a1 | a1 | | a2 | a2 | | a3 | a3 | +------+------+ 3 rows in set (0.00 sec) Move to Session 3: MariaDB [employees]> select * from tab; +------+------+ | c1 | c2 | +------+------+ | a1 | a1 | | a2 | a2 | | a3 | a3 | +------+------+ 3 rows in set (0.00 sec) Across all 3 sessions, the data is consistent. Move to session 1: MariaDB [employees]> INSERT INTO tab -> (c1, c2) -> VALUES -> ('a4', 'a44'); Query OK, 1 row affected, 1 warning (0.00 sec) MariaDB [employees]> select * from tab; +------+------+ | c1 | c2 | +------+------+ | a1 | a1 | | a2 | a2 | | a3 | a3 | | a4 | a4 | +------+------+ 4 rows in set (0.00 sec) Move to Session 2: MariaDB [employees]> INSERT INTO tab -> (c1, c2) -> VALUES -> ('a5', 'a55'); Query OK, 1 row affected, 1 warning (0.01 sec) MariaDB [employees]> INSERT INTO tab -> (c1, c2) -> VALUES -> ('a6', 'a66'); Query OK, 1 row affected, 1 warning (0.00 sec) MariaDB [employees]> select * from tab; +------+------+ | c1 | c2 | +------+------+ | a1 | a1 | | a2 | a2 | | a3 | a3 | | a5 | a5 | | a6 | a6 | +------+------+ 5 rows in set (0.00 sec) a4 record is missing here in session 2 - inconsistency started. move to session 3: MariaDB [employees]> select * from tab; +------+------+ | c1 | c2 | +------+------+ | a1 | a1 | | a2 | a2 | | a3 | a3 | | a4 | a4 | +------+------+ 4 rows in set (0.00 sec) In Session 3 - a5 and a6 records are mising because in session 2 - autocommit=0, so its expected that a5 and a6 are missing in session1,3. BUT, why in session 2, the a4 record is missing?

2 2

[Maria-discuss] New Question: MariaDB installation in a different directory using RPMs
by AskMonty KB 09 Jun '16

09 Jun '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-installation-in-a-different-directory-usin… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I am trying to install MariaDB using RPMs packages in a user created directory but i am not able to do it. Is it possible to do it?? i have tried --prefix option but couldnt start the mysql service and also yum --installroot option but couldnt start the service. Please suggest a way to do it if its possible -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-installation-in-a-different-directory-usin…

1 0

[Maria-discuss] New Question: how to install ColumnStore?
by AskMonty KB 08 Jun '16

08 Jun '16

Hello, A new question has been asked in "ColumnStore" by robertsilen. Please answer it at http://mariadb.com/kb/en/how-to-install-columnstore/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- how do I install ColumnStore? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-install-columnstore/

1 0