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