#135064 Report by node gh-actions covering 2060 tests from 59 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 0x7f4924b73b50; network>, <sqlalchemy.sql.elements.Label at 0x7f4924b73b80; station>, <sqlalchemy.sql.elements.Label at 0x7f4924b73be0; location>, <sqlalchemy.sql.elements.Label at 0x7f4924b87370; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924b87610; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924b87700; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7f4924b73b50; network>, <sqlalchemy.sql.elements.Label at 0x7f4924b73b80; station>, <sqlalchemy.sql.elements.Label at 0x7f4924b73be0; location>, <sqlalchemy.sql.elements.Label at 0x7f4924b87370; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924b87610; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924b87700; endtime>)?')
Traceback (most recent call last):
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 1726, in _fetch_summary_rows
stmts = [
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 1727, in <listcomp>
sa.select([
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/selectable.py", line 5130, in __init__
self._raw_columns = [
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/selectable.py", line 5131, in <listcomp>
coercions.expect(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 413, in expect
resolved = impl._literal_coercion(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 651, in _literal_coercion
self._raise_for_expected(element, argname)
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 1139, in _raise_for_expected
return super()._raise_for_expected(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 710, in _raise_for_expected
super()._raise_for_expected(
File "/usr/share/miniconda3/envs/test/lib/python3.8/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 0x7f4924b73b50; network>, <sqlalchemy.sql.elements.Label at 0x7f4924b73b80; station>, <sqlalchemy.sql.elements.Label at 0x7f4924b73be0; location>, <sqlalchemy.sql.elements.Label at 0x7f4924b87370; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924b87610; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924b87700; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7f4924b73b50; network>, <sqlalchemy.sql.elements.Label at 0x7f4924b73b80; station>, <sqlalchemy.sql.elements.Label at 0x7f4924b73be0; location>, <sqlalchemy.sql.elements.Label at 0x7f4924b87370; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924b87610; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924b87700; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/share/miniconda3/envs/test/lib/python3.8/doctest.py", line 1336, in __run
exec(compile(example.source, filename, "single",
File "<doctest obspy.clients.filesystem.tsindex[6]>", line 1, in <module>
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 358, in get_availability_extent
summary_rows = self._get_summary_rows(network, station,
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 597, in _get_summary_rows
return self.request_handler._fetch_summary_rows(query_rows)
File "/usr/share/miniconda3/envs/test/lib/python3.8/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 0x7f4924b73b50; network>, <sqlalchemy.sql.elements.Label at 0x7f4924b73b80; station>, <sqlalchemy.sql.elements.Label at 0x7f4924b73be0; location>, <sqlalchemy.sql.elements.Label at 0x7f4924b87370; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924b87610; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924b87700; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7f4924b73b50; network>, <sqlalchemy.sql.elements.Label at 0x7f4924b73b80; station>, <sqlalchemy.sql.elements.Label at 0x7f4924b73be0; location>, <sqlalchemy.sql.elements.Label at 0x7f4924b87370; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924b87610; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924b87700; endtime>)?
/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py:64: UnexpectedException

Traceback (most recent call last):
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 1546, in _fetch_index_rows
stmts = [
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 1547, in <listcomp>
sa.select([
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/selectable.py", line 5130, in __init__
self._raw_columns = [
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/selectable.py", line 5131, in <listcomp>
coercions.expect(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 413, in expect
resolved = impl._literal_coercion(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 651, in _literal_coercion
self._raise_for_expected(element, argname)
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 1139, in _raise_for_expected
return super()._raise_for_expected(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 710, in _raise_for_expected
super()._raise_for_expected(
File "/usr/share/miniconda3/envs/test/lib/python3.8/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 0x7f4924a983a0; network>, <sqlalchemy.sql.elements.Label at 0x7f4924a98850; station>, <sqlalchemy.sql.elements.Label at 0x7f4924a98580; location>, <sqlalchemy.sql.elements.Label at 0x7f4924a98bb0; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924a98a60; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924a98ca0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7f4924a983a0; network>, <sqlalchemy.sql.elements.Label at 0x7f4924a98850; station>, <sqlalchemy.sql.elements.Label at 0x7f4924a98580; location>, <sqlalchemy.sql.elements.Label at 0x7f4924a98bb0; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924a98a60; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924a98ca0; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 380, in test_get_availability
actual_avail = client.get_availability(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 415, in get_availability
tsindex_rows = self._get_tsindex_rows(network, station,
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 679, in _get_tsindex_rows
return self.request_handler._fetch_index_rows(query_rows)
File "/usr/share/miniconda3/envs/test/lib/python3.8/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 0x7f4924a983a0; network>, <sqlalchemy.sql.elements.Label at 0x7f4924a98850; station>, <sqlalchemy.sql.elements.Label at 0x7f4924a98580; location>, <sqlalchemy.sql.elements.Label at 0x7f4924a98bb0; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924a98a60; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924a98ca0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7f4924a983a0; network>, <sqlalchemy.sql.elements.Label at 0x7f4924a98850; station>, <sqlalchemy.sql.elements.Label at 0x7f4924a98580; location>, <sqlalchemy.sql.elements.Label at 0x7f4924a98bb0; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924a98a60; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924a98ca0; endtime>)?

Traceback (most recent call last):
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 1726, in _fetch_summary_rows
stmts = [
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 1727, in <listcomp>
sa.select([
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/selectable.py", line 5130, in __init__
self._raw_columns = [
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/selectable.py", line 5131, in <listcomp>
coercions.expect(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 413, in expect
resolved = impl._literal_coercion(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 651, in _literal_coercion
self._raise_for_expected(element, argname)
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 1139, in _raise_for_expected
return super()._raise_for_expected(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 710, in _raise_for_expected
super()._raise_for_expected(
File "/usr/share/miniconda3/envs/test/lib/python3.8/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 0x7f4924a2d1c0; network>, <sqlalchemy.sql.elements.Label at 0x7f4924a2d610; station>, <sqlalchemy.sql.elements.Label at 0x7f4924aa9f40; location>, <sqlalchemy.sql.elements.Label at 0x7f4924aa9550; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924aa99a0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924aa9520; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7f4924a2d1c0; network>, <sqlalchemy.sql.elements.Label at 0x7f4924a2d610; station>, <sqlalchemy.sql.elements.Label at 0x7f4924aa9f40; location>, <sqlalchemy.sql.elements.Label at 0x7f4924aa9550; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924aa99a0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924aa9520; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 235, in test_get_availability_extent
actual_avail_extents = client.get_availability_extent(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 358, in get_availability_extent
summary_rows = self._get_summary_rows(network, station,
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 597, in _get_summary_rows
return self.request_handler._fetch_summary_rows(query_rows)
File "/usr/share/miniconda3/envs/test/lib/python3.8/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 0x7f4924a2d1c0; network>, <sqlalchemy.sql.elements.Label at 0x7f4924a2d610; station>, <sqlalchemy.sql.elements.Label at 0x7f4924aa9f40; location>, <sqlalchemy.sql.elements.Label at 0x7f4924aa9550; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924aa99a0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924aa9520; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7f4924a2d1c0; network>, <sqlalchemy.sql.elements.Label at 0x7f4924a2d610; station>, <sqlalchemy.sql.elements.Label at 0x7f4924aa9f40; location>, <sqlalchemy.sql.elements.Label at 0x7f4924aa9550; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924aa99a0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924aa9520; endtime>)?

Traceback (most recent call last):
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 1726, in _fetch_summary_rows
stmts = [
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 1727, in <listcomp>
sa.select([
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/selectable.py", line 5130, in __init__
self._raw_columns = [
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/selectable.py", line 5131, in <listcomp>
coercions.expect(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 413, in expect
resolved = impl._literal_coercion(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 651, in _literal_coercion
self._raise_for_expected(element, argname)
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 1139, in _raise_for_expected
return super()._raise_for_expected(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 710, in _raise_for_expected
super()._raise_for_expected(
File "/usr/share/miniconda3/envs/test/lib/python3.8/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 0x7f4924986f70; network>, <sqlalchemy.sql.elements.Label at 0x7f49249864f0; station>, <sqlalchemy.sql.elements.Label at 0x7f4924986fd0; location>, <sqlalchemy.sql.elements.Label at 0x7f4924986a00; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924986ca0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924986e20; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7f4924986f70; network>, <sqlalchemy.sql.elements.Label at 0x7f49249864f0; station>, <sqlalchemy.sql.elements.Label at 0x7f4924986fd0; location>, <sqlalchemy.sql.elements.Label at 0x7f4924986a00; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924986ca0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924986e20; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 174, in test_get_nslc
actual_nslc = client.get_nslc("I*,CU",
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 317, in get_nslc
summary_rows = self._get_summary_rows(network, station, location,
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 597, in _get_summary_rows
return self.request_handler._fetch_summary_rows(query_rows)
File "/usr/share/miniconda3/envs/test/lib/python3.8/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 0x7f4924986f70; network>, <sqlalchemy.sql.elements.Label at 0x7f49249864f0; station>, <sqlalchemy.sql.elements.Label at 0x7f4924986fd0; location>, <sqlalchemy.sql.elements.Label at 0x7f4924986a00; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924986ca0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924986e20; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7f4924986f70; network>, <sqlalchemy.sql.elements.Label at 0x7f49249864f0; station>, <sqlalchemy.sql.elements.Label at 0x7f4924986fd0; location>, <sqlalchemy.sql.elements.Label at 0x7f4924986a00; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924986ca0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924986e20; endtime>)?

Traceback (most recent call last):
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 1546, in _fetch_index_rows
stmts = [
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 1547, in <listcomp>
sa.select([
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/selectable.py", line 5130, in __init__
self._raw_columns = [
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/selectable.py", line 5131, in <listcomp>
coercions.expect(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 413, in expect
resolved = impl._literal_coercion(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 651, in _literal_coercion
self._raise_for_expected(element, argname)
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 1139, in _raise_for_expected
return super()._raise_for_expected(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 710, in _raise_for_expected
super()._raise_for_expected(
File "/usr/share/miniconda3/envs/test/lib/python3.8/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 0x7f4924988190; network>, <sqlalchemy.sql.elements.Label at 0x7f4924988670; station>, <sqlalchemy.sql.elements.Label at 0x7f4924988280; location>, <sqlalchemy.sql.elements.Label at 0x7f4924a99b80; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924a990d0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924a99d00; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7f4924988190; network>, <sqlalchemy.sql.elements.Label at 0x7f4924988670; station>, <sqlalchemy.sql.elements.Label at 0x7f4924988280; location>, <sqlalchemy.sql.elements.Label at 0x7f4924a99b80; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924a990d0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924a99d00; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 61, in test_get_waveforms
returned_stream = client.get_waveforms(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 262, in get_waveforms
return self._get_waveforms(query_rows, merge)
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 623, in _get_waveforms
index_rows = self.request_handler._fetch_index_rows(query_rows)
File "/usr/share/miniconda3/envs/test/lib/python3.8/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 0x7f4924988190; network>, <sqlalchemy.sql.elements.Label at 0x7f4924988670; station>, <sqlalchemy.sql.elements.Label at 0x7f4924988280; location>, <sqlalchemy.sql.elements.Label at 0x7f4924a99b80; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924a990d0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924a99d00; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7f4924988190; network>, <sqlalchemy.sql.elements.Label at 0x7f4924988670; station>, <sqlalchemy.sql.elements.Label at 0x7f4924988280; location>, <sqlalchemy.sql.elements.Label at 0x7f4924a99b80; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924a990d0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924a99d00; endtime>)?

Traceback (most recent call last):
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 1546, in _fetch_index_rows
stmts = [
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 1547, in <listcomp>
sa.select([
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/selectable.py", line 5130, in __init__
self._raw_columns = [
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/selectable.py", line 5131, in <listcomp>
coercions.expect(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 413, in expect
resolved = impl._literal_coercion(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 651, in _literal_coercion
self._raise_for_expected(element, argname)
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 1139, in _raise_for_expected
return super()._raise_for_expected(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 710, in _raise_for_expected
super()._raise_for_expected(
File "/usr/share/miniconda3/envs/test/lib/python3.8/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 0x7f4924982910; network>, <sqlalchemy.sql.elements.Label at 0x7f4924982cd0; station>, <sqlalchemy.sql.elements.Label at 0x7f492499ebe0; location>, <sqlalchemy.sql.elements.Label at 0x7f492499e670; channel>, <sqlalchemy.sql.elements.Label at 0x7f492499ecd0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f492499ed30; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7f4924982910; network>, <sqlalchemy.sql.elements.Label at 0x7f4924982cd0; station>, <sqlalchemy.sql.elements.Label at 0x7f492499ebe0; location>, <sqlalchemy.sql.elements.Label at 0x7f492499e670; channel>, <sqlalchemy.sql.elements.Label at 0x7f492499ecd0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f492499ed30; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/share/miniconda3/envs/test/lib/python3.8/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 "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 288, in get_waveforms_bulk
return self._get_waveforms(query_rows, merge)
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 623, in _get_waveforms
index_rows = self.request_handler._fetch_index_rows(query_rows)
File "/usr/share/miniconda3/envs/test/lib/python3.8/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 0x7f4924982910; network>, <sqlalchemy.sql.elements.Label at 0x7f4924982cd0; station>, <sqlalchemy.sql.elements.Label at 0x7f492499ebe0; location>, <sqlalchemy.sql.elements.Label at 0x7f492499e670; channel>, <sqlalchemy.sql.elements.Label at 0x7f492499ecd0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f492499ed30; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7f4924982910; network>, <sqlalchemy.sql.elements.Label at 0x7f4924982cd0; station>, <sqlalchemy.sql.elements.Label at 0x7f492499ebe0; location>, <sqlalchemy.sql.elements.Label at 0x7f492499e670; channel>, <sqlalchemy.sql.elements.Label at 0x7f492499ecd0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f492499ed30; endtime>)?

Traceback (most recent call last):
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 1546, in _fetch_index_rows
stmts = [
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 1547, in <listcomp>
sa.select([
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/selectable.py", line 5130, in __init__
self._raw_columns = [
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/selectable.py", line 5131, in <listcomp>
coercions.expect(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 413, in expect
resolved = impl._literal_coercion(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 651, in _literal_coercion
self._raise_for_expected(element, argname)
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 1139, in _raise_for_expected
return super()._raise_for_expected(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 710, in _raise_for_expected
super()._raise_for_expected(
File "/usr/share/miniconda3/envs/test/lib/python3.8/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 0x7f4924aa06d0; network>, <sqlalchemy.sql.elements.Label at 0x7f4924aa0250; station>, <sqlalchemy.sql.elements.Label at 0x7f4924a9bdf0; location>, <sqlalchemy.sql.elements.Label at 0x7f4924a9bd00; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924a9bee0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924a9b640; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7f4924aa06d0; network>, <sqlalchemy.sql.elements.Label at 0x7f4924aa0250; station>, <sqlalchemy.sql.elements.Label at 0x7f4924a9bdf0; location>, <sqlalchemy.sql.elements.Label at 0x7f4924a9bd00; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924a9bee0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924a9b640; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 580, in test_has_data
self.assertTrue(client.has_data())
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 558, in has_data
avail_percentage = self.get_availability_percentage(network,
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 494, in get_availability_percentage
avail = self.get_availability(network, station,
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 415, in get_availability
tsindex_rows = self._get_tsindex_rows(network, station,
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 679, in _get_tsindex_rows
return self.request_handler._fetch_index_rows(query_rows)
File "/usr/share/miniconda3/envs/test/lib/python3.8/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 0x7f4924aa06d0; network>, <sqlalchemy.sql.elements.Label at 0x7f4924aa0250; station>, <sqlalchemy.sql.elements.Label at 0x7f4924a9bdf0; location>, <sqlalchemy.sql.elements.Label at 0x7f4924a9bd00; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924a9bee0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924a9b640; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7f4924aa06d0; network>, <sqlalchemy.sql.elements.Label at 0x7f4924aa0250; station>, <sqlalchemy.sql.elements.Label at 0x7f4924a9bdf0; location>, <sqlalchemy.sql.elements.Label at 0x7f4924a9bd00; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924a9bee0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924a9b640; endtime>)?

Traceback (most recent call last):
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 1546, in _fetch_index_rows
stmts = [
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 1547, in <listcomp>
sa.select([
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/selectable.py", line 5130, in __init__
self._raw_columns = [
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/selectable.py", line 5131, in <listcomp>
coercions.expect(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 413, in expect
resolved = impl._literal_coercion(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 651, in _literal_coercion
self._raise_for_expected(element, argname)
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 1139, in _raise_for_expected
return super()._raise_for_expected(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 710, in _raise_for_expected
super()._raise_for_expected(
File "/usr/share/miniconda3/envs/test/lib/python3.8/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 0x7f4924988a60; network>, <sqlalchemy.sql.elements.Label at 0x7f49249883d0; station>, <sqlalchemy.sql.elements.Label at 0x7f4924988c40; location>, <sqlalchemy.sql.elements.Label at 0x7f4924988880; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924988040; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924988070; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7f4924988a60; network>, <sqlalchemy.sql.elements.Label at 0x7f49249883d0; station>, <sqlalchemy.sql.elements.Label at 0x7f4924988c40; location>, <sqlalchemy.sql.elements.Label at 0x7f4924988880; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924988040; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924988070; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 773, in test_build_file_list
self.assertRaisesRegex(OSError,
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 1357, in assertRaisesRegex
return context.handle('assertRaisesRegex', args, kwargs)
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 202, in handle
callable_obj(*args, **kwargs)
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 1064, in build_file_list
tsindex = self.request_handler._fetch_index_rows()
File "/usr/share/miniconda3/envs/test/lib/python3.8/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 0x7f4924988a60; network>, <sqlalchemy.sql.elements.Label at 0x7f49249883d0; station>, <sqlalchemy.sql.elements.Label at 0x7f4924988c40; location>, <sqlalchemy.sql.elements.Label at 0x7f4924988880; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924988040; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924988070; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7f4924988a60; network>, <sqlalchemy.sql.elements.Label at 0x7f49249883d0; station>, <sqlalchemy.sql.elements.Label at 0x7f4924988c40; location>, <sqlalchemy.sql.elements.Label at 0x7f4924988880; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924988040; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924988070; endtime>)?

Traceback (most recent call last):
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 1726, in _fetch_summary_rows
stmts = [
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/obspy/clients/filesystem/tsindex.py", line 1727, in <listcomp>
sa.select([
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/selectable.py", line 5130, in __init__
self._raw_columns = [
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/selectable.py", line 5131, in <listcomp>
coercions.expect(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 413, in expect
resolved = impl._literal_coercion(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 651, in _literal_coercion
self._raise_for_expected(element, argname)
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 1139, in _raise_for_expected
return super()._raise_for_expected(
File "/usr/share/miniconda3/envs/test/lib/python3.8/site-packages/sqlalchemy/sql/coercions.py", line 710, in _raise_for_expected
super()._raise_for_expected(
File "/usr/share/miniconda3/envs/test/lib/python3.8/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 0x7f492492b910; network>, <sqlalchemy.sql.elements.Label at 0x7f492492ba90; station>, <sqlalchemy.sql.elements.Label at 0x7f4924989fd0; location>, <sqlalchemy.sql.elements.Label at 0x7f4924989f40; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924989be0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924989d30; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7f492492b910; network>, <sqlalchemy.sql.elements.Label at 0x7f492492ba90; station>, <sqlalchemy.sql.elements.Label at 0x7f4924989fd0; location>, <sqlalchemy.sql.elements.Label at 0x7f4924989f40; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924989be0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924989d30; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 60, in testPartExecutor
yield
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 676, in run
self._callTestMethod(testMethod)
File "/usr/share/miniconda3/envs/test/lib/python3.8/unittest/case.py", line 633, in _callTestMethod
method()
File "/usr/share/miniconda3/envs/test/lib/python3.8/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 "/usr/share/miniconda3/envs/test/lib/python3.8/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 0x7f492492b910; network>, <sqlalchemy.sql.elements.Label at 0x7f492492ba90; station>, <sqlalchemy.sql.elements.Label at 0x7f4924989fd0; location>, <sqlalchemy.sql.elements.Label at 0x7f4924989f40; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924989be0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924989d30; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x7f492492b910; network>, <sqlalchemy.sql.elements.Label at 0x7f492492ba90; station>, <sqlalchemy.sql.elements.Label at 0x7f4924989fd0; location>, <sqlalchemy.sql.elements.Label at 0x7f4924989f40; channel>, <sqlalchemy.sql.elements.Label at 0x7f4924989be0; starttime>, <sqlalchemy.sql.elements.Label at 0x7f4924989d30; endtime>)?