HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   General (http://www.howtoforge.com/forums/forumdisplay.php?f=25)
-   -   fix broken replication (http://www.howtoforge.com/forums/showthread.php?t=60414)

MaddinXx 2nd February 2013 16:56

fix broken replication
 
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!

till 4th February 2013 11:51

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.

MaddinXx 4th February 2013 12:26

Puh thanks Till, that worked!

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


All times are GMT +2. The time now is 15:16.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.