SQL server is having a cow

Let us know when something isn't working correctly, or if you find a typo. Do not post complaints or suggestions here.

Moderator: Mods

User avatar
Manhattan Glutton
Hachikō
Posts: 1521
Joined: Tue Feb 15, 2005 12:10 pm
Instruments: Angst
Recording Method: REAPER
Location: Madison, WI
Contact:

SQL server is having a cow

Postby Manhattan Glutton » Tue Apr 12, 2011 10:41 am

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.
If I had a dollar for every one of my songs j$ has called a 90s pastiche, I'd have $1 for every song I've written.

Nur Ein Archives | The New Ugly Podcast
User avatar
irwin
Lassie
Posts: 502
Joined: Mon Jan 22, 2007 10:09 pm
Instruments: insecurity
Recording Method: scotch
Submitting as: suckweasel, kasper, nutwalls
Location: Woodland, CA

Re: SQL server is having a cow

Postby irwin » Tue Apr 12, 2011 10:55 am

I've been seeing that a lot today as well.
"Ouch. I wonder if this guy sounds like this when he speaks." -- Puce
User avatar
fluffy
Boo
Posts: 9429
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Location: The Plaidlands (also, Seattle)
Contact:

Re: SQL server is having a cow

Postby fluffy » Tue Apr 12, 2011 11:19 am

I'll pester Dreamhost support. I suspect their answer will be "get a VPS." (That is their answer for everything, lately.)
User avatar
Manhattan Glutton
Hachikō
Posts: 1521
Joined: Tue Feb 15, 2005 12:10 pm
Instruments: Angst
Recording Method: REAPER
Location: Madison, WI
Contact:

Re: SQL server is having a cow

Postby Manhattan Glutton » Tue Apr 12, 2011 11:29 am

Hey I have unlimited bandwidth, hosts, and space with them - let's move everything to my account and save $10/month. (joke)
If I had a dollar for every one of my songs j$ has called a 90s pastiche, I'd have $1 for every song I've written.

Nur Ein Archives | The New Ugly Podcast
Lunkhead
Owney
Posts: 5434
Joined: Sat Sep 25, 2004 12:14 pm
Instruments: many
Recording Method: cubase/reason/mac/tascam4x4
Submitting as: Berkeley Social Scene, Merisan, Tiny Robots
Location: Berkeley, CA
Contact:

Re: SQL server is having a cow

Postby Lunkhead » Tue Apr 12, 2011 12:48 pm

If you guys move to something that allows Java apps I will gladly write SongFight 2.0 for you. ;)
User avatar
fluffy
Boo
Posts: 9429
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Location: The Plaidlands (also, Seattle)
Contact:

Re: SQL server is having a cow

Postby fluffy » Tue Apr 12, 2011 1:05 pm

Anything 2.0 should be Ruby on Rails, shouldn't it?
Lunkhead
Owney
Posts: 5434
Joined: Sat Sep 25, 2004 12:14 pm
Instruments: many
Recording Method: cubase/reason/mac/tascam4x4
Submitting as: Berkeley Social Scene, Merisan, Tiny Robots
Location: Berkeley, CA
Contact:

Re: SQL server is having a cow

Postby Lunkhead » Tue Apr 12, 2011 1:16 pm

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? :P
User avatar
Manhattan Glutton
Hachikō
Posts: 1521
Joined: Tue Feb 15, 2005 12:10 pm
Instruments: Angst
Recording Method: REAPER
Location: Madison, WI
Contact:

Re: SQL server is having a cow

Postby Manhattan Glutton » Tue Apr 12, 2011 1:28 pm

hay guyz can i rewrite song fight in VB6 and/or autohotkey script? it'll store the fights in ini files
If I had a dollar for every one of my songs j$ has called a 90s pastiche, I'd have $1 for every song I've written.

Nur Ein Archives | The New Ugly Podcast
User avatar
Spud
Scrappy Dappy
Posts: 4742
Joined: Fri Sep 24, 2004 10:25 am
Instruments: Bass, Keyboards, eHorn
Submitting as: Octothorpe
Location: Seattle
Contact:

Re: SQL server is having a cow

Postby Spud » Wed Apr 13, 2011 10:06 am

Songfight 2.0 will not fix the problems that phpBB is having with the SQL server...
"I only listen to good music. And Octothorpe." - Marcus Kellis
Song Fight! The Rockening
User avatar
jast
Hachikō
Posts: 1153
Joined: Tue Jul 29, 2008 7:03 pm
Instruments: Vocals, guitar
Recording Method: REAPER, Steinberg UR44
Submitting as: Jan Krueger
Location: near Aachen, Germany
Contact:

Re: SQL server is having a cow

Postby jast » Thu Apr 14, 2011 12:09 am

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!
most of my music
Song Fight-related stuff I host: ZIP archives // Circle of Titles
User avatar
Manhattan Glutton
Hachikō
Posts: 1521
Joined: Tue Feb 15, 2005 12:10 pm
Instruments: Angst
Recording Method: REAPER
Location: Madison, WI
Contact:

Re: SQL server is having a cow

Postby Manhattan Glutton » Thu Apr 14, 2011 2:43 pm

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.
If I had a dollar for every one of my songs j$ has called a 90s pastiche, I'd have $1 for every song I've written.

Nur Ein Archives | The New Ugly Podcast
User avatar
jast
Hachikō
Posts: 1153
Joined: Tue Jul 29, 2008 7:03 pm
Instruments: Vocals, guitar
Recording Method: REAPER, Steinberg UR44
Submitting as: Jan Krueger
Location: near Aachen, Germany
Contact:

Re: SQL server is having a cow

Postby jast » Thu Apr 14, 2011 4:01 pm

The probability of it not being a good idea is fairly high.
most of my music
Song Fight-related stuff I host: ZIP archives // Circle of Titles
User avatar
fluffy
Boo
Posts: 9429
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Location: The Plaidlands (also, Seattle)
Contact:

Re: SQL server is having a cow

Postby fluffy » Thu Apr 14, 2011 4:21 pm

We could always use BerkeleyDB!
User avatar
Spud
Scrappy Dappy
Posts: 4742
Joined: Fri Sep 24, 2004 10:25 am
Instruments: Bass, Keyboards, eHorn
Submitting as: Octothorpe
Location: Seattle
Contact:

Re: SQL server is having a cow

Postby Spud » Thu Apr 14, 2011 10:44 pm

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!
"I only listen to good music. And Octothorpe." - Marcus Kellis
Song Fight! The Rockening
User avatar
fluffy
Boo
Posts: 9429
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Location: The Plaidlands (also, Seattle)
Contact:

Re: SQL server is having a cow

Postby fluffy » Fri Apr 15, 2011 12:13 am

Not flat files. One giant text file with a woefully inconsistent and ad-hoc pile of weird.
User avatar
jast
Hachikō
Posts: 1153
Joined: Tue Jul 29, 2008 7:03 pm
Instruments: Vocals, guitar
Recording Method: REAPER, Steinberg UR44
Submitting as: Jan Krueger
Location: near Aachen, Germany
Contact:

Re: SQL server is having a cow

Postby jast » Fri Apr 15, 2011 3:19 am

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.
most of my music
Song Fight-related stuff I host: ZIP archives // Circle of Titles
User avatar
Spud
Scrappy Dappy
Posts: 4742
Joined: Fri Sep 24, 2004 10:25 am
Instruments: Bass, Keyboards, eHorn
Submitting as: Octothorpe
Location: Seattle
Contact:

Re: SQL server is having a cow

Postby Spud » Fri Apr 15, 2011 2:13 pm

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
"I only listen to good music. And Octothorpe." - Marcus Kellis
Song Fight! The Rockening

Return to “Quality Control”

Who is online

Users browsing this forum: No registered users and 2 guests