DROP FUNCTION collection_timestamp(uid VARCHAR, resource VARCHAR) doesn't exists
Open
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
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