List:General Discussion« Previous MessageNext Message »
From:Jay Ess Date:December 7 2004 11:57pm
Subject:Replication update bug/error/problem.
View as plain text  
I have a problem with an update query not replicating through to the slave.

The query is "update content_review_site as a,site_rating_factors as b set 
a.overall_rating = 77 where a.content_id=243"

Version : 4.0.22
OS : Linux X86

How to replicate the error.

CREATE TABLE content_review_site (
   content_id int(11) unsigned NOT NULL default '0',
   site_id int(10) unsigned NOT NULL default '0',
   overall_rating float(4,2) unsigned NOT NULL default '0.00',
   rating_software_and_graphics tinyint(4) unsigned NOT NULL default '0',
   rating_game_variety tinyint(4) unsigned NOT NULL default '0',
   rating_maximum_bonus tinyint(4) unsigned NOT NULL default '0',
   rating_bonus_match tinyint(4) unsigned NOT NULL default '0',
   rating_wagering_requirements tinyint(4) unsigned NOT NULL default '0',
   rating_payout_ratio tinyint(4) unsigned NOT NULL default '0',
   rating_multiplayer_games tinyint(4) unsigned NOT NULL default '0',
   rating_loyalty_bonus tinyint(4) unsigned NOT NULL default '0',
   rating_deposit_withdrawal_options tinyint(4) unsigned NOT NULL default '0',
   rating_support tinyint(4) unsigned NOT NULL default '0',
   rating_progressive_jackpots tinyint(4) unsigned NOT NULL default '0',
   rating_languages tinyint(4) unsigned NOT NULL default '0',
   rating_reputation_fairness tinyint(4) unsigned NOT NULL default '0',
   rating_free_bonus tinyint(4) unsigned NOT NULL default '0',
   create_ts datetime NOT NULL default '0000-00-00 00:00:00',
   modify_ts datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY  (content_id,site_id)
) TYPE=MyISAM;

CREATE TABLE site_rating_factors (
   site_id int(11) unsigned NOT NULL default '0',
   factor_software_and_graphics tinyint(4) unsigned NOT NULL default '0',
   factor_game_variety tinyint(4) unsigned NOT NULL default '0',
   factor_bonus_amount tinyint(4) unsigned NOT NULL default '0',
   factor_bonus_clauses tinyint(4) unsigned NOT NULL default '0',
   factor_payout_ratio tinyint(4) unsigned NOT NULL default '0',
   factor_multiplayer_games tinyint(4) unsigned NOT NULL default '0',
   factor_loyalty_bonus tinyint(4) unsigned NOT NULL default '0',
   factor_deposit_withdrawal_options tinyint(4) unsigned NOT NULL default '0',
   factor_support tinyint(4) unsigned NOT NULL default '0',
   factor_graphics tinyint(4) unsigned NOT NULL default '0',
   factor_progressive_jackpots tinyint(4) unsigned NOT NULL default '0',
   factor_languages tinyint(4) unsigned NOT NULL default '0',
   factor_reputation_fairness tinyint(4) unsigned NOT NULL default '0',
   factor_free_bonus tinyint(4) unsigned NOT NULL default '0',
   create_ts datetime NOT NULL default '0000-00-00 00:00:00',
   modify_ts datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY  (site_id)
) TYPE=MyISAM;

insert into site_rating_factors values (1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,now(),now());
insert into content_review_site values 
(243,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,now(),now());

On the slave get the data with "load data from master".
Both slave and master shows :
+------------+----------------+
| content_id | overall_rating |
+------------+----------------+
|        243 |           1.00 |
+------------+----------------+

update content_review_site set overall_rating = 666;
updates the tables just fine on both slave and master.

But the troubling query below does NOT it only updates on the master.

update content_review_site as a,site_rating_factors as b set a.overall_rating = 
77 where a.content_id=243;




Any suggestions?
Thread
Replication update bug/error/problem.Jay Ess8 Dec
  • Re: Replication update bug/error/problem.Eric Bergen8 Dec
    • Re: Replication update bug/error/problem.Jay Ess8 Dec
      • Re: Replication update bug/error/problem.Ware Adams9 Dec