Hi there

Umbraco 4.5.2 .NET 3.5 Release on IIS6 + MySQL

I have got this error when trying to save a macro with a change to an existing property name.

I have tried creating and re-saving a datatype with changes and that works fine and when I come back to the macro and try to resave the property name, it once again errors, with the following error... I continued to hit the db like this in other places (all working fine) to confirm this particular issue until on this error brought the whole site down - and I couldn't even login to the Umbraco backend. After a few mins the DB obviously reset and I could login again, only to find the same issue immediately...

Server Error in '/' Application.

---

User dbUserName already has more than 'max_user_connections' active connections

Stack Trace:

[MySqlException (0x80004005): User hsgdb already has more than 'max_user_connections' active connections]
   MySql.Data.MySqlClient.MySqlStream.OpenPacket() +238
   MySql.Data.MySqlClient.NativeDriver.Authenticate411() +124
   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) +58
   umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +141

[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader]
   umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +223
   umbraco.cms.businesslogic.macro.Macro.setup() +212
   umbraco.cms.businesslogic.macro.Macro..ctor(Int32 Id) +60
   umbraco.cms.businesslogic.macro.MacroProperty.setup() +322
   umbraco.cms.businesslogic.macro.MacroProperty..ctor(Int32 Id) +53
   umbraco.cms.presentation.developer.editMacro.Page_Load(Object sender, EventArgs e) +4602
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   umbraco.BasePages.BasePage.OnLoad(EventArgs e) +49
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

---------------------------------

Also Error in UmbracoLog table:

At /umbraco/developer/macros/editMacro.aspx?macroID=21 (Referred by: http://highsugargrass.co.nz.win.mydns.net.nz/umbraco/developer/macros/editMacro.aspx?macroID=21): umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader ---> MySql.Data.MySqlClient.MySqlException: User dbUserName already has more than 'max_user_connections' active connections
   at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
   at MySql.Data.MySqlClient.NativeDriver.Authenticate411()
   at MySql.Data.MySqlClient.NativeDriver.Authenticate()
   at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(String connectionString, String commandText, MySqlParameter[] commandParameters)
   at umbraco.DataLayer.SqlHelpers.MySql.MySqlHelper.ExecuteReader(String commandText, MySqlParameter[] parameters)
   at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
   --- End of inner exception stack trace ---
   at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
   at umbraco.cms.businesslogic.macro.Macro.setup()
   at umbraco.cms.businesslogic.macro.Macro..ctor(Int32 Id)
   at umbraco.cms.businesslogic.macro.MacroProperty.setup()
   at umbraco.cms.businesslogic.macro.MacroProperty..ctor(Int32 Id)
   at umbraco.cms.presentation.developer.editMacro.Page_Load(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.Web.UI.Control.OnLoad(EventArgs e)
   at umbraco.BasePages.BasePage.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

------------------------------------

Any thoughts much appreciated.

Thanks
Josh