Created
June 18, 2021 16:43
Star
You must be signed in to star a gist
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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