Hi Raghav, Below is my my.cnf. ## Galera wsrep_provider = /usr/lib64/libgalera_smm.so wsrep_cluster_address = gcomm://10.34.38.139,10.34.38.140,10.34.38.141 wsrep_slave_threads = 2 wsrep_cluster_name = nydn wsrep_sst_method = rsync wsrep_node_name = proddb1 binlog_format = ROW innodb_locks_unsafe_for_binlog = 1 innodb_autoinc_lock_mode = 2 wsrep_node_address = 10.34.38.139 wsrep_sst_receive_address = 10.34.38.139 and log at the time of crash is.. len 224; hex 1875f200732b0000390e8136712b0000003a84e46e2b00000000000000000000000000000000000000000000000000000300000000000000020000000000000001000000 0000000000000000000000000000000000000000000000000000000001000000000000000000000000000000cf6de7bf2617fd260000000000000000010000000000000083445107000000 004eb41940732b000002000000000000000100000000000000003a84e46e2b0000375602000000000060e11177000000000200000000000000b827f7110000000048b41940732b00001800 000000000000; asc u s+ 9 6q+ : n+ m & & DQ N @s+ : n+ 7V ` w ' H @s+ ; TRANSACTION DF93DF1F, ACTIVE 1 sec fetching rows mysql tables in use 2, locked 1 252 lock struct(s), heap size 31160, 2807 row lock(s), undo log entries 2735 MySQL thread id 12740606, OS thread handle 0x2b73275e2940, query id 378424606 69.167.130.6 mcwusa preparing UPDATE `table_a` SET `app_status` = 'D', `load_status` = 'D' WHERE ( guid IN (SELECT DISTINCT gallery_id FROM table_b WHERE app_status='A' OR app_status='N') AND feed_id !=21) 140203 4:06:41 InnoDB: Assertion failure in thread 47773581715776 in file btr0pcur.c line 257 table_a - +--------------------+---------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+---------------+------+-----+---------------------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | feed_id | int(11) | NO | MUL | NULL | | | category_name | varchar(255) | NO | MUL | NULL | | | title | varchar(255) | YES | MUL | NULL | | | image | longtext | YES | | NULL | | | image_land | longtext | YES | | NULL | | | image_thumb | longtext | YES | | NULL | | | url | varchar(255) | YES | | NULL | | | bitly_url | varchar(255) | YES | | NULL | | | status | enum('1','0') | YES | | 1 | | | one_liner | longtext | YES | | NULL | | | description | text | YES | | NULL | | | guid | varchar(255) | YES | MUL | NULL | | | author | varchar(255) | YES | | NULL | | | pub_date | datetime | YES | MUL | NULL | | | load_status | varchar(10) | YES | MUL | NULL | | | app_status | varchar(10) | YES | MUL | NULL | | | image_author | varchar(255) | YES | | NULL | | | image_caption | text | YES | | NULL | | | timestamp | timestamp | NO | | CURRENT_TIMESTAMP | | | in_order_id | int(11) | YES | MUL | NULL | | | image_count | int(11) | YES | | NULL | | | ti_article_updated | timestamp | YES | | 0000-00-00 00:00:00 | | +--------------------+---------------+------+-----+---------------------+----------------+ Table_b +-------------+---------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------+------+-----+-------------------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | gallery_id | varchar(500) | NO | MUL | NULL | | | title | longtext | YES | | NULL | | | caption | longtext | YES | | NULL | | | credit | longtext | YES | | NULL | | | image | longtext | YES | | NULL | | | datetime | timestamp | NO | | CURRENT_TIMESTAMP | | | status | enum('1','0') | NO | | 1 | | | in_order_id | int(11) | YES | | NULL | | | load_status | varchar(10) | YES | | NULL | | | app_status | varchar(10) | YES | | NULL | | +-------------+---------------+------+-----+-------------------+----------------+ 11 rows in set (0.00 sec)