Marc Herbert <[EMAIL PROTECTED]> writes: >> So before inserting a new record, it reads the max id >> value in the table and increases it by one for the new id. After >> insertion opertaion, TPCW commits transaction. MySQL server works >> correctly with the operation. >> But with Sequoia, it looks like the operation deosn't perform >> automicly and the read operatation sometimes is stale.
> This should work iff the backend transactionIsolation level is > REPEATABLE_READ or above, with or without sequoia. Sorry this is wrong, I overlooked the scenario: REPEATABLE_READ is not enough. You need a full SERIALIZABLE isolation level for this to be thread-safe since a predicate read is involved. _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
