Activity log for bug #44032

Date Who What changed Old value New value Message
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