[Dnfbb-developers] [ dnfbb-Bugs-1590745 ] Cannot open database connection exception

[SourceForge.net <no...@so...>]

Bugs item #1590745, was opened at 2006-11-05 09:21
Message generated for change (Settings changed) made by tectsoft
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=784889&aid=1590745&group_id=152364

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: All Layers
>Group: V2 Pre-Beta
>Status: Closed
>Resolution: Accepted
Priority: 7
Private: No
Submitted By: Bosie (sbosanquet)
>Assigned to: Si (tectsoft)
Summary: Cannot open database connection exception

Initial Comment:
When the database server connection cannot be opened 
the following unhandled exception is generated.

Exception:

Server Error in '/dnf' Application.
-------------------------------------------------------
-------------------------

A request to send or receive data was disallowed 
because the socket is not connected and (when sending 
on a datagram socket using a sendto call) no address 
was supplied 
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.Net.Sockets.SocketException: 
A request to send or receive data was disallowed 
because the socket is not connected and (when sending 
on a datagram socket using a sendto call) no address 
was supplied

Source Error: 


Line 848:
Line 849:			MySqlConnection db = 
new MySqlConnection(_ConnString);
Line 850:			db.Open();
Line 851:			try
Line 852:			{
 

Source File: d:\Misc\SF\dnfBB_SVN\v1
\DNFLib\DAL\MySQLDB.cs    Line: 850 

Stack Trace: 


[SocketException (0x2749): A request to send or 
receive data was disallowed because the socket is not 
connected and (when sending on a datagram socket using 
a sendto call) no address was supplied]
   System.Net.Sockets.Socket.Shutdown(SocketShutdown 
how) +189
   MySql.Data.Common.SocketStream.Read(Byte[] buffer, 
Int32 offset, Int32 count) +72
   System.IO.BufferedStream.ReadByte() +113
   MySql.Data.MySqlClient.PacketReader.ReadHeader() +16
   MySql.Data.MySqlClient.PacketReader.OpenPacket() 
+107
   MySql.Data.MySqlClient.NativeDriver.Open() +726
   
MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnect
ion() +147
   MySql.Data.MySqlClient.MySqlPool.GetPooledConnection
() +53
   MySql.Data.MySqlClient.MySqlPool.GetConnection() 
+148
   
MySql.Data.MySqlClient.MySqlPoolManager.GetConnection
(MySqlConnectionString settings) +264
   MySql.Data.MySqlClient.MySqlConnection.Open() +145
   DotNetForum.Library.DAL.MySqlDB.AdminBoardExists
(Int64 BoardID) in d:\Misc\SF\dnfBB_SVN\v1
\DNFLib\DAL\MySQLDB.cs:850
   DotNetForum.Library.BOL.UserSession.BoardExists
(Int64 BoardID) in d:\Misc\SF\dnfBB_SVN\v1
\DNFLib\BOL\UserSession.cs:238
   DotNetForum.WebSite.Classes.BaseWebForm.BoardExists
() in d:\Misc\SF\dnfBB_SVN\v1
\wwwroot\Classes\BaseWebFormClass.cs:301
   DotNetForum.WebSite.Classes.BaseWebForm.LoginUser() 
in d:\Misc\SF\dnfBB_SVN\v1
\wwwroot\Classes\BaseWebFormClass.cs:219
   DotNetForum.WebSite.Classes.BaseWebForm.GetSession
() in d:\Misc\SF\dnfBB_SVN\v1
\wwwroot\Classes\BaseWebFormClass.cs:283
   DotNetForum.WebSite.Classes.BaseWebForm.OnInit
(EventArgs e) in d:\Misc\SF\dnfBB_SVN\v1
\wwwroot\Classes\BaseWebFormClass.cs:62
   DotNetForum.WebSite.WebForm1.OnInit(EventArgs e) in 
d:\Misc\SF\dnfBB_SVN\v1\wwwroot\Index.aspx.cs:336
   System.Web.UI.Control.InitRecursive(Control 
namingContainer) +241
   System.Web.UI.Page.ProcessRequestMain() +197

 


-------------------------------------------------------
-------------------------
Version Information: Microsoft .NET Framework 
Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032 

----------------------------------------------------------------------

Comment By: Si (tectsoft)
Date: 2006-11-05 09:27

Message:
Logged In: YES 
user_id=1154545

This fits in with a current FR
(http://sourceforge.net/tracker/index.php?func=detail&aid=1587837&group_id=152364&atid=784892)

All errors need to be handled more gracefully and should be
redirected to a default page, logging to SF (or other
mechanism is secondary at the moment)

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=784889&aid=1590745&group_id=152364