Skip to content

Instantly share code, notes, and snippets.

@epifanio
Created June 18, 2021 16:43
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save epifanio/852b57c58ba497fcc6dbb55919169218 to your computer and use it in GitHub Desktop.
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 2070, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1515, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1513, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1499, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)
File "/home/pycsw/pycsw/pycsw/wsgi_flask.py", line 162, in item
return get_response(api_.item(dict(request.headers), request.args, item))
File "/home/pycsw/pycsw/pycsw/ogc/api/records.py", line 579, in item
record = self.repository.query_ids([item])[0]
File "/home/pycsw/pycsw/pycsw/core/repository.py", line 238, in query_ids
return self._get_repo_filter(query).all()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2699, in all
return self._iter().all()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2834, in _iter
result = self.session.execute(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1689, in execute
result = conn._execute_20(statement, params or {}, execution_options)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1582, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 324, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1451, in _execute_clauseelement
ret = self._execute_context(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1813, in _execute_context
self._handle_dbapi_exception(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1994, in _handle_dbapi_exception
util.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1770, in _execute_context
self.dialect.do_execute(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
[SQL: SELECT nbs_records.identifier AS nbs_records_identifier, nbs_records.typename AS nbs_records_typename, nbs_records.schema AS nbs_records_schema, nbs_records.mdsource AS nbs_records_mdsource, nbs_records.insert_date AS nbs_records_insert_date, nbs_records.xml AS nbs_records_xml, nbs_records.anytext AS nbs_records_anytext, nbs_records.metadata AS nbs_records_metadata, nbs_records.metadata_type AS nbs_records_metadata_type, nbs_records.language AS nbs_records_language, nbs_records.type AS nbs_records_type, nbs_records.title AS nbs_records_title, nbs_records.title_alternate AS nbs_records_title_alternate, nbs_records.abstract AS nbs_records_abstract, nbs_records.keywords AS nbs_records_keywords, nbs_records.keywordstype AS nbs_records_keywordstype, nbs_records.parentidentifier AS nbs_records_parentidentifier, nbs_records.relation AS nbs_records_relation, nbs_records.time_begin AS nbs_records_time_begin, nbs_records.time_end AS nbs_records_time_end, nbs_records.topicategory AS nbs_records_topicategory, nbs_records.resourcelanguage AS nbs_records_resourcelanguage, nbs_records.creator AS nbs_records_creator, nbs_records.publisher AS nbs_records_publisher, nbs_records.contributor AS nbs_records_contributor, nbs_records.organization AS nbs_records_organization, nbs_records.distributor AS nbs_records_distributor, nbs_records.securityconstraints AS nbs_records_securityconstraints, nbs_records.accessconstraints AS nbs_records_accessconstraints, nbs_records.useconstraints AS nbs_records_useconstraints, nbs_records.otherconstraints AS nbs_records_otherconstraints, nbs_records.date AS nbs_records_date, nbs_records.date_revision AS nbs_records_date_revision, nbs_records.date_creation AS nbs_records_date_creation, nbs_records.date_publication AS nbs_records_date_publication, nbs_records.date_modified AS nbs_records_date_modified, nbs_records.format AS nbs_records_format, nbs_records.source AS nbs_records_source, nbs_records.crs AS nbs_records_crs, nbs_records.geodescode AS nbs_records_geodescode, nbs_records.denominator AS nbs_records_denominator, nbs_records.distancevalue AS nbs_records_distancevalue, nbs_records.distanceuom AS nbs_records_distanceuom, nbs_records.wkt_geometry AS nbs_records_wkt_geometry, nbs_records.servicetype AS nbs_records_servicetype, nbs_records.servicetypeversion AS nbs_records_servicetypeversion, nbs_records.operation AS nbs_records_operation, nbs_records.couplingtype AS nbs_records_couplingtype, nbs_records.operateson AS nbs_records_operateson, nbs_records.operatesonidentifier AS nbs_records_operatesonidentifier, nbs_records.operatesoname AS nbs_records_operatesoname, nbs_records.degree AS nbs_records_degree, nbs_records.classification AS nbs_records_classification, nbs_records.conditionapplyingtoaccessanduse AS nbs_records_conditionapplyingtoaccessanduse, nbs_records.lineage AS nbs_records_lineage, nbs_records.responsiblepartyrole AS nbs_records_responsiblepartyrole, nbs_records.specificationtitle AS nbs_records_specificationtitle, nbs_records.specificationdate AS nbs_records_specificationdate, nbs_records.specificationdatetype AS nbs_records_specificationdatetype, nbs_records.platform AS nbs_records_platform, nbs_records.instrument AS nbs_records_instrument, nbs_records.sensortype AS nbs_records_sensortype, nbs_records.cloudcover AS nbs_records_cloudcover, nbs_records.bands AS nbs_records_bands, nbs_records.links AS nbs_records_links, nbs_records.anytext_tsvector AS nbs_records_anytext_tsvector, nbs_records.wkb_geometry AS nbs_records_wkb_geometry
FROM nbs_records
WHERE nbs_records.identifier IN (%(identifier_1_1)s)]
[parameters: {'identifier_1_1': 'S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E'}]
(Background on this error at: http://sqlalche.me/e/14/e3q8)
Fri, 18 Jun 2021 16:36:55] [DEBUG] file=/home/pycsw/pycsw/pycsw/ogc/api/records.py line=577 module=records function=item Querying repository for item S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E
Fri, 18 Jun 2021 16:36:55] [ERROR] file=/usr/local/lib/python3.8/site-packages/flask/app.py line=1454 module=app function=log_exception Exception on /collections/metadata:main/items/S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E [GET]
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1770, in _execute_context
self.dialect.do_execute(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute
cursor.execute(statement, parameters)
psycopg2.OperationalError: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 2070, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1515, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1513, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1499, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)
File "/home/pycsw/pycsw/pycsw/wsgi_flask.py", line 162, in item
return get_response(api_.item(dict(request.headers), request.args, item))
File "/home/pycsw/pycsw/pycsw/ogc/api/records.py", line 579, in item
record = self.repository.query_ids([item])[0]
File "/home/pycsw/pycsw/pycsw/core/repository.py", line 238, in query_ids
return self._get_repo_filter(query).all()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2699, in all
return self._iter().all()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2834, in _iter
result = self.session.execute(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1689, in execute
result = conn._execute_20(statement, params or {}, execution_options)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1582, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 324, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1451, in _execute_clauseelement
ret = self._execute_context(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1813, in _execute_context
self._handle_dbapi_exception(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1994, in _handle_dbapi_exception
util.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1770, in _execute_context
self.dialect.do_execute(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
[SQL: SELECT nbs_records.identifier AS nbs_records_identifier, nbs_records.typename AS nbs_records_typename, nbs_records.schema AS nbs_records_schema, nbs_records.mdsource AS nbs_records_mdsource, nbs_records.insert_date AS nbs_records_insert_date, nbs_records.xml AS nbs_records_xml, nbs_records.anytext AS nbs_records_anytext, nbs_records.metadata AS nbs_records_metadata, nbs_records.metadata_type AS nbs_records_metadata_type, nbs_records.language AS nbs_records_language, nbs_records.type AS nbs_records_type, nbs_records.title AS nbs_records_title, nbs_records.title_alternate AS nbs_records_title_alternate, nbs_records.abstract AS nbs_records_abstract, nbs_records.keywords AS nbs_records_keywords, nbs_records.keywordstype AS nbs_records_keywordstype, nbs_records.parentidentifier AS nbs_records_parentidentifier, nbs_records.relation AS nbs_records_relation, nbs_records.time_begin AS nbs_records_time_begin, nbs_records.time_end AS nbs_records_time_end, nbs_records.topicategory AS nbs_records_topicategory, nbs_records.resourcelanguage AS nbs_records_resourcelanguage, nbs_records.creator AS nbs_records_creator, nbs_records.publisher AS nbs_records_publisher, nbs_records.contributor AS nbs_records_contributor, nbs_records.organization AS nbs_records_organization, nbs_records.distributor AS nbs_records_distributor, nbs_records.securityconstraints AS nbs_records_securityconstraints, nbs_records.accessconstraints AS nbs_records_accessconstraints, nbs_records.useconstraints AS nbs_records_useconstraints, nbs_records.otherconstraints AS nbs_records_otherconstraints, nbs_records.date AS nbs_records_date, nbs_records.date_revision AS nbs_records_date_revision, nbs_records.date_creation AS nbs_records_date_creation, nbs_records.date_publication AS nbs_records_date_publication, nbs_records.date_modified AS nbs_records_date_modified, nbs_records.format AS nbs_records_format, nbs_records.source AS nbs_records_source, nbs_records.crs AS nbs_records_crs, nbs_records.geodescode AS nbs_records_geodescode, nbs_records.denominator AS nbs_records_denominator, nbs_records.distancevalue AS nbs_records_distancevalue, nbs_records.distanceuom AS nbs_records_distanceuom, nbs_records.wkt_geometry AS nbs_records_wkt_geometry, nbs_records.servicetype AS nbs_records_servicetype, nbs_records.servicetypeversion AS nbs_records_servicetypeversion, nbs_records.operation AS nbs_records_operation, nbs_records.couplingtype AS nbs_records_couplingtype, nbs_records.operateson AS nbs_records_operateson, nbs_records.operatesonidentifier AS nbs_records_operatesonidentifier, nbs_records.operatesoname AS nbs_records_operatesoname, nbs_records.degree AS nbs_records_degree, nbs_records.classification AS nbs_records_classification, nbs_records.conditionapplyingtoaccessanduse AS nbs_records_conditionapplyingtoaccessanduse, nbs_records.lineage AS nbs_records_lineage, nbs_records.responsiblepartyrole AS nbs_records_responsiblepartyrole, nbs_records.specificationtitle AS nbs_records_specificationtitle, nbs_records.specificationdate AS nbs_records_specificationdate, nbs_records.specificationdatetype AS nbs_records_specificationdatetype, nbs_records.platform AS nbs_records_platform, nbs_records.instrument AS nbs_records_instrument, nbs_records.sensortype AS nbs_records_sensortype, nbs_records.cloudcover AS nbs_records_cloudcover, nbs_records.bands AS nbs_records_bands, nbs_records.links AS nbs_records_links, nbs_records.anytext_tsvector AS nbs_records_anytext_tsvector, nbs_records.wkb_geometry AS nbs_records_wkb_geometry
FROM nbs_records
WHERE nbs_records.identifier IN (%(identifier_1_1)s)]
[parameters: {'identifier_1_1': 'S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E'}]
(Background on this error at: http://sqlalche.me/e/14/e3q8)
Fri, 18 Jun 2021 16:36:56] [DEBUG] file=/home/pycsw/pycsw/pycsw/ogc/api/records.py line=577 module=records function=item Querying repository for item S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E
Fri, 18 Jun 2021 16:36:56] [DEBUG] file=/home/pycsw/pycsw/pycsw/core/util.py line=402 module=util function=jsonify_links JSON link
Fri, 18 Jun 2021 16:36:56] [DEBUG] file=/home/pycsw/pycsw/pycsw/ogc/api/util.py line=181 module=util function=render_j2_template using default templates: /home/pycsw/pycsw/pycsw/ogc/api/templates
Fri, 18 Jun 2021 16:37:40] [DEBUG] file=/home/pycsw/pycsw/pycsw/ogc/api/records.py line=577 module=records function=item Querying repository for item S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E
Fri, 18 Jun 2021 16:37:40] [ERROR] file=/usr/local/lib/python3.8/site-packages/flask/app.py line=1454 module=app function=log_exception Exception on /collections/metadata:main/items/S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E [GET]
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3211, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 307, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 767, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 430, in checkout
rec._checkin_failed(err, _fairy_was_created=False)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 427, in checkout
dbapi_connection = rec.get_connection()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 552, in get_connection
self.__connect()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 611, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 605, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/create.py", line 578, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 584, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL: sorry, too many clients already
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 2070, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1515, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1513, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1499, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)
File "/home/pycsw/pycsw/pycsw/wsgi_flask.py", line 162, in item
return get_response(api_.item(dict(request.headers), request.args, item))
File "/home/pycsw/pycsw/pycsw/ogc/api/records.py", line 579, in item
record = self.repository.query_ids([item])[0]
File "/home/pycsw/pycsw/pycsw/core/repository.py", line 238, in query_ids
return self._get_repo_filter(query).all()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2699, in all
return self._iter().all()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2834, in _iter
result = self.session.execute(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1683, in execute
conn = self._connection_for_bind(bind, close_with_result=True)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1535, in _connection_for_bind
conn = engine.connect(**kw)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3165, in connect
return self._connection_cls(self, close_with_result=close_with_result)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 96, in __init__
else engine.raw_connection()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3244, in raw_connection
return self._wrap_pool_connect(self.pool.connect, _connection)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3214, in _wrap_pool_connect
Connection._handle_dbapi_exception_noconnection(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2068, in _handle_dbapi_exception_noconnection
util.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3211, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 307, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 767, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 430, in checkout
rec._checkin_failed(err, _fairy_was_created=False)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 427, in checkout
dbapi_connection = rec.get_connection()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 552, in get_connection
self.__connect()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 611, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 605, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/create.py", line 578, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 584, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) FATAL: sorry, too many clients already
(Background on this error at: http://sqlalche.me/e/14/e3q8)
Fri, 18 Jun 2021 16:37:43] [DEBUG] file=/home/pycsw/pycsw/pycsw/ogc/api/records.py line=577 module=records function=item Querying repository for item S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E
Fri, 18 Jun 2021 16:37:43] [ERROR] file=/usr/local/lib/python3.8/site-packages/flask/app.py line=1454 module=app function=log_exception Exception on /collections/metadata:main/items/S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E [GET]
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3211, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 307, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 767, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 430, in checkout
rec._checkin_failed(err, _fairy_was_created=False)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 427, in checkout
dbapi_connection = rec.get_connection()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 552, in get_connection
self.__connect()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 611, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 605, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/create.py", line 578, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 584, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL: sorry, too many clients already
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 2070, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1515, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1513, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1499, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)
File "/home/pycsw/pycsw/pycsw/wsgi_flask.py", line 162, in item
return get_response(api_.item(dict(request.headers), request.args, item))
File "/home/pycsw/pycsw/pycsw/ogc/api/records.py", line 579, in item
record = self.repository.query_ids([item])[0]
File "/home/pycsw/pycsw/pycsw/core/repository.py", line 238, in query_ids
return self._get_repo_filter(query).all()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2699, in all
return self._iter().all()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2834, in _iter
result = self.session.execute(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1683, in execute
conn = self._connection_for_bind(bind, close_with_result=True)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1535, in _connection_for_bind
conn = engine.connect(**kw)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3165, in connect
return self._connection_cls(self, close_with_result=close_with_result)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 96, in __init__
else engine.raw_connection()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3244, in raw_connection
return self._wrap_pool_connect(self.pool.connect, _connection)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3214, in _wrap_pool_connect
Connection._handle_dbapi_exception_noconnection(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2068, in _handle_dbapi_exception_noconnection
util.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3211, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 307, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 767, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 430, in checkout
rec._checkin_failed(err, _fairy_was_created=False)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 427, in checkout
dbapi_connection = rec.get_connection()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 552, in get_connection
self.__connect()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 611, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 605, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/create.py", line 578, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 584, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) FATAL: sorry, too many clients already
(Background on this error at: http://sqlalche.me/e/14/e3q8)
Fri, 18 Jun 2021 16:37:44] [DEBUG] file=/home/pycsw/pycsw/pycsw/ogc/api/records.py line=577 module=records function=item Querying repository for item S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E
Fri, 18 Jun 2021 16:37:44] [ERROR] file=/usr/local/lib/python3.8/site-packages/flask/app.py line=1454 module=app function=log_exception Exception on /collections/metadata:main/items/S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E [GET]
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3211, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 307, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 767, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 430, in checkout
rec._checkin_failed(err, _fairy_was_created=False)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 427, in checkout
dbapi_connection = rec.get_connection()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 552, in get_connection
self.__connect()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 611, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 605, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/create.py", line 578, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 584, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL: sorry, too many clients already
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 2070, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1515, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1513, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1499, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)
File "/home/pycsw/pycsw/pycsw/wsgi_flask.py", line 162, in item
return get_response(api_.item(dict(request.headers), request.args, item))
File "/home/pycsw/pycsw/pycsw/ogc/api/records.py", line 579, in item
record = self.repository.query_ids([item])[0]
File "/home/pycsw/pycsw/pycsw/core/repository.py", line 238, in query_ids
return self._get_repo_filter(query).all()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2699, in all
return self._iter().all()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2834, in _iter
result = self.session.execute(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1683, in execute
conn = self._connection_for_bind(bind, close_with_result=True)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1535, in _connection_for_bind
conn = engine.connect(**kw)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3165, in connect
return self._connection_cls(self, close_with_result=close_with_result)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 96, in __init__
else engine.raw_connection()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3244, in raw_connection
return self._wrap_pool_connect(self.pool.connect, _connection)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3214, in _wrap_pool_connect
Connection._handle_dbapi_exception_noconnection(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2068, in _handle_dbapi_exception_noconnection
util.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3211, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 307, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 767, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 430, in checkout
rec._checkin_failed(err, _fairy_was_created=False)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 427, in checkout
dbapi_connection = rec.get_connection()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 552, in get_connection
self.__connect()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 611, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 605, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/create.py", line 578, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 584, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) FATAL: sorry, too many clients already
(Background on this error at: http://sqlalche.me/e/14/e3q8)
Fri, 18 Jun 2021 16:37:45] [DEBUG] file=/home/pycsw/pycsw/pycsw/ogc/api/records.py line=577 module=records function=item Querying repository for item S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E
Fri, 18 Jun 2021 16:37:45] [ERROR] file=/usr/local/lib/python3.8/site-packages/flask/app.py line=1454 module=app function=log_exception Exception on /collections/metadata:main/items/S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E [GET]
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3211, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 307, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 767, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 430, in checkout
rec._checkin_failed(err, _fairy_was_created=False)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 427, in checkout
dbapi_connection = rec.get_connection()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 552, in get_connection
self.__connect()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 611, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 605, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/create.py", line 578, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 584, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL: sorry, too many clients already
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 2070, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1515, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1513, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1499, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)
File "/home/pycsw/pycsw/pycsw/wsgi_flask.py", line 162, in item
return get_response(api_.item(dict(request.headers), request.args, item))
File "/home/pycsw/pycsw/pycsw/ogc/api/records.py", line 579, in item
record = self.repository.query_ids([item])[0]
File "/home/pycsw/pycsw/pycsw/core/repository.py", line 238, in query_ids
return self._get_repo_filter(query).all()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2699, in all
return self._iter().all()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2834, in _iter
result = self.session.execute(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1683, in execute
conn = self._connection_for_bind(bind, close_with_result=True)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1535, in _connection_for_bind
conn = engine.connect(**kw)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3165, in connect
return self._connection_cls(self, close_with_result=close_with_result)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 96, in __init__
else engine.raw_connection()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3244, in raw_connection
return self._wrap_pool_connect(self.pool.connect, _connection)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3214, in _wrap_pool_connect
Connection._handle_dbapi_exception_noconnection(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2068, in _handle_dbapi_exception_noconnection
util.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3211, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 307, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 767, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 430, in checkout
rec._checkin_failed(err, _fairy_was_created=False)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 427, in checkout
dbapi_connection = rec.get_connection()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 552, in get_connection
self.__connect()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 611, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 605, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/create.py", line 578, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 584, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) FATAL: sorry, too many clients already
(Background on this error at: http://sqlalche.me/e/14/e3q8)
Fri, 18 Jun 2021 16:37:46] [DEBUG] file=/home/pycsw/pycsw/pycsw/ogc/api/records.py line=577 module=records function=item Querying repository for item S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E
Fri, 18 Jun 2021 16:37:46] [ERROR] file=/usr/local/lib/python3.8/site-packages/flask/app.py line=1454 module=app function=log_exception Exception on /collections/metadata:main/items/S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E [GET]
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1770, in _execute_context
self.dialect.do_execute(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute
cursor.execute(statement, parameters)
psycopg2.OperationalError: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 2070, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1515, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1513, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1499, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)
File "/home/pycsw/pycsw/pycsw/wsgi_flask.py", line 162, in item
return get_response(api_.item(dict(request.headers), request.args, item))
File "/home/pycsw/pycsw/pycsw/ogc/api/records.py", line 579, in item
record = self.repository.query_ids([item])[0]
File "/home/pycsw/pycsw/pycsw/core/repository.py", line 238, in query_ids
return self._get_repo_filter(query).all()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2699, in all
return self._iter().all()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2834, in _iter
result = self.session.execute(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1689, in execute
result = conn._execute_20(statement, params or {}, execution_options)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1582, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 324, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1451, in _execute_clauseelement
ret = self._execute_context(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1813, in _execute_context
self._handle_dbapi_exception(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1994, in _handle_dbapi_exception
util.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1770, in _execute_context
self.dialect.do_execute(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
[SQL: SELECT nbs_records.identifier AS nbs_records_identifier, nbs_records.typename AS nbs_records_typename, nbs_records.schema AS nbs_records_schema, nbs_records.mdsource AS nbs_records_mdsource, nbs_records.insert_date AS nbs_records_insert_date, nbs_records.xml AS nbs_records_xml, nbs_records.anytext AS nbs_records_anytext, nbs_records.metadata AS nbs_records_metadata, nbs_records.metadata_type AS nbs_records_metadata_type, nbs_records.language AS nbs_records_language, nbs_records.type AS nbs_records_type, nbs_records.title AS nbs_records_title, nbs_records.title_alternate AS nbs_records_title_alternate, nbs_records.abstract AS nbs_records_abstract, nbs_records.keywords AS nbs_records_keywords, nbs_records.keywordstype AS nbs_records_keywordstype, nbs_records.parentidentifier AS nbs_records_parentidentifier, nbs_records.relation AS nbs_records_relation, nbs_records.time_begin AS nbs_records_time_begin, nbs_records.time_end AS nbs_records_time_end, nbs_records.topicategory AS nbs_records_topicategory, nbs_records.resourcelanguage AS nbs_records_resourcelanguage, nbs_records.creator AS nbs_records_creator, nbs_records.publisher AS nbs_records_publisher, nbs_records.contributor AS nbs_records_contributor, nbs_records.organization AS nbs_records_organization, nbs_records.distributor AS nbs_records_distributor, nbs_records.securityconstraints AS nbs_records_securityconstraints, nbs_records.accessconstraints AS nbs_records_accessconstraints, nbs_records.useconstraints AS nbs_records_useconstraints, nbs_records.otherconstraints AS nbs_records_otherconstraints, nbs_records.date AS nbs_records_date, nbs_records.date_revision AS nbs_records_date_revision, nbs_records.date_creation AS nbs_records_date_creation, nbs_records.date_publication AS nbs_records_date_publication, nbs_records.date_modified AS nbs_records_date_modified, nbs_records.format AS nbs_records_format, nbs_records.source AS nbs_records_source, nbs_records.crs AS nbs_records_crs, nbs_records.geodescode AS nbs_records_geodescode, nbs_records.denominator AS nbs_records_denominator, nbs_records.distancevalue AS nbs_records_distancevalue, nbs_records.distanceuom AS nbs_records_distanceuom, nbs_records.wkt_geometry AS nbs_records_wkt_geometry, nbs_records.servicetype AS nbs_records_servicetype, nbs_records.servicetypeversion AS nbs_records_servicetypeversion, nbs_records.operation AS nbs_records_operation, nbs_records.couplingtype AS nbs_records_couplingtype, nbs_records.operateson AS nbs_records_operateson, nbs_records.operatesonidentifier AS nbs_records_operatesonidentifier, nbs_records.operatesoname AS nbs_records_operatesoname, nbs_records.degree AS nbs_records_degree, nbs_records.classification AS nbs_records_classification, nbs_records.conditionapplyingtoaccessanduse AS nbs_records_conditionapplyingtoaccessanduse, nbs_records.lineage AS nbs_records_lineage, nbs_records.responsiblepartyrole AS nbs_records_responsiblepartyrole, nbs_records.specificationtitle AS nbs_records_specificationtitle, nbs_records.specificationdate AS nbs_records_specificationdate, nbs_records.specificationdatetype AS nbs_records_specificationdatetype, nbs_records.platform AS nbs_records_platform, nbs_records.instrument AS nbs_records_instrument, nbs_records.sensortype AS nbs_records_sensortype, nbs_records.cloudcover AS nbs_records_cloudcover, nbs_records.bands AS nbs_records_bands, nbs_records.links AS nbs_records_links, nbs_records.anytext_tsvector AS nbs_records_anytext_tsvector, nbs_records.wkb_geometry AS nbs_records_wkb_geometry
FROM nbs_records
WHERE nbs_records.identifier IN (%(identifier_1_1)s)]
[parameters: {'identifier_1_1': 'S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E'}]
(Background on this error at: http://sqlalche.me/e/14/e3q8)
Fri, 18 Jun 2021 16:37:47] [DEBUG] file=/home/pycsw/pycsw/pycsw/ogc/api/records.py line=577 module=records function=item Querying repository for item S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E
Fri, 18 Jun 2021 16:37:47] [DEBUG] file=/home/pycsw/pycsw/pycsw/core/util.py line=402 module=util function=jsonify_links JSON link
Fri, 18 Jun 2021 16:37:47] [DEBUG] file=/home/pycsw/pycsw/pycsw/ogc/api/util.py line=181 module=util function=render_j2_template using default templates: /home/pycsw/pycsw/pycsw/ogc/api/templates
Fri, 18 Jun 2021 16:40:09] [DEBUG] file=/home/pycsw/pycsw/pycsw/ogc/api/records.py line=577 module=records function=item Querying repository for item S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E
Fri, 18 Jun 2021 16:40:09] [ERROR] file=/usr/local/lib/python3.8/site-packages/flask/app.py line=1454 module=app function=log_exception Exception on /collections/metadata:main/items/S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E [GET]
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3211, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 307, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 767, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 430, in checkout
rec._checkin_failed(err, _fairy_was_created=False)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 427, in checkout
dbapi_connection = rec.get_connection()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 552, in get_connection
self.__connect()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 611, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 605, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/create.py", line 578, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 584, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL: sorry, too many clients already
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 2070, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1515, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1513, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1499, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)
File "/home/pycsw/pycsw/pycsw/wsgi_flask.py", line 162, in item
return get_response(api_.item(dict(request.headers), request.args, item))
File "/home/pycsw/pycsw/pycsw/ogc/api/records.py", line 579, in item
record = self.repository.query_ids([item])[0]
File "/home/pycsw/pycsw/pycsw/core/repository.py", line 238, in query_ids
return self._get_repo_filter(query).all()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2699, in all
return self._iter().all()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2834, in _iter
result = self.session.execute(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1683, in execute
conn = self._connection_for_bind(bind, close_with_result=True)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1535, in _connection_for_bind
conn = engine.connect(**kw)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3165, in connect
return self._connection_cls(self, close_with_result=close_with_result)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 96, in __init__
else engine.raw_connection()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3244, in raw_connection
return self._wrap_pool_connect(self.pool.connect, _connection)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3214, in _wrap_pool_connect
Connection._handle_dbapi_exception_noconnection(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2068, in _handle_dbapi_exception_noconnection
util.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3211, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 307, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 767, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 430, in checkout
rec._checkin_failed(err, _fairy_was_created=False)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 427, in checkout
dbapi_connection = rec.get_connection()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 552, in get_connection
self.__connect()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 611, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 605, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/create.py", line 578, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 584, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) FATAL: sorry, too many clients already
(Background on this error at: http://sqlalche.me/e/14/e3q8)
Fri, 18 Jun 2021 16:40:12] [DEBUG] file=/home/pycsw/pycsw/pycsw/ogc/api/records.py line=577 module=records function=item Querying repository for item S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E
Fri, 18 Jun 2021 16:40:27] [DEBUG] file=/home/pycsw/pycsw/pycsw/ogc/api/records.py line=577 module=records function=item Querying repository for item S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E
Fri, 18 Jun 2021 16:40:27] [ERROR] file=/usr/local/lib/python3.8/site-packages/flask/app.py line=1454 module=app function=log_exception Exception on /collections/metadata:main/items/S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E [GET]
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3211, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 307, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 767, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 430, in checkout
rec._checkin_failed(err, _fairy_was_created=False)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 427, in checkout
dbapi_connection = rec.get_connection()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 552, in get_connection
self.__connect()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 611, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 605, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/create.py", line 578, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 584, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL: sorry, too many clients already
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 2070, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1515, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1513, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1499, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)
File "/home/pycsw/pycsw/pycsw/wsgi_flask.py", line 162, in item
return get_response(api_.item(dict(request.headers), request.args, item))
File "/home/pycsw/pycsw/pycsw/ogc/api/records.py", line 579, in item
record = self.repository.query_ids([item])[0]
File "/home/pycsw/pycsw/pycsw/core/repository.py", line 238, in query_ids
return self._get_repo_filter(query).all()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2699, in all
return self._iter().all()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2834, in _iter
result = self.session.execute(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1683, in execute
conn = self._connection_for_bind(bind, close_with_result=True)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1535, in _connection_for_bind
conn = engine.connect(**kw)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3165, in connect
return self._connection_cls(self, close_with_result=close_with_result)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 96, in __init__
else engine.raw_connection()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3244, in raw_connection
return self._wrap_pool_connect(self.pool.connect, _connection)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3214, in _wrap_pool_connect
Connection._handle_dbapi_exception_noconnection(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2068, in _handle_dbapi_exception_noconnection
util.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3211, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 307, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 767, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 430, in checkout
rec._checkin_failed(err, _fairy_was_created=False)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 427, in checkout
dbapi_connection = rec.get_connection()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 552, in get_connection
self.__connect()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 611, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 605, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/create.py", line 578, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 584, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.8/site-packages/psycopg2/__init__.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) FATAL: sorry, too many clients already
(Background on this error at: http://sqlalche.me/e/14/e3q8)
Fri, 18 Jun 2021 16:40:30] [DEBUG] file=/home/pycsw/pycsw/pycsw/ogc/api/records.py line=577 module=records function=item Querying repository for item S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E
Fri, 18 Jun 2021 16:40:30] [ERROR] file=/usr/local/lib/python3.8/site-packages/flask/app.py line=1454 module=app function=log_exception Exception on /collections/metadata:main/items/S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E [GET]
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1770, in _execute_context
self.dialect.do_execute(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute
cursor.execute(statement, parameters)
psycopg2.OperationalError: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 2070, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1515, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1513, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1499, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)
File "/home/pycsw/pycsw/pycsw/wsgi_flask.py", line 162, in item
return get_response(api_.item(dict(request.headers), request.args, item))
File "/home/pycsw/pycsw/pycsw/ogc/api/records.py", line 579, in item
record = self.repository.query_ids([item])[0]
File "/home/pycsw/pycsw/pycsw/core/repository.py", line 238, in query_ids
return self._get_repo_filter(query).all()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2699, in all
return self._iter().all()
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2834, in _iter
result = self.session.execute(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1689, in execute
result = conn._execute_20(statement, params or {}, execution_options)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1582, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 324, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1451, in _execute_clauseelement
ret = self._execute_context(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1813, in _execute_context
self._handle_dbapi_exception(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1994, in _handle_dbapi_exception
util.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1770, in _execute_context
self.dialect.do_execute(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
[SQL: SELECT nbs_records.identifier AS nbs_records_identifier, nbs_records.typename AS nbs_records_typename, nbs_records.schema AS nbs_records_schema, nbs_records.mdsource AS nbs_records_mdsource, nbs_records.insert_date AS nbs_records_insert_date, nbs_records.xml AS nbs_records_xml, nbs_records.anytext AS nbs_records_anytext, nbs_records.metadata AS nbs_records_metadata, nbs_records.metadata_type AS nbs_records_metadata_type, nbs_records.language AS nbs_records_language, nbs_records.type AS nbs_records_type, nbs_records.title AS nbs_records_title, nbs_records.title_alternate AS nbs_records_title_alternate, nbs_records.abstract AS nbs_records_abstract, nbs_records.keywords AS nbs_records_keywords, nbs_records.keywordstype AS nbs_records_keywordstype, nbs_records.parentidentifier AS nbs_records_parentidentifier, nbs_records.relation AS nbs_records_relation, nbs_records.time_begin AS nbs_records_time_begin, nbs_records.time_end AS nbs_records_time_end, nbs_records.topicategory AS nbs_records_topicategory, nbs_records.resourcelanguage AS nbs_records_resourcelanguage, nbs_records.creator AS nbs_records_creator, nbs_records.publisher AS nbs_records_publisher, nbs_records.contributor AS nbs_records_contributor, nbs_records.organization AS nbs_records_organization, nbs_records.distributor AS nbs_records_distributor, nbs_records.securityconstraints AS nbs_records_securityconstraints, nbs_records.accessconstraints AS nbs_records_accessconstraints, nbs_records.useconstraints AS nbs_records_useconstraints, nbs_records.otherconstraints AS nbs_records_otherconstraints, nbs_records.date AS nbs_records_date, nbs_records.date_revision AS nbs_records_date_revision, nbs_records.date_creation AS nbs_records_date_creation, nbs_records.date_publication AS nbs_records_date_publication, nbs_records.date_modified AS nbs_records_date_modified, nbs_records.format AS nbs_records_format, nbs_records.source AS nbs_records_source, nbs_records.crs AS nbs_records_crs, nbs_records.geodescode AS nbs_records_geodescode, nbs_records.denominator AS nbs_records_denominator, nbs_records.distancevalue AS nbs_records_distancevalue, nbs_records.distanceuom AS nbs_records_distanceuom, nbs_records.wkt_geometry AS nbs_records_wkt_geometry, nbs_records.servicetype AS nbs_records_servicetype, nbs_records.servicetypeversion AS nbs_records_servicetypeversion, nbs_records.operation AS nbs_records_operation, nbs_records.couplingtype AS nbs_records_couplingtype, nbs_records.operateson AS nbs_records_operateson, nbs_records.operatesonidentifier AS nbs_records_operatesonidentifier, nbs_records.operatesoname AS nbs_records_operatesoname, nbs_records.degree AS nbs_records_degree, nbs_records.classification AS nbs_records_classification, nbs_records.conditionapplyingtoaccessanduse AS nbs_records_conditionapplyingtoaccessanduse, nbs_records.lineage AS nbs_records_lineage, nbs_records.responsiblepartyrole AS nbs_records_responsiblepartyrole, nbs_records.specificationtitle AS nbs_records_specificationtitle, nbs_records.specificationdate AS nbs_records_specificationdate, nbs_records.specificationdatetype AS nbs_records_specificationdatetype, nbs_records.platform AS nbs_records_platform, nbs_records.instrument AS nbs_records_instrument, nbs_records.sensortype AS nbs_records_sensortype, nbs_records.cloudcover AS nbs_records_cloudcover, nbs_records.bands AS nbs_records_bands, nbs_records.links AS nbs_records_links, nbs_records.anytext_tsvector AS nbs_records_anytext_tsvector, nbs_records.wkb_geometry AS nbs_records_wkb_geometry
FROM nbs_records
WHERE nbs_records.identifier IN (%(identifier_1_1)s)]
[parameters: {'identifier_1_1': 'S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E'}]
(Background on this error at: http://sqlalche.me/e/14/e3q8)
Fri, 18 Jun 2021 16:40:31] [DEBUG] file=/home/pycsw/pycsw/pycsw/ogc/api/records.py line=577 module=records function=item Querying repository for item S1B_IW_GRDH_1SDV_20190831T161553_20190831T161615_017832_0218F0_715E
Fri, 18 Jun 2021 16:40:31] [DEBUG] file=/home/pycsw/pycsw/pycsw/core/util.py line=402 module=util function=jsonify_links JSON link
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment