Re: MySQL Replicaiton Slave Halts on Bulk insert from master
Hi James,
Please find the show full processlist during the issue occurrence.
mysql> show full processlist\G
*************************** 1. row ***************************
Id: 755
User: system user
Host:
db: NULL
Command: Connect
Time: 45613
State: Waiting for master to send event
Info: NULL
*************************** 2. row ***************************
Id: 756
User: system user
Host:
db: abc_por
Command: Connect
Time: 4847
State: update
Info: insert into mimik_history (external_transaction_id, step_index, rollback, message, context, result_code, mimik_batch_id) values ('184010', 4, '0', null, 'REQUEST_RECEIVED', null, 184010)
2. Application team said that we have <2000 inserts during this time.
3. Show create Table
mysql> SHOW CREATE TABLE mimik_history;
+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| mimik_history | CREATE TABLE `mimik_history` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`mimik_batch_id` int(10) unsigned NOT NULL,
`external_transaction_id` varchar(50) DEFAULT NULL,
`step_index` tinyint(3) unsigned DEFAULT NULL,
`ROLLBACK` enum('1','0') DEFAULT NULL,
`message` varchar(1024) DEFAULT NULL,
`context` enum('REQUEST_RECEIVED','IN_FLIGHT','COMPENSATION_IN_FLIGHT','COMPLETED','COMPENSATION_COMPLETED','ENTITY_LOCKED','NOT_FOUND','SEE_MESSAGE') NOT NULL DEFAULT 'REQUEST_RECEIVED',
`result_code` char(5) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `ind_mimik_batch_id` (`mimik_batch_id`),
KEY `ind_external_transaction_id` (`external_transaction_id`),
CONSTRAINT `fk_mimik_gh__mimik_batch__id` FOREIGN KEY (`mimik_batch_id`) REFERENCES `mimik_batch` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1855086 DEFAULT CHARSET=latin1 COMMENT='mimik operation history base' |
+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
4. Schema is identical on both the servers.
Thanks for the Support
Regards
Karthik R