[support] Site Offline Errors

[Ryan LeTulle]

Appears to have been a vm host issue the entire time.

In the end I learned a lot about MySQL and Drupal that I did not know.
 Thanks.

Ryan LeTulle, Web Developer

blog:  bayousoft.com <http://www.bayousoft.com>
twitter: @bayousoft <http://twitter.com/bayousoft>





On Thu, Jan 6, 2011 at 5:24 PM, Ryan LeTulle <bayousoft at gmail.com> wrote:

> It appears to have boiled down to the watchdog table.
>
> All the errors in my php log are like:
>
> *[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 also cannot SELECT * FROM watchdog in MySQL Query Browser.  I get *Query
> Execute Thread cannot connect to MySQL*.
>
> 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.
>
> Any ideas?
>
>
> Ryan LeTulle, Web Developer
>
> blog:  bayousoft.com <http://www.bayousoft.com>
> twitter: @bayousoft <http://twitter.com/bayousoft>
>
>
>
>
>
> On Thu, Jan 6, 2011 at 3:08 PM, Ryan LeTulle <bayousoft at gmail.com> wrote:
>
>> nm that didn't fix it
>>
>> talking out loud ...
>>
>> 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?
>>
>> found this:
>>
>> 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 URL does not exist and to return
>> an error 404. Too many requests for a non-existent file can basically become
>> aDoS attack.
>>
>>
>> Ryan LeTulle, Web Developer
>>
>> blog:  bayousoft.com <http://www.bayousoft.com>
>> twitter: @bayousoft <http://twitter.com/bayousoft>
>>
>>
>>
>>
>>
>> On Thu, Jan 6, 2011 at 2:43 PM, Ryan LeTulle <bayousoft at gmail.com> wrote:
>>
>>> I increased the max mysql connections to 200 & restarted mysql but was
>>> still getting the site offline page almost immediately after.
>>>
>>> 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).
>>>
>>> Ryan LeTulle, Web Developer
>>>
>>> blog:  bayousoft.com <http://www.bayousoft.com>
>>> twitter: @bayousoft <http://twitter.com/bayousoft>
>>>
>>>
>>>
>>>
>>>
>>> On Thu, Jan 6, 2011 at 1:18 PM, Ryan Letulle <bayousoft at gmail.com>wrote:
>>>
>>>> Thx
>>>>
>>>> Ryan
>>>>
>>>> i4
>>>>
>>>> On Jan 6, 2011, at 12:34 PM, Jamie Holly <hovercrafter at earthlink.net>
>>>> wrote:
>>>>
>>>>  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.
>>>>
>>>> Jamie Holly <http://www.intoxination.net>http://www.intoxination.net  <http://www.hollyit.net>http://www.hollyit.net
>>>>
>>>>
>>>> On 1/6/2011 1:14 PM, Ryan LeTulle wrote:
>>>>
>>>> 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?
>>>>
>>>>
>>>> Ryan LeTulle, Web Developer
>>>>
>>>>  blog:   <http://www.bayousoft.com>bayousoft.com
>>>> twitter: @bayousoft <http://twitter.com/bayousoft>
>>>>
>>>>
>>>>
>>>>  --
>>>> [ Drupal support list | http://lists.drupal.org/ ]
>>>>
>>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20110107/9daf1ee6/attachment.html