Penny Arcade Forums› Tube's Circus Of Bug Reports and User Issues
As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread: https://forums.penny-arcade.com/discussion/240191/forum-advertisement-faq-and-reports-thread/
Options

MySQL... From the ashes...

ÄlphämönkëyÄlphämönkëy Registered User regular
edited May 2004 in Tube's Circus Of Bug Reports and User Issues
Well, the SQL server died again today, and the guys at HomeLAN bailed us out by hard rebooting the server. I've been exchanging emails with a tech guy at HomeLAN and he is making sure we get treated right. We are upgrading our MySQL server to the latest version of Gentoo, and maybe, just maybe... we might move over to MySQL 4 :wink:

Readers Digest Version : Forums died. Fixed. Jason at HomeLAN is working to make things more stable.

Älphämönkëy on

Posts

  • Options
    Raijin QuickfootRaijin Quickfoot I'm your Huckleberry YOU'RE NO DAISYRegistered User, ClubPA regular
    edited May 2004
    Alphamonkey just casted summon Orthanc.

    Raijin Quickfoot on
  • Options
    ObbiObbi Registered User, ClubPA regular
    edited May 2004
    Days are so slow without reading the asshattery of the PA forums...

    Obbi on
  • Options
    OrthancOrthanc Death Lite, Only 1 Calorie Off the end of the internet, just turn left.Registered User, ClubPA regular
    edited May 2004
    Raijin Quickfoot wrote:
    Alphamonkey just casted summon Orthanc.

    Unfortunatly his summon was countered by the curse of the working man.

    Be good to get MySQL 4 on though. Soo much extra stuff

    Orthanc on
    orthanc
  • Options
    BesigedBBesigedB Registered User, ClubPA regular
    edited May 2004
    Please please, please get some graceful error handling for the front page.

    It just looks so unprofessional and shit.
    PA-logo.gif
    Penny arcade is experiencing database problems. Please check back later

    Would suffice :?

    BesigedB on
    this is a small sig to not get in your way
  • Options
    ÄlphämönkëyÄlphämönkëy Registered User regular
    edited May 2004
    I dont handle the mainsite.

    Älphämönkëy on
  • Options
    DogDog Registered User, Administrator, Vanilla Staff admin
    edited May 2004
    You would if you cared!


    ;)

    Unknown User on
  • Options
    BesigedBBesigedB Registered User, ClubPA regular
    edited May 2004
    alphamonkey wrote:
    I dont handle the mainsite.

    php 101 saiz: 
    mysql_connect(blah) or
          die(include("mysqlisfucked.php"));

    BesigedB on
    this is a small sig to not get in your way
  • Options
    DogDog Registered User, Administrator, Vanilla Staff admin
    edited May 2004
    BesigedB wrote:
    alphamonkey wrote:
    I dont handle the mainsite.

    php 101 saiz: 
    mysql_connect(blah) or
          die(include("mysqlisfucked.php"));

    Then, when MySQL goes down, he'll include mysqlisfucked.php 100x (one for each connect). Instead, he should prefix the mysql* commands with an at sign (@) to supress the error warnings.

    *Edit*
    I noticed the die in there, so it won't get called 100x, but still, supressing the error is a better idea anyway ;)

    Unknown User on
  • Options
    ÄlphämönkëyÄlphämönkëy Registered User regular
    edited May 2004
    You seem confused BesigedB. Myself and Ramius are both pretty good at coding. We are both familiar with the basic concepts of programming. My not patching the main site is not on account of the fact that conditional expressions for error handling is a foriegn concept, it lies in the fact that I do not manage the mainsite. It is not my area. I have the UNIX permissions to do so, its just for the most part I dont.

    If you noticed, when you tried to access the forums while MySQL was down, there was a nice error message.

    I'm way sick right now and I know Im comming off a bit bitter, so Im going to sign off.

    Älphämönkëy on
  • Options
    BesigedBBesigedB Registered User, ClubPA regular
    edited May 2004
    have some asprin on me :)

    BesigedB on
    this is a small sig to not get in your way
  • Options
    BogeyBogey I'm back, baby! Santa Monica, CAModerator mod
    edited May 2004
    Hey alpha,

    Just wanted to let you know that I've gotten the "forums are down" message like 4 times in the last 10 mins while browsing the forums.

    Bogey on
    Fitocracy: Join us in the SE++ group!
    XBox LIVE: Bogestrom | Destiny
    PSN: Bogestrom
  • Options
    ÄlphämönkëyÄlphämönkëy Registered User regular
    edited May 2004
    Thanks Im fixing that.

    Älphämönkëy on
  • Options
    ÄlphämönkëyÄlphämönkëy Registered User regular
    edited May 2004
    We still have some bugs to work out. I found that one :P

    Älphämönkëy on
  • Options
    ShiosaiShiosai Registered User, ClubPA regular
    edited May 2004
    I just got one that lasted for a few minutes...


    but now everything is working fine again.

    Shiosai on
    60353019xm5.jpg
  • Options
    erisian popeerisian pope Registered User regular
    edited May 2004
    I just got one about 60 seconds ago. It lasted about 5 seconds. I mention this only in case tracking errors by time of occurrence helps any.

    Edit - it happened again.

    erisian pope on
    Pete-sig-1.jpg
    My Website | My "photo-a-day" 2010
  • Options
    ÄlphämönkëyÄlphämönkëy Registered User regular
    edited May 2004
    Hmmm. I see where that is comming from the question now is the easiest way to fix it.

    Älphämönkëy on
  • Options
    CaptainCaptain Registered User regular
    edited May 2004
    What, you guys are still on something like 3.23?


    Ewe.

    Captain on
    232138902_1bb81e6577.jpg
  • Options
    ZoolanderZoolander Registered User regular
    edited May 2004
    I got it again as well.

    Zoolander on
  • Options
    japanjapan Registered User regular
    edited May 2004
    I seem to get MySQL errors every time I post. So I close the page, open it, and it works fine.
    wtf?

    japan on
  • Options
    ÄlphämönkëyÄlphämönkëy Registered User regular
    edited May 2004
    Cool thanks for the heads up guys. Ill look into it.

    Älphämönkëy on
  • Options
    DynagripDynagrip Break me a million hearts HoustonRegistered User, ClubPA regular
    edited May 2004
    I just got a couple of them as well.

    Dynagrip on
    http://leonidas-res.com
  • Options
    ÄlphämönkëyÄlphämönkëy Registered User regular
    edited May 2004
    I realized what is causing this. When the INSERT DELAY's finally run, they take about 60 seconds of time, causing a major backup in MySQL. The solution? InnoDB. I'll send an email to HomeLAN by Friday.

    Älphämönkëy on
  • Options
    The GeekThe Geek Oh-Two Crew, Omeganaut Registered User, ClubPA regular
    edited May 2004
    I am also getting MySGL errors all the time.

    The Geek on
    BLM - ACAB
  • Options
    DogDog Registered User, Administrator, Vanilla Staff admin
    edited May 2004
    The Geek wrote:
    I am also getting MySGL errors all the time.

    What the hell is a MySGL error?

    ;)

    Unknown User on
  • Options
    erisian popeerisian pope Registered User regular
    edited May 2004
    SeñorAmor wrote:
    The Geek wrote:
    I am also getting MySGL errors all the time.

    What the hell is a MySGL error?

    ;)

    My Seagull - it's a reference to a domesticated representative of a bird species that lives (mostly) along coasts. How that his causing him problems, however, and what he wants Alpha to do about it are beyond me.

    erisian pope on
    Pete-sig-1.jpg
    My Website | My "photo-a-day" 2010
Sign In or Register to comment.
Penny Arcade Forums› Tube's Circus Of Bug Reports and User Issues