connection pool error when editing content with richtext datatypes
Upon editing content with richtext datatypes I began getting these errors:
Error adding stylesheet to tinymce (id: 1173). System.NullReferenceException: Object reference not set to an instance of an object. at umbraco.editorControls.tinyMCE3.TinyMCE..ctor(IData Data, String Configuration)
and eventually the website would crash with this error:
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open()
I ran this sql query on the database before and after clicking on the suspected nodes and noticed they grew tenfold each time a node was accessed.
When it hit > 100 the site crashed.
drop table #tempt create table #tempt(spid int, ecid int ,status varchar(max),loginname varchar(max),hostname varchar(max),blk int,dbname varchar(max),cmd varchar(50),requestid int) insert into #tempt exec spwhoselect COUNT(*),dbname from #tempt where dbname not in ('NULL','master','msdb')group by dbname
Not sure where to look from here. Any help would be greatly appreciated.
connection pool error when editing content with richtext datatypes
Upon editing content with richtext datatypes I began getting these errors:
Error adding stylesheet to tinymce (id: 1173). System.NullReferenceException: Object reference not set to an instance of an object. at umbraco.editorControls.tinyMCE3.TinyMCE..ctor(IData Data, String Configuration)
and eventually the website would crash with this error:
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open()
I ran this sql query on the database before and after clicking on the suspected nodes and noticed they grew tenfold each time a node was accessed. When it hit > 100 the site crashed.
drop table #tempt create table #tempt(spid int, ecid int ,status varchar(max),loginname varchar(max),hostname varchar(max),blk int,dbname varchar(max),cmd varchar(50),requestid int) insert into #tempt exec spwhoselect COUNT(*),dbname from #tempt where dbname not in ('NULL','master','msdb')group by dbname
Not sure where to look from here. Any help would be greatly appreciated.
is working on a reply...