gilsondev / checkstatus-govbr

Projeto criado para acompanhar situação dos domínios .govbr registrados pela área pública
https://checkstatusgovbr.org
GNU General Public License v3.0
2 stars 1 forks source link

OperationalError: (psycopg2.OperationalError) server closed the connection unexpectedly #37

Open sentry-io[bot] opened 8 months ago

sentry-io[bot] commented 8 months ago

Sentry Issue: CHECKSTATUSGOVBR-6

OperationalError: server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.

  File "sqlalchemy/engine/base.py", line 1900, in _execute_context
    self.dialect.do_execute(
  File "sqlalchemy/engine/default.py", line 736, in do_execute
    cursor.execute(statement, parameters)

OperationalError: (psycopg2.OperationalError) server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.

[SQL: SELECT count(*) AS count_1 
FROM (SELECT domains.id AS domains_id, domains.created_at AS domains_created_at, domains.updated_at AS domains_updated_at, domains.domain AS domains_domain, domains.slug AS domains_slug, domains.document AS domains_document, domains.document_normalized AS domains_document_normalized, domains.organization AS domains_organization, domains.organization_normalized AS domains_organization_normalized, domains.agent AS domains_agent, domains.agent_normalized AS domains_agent_normalized, domains.nameservers AS domains_nameservers, domains.department AS domains_department, domains.department_normalized AS domains_department_normalized, domains.department_email AS domains_department_email, domains.status AS domains_status, domains.available AS domains_available, domains.registered_at AS domains_registered_at, domains.re...
(27 additional frame(s) were not displayed)
...
  File "src/routes.py", line 36, in fetch_domains
    return paginate(DomainService(db).fetch())
gilsondev commented 8 months ago

Isso parece comportamento da infraestrutura do banco, que depois de inatividade ele "dorme", fazendo com que perca a referência da conexão, abortando ele.