Issue #9277
closedKatello::Errors::Pulp3Error: value too long for type character varying(255)
Updated by quba42 about 3 years ago
I went and had a look at all fields in pulp_deb that have max_length=255
and I don't think any of them are likely to have caused this sync failure. (Given what I know about the repo being synced).
Without the ability to test the upstream repo, I do not know how to proceed...
Updated by quba42 about 3 years ago
Ok, I was given the relevant release file, and the problem is that the repo has uncharacteristically many components, thus exceeding the max length of the field in pulp_deb. The following is from the upstream release file:
Components: main mysql postgresql ldap cloud-s3 cloud-glacier cloud-azure cloud-google cloud-oracle shstore delta ndmp vsphere demo demo-support bweb netapp-hfc html-manuals kvm snapshot dedup aligned single-item-restore sybase kubernetes docker rhv db2 xenserver hdfs m365
Updated by quba42 about 3 years ago
Several possibilities for improving components
fields:
- Increase the
max_length
? - Chane to
TextField(null=True)
? - Change to
ArrayField(CharField(max_length=255), null=True)
?
Also update architectures and distributions fields?
Updated by quba42 about 3 years ago
I decided against the array option, since I want to do as little as possible processing of upstream metadata, before storing it in the DB. In other words, I want to keep upstream fields containing space separated string lists as a single string (containing space separated list values) in the DB.
Added by quba42 about 3 years ago
Updated by pulpbot about 3 years ago
- Status changed from NEW to POST
Updated by quba42 about 3 years ago
- Status changed from POST to MODIFIED
Applied in changeset 00fe4226e8b79bc8de335414963d25a0fbb23672.
Updated by pulpbot about 3 years ago
- Status changed from MODIFIED to CLOSED - CURRENTRELEASE
Allow more than 256 characters for certain DB fields
closes #9277 https://pulp.plan.io/issues/9277
The relevant fields containing a whitespace seperated list of values, in particular any fields named "distributions", "components", or "architectures".