Blog Documentation Try Vanilla Cloud
Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Options

MySQL error

alex9alex9
edited March 2007 in Vanilla 1.0 Help
Our forum site has been going crazy today, really moving slow. Then after hours of dodgy slowness, I get this error: *************** A fatal, non-recoverable error has occurred Technical information (for support personel): Error Message The connection to the database failed: Affected Elements MySQL.OpenConnection(); The error occurred on or near: Can't connect to MySQL server on 'yoursite' (111) *************** Anyone know what this is?

Comments

  • Options
    alex9alex9
    ..and now it works. Our IT guy says the way the forum is setup is hard on the server, something about how it parses the info?
  • Options
    alex9alex9
    edited March 2007
    ..and now it doesn't work.. eee. From my IT guy: There is problem with how the site is indexed. Recovering (with sort) MyISAM-table 'yoursite_com_community/LUM_IpHistory.MYI' Data records: 429290 I'm being told to upgrade our server. And this has only been online for 4.5 months with only 30MB of db size. Anyone else have this problem?
  • Options
    alex9alex9
    edited March 2007
    Another error: The error occurred on or near: Got error 127 from table handler I wonder if it's just a little thing like: http://lussumo.com/community/discussion/1148/
  • Options
    WallPhoneWallPhone
    edited March 2007
    It looks like 111 is a standard MySql can't connect error. This might help: http://www.vbulletin.com/forum/showthread.php?t=108032 And 127: http://www.vbulletin.com/forum/showthread.php?t=100983
  • Options
    MarkMark Vanilla Staff
    For the record, it's pretty much standard practice for hosting providers to blame software (typically software you installed) when errors occur. This is a server problem. Saying that it has something to do with the way that Vanilla parses information is complete bs.
  • Options
    alex9alex9
    Thanks guys! After restarting the server, we repaired the db and it was fixed. We did have a high load average all afternoon (from 4-20), so I think quite a few things were causing this problem. Too many hits, too many connections to the db? The server we're running this on is: Model Intel(R) Celeron(R) CPU 2.00GHz Chip MHz 1999.97 MHz Cache Size 128 KB We're also streaming a radio station feed on the same server. So, we may have to upgrade the server. Thanks again. That was bizarre.
This discussion has been closed.