[Mono-bugs] [Bug 79323][Wis] New - SessionSQLServerHandler fails when database restart

[bugzilla-daemon at bugzilla.ximian.com]

Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by informatique.internet at fiducial.fr.

http://bugzilla.ximian.com/show_bug.cgi?id=79323

--- shadow/79323	2006-09-08 11:18:10.000000000 -0400
+++ shadow/79323.tmp.8736	2006-09-08 11:18:10.000000000 -0400
@@ -0,0 +1,67 @@
+Bug#: 79323
+Product: Mono: Class Libraries
+Version: unspecified
+OS: 
+OS Details: 
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Wishlist
+Component: Sys.Web
+AssignedTo: gonzalo at ximian.com                            
+ReportedBy: informatique.internet at fiducial.fr               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: SessionSQLServerHandler fails when database restart
+
+Please fill in this template when reporting a bug, unless you know what you
+are doing.
+Description of Problem:
+
+The last changes in SessionSQLServerHandler (r58047) has a problem, it
+fails if the database restart
+
+
+Steps to reproduce the problem:
+1. run xsp on a website with a web.config like this:
+ <system.web>
+<sessionState mode="SqlServer" sqlConnectionString="server=localhost;user
+id=postgres;password=postgres;database=postgres" timeout="10"/>
+ </system.web>
+<appSettings>
+     <add key="StateDBProviderAssembly" value="Npgsql,Version=1.0.5000.0,
+Culture=neutral, PublicKeyToken=5d8b90d52f46fda7"/>
+
+   </appSettings>
+
+2. hit localhost:8080/yourpage.aspx
+3. Restart postgresql
+4. hit localhost:8080/yourpage.aspx
+
+Actual Results:
+System.InvalidOperationException: Connection already open
+  at Npgsql.NpgsqlConnection.CheckConnectionClosed () [0x00000] 
+  at Npgsql.NpgsqlConnection.Open () [0x00000] 
+  at System.Web.SessionState.SessionSQLServerHandler.GetReaderWithRetry
+(System.String id) [0x00000] 
+  at System.Web.SessionState.SessionSQLServerHandler.SelectSession
+(System.String id, Boolean read_only) [0x00000] 
+  at System.Web.SessionState.SessionSQLServerHandler.UpdateContext
+(System.Web.HttpContext context, System.Web.SessionState.SessionStateModule
+module, Boolean required, Boolean read_only, System.Boolean& isNew) [0x00000] 
+  at System.Web.SessionState.SessionStateModule.OnAcquireState
+(System.Object o, System.EventArgs args) [0x00000] 
+  at (wrapper delegate-invoke)
+System.MulticastDelegate:invoke_void_object_EventArgs (object,System.EventArgs)
+  at System.Web.HttpApplication+<RunHooks>__0.MoveNext () [0x00000] 
+
+Expected Results:
+It should reopen correctly the connection
+
+How often does this happen? 
+always
+
+Additional Information:
+It use to work before!