Group replication insert problem
Hi,
We're using MySQL 5.7.18 with group replication.
We have 3 servers and allow writes to all 3, however atm we only write to the first one:
192.168.140.51
When doing some initial tests all works fine, however we took a mysqldump of 1.2 gb and seem to have issues to import it.
2017-07-05T12:15:15.630725+01:00 0 [Warning] Plugin group_replication reported: 'The member with address 192.168.140.51:3306 has already sent the stable set. Therefore discarding the second message.'
2017-07-05T12:15:15.885455+01:00 0 [Warning] Plugin group_replication reported: 'The member with address 192.168.140.52:3306 has already sent the stable set. Therefore discarding the second message.'
2017-07-05T12:15:53.567919+01:00 0 [Warning] Plugin group_replication reported: 'The member with address 192.168.140.51:3306 has already sent the stable set. Therefore discarding the second message.'
2017-07-05T12:16:05.306101+01:00 0 [Warning] Plugin group_replication reported: 'The member with address 192.168.140.52:3306 has already sent the stable set. Therefore discarding the second message.'
If we use smaller inserts we have no issues , if we remove the:
LOCK TABLES `xxx` WRITE;
It's working better already with manual tests, but the whole import still hangs on a query like:
INSERT INTO `xxx` VALUES (
3,
'2010-09-24 10:47:16',
'2017-07-04 00:00:00',
1,
9245,
'etam',
'Etam',
'Sampledata
',
'ddd',
'ddd',
'ddd',
'5',
'5',
'5',
'5'),(
4,
'2010-09-24 10:47:16',
'2017-07-04 00:00:00',
1,
9246,
'etam',
'Etam',
'Sampledata2
',
'ddd',
'ddd',
'ddd',
'5',
'5',
'5',
'5'),
(...)
;
Table looks like this:
DROP TABLE IF EXISTS `xxx`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xxx` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`created_on` datetime NOT NULL,
`last_updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`domainset_id` mediumint(8) unsigned NOT NULL,
`program_id` mediumint(8) unsigned NOT NULL,
`ref` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`text_fr` text COLLATE utf8_unicode_ci NOT NULL,
`icon` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`pinterest` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`average_pending_order_delay` int(11) NOT NULL DEFAULT '3',
`average_validated_order_delay` int(11) NOT NULL DEFAULT '3',
`total_validated_orders_count` int(11) NOT NULL DEFAULT '0',
`total_pending_orders_count` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `domainset_id` (`domainset_id`),
KEY `program_id` (`program_id`)
) AUTO_INCREMENT=4166 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
We have no clue what could be wrong or how to fix this situation, any help would appreciated.