test is stuck at waiting and then times out : postgres container

[ypatel26]

Can someone please help fix this issue? Not sure what to do. Container starts up fine. But my test is timing out.

py.test -s
========================================================================== test session starts ==========================================================================
platform darwin -- Python 3.8.3, pytest-5.4.3, py-1.8.1, pluggy-0.13.1
rootdir: /Users/ypatel/postgres
collecting ... testing
collected 1 item                                                                                                                                                        

test_db_containers.py 
Pulling image localhost/opensource/postgres/postgresql12:12.3
⠴
Container started:  d21da7fa95
Waiting to be ready...
F

=============================================================================== FAILURES ================================================================================
_______________________________________________________________________ test_docker_run_postgress _______________________________________________________________________

    def test_docker_run_postgress():
        postgres_container = PostgresContainer("localhost/opensource/postgres/postgresql12:12.3")
    
>       with postgres_container as postgres:

test_db_containers.py:21: 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/testcontainers/core/container.py:64: in __enter__
    return self.start()
/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/testcontainers/core/generic.py:42: in start
    self._connect()
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

wrapped = <bound method DbContainer._connect of <testcontainers.postgres.PostgresContainer object at 0x7fcb692b6700>>
instance = <testcontainers.postgres.PostgresContainer object at 0x7fcb692b6700>, args = (), kwargs = {}

    @wrapt.decorator
    def wrapper(wrapped, instance, args, kwargs):
        exception = None
        print(crayons.yellow("Waiting to be ready..."))
        with blindspin.spinner():
            for _ in range(0, config.MAX_TRIES):
                try:
                    return wrapped(*args, **kwargs)
                except Exception as e:
                    time.sleep(config.SLEEP_TIME)
                    exception = e
>           raise TimeoutException(
                """Wait time exceeded {0} sec.
                    Method {1}, args {2} , kwargs {3}.
                     Exception {4}""".format(config.MAX_TRIES,
                                             wrapped.__name__,
                                             args, kwargs, exception))
E           testcontainers.core.exceptions.TimeoutException: Wait time exceeded 120 sec.
E                               Method _connect, args () , kwargs {}.
E                                Exception (psycopg2.OperationalError) server closed the connection unexpectedly
E               This probably means the server terminated abnormally
E               before or while processing the request.
E           
E           (Background on this error at: http://sqlalche.me/e/e3q8)

/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/testcontainers/core/waiting_utils.py:46: TimeoutException
======================================================================== short test summary info ========================================================================
FAILED test_db_containers.py::test_docker_run_postgress - testcontainers.core.exceptions.TimeoutException: Wait time exceeded 120 sec.
===================================================================== 1 failed in 124.21s (0:02:04) =====================================================================

[calswbin]

Like others from the interest on this post, I can confirm that I can replicate this issue using Docker Desktop on Windows OS, when using both Hyper-V and WSL2 backends.

For WSL2 I have enabled vsyscall seen in the guide within the testcontainers-java fork here. I can confirm this sadly does not fix the issue https://www.testcontainers.org/supported_docker_environment/windows/

Spec Python 3.8.8 Docker version 20.10.5, build 55c4c88 testcontainers[postgresql]==3.2.0

Can you please advise?

[marcrleonard]

I am having the same issue on windows WSL2

Python 3.7.6 Docker engine version v20.10.2 testcontainers[mysql]

[marcrleonard]

This feels like a named pipe issue. I found this workaround to work for me:

https://github.com/testcontainers/testcontainers-python/issues/108#issuecomment-660371568