Yes we faced the same prbs with 5.0.24, pls upgrade to 5.0.37 community / Darshan
----- Original Message ----- From: "Baron Schwartz" <[EMAIL PROTECTED]> To: "Tim Lucia" <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED], mysql@lists.mysql.com Sent: Saturday, April 14, 2007 6:53:17 PM (GMT+0530) Asia/Calcutta Subject: Re: MySQL slave error when creating view Sounds like a bug to me. It's likely fixed in newer versions; a lot of view/function/sproc replication bugs have been fixed. But if not, you should report it. Tim Lucia wrote: > Nobody has any idea(s) on this? > >> -----Original Message----- >> From: Tim Lucia [mailto:[EMAIL PROTECTED] >> Sent: Friday, April 06, 2007 7:11 PM >> To: [EMAIL PROTECTED] >> Subject: MySQL slave error when creating view >> >> >> I ran the following DDL on our master today: >> >> CREATE OR REPLACE VIEW REF_TRANSFER_PREFERENCE ( >> IORG_UID, TDISTRICT_NAME, IORGDISPLAY, IORG ) AS >> SELECT >> 0, TDISTRICT_NAME, IORG_UID, IORG_UID >> FROM REF_PREFERENCE >> ; >> >> The master happily created the view. The slave however dies with: >> >> 070405 10:48:23 [ERROR] Slave: Error 'Duplicate column name 'IORG_UID'' on >> query. Default database: 'pildb'. Query: 'CREATE OR REPLACE >> ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL SECURITY DEFINER VIEW >> `REF_TRANSFER_PREFERENCE` AS SELECT 0, TDISTRICT_NAME, IORG_UID, IORG_UID >> FROM REF_PREFERENCE', Error_code: 1060 >> >> I can work around it by redefining the view DDL as: >> >> CREATE OR REPLACE VIEW REF_TRANSFER_PREFERENCE ( >> IORG_UID, TDISTRICT_NAME, IORGDISPLAY, IORG ) AS >> SELECT >> 0 as IORG_UID, TDISTRICT_NAME, IORG_UID as IORGDISPLAY, IORG_UID as >> IORG >> FROM REF_PREFERENCE >> ; >> >> And the slave is happy. Is this a bug? Anyone care to comment? >> >> CONFIGURATION: >> storage_engine MyISAM >> table_type MyISAM >> updatable_views_with_limit YES >> version 5.0.24-standard-log >> version_comment MySQL Community Edition - Standard (GPL) >> version_compile_machine x86_64 >> version_compile_os unknown-linux-gnu >> >> Thanks, >> Tim >> >> >> >> >> >> -- >> MySQL Replication Mailing List >> For list archives: http://lists.mysql.com/replication >> To unsubscribe: >> http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- MySQL Replication Mailing List For list archives: http://lists.mysql.com/replication To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]