We're going to be adding some advertisements to the forums! If you notice any weirdness around this or spot bad/inappropriate ads, please make a thread in the bugs forum.

Having issues accessing the forums

phpBB : Critical Error

Could not connect to the database

Getting this error about half the time when tring to access forums/threads/new post screen.

General maintenence, something I missed or is this a problem? It's a bit annoying, but annoying isn't all that bad.

Mages do it with Sheep.
chatelaine on
«1

Posts

  • MachineHeadMachineHead Registered User
    edited February 2004
    I'm getting them about 75% of the time. Need to keep refreshing until the page comes up.

    MachineHead on
  • Raijin QuickfootRaijin Quickfoot I'm your Huckleberry YOU'RE NO DAISYRegistered User, ClubPA regular
    edited February 2004
    As am I. It almost seems random, One time it didn't let me in the chat thread, the next time it did. I also got on trying to replay to this thread, then I tried again and it worked.

    Raijin Quickfoot on
    HEY SATAN! HERE'S MY WISHLIST! GO NUTS YOU DEVIL!

    https://www.amazon.com/gp/registry/wishlist/1JI9WWSRW1YJI
  • denihilistdenihilist Ancient and Mighty Registered User, Moderator mod
    edited February 2004
    I'm getting them as well. Perhaps the speed hack is getting wonky.

    denihilist on
  • Raijin QuickfootRaijin Quickfoot I'm your Huckleberry YOU'RE NO DAISYRegistered User, ClubPA regular
    edited February 2004
    denihilist wrote:
    I'm getting them as well. Perhaps the speed hack is getting wonky.
    I'll tell you, they're popping up nice and quick though.

    Raijin Quickfoot on
    HEY SATAN! HERE'S MY WISHLIST! GO NUTS YOU DEVIL!

    https://www.amazon.com/gp/registry/wishlist/1JI9WWSRW1YJI
  • DynagripDynagrip destroy everything you touch Registered User, ClubPA regular
    edited February 2004
    Same here.

    Dynagrip on
    ok98TNK.png
  • CorvusCorvus . VancouverRegistered User regular
    edited February 2004
    I'm getting it too.

    Also got this lovely thing:

    huh.jpg

    Link (much larger version)

    Corvus on
    :so_raven:
  • DogDog Registered User, Administrator, Vanilla Staff admin
    edited February 2004
    denihilist wrote:
    I'm getting them as well. Perhaps the speed hack is getting wonky.

    It's that cursed pconnect Alpha is using, consarnit!

    I told you! I told you all!

    The world is ending.
    Ennnnnnnnnnnnnnnnnnnnding!

    Ahhhhhhhhhhhhhhhhh!!!!!!!!!!!!

    :roll:

    Unknown User on
  • PaladinPaladin Registered User regular
    edited February 2004
    This has all happened before. Presumably alpha will adjust th tweaks for more stability.

    On the bright side, we're not double posting anymore.

    Paladin on
    Marty: The future, it's where you're going?
    Doc: That's right, twenty five years into the future. I've always dreamed on seeing the future, looking beyond my years, seeing the progress of mankind. I'll also be able to see who wins the next twenty-five world series.
  • AlhazadAlhazad Registered User
    edited February 2004
    Yes we are.

    Alhazad on
    bash.org wrote:
    <fanf1> linux is more compatible with unix than windows is with windows
  • AlhazadAlhazad Registered User
    edited February 2004
    Yes we are.

    Alhazad on
    bash.org wrote:
    <fanf1> linux is more compatible with unix than windows is with windows
  • PaladinPaladin Registered User regular
    edited February 2004
    I think this is more a problem with the PA host at a bad time rather than anything Alpha has done. I highly doubt he could screw up the main site from here.

    Paladin on
    Marty: The future, it's where you're going?
    Doc: That's right, twenty five years into the future. I've always dreamed on seeing the future, looking beyond my years, seeing the progress of mankind. I'll also be able to see who wins the next twenty-five world series.
  • DogDog Registered User, Administrator, Vanilla Staff admin
    edited February 2004
    Paladin wrote:
    I think this is more a problem with the PA host at a bad time rather than anything Alpha has done. I highly doubt he could screw up the main site from here.

    All the current issues have been MySQL related. Alpha said he was gonna tinker with MySQL stuff.

    Draw your own conclusions.

    Just so I don't come off as a complete asshole: this is just speculation. I don't know exactly what he's working on, it's just a strange coincidence.

    Unknown User on
  • MachineHeadMachineHead Registered User
    edited February 2004
    Paladin wrote:
    I think this is more a problem with the PA host at a bad time rather than anything Alpha has done. I highly doubt he could screw up the main site from here.

    All the current issues have been MySQL related. Alpha said he was gonna tinker with MySQL stuff.

    Draw your own conclusions.

    Just so I don't come off as a complete asshole: this is just speculation. I don't know exactly what he's working on, it's just a strange coincidence.

    Things were fine this morning when the user load was low, but now that more people are on-line, the problem has gotten steadily worse and worse.

    MachineHead on
  • PaladinPaladin Registered User regular
    edited February 2004
    The proper scientific thing to do would be to let this run for two more days and then have the same period of time without the modifications, slowly adding them on as each day progresses.

    By that time everybody will have left the forum

    Paladin on
    Marty: The future, it's where you're going?
    Doc: That's right, twenty five years into the future. I've always dreamed on seeing the future, looking beyond my years, seeing the progress of mankind. I'll also be able to see who wins the next twenty-five world series.
  • DickDick Registered User
    edited February 2004
    Alhazad wrote:
    Yes we are.

    Assmate. You did that on purpose. Funny, I got error when trying to open this thread :)


    And when I tried to post this the first time.

    Dick on
  • DogDog Registered User, Administrator, Vanilla Staff admin
    edited February 2004
    Paladin wrote:
    I think this is more a problem with the PA host at a bad time rather than anything Alpha has done. I highly doubt he could screw up the main site from here.

    All the current issues have been MySQL related. Alpha said he was gonna tinker with MySQL stuff.

    Draw your own conclusions.

    Just so I don't come off as a complete asshole: this is just speculation. I don't know exactly what he's working on, it's just a strange coincidence.

    Things were fine this morning when the user load was low, but now that more people are on-line, the problem has gotten steadily worse and worse.

    Yes. My thought is that it's related to Alpha switching to persistent MySQL connections. All the connections are gobbled up by idle users and active users get screwed.

    Unknown User on
  • DogDog Registered User, Administrator, Vanilla Staff admin
    edited February 2004
    Alhazad wrote:
    Yes we are.

    Assmate. You did that on purpose. Funny, I got error when trying to open this thread :)


    And when I tried to post this the first time.

    Assmate? As in you guys share an ass?

    Unknown User on
  • Raijin QuickfootRaijin Quickfoot I'm your Huckleberry YOU'RE NO DAISYRegistered User, ClubPA regular
    edited February 2004
    I think its quite apparant that Alpha is secretly an agent of squidi.net!!!!

    Raijin Quickfoot on
    HEY SATAN! HERE'S MY WISHLIST! GO NUTS YOU DEVIL!

    https://www.amazon.com/gp/registry/wishlist/1JI9WWSRW1YJI
  • The Deranged HermitThe Deranged Hermit Inside the walls Merry Old EnglandRegistered User regular
    edited February 2004
    I think its quite apparant that Alpha is secretly an agent of squidi.net!!!!

    :shock:

    It's a constipatery!

    It started off happening about one in every ten pages I tried, now it's virtually every other page. However I am glad it's not my computer being an asshole.

    The Deranged Hermit on
    Steam: the_deranged_hermit
    GW2: Tavalisk.9463
  • RamiusRamius Joined: July 19, 2000 Administrator, ClubPA admin
    edited February 2004
    denihilist wrote:
    I'm getting them as well. Perhaps the speed hack is getting wonky.

    It's that cursed pconnect Alpha is using

    I agree with this assessment.

    The pconnect has been removed and the 250 hung threads have been painstakingly killed one-by-one. :!:

    No ill-will toward alpha. He had no way of knowing this would happen.

    Ramius on
  • DogDog Registered User, Administrator, Vanilla Staff admin
    edited February 2004
    Ramius wrote:
    The pconnect has been removed and the 250 hung threads have been painstakingly killed one-by-one. :!:
    /path/to/mysql/mysqld restart
    apachectl -restart
    

    Wouldn't that have been much easier?
    (or something to that effect)

    Unknown User on
  • Premier kakosPremier kakos Registered User, ClubPA regular
    edited February 2004
    Ramius wrote:
    denihilist wrote:
    I'm getting them as well. Perhaps the speed hack is getting wonky.

    It's that cursed pconnect Alpha is using

    I agree with this assessment.

    The pconnect has been removed and the 250 hung threads have been painstakingly killed one-by-one. :!:

    No ill-will toward alpha. He had no way of knowing this would happen.

    A lot of people could have let him know. I think this is justification for a Programming Forum. Not only could the forumers discuss programming, but if alpha or anyone has a question when it comes to optimizing the forums, he could ask it and get lots of feedback!

    Premier kakos on
    SuperKawaiiWillSig.jpg
  • bone daddybone daddy Registered User, ClubPA regular
    edited February 2004
    I think its quite apparant that Alpha is secretly an agent of squidi.net!!!!

    Suicide-squad, attack!

    bone daddy on
    Rogue helicopter?
    Ecoterrorism is actually the single largest terrorist threat at the moment. They don't usually kill people, but they blow up or set on fire very expensive things.
  • MachineHeadMachineHead Registered User
    edited February 2004
    Ramius wrote:
    denihilist wrote:
    I'm getting them as well. Perhaps the speed hack is getting wonky.

    It's that cursed pconnect Alpha is using

    I agree with this assessment.

    The pconnect has been removed and the 250 hung threads have been painstakingly killed one-by-one. :!:

    No ill-will toward alpha. He had no way of knowing this would happen.

    You may want to fill him in on some of the no-nos code wise.

    MachineHead on
  • denihilistdenihilist Ancient and Mighty Registered User, Moderator mod
    edited February 2004
    Ramius wrote:
    denihilist wrote:
    I'm getting them as well. Perhaps the speed hack is getting wonky.

    It's that cursed pconnect Alpha is using

    I agree with this assessment.

    The pconnect has been removed and the 250 hung threads have been painstakingly killed one-by-one. :!:

    No ill-will toward alpha. He had no way of knowing this would happen.

    You may want to fill him in on some of the no-nos code wise.

    I think what Ramius was saying was that no one could've expected it. I of course reserve the right to be wrong about this.

    denihilist on
  • Premier kakosPremier kakos Registered User, ClubPA regular
    edited February 2004
    denihilist wrote:
    I think what Ramius was saying was that no one could've expected it. I of course reserve the right to be wrong about this.

    I hope that isn't what he's saying. Most people with experience with pconnect (there are at least a few) could have expected this. pconnect sets up a persistent connection that doesn't die. You cannot close pconnects, which is why there were 250 hung threads.

    The best advise is to not use pconnect unless you need it, which isn't the case with the board.

    Premier kakos on
    SuperKawaiiWillSig.jpg
  • MachineHeadMachineHead Registered User
    edited February 2004
    denihilist wrote:
    Ramius wrote:
    denihilist wrote:
    I'm getting them as well. Perhaps the speed hack is getting wonky.

    It's that cursed pconnect Alpha is using

    I agree with this assessment.

    The pconnect has been removed and the 250 hung threads have been painstakingly killed one-by-one. :!:

    No ill-will toward alpha. He had no way of knowing this would happen.

    You may want to fill him in on some of the no-nos code wise.

    I think what Ramius was saying was that no one could've expected it. I of course reserve the right to be wrong about this.

    I might have read into what Ramius said, but it seemed to me that he knew what the result of Alpha's coding would be.

    MachineHead on
  • DogDog Registered User, Administrator, Vanilla Staff admin
    edited February 2004
    denihilist wrote:
    Ramius wrote:
    denihilist wrote:
    I'm getting them as well. Perhaps the speed hack is getting wonky.

    It's that cursed pconnect Alpha is using

    I agree with this assessment.

    The pconnect has been removed and the 250 hung threads have been painstakingly killed one-by-one. :!:

    No ill-will toward alpha. He had no way of knowing this would happen.

    You may want to fill him in on some of the no-nos code wise.

    I think what Ramius was saying was that no one could've expected it. I of course reserve the right to be wrong about this.

    I might have read into what Ramius said, but it seemed to me that he knew what the result of Alpha's coding would be.

    At least two of us knew what was gonna happen.

    Unknown User on
  • ÄlphämönkëyÄlphämönkëy Registered User regular
    edited February 2004
    I make mistakes. Im the first one to tell you that. I knew there was a possiblity of error and I take full responsibilty for the mistake. Im still getting used to this new system too, it will take me a while to "get my bearings" The cluster is, interesting, to say the least and it has many peculiarities.

    I have used pconnect before, infact I currently am on another system and I was fully aware of the possibility of error, however, given the size of the board, it was an experiment I was willing to try as the potential gain was high. If you noticed I didnt just apply the patch, I made a thread for telling when pconnect broke, as I was aware of the risk and I stayed on for several hours waiting to see if there would be any problems.

    Kakos, you mentioned me posting about it, I did. I recieved feedback from both sides, though I didnt see your name as one of them. I am always happy to talk about coding with people. I dont think that it merits spliting this forum in two however.

    Appologies to Ramius, killing mySQL threads is no fun. Appologies to the forumers, because critical errors suck.

    Älphämönkëy on
  • denihilistdenihilist Ancient and Mighty Registered User, Moderator mod
    edited February 2004
    kakos wrote:
    denihilist wrote:
    I think what Ramius was saying was that no one could've expected it. I of course reserve the right to be wrong about this.

    I hope that isn't what he's saying. Most people with experience with pconnect (there are at least a few) could have expected this. pconnect sets up a persistent connection that doesn't die. You cannot close pconnects, which is why there were 250 hung threads.

    The best advise is to not use pconnect unless you need it, which isn't the case with the board.

    I know fuck all about the technical side of things, which is why I reserved the right to be wrong.

    denihilist on
  • RamiusRamius Joined: July 19, 2000 Administrator, ClubPA admin
    edited February 2004
    kakos and Machinehead are both partially correct.


    We have historically not used pconnect anywhere on the server. That is, for as long as I've been here it hasn't been used. I never bothered to give serious thought to why not because I never saw a noticable performance issue related to not using pconnect. I'm not saying I haven't seen performance problems on the server, just that if connecting to the database were slow, it would always be slow. And many times the server runs great.

    I have a glint of a memory from a couple years ago, where we had problems with connections to the database. This is while I was still rather new to penny-arcade programming. And the message passed to me from HomeLAN was something like "you aren't using persistant connections, are you?"

    We weren't, but that comment stuck with me as an indication that we shouldn't. If not for that comment way back when, I probably might have gone ahead and tried it at some point to see what kind of difference it might make. That is why I don't blame alpha for trying it.

    The fact is, pconnect can work wonders in certain situations. I have used it in applications at work a number of times. But success or failure with using pconnect relies heavily on the webserver and database configuration, and here at HomeLAN, not only do we not have any control over those factors, but we also don't have much data about them. Anything I know about the server and network configuration of the cluster I know from empirical evidence acquired over time. I don't mean to disparage HomeLAN, I think they are awesome and have been immeasurably generous to penny-arcade. But they run this operation in such a way that there is virtually no information-exchange between them and me.

    I typically wouldn't even share this kind of information with the forum-at-large. But I made a mistake in posting my earlier comment, because it cast some doubt on alphamonkey's abilities and/or judgement. That is a terrible "off-to-the-wrong-foot" way to transition from one administration to the next, so I want to set the record straight. Programming at penny-arcade presents some unique challenges, and I have full confidence in alphamonkey to meet those challenges. While there will be instances, like this one, where someone around the forums might say "I knew better" of a decision, alphamonkey should not be judged based upon a single decision. I believe alphamonkey is particularly well-suited for this position and I think that looking back 6 months from now you will find yourself feeling he is as dependable and ingenious as I ever was.

    Ramius on
  • DogDog Registered User, Administrator, Vanilla Staff admin
    edited February 2004
    I make mistakes. Im the first one to tell you that. I knew there was a possiblity of error and I take full responsibilty for the mistake. Im still getting used to this new system too, it will take me a while to "get my bearings" The cluster is, interesting, to say the least and it has many peculiarities.

    I have used pconnect before, infact I currently am on another system and I was fully aware of the possibility of error, however, given the size of the board, it was an experiment I was willing to try as the potential gain was high. If you noticed I didnt just apply the patch, I made a thread for telling when pconnect broke, as I was aware of the risk and I stayed on for several hours waiting to see if there would be any problems.

    Kakos, you mentioned me posting about it, I did. I recieved feedback from both sides, though I didnt see your name as one of them. I am always happy to talk about coding with people. I dont think that it merits spliting this forum in two however.

    Appologies to Ramius, killing mySQL threads is no fun. Appologies to the forumers, because critical errors suck.

    Hey man, no need to apologize. People don't find better ways of doing things without taking a risk and trying a new approach. With the exception of Ramius having to kill some connections, you didn't put anyone out, and I'm sure Ramius didn't mind all that much.

    Honestly, I'd much rather have someone around that comes up with innovative ideas to better the forum. With Ramius leaving, I couldn't think of a better choice for him to make.

    Unknown User on
  • Premier kakosPremier kakos Registered User, ClubPA regular
    edited February 2004
    I make mistakes. Im the first one to tell you that. I knew there was a possiblity of error and I take full responsibilty for the mistake. Im still getting used to this new system too, it will take me a while to "get my bearings" The cluster is, interesting, to say the least and it has many peculiarities.

    I have used pconnect before, infact I currently am on another system and I was fully aware of the possibility of error, however, given the size of the board, it was an experiment I was willing to try as the potential gain was high. If you noticed I didnt just apply the patch, I made a thread for telling when pconnect broke, as I was aware of the risk and I stayed on for several hours waiting to see if there would be any problems.

    Kakos, you mentioned me posting about it, I did. I recieved feedback from both sides, though I didnt see your name as one of them. I am always happy to talk about coding with people. I dont think that it merits spliting this forum in two however.

    Appologies to Ramius, killing mySQL threads is no fun. Appologies to the forumers, because critical errors suck.

    I had not seen the thread. I apologize. I also apologize if I came off as an ass. The information I had at the time was that you just applied the patch, which is not an unreasonable assumption with most forum admins. Thank you for actually starting a thread about this.

    As far as experimentations on these forums, we could employ something that most development projects do. We have a 'stable' forum and an 'unstable' forum. You implement code on the 'unstable' forum and if it works, you put it in the 'stable' forum.

    As far as testing the 'unstable' forum, you could ask for volunteers to use the 'unstable' forum. Or you could simply code up something that randomly redirects people to one or the other when they point their browser to http://www.penny-arcade.com/forums and can be turned off at a moment's notice.

    Premier kakos on
    SuperKawaiiWillSig.jpg
  • ÄlphämönkëyÄlphämönkëy Registered User regular
    edited February 2004
    We actually do have an "unstable forums" folder, I just needed the traffic to illustrate the flaw on this one. I have an idea, a modification on your theroy. I need to do some thinking for a while though.... Ill come back in the morning with some better information.

    Älphämönkëy on
  • Fire_FoxFire_Fox Registered User
    edited February 2004
    I have been noticing that the forum hasn't been showing new threads and post correctly (ie the red folder), and not remembering my login... Is this related to the problems everyone else has been having?

    Fire_Fox on
  • ÄlphämönkëyÄlphämönkëy Registered User regular
    edited February 2004
    Fire_Fox wrote:
    I have been noticing that the forum hasn't been showing new threads and post correctly (ie the red folder), and not remembering my login... Is this related to the problems everyone else has been having?
    I doubt it. It could be delayed ramifications, but I doubt it, more than likely its your connection let me check your ISP.

    EDIT : Its not your ISP, my guess would be you are either taking a very long time and letting your session expire or something very wrong is happening with your cookies.

    Älphämönkëy on
  • Fire_FoxFire_Fox Registered User
    edited February 2004
    How Long does it take for a session to expire? It has been happening to me through out the day I'll wait to get back to you till tomarrow. It'll probably go away...

    Fire_Fox on
  • ÄlphämönkëyÄlphämönkëy Registered User regular
    edited February 2004
    Quickly. 15 or so minutes of inactivity kills a session.

    Älphämönkëy on
  • DogDog Registered User, Administrator, Vanilla Staff admin
    edited February 2004
    Fire_Fox wrote:
    I have been noticing that the forum hasn't been showing new threads and post correctly (ie the red folder), and not remembering my login... Is this related to the problems everyone else has been having?
    I doubt it. It could be delayed ramifications, but I doubt it, more than likely its your connection let me check your ISP.

    EDIT : Its not your ISP, my guess would be you are either taking a very long time and letting your session expire or something very wrong is happening with your cookies.

    Regarding the new threads/posts: that's due to the time difference among the servers in the cluster.

    Regarding the login: Alpha was right. It's probably a cookie issue. Grease your browser's cookie(style) sheet and turn down the temperature on your firewall a bit.

    ;)

    Unknown User on
  • ÄlphämönkëyÄlphämönkëy Registered User regular
    edited February 2004
    I actually think in his case the two are connected. When you lose your session it marks everything as read, so when it was recreated it would appear as if he had read everything. If his error was the opposite, ie not marking things read, your right, its the cluster timesync issue.

    Älphämönkëy on
Sign In or Register to comment.