View previous topic :: View next topic |
Author |
Message |
kal Forum Administrator
Joined: 06 Mar 2006 Posts: 17850 Location: Ottawa, Canada
TV/Projector: JVC DLA-NZ7
|
Link Posted: Fri Oct 23, 2009 2:20 pm Post subject: POST HERE: 'Could not connect to the database' errors |
|
|
We moved to a dedicated server on October 21, 2009 and we're still having intermittent database outages. I need some idea of when they're happening so that I can track them and help resolve them.
If you get a "Could not connect to the database" error please post here with the data and time as well as how long the outage lasted instead of emailing me. If someone's already covered an outage no need to post a second time. Thanks!
Kal
_________________
Support our site by using our affiliate links. We thank you!
My basement/HT/bar/brewery build 2.0
Last edited by kal on Fri Oct 23, 2009 5:40 pm; edited 2 times in total
|
|
Back to top |
|
|
kal Forum Administrator
Joined: 06 Mar 2006 Posts: 17850 Location: Ottawa, Canada
TV/Projector: JVC DLA-NZ7
|
|
Back to top |
|
|
WanMan
Joined: 19 Mar 2006 Posts: 10273
|
Link Posted: Fri Oct 23, 2009 3:30 pm Post subject: |
|
|
Hah, me first.
_________________ Trust no one. Absolutely no one. Advice of the board.
|
|
Back to top |
|
|
nuttall_chris
Joined: 08 Mar 2006 Posts: 832 Location: Ottawa, Ontario, Canada
|
Link Posted: Fri Oct 23, 2009 7:32 pm Post subject: |
|
|
Just lost connection from 3:27 until 3:31.
Chris.
|
|
Back to top |
|
|
kal Forum Administrator
Joined: 06 Mar 2006 Posts: 17850 Location: Ottawa, Canada
TV/Projector: JVC DLA-NZ7
|
|
Back to top |
|
|
nuttall_chris
Joined: 08 Mar 2006 Posts: 832 Location: Ottawa, Ontario, Canada
|
Link Posted: Fri Oct 23, 2009 7:38 pm Post subject: |
|
|
Not sure if it was the same. Firefox just stated that it could not connect to the site. IE reported something similar. Also tried on another computer on a different network and got the same response using IE.
Chris.
|
|
Back to top |
|
|
ecrabb Forum Moderator
Joined: 13 Mar 2006 Posts: 15909 Location: Utah
TV/Projector: JVC RS40, Epson 5010
|
Link Posted: Fri Oct 23, 2009 8:07 pm Post subject: |
|
|
I haven't gotten that error since the switch, but I did just get REALLY slow response from the server... As in, it took almost a minute for the forum index page to load. 3:04-3:05 CDT.
SC
|
|
Back to top |
|
|
CRT_Ben
Joined: 28 Aug 2006 Posts: 1684 Location: Northern Virginia
|
Link Posted: Fri Oct 23, 2009 8:30 pm Post subject: |
|
|
phpBB : Critical Error Could not connect to the database 4:25 - 4:29pm EST
|
|
Back to top |
|
|
MikeEby
Joined: 24 Jun 2007 Posts: 5238 Location: Osceola, Indiana
|
Link Posted: Fri Oct 23, 2009 8:52 pm Post subject: |
|
|
ecrabb wrote: | I haven't gotten that error since the switch, but I did just get REALLY slow response from the server... As in, it took almost a minute for the forum index page to load. 3:04-3:05 CDT.
SC |
Yeah...same here...very sluggish but no errors...I'm really not a big fan of MySQL....this was about 4:10 EST.
Just did it again twice...7:53 and 7:56 PM EST took almost minute to edit this post....No errors...
Kal...Is this on a real dedicated server or a virtual dedicated server?
Mike
_________________ Doing HD since the last century!
Last edited by MikeEby on Sat Oct 24, 2009 12:01 am; edited 3 times in total
|
|
Back to top |
|
|
garyfritz
Joined: 08 Apr 2006 Posts: 12024 Location: Fort Collins, CO
|
Link Posted: Fri Oct 23, 2009 11:55 pm Post subject: |
|
|
Same here. Haven't seen any database errors for a few days but I just waited about 3-4 minutes or more for a page to load.
|
|
Back to top |
|
|
kal Forum Administrator
Joined: 06 Mar 2006 Posts: 17850 Location: Ottawa, Canada
TV/Projector: JVC DLA-NZ7
|
Link Posted: Sat Oct 24, 2009 12:14 am Post subject: |
|
|
Sorry guys - a lot of the slowdowns are me. I'm doing all sorts of maintenance.
I've been working with my hosting company and their response is simply that there's too much data to wade through ever time someone goes to use the forum. D
So I've been doing something that I was hoping (and figuring) I'd never have to do: Nuke old posts. Any threads over 800-900 days old where nobody's replied I've been removing. This doesn't include polls, stickies, annoucements, and some of the forums that contain mostly old stuff. The hardest hit was the OFF TOPIC forum which is no big deal I'm assuming. Few people will go back and re-read old stuff.
Our database has come down from nearly 500mb to ~250mb now.
Kal
_________________
Support our site by using our affiliate links. We thank you!
My basement/HT/bar/brewery build 2.0
|
|
Back to top |
|
|
AnalogRocks Forum Moderator
Joined: 08 Mar 2006 Posts: 26690 Location: Toronto, Ontario, Canada
TV/Projector: Sony 1252Q, AMPRO 4000G
|
Link Posted: Sat Oct 24, 2009 12:16 am Post subject: |
|
|
Kal! Why didn't you archive it?!
You nuked around 5000 of my post's!!
4589!
_________________ Tech support for nothing
CRT.
HD done right!
Last edited by AnalogRocks on Sat Oct 24, 2009 12:21 am; edited 1 time in total
|
|
Back to top |
|
|
Nashou66
Joined: 12 Jan 2007 Posts: 16171 Location: West Seneca NY
|
Link Posted: Sat Oct 24, 2009 12:18 am Post subject: |
|
|
kal wrote: | Sorry guys - a lot of the slowdowns are me. I'm doing all sorts of maintenance.
I've been working with my hosting company and their response is simply that there's too much data to wade through ever time someone goes to use the forum. D
So I've been doing something that I was hoping (and figuring) I'd never have to do: Nuke old posts. Any threads over 800-900 days old where nobody's replied I've been removing. This doesn't include polls, stickies, annoucements, and some of the forums that contain mostly old stuff. The hardest hit was the OFF TOPIC forum which is no big deal I'm assuming. Few people will go back and re-read old stuff.
Our database has come down from nearly 500mb to ~250mb now.
Kal |
Man I think I am going to go through all my watched threads and bump the ones I want to keep?
isn't there a way to Archive them like On AVS forum?
Nashou
_________________ Don't blame your underwear for your crooked ass~ unknown Greek philosopher
"Republicans believe every day is the Fourth of July, but the Democrats believe every day is April 15." --- President Reagan
One Smart Dog!!!
Marquee High Performance Bellows now shipping!!
Marquee Modifications and Performance Enhancement
Marquee C-element and Bellow removal
|
|
Back to top |
|
|
kal Forum Administrator
Joined: 06 Mar 2006 Posts: 17850 Location: Ottawa, Canada
TV/Projector: JVC DLA-NZ7
|
Link Posted: Sat Oct 24, 2009 12:21 am Post subject: |
|
|
Nashou66 wrote: | Man I think I am going to go through all my watched threads and bump the ones I want to keep? |
If nobody's posted in them for 2-3 years odds are you don't need them. Anything truly of value CRT related has probably already been copied to the main site too here:
http://www.curtpalme.com/Advanced_Procedures.shtm
Quote: | isn't there a way to Archive them like On AVS forum? |
If I set up a dedicated forum/database for it which I'm not going to do given the low volume of users that would actually use it. AVS has 1000x times as much traffic, multiple dedicated servers, and full time staff. I run this place on my own in my spare time.
Kal
_________________
Support our site by using our affiliate links. We thank you!
My basement/HT/bar/brewery build 2.0
|
|
Back to top |
|
|
AnalogRocks Forum Moderator
Joined: 08 Mar 2006 Posts: 26690 Location: Toronto, Ontario, Canada
TV/Projector: Sony 1252Q, AMPRO 4000G
|
Link Posted: Sat Oct 24, 2009 12:24 am Post subject: |
|
|
kal wrote: | Nashou66 wrote: | Man I think I am going to go through all my watched threads and bump the ones I want to keep? |
If nobody's posted in them for 2-3 years odds are you don't need them. Anything truly of value CRT related has probably already been copied to the main site too here:
http://www.curtpalme.com/Advanced_Procedures.shtm
Quote: | isn't there a way to Archive them like On AVS forum? |
If I set up a dedicated forum/database for it which I'm not going to do given the low volume of users that would actually use it. AVS has 1000x times as much traffic, multiple dedicated servers, and full time staff. I run this place on my own in my spare time.
Kal |
Do you have a full back up of the forum I could get off you? That was 3 years of my life.
_________________ Tech support for nothing
CRT.
HD done right!
|
|
Back to top |
|
|
Nashou66
Joined: 12 Jan 2007 Posts: 16171 Location: West Seneca NY
|
Link Posted: Sat Oct 24, 2009 12:26 am Post subject: |
|
|
kal wrote: | Nashou66 wrote: | Man I think I am going to go through all my watched threads and bump the ones I want to keep? |
If nobody's posted in them for 2-3 years odds are you don't need them. Anything truly of value CRT related has probably already been copied to the main site too here:
http://www.curtpalme.com/Advanced_Procedures.shtm
Quote: | isn't there a way to Archive them like On AVS forum? |
If I set up a dedicated forum/database for it which I'm not going to do given the low volume of users that would actually use it. AVS has 1000x times as much traffic, multiple dedicated servers, and full time staff. I run this place on my own in my spare time.
Kal |
No worries Kal, just throwing some questions out there.
So far no errors for me and actually faster load times, Maybe I am closer to the server location?
nashou
_________________ Don't blame your underwear for your crooked ass~ unknown Greek philosopher
"Republicans believe every day is the Fourth of July, but the Democrats believe every day is April 15." --- President Reagan
One Smart Dog!!!
Marquee High Performance Bellows now shipping!!
Marquee Modifications and Performance Enhancement
Marquee C-element and Bellow removal
|
|
Back to top |
|
|
kal Forum Administrator
Joined: 06 Mar 2006 Posts: 17850 Location: Ottawa, Canada
TV/Projector: JVC DLA-NZ7
|
|
Back to top |
|
|
MikeEby
Joined: 24 Jun 2007 Posts: 5238 Location: Osceola, Indiana
|
Link Posted: Sat Oct 24, 2009 12:58 am Post subject: |
|
|
Just nuke all of Ron Holm's threads...Nobody but him would notice.
_________________ Doing HD since the last century!
|
|
Back to top |
|
|
kal Forum Administrator
Joined: 06 Mar 2006 Posts: 17850 Location: Ottawa, Canada
TV/Projector: JVC DLA-NZ7
|
|
Back to top |
|
|
kal Forum Administrator
Joined: 06 Mar 2006 Posts: 17850 Location: Ottawa, Canada
TV/Projector: JVC DLA-NZ7
|
Link Posted: Sat Oct 24, 2009 1:16 am Post subject: |
|
|
AnalogRocks wrote: | kal wrote: | Nashou66 wrote: | Man I think I am going to go through all my watched threads and bump the ones I want to keep? |
If nobody's posted in them for 2-3 years odds are you don't need them. Anything truly of value CRT related has probably already been copied to the main site too here:
http://www.curtpalme.com/Advanced_Procedures.shtm
Quote: | isn't there a way to Archive them like On AVS forum? |
If I set up a dedicated forum/database for it which I'm not going to do given the low volume of users that would actually use it. AVS has 1000x times as much traffic, multiple dedicated servers, and full time staff. I run this place on my own in my spare time.
Kal |
Do you have a full back up of the forum I could get off you? That was 3 years of my life. |
It's not 3 years worth of stuff. It's threads that haven't been posted to in over 2-3 years. Most of it was likely old useless stuff. A lot was from the OFF TOPIC forum.
Sticky's and polls were not removed even if someone had not posted in 3+ years.
Kal
_________________
Support our site by using our affiliate links. We thank you!
My basement/HT/bar/brewery build 2.0
|
|
Back to top |
|
|
|
|