query on master: USE `sas-ru`; CREATE TABLE analytics_sections_categories( id INT(11) NOT NULL AUTO_INCREMENT, section_id SMALLINT(6) NOT NULL, category_id SMALLINT(6) NOT NULL, PRIMARY KEY (section_id, category_id), INDEX FK_analytics_category (category_id), UNIQUE INDEX id (id), CONSTRAINT FK_analytics_category FOREIGN KEY (category_id) REFERENCES analytics_category (id) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT FK_analytics_section FOREIGN KEY (section_id) REFERENCES analytics_section (id) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = INNODB CHARACTER SET utf8 COLLATE utf8_general_ci; USE `site-ru-v4`; CREATE TABLE analytics_sections_categories( id INT(11) NOT NULL AUTO_INCREMENT, section_id SMALLINT(6) NOT NULL, category_id SMALLINT(6) NOT NULL, PRIMARY KEY (section_id, category_id), INDEX FK_analytics_category (category_id), UNIQUE INDEX id (id), CONSTRAINT FK_analytics_category FOREIGN KEY (category_id) REFERENCES analytics_category (id) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT FK_analytics_section FOREIGN KEY (section_id) REFERENCES analytics_section (id) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = INNODB CHARACTER SET utf8 COLLATE utf8_general_ci; I`ve emulate those situation and get error. Here is records in binlog /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 4 #120203 5:25:06 server id 125009144 end_log_pos 107 Start: binlog v 4, server v 5.5.18-55-log created 120203 5:25:06 # Warning: this binlog is either in use or was not closed properly. BINLOG ' klMrTw/4fHMHZwAAAGsAAAABAAQANS41LjE4LTU1LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA== '/*!*/; # at 555729637 #120203 13:23:00 server id 125009144 end_log_pos 555729859 Query thread_id=3657294 exec_time=0 error_code=0 SET TIMESTAMP=1328268180/*!*/; SET @@session.pseudo_thread_id=3657294/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=0/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C utf8 *//*!*/; SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=33/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; UPDATE `phpmyadmin`.`pma_tracking` SET `tracking_active` = '0' WHERE `db_name` = 'sas-ru' AND `table_name` = 'analytics_sections_categories' AND `version` = '0' /*!*/; # at 555729859 #120203 13:23:00 server id 125009144 end_log_pos 555729924 Query thread_id=3657294 exec_time=0 error_code=0 SET TIMESTAMP=1328268180/*!*/; COMMIT /*!*/; # at 555729924 #120203 13:23:01 server id 125009144 end_log_pos 555730600 Query thread_id=3657295 exec_time=0 error_code=0 use site-ru-v4/*!*/; SET TIMESTAMP=1328268181/*!*/; CREATE TABLE analytics_sections_categories( id INT(11) NOT NULL AUTO_INCREMENT, section_id SMALLINT(6) NOT NULL, category_id SMALLINT(6) NOT NULL, PRIMARY KEY (section_id, category_id), INDEX FK_analytics_category (category_id), UNIQUE INDEX id (id), CONSTRAINT FK_analytics_category FOREIGN KEY (category_id) REFERENCES analytics_category (id) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT FK_analytics_section FOREIGN KEY (section_id) REFERENCES analytics_section (id) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = INNODB CHARACTER SET utf8 COLLATE utf8_general_ci /*!*/; DELIMITER ; # End of log file ROLLBACK /* added by mysqlbinlog */; /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; in relay logs on slave /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 4 #120201 15:34:26 server id 10251053 end_log_pos 107 Start: binlog v 4, server v 5.5.18-55-log created 120201 15:34:26 BINLOG ' Yj8pTw8ta5wAZwAAAGsAAAAAAAQANS41LjE4LTU1LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA== '/*!*/; # at 150 #120203 5:25:06 server id 125009144 end_log_pos 107 Start: binlog v 4, server v 5.5.18-55-log created 120203 5:25:06 BINLOG ' klMrTw/4fHMHZwAAAGsAAAAAAAQANS41LjE4LTU1LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA== '/*!*/; # at 555725141 #120203 13:23:00 server id 125009144 end_log_pos 555725059 Query thread_id=3657294 exec_time=0 error_code=0 SET TIMESTAMP=1328268180/*!*/; SET @@session.pseudo_thread_id=3657294/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=0/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C utf8 *//*!*/; SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=33/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; # at 555725205 #120203 13:23:00 server id 125009144 end_log_pos 555729508 Query thread_id=3657294 exec_time=0 error_code=0 SET TIMESTAMP=1328268180/*!*/; /*NOTRACK*/ INSERT INTO`phpmyadmin`.`pma_tracking` (db_name, table_name, version, date_created, date_updated, schema_snapshot, schema_sql, data_sql, tracking ) values ( 'sas-ru', 'analytics_sections_categories', '1', '2012-02-03 11:23:00', '2012-02-03 11:23:00', 'a:2:{s:7:"COLUMNS";a:3:{i:0;a:18:{i:0;s:2:"id";s:5:"Field";s:2:"id";i:1;s:7:"int(11)";s:4:"Type";s:7:"int(11)";i:2;N;s:9:"Collation";N;i:3;s:2:"NO";s:4:"Null";s:2:"NO";i:4;s:3:"UNI";s:3:"Key";s:3:"UNI";i :5;N;s:7:"Default";N;i:6;s:14:"auto_increment";s:5:"Extra";s:14:"auto_increment";i:7;s:31:"select,insert,update,references";s:10:"Privileges";s:31:"select,insert,update,references";i:8;s:0:"";s:7:"Comment";s:0:"" ;}i:1;a:18:{i:0;s:10:"section_id";s:5:"Field";s:10:"section_id";i:1;s:11:"smallint(6)";s:4:"Type";s:11:"smallint(6)";i:2;N;s:9:"Collation";N;i:3;s:2:"NO";s:4:"Null";s:2:"NO";i:4;s:3:"PRI";s:3:"Key";s:3:"PRI";i:5; N;s:7:"Default";N;i:6;s:0:"";s:5:"Extra";s:0:"";i:7;s:31:"select,insert,update,references";s:10:"Privileges";s:31:"select,insert,update,references";i:8;s:0:"";s:7:"Comment";s:0:"";}i:2;a:18:{i:0;s:11:"category_id";s:5:"Field";s:11:"category_id";i:1;s:11:"smallint(6)";s:4:"Type";s:11:"smallint(6)";i:2;N;s:9:"Collation";N;i:3;s:2:"NO";s:4:"Null";s:2:"NO";i:4;s:3:"PRI";s:3:"Key";s:3:"PRI";i:5;N;s:7:"Default";N;i:6;s:0:"";s:5:"Extra";s:0:"";i:7;s:31:"select,insert,update,references";s:10:"Privileges";s:31:"select,insert,update,references";i:8;s:0:"";s:7:"Comment";s:0:"";}}s:7:"INDEXES";a:4:{i:0;a:26:{i:0;s:29:"analytics_sections_categories";s:5:"Table";s:29:"analytics_sections_categories";i:1;s:1:"0";s:10:"Non_unique";s:1:"0";i:2;s:7:"PRIMARY";s:8:"Key_name";s:7:"PRIMARY";i:3;s:1:"1";s:12:"Seq_in_index";s:1:"1";i:4;s:10:"section_id";s:11:"Column_name";s:10:"section_id";i:5;s:1:"A";s:9:"Collation";s:1:"A";i:6;s:1:"0";s:11:"Cardinality";s:1:"0";i:7;N;s:8:"Sub_part";N;i:8;N;s:6:"Packed";N;i:9;s:0:"";s:4:"Null";s:0:"";i:10;s:5:"BTREE";s:10:"Index_type";s:5:"BTREE";i:11;s:0:"";s:7:"Comment";s:0:"";i:12;s:0:"";s:13:"Index_comment";s:0:"";}i:1;a:26:{i:0;s:29:"analytics_sections_categories";s:5:"Table";s:29:"analytics_sections_categories";i:1;s:1:"0";s:10:"Non_unique";s:1:"0";i:2;s:7:"PRIMARY";s:8:"Key_name";s:7:"PRIMARY";i:3;s:1:"2";s:12:"Seq_in_index";s:1:"2";i:4;s:11:"category_id";s:11:"Column_name";s:11:"category_id";i:5;s:1:"A";s:9:"Collation";s:1:"A";i:6;s:1:"0";s:11:"Cardinality";s:1:"0";i:7;N;s:8:"Sub_part";N;i:8;N;s:6:"Packed";N;i:9;s:0:"";s:4:"Null";s:0:"";i:10;s:5:"BTREE";s:10:"Index_type";s:5:"BTREE";i:11;s:0:"";s:7:"Comment";s:0:"";i:12;s:0:"";s:13:"Index_comment";s:0:"";}i:2;a:26:{i:0;s:29:"analytics_sections_categories";s:5:"Table";s:29:"analytics_sections_categories";i:1;s:1:"0";s:10:"Non_unique";s:1:"0";i:2;s:2:"id";s:8:"Key_name";s:2:"id";i:3;s:1:"1";s:12:"Seq_in_index";s:1:"1";i:4;s:2:"id";s:11:"Column_name";s:2:"id";i:5;s:1:"A";s:9:"Collation";s:1:"A";i:6;s:1:"0";s:11:"Cardinality";s:1:"0";i:7;N;s:8:"Sub_part";N;i:8;N;s:6:"Packed";N;i:9;s:0:"";s:4:"Null";s:0:"";i:10;s:5:"BTREE";s:10:"Index_type";s:5:"BTREE";i:11;s:0:"";s:7:"Comment";s:0:"";i:12;s:0:"";s:13:"Index_comment";s:0:"";}i:3;a:26:{i:0;s:29:"analytics_sections_categories";s:5:"Table";s:29:"analytics_sections_categories";i:1;s:1:"1";s:10:"Non_unique";s:1:"1";i:2;s:21:"FK_analytics_category";s:8:"Key_name";s:21:"FK_analytics_category";i:3;s:1:"1";s:12:"Seq_in_index";s:1:"1";i:4;s:11:"category_id";s:11:"Column_name";s:11:"category_id";i:5;s:1:"A";s:9:"Collation";s:1:"A";i:6;s:1:"0";s:11:"Cardinality";s:1:"0";i:7;N;s:8:"Sub_part";N;i:8;N;s:6:"Packed";N;i:9;s:0:"";s:4:"Null";s:0:"";i:10;s:5:"BTREE";s:10:"Index_type";s:5:"BTREE";i:11;s:0:"";s:7:"Comment";s:0:"";i:12;s:0:"";s:13:"Index_comment";s:0:"";}}}', '# log 2012-02-03 11:23:00 config_root DROP TABLE IF EXISTS `analytics_sections_categories`; # log 2012-02-03 11:23:00 config_root CREATE TABLE `analytics_sections_categories` ( `id` int(11) NOT NULL AUTO_INCREMENT, `section_id` smallint(6) NOT NULL, `category_id` smallint(6) NOT NULL, PRIMARY KEY (`section_id`,`category_id`), UNIQUE KEY `id` (`id`), KEY `FK_analytics_category` (`category_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ', ' ', 'CREATE TABLE,ALTER TABLE,DROP TABLE,RENAME TABLE,CREATE INDEX,DROP INDEX,CREATE VIEW,ALTER VIEW,DROP VIEW,CREATE DATABASE,ALTER DATABASE,DROP DATABASE' ) /*!*/; # at 555729654 #120203 13:23:00 server id 125009144 end_log_pos 555729573 Query thread_id=3657294 exec_time=0 error_code=0 SET TIMESTAMP=1328268180/*!*/; COMMIT /*!*/; # at 555729719 #120203 13:23:00 server id 125009144 end_log_pos 555729637 Query thread_id=3657294 exec_time=0 error_code=0 SET TIMESTAMP=1328268180/*!*/; BEGIN /*!*/; # at 555729783 #120203 13:23:00 server id 125009144 end_log_pos 555729859 Query thread_id=3657294 exec_time=0 error_code=0 SET TIMESTAMP=1328268180/*!*/; UPDATE `phpmyadmin`.`pma_tracking` SET `tracking_active` = '0' WHERE `db_name` = 'sas-ru' AND `table_name` = 'analytics_sections_categories' AND `version` = '0' /*!*/; # at 555730005 #120203 13:23:00 server id 125009144 end_log_pos 555729924 Query thread_id=3657294 exec_time=0 error_code=0 SET TIMESTAMP=1328268180/*!*/; COMMIT /*!*/; DELIMITER ; # End of log file ROLLBACK /* added by mysqlbinlog */; /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; (END)