auto rollback if pages written to wal and query failed