MySQL transactions not working in unit tests?

I just installed acts_as_authenticated into an app and one of its unit
tests is failing. The cause is that another unit test's changes to the
AAA fixtures aren't being rolled back. I'm confused, since I have
transactional fixtures turned on and MySQL InnoDB engine being used.

- MySQL 5.0.24. InnoDB is the default engine, all tables in the test
db are using the InnoDB engine.
- Stock AAA unit tests.
- The unit test in question, test_should_reset_password, succeeds when
run by itself, fails when run with all of the unit tests. (I'm using
autotest, so when I touch the unit test file, I see the test succeed
in isolation, then the same test fails when run with all of the
- test.log clearly shows the unit tests being wrapped in BEGIN/
- If I modify the other unit test, test_should_not_rehash_password, to
explicitly undo the db changes it does, all tests pass, in isolation
and collectively.
- I have slightly modified AAA's User model, but I can't see how the
modifications could come into play in this case. (This is integrating
into a legacy database with some different conventions.)

Code at

Any suggestions are much appreciated! (I don't have enough hair to be
pulling so much out!)


BTW, turning off transactional fixtures in test_helper.rb results in
all AAA tests passing. Turn back on, they fail. For now, that's my
workaround. Slower tests, but they work as I expect them to.


Check that your tables are InnoDB and not MyISAM.

Yep. As I said in the initial post: