cloud-sql.sql-server.sqlalchemy.connection_test: test_get failed

[flaky-bot]

This test failed!

To configure my behavior, see the Flaky Bot documentation.

If I'm commenting on this issue too often, add the flakybot: quiet label and
I will stop commenting.

---

commit: 16c70db
buildURL: Build Status, Sponge
status: failed

Test output

Traceback (most recent call last):
  File "/workspace/cloud-sql/sql-server/sqlalchemy/connection_test.py", line 55, in tcp_db_connection
    yield from _common_setup()
  File "/workspace/cloud-sql/sql-server/sqlalchemy/connection_test.py", line 68, in _common_setup
    with pool.connect() as conn:
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 3067, in connect
    return self._connection_cls(self, close_with_result=close_with_result)
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 91, in __init__
    else engine.raw_connection()
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 3146, in raw_connection
    return self._wrap_pool_connect(self.pool.connect, _connection)
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 3113, in _wrap_pool_connect
    return fn()
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 301, in connect
    return _ConnectionFairy._checkout(self)
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 755, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 419, in checkout
    rec = pool._do_get()
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 145, in _do_get
    self._dec_overflow()
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 72, in __exit__
    with_traceback=exc_tb,
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 198, in raise_
    raise exception
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 142, in _do_get
    return self._create_connection()
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 247, in _create_connection
    return _ConnectionRecord(self)
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 362, in __init__
    self.__connect(first_connect_check=True)
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 605, in __connect
    pool.logger.debug("Error on connect(): %s", e)
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 72, in __exit__
    with_traceback=exc_tb,
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 198, in raise_
    raise exception
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 599, in __connect
    connection = pool._invoke_creator(self)
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/sqlalchemy/engine/create.py", line 578, in connect
    return dialect.connect(*cargs, **cparams)
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 548, in connect
    return self.dbapi.connect(*cargs, **cparams)
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/pytds/__init__.py", line 1330, in connect
    conn._open()
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/pytds/__init__.py", line 371, in _open
    self._try_open(timeout=retry_time)
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/pytds/__init__.py", line 353, in _try_open
    self._connect(host=host, port=port, instance=instance, timeout=timeout)
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/pytds/__init__.py", line 303, in _connect
    route = conn.login(login, sock, self._tzinfo_factory)
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/pytds/tds.py", line 1703, in login
    self._main_session.process_prelogin(login)
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/pytds/tds.py", line 1290, in process_prelogin
    p = self._reader.read_whole_packet()
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/pytds/tds.py", line 253, in read_whole_packet
    self._read_packet()
  File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-6/lib/python3.6/site-packages/pytds/tds.py", line 230, in _read_packet
    received = self._transport.recv_into(self._bufview[pos:_header.size-pos])
socket.timeout: timed out

[flaky-bot]

Looks like this issue is flaky. 😟

I'm going to leave this open and stop commenting.

A human should fix and close this.

---

When run at the same commit (16c70db), this test passed in one build (Build Status, Sponge) and failed in another build (Build Status, Sponge).