Skip to content

tests.system.test_alembic: test_alembic_scenario failed #862

Closed
@flaky-bot

Description

@flaky-bot

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-28caeb6eef4c

During 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-28caeb6eef4c

The 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 TO accounts]
(Background on this error at: https://sqlalche.me/e/14/4xp6)

Metadata

Metadata

Assignees

No one assigned

    Labels

    api: bigqueryIssues related to the googleapis/python-bigquery-sqlalchemy API.flakybot: flakyTells the Flaky Bot not to close or comment on this issue.flakybot: issueAn issue filed by the Flaky Bot. Should not be added manually.priority: p1Important issue which blocks shipping the next release. Will be fixed prior to next release.type: bugError or flaw in code with unintended results or allowing sub-optimal usage patterns.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions