database error timeout thing

Slime · 10-02-2011, 03:23 PM

Basically every day 3DMM gets slower and slower until the database gives an error. When the site is insanely slow, you can ping 3dmm.com, and it still returns a nice ping.

Am I the only one getting this? Cause nobody else has mentioned it.

Space Goat · 10-02-2011, 04:03 PM

The problem is not with your connection to the web server, it is the web server's connection to the database, which is all on the hosting side.

The errors suggest something is using up the max number of connections we are allowed to the database. I'm looking into it.

Pizza The Hut · 10-04-2011, 07:24 AM

Quote:

Originally Posted by Lohr

Am I the only one getting this? Cause nobody else has mentioned it.

No, I get it too sometimes. Figured it was host's fault.

Evil Ash · 10-05-2011, 05:59 AM

I haven't noticed.

Space Goat · 10-05-2011, 11:17 AM

It doesn't happen that often, maybe once every 1-2 days, and it lasts for about 3 minutes. I'm guessing the host has some backup process that is not configured properly and is briefly locking up the database.

Pizza The Hut · 10-05-2011, 02:00 PM

I never eat or sleep or do anything but refresh 3dmm.com so I would know

Breed · 11-12-2011, 04:16 AM

Kyle McJuicy is telling me he hasn't been able to access the site for FOUR FLIPPIN DAYS. Not even his MUSCLES OR WHATEVER can power their way past THE INTERNET to get to his BELOVED 3DMM.

Here are the facts:

It's been about 4 days as of this post. He can access anything else etc, just not 3dmm. He has tried IE8, Chrome and Firefox 8.

:O

Pizza The Hut · 11-12-2011, 04:29 AM

he needs to get new speakers

Compcat · 11-12-2011, 06:45 AM

I'm getting pretty good 3dmm.com reception here in Antarctica. Maybe he should consider moving.

Space Goat · 11-12-2011, 02:42 PM

There's not much I can do. The problem is likely with his internet service provider's DNS service.

The first thing he should do is flush his local DNS cache. On windows, this is done via the command line, type "ipconfig /flushdns" and press enter. If running on Vista or 7 with UAC enabled, ensure that you launch the command window in Administrator Mode (right mouse click, select "Run as administrator").

If that does not do anything, then he should try temporarily switching to another DNS service, like Google Public DNS or OpenDNS. I would be really surprised if this does not resolve the issue.

However, I don't recommend switching to a public DNS as a permanent solution. If he has confirmed that his ISP's DNS service is the problem, then he should contact their help line and ask them to fix it. It will likely fix itself eventually though.

McJuicy · 11-13-2011, 09:45 PM

Quote:

Originally Posted by Space Goat

If that does not do anything, then he should try temporarily switching to another DNS service, like Google Public DNS or OpenDNS. I would be really surprised if this does not resolve the issue.

I did it and it worked.
I'm using OpenDNS right now.
What did I do to my computer and why shouldnt I use a public DNS for a long time?

Space Goat · 11-13-2011, 10:47 PM

You didn't do anything, and the problem is not with your computer, it is with your ISP's DNS service. The purpose of a DNS service is to resolve domain names (i.e. www.3dmm.com) to IP addresses. I'm guessing the IP my host uses for this site has changed recently, and for whatever reason, your ISP's DNS service has not updated yet.

When you use an alternate DNS provider, you are sharing with them every domain name that you resolve, so they have the ability to track which websites you visit (though in the case of Google, they claim to erase all personally identifiable data within 24-48 hours). You will also be redirected to ad web sites should you make a typo in a web address, even if the parent domain exists.

McJuicy · 11-13-2011, 11:10 PM

So do I call my internet place and tell them what?

McJuicy · 11-13-2011, 11:14 PM

Also how do i turn it off

Space Goat · 11-13-2011, 11:30 PM

Just repeat the steps, except this time, select "Obtain DNS server address automatically". 3dmm.com might still continue to work for a short while after you do this, because your computer will have the IP address stored in your local DNS cache. It won't likely be cleared until you restart your PC or run an "ipconfig /flushdns".

I would just tell them that their DNS server is resolving 3dmm.com to the wrong IP address, and that it resolves to the correct IP address when you use OpenDNS. It should resolve to 67.222.6.108.

McJuicy · 11-14-2011, 01:03 AM

I hope they have no follow up questions ahaha

Space Goat · 11-14-2011, 12:01 PM

If you want, go to command window and type "tracert 3dmm.com", and send me a screenshot of the results (make sure you are not using OpenDNS anymore). I can then send it to my host, and they might be able to take care of it for you.

McJuicy · 11-14-2011, 08:41 PM

when i typed in tracert 3dmm.com it said
"Unable to resolve target name 3dmm.com"

Space Goat · 11-14-2011, 11:26 PM

Sorry, I don't think they can do anything without a tracert. That is really weird, I expected it to be resolving to the wrong IP, not no IP. Who is your ISP?

I think there's a way to locally map a hostname to an IP address in windows. I'll see if I can find you some instructions on how to do that.

McJuicy · 11-14-2011, 11:49 PM

it wouldnt tracert without open dns on

here is what it did with it on
[IMG]

[/IMG]

McJuicy · 11-16-2011, 01:43 AM

does this help

Phil Williamson · 11-16-2011, 10:33 AM

using open dns bypasses your ISP's dns servers, which is where the problem is, so probably not

Space Goat · 11-16-2011, 11:09 AM

Sorry, you're going to have to use OpenDNS or call your ISP and ask why their DNS servers are not resolving 3dmm.com to an IP address.

Evil Ash · 11-16-2011, 05:48 PM

Go to this folder:

C:\windows\system32\drivers\etc\

Find a file called HOSTS.
Right click on it and choose PROPERTIES.
In the new window, uncheck the 'Read Only' checkbox if it isnt already.
Click OK

Open the HOSTS file (use notepad if asked what to open with)

Add this line to it, at the bottom:

Code:

67.222.6.108		3dmm.com

Save (file > save, not save as).

Try the tracert again.
Also try going to 3dmm.com again.

McJuicy · 11-16-2011, 09:41 PM

10-02-2011, 03:23 PM	#1
Slime Senior Member Join Date: Oct 2001 Posts: 24,891	database error timeout thing Basically every day 3DMM gets slower and slower until the database gives an error. When the site is insanely slow, you can ping 3dmm.com, and it still returns a nice ping. Am I the only one getting this? Cause nobody else has mentioned it.
Slime Senior Member Join Date: Oct 2001 Posts: 24,891

10-05-2011, 05:59 AM	#4
Evil Ash Senior Member Join Date: Apr 2003 Posts: 15,534	I haven't noticed.
Evil Ash Senior Member Join Date: Apr 2003 Posts: 15,534

11-12-2011, 04:16 AM	#7
Breed Senior Member Join Date: Sep 2004 Posts: 7,768	Kyle McJuicy is telling me he hasn't been able to access the site for FOUR FLIPPIN DAYS. Not even his MUSCLES OR WHATEVER can power their way past THE INTERNET to get to his BELOVED 3DMM. Here are the facts: It's been about 4 days as of this post. He can access anything else etc, just not 3dmm. He has tried IE8, Chrome and Firefox 8. :O
Breed Senior Member Join Date: Sep 2004 Posts: 7,768

11-12-2011, 06:45 AM	#9
Compcat Senior Member Join Date: Mar 2004 Posts: 8,810	I'm getting pretty good 3dmm.com reception here in Antarctica. Maybe he should consider moving.
Compcat Senior Member Join Date: Mar 2004 Posts: 8,810

11-13-2011, 11:10 PM	#13
McJuicy Senior Member Join Date: Jul 2004 Posts: 8,786	So do I call my internet place and tell them what?
McJuicy Senior Member Join Date: Jul 2004 Posts: 8,786

10-02-2011, 04:03 PM	#2
Space Goat Administrator Join Date: Sep 2001 Posts: 6,042	The problem is not with your connection to the web server, it is the web server's connection to the database, which is all on the hosting side. The errors suggest something is using up the max number of connections we are allowed to the database. I'm looking into it.

10-05-2011, 11:17 AM	#5
Space Goat Administrator Join Date: Sep 2001 Posts: 6,042	It doesn't happen that often, maybe once every 1-2 days, and it lasts for about 3 minutes. I'm guessing the host has some backup process that is not configured properly and is briefly locking up the database.

10-05-2011, 02:00 PM	#6
Pizza The Hut Senior Member Join Date: Jan 2002 Posts: 10,633	I never eat or sleep or do anything but refresh 3dmm.com so I would know

11-12-2011, 04:29 AM	#8
Pizza The Hut Senior Member Join Date: Jan 2002 Posts: 10,633	he needs to get new speakers

11-12-2011, 02:42 PM	#10
Space Goat Administrator Join Date: Sep 2001 Posts: 6,042	There's not much I can do. The problem is likely with his internet service provider's DNS service. The first thing he should do is flush his local DNS cache. On windows, this is done via the command line, type "ipconfig /flushdns" and press enter. If running on Vista or 7 with UAC enabled, ensure that you launch the command window in Administrator Mode (right mouse click, select "Run as administrator"). If that does not do anything, then he should try temporarily switching to another DNS service, like Google Public DNS or OpenDNS. I would be really surprised if this does not resolve the issue. However, I don't recommend switching to a public DNS as a permanent solution. If he has confirmed that his ISP's DNS service is the problem, then he should contact their help line and ask them to fix it. It will likely fix itself eventually though.

11-13-2011, 10:47 PM	#12
Space Goat Administrator Join Date: Sep 2001 Posts: 6,042	You didn't do anything, and the problem is not with your computer, it is with your ISP's DNS service. The purpose of a DNS service is to resolve domain names (i.e. www.3dmm.com) to IP addresses. I'm guessing the IP my host uses for this site has changed recently, and for whatever reason, your ISP's DNS service has not updated yet. When you use an alternate DNS provider, you are sharing with them every domain name that you resolve, so they have the ability to track which websites you visit (though in the case of Google, they claim to erase all personally identifiable data within 24-48 hours). You will also be redirected to ad web sites should you make a typo in a web address, even if the parent domain exists.

11-13-2011, 11:14 PM	#14
McJuicy Senior Member Join Date: Jul 2004 Posts: 8,786	Also how do i turn it off
McJuicy Senior Member Join Date: Jul 2004 Posts: 8,786

11-13-2011, 11:30 PM	#15
Space Goat Administrator Join Date: Sep 2001 Posts: 6,042	Just repeat the steps, except this time, select "Obtain DNS server address automatically". 3dmm.com might still continue to work for a short while after you do this, because your computer will have the IP address stored in your local DNS cache. It won't likely be cleared until you restart your PC or run an "ipconfig /flushdns". I would just tell them that their DNS server is resolving 3dmm.com to the wrong IP address, and that it resolves to the correct IP address when you use OpenDNS. It should resolve to 67.222.6.108.

11-14-2011, 01:03 AM	#16
McJuicy Senior Member Join Date: Jul 2004 Posts: 8,786	I hope they have no follow up questions ahaha
McJuicy Senior Member Join Date: Jul 2004 Posts: 8,786

11-14-2011, 12:01 PM	#17
Space Goat Administrator Join Date: Sep 2001 Posts: 6,042	If you want, go to command window and type "tracert 3dmm.com", and send me a screenshot of the results (make sure you are not using OpenDNS anymore). I can then send it to my host, and they might be able to take care of it for you.

11-14-2011, 08:41 PM	#18
McJuicy Senior Member Join Date: Jul 2004 Posts: 8,786	when i typed in tracert 3dmm.com it said "Unable to resolve target name 3dmm.com"
McJuicy Senior Member Join Date: Jul 2004 Posts: 8,786

11-14-2011, 11:26 PM	#19
Space Goat Administrator Join Date: Sep 2001 Posts: 6,042	Sorry, I don't think they can do anything without a tracert. That is really weird, I expected it to be resolving to the wrong IP, not no IP. Who is your ISP? I think there's a way to locally map a hostname to an IP address in windows. I'll see if I can find you some instructions on how to do that.

11-14-2011, 11:49 PM	#20
McJuicy Senior Member Join Date: Jul 2004 Posts: 8,786	it wouldnt tracert without open dns on here is what it did with it on [IMG][/IMG]
McJuicy Senior Member Join Date: Jul 2004 Posts: 8,786

11-16-2011, 01:43 AM	#21
McJuicy Senior Member Join Date: Jul 2004 Posts: 8,786	does this help
McJuicy Senior Member Join Date: Jul 2004 Posts: 8,786

11-16-2011, 10:33 AM	#22
Phil Williamson Super Moderator Join Date: Oct 2002 Posts: 16,900	using open dns bypasses your ISP's dns servers, which is where the problem is, so probably not

11-16-2011, 11:09 AM	#23
Space Goat Administrator Join Date: Sep 2001 Posts: 6,042	Sorry, you're going to have to use OpenDNS or call your ISP and ask why their DNS servers are not resolving 3dmm.com to an IP address.

11-16-2011, 05:48 PM	#24
Evil Ash Senior Member Join Date: Apr 2003 Posts: 15,534	Go to this folder: C:\windows\system32\drivers\etc\ Find a file called HOSTS. Right click on it and choose PROPERTIES. In the new window, uncheck the 'Read Only' checkbox if it isnt already. Click OK Open the HOSTS file (use notepad if asked what to open with) Add this line to it, at the bottom: Code: 67.222.6.108 3dmm.com Save (file > save, not save as). Try the tracert again. Also try going to 3dmm.com again.
Evil Ash Senior Member Join Date: Apr 2003 Posts: 15,534

11-16-2011, 09:41 PM	#25
McJuicy Senior Member Join Date: Jul 2004 Posts: 8,786
McJuicy Senior Member Join Date: Jul 2004 Posts: 8,786