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)
-   -   SQL Replication Error (http://www.howtoforge.com/forums/showthread.php?t=38684)

Gimly 31st August 2009 18:44

SQL Replication Error
 
Hi All,

I've an error with the sql replication

Quote:

mail.espace4you.org Error Replication failed. Error: (client) in mysql server: (localhost) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near [...]

I've delete client which do this error.

So and I want to know is there a way to delete this replication sql job because this error returns every minute and it block my jobqueue ...



Thanks in advance for your help

till 1st September 2009 11:42

Find the corresponding item in the sys_datalog table on the master and the slave server(s) and delete it there.

Is the above the complete error message? Does it not contain the failed sql query?

Gimly 1st September 2009 14:48

Hi Till,

Thanks for your reply.

In ISPConfig the message is complete but it contains data about an user.

I test delete error in sys_datalog and now it work :)

till 1st September 2009 15:23

Did you update ISPConfig on all servers to 3.0.1.4b2 or just on the master?

Gimly 1st September 2009 16:56

On all servers. Why ?

till 1st September 2009 17:07

On all servers is fine. If you would have installed it only on the master, this would explain the replication error.

Gimly 1st September 2009 23:43

Ok, thanks Till for the info :)


All times are GMT +2. The time now is 03:14.

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