"tsa" is actually the database. It's running the function "AddSchool()", and
it appears that something went wrong in that situation. The actual table
affected inside the function is "school", and that table does exist on both
master and slave.
If by "general log", you mean the log named machine.err, I've checked that file
on both master and slave, and there is no reference there at all to a
"AddSchool(" function error. Other than that, I don't see that any other logs
are activated (other than the binary logs, of course).
Jesse
----- Original Message -----
From: Ananda Kumar
To: Jesse
Cc: MySQL List
Sent: Tuesday, August 26, 2008 12:55 AM
Subject: Re: Error stops replication
does tsa table exists on both master and slave.
If you have enabled general log, then u can see most of the errors.
I am suspecting that this table is not present in slave
On 8/26/08, Jesse <[EMAIL PROTECTED]> wrote:
I have been getting an error which stops replication on my slave server.
The error is as follows:
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 '' at line 1' on
query. Default database: 'tsa'. Query: 'SELECT
`tsa`.`AddSchool`(_latin1'Grenada High School',_latin1'2','
The thing is that I'm not getting an error on the master server, to my
knowledge. When I check the error log, there is no such error in there. Does
the "Machine.err" file log these sort of errors? If not, where can I look to
see if it is happening on the master server?
I'm running version 5.0.67-community-nt on the slave and version
5.0.51a-nt-log on the master.
If anyone has any ideas on what might be causing this, please let me know
what you think.
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
