User Support & Resources Account Problems | Questions | Suggestions

Database error --- just me?

Thread Tools
 
Search this Thread
 
Old Apr 21, 2005 | 11:13 PM
  #1  
Brandon Boomhauer's Avatar
Thread Starter
TECH Senior Member
iTrader: (10)
 
Joined: Nov 2001
Posts: 8,766
Likes: 0
From: Gainesville, Denton TX
Default Database error --- just me?

I've been getting the ol' database error on occasion the last couple days, any reason???
Reply
Old Apr 21, 2005 | 11:16 PM
  #2  
XLR8NSS's Avatar
Adkoonerstrator
iTrader: (4)
 
Joined: Nov 2001
Posts: 21,420
Likes: 0
From: Deep in the seedy underworld of Koonerville
Default

Not sure of the exact reason but, I'm sure Brains could shed some light on the situation.

It's not just you, it's been happening ALOT lately.
Reply
Old Apr 21, 2005 | 11:30 PM
  #3  
ACW's Avatar
ACW
TECH Veteran
 
Joined: Dec 2004
Posts: 4,012
Likes: 1
From: Beaumont, TX
Default

I have seen them occasionally too, but it never lasts - page loads successfully on the next attempt.

Last edited by ACW; Apr 25, 2005 at 09:43 PM.
Reply
Old Apr 21, 2005 | 11:33 PM
  #4  
XLR8NSS's Avatar
Adkoonerstrator
iTrader: (4)
 
Joined: Nov 2001
Posts: 21,420
Likes: 0
From: Deep in the seedy underworld of Koonerville
Default

Originally Posted by ACW
I have seen them occasionally too, but it never lasts - page loads successfully on the next attempt.
That's because Brains has a watchdog program to "reboot" the site when it goes down. When he didn't have that you'd just have to wait until he noticed or got a call that the site was down. Thank goodness he is the DA MAN!!
Reply
Old Apr 22, 2005 | 12:56 AM
  #5  
cyphur's Avatar
TECH Senior Member
iTrader: (10)
 
Joined: Mar 2003
Posts: 8,009
Likes: 0
From: North Texas
Default

really guys its just cuz Brandon is a lazy bitch. thats why his pages don't load.
Reply
Old Apr 22, 2005 | 09:39 AM
  #6  
777's Avatar
777
TECH Senior Member
iTrader: (21)
 
Joined: Jun 2004
Posts: 6,697
Likes: 2
From: Jacksonville, FL
Default

when did you become a mod cyphur traq...i was wondering when that was going to happen
Reply
Old Apr 22, 2005 | 12:17 PM
  #7  
Brandon Boomhauer's Avatar
Thread Starter
TECH Senior Member
iTrader: (10)
 
Joined: Nov 2001
Posts: 8,766
Likes: 0
From: Gainesville, Denton TX
Default

think it happened wednesday night..
Reply
Old Apr 22, 2005 | 01:12 PM
  #8  
bowtieman81's Avatar
TECH Fanatic
iTrader: (35)
 
Joined: Sep 2004
Posts: 1,660
Likes: 0
From: Maryland/Illinois
Default

the search feature seems to be down currently. I can't search in any of the forums
Reply
LS1 Tech Stories

The Best V8 Stories One Small Block at Time

story-0

Retro Modern Bandit Pontiac Trans AM Comes With Burt Reynolds' Autograph

 Verdad Gallardo
story-1

Top 10 Greatest Cadillac V Series Performance Models Ever, Ranked

 Pouria Savadkouei
story-2

Top 10 Most Powerful Chevy Trucks Ever Made!

 
story-3

Hennessey's New Supercharged Silverado ZR2 Has 700 HP

 Verdad Gallardo
story-4

Coachbuilt N2A Anteros Is an LS2-Powered C6 Corvette In Italian Clothes

 Verdad Gallardo
story-5

Awesome K5 Blazer Restomod Comes With C7 Corvette Power

 Verdad Gallardo
story-6

10 Camaros You Should Never Buy

 
story-7

10 LS Engine Myths That Refuse to Die

 Verdad Gallardo
story-8

Five Reasons the Camaro Was the Most Pivotal Player in the Pony Car Wars 2.0

 Brett Foote
story-9

10 Reasons the LS7 Is GM's Most Extreme Naturally Aspirated V8 Engine Ever

 Verdad Gallardo
Old Apr 22, 2005 | 01:52 PM
  #9  
Phoenix 5.7's Avatar
TECH Junkie
iTrader: (7)
 
Joined: Aug 2004
Posts: 3,809
Likes: 0
From: Prairie de Femme, LA
Default

yup, but u have top expect problems with a database this large. this is a big site for primarily one guy to manage as far as the server part.
Reply
Old Apr 22, 2005 | 02:19 PM
  #10  
shouldaboughttheZ's Avatar
TECH Addict
iTrader: (8)
 
Joined: Nov 2004
Posts: 2,036
Likes: 0
From: H-Town
Default

Originally Posted by bowtieman81
the search feature seems to be down currently. I can't search in any of the forums
I tried also and got nothing. I usually just wait and try later.
Reply
Old Apr 22, 2005 | 02:31 PM
  #11  
Brains's Avatar
TECH Senior Member
iTrader: (7)
 
Joined: Jan 2002
Posts: 12,754
Likes: 0
From: Katy, TX
Default

Search will be back up momentarily..
Reply
Old Apr 23, 2005 | 12:47 AM
  #12  
cyphur's Avatar
TECH Senior Member
iTrader: (10)
 
Joined: Mar 2003
Posts: 8,009
Likes: 0
From: North Texas
Default

Originally Posted by 777
when did you become a mod cyphur traq...i was wondering when that was going to happen
it was the middle of this week. and thanks for the compliment.
Reply
Old Apr 23, 2005 | 01:42 AM
  #13  
Phoenix 5.7's Avatar
TECH Junkie
iTrader: (7)
 
Joined: Aug 2004
Posts: 3,809
Likes: 0
From: Prairie de Femme, LA
Default

they will make anyone a mod, first badjuju, and now cyphur_traq congrats dude
Reply
Old Apr 23, 2005 | 06:03 AM
  #14  
Daley's Avatar
Launching!
 
Joined: Mar 2005
Posts: 257
Likes: 0
From: H-Town
Default

Based on my experience with administering other boards, these problems typically surface when people do large queries on the database. More specifically, when an admin or mod does a search my IP address for a user, the database gets taxed heavily, as the IP table is not indexed. This causes the database server to have to work overtime because it has to process the normal requests for the board as well as the large query that's being requested. Not sure if that's what's going on here, but just a thought. As always, your friendly neighborhood Admin could confirm this - or not.
Reply
Old Apr 23, 2005 | 10:48 AM
  #15  
ACW's Avatar
ACW
TECH Veteran
 
Joined: Dec 2004
Posts: 4,012
Likes: 1
From: Beaumont, TX
Default

Brains (one of the admins) has done a LOT of work on adjusting the site's database and code for optimal performance! IIRC, this site has a much larger active database than any other site using this software. We actually have a separate server just for handling search requests. There are always going to be occasional little glitches, don't worry, he's got it under control and knows what he's doing

Last edited by ACW; Apr 25, 2005 at 09:44 PM.
Reply
Old Apr 23, 2005 | 12:00 PM
  #16  
Brandon Boomhauer's Avatar
Thread Starter
TECH Senior Member
iTrader: (10)
 
Joined: Nov 2001
Posts: 8,766
Likes: 0
From: Gainesville, Denton TX
Default

yeah, it hasnt happened since i posted really. Just wanted to make note of it.
Reply
Old Apr 23, 2005 | 02:41 PM
  #17  
XLR8NSS's Avatar
Adkoonerstrator
iTrader: (4)
 
Joined: Nov 2001
Posts: 21,420
Likes: 0
From: Deep in the seedy underworld of Koonerville
Default

Originally Posted by Daley
Based on my experience with administering other boards, these problems typically surface when people do large queries on the database. More specifically, when an admin or mod does a search my IP address for a user, the database gets taxed heavily, as the IP table is not indexed. This causes the database server to have to work overtime because it has to process the normal requests for the board as well as the large query that's being requested. Not sure if that's what's going on here, but just a thought. As always, your friendly neighborhood Admin could confirm this - or not.
I'll go ahead and confirm that some of the IP search stuff causes the site to go down. SOOOO, you new mods stay outta the search in the mod panel.
Reply
Old Apr 23, 2005 | 03:07 PM
  #18  
Brandon Boomhauer's Avatar
Thread Starter
TECH Senior Member
iTrader: (10)
 
Joined: Nov 2001
Posts: 8,766
Likes: 0
From: Gainesville, Denton TX
Default

coughcyphurcough
Reply
Old Apr 23, 2005 | 04:54 PM
  #19  
cyphur's Avatar
TECH Senior Member
iTrader: (10)
 
Joined: Mar 2003
Posts: 8,009
Likes: 0
From: North Texas
Default

hahahaha i haven't even looked for IP's yet. have had no reason for it.
Reply
Old Apr 24, 2005 | 01:24 AM
  #20  
Brains's Avatar
TECH Senior Member
iTrader: (7)
 
Joined: Jan 2002
Posts: 12,754
Likes: 0
From: Katy, TX
Default

XLR8 is good at wiping out the site, so if you get a DB error chances are it was HIM !!!
Reply




All times are GMT -5. The time now is 07:03 AM.

story-0
Retro Modern Bandit Pontiac Trans AM Comes With Burt Reynolds' Autograph

Slideshow: A modern Camaro transformed into a retro icon, this limited-run "Bandit" build blends nostalgia with brute force in a way few revivals manage.

By Verdad Gallardo | 2026-04-21 13:57:02


VIEW MORE
story-1
Top 10 Greatest Cadillac V Series Performance Models Ever, Ranked

Slideshow: Cadillac didn't just crash the high-performance luxury vehicle party, it showed up loud, supercharged, and occasionally a little unhinged...

By Pouria Savadkouei | 2026-04-16 10:05:15


VIEW MORE
story-2
Top 10 Most Powerful Chevy Trucks Ever Made!

Slideshow: Top ten most powerful Chevy trucks ever made

By | 2026-03-25 09:22:26


VIEW MORE
story-3
Hennessey's New Supercharged Silverado ZR2 Has 700 HP

Slideshow: Hennessey has turned the Silverado ZR2 into a 700-hp off-road monster with supercharged V8 power and a limited production run.

By Verdad Gallardo | 2026-03-24 18:57:52


VIEW MORE
story-4
Coachbuilt N2A Anteros Is an LS2-Powered C6 Corvette In Italian Clothes

Slideshow: A one-off sports car that looks like a vintage Italian exotic-but hides a C6 Corvette underneath-just sold for the price of a new mid-engine Corvette.

By Verdad Gallardo | 2026-03-23 18:53:41


VIEW MORE
story-5
Awesome K5 Blazer Restomod Comes With C7 Corvette Power

Slideshow: A heavily reworked 1972 K5 Blazer swaps its off-road roots for a low-slung street-focused build with modern V8 power.

By Verdad Gallardo | 2026-03-09 18:08:45


VIEW MORE
story-6
10 Camaros You Should Never Buy

Slideshow: There are thousands of used Camaros on the market but we think you should avoid these 10

By | 2026-02-17 17:09:30


VIEW MORE
story-7
10 LS Engine Myths That Refuse to Die

Slideshows: Which one of these myths do you believe?

By Verdad Gallardo | 2026-01-28 18:10:11


VIEW MORE
story-8
Five Reasons the Camaro Was the Most Pivotal Player in the Pony Car Wars 2.0

The world was a better place when it was still around.

By Brett Foote | 2026-01-23 09:20:37


VIEW MORE
story-9
10 Reasons the LS7 Is GM's Most Extreme Naturally Aspirated V8 Engine Ever

Slideshow: The 7.0-liter LS7 was designed for absolute cutting-edge performance.

By Verdad Gallardo | 2026-01-07 18:36:00


VIEW MORE