mysql bin log replication stopped with error

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

bin log replication has stopped and we are running out of disk space.

error:Last_SQL_Error: Error 'Duplicate partition name XXXXXX' on query. Default database: 'em'. Query: 'ALTER TABLE `event_identifiers` REORGANIZE PARTITION pMAX INTO (PARTITION XXXXX VALUES LESS THAN (1621296000), PARTITION pMAX VALUES LESS THAN MAXVALUE)'

 

 

Environment

Dx NetOps Performance Management any version

Cause

The event scheduler was started on the backup server, when this happens you will get an error as the production system has already done that work. So when the backup goes to do that work, the files are already moved/altered. This causes mysql to throw errors.

 

Resolution

Turn off event scheduler on the backup system

You can also set it not to start it on system startup, by editing the /etc/my.cnf file

#Turn on Event Scheduler
event_scheduler=OFF