UnboundLocalError in mssql/base.py:1925

[sqlalchemy-bot]

Migrated issue, originally created by Umberto Prim

In my call to engine.raw_connection() I have got this error:

File "D:\Anaconda\lib\site-packages\sqlalchemy\dialects\mssql\base.py", line 1925, in get_isolation_level
    "tried views: %s; final error was: %s" % (views, err))
UnboundLocalError: local variable 'err' referenced before assignment

Which looks like an easy fix.

[sqlalchemy-bot]

Michael Bayer (@zzzeek) wrote:

pr at zzzeek/sqlalchemy#453

[sqlalchemy-bot]

Michael Bayer (@zzzeek) wrote:

what's the actual error it is trying to report?

[sqlalchemy-bot]

Michael Bayer (@zzzeek) wrote:

also this is a Python 3 error...heh

[sqlalchemy-bot]

Michael Bayer (@zzzeek) wrote:

https://gerrit.sqlalchemy.org/#/q/I39877c1f65f9cf8602fb1dceaf03072357759564 for 1.2 / master

[sqlalchemy-bot]

Changes by Michael Bayer (@zzzeek):

• set milestone to "1.2.x"

[sqlalchemy-bot]

Michael Bayer (@zzzeek) wrote:

Fix UnboundLocalError in mssql during isolation level grab

Fixed issue within the SQL Server dialect under Python 3 where when running
against a non-standard SQL server database that does not contain either the
"sys.dm_exec_sessions" or "sys.dm_pdw_nodes_exec_sessions" views, leading
to a failure to fetch the isolation level, the error raise would fail due
to an UnboundLocalError.

Fixes: #4273
Co-authored-by: wikiped wikiped@yandex.ru
Change-Id: I39877c1f65f9cf8602fb1dceaf03072357759564

→ e2913f6

[sqlalchemy-bot]

Michael Bayer (@zzzeek) wrote:

Fix UnboundLocalError in mssql during isolation level grab

Fixed issue within the SQL Server dialect under Python 3 where when running
against a non-standard SQL server database that does not contain either the
"sys.dm_exec_sessions" or "sys.dm_pdw_nodes_exec_sessions" views, leading
to a failure to fetch the isolation level, the error raise would fail due
to an UnboundLocalError.

Fixes: #4273
Co-authored-by: wikiped wikiped@yandex.ru
Change-Id: I39877c1f65f9cf8602fb1dceaf03072357759564
(cherry picked from commit e2913f6)

→ d404111

[sqlalchemy-bot]

Changes by Michael Bayer (@zzzeek):

• changed status to closed