Arvixe - Database connection drops

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
6/12/2012 9:25:27 AM
Gravatar
Total Posts 63
Jerry McCreary
SureFire Studios, Inc.

Arvixe - Database connection drops

I have a site in development with Arvixe.com.  The site constantly, but unpredictably, kicks back to mojoPortal Setup and gives database connection errors. I've spent hours with Arvixe support, both on phone an online, and they insist that is a problem with mojoPortal.

I've tripled-check the connection string, and tried suggestions by Indigo Tea in this thread https://www.mojoportal.com/Forums/Thread.aspx?pageid=5&mid=34&ItemID=3&thread=10274&pagenumber=1

The error comes up sporadically, and I am not able to repeat steps to cause it.

Steps taken:

1) Initially installed with mojoPortal installer from Arvixe control panel

2) 2 months of going back in forth with Arvixe support

3) Tried changing Data Source from server name to localhost (also tried using 127.0.0.1).
     Each of these connections work for a while, then same error randomly occurs.

3) Re-installed mojoPortal manually, upgrading to 2.3.8.5.   Worked fine for awhile, then started giving same error again.

Please, I need help.  This site is for a new client.
I'm willing to pay or make donation for resolution. I have 3 new sites ready to go on Arvixe, but I'm losing confidence.

Hosting:

•  Microsoft® Windows Server® 2008 Standard without Hyper-V Service Pack 2
•  ASP.Net 4.0 (Integrated)
• SQL Server 2008

6/12/2012 9:50:50 AM
Gravatar
Total Posts 2202

Re: Arvixe - Database connection drops

mojoPortal doesn't intermittently forget where to find the database. If mojo can't connect to the database, it will display the setup page and the error you're describing. The most probable cause of the issue is a loss of connectivity between your web server and the database server. The database server and web server are probably on the same host but that doesn't mean that the sql service isn't shutting down, restarting or hanging in some way. Another thought is that the web site is having trouble reading the user.config but I highly doubt that is the issue because if it can read the web.config, it should be able to read the user.config. (Unless there are specific permissions set on the user.config preventing read access but why would that happen intermittently?)

Feel free to check out the only other recommended mojoPortal host, i7MEDIA. I hear they have mojoPortal experts on staff. ;-)

HTH,
Joe D.

6/12/2012 10:03:15 AM
Gravatar
Total Posts 18439

Re: Arvixe - Database connection drops

Hi Jerry,

Is this shared hosting or a VM or dedicated server?

If it is a VM or dedicated server how much RAM?

Having both IIS and SQL Express running on the same machine with low memory available can result in an unstable environment. I generally recommend stick with shared hosting unless you can get at least 2GB of RAM on a VM or dedicated machine. 1GB might be enough for a single site but doesn't leave much headroom, less than that is a bad recipe, it just doesn't give enough headroom for running both services.

Best,

Joe

6/12/2012 12:13:23 PM
Gravatar
Total Posts 63
Jerry McCreary
SureFire Studios, Inc.

Re: Arvixe - Database connection drops

Joe A,

It is on a shared host.  IIS and SQL Express are running on same machine (I assume, since I'm using server="localhost").  I'm using their Personal Class package that is advertised on mojoPortal.com. Despite what Arvixe is telling me, it may simply be not enough headroom on the Personal Class package. (We would be moving the final site to their Business Class package eventually anyway, but turns out that trying to save a few bucks by using the Personal Class Package isn't worth the frustration.

I'm interested to know if anyone is successfully using mojoPortal on Arvixe's Personal Class hosting? I'm running into the same problem with 2 different sites using Arvixe Personal Class hosting.

 

Joe D,

I'll check i7media's web site. 

 

Thanks.

Jerry

6/12/2012 5:16:42 PM
Gravatar
Total Posts 355

Re: Arvixe - Database connection drops

Jerry,

I tested Arvixe shared hosting for a single site, but decided to step up to a VPS for my client sites in order to have better control over my hosting environment. I have numerous mojoPortal instances running on my Arvixe VPS, with no performance issues at all. 

Since you haven't had success with consistently recreating the error message, would you mind sharing your mojoPortal event log, so that we can see what mojoPortal's reporting?

6/13/2012 1:53:36 PM
Gravatar
Total Posts 63
Jerry McCreary
SureFire Studios, Inc.

Re: Arvixe - Database connection drops

IndigoTea,

Here is the latest system log. Thanks for any insight.

2012-06-13 11:33:13,501 ERROR (null) - (null) - (null) - mojoPortal.Web.BannedIPBlockingHttpModule - handled exception: 
System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
   at System.Data.SqlClient.TdsParserStateObject.ReadByte()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   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.DBBannedIP.IsBanned(String ipAddress)
   at mojoPortal.Web.BannedIPBlockingHttpModule.BeginRequest(Object sender, EventArgs e)
2012-06-13 11:33:15,715 ERROR (null) - (null) - (null) - mojoPortal.Web.UrlRewriter - System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   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.DBSiteSettings.GetSiteIdByHostName(String hostName)
   at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromCache()
   at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromContext()
   at mojoPortal.Web.UrlRewriter.GetRedirectUrl(String targetUrl)
   at mojoPortal.Web.UrlRewriter.RewriteUrl(HttpApplication app)
   at mojoPortal.Web.UrlRewriter.UrlRewriter_BeginRequest(Object sender, EventArgs e)
2012-06-13 11:33:46,510 ERROR (null) - (null) - (null) - mojoPortal.Web.BannedIPBlockingHttpModule - handled exception: 
System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
   at System.Data.SqlClient.TdsParserStateObject.ReadByte()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   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.DBBannedIP.IsBanned(String ipAddress)
   at mojoPortal.Web.BannedIPBlockingHttpModule.BeginRequest(Object sender, EventArgs e)
2012-06-13 11:33:46,939 ERROR (null) - (null) - (null) - mojoPortal.Web.UrlRewriter - System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   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.DBSiteSettings.GetSiteIdByHostName(String hostName)
   at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromCache()
   at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromContext()
   at mojoPortal.Web.UrlRewriter.GetRedirectUrl(String targetUrl)
   at mojoPortal.Web.UrlRewriter.RewriteUrl(HttpApplication app)
   at mojoPortal.Web.UrlRewriter.UrlRewriter_BeginRequest(Object sender, EventArgs e)
2012-06-13 11:33:46,944 ERROR 75.xxx.xxx.xxx - en-US - / - mojoPortal.Web.BannedIPBlockingHttpModule - handled exception: 
System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   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.DBBannedIP.IsBanned(String ipAddress)
   at mojoPortal.Web.BannedIPBlockingHttpModule.BeginRequest(Object sender, EventArgs e)
2012-06-13 11:33:46,947 ERROR 75.xxx.xxx.xxx - en-US - / - mojoPortal.Web.UrlRewriter - System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   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.DBSiteSettings.GetSiteIdByHostName(String hostName)
   at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromCache()
   at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromContext()
   at mojoPortal.Web.UrlRewriter.GetRedirectUrl(String targetUrl)
   at mojoPortal.Web.UrlRewriter.RewriteUrl(HttpApplication app)
   at mojoPortal.Web.UrlRewriter.UrlRewriter_BeginRequest(Object sender, EventArgs e)
2012-06-13 11:33:46,954 ERROR 75.xxx.xxx.xxx - en-US - / - mojoPortal.Web.BannedIPBlockingHttpModule - handled exception: 
System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   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.DBBannedIP.IsBanned(String ipAddress)
   at mojoPortal.Web.BannedIPBlockingHttpModule.BeginRequest(Object sender, EventArgs e)
2012-06-13 11:33:46,956 ERROR 75.xxx.xxx.xxx - en-US - / - mojoPortal.Web.mojoBasePage - 75.xxx.xxx.xxx-en-US - /
System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   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.DBSiteSettings.GetSiteIdByHostName(String hostName)
   at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromCache()
   at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromContext()
   at mojoPortal.Web.SiteUtils.IsMobileDevice()
   at mojoPortal.Web.mojoBasePage.OnPreInit(EventArgs e)
   at mojoPortal.Web.UI.CmsPage.OnPreInit(EventArgs e)
   at System.Web.UI.Page.PerformPreInit()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
2012-06-13 11:33:46,958 INFO 75.xxx.xxx.xxx - en-US - / - mojoPortal.Web.mojoBasePage - no sites or no database found in application error so try to redirect to Setup Page
2012-06-13 11:33:47,011 ERROR (null) - (null) - (null) - mojoPortal.Web.BannedIPBlockingHttpModule - handled exception: 
System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   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.DBBannedIP.IsBanned(String ipAddress)
   at mojoPortal.Web.BannedIPBlockingHttpModule.BeginRequest(Object sender, EventArgs e)
2012-06-13 11:33:47,014 ERROR (null) - (null) - (null) - mojoPortal.Web.UrlRewriter - System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   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.DBSiteSettings.GetSiteIdByHostName(String hostName)
   at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromCache()
   at mojoPortal.Business.WebHelpers.CacheHelper.GetSiteSettingsFromContext()
   at mojoPortal.Web.UrlRewriter.GetRedirectUrl(String targetUrl)
   at mojoPortal.Web.UrlRewriter.RewriteUrl(HttpApplication app)
   at mojoPortal.Web.UrlRewriter.UrlRewriter_BeginRequest(Object sender, EventArgs e)

6/13/2012 3:30:32 PM
Gravatar
Total Posts 18439

Re: Arvixe - Database connection drops

Hi Jerry,

I followed up with my contact at Arvixe yesterday after you copied me on your support ticket, and I received a copy of a response where they offered to move the affected sites to a different server. I think you should take them up on that as it seems the database timeout problem is likely something specific to the current server you are hosted on.

Best,

Joe

6/13/2012 4:27:10 PM
Gravatar
Total Posts 355

Re: Arvixe - Database connection drops

Jerry,

I'd go with Joe's suggestion, in the interests of saving time and frustration. You might also consider activating the "keep-alive" to see if the timeouts go away.

6/14/2012 11:05:17 AM
Gravatar
Total Posts 63
Jerry McCreary
SureFire Studios, Inc.

Re: Arvixe - Database connection drops

All,

Thanks for your input.  I have accepted Arvixe's offer to move site to a different server.  
I will let you know how it goes.

6/14/2012 2:55:15 PM
Gravatar
Total Posts 533
feet planted firmly on the ground

Re: Arvixe - Database connection drops

I have three personal mojo sites running on Arvixe personal class hosting, with mixed experiences. Cheap, yes, and sometimes it runs very nicely for days, but I have had the similar issues with failures to communicate with the database (as well as larger outages). And often just running dog slow.  It sounds like your problems were worse - I'm talking about one or a few failures every day.  For a while I was monitoring my sites it closely with wasitup.com (now defunct) and they were nowhere near the 99.9% "guaranteed" uptime (though of course Arvixe said it was nothing to do with their server, it must have been my mojoportal sites at fault!).

When I notice this I tend to jump onto their "chat" support, where the operator usually owns up that they are aware of problems on the server.  I think they tend to restart services at the slightest trouble, and the sites and SQL databases are piled high (you can see this by connecting SSMS to your server - I didn't have the life expectancy to count the databases on "pine"), so this leads to a lot of interruptions.

I'd be interested to hear what server you were having bother with?  I'm on "pine". And whether you have better experience on the new one.

For mojoPortal sites running on our own hosting servers (in my professional capacity) we have never experienced mojoPortal automatically running its own setup routine.

6/14/2012 6:06:14 PM
Gravatar
Total Posts 6

Re: Arvixe - Database connection drops

ALCON

I have believe that the issue is a server/service issue and not a MojoPortal issue.  I have multiple MojoPortal websites running with i7Media and not once have I or any of my client websites experienced the issue being discussed here.

For full disclosure:  I have been a client with i7Media for two years now. A little over a year ago, we switched to a dedicated server (went to a dedicated server when we had i7Media create a couple of custom web service and sites).  At no point in time in our relationship with i7Media using MojoPortal have we had any service, downtime, connection or any other kind of issues.  We are always up and running!

I always remember that I have a choice when it comes to CMS packages. I have always had great service so I will always choose MojoPortal! For hosting services, I will not veer away from i7Media. I'm very glad that we found them!

John J. Gately

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