Task #3505
Updated by bmbouter over 6 years ago
Justification is written here: https://www.redhat.com/archives/pulp-dev/2018-April/msg00204.html
Sqlite falls over very quickly when loaded. Despite the recent change to add a 20 second timeout, Pulp still frequently gets "OperationalError: database is locked" errors when handling a couple dozen to a couple hundred packages, with the liklihood of a sync failure due to db lock being almost 100% after about 300 packages.
This is immediately apparent with the Python plugin, which downloads every release package for a provided project name by default.
In practical terms, syncing the "Django" and "pulpcore" projects works about half the time, and syncing "Django", "pulpcore", and "scipy" usually fails.
This makes developing some plugins, such as the Python plugin, particularly difficult. We can keep sqlite support for *very* simple plugin development but we shouldn't leave it the default in our own development environment.
.