Jira (PDB-3856) PQL specifying both type and title for class makes pql not find existing class

[David Hollinger (JIRA)]

David Hollinger created an issue

PuppetDB / PDB-3856 PQL specifying both type and title for class makes pql not find existing class Issue Type: Bug Affects Versions: PDB 5.2.0 Assignee: Unassigned Created: 2018/02/26 1:35 PM Priority: Normal Reporter: David Hollinger I noticed today when attempting to do a PQL query against the PuppetDB REST API to gather a list of nodes with a specific class assigned to it, that I get an empty array in return. When I execute: $ curl -XGET http://localhost:8080/pdb/query/v4 --data-urlencode 'query=nodes[certname] { resources { title = "foo" } }' I will get a list of nodes back that have ANY resources with title of "foo". When I execute: $ curl -XGET http://localhost:8080/pdb/query/v4 --data-urlencode 'query=resources { type = "Class" and certname = "node" }' I'll get a list of resources of type class for that node. But, If I try: curl -XGET http://localhost:8080/pdb/query/v4 --data-urlencode 'query=nodes[certname] { resources { type = "Class" and title = "foo" } }' I get an empty array back, when I should betting a list of nodes that have Class "foo" assigned to it. This has also broken Choria's ability to execute certain playbooks as we rely on running jobs only on certain nodes containing specific classes. Add Comment

This message was sent by Atlassian JIRA (v7.5.1#75006-sha1:7df2574)

[Jeff Yarnell (JIRA)]

Jeff Yarnell updated an issue

PuppetDB / PDB-3856 PQL specifying both type and title for class makes pql not find existing class

Change By: Jeff Yarnell Team: Data Platform

Add Comment

[Jeff Yarnell (JIRA)]

Jeff Yarnell updated an issue

PuppetDB / PDB-3856 PQL specifying both type and title for class makes pql not find existing class

Change By: Jeff Yarnell Sprint: Hopper/Triage

Add Comment

[Jeff Yarnell (JIRA)]

Jeff Yarnell updated an issue

PuppetDB / PDB-3856 PQL specifying both type and title for class makes pql not find existing class

Change By: Jeff Yarnell Sprint: Hopper/Triage Data Platform 2018-03-28

Add Comment

[David Hollinger (JIRA)]

David Hollinger commented on PDB-3856

Re: PQL specifying both type and title for class makes pql not find existing class For us, this ticket is a bit more high priority as I have noticed that a downgrade of PuppetDB is not possible due to the changes to how Facts are stored.

Add Comment

[Kenn Hussey (JIRA)]

Kenn Hussey commented on PDB-3856

Re: PQL specifying both type and title for class makes pql not find existing class

Jeff Yarnell is this being fixed for PDB 5.2.1 as well (in which case that fix version should be assigned)? /cc Nirupama Mantha

Add Comment

This message was sent by Atlassian JIRA (v7.7.1#77002-sha1:e75ca93)

[Jeff Yarnell (JIRA)]

Jeff Yarnell updated an issue

PuppetDB / PDB-3856

PQL specifying both type and title for class makes pql not find existing class

Change By: Jeff Yarnell Fix Version/s: PDB 5.2.z

Add Comment

[Jeff Yarnell (JIRA)]

Jeff Yarnell commented on PDB-3856

Re: PQL specifying both type and title for class makes pql not find existing class We can't make PDB 5.2.1 but are targeting 5.2.2

Add Comment

[Kenn Hussey (JIRA)]

Kenn Hussey updated an issue

PuppetDB / PDB-3856

PQL specifying both type and title for class makes pql not find existing class

Change By: Kenn Hussey Fix Version/s: PDB 5.2.z Fix Version/s: PDB 5.2.2

Add Comment

[Jeff Yarnell (JIRA)]

Jeff Yarnell updated an issue

PuppetDB / PDB-3856 PQL specifying both type and title for class makes pql not find existing class

Change By: Jeff Yarnell Sprint: Data Platform 2018- 03 04 - 28 11

Add Comment

[Jeff Yarnell (JIRA)]

Jeff Yarnell updated an issue

PuppetDB / PDB-3856 PQL specifying both type and title for class makes pql not find existing class

Change By: Jeff Yarnell Sprint: Data Platform 2018-04- 11 25

Add Comment

[AJ Roetker (JIRA)]

AJ Roetker assigned an issue to AJ Roetker

PuppetDB / PDB-3856 PQL specifying both type and title for class makes pql not find existing class

Change By: AJ Roetker Assignee: AJ Roetker

Add Comment

[Jeff Yarnell (JIRA)]

Jeff Yarnell updated an issue

PuppetDB / PDB-3856 PQL specifying both type and title for class makes pql not find existing class

Change By: Jeff Yarnell Sprint: Data Platform 2018-04- 25 11

Add Comment

[AJ Roetker (JIRA)]

AJ Roetker commented on PDB-3856

Re: PQL specifying both type and title for class makes pql not find existing class David Hollinger Do you have any more information regarding the specifics of what kinds of queries are failing with which resources? I've tried to reproduce this but have been unsuccessful. Is it possible for you to paste the example real inputs and outputs that are failing for you?

Add Comment

[R.I.Pienaar (JIRA)]

R.I.Pienaar commented on PDB-3856

Re: PQL specifying both type and title for class makes pql not find existing class

PuppetDB 5.1.1: $ rpm -q puppetdb puppetdb-5.1.1-1.el7.noarch $ puppet query 'nodes[certname] { resources { type = "Class" and title = "Puppetdb" } }' [ { "certname": "puppet.choria.example.net" } ] Upgraded to 5.2.1 by setting puppetdb::globals::version to 5.2.1-1.el7: $ rpm -q puppetdb puppetdb-5.2.1-1.el7.noarch Still works: $ puppet query 'nodes[certname] { resources { type = "Class" and title = "Puppetdb" } }' [ { "certname": "puppet.choria.example.net" } ] Note the class is capitalized, your foo is not, perhaps your real query was also not David Hollinger?

Add Comment

[David Hollinger (JIRA)]

David Hollinger commented on PDB-3856

Re: PQL specifying both type and title for class makes pql not find existing class

foo was not my real query, no. It's entirely possible that it was my query, but I'll validate tonight.

Add Comment

[R.I.Pienaar (JIRA)]

R.I.Pienaar commented on PDB-3856

Re: PQL specifying both type and title for class makes pql not find existing class

David Hollinger your discovery is more likely failing due to https://tickets.puppetlabs.com/browse/PDB-3852

Add Comment

[Kenn Hussey (JIRA)]

Kenn Hussey updated an issue

PuppetDB / PDB-3856

PQL specifying both type and title for class makes pql not find existing class

Change By: Kenn Hussey Flagged: Impediment

Add Comment

[AJ Roetker (JIRA)]

AJ Roetker commented on PDB-3856

Re: PQL specifying both type and title for class makes pql not find existing class David Hollinger any updates here? If not I'll go ahead and close this.

Add Comment

[Kenn Hussey (JIRA)]

Kenn Hussey updated an issue

PuppetDB / PDB-3856

PQL specifying both type and title for class makes pql not find existing class

Change By: Kenn Hussey Flagged: Impediment

Add Comment

[Kenn Hussey (JIRA)]

Kenn Hussey updated an issue

PuppetDB / PDB-3856 PQL specifying both type and title for class makes pql not find existing class

Change By: Kenn Hussey Fix Version/s: PDB 5.2.2 Fix Version/s: PDB 5.2.z

Add Comment

[Nirupama Mantha (JIRA)]

Nirupama Mantha updated an issue

PuppetDB / PDB-3856 PQL specifying both type and title for class makes pql not find existing class

Change By: Nirupama Mantha Sprint: Data Platform 2018-04-11 Hopper/Triage

Add Comment

[Zachary Kent (Jira)]

Zachary Kent updated an issue

PuppetDB / PDB-3856 PQL specifying both type and title for class makes pql not find existing class

Change By: Zachary Kent Sprint:

Add Comment

This message was sent by Atlassian Jira (v8.5.2#805002-sha1:a66f935)

[Zachary Kent (Jira)]

Zachary Kent updated an issue

PuppetDB / PDB-3856 PQL specifying both type and title for class makes pql not find existing class

Change By: Zachary Kent Sprint: Release Engineering Hopper

Add Comment

[Morgan Rhodes (Jira)]

Morgan Rhodes updated an issue

PuppetDB / PDB-3856 PQL specifying both type and title for class makes pql not find existing class

Change By: Morgan Rhodes Sprint: Release Engineering Hopper

Add Comment