MySQL Forums
Forum List  »  Replication

Re: MySQL Replicaiton Slave Halts on Bulk insert from master
Posted by: Karthik Ramakrishnan
Date: August 19, 2016 09:57AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL Replicaiton Slave Halts on Bulk insert from master
772
August 19, 2016 09:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.