Page 1 of 1
SQL server is having a cow
Posted: Tue Apr 12, 2011 10:41 am
by Manhattan Glutton
It's been going on a for a few weeks now. A sporadic error message along the lines of "mysql.songfight.net is shitting a large brick". Seems particularly bad today.
Perhaps your host is having problems, or some application is hammering the database?
SQL ERROR [ mysqli ]
Can't connect to MySQL server on 'mysql.songfight.net' (110) [2003]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Re: SQL server is having a cow
Posted: Tue Apr 12, 2011 10:55 am
by irwin
I've been seeing that a lot today as well.
Re: SQL server is having a cow
Posted: Tue Apr 12, 2011 11:19 am
by fluffy
I'll pester Dreamhost support. I suspect their answer will be "get a VPS." (That is their answer for everything, lately.)
Re: SQL server is having a cow
Posted: Tue Apr 12, 2011 11:29 am
by Manhattan Glutton
Hey I have unlimited bandwidth, hosts, and space with them - let's move everything to my account and save $10/month. (joke)
Re: SQL server is having a cow
Posted: Tue Apr 12, 2011 12:48 pm
by Lunkhead
If you guys move to something that allows Java apps I will gladly write SongFight 2.0 for you.
Re: SQL server is having a cow
Posted: Tue Apr 12, 2011 1:05 pm
by fluffy
Anything 2.0 should be Ruby on Rails, shouldn't it?
Re: SQL server is having a cow
Posted: Tue Apr 12, 2011 1:16 pm
by Lunkhead
Don't believe the hype! Java's not quite dead yet. And free services aren't enough, you need them to be in the language of your choosing? Beggars can't be choosers, eh?
Re: SQL server is having a cow
Posted: Tue Apr 12, 2011 1:28 pm
by Manhattan Glutton
hay guyz can i rewrite song fight in VB6 and/or autohotkey script? it'll store the fights in ini files
Re: SQL server is having a cow
Posted: Wed Apr 13, 2011 10:06 am
by Spud
Songfight 2.0 will not fix the problems that phpBB is having with the SQL server...
Re: SQL server is having a cow
Posted: Thu Apr 14, 2011 12:09 am
by jast
Actually, I think if MG rewrites the board in VB6, too, it will simply work without the SQL server. Just imagine — all of the data stored in INI files. Genius!
Re: SQL server is having a cow
Posted: Thu Apr 14, 2011 2:43 pm
by Manhattan Glutton
If I'm not mistaken, the SF archive is already flatfiles and thus immune to this SQL problem. So, we just need to switch the phpBB storage backend from MySQL to SQLite, which should be fairly straight-forward for PHP... but this is probably not a good idea.
Re: SQL server is having a cow
Posted: Thu Apr 14, 2011 4:01 pm
by jast
The probability of it not being a good idea is fairly high.
Re: SQL server is having a cow
Posted: Thu Apr 14, 2011 4:21 pm
by fluffy
We could always use BerkeleyDB!
Re: SQL server is having a cow
Posted: Thu Apr 14, 2011 10:44 pm
by Spud
Manhattan Glutton wrote:If I'm not mistaken, the SF archive is already flatfiles and thus immune to this SQL problem.
Thanks, MG. I knew that there was something good about it!
Re: SQL server is having a cow
Posted: Fri Apr 15, 2011 12:13 am
by fluffy
Not flat files. One giant text file with a woefully inconsistent and ad-hoc pile of weird.
Re: SQL server is having a cow
Posted: Fri Apr 15, 2011 3:19 am
by jast
fluffy wrote:We could always use BerkeleyDB!
Yeah, let's use BerkeleyDB, the reason why software like OpenLDAP is so great at making for lots of entertainment after a power outage.
Re: SQL server is having a cow
Posted: Fri Apr 15, 2011 2:13 pm
by Spud
fluffy wrote:Not flat files. One giant text file with a woefully inconsistent and ad-hoc pile of weird.
fluffy, you actually made me laugh out loud. Alas, it's only too true. But that's what I love about it. And you. Thanks.
SPUD