No PowerDNS replication taking place and in “show slave status \G;” command in mysql, the errors were noted:
To resolve this, set the SQL_Slave_Skip_Counter to 1 in mysql with the following command. First log into the PowerDNS server using SSH.
Set Global SQL_Slave_Skip_Counter = 1 ;
Show Slave Status \G;
Is the Error is still present, try running the command again and increment the value from 1 to 2 and so on. If you’re tired of the trial and error test, try putting in 100 or a larger number.