| Author |
 Topic  |
|
MaGraham
Senior Member
USA
1297 Posts |
 Posted - 07 June 2013 : 15:18:22
|
I am receiving the following error message, at times, on my forums. These are new forums (also new domain and new hosting) that I haven't even opened for my members yet.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 5.1 Driver]Too many connections
There was a line of code specified in inc_header.asp but I neglected to make a note of it. 
I am using MySQL database and hosting is asking if the connections are set to be closed after they are used. I don't understand this. Could someone help me to know how to answer this?
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
Carefree
Advanced Member
Philippines
4217 Posts |
Posted - 07 June 2013 : 16:58:21
|
| What the host is referring are possible "handles" left open to the database. Every time there's a "Set ? = my_Conn.Execute" or a "my_Conn.Open", there needs to be a corresponding .Close and for the "Set ***", there should be a corresponding "Set ? = Nothing" to finish the job. Somewhere in your code, there's probably one that isn't closed and you're frequenting that command. |
 |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 08 June 2013 : 02:24:47
|
Since the error message referred to inc_header.asp, does that mean that's where the error is?
I still can't believe I neglected to note the exact line!  In my mind's eye I think it said line 112. Does seeing these lines below look like that might be the case and/or help in determining the problem?
Here are lines 108 - 126
Response.End
end if
set my_Conn = Server.CreateObject("ADODB.Connection")
my_Conn.Open strConnString
%>
<!--#include file="my_theme2.asp"-->
<%
'##### Ban IP Mod ######
Call banIP()
'#######################
if (strAuthType = "nt") then
call NTauthenticate()
if (ChkAccountReg() = "1") then
call NTUser()
end if
end if
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
|
Carefree
Advanced Member
Philippines
4217 Posts |
Posted - 08 June 2013 : 13:08:17
|
| No, that doesn't mean the error is there; it's just one of the most frequently accessed pages. The error could be anywhere, but it's likely to be on a frequently used page as well. I'd recommend reviewing any/all of the pages which are "included" from "default.asp" as a place to start. |
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 08 June 2013 : 14:16:02
|
I had active.asp open when I received this error message. Would that mean the error is in active.asp?
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
Edited by - MaGraham on 08 June 2013 14:21:53 |
|
|
|
Carefree
Advanced Member
Philippines
4217 Posts |
Posted - 08 June 2013 : 16:20:02
|
| I'll take a look later today, maybe I'll get lucky and find it in the first dozen or so files. |
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 08 June 2013 : 19:52:51
|
Oh thank you, Carefree!!
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 09 June 2013 : 09:35:03
|
Hosting just said, "If the number of open connects cross a defined limit on the server, it will start giving too many connections errors" in a message.
Does this mean doing too many mods could also cause this?
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
Edited by - MaGraham on 09 June 2013 09:35:45 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 09 June 2013 : 11:12:56
|
Yes, too many mods will cause that. But it's not just any mod, mods that are not written properly will let that error occur.
You see, usually each mod opens a connection to the database, and they are SUPPOSED to close that connection when finished with it. But they leave out the closing part and so the # of open connections to the database is left.
So Carefree will have to go through each mod that is referenced on active.asp and check to make sure they close the connection properly. |
Support Snitz Forums
|
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 10 June 2013 : 13:09:15
|
quote:
Originally posted by Davio
So Carefree will have to go through each mod that is referenced on active.asp and check to make sure they close the connection properly.
Oh my! I hope the error is found in the first few!
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 11 June 2013 : 02:28:10
|
I have the same issue occasionally despite being on a dedicated server and having lifted the number of max connections and so far I cannot for the life of me find where the issue is coming from.
All I know is that is only rears it's head on busy occasions when there are 500+ users onboard. I did suspect the ipgate mod as a line in there was referenced but I couldn't find anyting wrong with it either.
Carefree, if you do find the cause I also lost a needle once in a hay stack, perhaps you could find that for me as well  
Edit: I found a saved error:
quote:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 5.1 Driver]User webbo already has more than 'max_user_connections' active connections
/forum/inc_header.asp, line 169
|
Edited by - Webbo on 11 June 2013 02:30:47 |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 11 June 2013 : 10:56:22
|
| Webbo, what is your configured connection limit ? 500+ users is going to create a lot of connections anyway, and not sure how MySQL handles connection pooling so it could be creating 500+ connections. |
MVC .net dev/test site | MVC .net running on Raspberry Pi |
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 11 June 2013 : 17:34:27
|
The max user connections was set to 1000 from the default 100(?)
Technically it could be raised further if need be but it has an impact on server memory so 1000 seemed to be a good round number.
|
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 12 June 2013 : 06:41:03
|
My website isn't even open. I'm still moving the latest posts, etc. to my new domain. But I haven't even been on the site for the past 8 hours, or more, and yet when I tried to go to my forums just a few minutes ago, I received the error we're referring to here.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 5.1 Driver]Too many connections
/fp/inc_header.asp, line 112
It's finally loaded now though.
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
Edited by - MaGraham on 12 June 2013 06:41:48 |
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 13 June 2013 : 08:15:35
|
I've managed to capture an error message:
error '80004005'
/forum/inc_ipgate.asp, line 50
MaGraham, have you got the IPGate mod installed? |
|
|
|
Topic |
|
