2006-05-10 15:43:47 |
Diogo Matsubara |
bug |
|
|
added bug |
2006-05-10 15:44:08 |
Diogo Matsubara |
launchpad: assignee |
|
stub |
|
2006-05-10 15:44:08 |
Diogo Matsubara |
launchpad: statusexplanation |
|
|
|
2006-05-20 19:01:28 |
Diogo Matsubara |
description |
Sometimes we see out of order sql queries that trigger foreign key constraints on the DB.
As reference:
OOPS-119B108
OOPS-123A293
OOPS-123B35
OOPS-125B55
OOPS-129D177
And:
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008784.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008906.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008938.html |
Sometimes we see out of order sql queries that trigger foreign key constraints on the DB.
As reference:
OOPS-119B108
OOPS-123A293
OOPS-123B35
OOPS-125B55
OOPS-129D177
OOPS-139D917
And:
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008784.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008906.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008938.html |
|
2006-05-22 08:53:58 |
Stuart Bishop |
launchpad: status |
Unconfirmed |
In Progress |
|
2006-05-22 14:02:48 |
Stuart Bishop |
launchpad: status |
In Progress |
Fix Committed |
|
2006-05-23 12:55:54 |
Diogo Matsubara |
description |
Sometimes we see out of order sql queries that trigger foreign key constraints on the DB.
As reference:
OOPS-119B108
OOPS-123A293
OOPS-123B35
OOPS-125B55
OOPS-129D177
OOPS-139D917
And:
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008784.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008906.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008938.html |
Sometimes we see out of order sql queries that trigger foreign key constraints on the DB.
As reference:
OOPS-119B108
OOPS-123A293
OOPS-123B35
OOPS-125B55
OOPS-129D177
OOPS-139D917
OOPS-142A582
And:
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008784.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008906.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008938.html |
|
2006-05-24 04:12:41 |
Stuart Bishop |
launchpad: status |
Fix Committed |
In Progress |
|
2006-05-29 21:25:33 |
Diogo Matsubara |
description |
Sometimes we see out of order sql queries that trigger foreign key constraints on the DB.
As reference:
OOPS-119B108
OOPS-123A293
OOPS-123B35
OOPS-125B55
OOPS-129D177
OOPS-139D917
OOPS-142A582
And:
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008784.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008906.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008938.html |
Sometimes we see out of order sql queries that trigger foreign key constraints on the DB.
As reference:
OOPS-119B108
OOPS-123A293
OOPS-123B35
OOPS-125B55
OOPS-129D177
OOPS-139D917
OOPS-142A582
OOPS-147C2751
And:
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008784.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008906.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008938.html |
|
2006-05-30 13:56:28 |
Diogo Matsubara |
description |
Sometimes we see out of order sql queries that trigger foreign key constraints on the DB.
As reference:
OOPS-119B108
OOPS-123A293
OOPS-123B35
OOPS-125B55
OOPS-129D177
OOPS-139D917
OOPS-142A582
OOPS-147C2751
And:
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008784.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008906.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008938.html |
Sometimes we see out of order sql queries that trigger foreign key constraints on the DB.
As reference:
OOPS-119B108
OOPS-123A293
OOPS-123B35
OOPS-125B55
OOPS-129D177
OOPS-139D917
OOPS-142A582
OOPS-147C2751
OOPS-149C143
And:
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008784.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008906.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008938.html |
|
2006-05-30 13:59:48 |
Diogo Matsubara |
description |
Sometimes we see out of order sql queries that trigger foreign key constraints on the DB.
As reference:
OOPS-119B108
OOPS-123A293
OOPS-123B35
OOPS-125B55
OOPS-129D177
OOPS-139D917
OOPS-142A582
OOPS-147C2751
OOPS-149C143
And:
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008784.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008906.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008938.html |
Sometimes we see out of order sql queries that trigger foreign key constraints on the DB.
As reference:
OOPS-119B108
OOPS-123A293
OOPS-123B35
OOPS-125B55
OOPS-129D177
OOPS-139D917
OOPS-142A582
OOPS-147C2751
OOPS-149C143
OOPS-149C784
And:
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008784.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008906.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008938.html |
|
2006-06-07 16:18:43 |
Guilherme Salgado |
description |
Sometimes we see out of order sql queries that trigger foreign key constraints on the DB.
As reference:
OOPS-119B108
OOPS-123A293
OOPS-123B35
OOPS-125B55
OOPS-129D177
OOPS-139D917
OOPS-142A582
OOPS-147C2751
OOPS-149C143
OOPS-149C784
And:
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008784.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008906.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008938.html |
Sometimes we see out of order sql queries that trigger foreign key constraints on the DB.
As reference:
OOPS-53B84
OOPS-119B108
OOPS-123A293
OOPS-123B35
OOPS-125B55
OOPS-129D177
OOPS-139D917
OOPS-142A582
OOPS-147C2751
OOPS-149C143
OOPS-149C784
And:
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008784.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008906.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008938.html |
|
2006-06-08 17:19:46 |
Guilherme Salgado |
description |
Sometimes we see out of order sql queries that trigger foreign key constraints on the DB.
As reference:
OOPS-53B84
OOPS-119B108
OOPS-123A293
OOPS-123B35
OOPS-125B55
OOPS-129D177
OOPS-139D917
OOPS-142A582
OOPS-147C2751
OOPS-149C143
OOPS-149C784
And:
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008784.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008906.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008938.html |
Sometimes we see OOPSes with foreign key constraint violations (OOPS-119B108) and AttributeErrors (OOPS-53B84), either when referencing newly created objects on a foreign key or when accessing attributes of the newly created objects right after their creation. The SQL Statement Log confirms that the queries are being issued in the right order, so this could be caused by having a single thread using more than one connection ID.
As reference:
OOPS-53B84
OOPS-119B108
OOPS-123A293
OOPS-123B35
OOPS-125B55
OOPS-129D177
OOPS-139D917
OOPS-142A582
OOPS-147C2751
OOPS-149C143
OOPS-149C784
And:
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008784.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008906.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008938.html |
|
2006-06-08 17:19:46 |
Guilherme Salgado |
title |
Out of order SQL queries triggering foreign key constraints |
Possible use of more than one connection ID on a single thread may be the cause of many OOPSes |
|
2006-07-14 21:13:03 |
Stuart Bishop |
launchpad: assignee |
stub |
stevea |
|
2006-07-14 21:13:03 |
Stuart Bishop |
launchpad: statusexplanation |
|
Steve - should you have this for the doomed transactions? |
|
2006-07-14 21:16:11 |
Stuart Bishop |
description |
Sometimes we see OOPSes with foreign key constraint violations (OOPS-119B108) and AttributeErrors (OOPS-53B84), either when referencing newly created objects on a foreign key or when accessing attributes of the newly created objects right after their creation. The SQL Statement Log confirms that the queries are being issued in the right order, so this could be caused by having a single thread using more than one connection ID.
As reference:
OOPS-53B84
OOPS-119B108
OOPS-123A293
OOPS-123B35
OOPS-125B55
OOPS-129D177
OOPS-139D917
OOPS-142A582
OOPS-147C2751
OOPS-149C143
OOPS-149C784
And:
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008784.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008906.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008938.html |
It appears that rollback statements are occuring in the middle of handling requests, yet the request continues to be processed. This may cause errors at commit time as SQLObject believes changes have been committed to the database that have not been. The culprit appears to be the standard Z3 editform code, which has been cargo culted into general form.
Instead of aborting the transaction mid request, we need to be able to doom the transaction.
As reference:
OOPS-53B84
OOPS-119B108
OOPS-123A293
OOPS-123B35
OOPS-125B55
OOPS-129D177
OOPS-139D917
OOPS-142A582
OOPS-147C2751
OOPS-149C143
OOPS-149C784
And:
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008784.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008906.html
https://lists.ubuntu.com/mailman/private/launchpad/2006-May/008938.html |
|
2006-07-14 21:16:11 |
Stuart Bishop |
name |
|
doom |
|
2006-07-14 21:16:11 |
Stuart Bishop |
title |
Possible use of more than one connection ID on a single thread may be the cause of many OOPSes |
Need doomed transaction API |
|
2007-09-27 18:52:28 |
Francis J. Lacoste |
launchpad: status |
In Progress |
Triaged |
|
2007-09-27 18:52:28 |
Francis J. Lacoste |
launchpad: assignee |
stevea |
|
|
2009-03-30 10:23:56 |
Stuart Bishop |
launchpad-foundations: assignee |
|
salgado |
|
2009-03-30 10:25:34 |
Stuart Bishop |
launchpad-foundations: status |
Triaged |
Fix Released |
|