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).