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.nethttp://www.intoxination.net http://www.hollyit.nethttp://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.combayousoft.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.nethttp://www.intoxination.net http://www.hollyit.nethttp://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.combayousoft.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.nethttp://www.intoxination.net http://www.hollyit.nethttp://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.combayousoft.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.comwrote:
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.nethttp://www.intoxination.net http://www.hollyit.nethttp://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.combayousoft.com twitter: @bayousoft http://twitter.com/bayousoft
-- [ Drupal support list | http://lists.drupal.org/ ]
-
Fred Jones -
Jamie Holly -
Ryan Letulle -
Ryan LeTulle