cloud-sql.sql-server.sqlalchemy.connection_test: test_cast_vote failed #9096
Description
Note: #8372 was also for this test, but it was closed more than 10 days ago. So, I didn't mark it flaky.
commit: e8e8b4e
buildURL: Build Status, Sponge
status: failed
Test output
Traceback (most recent call last):
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 3280, in _wrap_pool_connect
return fn()
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 310, in connect
return _ConnectionFairy._checkout(self)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 868, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 476, in checkout
rec = pool._do_get()
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 146, in _do_get
self._dec_overflow()
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 72, in __exit__
with_traceback=exc_tb,
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 143, in _do_get
return self._create_connection()
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 256, in _create_connection
return _ConnectionRecord(self)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 371, in __init__
self.__connect()
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 666, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 72, in __exit__
with_traceback=exc_tb,
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/engine/create.py", line 590, in connect
return dialect.connect(*cargs, **cparams)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 597, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/pytds/__init__.py", line 1345, in connect
conn._open(sock=sock)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/pytds/__init__.py", line 372, in _open
self._try_open(timeout=retry_time, sock=sock)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/pytds/__init__.py", line 354, in _try_open
self._connect(host=host, port=port, instance=instance, timeout=timeout, sock=sock)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/pytds/__init__.py", line 304, in _connect
route = conn.login(login, sock, self._tzinfo_factory)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/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-7/lib/python3.7/site-packages/pytds/tds.py", line 1294, in process_prelogin
self.parse_prelogin(octets=p, login=login)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/pytds/tds.py", line 1343, in parse_prelogin
raise tds_base.Error('Client does not have encryption enabled but it is required by server, '
pytds.tds_base.Error: Client does not have encryption enabled but it is required by server, enable encryption and try connecting again
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/workspace/cloud-sql/sql-server/sqlalchemy/connection_test.py", line 55, in test_cast_vote
response = client.post("/votes", data={"team": "SPACES"})
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/werkzeug/test.py", line 1145, in post
return self.open(*args, **kw)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/flask/testing.py", line 220, in open
follow_redirects=follow_redirects,
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/werkzeug/test.py", line 1094, in open
response = self.run_wsgi_app(request.environ, buffered=buffered)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/werkzeug/test.py", line 961, in run_wsgi_app
rv = run_wsgi_app(self.application, environ, buffered=buffered)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/werkzeug/test.py", line 1242, in run_wsgi_app
app_rv = app(environ, start_response)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/flask/app.py", line 2095, in call
return self.wsgi_app(environ, start_response)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/flask/app.py", line 2080, in wsgi_app
response = self.handle_exception(e)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/flask/app.py", line 2077, in wsgi_app
response = self.full_dispatch_request()
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/flask/app.py", line 1518, in full_dispatch_request
self.try_trigger_before_first_request_functions()
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/flask/app.py", line 1570, in try_trigger_before_first_request_functions
self.ensure_sync(func)()
File "/workspace/cloud-sql/sql-server/sqlalchemy/app.py", line 79, in init_db
migrate_db(db)
File "/workspace/cloud-sql/sql-server/sqlalchemy/app.py", line 52, in migrate_db
inspector = sqlalchemy.inspect(db)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/inspection.py", line 64, in inspect
ret = reg(subject)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/engine/reflection.py", line 182, in _engine_insp
return Inspector._construct(Inspector._init_engine, bind)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/engine/reflection.py", line 117, in _construct
init(self, bind)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/engine/reflection.py", line 128, in _init_engine
engine.connect().close()
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 3234, in connect
return self._connection_cls(self, close_with_result=close_with_result)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 96, in init
else engine.raw_connection()
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 3313, in raw_connection
return self._wrap_pool_connect(self.pool.connect, _connection)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 3284, in wrap_pool_connect
e, dialect, self
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2118, in handle_dbapi_exception_noconnection
sqlalchemy_exception, with_traceback=exc_info[2], from=e
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 208, in raise
raise exception
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 3280, in _wrap_pool_connect
return fn()
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 310, in connect
return _ConnectionFairy._checkout(self)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 868, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 476, in checkout
rec = pool._do_get()
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 146, in _do_get
self.dec_overflow()
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 72, in exit
with_traceback=exc_tb,
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 208, in raise
raise exception
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 143, in _do_get
return self._create_connection()
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 256, in _create_connection
return _ConnectionRecord(self)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 371, in init
self.__connect()
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 666, in _connect
pool.logger.debug("Error on connect(): %s", e)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 72, in exit
with_traceback=exc_tb,
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 208, in raise
raise exception
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/engine/create.py", line 590, in connect
return dialect.connect(*cargs, **cparams)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 597, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/pytds/init.py", line 1345, in connect
conn._open(sock=sock)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/pytds/init.py", line 372, in _open
self._try_open(timeout=retry_time, sock=sock)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/pytds/init.py", line 354, in _try_open
self._connect(host=host, port=port, instance=instance, timeout=timeout, sock=sock)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/pytds/init.py", line 304, in _connect
route = conn.login(login, sock, self._tzinfo_factory)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/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-7/lib/python3.7/site-packages/pytds/tds.py", line 1294, in process_prelogin
self.parse_prelogin(octets=p, login=login)
File "/workspace/cloud-sql/sql-server/sqlalchemy/.nox/py-3-7/lib/python3.7/site-packages/pytds/tds.py", line 1343, in parse_prelogin
raise tds_base.Error('Client does not have encryption enabled but it is required by server, '
sqlalchemy.exc.DBAPIError: (pytds.tds_base.Error) Client does not have encryption enabled but it is required by server, enable encryption and try connecting again
(Background on this error at: https://sqlalche.me/e/14/dbapi)