Bug: Running `.exec` on `SqlServerContainer` instance hangs indefinitely

[manoss96]

Describe the bug

I am trying to create a table within a SqlServer container during start up. I am running the necessary command via the exec method, but said method just hangs and never exits.

Additional info: When bashing into the container and running the command, it works just fine and the process does not hang. Furthermore, running a different SQL query via the exec method such as SELECT 1 works as well.

To Reproduce

with SqlServerContainer(image="mcr.microsoft.com/mssql/server:2022-CU12-ubuntu-22.04") as container:
   container.exec(
      "/opt/mssql-tools/bin/sqlcmd -U SA -P 1Secure*Password1 -d tempdb -Q 'CREATE TABLE test_table (id INT PRIMARY KEY)'"
   )

Runtime environment

OS: Windows 11
Python version: 3.12.10
Docker version: 28.4.0, build d8eb465
Testcontainers version: 4.13.2

[alexanderankin]

which statement hangs the creation/context or just the exec method call?

…

On Fri, Oct 24, 2025 at 3:03 PM Manos Stoumpos ***@***.***> wrote: *manoss96* created an issue (testcontainers/testcontainers-python#910) <#910> *Describe the bug* I am trying to create a table within a SqlServer container during start up. I am running the necessary command via the exec method, but said method just hangs and never exits. Additional info: When bashing into the container and running the command, it works just fine and the process does not hang. Furthermore, running a different SQL query via the exec method such as SELECT 1 works as well. *To Reproduce* with SqlServerContainer(image="mcr.microsoft.com/mssql/server:2022-CU12-ubuntu-22.04") as container: container.exec("/opt/mssql-tools/bin/sqlcmd -U SA -P 1Secure*Password1 -d tempdb -Q 'CREATE TABLE test_table (id INT PRIMARY KEY)'") *Runtime environment* OS: Windows 11 Python version: 3.12.10 Docker version: 28.4.0, build d8eb465 Testcontainers version: 4.13.2 — Reply to this email directly, view it on GitHub <#910>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACECGJAZPBVUM6BBCVLRCC33ZJZZ3AVCNFSM6AAAAACKETSMCGVHI2DSMVQWIX3LMV43ASLTON2WKOZTGU2TANRVHAYDEMY> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[manoss96]

which statement hangs the creation/context or just the exec method call?
…

The exec method call.