Script Locking Up and Causing 500 Errors

A script is locking up and causing PHP errors because processes aren't finishing.

Mysql Insert Query Locking Becuz It Tries to Select before Read Lock Is Finish
My site is having some problems and getting locked on an insert (cause lock) and then it tries to select b4 read lock is finished causing my script on calendar.php to lock the site up which causes it (during heavy traffic) to just keep reloading without finishing out the whole page.

Here is the exact message my administrator sent me: (t appears that your script is causing contention with the database it is trying to access. You are inserting (causing a lock) ) and then attempting to select, and the read lock isn't complete yet. This is causing the lock contention that your calendar script is suffering from. Please reevaluate your code to streamline your queries and/or change it to atomic writes (by using the lock procedure)

What be the best thing to do at this point? Because its causing me to miss out on THOUSANDS OF DAILY USERS).

Need help Quick

Here is the file in question:

<?php 
$result = mysql_query("select uid, profile_image_url,screen_name from users order by made desc limit 12");
$num = 0;
while($row = mysql_fetch_array($result)){
$num++;
$img = $row['profile_image_url'];
  if($img == "") { $img = "http://static.twitter.com/images/default_profile_normal.png"; }
$uid = $row['uid'];
$screen_name = $row['screen_name'];
echo "<a href=\"./u/$screen_name\"><img width=\"48px\" height=\"48px\" src=\"$img\"></a>";
if($num % 4 == 0){ echo "<br>"; }
}
?>
   </div>
   </div>
 <div style="float:left;width:100%;">
 <b class="wgb4"></b><b class="wgb3"></b><b class="wgb2"></b><b class="wgb1"></b></b>
</div>
 </div>
 </div>
 <!--- END RECENT TWEETERS -->
  
  
  <!--- SPOTLIGHT -->
<div style="width:420px;float:left;margin-left:30px;">
 <div style="margin-left:0px;margin-top:0px;float:left;width:100%;">
 <b class="wgtop"><b class="wgb1"></b><b class="wgb2"></b><b class="wgb3"></b><b class="wgb4"></b></b>
<div class="blue_box" style="height:200px; width:418px; color:#ffffff; text-align:center;">
   <strong>Social Event Sharing</strong>
<ul style="size:8px; color:#000000; text-align:left;">
<li>Share/Find Events via Twitter, Facebook, Myspace, Email & other social media sites right from Caltweet</li>
<br>
 <li>Caltweet is the fastest, easiest, & safest ways to Promote your events online</li>
<br>
 <li>Print Guestlist & Have RSVP's Emailed Directly to your inbox <a href="http://example.com/create.php">Click Here to Start</a> or <a href="howto.php">Learn How to Use Example</a> </li>
 <!-- <a href="http://example.com/961">
 <img src="http://www.example.com/imgs/caltweet-charity.jpg" title="Example 4 Charity" alt="Example 4 Charity"/></a><br /><font color="#000000">Click here:</font> <a href="/961">Example4 Charity</a><br />-->
  <form style="margin-top: 10px;" action="./allevents.php" method="get">
<input onkeyup="searchEvents();" size="42" autocomplete="off" style="height:9; font-size:12px; padding:0px;" type="search" name="se" id="se" />
<input style="height:9; font-size:12px; padding:0px;" value="Search" type="submit" /><br />
<div style=" z-index:1000; position:absolute; visibility:hidden; text-align:left; margin:0px; padding:0px; width:330px; background-color:#CCCCCC;" name="search" id="search"></div>
</form>
</ul>

   </div>
 <div style="float:left;width:100%;">
 <b class="wgb4"></b><b class="wgb3"></b><b class="wgb2"></b><b class="wgb1"></b></b>
</div>
 </div> 
 </div> 
 <!--- END SPOTLIGHT -->
  
  
  
  </div>
  <div class="right">
  <div class="tags"><div style="height:185px; overflow:hidden;"><img src="/imgs/section_names_03.jpg" />
  
  <?php 
$max = mysql_fetch_array(mysql_query("select max(tag_count) as max from tags"));
$max = $max['max'];
$small = 10;
$large = 25;
$num = 0;
$result = mysql_query("select * from tags order by rand() limit 15"); 
while ($tag = mysql_fetch_array($result)){
if($num > 0){ echo ", "; }
$num++;
$tagcount = $tag['tag_count'];
if($tagcount == "" || $tagcount < 1){ $tagcount = 1; }
$percent = $tagcount / $max;
$size = (($large - $small) * $percent) + $small;
echo "<font size=\"{$size}px\" style=\"font-size: {$size}px;\"><a href=\"/t/". str_replace('+', '-', urlencode($tag['tag'])) . "\">{$tag['tag']}</a></font>";
}
?></div><div style="height:100px; overflow:hidden;">
Follow the Creators:<br />
<a href="http://twitter.com/mrcaltweet"><img src="http://example.com/imgs/freddy.jpg" width="55px" height="55px" /></a> 
<a href="http://twitter.com/person_name"><img src="http://a3.twimg.com/profile_images/457209831/6935_167176678078_697813078_3722745_2905007_n-1_normal.jpg" width="55px" height="55px" /></a>

</div>
  
  </div>
  </div>
 </div>
 <div class="bottom">
 <!--- RECENT EVENTS -->
<div style="width:860px;float:left;margin-left:18px;">
 <div style="margin-left:0px;margin-top:0px;float:left;width:100%;">
 <b class="retop"><b class="reb1"></b><b class="reb2"></b><b class="reb3"></b><b class="reb4"></b></b>
<div class="re_box" style="height:120px; width:857px;">
 
 
  <div class="re_pic"><img src="/imgs/section_names_14.jpg" /></div>
   <div class="seperator"></div>
   <?php
$result = mysql_query("select * from events join users on (user_id = uid) where ispublic = 1 order by created desc limit 4");
$i = 0;
while($row = mysql_fetch_array($result)){
$i++;
$event_id = $row['event_id'];
$hex_id = encode_eid($event_id);
$event_time = date("F j, Y, g:i a", $row['event_time']);
$link = "<a href='http://caltweet.com/$hex_id'>";
$event_title = stripslashes($row['event_title']);
//$event_pic = "<img width='300px' height='300px' src='{$row['event_pic']}'>";
$event_pic = max_picture($row['event_pic'], 120, 90, $event_title);
$event_desc = $row['event_desc'];

thanks

[edited by: eelixduppy at 6:03 pm (utc) on Mar 17, 2010]
[edit reason] removed specifics [/edit]

Script Locking Up and Causing 500 Errors

php mysql script locking up on read & select

MrCaltweet

Matthew1980

MrCaltweet

Matthew1980

MrCaltweet

Matthew1980

MrCaltweet

jatar_k

MrCaltweet

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week