#137265 Report by node IGSKACCGLT0044 covering 2060 tests from 34 modules resulted into 11 errors

Traceback (most recent call last):
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1546, in _fetch_index_rows
stmts = [
^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1547, in <listcomp>
sa.select([
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\_selectable_constructors.py", line 482, in select
return Select(*entities)
^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\selectable.py", line 5131, in __init__
self._raw_columns = [
^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\selectable.py", line 5132, in <listcomp>
coercions.expect(
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 396, in expect
resolved = impl._literal_coercion(
^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 634, in _literal_coercion
self._raise_for_expected(element, argname)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 1122, in _raise_for_expected
return super()._raise_for_expected(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 693, in _raise_for_expected
super()._raise_for_expected(
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 518, in _raise_for_expected
raise exc.ArgumentError(msg, code=code) from err
sqlalchemy.exc.ArgumentError: Column expression, FROM clause, or other columns clause element expected, got [<sqlalchemy.sql.elements.Label at 0x1ef3d5d2890; network>, <sqlalchemy.sql.elements.Label at 0x1ef3e225c90; station>, <sqlalchemy.sql.elements.Label at 0x1ef3e2a9990; location>, <sqlalchemy.sql.elements.Label at 0x1ef3e2169d0; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3ed79150; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3ed78fd0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1ef3d5d2890; network>, <sqlalchemy.sql.elements.Label at 0x1ef3e225c90; station>, <sqlalchemy.sql.elements.Label at 0x1ef3e2a9990; location>, <sqlalchemy.sql.elements.Label at 0x1ef3e2169d0; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3ed79150; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3ed78fd0; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 57, in testPartExecutor
yield
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 623, in run
self._callTestMethod(testMethod)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 579, in _callTestMethod
if method() is not None:
^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tests\test_tsindex.py", line 380, in test_get_availability
actual_avail = client.get_availability(
^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 415, in get_availability
tsindex_rows = self._get_tsindex_rows(network, station,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 679, in _get_tsindex_rows
return self.request_handler._fetch_index_rows(query_rows)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1668, in _fetch_index_rows
raise ValueError(str(err))
ValueError: Column expression, FROM clause, or other columns clause element expected, got [<sqlalchemy.sql.elements.Label at 0x1ef3d5d2890; network>, <sqlalchemy.sql.elements.Label at 0x1ef3e225c90; station>, <sqlalchemy.sql.elements.Label at 0x1ef3e2a9990; location>, <sqlalchemy.sql.elements.Label at 0x1ef3e2169d0; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3ed79150; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3ed78fd0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1ef3d5d2890; network>, <sqlalchemy.sql.elements.Label at 0x1ef3e225c90; station>, <sqlalchemy.sql.elements.Label at 0x1ef3e2a9990; location>, <sqlalchemy.sql.elements.Label at 0x1ef3e2169d0; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3ed79150; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3ed78fd0; endtime>)?

Traceback (most recent call last):
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1726, in _fetch_summary_rows
stmts = [
^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1727, in <listcomp>
sa.select([
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\_selectable_constructors.py", line 482, in select
return Select(*entities)
^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\selectable.py", line 5131, in __init__
self._raw_columns = [
^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\selectable.py", line 5132, in <listcomp>
coercions.expect(
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 396, in expect
resolved = impl._literal_coercion(
^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 634, in _literal_coercion
self._raise_for_expected(element, argname)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 1122, in _raise_for_expected
return super()._raise_for_expected(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 693, in _raise_for_expected
super()._raise_for_expected(
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 518, in _raise_for_expected
raise exc.ArgumentError(msg, code=code) from err
sqlalchemy.exc.ArgumentError: Column expression, FROM clause, or other columns clause element expected, got [<sqlalchemy.sql.elements.Label at 0x1ef19556210; network>, <sqlalchemy.sql.elements.Label at 0x1ef3e04e790; station>, <sqlalchemy.sql.elements.Label at 0x1ef3e2caf10; location>, <sqlalchemy.sql.elements.Label at 0x1ef3e2c2650; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3e283fd0; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3e096610; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1ef19556210; network>, <sqlalchemy.sql.elements.Label at 0x1ef3e04e790; station>, <sqlalchemy.sql.elements.Label at 0x1ef3e2caf10; location>, <sqlalchemy.sql.elements.Label at 0x1ef3e2c2650; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3e283fd0; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3e096610; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 57, in testPartExecutor
yield
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 623, in run
self._callTestMethod(testMethod)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 579, in _callTestMethod
if method() is not None:
^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tests\test_tsindex.py", line 235, in test_get_availability_extent
actual_avail_extents = client.get_availability_extent(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 358, in get_availability_extent
summary_rows = self._get_summary_rows(network, station,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 597, in _get_summary_rows
return self.request_handler._fetch_summary_rows(query_rows)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1744, in _fetch_summary_rows
raise ValueError(str(err))
ValueError: Column expression, FROM clause, or other columns clause element expected, got [<sqlalchemy.sql.elements.Label at 0x1ef19556210; network>, <sqlalchemy.sql.elements.Label at 0x1ef3e04e790; station>, <sqlalchemy.sql.elements.Label at 0x1ef3e2caf10; location>, <sqlalchemy.sql.elements.Label at 0x1ef3e2c2650; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3e283fd0; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3e096610; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1ef19556210; network>, <sqlalchemy.sql.elements.Label at 0x1ef3e04e790; station>, <sqlalchemy.sql.elements.Label at 0x1ef3e2caf10; location>, <sqlalchemy.sql.elements.Label at 0x1ef3e2c2650; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3e283fd0; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3e096610; endtime>)?

Traceback (most recent call last):
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1726, in _fetch_summary_rows
stmts = [
^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1727, in <listcomp>
sa.select([
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\_selectable_constructors.py", line 482, in select
return Select(*entities)
^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\selectable.py", line 5131, in __init__
self._raw_columns = [
^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\selectable.py", line 5132, in <listcomp>
coercions.expect(
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 396, in expect
resolved = impl._literal_coercion(
^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 634, in _literal_coercion
self._raise_for_expected(element, argname)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 1122, in _raise_for_expected
return super()._raise_for_expected(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 693, in _raise_for_expected
super()._raise_for_expected(
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 518, in _raise_for_expected
raise exc.ArgumentError(msg, code=code) from err
sqlalchemy.exc.ArgumentError: Column expression, FROM clause, or other columns clause element expected, got [<sqlalchemy.sql.elements.Label at 0x1ef3f8ba810; network>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba650; station>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba5d0; location>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba550; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba4d0; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba450; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1ef3f8ba810; network>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba650; station>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba5d0; location>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba550; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba4d0; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba450; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 57, in testPartExecutor
yield
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 623, in run
self._callTestMethod(testMethod)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 579, in _callTestMethod
if method() is not None:
^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tests\test_tsindex.py", line 174, in test_get_nslc
actual_nslc = client.get_nslc("I*,CU",
^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 317, in get_nslc
summary_rows = self._get_summary_rows(network, station, location,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 597, in _get_summary_rows
return self.request_handler._fetch_summary_rows(query_rows)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1744, in _fetch_summary_rows
raise ValueError(str(err))
ValueError: Column expression, FROM clause, or other columns clause element expected, got [<sqlalchemy.sql.elements.Label at 0x1ef3f8ba810; network>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba650; station>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba5d0; location>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba550; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba4d0; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba450; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1ef3f8ba810; network>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba650; station>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba5d0; location>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba550; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba4d0; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba450; endtime>)?

Traceback (most recent call last):
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1546, in _fetch_index_rows
stmts = [
^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1547, in <listcomp>
sa.select([
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\_selectable_constructors.py", line 482, in select
return Select(*entities)
^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\selectable.py", line 5131, in __init__
self._raw_columns = [
^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\selectable.py", line 5132, in <listcomp>
coercions.expect(
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 396, in expect
resolved = impl._literal_coercion(
^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 634, in _literal_coercion
self._raise_for_expected(element, argname)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 1122, in _raise_for_expected
return super()._raise_for_expected(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 693, in _raise_for_expected
super()._raise_for_expected(
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 518, in _raise_for_expected
raise exc.ArgumentError(msg, code=code) from err
sqlalchemy.exc.ArgumentError: Column expression, FROM clause, or other columns clause element expected, got [<sqlalchemy.sql.elements.Label at 0x1ef3dcbff50; network>, <sqlalchemy.sql.elements.Label at 0x1ef3e1c87d0; station>, <sqlalchemy.sql.elements.Label at 0x1ef3e2cac10; location>, <sqlalchemy.sql.elements.Label at 0x1ef3e225e10; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3e2bfb10; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3e2bea90; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1ef3dcbff50; network>, <sqlalchemy.sql.elements.Label at 0x1ef3e1c87d0; station>, <sqlalchemy.sql.elements.Label at 0x1ef3e2cac10; location>, <sqlalchemy.sql.elements.Label at 0x1ef3e225e10; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3e2bfb10; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3e2bea90; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 57, in testPartExecutor
yield
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 623, in run
self._callTestMethod(testMethod)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 579, in _callTestMethod
if method() is not None:
^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tests\test_tsindex.py", line 61, in test_get_waveforms
returned_stream = client.get_waveforms(
^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 262, in get_waveforms
return self._get_waveforms(query_rows, merge)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 623, in _get_waveforms
index_rows = self.request_handler._fetch_index_rows(query_rows)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1668, in _fetch_index_rows
raise ValueError(str(err))
ValueError: Column expression, FROM clause, or other columns clause element expected, got [<sqlalchemy.sql.elements.Label at 0x1ef3dcbff50; network>, <sqlalchemy.sql.elements.Label at 0x1ef3e1c87d0; station>, <sqlalchemy.sql.elements.Label at 0x1ef3e2cac10; location>, <sqlalchemy.sql.elements.Label at 0x1ef3e225e10; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3e2bfb10; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3e2bea90; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1ef3dcbff50; network>, <sqlalchemy.sql.elements.Label at 0x1ef3e1c87d0; station>, <sqlalchemy.sql.elements.Label at 0x1ef3e2cac10; location>, <sqlalchemy.sql.elements.Label at 0x1ef3e225e10; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3e2bfb10; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3e2bea90; endtime>)?

Traceback (most recent call last):
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1546, in _fetch_index_rows
stmts = [
^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1547, in <listcomp>
sa.select([
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\_selectable_constructors.py", line 482, in select
return Select(*entities)
^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\selectable.py", line 5131, in __init__
self._raw_columns = [
^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\selectable.py", line 5132, in <listcomp>
coercions.expect(
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 396, in expect
resolved = impl._literal_coercion(
^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 634, in _literal_coercion
self._raise_for_expected(element, argname)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 1122, in _raise_for_expected
return super()._raise_for_expected(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 693, in _raise_for_expected
super()._raise_for_expected(
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 518, in _raise_for_expected
raise exc.ArgumentError(msg, code=code) from err
sqlalchemy.exc.ArgumentError: Column expression, FROM clause, or other columns clause element expected, got [<sqlalchemy.sql.elements.Label at 0x1ef3f8bbbd0; network>, <sqlalchemy.sql.elements.Label at 0x1ef3dfeb490; station>, <sqlalchemy.sql.elements.Label at 0x1ef3f8a3050; location>, <sqlalchemy.sql.elements.Label at 0x1ef3f8a2d10; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3ed1bc10; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3ed1bbd0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1ef3f8bbbd0; network>, <sqlalchemy.sql.elements.Label at 0x1ef3dfeb490; station>, <sqlalchemy.sql.elements.Label at 0x1ef3f8a3050; location>, <sqlalchemy.sql.elements.Label at 0x1ef3f8a2d10; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3ed1bc10; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3ed1bbd0; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 57, in testPartExecutor
yield
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 623, in run
self._callTestMethod(testMethod)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 579, in _callTestMethod
if method() is not None:
^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tests\test_tsindex.py", line 141, in test_get_waveforms_bulk
returned_stream = client.get_waveforms_bulk(bulk_request)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 288, in get_waveforms_bulk
return self._get_waveforms(query_rows, merge)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 623, in _get_waveforms
index_rows = self.request_handler._fetch_index_rows(query_rows)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1668, in _fetch_index_rows
raise ValueError(str(err))
ValueError: Column expression, FROM clause, or other columns clause element expected, got [<sqlalchemy.sql.elements.Label at 0x1ef3f8bbbd0; network>, <sqlalchemy.sql.elements.Label at 0x1ef3dfeb490; station>, <sqlalchemy.sql.elements.Label at 0x1ef3f8a3050; location>, <sqlalchemy.sql.elements.Label at 0x1ef3f8a2d10; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3ed1bc10; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3ed1bbd0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1ef3f8bbbd0; network>, <sqlalchemy.sql.elements.Label at 0x1ef3dfeb490; station>, <sqlalchemy.sql.elements.Label at 0x1ef3f8a3050; location>, <sqlalchemy.sql.elements.Label at 0x1ef3f8a2d10; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3ed1bc10; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3ed1bbd0; endtime>)?

Traceback (most recent call last):
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1546, in _fetch_index_rows
stmts = [
^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1547, in <listcomp>
sa.select([
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\_selectable_constructors.py", line 482, in select
return Select(*entities)
^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\selectable.py", line 5131, in __init__
self._raw_columns = [
^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\selectable.py", line 5132, in <listcomp>
coercions.expect(
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 396, in expect
resolved = impl._literal_coercion(
^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 634, in _literal_coercion
self._raise_for_expected(element, argname)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 1122, in _raise_for_expected
return super()._raise_for_expected(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 693, in _raise_for_expected
super()._raise_for_expected(
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 518, in _raise_for_expected
raise exc.ArgumentError(msg, code=code) from err
sqlalchemy.exc.ArgumentError: Column expression, FROM clause, or other columns clause element expected, got [<sqlalchemy.sql.elements.Label at 0x1ef3d637e10; network>, <sqlalchemy.sql.elements.Label at 0x1ef3e24b210; station>, <sqlalchemy.sql.elements.Label at 0x1ef3f8cabd0; location>, <sqlalchemy.sql.elements.Label at 0x1ef3f8cac10; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3f8cab10; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3f8cab90; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1ef3d637e10; network>, <sqlalchemy.sql.elements.Label at 0x1ef3e24b210; station>, <sqlalchemy.sql.elements.Label at 0x1ef3f8cabd0; location>, <sqlalchemy.sql.elements.Label at 0x1ef3f8cac10; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3f8cab10; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3f8cab90; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 57, in testPartExecutor
yield
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 623, in run
self._callTestMethod(testMethod)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 579, in _callTestMethod
if method() is not None:
^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tests\test_tsindex.py", line 580, in test_has_data
self.assertTrue(client.has_data())
^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 558, in has_data
avail_percentage = self.get_availability_percentage(network,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 494, in get_availability_percentage
avail = self.get_availability(network, station,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 415, in get_availability
tsindex_rows = self._get_tsindex_rows(network, station,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 679, in _get_tsindex_rows
return self.request_handler._fetch_index_rows(query_rows)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1668, in _fetch_index_rows
raise ValueError(str(err))
ValueError: Column expression, FROM clause, or other columns clause element expected, got [<sqlalchemy.sql.elements.Label at 0x1ef3d637e10; network>, <sqlalchemy.sql.elements.Label at 0x1ef3e24b210; station>, <sqlalchemy.sql.elements.Label at 0x1ef3f8cabd0; location>, <sqlalchemy.sql.elements.Label at 0x1ef3f8cac10; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3f8cab10; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3f8cab90; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1ef3d637e10; network>, <sqlalchemy.sql.elements.Label at 0x1ef3e24b210; station>, <sqlalchemy.sql.elements.Label at 0x1ef3f8cabd0; location>, <sqlalchemy.sql.elements.Label at 0x1ef3f8cac10; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3f8cab10; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3f8cab90; endtime>)?

Traceback (most recent call last):
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1546, in _fetch_index_rows
stmts = [
^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1547, in <listcomp>
sa.select([
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\_selectable_constructors.py", line 482, in select
return Select(*entities)
^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\selectable.py", line 5131, in __init__
self._raw_columns = [
^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\selectable.py", line 5132, in <listcomp>
coercions.expect(
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 396, in expect
resolved = impl._literal_coercion(
^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 634, in _literal_coercion
self._raise_for_expected(element, argname)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 1122, in _raise_for_expected
return super()._raise_for_expected(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 693, in _raise_for_expected
super()._raise_for_expected(
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 518, in _raise_for_expected
raise exc.ArgumentError(msg, code=code) from err
sqlalchemy.exc.ArgumentError: Column expression, FROM clause, or other columns clause element expected, got [<sqlalchemy.sql.elements.Label at 0x1ef3e2af7d0; network>, <sqlalchemy.sql.elements.Label at 0x1ef3f8a2550; station>, <sqlalchemy.sql.elements.Label at 0x1ef3dd53250; location>, <sqlalchemy.sql.elements.Label at 0x1ef3df95b10; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3e2ca010; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba210; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1ef3e2af7d0; network>, <sqlalchemy.sql.elements.Label at 0x1ef3f8a2550; station>, <sqlalchemy.sql.elements.Label at 0x1ef3dd53250; location>, <sqlalchemy.sql.elements.Label at 0x1ef3df95b10; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3e2ca010; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba210; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 57, in testPartExecutor
yield
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 623, in run
self._callTestMethod(testMethod)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 579, in _callTestMethod
if method() is not None:
^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tests\test_tsindex.py", line 773, in test_build_file_list
self.assertRaisesRegex(OSError,
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 1318, in assertRaisesRegex
return context.handle('assertRaisesRegex', args, kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 237, in handle
callable_obj(*args, **kwargs)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1064, in build_file_list
tsindex = self.request_handler._fetch_index_rows()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1668, in _fetch_index_rows
raise ValueError(str(err))
ValueError: Column expression, FROM clause, or other columns clause element expected, got [<sqlalchemy.sql.elements.Label at 0x1ef3e2af7d0; network>, <sqlalchemy.sql.elements.Label at 0x1ef3f8a2550; station>, <sqlalchemy.sql.elements.Label at 0x1ef3dd53250; location>, <sqlalchemy.sql.elements.Label at 0x1ef3df95b10; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3e2ca010; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba210; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1ef3e2af7d0; network>, <sqlalchemy.sql.elements.Label at 0x1ef3f8a2550; station>, <sqlalchemy.sql.elements.Label at 0x1ef3dd53250; location>, <sqlalchemy.sql.elements.Label at 0x1ef3df95b10; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3e2ca010; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3f8ba210; endtime>)?

Traceback (most recent call last):
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1726, in _fetch_summary_rows
stmts = [
^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1727, in <listcomp>
sa.select([
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\_selectable_constructors.py", line 482, in select
return Select(*entities)
^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\selectable.py", line 5131, in __init__
self._raw_columns = [
^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\selectable.py", line 5132, in <listcomp>
coercions.expect(
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 396, in expect
resolved = impl._literal_coercion(
^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 634, in _literal_coercion
self._raise_for_expected(element, argname)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 1122, in _raise_for_expected
return super()._raise_for_expected(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 693, in _raise_for_expected
super()._raise_for_expected(
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 518, in _raise_for_expected
raise exc.ArgumentError(msg, code=code) from err
sqlalchemy.exc.ArgumentError: Column expression, FROM clause, or other columns clause element expected, got [<sqlalchemy.sql.elements.Label at 0x1ef3dbf6390; network>, <sqlalchemy.sql.elements.Label at 0x1ef3ed78c90; station>, <sqlalchemy.sql.elements.Label at 0x1ef3f8bb910; location>, <sqlalchemy.sql.elements.Label at 0x1ef3f8bbe50; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3f8baad0; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3e2c8090; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1ef3dbf6390; network>, <sqlalchemy.sql.elements.Label at 0x1ef3ed78c90; station>, <sqlalchemy.sql.elements.Label at 0x1ef3f8bb910; location>, <sqlalchemy.sql.elements.Label at 0x1ef3f8bbe50; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3f8baad0; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3e2c8090; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 57, in testPartExecutor
yield
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 623, in run
self._callTestMethod(testMethod)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\unittest\case.py", line 579, in _callTestMethod
if method() is not None:
^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tests\test_tsindex.py", line 919, in test__fetch_summary_rows
ts_summary_data = request_handler._fetch_summary_rows(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1744, in _fetch_summary_rows
raise ValueError(str(err))
ValueError: Column expression, FROM clause, or other columns clause element expected, got [<sqlalchemy.sql.elements.Label at 0x1ef3dbf6390; network>, <sqlalchemy.sql.elements.Label at 0x1ef3ed78c90; station>, <sqlalchemy.sql.elements.Label at 0x1ef3f8bb910; location>, <sqlalchemy.sql.elements.Label at 0x1ef3f8bbe50; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3f8baad0; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3e2c8090; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1ef3dbf6390; network>, <sqlalchemy.sql.elements.Label at 0x1ef3ed78c90; station>, <sqlalchemy.sql.elements.Label at 0x1ef3f8bb910; location>, <sqlalchemy.sql.elements.Label at 0x1ef3f8bbe50; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3f8baad0; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3e2c8090; endtime>)?

055 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
056
057 * :meth:`~Client.get_availability_extent()`:
058 Returns a list of (network, station, location, channel, earliest, latest)
059 tuples that represent the full extent of available data. This example
060 retrieves from the very small obspy test tsindex database a list of all
061 available ("BHZ") channel extents from the Global Seismograph Network
062 ("IU") for all times.
063
064 >>> extents = client.get_availability_extent(network="IU", channel="BHZ")
UNEXPECTED EXCEPTION: ValueError('Column expression, FROM clause, or other columns clause element expected, got [<sqlalchemy.sql.elements.Label at 0x1ef3c526450; network>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fcc10; station>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fcf10; location>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fcfd0; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fd0d0; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fd150; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1ef3c526450; network>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fcc10; station>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fcf10; location>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fcfd0; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fd0d0; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fd150; endtime>)?')
Traceback (most recent call last):
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1726, in _fetch_summary_rows
stmts = [
^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1727, in <listcomp>
sa.select([
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\_selectable_constructors.py", line 482, in select
return Select(*entities)
^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\selectable.py", line 5131, in __init__
self._raw_columns = [
^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\selectable.py", line 5132, in <listcomp>
coercions.expect(
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 396, in expect
resolved = impl._literal_coercion(
^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 634, in _literal_coercion
self._raise_for_expected(element, argname)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 1122, in _raise_for_expected
return super()._raise_for_expected(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 693, in _raise_for_expected
super()._raise_for_expected(
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\sqlalchemy\sql\coercions.py", line 518, in _raise_for_expected
raise exc.ArgumentError(msg, code=code) from err
sqlalchemy.exc.ArgumentError: Column expression, FROM clause, or other columns clause element expected, got [<sqlalchemy.sql.elements.Label at 0x1ef3c526450; network>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fcc10; station>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fcf10; location>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fcfd0; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fd0d0; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fd150; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1ef3c526450; network>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fcc10; station>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fcf10; location>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fcfd0; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fd0d0; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fd150; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\doctest.py", line 1355, in __run
exec(compile(example.source, filename, "single",
File "<doctest obspy.clients.filesystem.tsindex[6]>", line 1, in <module>
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 358, in get_availability_extent
summary_rows = self._get_summary_rows(network, station,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 597, in _get_summary_rows
return self.request_handler._fetch_summary_rows(query_rows)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py", line 1744, in _fetch_summary_rows
raise ValueError(str(err))
ValueError: Column expression, FROM clause, or other columns clause element expected, got [<sqlalchemy.sql.elements.Label at 0x1ef3c526450; network>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fcc10; station>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fcf10; location>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fcfd0; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fd0d0; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fd150; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1ef3c526450; network>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fcc10; station>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fcf10; location>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fcfd0; channel>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fd0d0; starttime>, <sqlalchemy.sql.elements.Label at 0x1ef3f8fd150; endtime>)?
C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\clients\filesystem\tsindex.py:64: UnexpectedException

Traceback (most recent call last):
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\runner.py", line 346, in from_call
result: Optional[TResult] = func()
^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\runner.py", line 267, in <lambda>
lambda: ihook(item=item, **kwds), when=when, reraise=reraise
^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_hooks.py", line 501, in __call__
return self._hookexec(self.name, self._hookimpls.copy(), kwargs, firstresult)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_manager.py", line 119, in _hookexec
return self._inner_hookexec(hook_name, methods, kwargs, firstresult)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_callers.py", line 181, in _multicall
return outcome.get_result()
^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_result.py", line 99, in get_result
raise exc.with_traceback(exc.__traceback__)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_callers.py", line 166, in _multicall
teardown.throw(outcome._exception)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\threadexception.py", line 87, in pytest_runtest_call
yield from thread_exception_runtest_hook()
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\threadexception.py", line 63, in thread_exception_runtest_hook
yield
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_callers.py", line 166, in _multicall
teardown.throw(outcome._exception)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\unraisableexception.py", line 90, in pytest_runtest_call
yield from unraisable_exception_runtest_hook()
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\unraisableexception.py", line 65, in unraisable_exception_runtest_hook
yield
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_callers.py", line 166, in _multicall
teardown.throw(outcome._exception)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\logging.py", line 839, in pytest_runtest_call
yield from self._runtest_for(item, "call")
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\logging.py", line 822, in _runtest_for
yield
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_callers.py", line 166, in _multicall
teardown.throw(outcome._exception)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\capture.py", line 882, in pytest_runtest_call
return (yield)
^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_callers.py", line 166, in _multicall
teardown.throw(outcome._exception)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\skipping.py", line 256, in pytest_runtest_call
return (yield)
^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_callers.py", line 102, in _multicall
res = hook_impl.function(*args)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\runner.py", line 182, in pytest_runtest_call
raise e
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\runner.py", line 174, in pytest_runtest_call
item.runtest()
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\python.py", line 1831, in runtest
self.ihook.pytest_pyfunc_call(pyfuncitem=self)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_hooks.py", line 501, in __call__
return self._hookexec(self.name, self._hookimpls.copy(), kwargs, firstresult)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_manager.py", line 119, in _hookexec
return self._inner_hookexec(hook_name, methods, kwargs, firstresult)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_callers.py", line 138, in _multicall
raise exception.with_traceback(exception.__traceback__)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_callers.py", line 102, in _multicall
res = hook_impl.function(*args)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\python.py", line 194, in pytest_pyfunc_call
result = testfunction(**testargs)
^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\core\tests\test_trace.py", line 1360, in test_taper_onesided
assert len(w) == 1
AssertionError: assert 2 == 1
+ where 2 = len([<warnings.WarningMessage object at 0x000001EF3F9F3AD0>, <warnings.WarningMessage object at 0x000001EF4168E310>])

Traceback (most recent call last):
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\runner.py", line 346, in from_call
result: Optional[TResult] = func()
^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\runner.py", line 267, in <lambda>
lambda: ihook(item=item, **kwds), when=when, reraise=reraise
^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_hooks.py", line 501, in __call__
return self._hookexec(self.name, self._hookimpls.copy(), kwargs, firstresult)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_manager.py", line 119, in _hookexec
return self._inner_hookexec(hook_name, methods, kwargs, firstresult)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_callers.py", line 181, in _multicall
return outcome.get_result()
^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_result.py", line 99, in get_result
raise exc.with_traceback(exc.__traceback__)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_callers.py", line 166, in _multicall
teardown.throw(outcome._exception)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\threadexception.py", line 87, in pytest_runtest_call
yield from thread_exception_runtest_hook()
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\threadexception.py", line 63, in thread_exception_runtest_hook
yield
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_callers.py", line 166, in _multicall
teardown.throw(outcome._exception)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\unraisableexception.py", line 90, in pytest_runtest_call
yield from unraisable_exception_runtest_hook()
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\unraisableexception.py", line 65, in unraisable_exception_runtest_hook
yield
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_callers.py", line 166, in _multicall
teardown.throw(outcome._exception)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\logging.py", line 839, in pytest_runtest_call
yield from self._runtest_for(item, "call")
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\logging.py", line 822, in _runtest_for
yield
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_callers.py", line 166, in _multicall
teardown.throw(outcome._exception)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\capture.py", line 882, in pytest_runtest_call
return (yield)
^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_callers.py", line 166, in _multicall
teardown.throw(outcome._exception)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\skipping.py", line 256, in pytest_runtest_call
return (yield)
^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_callers.py", line 102, in _multicall
res = hook_impl.function(*args)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\runner.py", line 182, in pytest_runtest_call
raise e
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\runner.py", line 174, in pytest_runtest_call
item.runtest()
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\python.py", line 1831, in runtest
self.ihook.pytest_pyfunc_call(pyfuncitem=self)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_hooks.py", line 501, in __call__
return self._hookexec(self.name, self._hookimpls.copy(), kwargs, firstresult)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_manager.py", line 119, in _hookexec
return self._inner_hookexec(hook_name, methods, kwargs, firstresult)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_callers.py", line 138, in _multicall
raise exception.with_traceback(exception.__traceback__)
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\pluggy\_callers.py", line 102, in _multicall
res = hook_impl.function(*args)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\_pytest\python.py", line 194, in pytest_pyfunc_call
result = testfunction(**testargs)
^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\dpeterson\anaconda3\envs\msnoise\Lib\site-packages\obspy\core\tests\test_trace.py", line 1390, in test_taper_length
assert len(w) == 1
AssertionError: assert 2 == 1
+ where 2 = len([<warnings.WarningMessage object at 0x000001EF41332DD0>, <warnings.WarningMessage object at 0x000001EF417EF650>])