#134462 Report by node kozel covering 2022 tests from 60 modules resulted into 20 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 0x165f644f0; network>, <sqlalchemy.sql.elements.Label at 0x165f648e0; station>, <sqlalchemy.sql.elements.Label at 0x165f64940; location>, <sqlalchemy.sql.elements.Label at 0x165f64bb0; channel>, <sqlalchemy.sql.elements.Label at 0x165f64c70; starttime>, <sqlalchemy.sql.elements.Label at 0x165f64cd0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x165f644f0; network>, <sqlalchemy.sql.elements.Label at 0x165f648e0; station>, <sqlalchemy.sql.elements.Label at 0x165f64940; location>, <sqlalchemy.sql.elements.Label at 0x165f64bb0; channel>, <sqlalchemy.sql.elements.Label at 0x165f64c70; starttime>, <sqlalchemy.sql.elements.Label at 0x165f64cd0; endtime>)?')
Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1726, in _fetch_summary_rows
stmts = [
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1727, in <listcomp>
sa.select([
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/selectable.py", line 5132, in __init__
self._raw_columns = [
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/selectable.py", line 5133, in <listcomp>
coercions.expect(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 413, in expect
resolved = impl._literal_coercion(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 652, in _literal_coercion
self._raise_for_expected(element, argname)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 1143, in _raise_for_expected
return super()._raise_for_expected(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 711, in _raise_for_expected
super()._raise_for_expected(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 536, 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 0x165f644f0; network>, <sqlalchemy.sql.elements.Label at 0x165f648e0; station>, <sqlalchemy.sql.elements.Label at 0x165f64940; location>, <sqlalchemy.sql.elements.Label at 0x165f64bb0; channel>, <sqlalchemy.sql.elements.Label at 0x165f64c70; starttime>, <sqlalchemy.sql.elements.Label at 0x165f64cd0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x165f644f0; network>, <sqlalchemy.sql.elements.Label at 0x165f648e0; station>, <sqlalchemy.sql.elements.Label at 0x165f64940; location>, <sqlalchemy.sql.elements.Label at 0x165f64bb0; channel>, <sqlalchemy.sql.elements.Label at 0x165f64c70; starttime>, <sqlalchemy.sql.elements.Label at 0x165f64cd0; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/doctest.py", line 1350, in __run
exec(compile(example.source, filename, "single",
File "<doctest obspy.clients.filesystem.tsindex[6]>", line 1, in <module>
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 358, in get_availability_extent
summary_rows = self._get_summary_rows(network, station,
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 597, in _get_summary_rows
return self.request_handler._fetch_summary_rows(query_rows)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/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 0x165f644f0; network>, <sqlalchemy.sql.elements.Label at 0x165f648e0; station>, <sqlalchemy.sql.elements.Label at 0x165f64940; location>, <sqlalchemy.sql.elements.Label at 0x165f64bb0; channel>, <sqlalchemy.sql.elements.Label at 0x165f64c70; starttime>, <sqlalchemy.sql.elements.Label at 0x165f64cd0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x165f644f0; network>, <sqlalchemy.sql.elements.Label at 0x165f648e0; station>, <sqlalchemy.sql.elements.Label at 0x165f64940; location>, <sqlalchemy.sql.elements.Label at 0x165f64bb0; channel>, <sqlalchemy.sql.elements.Label at 0x165f64c70; starttime>, <sqlalchemy.sql.elements.Label at 0x165f64cd0; endtime>)?
/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py:64: UnexpectedException

Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1546, in _fetch_index_rows
stmts = [
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1547, in <listcomp>
sa.select([
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/selectable.py", line 5132, in __init__
self._raw_columns = [
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/selectable.py", line 5133, in <listcomp>
coercions.expect(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 413, in expect
resolved = impl._literal_coercion(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 652, in _literal_coercion
self._raise_for_expected(element, argname)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 1143, in _raise_for_expected
return super()._raise_for_expected(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 711, in _raise_for_expected
super()._raise_for_expected(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 536, 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 0x1660fc250; network>, <sqlalchemy.sql.elements.Label at 0x1660fde70; station>, <sqlalchemy.sql.elements.Label at 0x1660fd480; location>, <sqlalchemy.sql.elements.Label at 0x1660ffe80; channel>, <sqlalchemy.sql.elements.Label at 0x1660fd690; starttime>, <sqlalchemy.sql.elements.Label at 0x1660fe830; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1660fc250; network>, <sqlalchemy.sql.elements.Label at 0x1660fde70; station>, <sqlalchemy.sql.elements.Label at 0x1660fd480; location>, <sqlalchemy.sql.elements.Label at 0x1660ffe80; channel>, <sqlalchemy.sql.elements.Label at 0x1660fd690; starttime>, <sqlalchemy.sql.elements.Label at 0x1660fe830; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 381, in test_get_availability
actual_avail = client.get_availability(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 415, in get_availability
tsindex_rows = self._get_tsindex_rows(network, station,
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 679, in _get_tsindex_rows
return self.request_handler._fetch_index_rows(query_rows)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/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 0x1660fc250; network>, <sqlalchemy.sql.elements.Label at 0x1660fde70; station>, <sqlalchemy.sql.elements.Label at 0x1660fd480; location>, <sqlalchemy.sql.elements.Label at 0x1660ffe80; channel>, <sqlalchemy.sql.elements.Label at 0x1660fd690; starttime>, <sqlalchemy.sql.elements.Label at 0x1660fe830; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1660fc250; network>, <sqlalchemy.sql.elements.Label at 0x1660fde70; station>, <sqlalchemy.sql.elements.Label at 0x1660fd480; location>, <sqlalchemy.sql.elements.Label at 0x1660ffe80; channel>, <sqlalchemy.sql.elements.Label at 0x1660fd690; starttime>, <sqlalchemy.sql.elements.Label at 0x1660fe830; endtime>)?

Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1726, in _fetch_summary_rows
stmts = [
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1727, in <listcomp>
sa.select([
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/selectable.py", line 5132, in __init__
self._raw_columns = [
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/selectable.py", line 5133, in <listcomp>
coercions.expect(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 413, in expect
resolved = impl._literal_coercion(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 652, in _literal_coercion
self._raise_for_expected(element, argname)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 1143, in _raise_for_expected
return super()._raise_for_expected(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 711, in _raise_for_expected
super()._raise_for_expected(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 536, 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 0x1660f7520; network>, <sqlalchemy.sql.elements.Label at 0x1660f7cd0; station>, <sqlalchemy.sql.elements.Label at 0x1660f6da0; location>, <sqlalchemy.sql.elements.Label at 0x1660f62c0; channel>, <sqlalchemy.sql.elements.Label at 0x1660f5f90; starttime>, <sqlalchemy.sql.elements.Label at 0x1660f7c10; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1660f7520; network>, <sqlalchemy.sql.elements.Label at 0x1660f7cd0; station>, <sqlalchemy.sql.elements.Label at 0x1660f6da0; location>, <sqlalchemy.sql.elements.Label at 0x1660f62c0; channel>, <sqlalchemy.sql.elements.Label at 0x1660f5f90; starttime>, <sqlalchemy.sql.elements.Label at 0x1660f7c10; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 236, in test_get_availability_extent
actual_avail_extents = client.get_availability_extent(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 358, in get_availability_extent
summary_rows = self._get_summary_rows(network, station,
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 597, in _get_summary_rows
return self.request_handler._fetch_summary_rows(query_rows)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/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 0x1660f7520; network>, <sqlalchemy.sql.elements.Label at 0x1660f7cd0; station>, <sqlalchemy.sql.elements.Label at 0x1660f6da0; location>, <sqlalchemy.sql.elements.Label at 0x1660f62c0; channel>, <sqlalchemy.sql.elements.Label at 0x1660f5f90; starttime>, <sqlalchemy.sql.elements.Label at 0x1660f7c10; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1660f7520; network>, <sqlalchemy.sql.elements.Label at 0x1660f7cd0; station>, <sqlalchemy.sql.elements.Label at 0x1660f6da0; location>, <sqlalchemy.sql.elements.Label at 0x1660f62c0; channel>, <sqlalchemy.sql.elements.Label at 0x1660f5f90; starttime>, <sqlalchemy.sql.elements.Label at 0x1660f7c10; endtime>)?

Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1726, in _fetch_summary_rows
stmts = [
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1727, in <listcomp>
sa.select([
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/selectable.py", line 5132, in __init__
self._raw_columns = [
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/selectable.py", line 5133, in <listcomp>
coercions.expect(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 413, in expect
resolved = impl._literal_coercion(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 652, in _literal_coercion
self._raise_for_expected(element, argname)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 1143, in _raise_for_expected
return super()._raise_for_expected(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 711, in _raise_for_expected
super()._raise_for_expected(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 536, 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 0x16614d960; network>, <sqlalchemy.sql.elements.Label at 0x16614fd00; station>, <sqlalchemy.sql.elements.Label at 0x16614d810; location>, <sqlalchemy.sql.elements.Label at 0x165f654e0; channel>, <sqlalchemy.sql.elements.Label at 0x165f65330; starttime>, <sqlalchemy.sql.elements.Label at 0x165f65cc0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x16614d960; network>, <sqlalchemy.sql.elements.Label at 0x16614fd00; station>, <sqlalchemy.sql.elements.Label at 0x16614d810; location>, <sqlalchemy.sql.elements.Label at 0x165f654e0; channel>, <sqlalchemy.sql.elements.Label at 0x165f65330; starttime>, <sqlalchemy.sql.elements.Label at 0x165f65cc0; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 175, in test_get_nslc
actual_nslc = client.get_nslc("I*,CU",
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 317, in get_nslc
summary_rows = self._get_summary_rows(network, station, location,
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 597, in _get_summary_rows
return self.request_handler._fetch_summary_rows(query_rows)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/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 0x16614d960; network>, <sqlalchemy.sql.elements.Label at 0x16614fd00; station>, <sqlalchemy.sql.elements.Label at 0x16614d810; location>, <sqlalchemy.sql.elements.Label at 0x165f654e0; channel>, <sqlalchemy.sql.elements.Label at 0x165f65330; starttime>, <sqlalchemy.sql.elements.Label at 0x165f65cc0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x16614d960; network>, <sqlalchemy.sql.elements.Label at 0x16614fd00; station>, <sqlalchemy.sql.elements.Label at 0x16614d810; location>, <sqlalchemy.sql.elements.Label at 0x165f654e0; channel>, <sqlalchemy.sql.elements.Label at 0x165f65330; starttime>, <sqlalchemy.sql.elements.Label at 0x165f65cc0; endtime>)?

Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1546, in _fetch_index_rows
stmts = [
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1547, in <listcomp>
sa.select([
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/selectable.py", line 5132, in __init__
self._raw_columns = [
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/selectable.py", line 5133, in <listcomp>
coercions.expect(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 413, in expect
resolved = impl._literal_coercion(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 652, in _literal_coercion
self._raise_for_expected(element, argname)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 1143, in _raise_for_expected
return super()._raise_for_expected(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 711, in _raise_for_expected
super()._raise_for_expected(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 536, 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 0x16614dcf0; network>, <sqlalchemy.sql.elements.Label at 0x16614c310; station>, <sqlalchemy.sql.elements.Label at 0x16614f5e0; location>, <sqlalchemy.sql.elements.Label at 0x16614df60; channel>, <sqlalchemy.sql.elements.Label at 0x16614f4f0; starttime>, <sqlalchemy.sql.elements.Label at 0x16614cac0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x16614dcf0; network>, <sqlalchemy.sql.elements.Label at 0x16614c310; station>, <sqlalchemy.sql.elements.Label at 0x16614f5e0; location>, <sqlalchemy.sql.elements.Label at 0x16614df60; channel>, <sqlalchemy.sql.elements.Label at 0x16614f4f0; starttime>, <sqlalchemy.sql.elements.Label at 0x16614cac0; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 62, in test_get_waveforms
returned_stream = client.get_waveforms(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 262, in get_waveforms
return self._get_waveforms(query_rows, merge)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 623, in _get_waveforms
index_rows = self.request_handler._fetch_index_rows(query_rows)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/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 0x16614dcf0; network>, <sqlalchemy.sql.elements.Label at 0x16614c310; station>, <sqlalchemy.sql.elements.Label at 0x16614f5e0; location>, <sqlalchemy.sql.elements.Label at 0x16614df60; channel>, <sqlalchemy.sql.elements.Label at 0x16614f4f0; starttime>, <sqlalchemy.sql.elements.Label at 0x16614cac0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x16614dcf0; network>, <sqlalchemy.sql.elements.Label at 0x16614c310; station>, <sqlalchemy.sql.elements.Label at 0x16614f5e0; location>, <sqlalchemy.sql.elements.Label at 0x16614df60; channel>, <sqlalchemy.sql.elements.Label at 0x16614f4f0; starttime>, <sqlalchemy.sql.elements.Label at 0x16614cac0; endtime>)?

Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1546, in _fetch_index_rows
stmts = [
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1547, in <listcomp>
sa.select([
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/selectable.py", line 5132, in __init__
self._raw_columns = [
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/selectable.py", line 5133, in <listcomp>
coercions.expect(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 413, in expect
resolved = impl._literal_coercion(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 652, in _literal_coercion
self._raise_for_expected(element, argname)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 1143, in _raise_for_expected
return super()._raise_for_expected(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 711, in _raise_for_expected
super()._raise_for_expected(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 536, 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 0x16614e8f0; network>, <sqlalchemy.sql.elements.Label at 0x16614d330; station>, <sqlalchemy.sql.elements.Label at 0x16614cf40; location>, <sqlalchemy.sql.elements.Label at 0x1661217e0; channel>, <sqlalchemy.sql.elements.Label at 0x166123a90; starttime>, <sqlalchemy.sql.elements.Label at 0x166123940; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x16614e8f0; network>, <sqlalchemy.sql.elements.Label at 0x16614d330; station>, <sqlalchemy.sql.elements.Label at 0x16614cf40; location>, <sqlalchemy.sql.elements.Label at 0x1661217e0; channel>, <sqlalchemy.sql.elements.Label at 0x166123a90; starttime>, <sqlalchemy.sql.elements.Label at 0x166123940; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/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 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 288, in get_waveforms_bulk
return self._get_waveforms(query_rows, merge)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 623, in _get_waveforms
index_rows = self.request_handler._fetch_index_rows(query_rows)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/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 0x16614e8f0; network>, <sqlalchemy.sql.elements.Label at 0x16614d330; station>, <sqlalchemy.sql.elements.Label at 0x16614cf40; location>, <sqlalchemy.sql.elements.Label at 0x1661217e0; channel>, <sqlalchemy.sql.elements.Label at 0x166123a90; starttime>, <sqlalchemy.sql.elements.Label at 0x166123940; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x16614e8f0; network>, <sqlalchemy.sql.elements.Label at 0x16614d330; station>, <sqlalchemy.sql.elements.Label at 0x16614cf40; location>, <sqlalchemy.sql.elements.Label at 0x1661217e0; channel>, <sqlalchemy.sql.elements.Label at 0x166123a90; starttime>, <sqlalchemy.sql.elements.Label at 0x166123940; endtime>)?

Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1546, in _fetch_index_rows
stmts = [
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1547, in <listcomp>
sa.select([
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/selectable.py", line 5132, in __init__
self._raw_columns = [
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/selectable.py", line 5133, in <listcomp>
coercions.expect(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 413, in expect
resolved = impl._literal_coercion(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 652, in _literal_coercion
self._raise_for_expected(element, argname)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 1143, in _raise_for_expected
return super()._raise_for_expected(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 711, in _raise_for_expected
super()._raise_for_expected(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 536, 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 0x1660f47f0; network>, <sqlalchemy.sql.elements.Label at 0x1660f5120; station>, <sqlalchemy.sql.elements.Label at 0x1660f72e0; location>, <sqlalchemy.sql.elements.Label at 0x1660f5bd0; channel>, <sqlalchemy.sql.elements.Label at 0x1660f40a0; starttime>, <sqlalchemy.sql.elements.Label at 0x1660f5db0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1660f47f0; network>, <sqlalchemy.sql.elements.Label at 0x1660f5120; station>, <sqlalchemy.sql.elements.Label at 0x1660f72e0; location>, <sqlalchemy.sql.elements.Label at 0x1660f5bd0; channel>, <sqlalchemy.sql.elements.Label at 0x1660f40a0; starttime>, <sqlalchemy.sql.elements.Label at 0x1660f5db0; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 581, in test_has_data
self.assertTrue(client.has_data())
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 558, in has_data
avail_percentage = self.get_availability_percentage(network,
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 494, in get_availability_percentage
avail = self.get_availability(network, station,
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 415, in get_availability
tsindex_rows = self._get_tsindex_rows(network, station,
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 679, in _get_tsindex_rows
return self.request_handler._fetch_index_rows(query_rows)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/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 0x1660f47f0; network>, <sqlalchemy.sql.elements.Label at 0x1660f5120; station>, <sqlalchemy.sql.elements.Label at 0x1660f72e0; location>, <sqlalchemy.sql.elements.Label at 0x1660f5bd0; channel>, <sqlalchemy.sql.elements.Label at 0x1660f40a0; starttime>, <sqlalchemy.sql.elements.Label at 0x1660f5db0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x1660f47f0; network>, <sqlalchemy.sql.elements.Label at 0x1660f5120; station>, <sqlalchemy.sql.elements.Label at 0x1660f72e0; location>, <sqlalchemy.sql.elements.Label at 0x1660f5bd0; channel>, <sqlalchemy.sql.elements.Label at 0x1660f40a0; starttime>, <sqlalchemy.sql.elements.Label at 0x1660f5db0; endtime>)?

Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 705, in test__get_leap_seconds_file
open(test_file, 'a').close()
PermissionError: [Errno 13] Permission denied: '/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tests/data/tsindex_data/leap-seconds.list'

Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1546, in _fetch_index_rows
stmts = [
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1547, in <listcomp>
sa.select([
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/selectable.py", line 5132, in __init__
self._raw_columns = [
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/selectable.py", line 5133, in <listcomp>
coercions.expect(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 413, in expect
resolved = impl._literal_coercion(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 652, in _literal_coercion
self._raise_for_expected(element, argname)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 1143, in _raise_for_expected
return super()._raise_for_expected(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 711, in _raise_for_expected
super()._raise_for_expected(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 536, 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 0x16614d4e0; network>, <sqlalchemy.sql.elements.Label at 0x16614ecb0; station>, <sqlalchemy.sql.elements.Label at 0x16614e8f0; location>, <sqlalchemy.sql.elements.Label at 0x16614e950; channel>, <sqlalchemy.sql.elements.Label at 0x16614ff10; starttime>, <sqlalchemy.sql.elements.Label at 0x16614eef0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x16614d4e0; network>, <sqlalchemy.sql.elements.Label at 0x16614ecb0; station>, <sqlalchemy.sql.elements.Label at 0x16614e8f0; location>, <sqlalchemy.sql.elements.Label at 0x16614e950; channel>, <sqlalchemy.sql.elements.Label at 0x16614ff10; starttime>, <sqlalchemy.sql.elements.Label at 0x16614eef0; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 770, in test_build_file_list
self.assertRaisesRegex(OSError,
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/unittest/case.py", line 1291, in assertRaisesRegex
return context.handle('assertRaisesRegex', args, kwargs)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/unittest/case.py", line 201, in handle
callable_obj(*args, **kwargs)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1064, in build_file_list
tsindex = self.request_handler._fetch_index_rows()
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/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 0x16614d4e0; network>, <sqlalchemy.sql.elements.Label at 0x16614ecb0; station>, <sqlalchemy.sql.elements.Label at 0x16614e8f0; location>, <sqlalchemy.sql.elements.Label at 0x16614e950; channel>, <sqlalchemy.sql.elements.Label at 0x16614ff10; starttime>, <sqlalchemy.sql.elements.Label at 0x16614eef0; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x16614d4e0; network>, <sqlalchemy.sql.elements.Label at 0x16614ecb0; station>, <sqlalchemy.sql.elements.Label at 0x16614e8f0; location>, <sqlalchemy.sql.elements.Label at 0x16614e950; channel>, <sqlalchemy.sql.elements.Label at 0x16614ff10; starttime>, <sqlalchemy.sql.elements.Label at 0x16614eef0; endtime>)?

Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1131, in download_leap_seconds_file
with open(file_path, "w") as fh:
PermissionError: [Errno 13] Permission denied: '/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tests/data/tsindex_data/leap-seconds.list'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 656, in test_download_leap_seconds_file
file_path = indexer.download_leap_seconds_file(test_file)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1134, in download_leap_seconds_file
raise OSError("Failed to create leap seconds file at {} due to {}."
OSError: Failed to create leap seconds file at /opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tests/data/tsindex_data/leap-seconds.list due to [Errno 13] Permission denied: '/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tests/data/tsindex_data/leap-seconds.list'.

Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1131, in download_leap_seconds_file
with open(file_path, "w") as fh:
PermissionError: [Errno 13] Permission denied: '/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tests/data/tsindex_data/leap-seconds.list'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 671, in test_download_leap_seconds_file_no_path_given
file_path = indexer.download_leap_seconds_file()
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1134, in download_leap_seconds_file
raise OSError("Failed to create leap seconds file at {} due to {}."
OSError: Failed to create leap seconds file at /opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tests/data/tsindex_data/leap-seconds.list due to [Errno 13] Permission denied: '/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tests/data/tsindex_data/leap-seconds.list'.

Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1726, in _fetch_summary_rows
stmts = [
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tsindex.py", line 1727, in <listcomp>
sa.select([
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/_selectable_constructors.py", line 489, in select
return Select(*entities)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/selectable.py", line 5132, in __init__
self._raw_columns = [
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/selectable.py", line 5133, in <listcomp>
coercions.expect(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 413, in expect
resolved = impl._literal_coercion(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 652, in _literal_coercion
self._raise_for_expected(element, argname)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 1143, in _raise_for_expected
return super()._raise_for_expected(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 711, in _raise_for_expected
super()._raise_for_expected(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/sqlalchemy/sql/coercions.py", line 536, 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 0x165f67c40; network>, <sqlalchemy.sql.elements.Label at 0x165f67be0; station>, <sqlalchemy.sql.elements.Label at 0x165f66320; location>, <sqlalchemy.sql.elements.Label at 0x165f66da0; channel>, <sqlalchemy.sql.elements.Label at 0x165f65750; starttime>, <sqlalchemy.sql.elements.Label at 0x165f66500; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x165f67c40; network>, <sqlalchemy.sql.elements.Label at 0x165f67be0; station>, <sqlalchemy.sql.elements.Label at 0x165f66320; location>, <sqlalchemy.sql.elements.Label at 0x165f66da0; channel>, <sqlalchemy.sql.elements.Label at 0x165f65750; starttime>, <sqlalchemy.sql.elements.Label at 0x165f66500; endtime>)?
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/clients/filesystem/tests/test_tsindex.py", line 916, in test__fetch_summary_rows
ts_summary_data = request_handler._fetch_summary_rows(
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/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 0x165f67c40; network>, <sqlalchemy.sql.elements.Label at 0x165f67be0; station>, <sqlalchemy.sql.elements.Label at 0x165f66320; location>, <sqlalchemy.sql.elements.Label at 0x165f66da0; channel>, <sqlalchemy.sql.elements.Label at 0x165f65750; starttime>, <sqlalchemy.sql.elements.Label at 0x165f66500; endtime>]. Did you mean to say select(<sqlalchemy.sql.elements.Label at 0x165f67c40; network>, <sqlalchemy.sql.elements.Label at 0x165f67be0; station>, <sqlalchemy.sql.elements.Label at 0x165f66320; location>, <sqlalchemy.sql.elements.Label at 0x165f66da0; channel>, <sqlalchemy.sql.elements.Label at 0x165f65750; starttime>, <sqlalchemy.sql.elements.Label at 0x165f66500; endtime>)?

Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/core/tests/test_event.py", line 120, in test_plot_farfield_without_quiver_with_maps
ev.plot(kind=[['global'], ['ortho', 'beachball'],
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/core/event/event.py", line 257, in plot
fig, axes, kind_ = _setup_figure_and_axes(kind,
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/imaging/source.py", line 72, in _setup_figure_and_axes
import cartopy.crs as ccrs
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/cartopy/__init__.py", line 107, in <module>
import cartopy.crs # noqa: E402 module-level imports
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/cartopy/crs.py", line 27, in <module>
import cartopy.trace
File "lib/cartopy/trace.pyx", line 56, in init cartopy.trace
ImportError: cannot import name lgeos

Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/core/tests/test_inventory.py", line 699, in test_location_plot_global
inv.plot(method='cartopy', outfile=image_path)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/core/inventory/inventory.py", line 965, in plot
from obspy.imaging.maps import plot_map
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/imaging/maps.py", line 28, in <module>
import cartopy
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/cartopy/__init__.py", line 107, in <module>
import cartopy.crs # noqa: E402 module-level imports
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/cartopy/crs.py", line 27, in <module>
import cartopy.trace
File "lib/cartopy/trace.pyx", line 56, in init cartopy.trace
ImportError: cannot import name lgeos

Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/core/tests/test_inventory.py", line 707, in test_location_plot_ortho
inv.plot(method='cartopy', projection='ortho', resolution='c',
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/core/inventory/inventory.py", line 965, in plot
from obspy.imaging.maps import plot_map
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/imaging/maps.py", line 28, in <module>
import cartopy
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/cartopy/__init__.py", line 107, in <module>
import cartopy.crs # noqa: E402 module-level imports
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/cartopy/crs.py", line 27, in <module>
import cartopy.trace
File "lib/cartopy/trace.pyx", line 56, in init cartopy.trace
ImportError: cannot import name lgeos

Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/core/tests/test_inventory.py", line 717, in test_location_plot_local
inv.plot(method='cartopy', projection='local', resolution='50m',
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/core/inventory/inventory.py", line 965, in plot
from obspy.imaging.maps import plot_map
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/imaging/maps.py", line 28, in <module>
import cartopy
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/cartopy/__init__.py", line 107, in <module>
import cartopy.crs # noqa: E402 module-level imports
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/cartopy/crs.py", line 27, in <module>
import cartopy.trace
File "lib/cartopy/trace.pyx", line 56, in init cartopy.trace
ImportError: cannot import name lgeos

Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/core/tests/test_inventory.py", line 728, in test_combined_station_event_plot
fig = inv.plot(show=False)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/core/inventory/inventory.py", line 965, in plot
from obspy.imaging.maps import plot_map
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/imaging/maps.py", line 28, in <module>
import cartopy
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/cartopy/__init__.py", line 107, in <module>
import cartopy.crs # noqa: E402 module-level imports
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/cartopy/crs.py", line 27, in <module>
import cartopy.trace
File "lib/cartopy/trace.pyx", line 56, in init cartopy.trace
ImportError: cannot import name lgeos

Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/core/tests/test_network.py", line 324, in test_location_plot_global
net.plot(method='cartopy', outfile=image_path)
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/core/inventory/network.py", line 605, in plot
from obspy.imaging.maps import plot_map
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/imaging/maps.py", line 28, in <module>
import cartopy
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/cartopy/__init__.py", line 107, in <module>
import cartopy.crs # noqa: E402 module-level imports
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/cartopy/crs.py", line 27, in <module>
import cartopy.trace
File "lib/cartopy/trace.pyx", line 56, in init cartopy.trace
ImportError: cannot import name lgeos

Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/core/tests/test_network.py", line 332, in test_location_plot_ortho
net.plot(method='cartopy', projection='ortho', resolution='c',
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/core/inventory/network.py", line 605, in plot
from obspy.imaging.maps import plot_map
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/imaging/maps.py", line 28, in <module>
import cartopy
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/cartopy/__init__.py", line 107, in <module>
import cartopy.crs # noqa: E402 module-level imports
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/cartopy/crs.py", line 27, in <module>
import cartopy.trace
File "lib/cartopy/trace.pyx", line 56, in init cartopy.trace
ImportError: cannot import name lgeos

Traceback (most recent call last):
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/core/tests/test_network.py", line 342, in test_location_plot_local
net.plot(method='cartopy', projection='local', resolution='50m',
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/core/inventory/network.py", line 605, in plot
from obspy.imaging.maps import plot_map
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/obspy/imaging/maps.py", line 28, in <module>
import cartopy
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/cartopy/__init__.py", line 107, in <module>
import cartopy.crs # noqa: E402 module-level imports
File "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/cartopy/crs.py", line 27, in <module>
import cartopy.trace
File "lib/cartopy/trace.pyx", line 56, in init cartopy.trace
ImportError: cannot import name lgeos