468,554 Members | 1,972 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,554 developers. It's quick & easy.

Roll back problems

Hi,

I am rolling back a transaction that (up to the rollback command) has
inserted into two tables, both of which are type InnoDB. I am getting the
warning:

"Warning: Some non-transactional changed tables couldn't be rolled back"

I check the database and it seems to have rolled back all the changes I
expected it to make, so why is this error occurring. I am using MySQL
4.0.18; is it a a minor known bug? Is there "hidden" tables that it is
updating that might be causing this warning?

Thanks for any info

Andy Hall.
Jul 20 '05 #1
1 4484
Andy,

you should write to my***@lists.mysql.com. These newsgroups are mostly just
mirrors of mailing lists.

You get the error:

"Warning: Some non-transactional changed tables couldn't be rolled back"

when MyISAM tables were involved in the transaction. Please check with

SHOW CREATE TABLE tablename;

that your tables indeed are of the InnoDB type.

Best regards,

Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php

Order MySQL technical support from https://order.mysql.com/

"Andy Hall" <an*******@btconnect.com> kirjoitti viestissä
news:ci**********@titan.btinternet.com...
Hi,

I am rolling back a transaction that (up to the rollback command) has
inserted into two tables, both of which are type InnoDB. I am getting the
warning:

"Warning: Some non-transactional changed tables couldn't be rolled back"

I check the database and it seems to have rolled back all the changes I
expected it to make, so why is this error occurring. I am using MySQL
4.0.18; is it a a minor known bug? Is there "hidden" tables that it is
updating that might be causing this warning?

Thanks for any info

Andy Hall.

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Peter Sands | last post: by
reply views Thread by MajorTom | last post: by
1 post views Thread by Dan | last post: by
1 post views Thread by elma.arsalan | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by UniDue | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.