Roll back problems

[Andy Hall]

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.

[Heikki Tuuri]

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.