Kinto / Kinto/kinto

DROP FUNCTION collection_timestamp(uid VARCHAR, resource VARCHAR) doesn't exists

Open
#2,235 1 comment 0 reactions 0 assignees View on GitHub
bug stale
Dominant language
Python
Stars
4.4k
Forks
437
Avg merge
1d 2h
Merged PRs (30d)
15

Description

kinto.core.storage.exceptions.BackendError: ProgrammingError: (psycopg2.errors.UndefinedFunction) function collection_timestamp(character varying, character varying) does not exist

When running the migrations between kinto 12 to kinto 13, this error message can happen. We should ignore the deletion if the function does not exists.

Contributor guide

Open the contributing guide

Research direction

Start by locating the migration that runs when upgrading from Kinto 12 to Kinto 13 and reproducing the reported psycopg2 UndefinedFunction error for collection_timestamp(uid VARCHAR, resource VARCHAR). The migration is done when deletion succeeds both with and without that function present.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, python
Domain
database
Issue type
Bug
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.