||2nd February 2013 17:56
fix broken replication
I get the following error on all slaves, preventing them from updating:
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?
||4th February 2013 12: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.
||4th February 2013 13: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 03:49.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.