- 论坛徽章:
- 0
|
1,版本相同都是,
| version | 5.1.32-log |
| version_comment | Source distribution |
| version_compile_machine | x86_64 |
| version_compile_os | unknown-freebsd7.2
2,slave上的err日志
090806 15:19:28 [ERROR] Slave SQL: Table definition on master and slave does not match: Column 5 size mismatch - master has size 96, TESTdb1.Testtable1 on slave has size 4. Master's column size should be <= the slave's column size. Error_code: 1535
090806 15:19:28 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000001' position 176642
3,show create table相同
mysql> show create table TESTdb1.Testtable1\G
*************************** 1. row ***************************
Table: Testtable1
Create Table: CREATE TABLE `Testtable1` (
`f_index_id` bigint(20) NOT NULL AUTO_INCREMENT,
`f_stag` varchar(32) NOT NULL DEFAULT '',
`f_id` varchar(32) NOT NULL DEFAULT '',
`f_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`f_log_type` tinyint(1) NOT NULL DEFAULT '0',
`f_processed` char(1) DEFAULT '0',
PRIMARY KEY (`f_index_id`),
KEY `stag` (`f_stag`,`f_id`,`f_time`)
) ENGINE=MyISAM AUTO_INCREMENT=114288 DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
4,安装时./configure也相同,
这些郁闷了
谢谢各位关注 |
|