Hello.
Not enough information to make a conclusion. What version of
MySQL do you use? Usually debugging of replication problems
begins from researching of binary logs with mysqlbinlog. See:
http://dev.mysql.com/doc/mysql/en/mysqlbinlog.html
http://dev.mysql.com/doc/mysql/en/slave-logs.html
http://dev.mysql.com/doc/mysql/en/binary-log.html
Please, next time include the output of SHOW SLAVE STATUS
(executed on the slave) and SHOW MASTER STATUS (executed on
the master) as well.
"Weicheng Pan" <[EMAIL PROTECTED]> wrote:
> Hi all:
> I have replication problem on my FreeBSD 5.4 AMD64 box.
> Sometimes replication will stop and throw an error code 1054,
> but the query is not the original one in the master.
> A query like UPDATE table_a SET col_a = 'abc' where col_b = 234
> the right most character will become a strange character, and cannot print
> out in error log.
> I have twelve machines doing the replication work, but only got problem on
> this AMD64 machine.
> Anyone has encounter this type problem? please give me some advise.
>
> Thanks and have a nice day.
>
> Regards,
> Weicheng.
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
