counterdata-network / story-processor

Story discovery engine for the Counterdata Network. Grabs relevant stories from various APIs, runs them against bespoke classifier models, post results to a central server.
Apache License 2.0
0 stars 2 forks source link

Postgres fetch query error on projects table #49

Closed gopigof closed 2 months ago

gopigof commented 11 months ago

Issue

The database API calls to fetch project history has been failed multiple times over the past week. The exact reason behind this API call error is uncertain at the moment, but it is suspected to be due to the connection pool handling logic in multiprocessing scenario.

Link

https://data-feminism-lab-mit.sentry.io/issues/4477463557/?project=5893078&query=is%3Aunresolved&referrer=issue-stream&statsPeriod=14d&stream_index=8

Error description

'''' Couldn't get history for project 21 - (psycopg2.OperationalError) SSL SYSCALL error: EOF detected

[SQL: SELECT projects.id AS projects_id, projects.last_processed_id AS projects_last_processed_id, projects.last_publish_date AS projects_last_publish_date, projects.last_url AS projects_last_url, projects.created_at AS projects_created_at, projects.updated_at AS projects_updated_at FROM projects WHERE projects.id = %(pk_1)s] [parameters: {'pk_1': 21}] (Background on this error at: https://sqlalche.me/e/20/e3q8) ''''

rahulbot commented 2 months ago

Haven't seen it a while, closing.