Bug #23022
closedSQL error when using PUT to upload RHSM facts
Description
Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1543598
Description of problem:
While attempting to verify bz 1405523 I ran into an error when i tried to upload changed facts.
Version-Release number of selected component (if applicable): Sat 6.3 snap 35
How reproducible: always
Steps to Reproduce:
1. curl -k -X GET -u admin:changeme https://<satellite>/rhsm/consumers/$id -H "Content-Type: application/json" -o facts.json
2.Edit facts.json and change cpu.cpu_socket(s) from 1 to 2
3. curl -k -X PUT -u admin:changeme https://<satellite>/rhsm/consumers/$id -H "Content-Type: application/json" -d "@facts.json"
Actual results:
Error returned:
{"displayMessage":"ERROR: missing FROM-clause entry for table \"label\"\nLINE 1: ...WHERE \"taxonomies\".\"type\" IN ('Organization') AND \"label\".\"i...\n ^\n","errors":["ERROR: missing FROM-clause entry for table \"label\"\nLINE 1: ...WHERE \"taxonomies\".\"type\" IN ('Organization') AND \"label\".\"i...\n ^\n"]}
Expected results:
Facts updated
Additional info:
Uploaded foreman debug and facts.json
For reference the UUID of the content host i used was 963da17b-c50d-41dd-ab45-5ba670c4d55c
Updated by The Foreman Bot over 6 years ago
- Status changed from New to Ready For Testing
- Assignee set to Stephen Benjamin
- Pull request https://github.com/Katello/katello/pull/7264 added
Updated by John Mitsch over 6 years ago
- Subject changed from SQL error when using PUT to upload RHSM facts to SQL error when using PUT to upload RHSM facts
- Translation missing: en.field_release set to 338
Updated by Stephen Benjamin over 6 years ago
- Status changed from Ready For Testing to Closed
- % Done changed from 0 to 100
Applied in changeset katello|643d3b81b6e52bf0d43bce1ee7a9d3584965baca.