Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • sharon Schmidt 12 posts 32 karma points
    Aug 01, 2013 @ 16:57
    sharon Schmidt
    0

    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.

Please Sign in or register to post replies

Write your reply to:

Draft