Blog Documentation Book a Demo
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

  • 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?
  • 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?
  • 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/
  • 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
  • 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.
  • 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.