From 999195822166fd2bd5558a2c1f60460141aa7a2c Mon Sep 17 00:00:00 2001
From: "myk%mozilla.org" <>
Date: Wed, 24 Apr 2002 04:33:46 +0000
Subject: Fix for bug 124587: Lock bugs table before inserting new bug. Patch
 by Myk Melez <myk@mozilla.org> r=bbaetz,justdave

---
 post_bug.cgi | 7 +++++++
 1 file changed, 7 insertions(+)

(limited to 'post_bug.cgi')

diff --git a/post_bug.cgi b/post_bug.cgi
index 7f9f46c47..a50369592 100755
--- a/post_bug.cgi
+++ b/post_bug.cgi
@@ -237,6 +237,11 @@ foreach my $b (grep(/^bit-\d*$/, keys %::FORM)) {
 
 $sql .= ") & $::usergroupset)\n";
 
+# Lock tables before inserting records for the new bug into the database
+# if we are using a shadow database to prevent shadow database corruption
+# when two bugs get created at the same time.
+SendSQL("LOCK TABLES bugs WRITE, longdescs WRITE, cc WRITE") if Param("shadowdb");
+
 # Add the bug report to the DB.
 SendSQL($sql);
 
@@ -266,6 +271,8 @@ if (defined $::FORM{'cc'}) {
     }
 }
 
+SendSQL("UNLOCK TABLES") if Param("shadowdb");
+
 # Assemble the -force* strings so this counts as "Added to this capacity"
 my @ARGLIST = ();
 if (@cc) {
-- 
cgit v1.2.3-24-g4f1b