Description
Note: #373 was also for this test, but it was closed more than 10 days ago. So, I didn't mark it flaky.
commit: 912fa39
buildURL: Build Status, Sponge
status: failed
Test output
Traceback (most recent call last): File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/google/cloud/bigquery/dbapi/cursor.py", line 213, in _execute self._query_job.result() File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/google/cloud/bigquery/job/query.py", line 1520, in result do_get_result() File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/google/api_core/retry.py", line 349, in retry_wrapped_func return retry_target( File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/google/api_core/retry.py", line 191, in retry_target return target() File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/google/cloud/bigquery/job/query.py", line 1510, in do_get_result super(QueryJob, self).result(retry=retry, timeout=timeout) File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/google/cloud/bigquery/job/base.py", line 911, in result return super(_AsyncJob, self).result(timeout=timeout, **kwargs) File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/google/api_core/future/polling.py", line 261, in result raise self._exception google.api_core.exceptions.BadRequest: 400 Cannot rename precise-truck-742:python_bigquery_sqlalchemy_tests_system_20230516050505_ddce40.account due to a concurrent operation.Location: US
Job ID: 4ec48980-ae47-46f2-8506-28caeb6eef4cDuring handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1905, in _execute_context
self.dialect.do_execute(
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
cursor.execute(statement, parameters)
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/google/cloud/bigquery/dbapi/_helpers.py", line 494, in with_closed_check
return method(self, *args, **kwargs)
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/google/cloud/bigquery/dbapi/cursor.py", line 176, in execute
self._execute(
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/google/cloud/bigquery/dbapi/cursor.py", line 215, in _execute
raise exceptions.DatabaseError(exc)
google.cloud.bigquery.dbapi.exceptions.DatabaseError: 400 Cannot rename precise-truck-742:python_bigquery_sqlalchemy_tests_system_20230516050505_ddce40.account due to a concurrent operation.Location: US
Job ID: 4ec48980-ae47-46f2-8506-28caeb6eef4cThe above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/tmpfs/src/github/python-bigquery-sqlalchemy/tests/system/test_alembic.py", line 130, in test_alembic_scenario
op.rename_table("account", "accounts")
File "", line 8, in rename_table
File "", line 3, in rename_table
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/alembic/operations/ops.py", line 1425, in rename_table
return operations.invoke(op)
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/alembic/operations/base.py", line 395, in invoke
return fn(self, operation)
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/alembic/operations/toimpl.py", line 122, in rename_table
operations.impl.rename_table(
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/alembic/ddl/impl.py", line 346, in rename_table
self._exec(
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/alembic/ddl/impl.py", line 193, in _exec
return conn.execute( # type: ignore[call-overload]
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1385, in execute
return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS)
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/sqlalchemy/sql/ddl.py", line 80, in _execute_on_connection
return connection._execute_ddl(
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1477, in _execute_ddl
ret = self._execute_context(
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1948, in _execute_context
self.handle_dbapi_exception(
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2129, in handle_dbapi_exception
util.raise(
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 211, in raise
raise exception
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1905, in _execute_context
self.dialect.do_execute(
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
cursor.execute(statement, parameters)
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/google/cloud/bigquery/dbapi/_helpers.py", line 494, in with_closed_check
return method(self, *args, **kwargs)
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/google/cloud/bigquery/dbapi/cursor.py", line 176, in execute
self._execute(
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/prerelease_deps-3-8/lib/python3.8/site-packages/google/cloud/bigquery/dbapi/cursor.py", line 215, in _execute
raise exceptions.DatabaseError(exc)
sqlalchemy.exc.DatabaseError: (google.cloud.bigquery.dbapi.exceptions.DatabaseError) 400 Cannot rename precise-truck-742:python_bigquery_sqlalchemy_tests_system_20230516050505_ddce40.account due to a concurrent operation.Location: US
Job ID: 4ec48980-ae47-46f2-8506-28caeb6eef4c[SQL: ALTER TABLE
account
RENAME TOaccounts
]
(Background on this error at: https://sqlalche.me/e/14/4xp6)