It appears to have boiled down to the watchdog table.<div><br></div><div>All the errors in my php log are like:</div><div><br></div><div><i>[Thu Jan 06 22:59:26 2011] [error] [client 74.167.103.62] PHP Warning: MySQL server has gone away\nquery: INSERT INTO watchdog\n ...</i></div>
<div><br></div><div>I also cannot SELECT * FROM watchdog in MySQL Query Browser. I get <i>Query Execute Thread cannot connect to MySQL</i>.</div><div><br></div><div>I can select any other table. So this explains why it is intermittent. Every time Drupal tries to write to watchdog I get the site offline page.</div>
<div><br></div><div>Any ideas?</div><div><br></div><div><br clear="all">Ryan LeTulle, Web Developer<br><br><div>blog: <a href="http://www.bayousoft.com" target="_blank">bayousoft.com</a><br>twitter: <a href="http://twitter.com/bayousoft" target="_blank">@bayousoft</a><br>
<br><br></div><br>
<br><br><div class="gmail_quote">On Thu, Jan 6, 2011 at 3:08 PM, Ryan LeTulle <span dir="ltr"><<a href="mailto:bayousoft@gmail.com">bayousoft@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
nm that didn't fix it<div><br></div><div>talking out loud ...</div><div><br></div><div>getting lots of page not found errors in the log, can't believe that would be enough to kill it. maybe it's getting indexed?</div>
<div><br></div><div>found this:</div><div><br></div><div><span style="font-family:Verdana, sans-serif;font-size:12px;color:rgb(34, 34, 34);line-height:20px">When using Drupal’s “pretty URLs” which uses Apache’s mod_rewrite to, well, make URLs pretty, all requests that the web server does not process (including errors) will go through Drupal. Going through Drupal means a long boot-strapping process to initialize Drupal and load all its modules, and at least one database request to find out a <span style="font-size:0.9em">URL</span> does not exist and to return an error 404. Too many requests for a non-existent file can basically become a<acronym title="denial of service">DoS</acronym> attack.</span></div>
<div><span style="font-family:Verdana, sans-serif;font-size:12px;color:rgb(34, 34, 34);line-height:20px"><br></span></div><div><font color="#222222" face="Verdana, sans-serif"><span style="font-size:12px;line-height:20px"><br>
</span></font></div><div><div class="im">Ryan LeTulle, Web Developer<br><br><div>blog: <a href="http://www.bayousoft.com" target="_blank">bayousoft.com</a><br>twitter: <a href="http://twitter.com/bayousoft" target="_blank">@bayousoft</a><br>
<br><br></div><br>
<br><br></div><div><div></div><div class="h5"><div class="gmail_quote">On Thu, Jan 6, 2011 at 2:43 PM, Ryan LeTulle <span dir="ltr"><<a href="mailto:bayousoft@gmail.com" target="_blank">bayousoft@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I increased the max mysql connections to 200 & restarted mysql but was still getting the site offline page almost immediately after.<div><br></div><div>Settings > performance > caching mode was set to disabled. I set it to normal. Can this setting cause a site offline error? So far it appears to have stopped and the pages seem snappier (which I would expect).</div>
<div><div><br clear="all">Ryan LeTulle, Web Developer<br><br><div>blog: <a href="http://www.bayousoft.com" target="_blank">bayousoft.com</a><br>twitter: <a href="http://twitter.com/bayousoft" target="_blank">@bayousoft</a><br>
<br><br></div><br>
<br><br></div><div><div></div><div><div class="gmail_quote">On Thu, Jan 6, 2011 at 1:18 PM, Ryan Letulle <span dir="ltr"><<a href="mailto:bayousoft@gmail.com" target="_blank">bayousoft@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF"><div>Thx<br><br>Ryan<div><span><br>
</span></div><div>i<span>4</span></div>
</div><div><div></div><div><div><br>On Jan 6, 2011, at 12:34 PM, Jamie Holly <<a href="mailto:hovercrafter@earthlink.net" target="_blank">hovercrafter@earthlink.net</a>> wrote:<br><br></div><div></div><blockquote type="cite">
<div>
Most of the time it's PHP unable to connect to the database. Check
your PHP error logs and see if it gives you a hint.<br>
<pre cols="72">Jamie Holly
<a href="http://www.intoxination.net" target="_blank"></a><a href="http://www.intoxination.net" target="_blank">http://www.intoxination.net</a>
<a href="http://www.hollyit.net" target="_blank"></a><a href="http://www.hollyit.net" target="_blank">http://www.hollyit.net</a></pre>
<br>
On 1/6/2011 1:14 PM, Ryan LeTulle wrote:
<blockquote type="cite">
<div>Training users on a new Drupal site today and getting lots of
site offline errors. Can someone tell me what triggers this?
PHP memory setting?</div>
<div><br>
</div>
<br clear="all">
Ryan LeTulle, Web Developer<br>
<br>
<div>
blog: <a href="http://www.bayousoft.com" target="_blank"></a><a href="http://bayousoft.com" target="_blank">bayousoft.com</a><br>
twitter: <a href="http://twitter.com/bayousoft" target="_blank">@bayousoft</a><br>
<br>
<br>
</div>
<br>
</blockquote>
</div></blockquote></div></div><blockquote type="cite"><div><span>-- </span><br><span>[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]</span></div></blockquote></div>
</blockquote></div><br></div></div></div>
</blockquote></div><br></div></div></div>
</blockquote></div><br></div>