Details
-
Type:
Bug
-
Status: Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 10.1.6
-
Fix Version/s: None
-
Component/s: Galera
-
Labels:None
-
Environment:centos 6.x
Description
I tried to install spider on one node of cluster, (cluster fully syncronized on 3 node).
normally the command source '/path/to/file.sql', (the query inside should executed in 3 nodes and it's wasn't the case on my case, or special things for plugins ? (i tried it with install for spider) I will make a new test now with some query.
So the cluster is no more syncronized with command 'source'; (I didn't saw that on limitations)
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
yeah source /path/to/install_spider.sql was not replicated on all node
Aurélien LEQUOY Can you attach install_spider.sql here? What commands
does it have? What storage engines are involved?
I ran a simple test and 'source' worked as expected :
Node 1:
MariaDB [test]> show tables;
Empty set (0.00 sec)
MariaDB [test]> \! cat /tmp/data.sql
create table test.t1(i int) engine=innodb;
insert into test.t1 values(1), (2), (3), (4), (5);
MariaDB [test]> source /tmp/data.sql
Query OK, 0 rows affected (0.18 sec)
Query OK, 5 rows affected (0.04 sec)
Records: 5 Duplicates: 0 Warnings: 0
Node 2:
MariaDB [test]> select * from t1; +------+ | i | +------+ | 1 | | 2 | | 3 | | 4 | | 5 | +------+ 5 rows in set (0.00 sec)
Nirbhay Choubey, maybe you will understand more from the description of the problem, I am not quite sure I interpret it correctly.
My understanding is this:
There was a fully synchronized 3-node Galera cluster (apparently with 10.1.6 MariaDB on each node).
Then 'source /path/to/install_spider.sql/' was executed on one node.
Either none or not all of SQL commands from the file were replicated to other nodes.