Hi! I think that the problem that MySQL complains about an uncommitted open transaction in RENAME TABLE has been reported before. I will take a look at this. The fix will probably be in 3.23.52.
The behavior that you cannot roll back a RENAME TABLE is as expected. To perform a data dictionary operation MySQL spins off a transaction which is separate from the current user transaction. Also most other DBMS brands do not provide rollback on CREATE TABLE or DROP TABLE, for example. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com ----- Original Message ----- From: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, July 31, 2002 2:14 AM Subject: Re: InnoDB, replication and create table w/3.23.51? > > > I can reproduce the problem with (on the master): > > > > create table foo (a int); > > rename table foo to foobar; > > > > Then the slave dies. Is this a known problem? I couldn't find > > anything at google or the list archives, but I've been off the list > > for a while. Is there a workaround? > > i think just to type : slave start .... will solve the problem ... just wait till the table is not in locking condition ... > > -- > prom_printf("Detected PenguinPages, getting out of here.\n"); > 2.0.38 /usr/src/linux/arch/sparc/mm/srmmu.c > > MySQL 3.23.51 : up 39 days, Queries : 354.555 per second (avg). > > -- > Dicky Wahyu Purnomo - System Administrator > PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) > Phone : +62 21 79199577 - Web : http://1rstwap.com > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
