search

packit / packit-service

Packit provided as a service
https://packit.dev
MIT License
34 stars 46 forks source link

OperationalError: (psycopg2.errors.DiskFull) could not resize shared memory segment "/PostgreSQL.7953802" to 838860... #2385

Closed sentry-io[bot] closed 2 months ago

sentry-io[bot] commented 3 months ago

Sentry Issue: PCKT-002-PACKIT-SERVICE-7BQ

DiskFull: could not resize shared memory segment "/PostgreSQL.7953802" to 8388608 bytes: No space left on device
CONTEXT:  parallel worker

  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.errors.DiskFull) could not resize shared memory segment "/PostgreSQL.7953802" to 8388608 bytes: No space left on device
CONTEXT:  parallel worker

[SQL: SELECT DISTINCT git_projects.project_url AS git_projects_project_url, count(srpm_builds.id) OVER (PARTITION BY git_projects.project_url) AS anon_1, count(srpm_builds.id) OVER (PARTITION BY git_projects.project_url) AS anon_2 
FROM git_projects JOIN pull_requests ON git_projects.id = pull_requests.project_id JOIN project_events ON project_events.event_id = pull_requests.id JOIN pipelines ON pipelines.project_event_id = project_events.id JOIN srpm_builds ON srpm_builds.id = pipelines.srpm_build_id 
WHERE project_events.type = %(type_1)s AND pipelines.datetime >= %(datetime_1)s AND pipelines.datetime <= %(datetime_2)s GROUP BY git_projects.project_url, srpm_builds.id ORDER BY count(srpm_builds.id) OVER (PARTITION BY git_projects.project_url) DESC]
[parameters: {'type_1': 'pull_request', 'datetime_1': datetime.datetime(1924, 3, 27, 11, 41, 51, 20563)...
(21 additional frame(s) were not displayed)
...
  File "packit_service/service/api/usage.py", line 801, in _get_usage_interval_data
    past_data = get_usage_data(
  File "packit_service/service/api/usage.py", line 352, in get_usage_data
    job_runs=GitProjectModel.get_job_usage_numbers_count_all_project_events(
  File "packit_service/models.py", line 868, in get_job_usage_numbers_count_all_project_events
    cls.get_job_usage_numbers_all_project_events(
  File "packit_service/models.py", line 959, in get_job_usage_numbers_all_project_events
    cls.get_job_usage_numbers(
  File "packit_service/models.py", line 931, in get_job_usage_numbers
    query.group_by(GitProjectModel.project_url, job_result_model.id)
majamassarini commented 2 months ago

Waiting for service-now ticket RITM1764747

majamassarini commented 2 months ago

PR packit/deployment#567 works if you manually mount the cache-volume.