Dear Gleb:
The problem has occured again, and I grab some output.
This box run mysql 4.1.11 on FreeBSD 5.4 AMD64, with 8GB RAM
In this case,
The original query is "INSERT INTO LOW_PRIORTY INTO `statistics`.`search`
(`userid`, `id`, `func`) VALUES('lty0105', '8', 2)"
The strange query is "'INSERT LOW_PRIORITY INTO `statistics`.`search` (
`userid` , `id` , `func` ) VALUES ( 'lty0105', '8', 2p)"
Slave server got a strange character 'p' after character '2'
Slave:
mysql> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: db0
Master_User: repl
Master_Port: 3306
Connect_Retry: 5
Master_Log_File: db0-bin.000056
Read_Master_Log_Pos: 755005566
Relay_Log_File: db10-relay-bin.000060
Relay_Log _Pos: 572461705
Relay_Master_Log_File: db0-bin.000056
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB: blog,album_database
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table: album_database.%,blog.%
Last_Errno: 1054
Last_Error: Error 'Unknown column '2p' in 'field list'' on
query. Default database: ''. Query: 'INSERT LOW_PRIORITY INTO
`statistics`.`search` ( `userid` , `id` , `func` ) VALUES ( 'lty0105', '8',
2p)'
Skip_Counter: 0
Exec_Master_Log_Pos: 692584947
Relay_Log_Space: 634882324
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)
Master:
mysql> show master status\G;
*************************** 1. row ***************************
File: db0-bin.000056
Position: 761127837
Binlog_Do_DB:
Binlog_Ignore_DB:
1 row in set (0.00 sec)
Finally I dump the slave log:
[EMAIL PROTECTED] [ /home/mysql ]> mysqlbinlog db10-relay-bin.000060 | grep "(
'lty0105', '8', 2p)"
INSERT LOW_PRIORITY INTO `statistics`.`search` ( `userid` , `id` , `func` )
VALUES ( 'lty0105', '8', 2p);
[EMAIL PROTECTED] [ /home/mysql ]>
With best regards,
Weicheng.
----- Original Message -----
From: "Gleb Paharenko" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Monday, May 30, 2005 5:20 PM
Subject: Re: Replication problem
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
