There is insufficient system memory in resource pool 'internal'

There is insufficient system memory in resource pool 'internal' to run this query.

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This thread is closed to new posts. You must sign in to post in the forums.

3/15/2010 10:05:19 PM

mer.seo

Total Posts 11

View Posts

There is insufficient system memory in resource pool 'internal' to run this query.

Hi,

I was doing skin changes and got some errors.

Is this related to insuffucient memory or because I was changing skin?

I run a VPS with 1MB ram, should I buy more memory?

Please let me know.

2010-03-15 15:16:38,559 ERROR mojoPortal.Web.Global - 98.219.xx.xx-en-US - /Admin/ContentTemplates.aspx
System.Data.SqlClient.SqlException: There is insufficient system memory in resource pool 'internal' to run this query.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
at mojoPortal.Data.SqlParameterHelper..ctor(String connectionString, String commandText, Int32 paramCnt)
at mojoPortal.Data.DBContentTemplate.GetCount(Guid siteGuid)
at mojoPortal.Data.DBContentTemplate.GetPage(Guid siteGuid, Int32 pageNumber, Int32 pageSize, Int32& totalPages)
at mojoPortal.Business.ContentTemplate.GetPage(Guid siteGuid, Int32 pageNumber, Int32 pageSize, Int32& totalPages)
at mojoPortal.Web.AdminUI.ContentTemplatesPage.BindGrid()
at mojoPortal.Web.AdminUI.ContentTemplatesPage.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at mojoPortal.Web.mojoBasePage.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

3/16/2010 7:45:36 AM

Joe Audette

Total Posts 18439

View Posts

Re: There is insufficient system memory in resource pool 'internal' to run this query.

Hi,

I've never encountered this error myself. I assume you mean you have 1 GB of RAM not 1 MB.

The error sounds like SQL Server does not have enough available memory and is not related to changing the skin.

1 GB should be sufficient unless you have a lot of sites or very high traffic or other things running on the machine. I would not install Visual Studio on a machine like that for example.

If you only have IIS and SQL EXpress and not much more on the machine then possibly there is some configuration limiting the ram available to SQL server.

Hope it helps,

Joe

3/16/2010 8:59:33 AM

mer.seo

Total Posts 11

View Posts

Re: There is insufficient system memory in resource pool 'internal' to run this query.

Hi Joe

Yes 1GB ram.

I only have 1 mojoportal website, but I have installed, Visual Studio 2008, Visual Developer Express, SQL Express and SQL Web server.

Thanks.

Manny

3/16/2010 10:30:25 AM

Joe Audette

Total Posts 18439

View Posts

Re: There is insufficient system memory in resource pool 'internal' to run this query.

Hi,

I don't recommend installing developer tools on production web servers. My recommendation is do development on a local machine and deploy a pre-compiled build to production.

It would not surprise me at all to run out of memory running Visual Studio on a machine with only 1 GB of RAM, Visual Studio is a resource hog.

Hope it helps,

Joe

You must sign in to post in the forums. This thread is closed to new posts.