ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

EE getting killed with some MySQL processes

June 17, 2008 9:00pm

Subscribe [3]
  • #16 / Jun 18, 2008 10:14pm

    Lisa Wess

    20502 posts

    Todd, are you running any extensions? Also, are you seeing this behavior when loading a simple template?

  • #17 / Jun 18, 2008 10:25pm

    Todd S

    57 posts

    Not running any extensions, and, no, I’m not seeing the same behavior anymore on the public side.

    Last night, of course, was a different story. Almost every page was spinning endlessly, but when I turned off caching for each each template directly in the database, and killed off the Sleeper connections, the public pages became accessible once again.

  • #18 / Jun 18, 2008 10:31pm

    Sue Crocker

    26054 posts

    So how is this evening going now that you made the changes?

  • #19 / Jun 18, 2008 10:57pm

    Todd S

    57 posts

    The control panel is still inaccessible. Spins endlessly, which I suspect is why I’m getting so many sleeper connections to the database.

    I haven’t upgraded, yet. I wanted to fix access to the control panel before going through that process.

  • #20 / Jun 18, 2008 11:42pm

    Todd S

    57 posts

    So here’s the latest. I decided to attempt an upgrade to 1.6.3, but on a backup copy of the live website. I copied the live db to a new database, and then just pointed the config.php in the 1.6.3 folder to this new backup copy of the live database. Unfortunately, I ran update.php only to watch it fall into the same pattern as the EE control panel on the live install. I’m now watching it spin endlessly just like the control panel does, and I can even see the connection to this new database listed in Sleep mode.

  • #21 / Jun 18, 2008 11:44pm

    Lisa Wess

    20502 posts

    Hey, Todd - it’s probably best that we work this out before updating.  It sounds like it may be checking for updates and timing out on that process.  Can you try adding:

    $conf['new_version_check'] = "n";

    to your config.php and temporarily remove /system/plugins/pi.magpie.php?  make a backup of both files first, please.  Let me know if that helps.

  • #22 / Jun 23, 2008 5:31pm

    Todd S

    57 posts

    So things are back to normal. Mysteriously, whatever was preventing us from accessing the control just vanished. We’re still trying to figure out what happened. One last question I have ...

    Does the EE control panel use the cache directory in any way?

  • #23 / Jun 23, 2008 7:14pm

    Ingmar

    29245 posts

    Todd, nothing in the control panel is cached in any way, not even the queries.

  • #24 / Jun 24, 2008 11:44am

    Todd S

    57 posts

    Not even that RSS feed from EllisLab that shows up via the Magpie plugin?

  • #25 / Jun 24, 2008 11:53am

    Ingmar

    29245 posts

    Magpie keeps its own cache, independent of the rest of EE.

  • #26 / Jun 24, 2008 12:42pm

    Todd S

    57 posts

    Yeah, I’ve seen that magpie cache folder in /ee/system/cache. Okay, so the control panel doesn’t cache anything, but if that RSS feed from you guys is enabled then the control panel effectively does rely on the cache folder, indirectly, because of the plugin.

    The reason I ask is because we think our problem had something to do with the webserver not being able to write files to the cache folder last week. It’s an NFS mount, and we know our provider, Joyent, was having some NFS problems last week. 

    When we turned off caching for all our templates, all the pages came back, but not the control panel. I’m thinking if there was any reliance on the cache folder, even indirectly through a plugin, that might have been why we couldn’t access the CP.

  • #27 / Jun 24, 2008 1:21pm

    Ingmar

    29245 posts

    To be honest, NFS is pretty advanced stuff. I don’t see why it shouldn’t work, but we cannot offer support for advanced server configurations, obviously. Couldn’t you just turn off the feed, or even disable/remove the plugin temporarily to test your hypothesis?

  • #28 / Jun 24, 2008 1:54pm

    Todd S

    57 posts

    We’re simply trying to figure out what happened. Everything is back to normal, but we believe NFS was the problem, not EE. There’s no way to test this, but knowing the control panel had some reliance on the EE cache folder indirectly via the Magpie plugin gives us more reason to believe the problem was indeed NFS.

  • #29 / Jun 24, 2008 5:06pm

    Ingmar

    29245 posts

    I see. That said, are ready to close this thread? Any unresolved technical issues left?

  • #30 / Jun 24, 2008 6:40pm

    Todd S

    57 posts

    Consider it closed.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases