Skip to content

tests.system.test_alembic: test_alembic_scenario failed #862

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
flaky-bot bot opened this issue May 16, 2023 · 4 comments · Fixed by #868
Closed

tests.system.test_alembic: test_alembic_scenario failed #862

flaky-bot bot opened this issue May 16, 2023 · 4 comments · Fixed by #868
Labels
api: bigquery Issues related to the googleapis/python-bigquery-sqlalchemy API. flakybot: flaky Tells the Flaky Bot not to close or comment on this issue. flakybot: issue An issue filed by the Flaky Bot. Should not be added manually. priority: p1 Important issue which blocks shipping the next release. Will be fixed prior to next release. type: bug Error or flaw in code with unintended results or allowing sub-optimal usage patterns.

Comments

@flaky-bot
Copy link

flaky-bot bot commented May 16, 2023

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)
@flaky-bot flaky-bot bot added flakybot: issue An issue filed by the Flaky Bot. Should not be added manually. priority: p1 Important issue which blocks shipping the next release. Will be fixed prior to next release. type: bug Error or flaw in code with unintended results or allowing sub-optimal usage patterns. labels May 16, 2023
@product-auto-label product-auto-label bot added the api: bigquery Issues related to the googleapis/python-bigquery-sqlalchemy API. label May 16, 2023
@shollyman
Copy link

closing as suspected backend flake

@flaky-bot flaky-bot bot reopened this May 17, 2023
@flaky-bot flaky-bot bot added the flakybot: flaky Tells the Flaky Bot not to close or comment on this issue. label May 17, 2023
@flaky-bot
Copy link
Author

flaky-bot bot commented May 17, 2023

Looks like this issue is flaky. 😟

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

A human should fix and close this.

commit: 912fa39
buildURL: Build Status, Sponge
status: failed

Test output
Traceback (most recent call last):
  File "/tmpfs/src/github/python-bigquery-sqlalchemy/tests/system/test_alembic.py", line 154, in test_alembic_scenario
    op.alter_column("transactions", "amount", True)
  File "", line 8, in alter_column
TypeError: alter_column() takes 3 positional arguments but 4 were given

@shollyman
Copy link

new failure makes no sense to me. this is in prerelease but the test log doesn't implicate what deps we picked up, so we should include that output to debug this further.

@chalmerlowe chalmerlowe mentioned this issue May 30, 2023
Merged
@chalmerlowe
Copy link
Collaborator

@shollyman

Alembic made an upstream change to their function signatures.
My PR should fix this. Waiting on tests to pass.

@flaky-bot flaky-bot bot mentioned this issue Jan 10, 2024
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
api: bigquery Issues related to the googleapis/python-bigquery-sqlalchemy API. flakybot: flaky Tells the Flaky Bot not to close or comment on this issue. flakybot: issue An issue filed by the Flaky Bot. Should not be added manually. priority: p1 Important issue which blocks shipping the next release. Will be fixed prior to next release. type: bug Error or flaw in code with unintended results or allowing sub-optimal usage patterns.
Projects
None yet
Milestone
No milestone
2 participants
@shollyman @chalmerlowe