Skip to content

tests.sqlalchemy_dialect_compliance.test_dialect_compliance.BinaryTest_bigquery+bigquery: test_pickle_roundtrip failed #548

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.

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

Closed
flaky-bot bot opened this issue Jan 18, 2023 · 1 comment
Labels
api: bigquery Issues related to the googleapis/python-bigquery-sqlalchemy API. 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 Jan 18, 2023

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: 7aa6696
buildURL: Build Status, Sponge
status: failed

Test output
Traceback (most recent call last):
  File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/compliance/lib/python3.11/site-packages/geoalchemy2/__init__.py", line 31, in _select_dialect
    return known_dialects[dialect_name]
           ~~~~~~~~~~~~~~^^^^^^^^^^^^^^
KeyError: 'bigquery'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/compliance/lib/python3.11/site-packages/sqlalchemy/testing/fixtures.py", line 401, in _setup_tables_test_class
cls._setup_once_tables()
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/compliance/lib/python3.11/site-packages/sqlalchemy/testing/fixtures.py", line 448, in _setup_once_tables
cls._tables_metadata.create_all(cls.bind)
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/compliance/lib/python3.11/site-packages/sqlalchemy/sql/schema.py", line 4930, in create_all
bind._run_ddl_visitor(
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/compliance/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 3228, in _run_ddl_visitor
conn._run_ddl_visitor(visitorcallable, element, **kwargs)
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/compliance/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2211, in _run_ddl_visitor
visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/compliance/lib/python3.11/site-packages/sqlalchemy/sql/visitors.py", line 524, in traverse_single
return meth(obj, **kw)
^^^^^^^^^^^^^^^
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/compliance/lib/python3.11/site-packages/sqlalchemy/sql/ddl.py", line 851, in visit_metadata
self.traverse_single(
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/compliance/lib/python3.11/site-packages/sqlalchemy/sql/visitors.py", line 524, in traverse_single
return meth(obj, **kw)
^^^^^^^^^^^^^^^
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/compliance/lib/python3.11/site-packages/sqlalchemy/sql/ddl.py", line 879, in visit_table
table.dispatch.before_create(
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/compliance/lib/python3.11/site-packages/sqlalchemy/event/attr.py", line 247, in call
fn(*args, **kw)
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/compliance/lib/python3.11/site-packages/geoalchemy2/init.py", line 42, in before_create
_select_dialect(bind.dialect.name).before_create(table, bind, **kw)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/compliance/lib/python3.11/site-packages/geoalchemy2/init.py", line 33, in _select_dialect
raise ValueError(
ValueError: The dialect 'bigquery' is unknown, please choose one of dict_keys(['postgresql', 'sqlite'])

@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 Jan 18, 2023
@product-auto-label product-auto-label bot added the api: bigquery Issues related to the googleapis/python-bigquery-sqlalchemy API. label Jan 18, 2023
@flaky-bot
Copy link
Author

flaky-bot bot commented Jan 30, 2023

Test passed for commit 0675b1e (Build Status, Sponge)! Closing this issue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
api: bigquery Issues related to the googleapis/python-bigquery-sqlalchemy API. 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
Development

No branches or pull requests

0 participants