max_user_connections error appearing all of a sudden
Hi All,
I have a multi domain site built up on Umbraco 4.0.1 running on a MySQL database,
all was running along fine until some recent small dev work (nothing major) when all of a sudden, I'm getting max_user_connections errors appearing as soon as I try to open up the developer section in Umbraco. This then crashes the site until I refresh the app pool.
This is really confusing as all was working fine until this began occuring.
Has anyone experienced this in the past? It's really got me stumped
Error is:
Server Error in '/' Application.
User <databasename> already has more than 'max_user_connections' active connections
Description: An
unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the
error and where it originated in the code.
Exception Details: MySql.Data.MySqlClient.MySqlException: User XXXXXXXX already has more than 'max_user_connections' active connections
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
Stack Trace:
[MySqlException (0x80004005): User xxxxxxxxxxxx already has more than 'max_user_connections' active connections] MySql.Data.MySqlClient.MySqlStream.OpenPacket() +238 MySql.Data.MySqlClient.NativeDriver.ReadOk(Boolean read) +261 MySql.Data.MySqlClient.NativeDriver.Authenticate411() +230 MySql.Data.MySqlClient.NativeDriver.Authenticate() +65 MySql.Data.MySqlClient.NativeDriver.Open() +968 MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) +47 MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() +23 MySql.Data.MySqlClient.MySqlPool.GetConnection() +76 MySql.Data.MySqlClient.MySqlConnection.Open() +185 MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(String connectionString, String commandText, MySqlParameter[] commandParameters) +65 umbraco.DataLayer.SqlHelpers.MySql.MySqlHelper.ExecuteReader(String commandText, MySqlParameter[] parameters) +33 umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +68
Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053
Request Details
Session Id:
ovsnafnl5z0zto553pvbtkab
Request Type:
GET
Time of Request:
19/11/2009 8:23:08 PM
Status Code:
500
Request Encoding:
Unicode (UTF-8)
Response Encoding:
Unicode (UTF-8)
Trace Information
Category
Message
From First(s)
From Last(s)
aspx.page
Begin PreInit
umbracoInit
handling request
0.00242685045487582
0.002427
request handler
current url ''
0.0416753885867522
0.039249
Unhandled Execution Error
Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) at umbraco.cms.businesslogic.web.Domain.<GetDomains>b__0()
at umbraco.cms.businesslogic.cache.Cache.GetCacheItem[TT](String
cacheKey, Object syncLock, CacheItemPriority priority,
CacheItemRemovedCallback refreshAction, CacheDependency
cacheDependency, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) at umbraco.cms.businesslogic.web.Domain.GetDomains() at umbraco.cms.businesslogic.web.Domain.GetDomain(String DomainName) at umbraco.cms.businesslogic.web.Domain.Exists(String DomainName) at umbraco.requestHandler.CreateXPathQuery(String url, Boolean checkDomain) at umbraco.requestHandler..ctor(XmlDocument _umbracoContent, String url) at umbraco.UmbracoDefault.Page_PreInit(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Page.OnPreInit(EventArgs e) at System.Web.UI.Page.PerformPreInit() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Did your dev work include hitting the database? You could get a lot of connections if you would (for example) iterate over all of the documents in the site..
User xxxxxxxxxxxxxxxx already has more than 'max_user_connections' active connections
Description: An unhandled exception occurred during
the execution of the current web request. Please review the stack trace
for more information about the error and where it originated in the
code.
Exception Details: MySql.Data.MySqlClient.MySqlException: User xxxxxxxxxxxxxxx already has more than 'max_user_connections' active connections
Source Error:
An unhandled exception was generated during the execution of the current
web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
Stack Trace:
[MySqlException (0x80004005): User xxxxxxxxxxxxxx already has more than 'max_user_connections' active connections] MySql.Data.MySqlClient.MySqlStream.OpenPacket() +238 MySql.Data.MySqlClient.NativeDriver.ReadOk(Boolean read) +265 MySql.Data.MySqlClient.NativeDriver.Authenticate411() +268 MySql.Data.MySqlClient.NativeDriver.Authenticate() +81 MySql.Data.MySqlClient.NativeDriver.Open() +932 MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) +87 MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() +23 MySql.Data.MySqlClient.MySqlPool.GetConnection() +79 MySql.Data.MySqlClient.MySqlConnection.Open() +222 MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(String connectionString, String commandText, MySqlParameter[] commandParameters) +65 umbraco.DataLayer.SqlHelpers.MySql.MySqlHelper.ExecuteReader(String commandText, MySqlParameter[] parameters) +58 umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +150
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
Request Details
Session Id:
42fbwie54i5wlcss5g2bc0zj
Request Type:
GET
Time of Request:
8/13/2010 4:36:54 PM
Status Code:
500
Request Encoding:
Unicode (UTF-8)
Response Encoding:
Unicode (UTF-8)
Trace Information
Category
Message
From First(s)
From Last(s)
aspx.page
Begin PreInit
umbracoInit
handling request
1.59735707033245E-05
0.000016
request handler
current url '/blog'
0.000141304663914025
0.000125
umbracoRequestHandler
Just before xPath query (True, '1363')
0.000163831494393072
0.000023
umbracoRequestHandler
After xPath query
0.000178576328888448
0.000015
umbracoRequestHandler
Access checking started
0.000206837261671253
0.000028
umbracoRequestHandler
Page not protected
0.000225677883526457
0.000019
umbracoRequestHandler
Access checking ended
0.000235917351926024
0.000010
umbracoInit
Done handling request
0.000245747241589608
0.000010
umbracoPage
Element loaded: recordsPerPage
0.000420227783118229
0.000174
umbracoPage
Element loaded: summaryView
0.00044480250727719
0.000025
umbracoPage
Element loaded: authorTitle
0.000468558073964186
0.000024
umbracoPage
Element loaded: authorPhoto
0.000490265746971268
0.000022
umbracoPage
Element loaded: authorName
0.000511154262506384
0.000021
umbracoPage
Element loaded: authorBio
0.000532861935513466
0.000022
umbracoPage
Element loaded: umbracoNaviHide
0.00055948455335234
0.000027
umbracoPage
Pagedata loaded for Blog (ID: 1363)
0.000574229387847717
0.000015
Unhandled Execution Error
Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) at umbraco.template..ctor(Int32 templateID) at umbraco.template.GetMasterPageName(Int32 templateID) at umbraco.UmbracoDefault.Page_PreInit(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Page.OnPreInit(EventArgs e) at System.Web.UI.Page.PerformPreInit() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
max_user_connections error appearing all of a sudden
Hi All,
I have a multi domain site built up on Umbraco 4.0.1 running on a MySQL database,
all was running along fine until some recent small dev work (nothing major) when all of a sudden, I'm getting max_user_connections errors appearing as soon as I try to open up the developer section in Umbraco. This then crashes the site until I refresh the app pool.
This is really confusing as all was working fine until this began occuring.
Has anyone experienced this in the past? It's really got me stumped
Error is:
Server Error in '/' Application.
User <databasename> already has more than 'max_user_connections' active connections
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: MySql.Data.MySqlClient.MySqlException: User XXXXXXXX already has more than 'max_user_connections' active connections
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.Stack Trace:
Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053
Request Details
Trace Information
Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
at umbraco.cms.businesslogic.web.Domain.<GetDomains>b__0()
at umbraco.cms.businesslogic.cache.Cache.GetCacheItem[TT](String cacheKey, Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, CacheDependency cacheDependency, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem)
at umbraco.cms.businesslogic.web.Domain.GetDomains()
at umbraco.cms.businesslogic.web.Domain.GetDomain(String DomainName)
at umbraco.cms.businesslogic.web.Domain.Exists(String DomainName)
at umbraco.requestHandler.CreateXPathQuery(String url, Boolean checkDomain)
at umbraco.requestHandler..ctor(XmlDocument _umbracoContent, String url)
at umbraco.UmbracoDefault.Page_PreInit(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Page.OnPreInit(EventArgs e)
at System.Web.UI.Page.PerformPreInit()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Control Tree
Session State
Application State
Request Cookies Collection
Response Cookies Collection
Headers Collection
Response Headers Collection
Form Collection
Querystring Collection
Server Variables
Did your dev work include hitting the database? You could get a lot of connections if you would (for example) iterate over all of the documents in the site..
Its quite odd, but it only seems to crash when I select a Doc2Form Macro.
As long as I steer clear of that it seems to work fine. Like I said, very odd.
Best guess would be no cleaning up after readers etc. First thing i would check up on atleast
I am having the same problem.... my whole site is down and it is currently only in development so I know I am the only user on the site.
and all I am doing right now is some macro work...
Server Error in '/' Application.
User xxxxxxxxxxxxxxxx already has more than 'max_user_connections' active connections
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: MySql.Data.MySqlClient.MySqlException: User xxxxxxxxxxxxxxx already has more than 'max_user_connections' active connections
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.Stack Trace:
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
Request Details
Trace Information
Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
at umbraco.template..ctor(Int32 templateID)
at umbraco.template.GetMasterPageName(Int32 templateID)
at umbraco.UmbracoDefault.Page_PreInit(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Page.OnPreInit(EventArgs e)
at System.Web.UI.Page.PerformPreInit()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Control Tree
Session State
Application State
Request Cookies Collection
Response Cookies Collection
Headers Collection
Response Headers Collection
Form Collection
Querystring Collection
Server Variables
Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
is working on a reply...