postgresql-interfaces/psqlodbc GitHub issues and pull requests (mirror)  

help / color / mirror / Atom feed

From: tazervas (@tazervas) <[email protected]>
To: postgresql-interfaces/psqlodbc <[email protected]>
Subject: [postgresql-interfaces/psqlodbc] issue #90: Unhandled exception on next query after network connection is disconnected then re-connected.
Date: Fri, 14 Feb 2025 13:58:51 +0000
Message-ID: <[email protected]> (raw)

If the network connection is lost and then re-connected during an ODBC session using version 17.00.0004 the next query will throw an "Attempted to read or write protected memory" exception which cannot be caught.  Version 16.00.00 throws exception "The connection has been disabled (or lost).  ERROR [08S01] server closed the connection unexpectedly" which can be caught and acted upon which is the desired behavior.

Example Visual Studio 2022 .NET 8 Windows Forms Visual Basic code which demonstrates this issue:

        Try

            Dim cs As New Odbc.OdbcConnectionStringBuilder
            cs.Clear()
            cs.Driver = "PostgreSQL Unicode(x64)"
            cs.Add("Database", "database")
            cs.Add("Servername", "host")
            cs.Add("UID", "user")
            cs.Add("PWD", "password")

            Dim c As Odbc.OdbcConnection = New Odbc.OdbcConnection With {.ConnectionString = cs.ConnectionString}
            c.Open()

            Dim sql As Odbc.OdbcCommand = c.CreateCommand
            sql.CommandType = CommandType.Text
            sql.CommandText = "SELECT count(*) FROM anytable"

            sql.ExecuteScalar()

            MsgBox("psqlODBC exception test: disconnect then re-connect network")

            sql.ExecuteScalar()     ' unhandled exception here

        Catch ex As Exception
            MsgBox(ex.ToString)

        End Try

Exception text:

System.AccessViolationException
  HResult=0x80004003
  Message=Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
  Source=<Cannot evaluate the exception source>
  StackTrace:
<Cannot evaluate the exception stack trace>

 	[Managed to Native Transition]	
 	System.Data.Odbc.dll!System.Data.Odbc.OdbcConnectionHandle.ReleaseHandle()	Unknown
 	System.Private.CoreLib.dll!System.Runtime.InteropServices.SafeHandle.InternalRelease(bool disposeOrFinalizeOperation)	Unknown
 	System.Private.CoreLib.dll!System.Runtime.InteropServices.SafeHandle.Dispose()	Unknown
 	System.Data.Odbc.dll!System.Data.Odbc.OdbcConnection.Close()	Unknown
 	System.Data.Odbc.dll!System.Data.Odbc.OdbcConnection.ConnectionIsAlive(System.Exception innerException)	Unknown
 	System.Data.Odbc.dll!System.Data.Odbc.OdbcConnection.HandleErrorNoThrow(System.Data.Odbc.OdbcHandle hrHandle, System.Data.Odbc.ODBC32.SQLRETURN retcode)	Unknown
 	System.Data.Odbc.dll!System.Data.Odbc.OdbcConnection.HandleError(System.Data.Odbc.OdbcHandle hrHandle, System.Data.Odbc.ODBC32.SQLRETURN retcode)	Unknown
 	System.Data.Odbc.dll!System.Data.Odbc.OdbcCommand.ExecuteReaderObject(System.Data.CommandBehavior behavior, string method, bool needReader, object[] methodArguments, System.Data.Odbc.ODBC32.SQL_API odbcApiMethod)	Unknown
 	System.Data.Odbc.dll!System.Data.Odbc.OdbcCommand.ExecuteReaderObject(System.Data.CommandBehavior behavior, string method, bool needReader)	Unknown
 	System.Data.Odbc.dll!System.Data.Odbc.OdbcCommand.ExecuteScalar()	Unknown
>	psqlodbc_17_0004_exception.dll!psqlodbc_17_0004_exception.Form1.Form1_Load(Object sender, System.EventArgs e) Line 43	Basic

view thread (4+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: github://postgresql-interfaces/psqlodbc
  Cc: [email protected], [email protected]
  Subject: Re: [postgresql-interfaces/psqlodbc] issue #90: Unhandled exception on next query after network connection is disconnected then re-connected.
  In-Reply-To: <<[email protected]>>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox