centos 6.x

nirbhay_c, 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.

yeah source /path/to/install_spider.sql was not replicated on all node

Aurelien_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)