Cacti Replication is getting stopped

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Moderators, Developers

Post Reply
Author
Message
dchandan
Posts: 4
Joined: Fri Dec 21, 2018 1:45 am

Cacti Replication is getting stopped

#1 Post by dchandan » Fri Dec 21, 2018 1:53 am

Hello I have 2 Cacti Server with master and slave setup. I am getting error in replication status of mariadb.

Last_SQL_Error: Could not execute Update_rows_v1 event on table microcacti.poller_item; Can't find record in 'poller_item', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log master-bin.000015, end_log_pos 520565013

Please help.

netniV
Cacti Guru User
Posts: 3020
Joined: Sun Aug 27, 2017 12:05 am

Re: Cacti Replication is getting stopped

#2 Post by netniV » Fri Dec 21, 2018 5:46 am

I have never setup the replication between two databases in MariaDB/MySQL but looking at the error, this would suggest that your basic table structures are not in sync. When I have done mirroring before with MSSQL that required a backup/restore to ensure the same database was being used for mirroring.

Have you made sure that both sets of tables are in sync? And that the user being used to perform the sync has access to both?

User avatar
Osiris
Cacti Pro User
Posts: 883
Joined: Mon Jan 05, 2015 10:10 am

Re: Cacti Replication is getting stopped

#3 Post by Osiris » Mon Dec 31, 2018 6:48 pm

I would suggest galera on a 10.2 or 10.3 instance of MariaDB.
Before history, there was a paradise, now dust.

Post Reply