Hello.
I suggest you to check what query was written to the master binary log
and then report a bug. Please include all information you've found in the
report.
"Weicheng Pan" <[EMAIL PROTECTED]> wrote:
> 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 ---
--
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]
