teh database, it does nothing!

Comments, Questions, Requests, or Suggestions relating to discgolfreview.com

Moderators: Timko, Solty, Frank Delicious, Blake_T, Fritz, Booter

teh database, it does nothing!

Postby SkaBob » Thu Jan 14, 2010 12:53 pm

So, who shit in mysql's cereal this morning?
I threw Wizards before they were cool.
SkaBob
Disc Whore
 
Posts: 3493
Joined: Fri Mar 16, 2007 9:51 am
Location: Detroit
Favorite Disc: Comet

Re: teh database, it does nothing!

Postby SkaBob » Fri Jan 15, 2010 12:47 pm

SQL ERROR [ mysql4 ]

Table 'm' is marked as crashed and should be repaired [1194]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

Sounds like you guys are having a serious problem with the database. I'd recommend someone take a peek at it and see why. That shouldn't be happening, nor should the horrendous outage of errors that happened when I posted this thread.
I threw Wizards before they were cool.
SkaBob
Disc Whore
 
Posts: 3493
Joined: Fri Mar 16, 2007 9:51 am
Location: Detroit
Favorite Disc: Comet

Re: teh database, it does nothing!

Postby Timko » Fri Jan 15, 2010 2:19 pm

None of the admins that frequent the site have access (Me, Solty, or Frank). We think Fritz does, but he hasn't said yet.

The only large error I've seen is when I tried to delete a 6 repeated post from GGGT. Anyways, we're looking(ish) into it.
jsun3thousand wrote:Disc golfers are holding the sport back.
Timko
Like Angels Kicking Ass in your Mouth
User avatar
 
Posts: 7694
Joined: Wed Aug 02, 2006 10:21 pm
Location: KCMO

Re: teh database, it does nothing!

Postby Redisculous » Fri Jan 15, 2010 2:37 pm

The error I was getting was: Too many connections (1040)

I've seen it a few times but it never lasts more than a few hours.
Anode | Comet | Axis |Vector | PPD | SPD | CPD
Redisculous
Fairway Surgeon
User avatar
 
Posts: 529
Joined: Mon Oct 13, 2008 6:17 am
Location: Southern Wisconsin, where the best courses are in Illinois!
Favorite Disc: Axis

Re: teh database, it does nothing!

Postby Timko » Fri Jan 15, 2010 2:47 pm

Redisculous wrote:The error I was getting was: Too many connections (1040)

I've seen it a few times but it never lasts more than a few hours.


I think that's a bandwidth error.
jsun3thousand wrote:Disc golfers are holding the sport back.
Timko
Like Angels Kicking Ass in your Mouth
User avatar
 
Posts: 7694
Joined: Wed Aug 02, 2006 10:21 pm
Location: KCMO

Re: teh database, it does nothing!

Postby SkaBob » Fri Jan 15, 2010 3:27 pm

No, too many connections indicates that the database server thinks that there're too many user connections attempting to access data. Usually this is because it's surpassed a configured limit, but when associated with other problems like the one I got, it's usually indicative of the database not being functional enough to keep up with the normal load.
I threw Wizards before they were cool.
SkaBob
Disc Whore
 
Posts: 3493
Joined: Fri Mar 16, 2007 9:51 am
Location: Detroit
Favorite Disc: Comet

Re: teh database, it does nothing!

Postby chiggins » Fri Jan 15, 2010 4:13 pm

SkaBob wrote:it's usually indicative of the database not being functional enough to keep up with the normal load.


This can also happen when the server's spawning too many children, or when server requests are leaving db handles open.
chiggins
2009 DGR Donator
User avatar
 
Posts: 751
Joined: Mon Apr 27, 2009 8:51 am

Re: teh database, it does nothing!

Postby emiller3 » Fri Jan 15, 2010 4:54 pm

It's been this way (Table 'm' is marked as crashed and should be repaired [1194]) since at least yesterday afternoon when I tried searching.
Trades | Bag | Drives | KC Aviar - Roc - Eagle - Monster - Valk - Destroyer
emiller3
1000 Rated Poster
User avatar
 
Posts: 1336
Joined: Thu Feb 21, 2008 9:49 am
Location: CO
Favorite Disc: Roc

Re: teh database, it does nothing!

Postby elnino » Fri Jan 15, 2010 7:23 pm

General Error
SQL ERROR [ mysql4 ]

Table 'm0' is marked as crashed and should be repaired [1194]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.


Same error as others while searching! firefox and ie both had errors!
Positive feedback 56 Trade
Destroyer=Firebird=Striker=Roc=Wizard
elnino
Fairway Surgeon
 
Posts: 703
Joined: Wed Dec 03, 2008 6:04 pm
Favorite Disc: Firebird/wizard

Re: teh database, it does nothing!

Postby Frank Delicious » Fri Jan 15, 2010 8:44 pm

chiggins wrote:
SkaBob wrote:it's usually indicative of the database not being functional enough to keep up with the normal load.


This can also happen when the server's spawning too many children, or when server requests are leaving db handles open.


There is update that is suppose to fix this problem but we have to see who has access to the backend to apply it.
Frank Delicious
The Crime Prince of Clown
User avatar
 
Posts: 12364
Joined: Thu Mar 23, 2006 3:43 pm
Location: Drowning in a cold river
Favorite Disc: Wraith

Re: teh database, it does nothing!

Postby Redisculous » Fri Jan 15, 2010 11:17 pm

... Isn't anyone going to make a joke about Frank D looking for access to the back end?
Anode | Comet | Axis |Vector | PPD | SPD | CPD
Redisculous
Fairway Surgeon
User avatar
 
Posts: 529
Joined: Mon Oct 13, 2008 6:17 am
Location: Southern Wisconsin, where the best courses are in Illinois!
Favorite Disc: Axis

Re: teh database, it does nothing!

Postby Frank Delicious » Fri Jan 15, 2010 11:24 pm

Redisculous wrote:... Isn't anyone going to make a joke about Frank D looking for access to the back end?


Image
Frank Delicious
The Crime Prince of Clown
User avatar
 
Posts: 12364
Joined: Thu Mar 23, 2006 3:43 pm
Location: Drowning in a cold river
Favorite Disc: Wraith


Return to Website Comments

Who is online

Users browsing this forum: No registered users and 1 guest