Project

General

Profile

Actions

Bug #23022

closed

SQL error when using PUT to upload RHSM facts

Added by Stephen Benjamin over 6 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Normal
Category:
Hosts
Target version:
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

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

Actions #1

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
Actions #2

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
Actions #3

Updated by Stephen Benjamin over 6 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100
Actions

Also available in: Atom PDF