fix broken replication

Discussion in 'General' started by MaddinXx, Feb 2, 2013.

  1. MaddinXx

    MaddinXx Member HowtoForge Supporter

    I get the following error on all slaves, preventing them from updating:

    Code:
    02.02.2013-15:53 - ERROR - Replication failed. Error: (nginx_reverse_proxy_plugin) in MySQL server: (localhost) Table 'dbispconfig.nginx_reverse_proxy_plugin' doesn't exist # SQL: REPLACE INTO nginx_reverse_proxy_plugin (`setting_id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`vhost_config_dir`,`vhost_config_dir_enabled`,`port`) VALUES ('1','1','1','riud','riud','','/etc/nginx/sites-available','/etc/nginx/sites-enabled','/etc/nginx/sites-enabled')
    02.02.2013-15:53 - ERROR - Error in Replication, changes were not processed.
    I created a module but deleted it afterwards, manually deleting the table in the ISPConfig DB. Is their a way to resolve this?

    Thanks!
     
  2. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    1) ensure that you removed the table in the master and slave database.
    2) Edit the server record of this slave in the server table on the master server and set the value in the updated column to a sys_datalog_id value from sys_datalog table that is higher then the one that you want to skip. If you dont know which record to skip, then use the max value of the sys_datalog_id column.
     
    Last edited: Feb 4, 2013
  3. MaddinXx

    MaddinXx Member HowtoForge Supporter

    Puh thanks Till, that worked!

    I better leave my fingers from the DB from now on :rolleyes:
     

Share This Page