Hacktoberfest 2026: as issues que os mantenedores marcaram para outubro, abertas e boas para iniciantes. Ver issues do Hacktoberfest

bulkcopy PyCore login is closed by SQL Server 2019 while ODBC and Go clients succeed (1.14.0)

Aberta
  • Algo errado?
#750 4 comentários 0 reações 1 responsável Ver no GitHub

Mantenedores costumam responder em até 1 dia

@bewithgaurav já está trabalhando nisso.

Desde 10/9/2026.

Avaliação

Esta issue ainda não foi avaliada.

Descrição

area: bulk-copy bug triage done
Describe the bug

cursor.bulkcopy() fails while opening its separate native/PyCore connection, although the normal mssql_python.connect() connection succeeds with the same server, database, SQL login, encryption settings, and process.

The failure occurs before destination metadata is read or any rows are sent. It reproduces with both a base table and a view, and even with an empty iterator.

Exception message:
RuntimeError: Failed to connect to SQL Server: Protocol Error: Failed to receive token during login response parsing.

Relevant filtered native TDS trace:
ERROR mssql_tds::message::login: Failed to receive token during login response parsing. Error: ConnectionClosed("Connection closed by server while reading TDS packet header")
DEBUG mssql_tds::connection_provider::tds_connection_provider: Connection attempt failed: Protocol Error: Failed to receive token during login response parsing.
ERROR mssql_py_core::connection: Failed to connect to SQL Server: Protocol Error: Failed to receive token during login response parsing.

This resembles #600, but the trace is different from the DatabaseMirroringPartner UnimplementedFeature fixed by microsoft/mssql-rs#69. This server reports SERVERPROPERTY('IsHadrEnabled') = 0; sys.database_mirroring has no partner or mirroring state for either master or the target database.

To reproduce

The following is the complete minimal reproduction. It creates and cleans up a small table through the working ODBC connection. Substitute environment variables for a SQL Server 2019 instance and SQL-authenticated test account with DDL permissions.

import os

import mssql_python


def braced(value: str) -> str:
    return "{" + value.replace("}", "}}") + "}"


server = os.environ["MSSQL_TEST_SERVER"]
database = os.environ["MSSQL_TEST_DATABASE"]
username = os.environ["MSSQL_TEST_USERNAME"]
password = os.environ["MSSQL_TEST_PASSWORD"]

connection_string = ";".join(
    (
        f"SERVER={braced(server)}",
        f"DATABASE={braced(database)}",
        f"UID={braced(username)}",
        f"PWD={braced(password)}",
        "Encrypt=yes",
        "TrustServerCertificate=yes",
        "",
    )
)

connection = mssql_python.connect(connection_string, timeout=20)
cursor = connection.cursor()

try:
    cursor.execute("SELECT @@VERSION, DB_NAME(), ORIGINAL_LOGIN()")
    print(tuple(cursor.fetchone()))  # succeeds

    cursor.execute("DROP TABLE IF EXISTS dbo.mssql_python_bulkcopy_login_repro")
    cursor.execute(
        "CREATE TABLE dbo.mssql_python_bulkcopy_login_repro (id int NOT NULL)"
    )
    connection.commit()

    # Fails while PyCore opens its separate connection. The same failure occurs
    # with [(1,)] and with an existing view as destination.
    print(
        cursor.bulkcopy(
            "dbo.mssql_python_bulkcopy_login_repro",
            iter(()),
            timeout=10,
        )
    )
finally:
    cursor.execute("DROP TABLE IF EXISTS dbo.mssql_python_bulkcopy_login_repro")
    connection.commit()
    cursor.close()
    connection.close()

Also reproduced with these variations:

  • SERVER=host
  • SERVER=host,1433
  • SERVER=tcp:host,1433
  • connecting to the target database and using a two-part destination name
  • connecting to master and using a fully qualified three-part destination name
  • fire_triggers=False and fire_triggers=True
  • base table and view destinations

Independent controls using the same server and SQL account all succeed:

  • normal mssql_python.connect() plus SELECT
  • ODBC sqlcmd 18.6
  • Go sqlcmd 1.10.0
  • ODBC bcp 18.6 initialization against the same table and view (0 rows copied, exit code 0)

All clients connect to the same explicit TCP port 1433 with encryption enabled and the development certificate trusted.

Expected behavior

cursor.bulkcopy() should establish its native connection and bulk copy the rows when the normal driver connection and other TDS/BCP clients can connect using the same endpoint and credentials.

If the server closes the login connection, the driver should ideally preserve enough diagnostic context to identify the rejected login feature or packet.

Further technical details

Python version: 3.12.11
mssql-python version: 1.14.0
Bundled mssql-python-odbc version: 18.6.2.1
SQL Server version: SQL Server 2019 Standard, 15.0.4430.1
Operating system: macOS 26.5.2, arm64

Additional context

  • The target server is reachable and remains available throughout the tests.
  • There is no separate Bulk Copy port; all successful and failing clients use TCP 1433.
  • Encrypt=yes;TrustServerCertificate=yes is explicitly present, so this does not appear to be the already-fixed connection-parameter forwarding problem from #501.
  • No credentials, hostnames, or packet contents are included in this report.
Linguagem predominante
Python
Estrelas
478
Forks
62
Merge médio
3d 1h
PRs com merge (30d)
27

Preparar o ambiente

Abrir no Codespaces

Inicia o contêiner de desenvolvimento do projeto no navegador, com a sua própria conta do GitHub.

Primeiros passos

  1. Leia a issue inteira e depois o guia de contribuição do projeto.
  2. Comente na issue dizendo que vai assumir — evita que duas pessoas façam o mesmo trabalho.
  3. Faça um fork do repositório e trabalhe em uma branch.
  4. Abra um pull request que referencie o número da issue.

Mais de microsoft/mssql-python

Todas as issues de microsoft/mssql-python

Issues semelhantes

Mais issues de Python

Receba novas issues na sua caixa de entrada

Um resumo curto de issues do GitHub para quem está começando.