***BOGO*** Re: Error stops replication

["Ananda Kumar" <anandkl@xxxxxxxxx>]

general log is different from machine.err log, it stores all logs of the db.




On 8/26/08, Jesse <jc@xxxxxxxxx> wrote:
>
>  "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 <anandkl@xxxxxxxxx>
> *To:* Jesse <jc@xxxxxxxxx>
> *Cc:* MySQL List <mysql@xxxxxxxxxxxxxxx>
> *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 <jc@xxxxxxxxx> 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/mysql?unsub=anandkl@xxxxxxxxx
>>
>>
>