sql 2008 timeout expired

Rene Falkenberg 5 posts 25 karma points

Feb 11, 2010 @ 07:48

Hi,

I have recently move from one hosting providor to another. The former providor was using SQL 2005 and the new providor is using 2008. I installed SQL Manager 2008 and used Data Export/Import to move the contents between the two SQL servers. Everything went fine. Then i used FTP to download the content and upload it to the new providor again no problems.

I changed the web.config with the new credentials and tried to login to the /umbraco backend and i have no problems with that.

But when i try to access the normal site i get the following :


[SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]

Its umbraco v4.0.2.1 and ASP.NET 2.0

And yes i know what the SqlException is saying, but i just don't understand why i can login to the backend but the frontend is not working....

/René

Copy Link

Petr Snobelt 923 posts 1535 karma points

Feb 11, 2010 @ 08:30

Try post full exception details...

Copy Link

Thomas Höhler 1237 posts 1709 karma points MVP

Feb 11, 2010 @ 08:50

Recommendet is not data export/import for moving better is to do a backup of the old db and restore on the new system. So the indexes are in sync.One thing is to recycle the indexes of the tables.(or delete and recreate them)

before try to republish the whole site...

Cheers, Thomas

Copy Link

Rene Falkenberg 5 posts 25 karma points

Feb 11, 2010 @ 08:52

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1951450
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4849003
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2394
   System.Data.SqlClient.SqlDataReader.SetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo) +125
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1910
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
   System.Data.SqlClient.SqlDataReader.get_MetaData() +83
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +12
   SME.AppCode.<>c__DisplayClass7.<ExecuteReader>b__6(IDbCommand cmd) +181
   SME.AppCode.<>c__DisplayClass4.<ExecuteCommand>b__3(IDbConnection connection) +114
   SME.AppCode.DBUtils.DoWithConnection(DoWithConnectionDelegate callback) +140
   SME.AppCode.DBUtils.ExecuteCommand(String query, ExecuteCommandDelegate callback) +126
   SME.AppCode.DBUtils.ExecuteReader(String query, ExecuteReaderDelegate readerCallback, DbParameter[] _params) +129
   SME.usercontrols.TopMenu.get_TopMenuList() +462
   SME.usercontrols.TopMenu.OnLoad(EventArgs e) +37
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Control.LoadRecursive() +141
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

Version Information: Microsoft .NET Framework Version:2.0.50727.4927; ASP.NET Version:2.0.50727.4927

Copy Link

Rene Falkenberg 5 posts 25 karma points

Feb 11, 2010 @ 08:54

And to Thomas, the old hosting company will not provide me with a backup !

Copy Link

mph 44 posts 78 karma points

Feb 11, 2010 @ 08:55

Hi René!

I agree that it's strange you can login to the backend, but not the front end...

Are you using a remote SQL??

Try to add this to the end of your umbracoDbDSN ;timeout=60

/Michael

Copy Link

Thomas Höhler 1237 posts 1709 karma points MVP

Feb 11, 2010 @ 08:56

Oh, this is thrown by the usercontrol TopMenu in the function get_TopMenuList...

Take a look into this code or paste it here

Copy Link

is working on a reply...

Flag this post as spam?

SQL 2008 Timeout Expired

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.