List:General Discussion« Previous MessageNext Message »
From:Jesse Date:August 27 2008 11:32am
Subject:Re: Error stops replication
View as plain text  
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@stripped> 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@stripped> 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=1






Thread
Error stops replicationJesse25 Aug
  • Re: Error stops replicationAnanda Kumar26 Aug
  • Re: Error stops replicationJesse26 Aug
    • Re: Error stops replicationAnanda Kumar26 Aug
  • Re: Error stops replicationJesse27 Aug