Forum: Ruby on Rails SQL transaction rollback isn't logged !

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
David M. (Guest)
on 2009-02-05 11:33
(Received via mailing list)
I'm finding that if I do something like this:

     X.transaction { X.create(...); raise('stop') }

Then I see the INSERT statement in my logs, but I don't see the BEGIN
or END for the transaction, or the ROLLBACK.

The transaction is definitely working:  Without the raise(), the X
object is created; with the raise(), it is not.  In both cases, the
log is identical, which makes debugging a bit confusing.

I'm using sqlite3 in development mode in an out of the box setup on a
mac.

Is there some way I can turn up the SQL logging level to include log
entries for transaction rollback events?  Or is there some good reason
I don't understand why this isn't done?
This topic is locked and can not be replied to.