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: bayousoft.com <http://www.bayousoft.com> twitter: @bayousoft <http://twitter.com/bayousoft>
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.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: bayousoft.com <http://www.bayousoft.com> twitter: @bayousoft <http://twitter.com/bayousoft>
Thx Ryan i4 On Jan 6, 2011, at 12:34 PM, Jamie Holly <hovercrafter@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 Hollyhttp://www.intoxination.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: bayousoft.com <http://www.bayousoft.com> twitter: @bayousoft <http://twitter.com/bayousoft> -- [ Drupal support list | http://lists.drupal.org/ ]
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@gmail.com> wrote:
Thx
Ryan
i4
On Jan 6, 2011, at 12:34 PM, Jamie Holly <hovercrafter@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/ ]
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 a DoS 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@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@gmail.com> wrote:
Thx
Ryan
i4
On Jan 6, 2011, at 12:34 PM, Jamie Holly <hovercrafter@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/ ]
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@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@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@gmail.com> wrote:
Thx
Ryan
i4
On Jan 6, 2011, at 12:34 PM, Jamie Holly <hovercrafter@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/ ]
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@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@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@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@gmail.com>wrote:
Thx
Ryan
i4
On Jan 6, 2011, at 12:34 PM, Jamie Holly <hovercrafter@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/ ]
participants (4)
-
Fred Jones -
Jamie Holly -
Ryan Letulle -
Ryan LeTulle