Jira (PDB-722) PuppetDB response hanging on select-nodes subquery
Title: Message Title Kenneth Barber updated an issue PuppetDB / PDB-722 PuppetDB response hanging on select-nodes subquery Change By: Kenneth Barber Fix Version/s: PDB3.0.0 Add Comment This message was sent by Atlassian JIRA (v6.3.7#6337-sha1:2ed701e) -- You received this message because you are subscribed to the Google Groups Puppet Bugs group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-722) PuppetDB response hanging on select-nodes subquery
Title: Message Title Steve Barlow updated an issue PuppetDB / PDB-722 PuppetDB response hanging on select-nodes subquery Change By: Steve Barlow Sprint: PuppetDB2014-12-03 ,PuppetDB2014-12-17 Add Comment This message was sent by Atlassian JIRA (v6.3.7#6337-sha1:2ed701e) -- You received this message because you are subscribed to the Google Groups Puppet Bugs group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-722) PuppetDB response hanging on select-nodes subquery
Title: Message Title Kenneth Barber updated an issue PuppetDB / PDB-722 PuppetDB response hanging on select-nodes subquery Change By: Kenneth Barber Sprint: PuppetDB2014-12-03 Add Comment This message was sent by Atlassian JIRA (v6.3.7#6337-sha1:2ed701e) -- You received this message because you are subscribed to the Google Groups Puppet Bugs group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-722) PuppetDB response hanging on select-nodes subquery
Title: Message Title Andrii Nikitiuk commented on PDB-722 Re: PuppetDB response hanging on select-nodes subquery Created PR-1165 for the issue described in the comment above. Add Comment This message was sent by Atlassian JIRA (v6.3.7#6337-sha1:2ed701e) -- You received this message because you are subscribed to the Google Groups Puppet Bugs group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-722) PuppetDB response hanging on select-nodes subquery
Title: Message Title Andrii Nikitiuk commented on PDB-722 Re: PuppetDB response hanging on select-nodes subquery Small addition to inconsistent error topic. According to https://docs.puppetlabs.com/puppetdb/latest/api/query/v4/operators.html#subquery-operators, it is allowed to extract a single field in vector-less form as in this example: curl -X GET 'http://localhost:8080/v4/facts' --data-urlencode 'query=[and, [=, name, swapfree], [in, name, [extract, fakefield, [select-nodes, [=, [parameter, name], mbp.corp.puppetlabs.net]' But, this is still invalid query because of not allowed fakefield field. That is why it results in such a different error: Can't extract unknown 'nodes' field 'fakefield'. Acceptable fields are: [certname,deactivated,facts-environment,report-environment,catalog-environment,facts-timestamp,report-timestamp,catalog-timestamp] However, I think I see a bug here. If we use vector form (even with a single extract field), it stops printing such error. Here is an example that should fail with the same error as previous one, but it actually does not: curl -X GET 'http://localhost:8080/v4/facts' --data-urlencode 'query=[and, [=, name, swapfree], [in, name, [extract, [fakefield], [select-nodes, [=, [parameter, name], mbp.corp.puppetlabs.net]' This seems to be the only issue which should be fixed in scope of this jira ticket. Please correct me if I am wrong.
Jira (PDB-722) PuppetDB response hanging on select-nodes subquery
Title: Message Title Andrii Nikitiuk commented on PDB-722 Re: PuppetDB response hanging on select-nodes subquery Currently it returns an error immediately: Andriis-MacBook-Pro:demonshi-puppetdb demonshi$ curl -X GET 'http://localhost:8080/v3/facts' --data-urlencode 'query=[and, [=, name, swapfree], [in, name, [extract, [parameter, name], [select-nodes, [=, [parameter, name], mbp.corp.puppetlabs.net]' [select-nodes [= [parameter name] mbp.corp.puppetlabs.net]] is not well-formed: query operator 'select-nodes' is unknown Add Comment This message was sent by Atlassian JIRA (v6.3.7#6337-sha1:2ed701e) -- You received this message because you are subscribed to the Google Groups Puppet Bugs group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-722) PuppetDB response hanging on select-nodes subquery
Title: Message Title Wyatt Alt commented on PDB-722 Re: PuppetDB response hanging on select-nodes subquery That's appropriate because [parameter name] is only valid on the resources endpoint. Swap select-nodes for select-resources and it should work. Add Comment This message was sent by Atlassian JIRA (v6.3.7#6337-sha1:2ed701e) -- You received this message because you are subscribed to the Google Groups Puppet Bugs group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-722) PuppetDB response hanging on select-nodes subquery
Title: Message Title Wyatt Alt commented on PDB-722 Re: PuppetDB response hanging on select-nodes subquery Andrii Nikitiuk I think that if there's more to be done it relates to Ken's comment above. When the malformed query is run in v4, there's no pretty error printed. in other words, curl -X GET 'http://localhost:8080/v4/facts' --data-urlencode 'query=[and, [=, name, swapfree], [in, name, [extract, [parameter, name], [select-nodes, [=, [parameter, name], mbp.corp.puppetlabs.net]' and curl -X GET 'http://localhost:8080/v4/facts' --data-urlencode 'query=[and, [=, name, swapfree], [in, name, [extract, fakefield, [select-nodes, [=, [parameter, name], mbp.corp.puppetlabs.net]' fail in inconsistent ways. The same would be true if the argument were [fact, foo] as would be appropriate on the nodes endpoint The general issue seems to be surfacing an error when the field is one of these special shorthand vectors, rather than a string. Reading this now though it occurs to me that we have semi-related issues with our new top-level extract operator on v4: https://github.com/puppetlabs/puppetdb/commit/688872674f7440272c8c0c450b7270cfef379ea9 In that case, this query is not supported: curl -X GET http://localhost:8080/v4/resources --data-urlencode 'query=[extract,[parameter,name],[~,certname,.*]]' and neither is this one:
Jira (PDB-722) PuppetDB response hanging on select-nodes subquery
Title: Message Title Andrii Nikitiuk commented on PDB-722 Re: PuppetDB response hanging on select-nodes subquery Thank you for clarifications. I will work on those on my free time Add Comment This message was sent by Atlassian JIRA (v6.3.7#6337-sha1:2ed701e) -- You received this message because you are subscribed to the Google Groups Puppet Bugs group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-722) PuppetDB response hanging on select-nodes subquery
Title: Message Title Andrii Nikitiuk assigned an issue to Andrii Nikitiuk PuppetDB / PDB-722 PuppetDB response hanging on select-nodes subquery Change By: Andrii Nikitiuk Assignee: AndriiNikitiuk Add Comment This message was sent by Atlassian JIRA (v6.3.7#6337-sha1:2ed701e) -- You received this message because you are subscribed to the Google Groups Puppet Bugs group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-722) PuppetDB response hanging on select-nodes subquery
Title: Message Title Ryan Senior updated an issue PuppetDB / PDB-722 PuppetDB response hanging on select-nodes subquery Change By: Ryan Senior Story Points: 2 Add Comment This message was sent by Atlassian JIRA (v6.1.4#6159-sha1:44eaede) -- You received this message because you are subscribed to the Google Groups Puppet Bugs group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-722) PuppetDB response hanging on select-nodes subquery
Title: Message Title Kenneth Barber updated an issue PuppetDB / PDB-722 PuppetDB response hanging on select-nodes subquery Change By: Kenneth Barber Affects Version/s: 2.1.0 Fix Version/s: 2.1.0 Add Comment This message was sent by Atlassian JIRA (v6.1.4#6159-sha1:44eaede) -- You received this message because you are subscribed to the Google Groups Puppet Bugs group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-722) PuppetDB response hanging on select-nodes subquery
Title: Message Title Wyatt Alt created an issue PuppetDB / PDB-722 PuppetDB response hanging on select-nodes subquery Issue Type: Bug Assignee: Unassigned Created: 24/Jun/14 4:12 PM Environment: OSX 10.9.3 Fix Versions: 2.1.0 Priority: Normal Reporter: Wyatt Alt Running the following query causes PuppetDB to hang for some time before responding with curl: (52) Empty reply from server Maybe it should send an empty list instead (or raise an exception if the query is malformed.) Query: curl -X GET 'http://localhost:8080/v3/facts' --data-urlencode 'query=[and, [=, name, swapfree], [in, name, [extract, [parameter, name], [select-nodes, [=, [parameter, name], mbp.corp.puppetlabs.net]' Traceback: java.lang.AssertionError: Assert failed: (string? field) at com.puppetlabs.puppetdb.query$compile_extract.invoke(query.clj:330) ~[na:na] at clojure.lang.AFn.applyToHelper(AFn.java:165)
Jira (PDB-722) PuppetDB response hanging on select-nodes subquery
Title: Message Title Kenneth Barber commented on an issue Re: PuppetDB response hanging on select-nodes subquery The think to note here, is that with the same query for v4, we throw an internal sql exception - because [parameter, name] just gets passed through to the SQL layer. Add Comment PuppetDB / PDB-722 PuppetDB response hanging on select-nodes subquery Running the following query causes PuppetDB to hang for some time before responding with curl: (52) Empty reply from server Maybe it should send an empty list instead (or raise an exception if the query is malformed.) Query: {code} curl -X GET 'http://localhost:8080/v3/facts#39; --data-urlencode 'query=[and, [=, name, swapfree], [in, nam... This message was sent by Atlassian JIRA (v6.1.4#6159-sha1:44eaede) -- You received this message because you are subscribed to the Google Groups Puppet Bugs group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-bugs. For more options, visit