MySQL Forums
Forum List  »  Replication

Group replication insert problem
Posted by: Jo Goossens
Date: July 05, 2017 04:26AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Group replication insert problem
1172
July 05, 2017 04:26AM


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.