I've got an issue with blog 4 umbraco crashing upon clicking the F5 key repeatedly (20 to 30 times) when on the blog home page.
Normally the blog works fine but after repeated refreshes the page hangs for a while and then part renders and part doesn't with various XSL errors reported. Normally all 3 below but occasionaly only 1 or 2 of these errors: Error parsing XSLT file: \xslt\BlogListPosts.xslt Error parsing XSLT file: \xslt\BlogLatestComments.xslt Error parsing XSLT file: \xslt\BlogCategories.xslt
Trying to access any other part of the umbraco installation (e.g. the admin section) then shows the following 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.
I initially thought it may be due to my customization, but I installed a fresh version of umbraco and blog4umbraco and the same issue occurs.
Anybody else experiencing this or any ideas what might be causing this?
Has blog4umbraco been stress tested at all?
Thanks, Clem
My setup:
Windows 7 64 bit IIS 7.5 Umbraco 4.0.3 Blog4Umbraco 2.0.24 Microsoft SQL Server Management Studio 10.0.2531.0 Microsoft Analysis Services Client Tools 10.0.1600.22 Microsoft Data Access Components (MDAC) 6.1.7600.16385 Microsoft MSXML 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 8.0.7600.16385 Microsoft .NET Framework 2.0.50727.4927 Operating System 6.1.7600
Stack Trace:
[InvalidOperationException: 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.] System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +6264689 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +6265031 System.Data.SqlClient.SqlConnection.Open() +258 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +89 umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteScalar(String commandText, SqlParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelpers\SqlServer\SqlServerHelper.cs:51 umbraco.DataLayer.SqlHelper`1.ExecuteScalar(String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:194
I removed all the macros from the page beside 'BlogListPosts' and the problem still occured so i removed the comments functionality from the BlogListPosts.XSLT by changing the line
<xsl:variable name="numberofcomments" select="count(BlogLibrary:GetCommentsForPost($post/@id)//comment)"/> to <xsl:variable name="numberofcomments" select="0"/>
and then the problem dissapeared.
So it's to do with fetching comments.
I've just installed the setup on a seperate computer and the same issue occured. As this hasn't seemed to affect anybody else it may well be down to the way I'm setting up IIS or MSSQL. Is there anything in particular I should be looking out for?
Looks like the connection to the database is not closed after selecting the comments,
[InvalidOperationException: 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.]
I've a different error in my stack trace (same result...error parsing), but here is what I found important, if more details are needed please let me know.
Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:line 244 at Umlaut.Umb.Blog.BlogLibrary.GetCommentsForPost(Int32 id) in d:\TeamCity\buildAgent\work\6c8a1edaa924eb51\Umlaut.Umb.Blog\Library\BlogLibrary.cs:line 83
Downloaded the patch and i still get this error. One thing i noticed is that in xsltextensions there is not entry for BlogLibrary not sure if there is bug with installer so that it does not put that entry in?
I started with version 2.0.26 and still got the error as well. Another forum post in here had the wrong code that you gave, Ismai (they had backward slashes) but in any case, if I've entered your code in the correct spot in the page, NEITHER strip of code is fixing my problem. I still get "
Error parsing XSLT file: \xslt\BlogListPosts.xslt"
I downloaded the latest version 2.0.26 on two different Umbraco 4.0.3 websites and got this same error. Can someone offer any new ideas for fixes? Thank you!
blog 4 umbraco crashing
I've got an issue with blog 4 umbraco crashing upon clicking the F5 key repeatedly (20 to 30 times) when on the blog home page.
Normally the blog works fine but after repeated refreshes the page hangs for a while and then part renders and part doesn't with various XSL errors reported. Normally all 3 below but occasionaly only 1 or 2 of these errors:
Error parsing XSLT file: \xslt\BlogListPosts.xslt
Error parsing XSLT file: \xslt\BlogLatestComments.xslt
Error parsing XSLT file: \xslt\BlogCategories.xslt
Trying to access any other part of the umbraco installation (e.g. the admin section) then shows the following 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.
I initially thought it may be due to my customization, but I installed a fresh version of umbraco and blog4umbraco and the same issue occurs.
Anybody else experiencing this or any ideas what might be causing this?
Has blog4umbraco been stress tested at all?
Thanks,
Clem
My setup:
Windows 7 64 bit
IIS 7.5
Umbraco 4.0.3
Blog4Umbraco 2.0.24
Microsoft SQL Server Management Studio 10.0.2531.0
Microsoft Analysis Services Client Tools 10.0.1600.22
Microsoft Data Access Components (MDAC) 6.1.7600.16385
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 8.0.7600.16385
Microsoft .NET Framework 2.0.50727.4927
Operating System 6.1.7600
Stack Trace:
[InvalidOperationException: 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.]
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +6264689
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +6265031
System.Data.SqlClient.SqlConnection.Open() +258
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +89
umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteScalar(String commandText, SqlParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelpers\SqlServer\SqlServerHelper.cs:51
umbraco.DataLayer.SqlHelper`1.ExecuteScalar(String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:194
[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteScalar]
umbraco.DataLayer.SqlHelper`1.ExecuteScalar(String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:200
umbraco.BusinessLogic.User.getUserId(String query, IParameter[] parameterValues) +60
umbraco.BusinessLogic.User..ctor(String Login) +116
umbraco.providers.UsersMembershipProvider.ValidateUser(String username, String password) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\providers\UsersMembershipProvider.cs:568
umbraco.cms.presentation.login.Button1_Click(Object sender, EventArgs e) +99
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +140
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +29
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2981
It looks like it has to do with fetching comments, since these are stored in the db.
It seems you're right.
I removed all the macros from the page beside 'BlogListPosts' and the problem still occured so i removed the comments functionality from the BlogListPosts.XSLT by changing the line
<xsl:variable name="numberofcomments" select="count(BlogLibrary:GetCommentsForPost($post/@id)//comment)"/>
to
<xsl:variable name="numberofcomments" select="0"/>
and then the problem dissapeared.
So it's to do with fetching comments.
I've just installed the setup on a seperate computer and the same issue occured. As this hasn't seemed to affect anybody else it may well be down to the way I'm setting up IIS or MSSQL. Is there anything in particular I should be looking out for?
Or has anybody else experience similar a issue?
Looks like the connection to the database is not closed after selecting the comments,
I have this exact same issue, how can I resolve it?
I checked the source, and Dennis is right, the connection isn't closed properly. I created an issue at codeplex, go vote!
http://blog4umbraco.codeplex.com/WorkItem/View.aspx?WorkItemId=4007
I've a different error in my stack trace (same result...error parsing), but here is what I found important, if more details are needed please let me know.
Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:line 244
at Umlaut.Umb.Blog.BlogLibrary.GetCommentsForPost(Int32 id) in d:\TeamCity\buildAgent\work\6c8a1edaa924eb51\Umlaut.Umb.Blog\Library\BlogLibrary.cs:line 83
Any update on this issue?
I wish I'd spotted this issue before using it on a production site, >.< Lx
Issue should be fixed you can upgrade to version 2.0.26 by downloading the update here:
http://nightly.umbraco.org/Blog4Umbraco/2.0.26/
This update will make my friends day (: L
Guys,
Downloaded the patch and i still get this error. One thing i noticed is that in xsltextensions there is not entry for BlogLibrary not sure if there is bug with installer so that it does not put that entry in?
regards
Ismail
Figured out why it was crashing, i didnt have the entry in xsltExtensions.config for the tagsLib library i.e.
<ext assembly="/bin/umbraco.editorControls" type="umbraco.editorControls.tags.library" alias="tagsLib" />
Ismial
So is this the correct code?
<?xml version="1.0" encoding="utf-8" ?>
<XsltExtensions>
<!--
<ext assembly="/bin/name-of-dll-without-dll-extension" type="Fully.Qualified.Name.Of.Type.Including.Namespace" alias="Prefix-to-use-in-xslt" />
-->
<ext assembly="/bin/umbraco.editorControls" type="umbraco.editorControls.tags.library" alias="tagsLib" />
</XsltExtensions>
I started with version 2.0.26 and still got the error as well. Another forum post in here had the wrong code that you gave, Ismai (they had backward slashes) but in any case, if I've entered your code in the correct spot in the page, NEITHER strip of code is fixing my problem. I still get " Error parsing XSLT file: \xslt\BlogListPosts.xslt"
I'm having similar problems...
Error parsing XSLT file: \xslt\BlogListPosts.xslt
Error parsing XSLT file: \xslt\BlogLatestComments.xslt
Also getting exception "Invalid object name 'comment'." when I try to view the root node of the content section.
I believe my xsltExtensions.config file is correct...
--------------------
<?xml version="1.0" encoding="utf-8"?>
<XsltExtensions>
<!--
<ext assembly="/bin/name-of-dll-without-dll-extension" type="Fully.Qualified.Name.Of.Type.Including.Namespace" alias="Prefix-to-use-in-xslt" />
-->
<ext assembly="\bin\umbraco.editorControls" type="umbraco.editorControls.tags.library" alias="tagsLib">
</ext>
<ext assembly="\bin\Umlaut.Umb.Blog" type="Umlaut.Umb.Blog.BlogLibrary" alias="BlogLibrary">
</ext>
</XsltExtensions>
--------------------
Help!
I downloaded the latest version 2.0.26 on two different Umbraco 4.0.3 websites and got this same error. Can someone offer any new ideas for fixes? Thank you!
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.