Lesson Learned #359: TCP Provider: Error code 0x68 (104) (SQLExecDirectW)

This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Community Hub.

Today, we got a service request that our customer faced the following error message connecting to the database:  (pyodbc.OperationalError) ('08S01', '[08S01] [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x68 (104) (SQLExecDirectW)'). This customer is using Python in a Linux environment. Following I would like to share my lessons learned about this error message. 


Checking what does mean 0x68 is 104 in decimal, and that is a Connection Reset by Peer error (i.e. the server abruptly closed the connection) and in Linux errors are listed here: https://github.com/torvalds/linux/blob/master/include/uapi/asm-generic/errno.h


Most probably, this error means that our customer is opening the connection using proxy policy Azure SQL Database connectivity architecture - Azure SQL Database and Azure Synapse Analytics | Microsoft Learn and it was in idle state for more than 30 minutes. In this situation after 30 minutes in idle state the connection will be closed by GatewayLesson Learned #214: Hands-On-Labs: How to manage an idle connection state issue - Microsoft Community Hub - Understanding Connectivity Issues in Azure SQL Database - Microsoft Community Hub if the application tries to use the connection without checking if the connection is closed you are going to have this error message


We have several options to mitigate this issue:





import pyodbc import time def PythonRetryLogicConnectToTheDB(): try: nTimes=0 while nTimes <5: nTimes=nTimes+1 print("Connecting to the DB - Attempt Number: %i " % nTimes) start_time = time.time() conn = ConnectToTheDB() if( conn != None ): print("Connected to the Database %s seconds ---" % ((time.time() - start_time)) ) return conn else: print("------ Next Attempt ----- Waiting for 5 seconds ---") time.sleep(5) return except Exception as e: print("An error occurred connecting to the DB - " + format(e)) return def ConnectToTheDB(): try: return pyodbc.connect("DRIVER={ODBC Driver 18 for SQL Server};server=tcp:servername.database.windows.net,1433;UID=username;PWD=password;database=dbname;APP=Testing Connection;timeout=30"); except Exception as e: print("An error occurred connecting to the DB - " + format(e)) return SQL = "select 1" nLoop=1 while nLoop<100: nLoop=nLoop+1 conn = PythonRetryLogicConnectToTheDB() if( conn != None ): cursor = conn.cursor() start_time = time.time() cursor.execute(SQL) row = cursor.fetchone() print("---------------- Loop:%d - %s seconds ---" % (nLoop,(time.time() - start_time)) ) conn.close() else: print("---------------- Loop:%d - (Not able to connect) " % (nLoop))





Leave a Reply

Your email address will not be published. Required fields are marked *


This site uses Akismet to reduce spam. Learn how your comment data is processed.