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

["Jesse" <jc@xxxxxxxxx>]

Where can I find a "general log" if I've got one running?  What's it's file name, and where it is usually located?

Thanks,
Jesse
  ----- Original Message ----- 
  From: Ananda Kumar 
  To: Jesse 
  Cc: MySQL List 
  Sent: Tuesday, August 26, 2008 8:03 AM
  Subject: Re: Error stops replication


  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 
      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 <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