Sandbox mode won't work with rails 7.2

[shouichi]

I recently upgraded our app (console1984 installed) to rails 7.2 and realized that the sandbox mode did not work. It worked fine when rails 7.1.

The problem seems like calling reconnect! without restore_transactions: true. I added the option and sandbox mode worked again. Furthermore, the sandbox mode breaks if I call ApplicationRecord.connection.reconnect! in a working sandboxed rails console.

console1984/lib/console1984/sessions_logger/database.rb

Line 64 in f7b85df

Console1984::Command.connection.reconnect! unless Console1984::Command.connection.active?

See also #91.

[shouichi]

I changed to use a different DB to store audit logs (followed #91 (comment)) and everything works as expected.