#154287 Report by node edge4 covering 2022 tests from 60 modules resulted into 9 errors

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 0x71b5412b2bd0; network>, <sqlalchemy.sql.elements.Label at 0x71b5412c8450; station>, <sqlalchemy.sql.elements.Label at 0x71b5412c8550; location>, <sqlalchemy.sql.elements.Label at 0x71b5412c85d0; channel>, <sqlalchemy.sql.elements.Label at 0x71b5412c8650; starttime>, <sqlalchemy.sql.elements.Label at 0x71b5412c86d0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x71b5412b2bd0; network>, <sqlalchemy.sql.elements.Label at 0x71b5412c8450; station>, <sqlalchemy.sql.elements.Label at 0x71b5412c8550; location>, <sqlalchemy.sql.elements.Label at 0x71b5412c85d0; channel>, <sqlalchemy.sql.elements.Label at 0x71b5412c8650; starttime>, <sqlalchemy.sql.elements.Label at 0x71b5412c86d0; endtime>)?')
Traceback (most recent call last):
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 1739, in _fetch_summary_rows
for idx, (a, b, c, d, e, f) in enumerate(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 1739, in <listcomp>
for idx, (a, b, c, d, e, f) in enumerate(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 538, in select
return Select(*entities)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5407, in __init__
for ent in entities
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5407, in <listcomp>
for ent in entities
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 397, in expect
element, argname=argname, **kw
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 635, in _literal_coercion
self._raise_for_expected(element, argname)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 1134, in _raise_for_expected
element, argname=argname, resolved=resolved, advice=advice, **kw
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 703, in _raise_for_expected
**kw,
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 519, 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 0x71b5412b2bd0; network>, <sqlalchemy.sql.elements.Label at 0x71b5412c8450; station>, <sqlalchemy.sql.elements.Label at 0x71b5412c8550; location>, <sqlalchemy.sql.elements.Label at 0x71b5412c85d0; channel>, <sqlalchemy.sql.elements.Label at 0x71b5412c8650; starttime>, <sqlalchemy.sql.elements.Label at 0x71b5412c86d0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x71b5412b2bd0; network>, <sqlalchemy.sql.elements.Label at 0x71b5412c8450; station>, <sqlalchemy.sql.elements.Label at 0x71b5412c8550; location>, <sqlalchemy.sql.elements.Label at 0x71b5412c85d0; channel>, <sqlalchemy.sql.elements.Label at 0x71b5412c8650; starttime>, <sqlalchemy.sql.elements.Label at 0x71b5412c86d0; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/doctest.py", line 1337, in __run
compileflags, 1), test.globs)
File "<doctest obspy.clients.filesystem.tsindex[6]>", line 1, in <module>
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 360, in get_availability_extent
starttime, endtime)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 597, in _get_summary_rows
return self.request_handler._fetch_summary_rows(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/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 0x71b5412b2bd0; network>, <sqlalchemy.sql.elements.Label at 0x71b5412c8450; station>, <sqlalchemy.sql.elements.Label at 0x71b5412c8550; location>, <sqlalchemy.sql.elements.Label at 0x71b5412c85d0; channel>, <sqlalchemy.sql.elements.Label at 0x71b5412c8650; starttime>, <sqlalchemy.sql.elements.Label at 0x71b5412c86d0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x71b5412b2bd0; network>, <sqlalchemy.sql.elements.Label at 0x71b5412c8450; station>, <sqlalchemy.sql.elements.Label at 0x71b5412c8550; location>, <sqlalchemy.sql.elements.Label at 0x71b5412c85d0; channel>, <sqlalchemy.sql.elements.Label at 0x71b5412c8650; starttime>, <sqlalchemy.sql.elements.Label at 0x71b5412c86d0; endtime>)?
/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py:64: UnexpectedException

Traceback (most recent call last):
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 1559, in _fetch_index_rows
for idx, (a, b, c, d, e, f) in enumerate(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 1559, in <listcomp>
for idx, (a, b, c, d, e, f) in enumerate(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 538, in select
return Select(*entities)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5407, in __init__
for ent in entities
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5407, in <listcomp>
for ent in entities
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 397, in expect
element, argname=argname, **kw
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 635, in _literal_coercion
self._raise_for_expected(element, argname)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 1134, in _raise_for_expected
element, argname=argname, resolved=resolved, advice=advice, **kw
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 703, in _raise_for_expected
**kw,
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 519, 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 0x71b53bea0c90; network>, <sqlalchemy.sql.elements.Label at 0x71b53bea0f50; station>, <sqlalchemy.sql.elements.Label at 0x71b53bea0a50; location>, <sqlalchemy.sql.elements.Label at 0x71b53bea0250; channel>, <sqlalchemy.sql.elements.Label at 0x71b53bea0410; starttime>, <sqlalchemy.sql.elements.Label at 0x71b53bea0dd0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x71b53bea0c90; network>, <sqlalchemy.sql.elements.Label at 0x71b53bea0f50; station>, <sqlalchemy.sql.elements.Label at 0x71b53bea0a50; location>, <sqlalchemy.sql.elements.Label at 0x71b53bea0250; channel>, <sqlalchemy.sql.elements.Label at 0x71b53bea0410; starttime>, <sqlalchemy.sql.elements.Label at 0x71b53bea0dd0; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/unittest/case.py", line 59, in testPartExecutor
yield
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/unittest/case.py", line 628, in run
testMethod()
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 387, in test_get_availability
"2018-12-31")
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 417, in get_availability
starttime, endtime)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 679, in _get_tsindex_rows
return self.request_handler._fetch_index_rows(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/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 0x71b53bea0c90; network>, <sqlalchemy.sql.elements.Label at 0x71b53bea0f50; station>, <sqlalchemy.sql.elements.Label at 0x71b53bea0a50; location>, <sqlalchemy.sql.elements.Label at 0x71b53bea0250; channel>, <sqlalchemy.sql.elements.Label at 0x71b53bea0410; starttime>, <sqlalchemy.sql.elements.Label at 0x71b53bea0dd0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x71b53bea0c90; network>, <sqlalchemy.sql.elements.Label at 0x71b53bea0f50; station>, <sqlalchemy.sql.elements.Label at 0x71b53bea0a50; location>, <sqlalchemy.sql.elements.Label at 0x71b53bea0250; channel>, <sqlalchemy.sql.elements.Label at 0x71b53bea0410; starttime>, <sqlalchemy.sql.elements.Label at 0x71b53bea0dd0; endtime>)?

Traceback (most recent call last):
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 1739, in _fetch_summary_rows
for idx, (a, b, c, d, e, f) in enumerate(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 1739, in <listcomp>
for idx, (a, b, c, d, e, f) in enumerate(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 538, in select
return Select(*entities)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5407, in __init__
for ent in entities
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5407, in <listcomp>
for ent in entities
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 397, in expect
element, argname=argname, **kw
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 635, in _literal_coercion
self._raise_for_expected(element, argname)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 1134, in _raise_for_expected
element, argname=argname, resolved=resolved, advice=advice, **kw
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 703, in _raise_for_expected
**kw,
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 519, 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 0x71b53beaba50; network>, <sqlalchemy.sql.elements.Label at 0x71b53beabe90; station>, <sqlalchemy.sql.elements.Label at 0x71b53beab290; location>, <sqlalchemy.sql.elements.Label at 0x71b53beab690; channel>, <sqlalchemy.sql.elements.Label at 0x71b53beab5d0; starttime>, <sqlalchemy.sql.elements.Label at 0x71b53beabb50; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x71b53beaba50; network>, <sqlalchemy.sql.elements.Label at 0x71b53beabe90; station>, <sqlalchemy.sql.elements.Label at 0x71b53beab290; location>, <sqlalchemy.sql.elements.Label at 0x71b53beab690; channel>, <sqlalchemy.sql.elements.Label at 0x71b53beab5d0; starttime>, <sqlalchemy.sql.elements.Label at 0x71b53beabb50; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/unittest/case.py", line 59, in testPartExecutor
yield
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/unittest/case.py", line 628, in run
testMethod()
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 242, in test_get_availability_extent
"2018-12-31T00:00:00.000000")
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 360, in get_availability_extent
starttime, endtime)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 597, in _get_summary_rows
return self.request_handler._fetch_summary_rows(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/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 0x71b53beaba50; network>, <sqlalchemy.sql.elements.Label at 0x71b53beabe90; station>, <sqlalchemy.sql.elements.Label at 0x71b53beab290; location>, <sqlalchemy.sql.elements.Label at 0x71b53beab690; channel>, <sqlalchemy.sql.elements.Label at 0x71b53beab5d0; starttime>, <sqlalchemy.sql.elements.Label at 0x71b53beabb50; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x71b53beaba50; network>, <sqlalchemy.sql.elements.Label at 0x71b53beabe90; station>, <sqlalchemy.sql.elements.Label at 0x71b53beab290; location>, <sqlalchemy.sql.elements.Label at 0x71b53beab690; channel>, <sqlalchemy.sql.elements.Label at 0x71b53beab5d0; starttime>, <sqlalchemy.sql.elements.Label at 0x71b53beabb50; endtime>)?

Traceback (most recent call last):
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 1739, in _fetch_summary_rows
for idx, (a, b, c, d, e, f) in enumerate(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 1739, in <listcomp>
for idx, (a, b, c, d, e, f) in enumerate(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 538, in select
return Select(*entities)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5407, in __init__
for ent in entities
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5407, in <listcomp>
for ent in entities
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 397, in expect
element, argname=argname, **kw
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 635, in _literal_coercion
self._raise_for_expected(element, argname)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 1134, in _raise_for_expected
element, argname=argname, resolved=resolved, advice=advice, **kw
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 703, in _raise_for_expected
**kw,
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 519, 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 0x71b5394c18d0; network>, <sqlalchemy.sql.elements.Label at 0x71b5394cfe50; station>, <sqlalchemy.sql.elements.Label at 0x71b5394cf490; location>, <sqlalchemy.sql.elements.Label at 0x71b5394cf250; channel>, <sqlalchemy.sql.elements.Label at 0x71b5394f11d0; starttime>, <sqlalchemy.sql.elements.Label at 0x71b5394f1250; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x71b5394c18d0; network>, <sqlalchemy.sql.elements.Label at 0x71b5394cfe50; station>, <sqlalchemy.sql.elements.Label at 0x71b5394cf490; location>, <sqlalchemy.sql.elements.Label at 0x71b5394cf250; channel>, <sqlalchemy.sql.elements.Label at 0x71b5394f11d0; starttime>, <sqlalchemy.sql.elements.Label at 0x71b5394f1250; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/unittest/case.py", line 59, in testPartExecutor
yield
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/unittest/case.py", line 628, in run
testMethod()
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 180, in test_get_nslc
"2018-01-01T00:00:00.019499")
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 318, in get_nslc
channel, starttime, endtime)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 597, in _get_summary_rows
return self.request_handler._fetch_summary_rows(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/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 0x71b5394c18d0; network>, <sqlalchemy.sql.elements.Label at 0x71b5394cfe50; station>, <sqlalchemy.sql.elements.Label at 0x71b5394cf490; location>, <sqlalchemy.sql.elements.Label at 0x71b5394cf250; channel>, <sqlalchemy.sql.elements.Label at 0x71b5394f11d0; starttime>, <sqlalchemy.sql.elements.Label at 0x71b5394f1250; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x71b5394c18d0; network>, <sqlalchemy.sql.elements.Label at 0x71b5394cfe50; station>, <sqlalchemy.sql.elements.Label at 0x71b5394cf490; location>, <sqlalchemy.sql.elements.Label at 0x71b5394cf250; channel>, <sqlalchemy.sql.elements.Label at 0x71b5394f11d0; starttime>, <sqlalchemy.sql.elements.Label at 0x71b5394f1250; endtime>)?

Traceback (most recent call last):
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 1559, in _fetch_index_rows
for idx, (a, b, c, d, e, f) in enumerate(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 1559, in <listcomp>
for idx, (a, b, c, d, e, f) in enumerate(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 538, in select
return Select(*entities)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5407, in __init__
for ent in entities
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5407, in <listcomp>
for ent in entities
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 397, in expect
element, argname=argname, **kw
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 635, in _literal_coercion
self._raise_for_expected(element, argname)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 1134, in _raise_for_expected
element, argname=argname, resolved=resolved, advice=advice, **kw
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 703, in _raise_for_expected
**kw,
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 519, 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 0x71b5394aaa10; network>, <sqlalchemy.sql.elements.Label at 0x71b5394aa7d0; station>, <sqlalchemy.sql.elements.Label at 0x71b5394aac90; location>, <sqlalchemy.sql.elements.Label at 0x71b5394aab90; channel>, <sqlalchemy.sql.elements.Label at 0x71b5394aabd0; starttime>, <sqlalchemy.sql.elements.Label at 0x71b5394aac50; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x71b5394aaa10; network>, <sqlalchemy.sql.elements.Label at 0x71b5394aa7d0; station>, <sqlalchemy.sql.elements.Label at 0x71b5394aac90; location>, <sqlalchemy.sql.elements.Label at 0x71b5394aab90; channel>, <sqlalchemy.sql.elements.Label at 0x71b5394aabd0; starttime>, <sqlalchemy.sql.elements.Label at 0x71b5394aac50; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/unittest/case.py", line 59, in testPartExecutor
yield
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/unittest/case.py", line 628, in run
testMethod()
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 65, in test_get_waveforms
endtime=UTCDateTime(2018, 1, 1, 0, 0, 5))
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 262, in get_waveforms
return self._get_waveforms(query_rows, merge)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 623, in _get_waveforms
index_rows = self.request_handler._fetch_index_rows(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/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 0x71b5394aaa10; network>, <sqlalchemy.sql.elements.Label at 0x71b5394aa7d0; station>, <sqlalchemy.sql.elements.Label at 0x71b5394aac90; location>, <sqlalchemy.sql.elements.Label at 0x71b5394aab90; channel>, <sqlalchemy.sql.elements.Label at 0x71b5394aabd0; starttime>, <sqlalchemy.sql.elements.Label at 0x71b5394aac50; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x71b5394aaa10; network>, <sqlalchemy.sql.elements.Label at 0x71b5394aa7d0; station>, <sqlalchemy.sql.elements.Label at 0x71b5394aac90; location>, <sqlalchemy.sql.elements.Label at 0x71b5394aab90; channel>, <sqlalchemy.sql.elements.Label at 0x71b5394aabd0; starttime>, <sqlalchemy.sql.elements.Label at 0x71b5394aac50; endtime>)?

Traceback (most recent call last):
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 1559, in _fetch_index_rows
for idx, (a, b, c, d, e, f) in enumerate(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 1559, in <listcomp>
for idx, (a, b, c, d, e, f) in enumerate(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 538, in select
return Select(*entities)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5407, in __init__
for ent in entities
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5407, in <listcomp>
for ent in entities
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 397, in expect
element, argname=argname, **kw
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 635, in _literal_coercion
self._raise_for_expected(element, argname)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 1134, in _raise_for_expected
element, argname=argname, resolved=resolved, advice=advice, **kw
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 703, in _raise_for_expected
**kw,
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 519, 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 0x71b53952cb10; network>, <sqlalchemy.sql.elements.Label at 0x71b539542b50; station>, <sqlalchemy.sql.elements.Label at 0x71b53bea3810; location>, <sqlalchemy.sql.elements.Label at 0x71b53bea3510; channel>, <sqlalchemy.sql.elements.Label at 0x71b53bea3490; starttime>, <sqlalchemy.sql.elements.Label at 0x71b53bea34d0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x71b53952cb10; network>, <sqlalchemy.sql.elements.Label at 0x71b539542b50; station>, <sqlalchemy.sql.elements.Label at 0x71b53bea3810; location>, <sqlalchemy.sql.elements.Label at 0x71b53bea3510; channel>, <sqlalchemy.sql.elements.Label at 0x71b53bea3490; starttime>, <sqlalchemy.sql.elements.Label at 0x71b53bea34d0; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/unittest/case.py", line 59, in testPartExecutor
yield
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/unittest/case.py", line 628, in run
testMethod()
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 142, in test_get_waveforms_bulk
returned_stream = client.get_waveforms_bulk(bulk_request)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 288, in get_waveforms_bulk
return self._get_waveforms(query_rows, merge)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 623, in _get_waveforms
index_rows = self.request_handler._fetch_index_rows(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/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 0x71b53952cb10; network>, <sqlalchemy.sql.elements.Label at 0x71b539542b50; station>, <sqlalchemy.sql.elements.Label at 0x71b53bea3810; location>, <sqlalchemy.sql.elements.Label at 0x71b53bea3510; channel>, <sqlalchemy.sql.elements.Label at 0x71b53bea3490; starttime>, <sqlalchemy.sql.elements.Label at 0x71b53bea34d0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x71b53952cb10; network>, <sqlalchemy.sql.elements.Label at 0x71b539542b50; station>, <sqlalchemy.sql.elements.Label at 0x71b53bea3810; location>, <sqlalchemy.sql.elements.Label at 0x71b53bea3510; channel>, <sqlalchemy.sql.elements.Label at 0x71b53bea3490; starttime>, <sqlalchemy.sql.elements.Label at 0x71b53bea34d0; endtime>)?

Traceback (most recent call last):
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 1559, in _fetch_index_rows
for idx, (a, b, c, d, e, f) in enumerate(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 1559, in <listcomp>
for idx, (a, b, c, d, e, f) in enumerate(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 538, in select
return Select(*entities)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5407, in __init__
for ent in entities
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5407, in <listcomp>
for ent in entities
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 397, in expect
element, argname=argname, **kw
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 635, in _literal_coercion
self._raise_for_expected(element, argname)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 1134, in _raise_for_expected
element, argname=argname, resolved=resolved, advice=advice, **kw
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 703, in _raise_for_expected
**kw,
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 519, 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 0x71b53beafbd0; network>, <sqlalchemy.sql.elements.Label at 0x71b53beaff90; station>, <sqlalchemy.sql.elements.Label at 0x71b53beaf110; location>, <sqlalchemy.sql.elements.Label at 0x71b53beaf210; channel>, <sqlalchemy.sql.elements.Label at 0x71b53beaffd0; starttime>, <sqlalchemy.sql.elements.Label at 0x71b5394aab10; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x71b53beafbd0; network>, <sqlalchemy.sql.elements.Label at 0x71b53beaff90; station>, <sqlalchemy.sql.elements.Label at 0x71b53beaf110; location>, <sqlalchemy.sql.elements.Label at 0x71b53beaf210; channel>, <sqlalchemy.sql.elements.Label at 0x71b53beaffd0; starttime>, <sqlalchemy.sql.elements.Label at 0x71b5394aab10; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/unittest/case.py", line 59, in testPartExecutor
yield
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/unittest/case.py", line 628, in run
testMethod()
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 581, in test_has_data
self.assertTrue(client.has_data())
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 563, in has_data
endtime)[0]
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 497, in get_availability_percentage
merge_overlap=True)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 417, in get_availability
starttime, endtime)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 679, in _get_tsindex_rows
return self.request_handler._fetch_index_rows(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/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 0x71b53beafbd0; network>, <sqlalchemy.sql.elements.Label at 0x71b53beaff90; station>, <sqlalchemy.sql.elements.Label at 0x71b53beaf110; location>, <sqlalchemy.sql.elements.Label at 0x71b53beaf210; channel>, <sqlalchemy.sql.elements.Label at 0x71b53beaffd0; starttime>, <sqlalchemy.sql.elements.Label at 0x71b5394aab10; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x71b53beafbd0; network>, <sqlalchemy.sql.elements.Label at 0x71b53beaff90; station>, <sqlalchemy.sql.elements.Label at 0x71b53beaf110; location>, <sqlalchemy.sql.elements.Label at 0x71b53beaf210; channel>, <sqlalchemy.sql.elements.Label at 0x71b53beaffd0; starttime>, <sqlalchemy.sql.elements.Label at 0x71b5394aab10; endtime>)?

Traceback (most recent call last):
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 1559, in _fetch_index_rows
for idx, (a, b, c, d, e, f) in enumerate(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 1559, in <listcomp>
for idx, (a, b, c, d, e, f) in enumerate(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 538, in select
return Select(*entities)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5407, in __init__
for ent in entities
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5407, in <listcomp>
for ent in entities
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 397, in expect
element, argname=argname, **kw
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 635, in _literal_coercion
self._raise_for_expected(element, argname)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 1134, in _raise_for_expected
element, argname=argname, resolved=resolved, advice=advice, **kw
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 703, in _raise_for_expected
**kw,
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 519, 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 0x71b53bea3690; network>, <sqlalchemy.sql.elements.Label at 0x71b53944b250; station>, <sqlalchemy.sql.elements.Label at 0x71b53944b390; location>, <sqlalchemy.sql.elements.Label at 0x71b53944b4d0; channel>, <sqlalchemy.sql.elements.Label at 0x71b53944b6d0; starttime>, <sqlalchemy.sql.elements.Label at 0x71b53944b510; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x71b53bea3690; network>, <sqlalchemy.sql.elements.Label at 0x71b53944b250; station>, <sqlalchemy.sql.elements.Label at 0x71b53944b390; location>, <sqlalchemy.sql.elements.Label at 0x71b53944b4d0; channel>, <sqlalchemy.sql.elements.Label at 0x71b53944b6d0; starttime>, <sqlalchemy.sql.elements.Label at 0x71b53944b510; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/unittest/case.py", line 59, in testPartExecutor
yield
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/unittest/case.py", line 628, in run
testMethod()
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 774, in test_build_file_list
relative_paths=False)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/unittest/case.py", line 1298, in assertRaisesRegex
return context.handle('assertRaisesRegex', args, kwargs)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/unittest/case.py", line 178, in handle
callable_obj(*args, **kwargs)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 1064, in build_file_list
tsindex = self.request_handler._fetch_index_rows()
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/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 0x71b53bea3690; network>, <sqlalchemy.sql.elements.Label at 0x71b53944b250; station>, <sqlalchemy.sql.elements.Label at 0x71b53944b390; location>, <sqlalchemy.sql.elements.Label at 0x71b53944b4d0; channel>, <sqlalchemy.sql.elements.Label at 0x71b53944b6d0; starttime>, <sqlalchemy.sql.elements.Label at 0x71b53944b510; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x71b53bea3690; network>, <sqlalchemy.sql.elements.Label at 0x71b53944b250; station>, <sqlalchemy.sql.elements.Label at 0x71b53944b390; location>, <sqlalchemy.sql.elements.Label at 0x71b53944b4d0; channel>, <sqlalchemy.sql.elements.Label at 0x71b53944b6d0; starttime>, <sqlalchemy.sql.elements.Label at 0x71b53944b510; endtime>)?

Traceback (most recent call last):
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 1739, in _fetch_summary_rows
for idx, (a, b, c, d, e, f) in enumerate(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 1739, in <listcomp>
for idx, (a, b, c, d, e, f) in enumerate(query_rows)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 538, in select
return Select(*entities)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5407, in __init__
for ent in entities
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5407, in <listcomp>
for ent in entities
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 397, in expect
element, argname=argname, **kw
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 635, in _literal_coercion
self._raise_for_expected(element, argname)
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 1134, in _raise_for_expected
element, argname=argname, resolved=resolved, advice=advice, **kw
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 703, in _raise_for_expected
**kw,
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 519, 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 0x71b53944fd10; network>, <sqlalchemy.sql.elements.Label at 0x71b53944fc50; station>, <sqlalchemy.sql.elements.Label at 0x71b53944fd50; location>, <sqlalchemy.sql.elements.Label at 0x71b53944fb10; channel>, <sqlalchemy.sql.elements.Label at 0x71b53944fa90; starttime>, <sqlalchemy.sql.elements.Label at 0x71b53944fa10; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x71b53944fd10; network>, <sqlalchemy.sql.elements.Label at 0x71b53944fc50; station>, <sqlalchemy.sql.elements.Label at 0x71b53944fd50; location>, <sqlalchemy.sql.elements.Label at 0x71b53944fb10; channel>, <sqlalchemy.sql.elements.Label at 0x71b53944fa90; starttime>, <sqlalchemy.sql.elements.Label at 0x71b53944fa10; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/unittest/case.py", line 59, in testPartExecutor
yield
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/unittest/case.py", line 628, in run
testMethod()
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 917, in test__fetch_summary_rows
[("I*,CU",
File "/home/mario/anaconda3/envs/eqt/lib/python3.7/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 0x71b53944fd10; network>, <sqlalchemy.sql.elements.Label at 0x71b53944fc50; station>, <sqlalchemy.sql.elements.Label at 0x71b53944fd50; location>, <sqlalchemy.sql.elements.Label at 0x71b53944fb10; channel>, <sqlalchemy.sql.elements.Label at 0x71b53944fa90; starttime>, <sqlalchemy.sql.elements.Label at 0x71b53944fa10; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x71b53944fd10; network>, <sqlalchemy.sql.elements.Label at 0x71b53944fc50; station>, <sqlalchemy.sql.elements.Label at 0x71b53944fd50; location>, <sqlalchemy.sql.elements.Label at 0x71b53944fb10; channel>, <sqlalchemy.sql.elements.Label at 0x71b53944fa90; starttime>, <sqlalchemy.sql.elements.Label at 0x71b53944fa10; endtime>)?