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.
Post Reply
User avatar
Manhattan Glutton
Ice Cream Man
Posts: 1530
Joined: Tue Feb 15, 2005 12:10 pm
Instruments: Angst
Recording Method: REAPER
Location: Madison, WI
Contact:

SQL server is having a cow

Post 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.
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
Mean Street
Posts: 617
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

Post by irwin »

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
Eruption
Posts: 11029
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Pronouns: she/they
Location: Seattle-ish
Contact:

Re: SQL server is having a cow

Post by fluffy »

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
Ice Cream Man
Posts: 1530
Joined: Tue Feb 15, 2005 12:10 pm
Instruments: Angst
Recording Method: REAPER
Location: Madison, WI
Contact:

Re: SQL server is having a cow

Post 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)
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
Lunkhead
You're No Good
Posts: 8107
Joined: Sat Sep 25, 2004 12:14 pm
Instruments: many
Recording Method: cubase/mac/tascam4x4
Submitting as: Berkeley Social Scene, Merisan, Tiny Robots
Pronouns: he/him
Location: Berkeley, CA
Contact:

Re: SQL server is having a cow

Post by Lunkhead »

If you guys move to something that allows Java apps I will gladly write SongFight 2.0 for you. ;)
User avatar
fluffy
Eruption
Posts: 11029
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Pronouns: she/they
Location: Seattle-ish
Contact:

Re: SQL server is having a cow

Post by fluffy »

Anything 2.0 should be Ruby on Rails, shouldn't it?
User avatar
Lunkhead
You're No Good
Posts: 8107
Joined: Sat Sep 25, 2004 12:14 pm
Instruments: many
Recording Method: cubase/mac/tascam4x4
Submitting as: Berkeley Social Scene, Merisan, Tiny Robots
Pronouns: he/him
Location: Berkeley, CA
Contact:

Re: SQL server is having a cow

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

Re: SQL server is having a cow

Post by Manhattan Glutton »

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
Hot for Teacher
Posts: 4770
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

Post by Spud »

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
Ice Cream Man
Posts: 1325
Joined: Tue Jul 29, 2008 7:03 pm
Instruments: Vocals, guitar
Recording Method: Cubase, Steinberg UR44
Submitting as: Jan Krueger
Pronouns: .
Location: near Aachen, Germany
Contact:

Re: SQL server is having a cow

Post 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!
User avatar
Manhattan Glutton
Ice Cream Man
Posts: 1530
Joined: Tue Feb 15, 2005 12:10 pm
Instruments: Angst
Recording Method: REAPER
Location: Madison, WI
Contact:

Re: SQL server is having a cow

Post 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.
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
Ice Cream Man
Posts: 1325
Joined: Tue Jul 29, 2008 7:03 pm
Instruments: Vocals, guitar
Recording Method: Cubase, Steinberg UR44
Submitting as: Jan Krueger
Pronouns: .
Location: near Aachen, Germany
Contact:

Re: SQL server is having a cow

Post by jast »

The probability of it not being a good idea is fairly high.
User avatar
fluffy
Eruption
Posts: 11029
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Pronouns: she/they
Location: Seattle-ish
Contact:

Re: SQL server is having a cow

Post by fluffy »

We could always use BerkeleyDB!
User avatar
Spud
Hot for Teacher
Posts: 4770
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

Post 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!
"I only listen to good music. And Octothorpe." - Marcus Kellis
Song Fight! The Rockening
User avatar
fluffy
Eruption
Posts: 11029
Joined: Sat Sep 25, 2004 10:56 am
Instruments: sometimes
Recording Method: Logic Pro X
Submitting as: Sockpuppet
Pronouns: she/they
Location: Seattle-ish
Contact:

Re: SQL server is having a cow

Post by fluffy »

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

Re: SQL server is having a cow

Post 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.
User avatar
Spud
Hot for Teacher
Posts: 4770
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

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