Subject | Question about transactions |
---|---|
Author | W O |
Post date | 2013-01-06T22:33:30Z |
Hello everybody, I have a question:
- Transaction 510 inserts a row
- Transaction 510 commit
- Transaction 526 start
- Transaction 526 updates the row inserted by transaction 510
- Transaction 535 start
- Transaction 535 updates the row inserted by transaction 510
- Transaction 542 start
- Transaction 542 updates the row inserted by transaction 510
1. Should be the order for the following commits: 526, 535, 542?
2. Or in some cases it could be 542, 535, 526?
If the answer is 1. it means that if transaction 526 hangs up will avoid
transactions 535 and 542 to finish. Am I right?
Greetings.
Walter.
[Non-text portions of this message have been removed]
- Transaction 510 inserts a row
- Transaction 510 commit
- Transaction 526 start
- Transaction 526 updates the row inserted by transaction 510
- Transaction 535 start
- Transaction 535 updates the row inserted by transaction 510
- Transaction 542 start
- Transaction 542 updates the row inserted by transaction 510
1. Should be the order for the following commits: 526, 535, 542?
2. Or in some cases it could be 542, 535, 526?
If the answer is 1. it means that if transaction 526 hangs up will avoid
transactions 535 and 542 to finish. Am I right?
Greetings.
Walter.
[Non-text portions of this message have been removed]