Aah. That helps.The reason I couldn't find a reference to "AddSchool(" was
that it's "`AddSchool`(". I should have searched for just "AddSchool", and
I would have found it. I did a search for just "Indianola Career &
Technical Center", though, and found the place.
One of the parameters was left blank somehow, which begs the question, why
didn't this "blow up" on the master system? I never got a notice of an
error, and can't find anything in the logs about that. There is nothing in
the event log in Windows either. Very strange.
Now, here's another question. The position indicated by the log dump is
193074. Pretty close to the Exec_Master_Log_Pos setting of 193018, but
enough to cause confusion. Any ideas why the log position would be
different than what was reported by SHOW SLAVE STATUS?
Thanks,
Jesse
----- Original Message -----
From: "Ceccotti, Eric M" <eric.m.ceccotti@stripped>
To: "Jesse" <jc@stripped>
Sent: Wednesday, August 27, 2008 3:03 PM
Subject: RE: Replication Error - Need HELP tracking
> Hmmm...can you run the mysqlbinlog utility and filter / parse the
> events? I know in Linux I can run binlog and send / pipe it to a GREP
> (filter) utility that only shows events that match the filter.
>
> In windows you may just need to export (>) the entire log to a text file
> then use an editor to search for strings that match something like
> "latin1'Indianola Career & Technical Center',_latin1'2"
>
>
> Thanks,
> Eric Ceccotti
> Midrange Standards & Integrated Engineering
> SQL Server / MySQL Database Engineering
> Office: 860-725-2327
>
> This communication (including attachments) is confidential and protected
> from disclosure. It is intended only for the addressee. If you are not
> the intended recipient, you may not copy, disclose, or distribute this
> message to anyone else; any such actions may be unlawful. If you have
> received this communication in error, please contact the sender of the
> message to inform him or her of the error and permanently delete this
> e-mail (including attachments) from your computer system.
>
> -----Original Message-----
> From: Jesse [mailto:jc@stripped]
> Sent: Wednesday, August 27, 2008 1:43 PM
> To: Ceccotti, Eric M
> Cc: replication@stripped
> Subject: Re: Replication Error - Need HELP tracking
>
> Thanks for the reply. Here's the output from that:
>
> D:\Program Files\MySQL\MySQL Server 5.0\data>..\bin\mysqlbinlog
> mysql-bin.000001
> --start-position=220368 --stop-position=220368
> /*!40019 SET @@session.max_insert_delayed_threads=0*/;
> /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
> DELIMITER /*!*/;
> DELIMITER ;
> # End of log file
> ROLLBACK /* added by mysqlbinlog */;
> /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
>
> Looks identical to me??? I've got to be doing something wrong here, or
> something is not set up correctly. Any ideas?
>
> Jesse
>
> ----- Original Message -----
> From: "Ceccotti, Eric M" <eric.m.ceccotti@stripped>
> To: "Jesse" <jc@stripped>
> Sent: Wednesday, August 27, 2008 1:18 PM
> Subject: RE: Replication Error - Need HELP tracking
>
>
>> Hey Jesse,
>> Try using Read_Master_Log_Pos: 220368 instead.
>>
>>
>> Thanks,
>> Eric Ceccotti
>> Midrange Standards & Integrated Engineering
>> SQL Server / MySQL Database Engineering
>> Office: 860-725-2327
>>
>> This communication (including attachments) is confidential and
> protected
>> from disclosure. It is intended only for the addressee. If you are not
>> the intended recipient, you may not copy, disclose, or distribute this
>> message to anyone else; any such actions may be unlawful. If you have
>> received this communication in error, please contact the sender of the
>> message to inform him or her of the error and permanently delete this
>> e-mail (including attachments) from your computer system.
>>
>> -----Original Message-----
>> From: Jesse [mailto:jc@stripped]
>> Sent: Wednesday, August 27, 2008 10:58 AM
>> To: replication@stripped
>> Subject: Replication Error - Need HELP tracking
>>
>> OK. I've reset replication several times, and this error keeps
> popping
>> up and breaking replication, so I need to figure out what the issue
> is.
>> On the slave, I ran a "SHOW SLAVE STATUS", and here's the output from
>> that:
>>
>> mysql> show slave status\G
>> *************************** 1. row ***************************
>> Slave_IO_State: Waiting for master to send event
>> Master_Host: 76.229.75.185
>> Master_User: replication
>> Master_Port: 3316
>> Connect_Retry: 60
>> Master_Log_File: mysql-bin.000001
>> Read_Master_Log_Pos: 220368
>> Relay_Log_File: dlgsrv-relay-bin.000022
>> Relay_Log_Pos: 26518
>> Relay_Master_Log_File: mysql-bin.000001
>> Slave_IO_Running: Yes
>> Slave_SQL_Running: No
>> Replicate_Do_DB:
>> Replicate_Ignore_DB:
>> Replicate_Do_Table:
>> Replicate_Ignore_Table:
>> Replicate_Wild_Do_Table:
>> Replicate_Wild_Ignore_Table:
>> Last_Errno: 1064
>> Last_Error: Error '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'Indianola Career & Technical Center',_latin1'2','
>> Skip_Counter: 0
>> Exec_Master_Log_Pos: 193018
>> Relay_Log_Space: 53868
>> Until_Condition: None
>> Until_Log_File:
>> Until_Log_Pos: 0
>> Master_SSL_Allowed: No
>> Master_SSL_CA_File:
>> Master_SSL_CA_Path:
>> Master_SSL_Cert:
>> Master_SSL_Cipher:
>> Master_SSL_Key:
>> Seconds_Behind_Master: NULL
>> 1 row in set (0.00 sec)
>>
>> OK. My first question is this. I want to track down the command on
> the
>> master that caused this error.There was no error on the Master, this
>> error occurred on the slave. So, looking at the output, am I
> correcting
>> in assuming that I need to use the mysqlbinlog utility to view the
> event
>> located at position 193018 in the mysql-bin.000001 file? If not,
> please
>> let me know. If so, here's what I get when I execute the following
>> command:
>>
>> D:\Program Files\MySQL\MySQL Server 5.0\data>..\bin\mysqlbinlog
>> mysql-bin.000001
>> --start-position=193018 --stop-position=193018
>> /*!40019 SET @@session.max_insert_delayed_threads=0*/;
>> /*!50003 SET
> @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
>> DELIMITER /*!*/;
>> DELIMITER ;
>> # End of log file
>> ROLLBACK /* added by mysqlbinlog */;
>> /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
>>
>> This log entry would seem to have nothing what-so-ever to do with the
>> error above??? What did I do wrong here?
>>
>> Thanks for any help anyone can offer.
>>
>> Jesse
>>
>>
>>
>> --
>> MySQL Replication Mailing List
>> For list archives: http://lists.mysql.com/replication
>> To unsubscribe:
>>
> http://lists.mysql.com/replication?unsub=1
>> om
>>
>>
>
>
