- 论坛徽章:
- 0
|
我用的是:mysql 5.1.61 同步:mysql 5.0.95.
刚配好时,是好的。用了一会,数据变大了,就把错了。
server-id = 2
##############
log-bin=mysql-bin
log-bin=/var/log/mysql/updatelog
binlog-do-db=test
max_binlog_size=1048576000
replicate-same-server-id
master-host=172.16.1.112
master-user=backup
master-password=qawsed
master-port=3306
master-connect-retry=60
replicate-do-db=posp
binlog-ignore-db=mysql
slave_skip_errors = 1062
skip-name-resolve
max_connections=1000
max_connect_errors=100
mysql> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 172.16.1.112
Master_User: backup
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: updatelog.000001
Read_Master_Log_Pos: 1028145
Relay_Log_File: mysqld-relay-bin.000002
Relay_Log_Pos: 638838
Relay_Master_Log_File: updatelog.000001
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB: posp
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 1054
Last_Error: Error 'Unknown column 'large_small_flag' in 'field list'' on query. Default database: 'posp'. Query: 'UPDATE `acq_merchant` SET `large_small_flag`='0' WHERE (`id`='1')'
Skip_Counter: 0
Exec_Master_Log_Pos: 693399
Relay_Log_Space: 974033
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
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 1054
Last_SQL_Error: Error 'Unknown column 'large_small_flag' in 'field list'' on query. Default database: 'posp'. Query: 'UPDATE `acq_merchant` SET `large_small_flag`='0' WHERE (`id`='1')'
1 row in set (0.00 sec)
ERROR:
No query specified
############
报错日志:
130426 10:57:37 [Note] Slave I/O thread killed while reading event
130426 10:57:37 [Note] Slave I/O thread exiting, read up to log 'updatelog.000001', position 997828
130426 10:57:39 [Note] Slave SQL thread initialized, starting replication in log 'updatelog.000001' at position 693399, relay log './mysqld-relay-bin.000002' position: 638838
130426 10:57:39 [ERROR] Slave SQL: Error 'Unknown column 'large_small_flag' in 'field list'' on query. Default database: 'posp'. Query: 'UPDATE `acq_merchant` SET `large_small_flag`='0' WHERE (`id`='1')', Error_code: 1054
130426 10:57:39 [Warning] Slave: Unknown column 'large_small_flag' in 'field list' Error_code: 1054
130426 10:57:39 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'updatelog.000001' position 693399
130426 10:57:39 [Note] Slave I/O thread: connected to master 'backup@172.16.1.112:3306',replication started in log 'updatelog.000001' at position 997828
那位高人帮忙看下。
网上说的重起change master to 我弄了,也是得一会,半个小时后,又会报同样的错。 |
|