#136866 Report by node LAPTOP-9H1VQ1F8 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 0x7efee74b4b10; network>, <sqlalchemy.sql.elements.Label at 0x7efee72e8450; station>, <sqlalchemy.sql.elements.Label at 0x7efee72e8550; location>, <sqlalchemy.sql.elements.Label at 0x7efee72e85d0; channel>, <sqlalchemy.sql.elements.Label at 0x7efee72e8650; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee72e86d0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7efee74b4b10; network>, <sqlalchemy.sql.elements.Label at 0x7efee72e8450; station>, <sqlalchemy.sql.elements.Label at 0x7efee72e8550; location>, <sqlalchemy.sql.elements.Label at 0x7efee72e85d0; channel>, <sqlalchemy.sql.elements.Label at 0x7efee72e8650; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee72e86d0; endtime>)?')
Traceback (most recent call last):
File "/home/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5140, in __init__
for ent in entities
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5140, in <listcomp>
for ent in entities
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 414, in expect
element, argname=argname, **kw
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 651, in _literal_coercion
self._raise_for_expected(element, argname)
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 1140, in _raise_for_expected
element, argname=argname, resolved=resolved, advice=advice, **kw
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 717, in _raise_for_expected
**kw,
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 535, 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 0x7efee74b4b10; network>, <sqlalchemy.sql.elements.Label at 0x7efee72e8450; station>, <sqlalchemy.sql.elements.Label at 0x7efee72e8550; location>, <sqlalchemy.sql.elements.Label at 0x7efee72e85d0; channel>, <sqlalchemy.sql.elements.Label at 0x7efee72e8650; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee72e86d0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7efee74b4b10; network>, <sqlalchemy.sql.elements.Label at 0x7efee72e8450; station>, <sqlalchemy.sql.elements.Label at 0x7efee72e8550; location>, <sqlalchemy.sql.elements.Label at 0x7efee72e85d0; channel>, <sqlalchemy.sql.elements.Label at 0x7efee72e8650; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee72e86d0; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 360, in get_availability_extent
starttime, endtime)
File "/home/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/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 0x7efee74b4b10; network>, <sqlalchemy.sql.elements.Label at 0x7efee72e8450; station>, <sqlalchemy.sql.elements.Label at 0x7efee72e8550; location>, <sqlalchemy.sql.elements.Label at 0x7efee72e85d0; channel>, <sqlalchemy.sql.elements.Label at 0x7efee72e8650; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee72e86d0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7efee74b4b10; network>, <sqlalchemy.sql.elements.Label at 0x7efee72e8450; station>, <sqlalchemy.sql.elements.Label at 0x7efee72e8550; location>, <sqlalchemy.sql.elements.Label at 0x7efee72e85d0; channel>, <sqlalchemy.sql.elements.Label at 0x7efee72e8650; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee72e86d0; endtime>)?
/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py:64: UnexpectedException

Traceback (most recent call last):
File "/home/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5140, in __init__
for ent in entities
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5140, in <listcomp>
for ent in entities
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 414, in expect
element, argname=argname, **kw
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 651, in _literal_coercion
self._raise_for_expected(element, argname)
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 1140, in _raise_for_expected
element, argname=argname, resolved=resolved, advice=advice, **kw
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 717, in _raise_for_expected
**kw,
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 535, 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 0x7efee7164410; network>, <sqlalchemy.sql.elements.Label at 0x7efee7164c90; station>, <sqlalchemy.sql.elements.Label at 0x7efee7164b10; location>, <sqlalchemy.sql.elements.Label at 0x7efee7164f50; channel>, <sqlalchemy.sql.elements.Label at 0x7efee7164490; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee7164c10; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7efee7164410; network>, <sqlalchemy.sql.elements.Label at 0x7efee7164c90; station>, <sqlalchemy.sql.elements.Label at 0x7efee7164b10; location>, <sqlalchemy.sql.elements.Label at 0x7efee7164f50; channel>, <sqlalchemy.sql.elements.Label at 0x7efee7164490; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee7164c10; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/unittest/case.py", line 59, in testPartExecutor
yield
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/unittest/case.py", line 628, in run
testMethod()
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 387, in test_get_availability
"2018-12-31")
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 417, in get_availability
starttime, endtime)
File "/home/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/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 0x7efee7164410; network>, <sqlalchemy.sql.elements.Label at 0x7efee7164c90; station>, <sqlalchemy.sql.elements.Label at 0x7efee7164b10; location>, <sqlalchemy.sql.elements.Label at 0x7efee7164f50; channel>, <sqlalchemy.sql.elements.Label at 0x7efee7164490; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee7164c10; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7efee7164410; network>, <sqlalchemy.sql.elements.Label at 0x7efee7164c90; station>, <sqlalchemy.sql.elements.Label at 0x7efee7164b10; location>, <sqlalchemy.sql.elements.Label at 0x7efee7164f50; channel>, <sqlalchemy.sql.elements.Label at 0x7efee7164490; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee7164c10; endtime>)?

Traceback (most recent call last):
File "/home/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5140, in __init__
for ent in entities
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5140, in <listcomp>
for ent in entities
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 414, in expect
element, argname=argname, **kw
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 651, in _literal_coercion
self._raise_for_expected(element, argname)
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 1140, in _raise_for_expected
element, argname=argname, resolved=resolved, advice=advice, **kw
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 717, in _raise_for_expected
**kw,
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 535, 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 0x7efee70ea1d0; network>, <sqlalchemy.sql.elements.Label at 0x7efee72e8590; station>, <sqlalchemy.sql.elements.Label at 0x7efee72e8710; location>, <sqlalchemy.sql.elements.Label at 0x7efee70ef190; channel>, <sqlalchemy.sql.elements.Label at 0x7efee70ef690; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee70efa50; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7efee70ea1d0; network>, <sqlalchemy.sql.elements.Label at 0x7efee72e8590; station>, <sqlalchemy.sql.elements.Label at 0x7efee72e8710; location>, <sqlalchemy.sql.elements.Label at 0x7efee70ef190; channel>, <sqlalchemy.sql.elements.Label at 0x7efee70ef690; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee70efa50; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/unittest/case.py", line 59, in testPartExecutor
yield
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/unittest/case.py", line 628, in run
testMethod()
File "/home/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 360, in get_availability_extent
starttime, endtime)
File "/home/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/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 0x7efee70ea1d0; network>, <sqlalchemy.sql.elements.Label at 0x7efee72e8590; station>, <sqlalchemy.sql.elements.Label at 0x7efee72e8710; location>, <sqlalchemy.sql.elements.Label at 0x7efee70ef190; channel>, <sqlalchemy.sql.elements.Label at 0x7efee70ef690; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee70efa50; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7efee70ea1d0; network>, <sqlalchemy.sql.elements.Label at 0x7efee72e8590; station>, <sqlalchemy.sql.elements.Label at 0x7efee72e8710; location>, <sqlalchemy.sql.elements.Label at 0x7efee70ef190; channel>, <sqlalchemy.sql.elements.Label at 0x7efee70ef690; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee70efa50; endtime>)?

Traceback (most recent call last):
File "/home/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5140, in __init__
for ent in entities
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5140, in <listcomp>
for ent in entities
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 414, in expect
element, argname=argname, **kw
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 651, in _literal_coercion
self._raise_for_expected(element, argname)
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 1140, in _raise_for_expected
element, argname=argname, resolved=resolved, advice=advice, **kw
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 717, in _raise_for_expected
**kw,
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 535, 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 0x7efee357b8d0; network>, <sqlalchemy.sql.elements.Label at 0x7efee357b250; station>, <sqlalchemy.sql.elements.Label at 0x7efee357bc10; location>, <sqlalchemy.sql.elements.Label at 0x7efee3525850; channel>, <sqlalchemy.sql.elements.Label at 0x7efee35258d0; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee3525c10; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7efee357b8d0; network>, <sqlalchemy.sql.elements.Label at 0x7efee357b250; station>, <sqlalchemy.sql.elements.Label at 0x7efee357bc10; location>, <sqlalchemy.sql.elements.Label at 0x7efee3525850; channel>, <sqlalchemy.sql.elements.Label at 0x7efee35258d0; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee3525c10; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/unittest/case.py", line 59, in testPartExecutor
yield
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/unittest/case.py", line 628, in run
testMethod()
File "/home/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 318, in get_nslc
channel, starttime, endtime)
File "/home/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/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 0x7efee357b8d0; network>, <sqlalchemy.sql.elements.Label at 0x7efee357b250; station>, <sqlalchemy.sql.elements.Label at 0x7efee357bc10; location>, <sqlalchemy.sql.elements.Label at 0x7efee3525850; channel>, <sqlalchemy.sql.elements.Label at 0x7efee35258d0; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee3525c10; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7efee357b8d0; network>, <sqlalchemy.sql.elements.Label at 0x7efee357b250; station>, <sqlalchemy.sql.elements.Label at 0x7efee357bc10; location>, <sqlalchemy.sql.elements.Label at 0x7efee3525850; channel>, <sqlalchemy.sql.elements.Label at 0x7efee35258d0; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee3525c10; endtime>)?

Traceback (most recent call last):
File "/home/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5140, in __init__
for ent in entities
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5140, in <listcomp>
for ent in entities
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 414, in expect
element, argname=argname, **kw
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 651, in _literal_coercion
self._raise_for_expected(element, argname)
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 1140, in _raise_for_expected
element, argname=argname, resolved=resolved, advice=advice, **kw
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 717, in _raise_for_expected
**kw,
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 535, 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 0x7efee34e2150; network>, <sqlalchemy.sql.elements.Label at 0x7efee34e2090; station>, <sqlalchemy.sql.elements.Label at 0x7efee34e2310; location>, <sqlalchemy.sql.elements.Label at 0x7efee34e2210; channel>, <sqlalchemy.sql.elements.Label at 0x7efee34e2250; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee34e22d0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7efee34e2150; network>, <sqlalchemy.sql.elements.Label at 0x7efee34e2090; station>, <sqlalchemy.sql.elements.Label at 0x7efee34e2310; location>, <sqlalchemy.sql.elements.Label at 0x7efee34e2210; channel>, <sqlalchemy.sql.elements.Label at 0x7efee34e2250; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee34e22d0; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/unittest/case.py", line 59, in testPartExecutor
yield
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/unittest/case.py", line 628, in run
testMethod()
File "/home/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 262, in get_waveforms
return self._get_waveforms(query_rows, merge)
File "/home/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/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 0x7efee34e2150; network>, <sqlalchemy.sql.elements.Label at 0x7efee34e2090; station>, <sqlalchemy.sql.elements.Label at 0x7efee34e2310; location>, <sqlalchemy.sql.elements.Label at 0x7efee34e2210; channel>, <sqlalchemy.sql.elements.Label at 0x7efee34e2250; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee34e22d0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7efee34e2150; network>, <sqlalchemy.sql.elements.Label at 0x7efee34e2090; station>, <sqlalchemy.sql.elements.Label at 0x7efee34e2310; location>, <sqlalchemy.sql.elements.Label at 0x7efee34e2210; channel>, <sqlalchemy.sql.elements.Label at 0x7efee34e2250; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee34e22d0; endtime>)?

Traceback (most recent call last):
File "/home/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5140, in __init__
for ent in entities
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5140, in <listcomp>
for ent in entities
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 414, in expect
element, argname=argname, **kw
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 651, in _literal_coercion
self._raise_for_expected(element, argname)
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 1140, in _raise_for_expected
element, argname=argname, resolved=resolved, advice=advice, **kw
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 717, in _raise_for_expected
**kw,
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 535, 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 0x7efee7122790; network>, <sqlalchemy.sql.elements.Label at 0x7efee3557dd0; station>, <sqlalchemy.sql.elements.Label at 0x7efee70e7990; location>, <sqlalchemy.sql.elements.Label at 0x7efee70e7810; channel>, <sqlalchemy.sql.elements.Label at 0x7efee70e7c10; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee70e7ad0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7efee7122790; network>, <sqlalchemy.sql.elements.Label at 0x7efee3557dd0; station>, <sqlalchemy.sql.elements.Label at 0x7efee70e7990; location>, <sqlalchemy.sql.elements.Label at 0x7efee70e7810; channel>, <sqlalchemy.sql.elements.Label at 0x7efee70e7c10; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee70e7ad0; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/unittest/case.py", line 59, in testPartExecutor
yield
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/unittest/case.py", line 628, in run
testMethod()
File "/home/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/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 0x7efee7122790; network>, <sqlalchemy.sql.elements.Label at 0x7efee3557dd0; station>, <sqlalchemy.sql.elements.Label at 0x7efee70e7990; location>, <sqlalchemy.sql.elements.Label at 0x7efee70e7810; channel>, <sqlalchemy.sql.elements.Label at 0x7efee70e7c10; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee70e7ad0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7efee7122790; network>, <sqlalchemy.sql.elements.Label at 0x7efee3557dd0; station>, <sqlalchemy.sql.elements.Label at 0x7efee70e7990; location>, <sqlalchemy.sql.elements.Label at 0x7efee70e7810; channel>, <sqlalchemy.sql.elements.Label at 0x7efee70e7c10; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee70e7ad0; endtime>)?

Traceback (most recent call last):
File "/home/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5140, in __init__
for ent in entities
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5140, in <listcomp>
for ent in entities
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 414, in expect
element, argname=argname, **kw
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 651, in _literal_coercion
self._raise_for_expected(element, argname)
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 1140, in _raise_for_expected
element, argname=argname, resolved=resolved, advice=advice, **kw
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 717, in _raise_for_expected
**kw,
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 535, 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 0x7efee70ef7d0; network>, <sqlalchemy.sql.elements.Label at 0x7efee7159ed0; station>, <sqlalchemy.sql.elements.Label at 0x7efee7196a50; location>, <sqlalchemy.sql.elements.Label at 0x7efee9d06d90; channel>, <sqlalchemy.sql.elements.Label at 0x7efee9d06950; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee7266190; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7efee70ef7d0; network>, <sqlalchemy.sql.elements.Label at 0x7efee7159ed0; station>, <sqlalchemy.sql.elements.Label at 0x7efee7196a50; location>, <sqlalchemy.sql.elements.Label at 0x7efee9d06d90; channel>, <sqlalchemy.sql.elements.Label at 0x7efee9d06950; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee7266190; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/unittest/case.py", line 59, in testPartExecutor
yield
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/unittest/case.py", line 628, in run
testMethod()
File "/home/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 563, in has_data
endtime)[0]
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 497, in get_availability_percentage
merge_overlap=True)
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/obspy/clients/filesystem/tsindex.py", line 417, in get_availability
starttime, endtime)
File "/home/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/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 0x7efee70ef7d0; network>, <sqlalchemy.sql.elements.Label at 0x7efee7159ed0; station>, <sqlalchemy.sql.elements.Label at 0x7efee7196a50; location>, <sqlalchemy.sql.elements.Label at 0x7efee9d06d90; channel>, <sqlalchemy.sql.elements.Label at 0x7efee9d06950; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee7266190; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7efee70ef7d0; network>, <sqlalchemy.sql.elements.Label at 0x7efee7159ed0; station>, <sqlalchemy.sql.elements.Label at 0x7efee7196a50; location>, <sqlalchemy.sql.elements.Label at 0x7efee9d06d90; channel>, <sqlalchemy.sql.elements.Label at 0x7efee9d06950; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee7266190; endtime>)?

Traceback (most recent call last):
File "/home/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5140, in __init__
for ent in entities
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5140, in <listcomp>
for ent in entities
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 414, in expect
element, argname=argname, **kw
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 651, in _literal_coercion
self._raise_for_expected(element, argname)
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 1140, in _raise_for_expected
element, argname=argname, resolved=resolved, advice=advice, **kw
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 717, in _raise_for_expected
**kw,
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 535, 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 0x7efee70e7b10; network>, <sqlalchemy.sql.elements.Label at 0x7efee34f6850; station>, <sqlalchemy.sql.elements.Label at 0x7efee34f69d0; location>, <sqlalchemy.sql.elements.Label at 0x7efee34f6b10; channel>, <sqlalchemy.sql.elements.Label at 0x7efee34f6d10; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee34f6b50; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7efee70e7b10; network>, <sqlalchemy.sql.elements.Label at 0x7efee34f6850; station>, <sqlalchemy.sql.elements.Label at 0x7efee34f69d0; location>, <sqlalchemy.sql.elements.Label at 0x7efee34f6b10; channel>, <sqlalchemy.sql.elements.Label at 0x7efee34f6d10; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee34f6b50; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/unittest/case.py", line 59, in testPartExecutor
yield
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/unittest/case.py", line 628, in run
testMethod()
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 774, in test_build_file_list
relative_paths=False)
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/unittest/case.py", line 1298, in assertRaisesRegex
return context.handle('assertRaisesRegex', args, kwargs)
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/unittest/case.py", line 178, in handle
callable_obj(*args, **kwargs)
File "/home/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/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 0x7efee70e7b10; network>, <sqlalchemy.sql.elements.Label at 0x7efee34f6850; station>, <sqlalchemy.sql.elements.Label at 0x7efee34f69d0; location>, <sqlalchemy.sql.elements.Label at 0x7efee34f6b10; channel>, <sqlalchemy.sql.elements.Label at 0x7efee34f6d10; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee34f6b50; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7efee70e7b10; network>, <sqlalchemy.sql.elements.Label at 0x7efee34f6850; station>, <sqlalchemy.sql.elements.Label at 0x7efee34f69d0; location>, <sqlalchemy.sql.elements.Label at 0x7efee34f6b10; channel>, <sqlalchemy.sql.elements.Label at 0x7efee34f6d10; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee34f6b50; endtime>)?

Traceback (most recent call last):
File "/home/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/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/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5140, in __init__
for ent in entities
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/selectable.py", line 5140, in <listcomp>
for ent in entities
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 414, in expect
element, argname=argname, **kw
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 651, in _literal_coercion
self._raise_for_expected(element, argname)
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 1140, in _raise_for_expected
element, argname=argname, resolved=resolved, advice=advice, **kw
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 717, in _raise_for_expected
**kw,
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/sqlalchemy/sql/coercions.py", line 535, 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 0x7efee35072d0; network>, <sqlalchemy.sql.elements.Label at 0x7efee3505dd0; station>, <sqlalchemy.sql.elements.Label at 0x7efee3505f90; location>, <sqlalchemy.sql.elements.Label at 0x7efee3505a50; channel>, <sqlalchemy.sql.elements.Label at 0x7efee35059d0; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee3505950; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7efee35072d0; network>, <sqlalchemy.sql.elements.Label at 0x7efee3505dd0; station>, <sqlalchemy.sql.elements.Label at 0x7efee3505f90; location>, <sqlalchemy.sql.elements.Label at 0x7efee3505a50; channel>, <sqlalchemy.sql.elements.Label at 0x7efee35059d0; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee3505950; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/unittest/case.py", line 59, in testPartExecutor
yield
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/unittest/case.py", line 628, in run
testMethod()
File "/home/cps/anaconda3/envs/obspy/lib/python3.7/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 917, in test__fetch_summary_rows
[("I*,CU",
File "/home/cps/anaconda3/envs/obspy/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 0x7efee35072d0; network>, <sqlalchemy.sql.elements.Label at 0x7efee3505dd0; station>, <sqlalchemy.sql.elements.Label at 0x7efee3505f90; location>, <sqlalchemy.sql.elements.Label at 0x7efee3505a50; channel>, <sqlalchemy.sql.elements.Label at 0x7efee35059d0; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee3505950; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7efee35072d0; network>, <sqlalchemy.sql.elements.Label at 0x7efee3505dd0; station>, <sqlalchemy.sql.elements.Label at 0x7efee3505f90; location>, <sqlalchemy.sql.elements.Label at 0x7efee3505a50; channel>, <sqlalchemy.sql.elements.Label at 0x7efee35059d0; starttime>, <sqlalchemy.sql.elements.Label at 0x7efee3505950; endtime>)?