tests.system.test_sqlalchemy_bigquery: test_engine_with_dataset failed

[flaky-bot]

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

Test output

Traceback (most recent call last):
  File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/google/cloud/bigquery/dbapi/cursor.py", line 203, in _execute
    self._query_job.result()
  File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/google/cloud/bigquery/job/query.py", line 1371, in result
    do_get_result()
  File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/google/api_core/retry.py", line 286, in retry_wrapped_func
    return retry_target(
  File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/google/api_core/retry.py", line 189, in retry_target
    return target()
  File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/google/cloud/bigquery/job/query.py", line 1361, in do_get_result
    super(QueryJob, self).result(retry=retry, timeout=timeout)
  File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/google/cloud/bigquery/job/base.py", line 708, in result
    return super(_AsyncJob, self).result(timeout=timeout, **kwargs)
  File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/google/api_core/future/polling.py", line 135, in result
    raise self._exception
google.api_core.exceptions.BadRequest: 400 Duplicate column names in the result are not supported when a destination table is present. Found duplicate(s): record, name, age
(job ID: 57e2c578-9e07-4b36-9977-5eff97ed676f)
                                                                                                                                                                                                                                                                              -----Query Job SQL Follows-----                                                                                                                                                                                                                                                                                  

|    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |

1:SELECT sample_one_row.integer, sample_one_row.timestamp, sample_one_row.string, sample_one_row.float, sample_one_row.numeric, sample_one_row.boolean, sample_one_row.date, sample_one_row.datetime, sample_one_row.time, sample_one_row.bytes, sample_one_row.record, sample_one_row.record.name, sample_one_row.record.age, sample_one_row.nested_record, sample_one_row.nested_record.record, sample_one_row.nested_record.record.name, sample_one_row.nested_record.record.age, sample_one_row.array

2:FROM sample_one_row

|    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |
During handling of the above exception, another exception occurred:
Traceback (most recent call last):

File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context

self.dialect.do_execute(

File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute

cursor.execute(statement, parameters)

File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/google/cloud/bigquery/dbapi/_helpers.py", line 489, in with_closed_check

return method(self, *args, **kwargs)

File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/google/cloud/bigquery/dbapi/cursor.py", line 166, in execute

self._execute(

File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/google/cloud/bigquery/dbapi/cursor.py", line 205, in _execute

raise exceptions.DatabaseError(exc)

google.cloud.bigquery.dbapi.exceptions.DatabaseError: 400 Duplicate column names in the result are not supported when a destination table is present. Found duplicate(s): record, name, age
(job ID: 57e2c578-9e07-4b36-9977-5eff97ed676f)
                                                                                                                                                                                                                                                                              -----Query Job SQL Follows-----                                                                                                                                                                                                                                                                                  

|    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |

1:SELECT sample_one_row.integer, sample_one_row.timestamp, sample_one_row.string, sample_one_row.float, sample_one_row.numeric, sample_one_row.boolean, sample_one_row.date, sample_one_row.datetime, sample_one_row.time, sample_one_row.bytes, sample_one_row.record, sample_one_row.record.name, sample_one_row.record.age, sample_one_row.nested_record, sample_one_row.nested_record.record, sample_one_row.nested_record.record.name, sample_one_row.nested_record.record.age, sample_one_row.array

2:FROM sample_one_row

|    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |
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_sqlalchemy_bigquery.py", line 237, in test_engine_with_dataset

rows = table_one_row.select().execute().fetchall()

File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/sqlalchemy/sql/base.py", line 416, in execute

return e._execute_clauseelement(self, multiparams, params)

File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2242, in _execute_clauseelement

return connection._execute_clauseelement(elem, multiparams, params)

File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement

ret = self._execute_context(

File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context

self.handle_dbapi_exception(

File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in handle_dbapi_exception

util.raise(

File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise

raise exception

File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context

self.dialect.do_execute(

File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute

cursor.execute(statement, parameters)

File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/google/cloud/bigquery/dbapi/_helpers.py", line 489, in with_closed_check

return method(self, *args, **kwargs)

File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/google/cloud/bigquery/dbapi/cursor.py", line 166, in execute

self._execute(

File "/tmpfs/src/github/python-bigquery-sqlalchemy/.nox/system-3-8/lib/python3.8/site-packages/google/cloud/bigquery/dbapi/cursor.py", line 205, in _execute

raise exceptions.DatabaseError(exc)

sqlalchemy.exc.DatabaseError: (google.cloud.bigquery.dbapi.exceptions.DatabaseError) 400 Duplicate column names in the result are not supported when a destination table is present. Found duplicate(s): record, name, age
(job ID: 57e2c578-9e07-4b36-9977-5eff97ed676f)
                                                                                                                                                                                                                                                                              -----Query Job SQL Follows-----                                                                                                                                                                                                                                                                                  

|    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |

1:SELECT sample_one_row.integer, sample_one_row.timestamp, sample_one_row.string, sample_one_row.float, sample_one_row.numeric, sample_one_row.boolean, sample_one_row.date, sample_one_row.datetime, sample_one_row.time, sample_one_row.bytes, sample_one_row.record, sample_one_row.record.name, sample_one_row.record.age, sample_one_row.nested_record, sample_one_row.nested_record.record, sample_one_row.nested_record.record.name, sample_one_row.nested_record.record.age, sample_one_row.array

2:FROM sample_one_row

|    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |

[SQL: SELECT sample_one_row.integer, sample_one_row.timestamp, sample_one_row.string, sample_one_row.float, sample_one_row.numeric, sample_one_row.boolean, sample_one_row.date, sample_one_row.datetime, sample_one_row.time, sample_one_row.bytes, sample_one_row.record, sample_one_row.record.name, sample_one_row.record.age, sample_one_row.nested_record, sample_one_row.nested_record.record, sample_one_row.nested_record.record.name, sample_one_row.nested_record.record.age, sample_one_row.array

FROM sample_one_row]

(Background on this error at: http://sqlalche.me/e/13/4xp6)

[flaky-bot]

Looks like this issue is flaky. 😟

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

A human should fix and close this.

---

When run at the same commit (4553a38), this test passed in one build (Build Status, Sponge) and failed in another build (Build Status, Sponge).

[jimfulton]

Should be fixed by #228