Not the answer you need?
Register and ask your own question!

master-master replication fails on "duplicate partition name" error

JuriMJuriM EntrantCurrent User Role Beginner
Hi,

Server version: 5.6.25-73.1-log Percona Server (GPL), Release 73.1, Revision 07b797f
High load database, master-master cross replication between two nodes on innodb tables, innodb_file_per_table is on, binary format is row.
At least one time at day, the both slaves fail to run on statement "Error 'Duplicate partition name p20150818' on query. Default database: 'db'. Query: 'ALTER TABLE fc_ticks REORGANIZE PARTITION pmax INTO ( PARTITION p20150818 VALUES LESS THAN(1439931600), PARTITION pmax VALUES LESS THAN( MAXVALUE ) )'
It's similar to https://bugs.mysql.com/bug.php?id=47343 and I can reproduce this error on my test nodes, but replication does not fail in my case.
Any ideas? I'm in stuck.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.