Jira (PDB-1447) remove late-project/basic-project and supply the functionality with the database.
Title: Message Title John Duarte updated an issue PuppetDB / PDB-1447 remove late-project/basic-project and supply the functionality with the database. Change By: John Duarte QA Risk Assessment: Medium Add Comment This message was sent by Atlassian JIRA (v6.3.15#6346-sha1:dbc023d) -- 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-1447) remove late-project/basic-project and supply the functionality with the database.
Title: Message Title John Duarte updated an issue PuppetDB / PDB-1447 remove late-project/basic-project and supply the functionality with the database. Change By: John Duarte QA Status: Reviewed Add Comment This message was sent by Atlassian JIRA (v6.3.15#6346-sha1:dbc023d) -- 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-1447) remove late-project/basic-project and supply the functionality with the database.
Title: Message Title Rob Browning commented on PDB-1447 Re: remove late-project/basic-project and supply the functionality with the database. Tested the migration, which resulted in a second version that uses a transform table, then tested the new version on a synthetic dataset of 1657950 values created via benchmark (and Wyatt's augmented data dir) and found: fact_values size MB before 435 after 490 Migration time: ~45s The migration was performed on Linux with postgres on an ext4 filesystem on a mechanical laptop drive connected via USB3, after dropping the vm caches: echo 3 /proc/sys/vm/drop_caches The query performance was tested via siege using this small set of URLs: http://localhost:8080/v4/facts?limit=10 http://localhost:8080/v4/facts/kernel
Jira (PDB-1447) remove late-project/basic-project and supply the functionality with the database.
Title: Message Title Rob Browning assigned an issue to Rob Browning PuppetDB / PDB-1447 remove late-project/basic-project and supply the functionality with the database. Change By: Rob Browning Assignee: RobBrowning Add Comment This message was sent by Atlassian JIRA (v6.3.15#6346-sha1:dbc023d) -- 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-1447) remove late-project/basic-project and supply the functionality with the database.
Title: Message Title Rob Browning assigned an issue to Unassigned PuppetDB / PDB-1447 remove late-project/basic-project and supply the functionality with the database. Change By: Rob Browning Assignee: RobBrowning Add Comment This message was sent by Atlassian JIRA (v6.3.15#6346-sha1:dbc023d) -- 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-1447) remove late-project/basic-project and supply the functionality with the database.
Title: Message Title Steve Barlow updated an issue PuppetDB / PDB-1447 remove late-project/basic-project and supply the functionality with the database. Change By: Steve Barlow Sprint: PuppetDB2015-05-06 ,PuppetDB2015-05-20 Add Comment This message was sent by Atlassian JIRA (v6.3.15#6346-sha1:dbc023d) -- 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-1447) remove late-project/basic-project and supply the functionality with the database.
Title: Message Title Wyatt Alt assigned an issue to Wyatt Alt PuppetDB / PDB-1447 remove late-project/basic-project and supply the functionality with the database. Change By: Wyatt Alt Assignee: WyattAlt Add Comment This message was sent by Atlassian JIRA (v6.3.15#6346-sha1:dbc023d) -- 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-1447) remove late-project/basic-project and supply the functionality with the database.
Title: Message Title Ryan Senior updated an issue PuppetDB / PDB-1447 remove late-project/basic-project and supply the functionality with the database. Change By: Ryan Senior Summary: removelate-project/basic-projectandsupplythefunctionalitywiththedatabase . Add Comment This message was sent by Atlassian JIRA (v6.3.15#6346-sha1:dbc023d) -- 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-1447) remove late-project/basic-project and supply the functionality with the database.
Title: Message Title Ryan Senior updated an issue PuppetDB / PDB-1447 remove late-project/basic-project and supply the functionality with the database. Change By: Ryan Senior Currentlywhenwequeryfactsthereisanimplicitselectionofthetypecolumn.Wedothisbecauseonthedatabasesidewecoalescethreecolumnsoffact_valuesintoasinglestringcolumnvalue.Thiscreatesissueswithgroup-byquerieslikethis:{code}/v4/facts-d'query=[extract,[[function,count],value],[=,name,operatingsystem],[group_by,value]]{code}sincetheselectedfieldsmustappearinthegrouping.Weshouldreturnasinglecolumnthatincludesbothtypeandvalueinformation. Agoodtestcaseforthisisacountoffactvalueslikeoperatingsystem Onewaytodothiswouldbetooverloadtheexistingvalue_jsoncolumnwithtypeinformation,andreturnthatsinglecolumnforallvaluequeries(maybeevenrenameit.) Add Comment This message was sent by Atlassian JIRA (v6.3.15#6346-sha1:dbc023d) -- 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-1447) remove late-project/basic-project and supply the functionality with the database
Title: Message Title Wyatt Alt updated an issue PuppetDB / PDB-1447 remove late-project/basic-project and supply the functionality with the database Change By: Wyatt Alt Sprint: PuppetDB2015-05-06 Add Comment This message was sent by Atlassian JIRA (v6.3.15#6346-sha1:dbc023d) -- 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-1447) remove late-project/basic-project and supply the functionality with the database
Title: Message Title Wyatt Alt created an issue PuppetDB / PDB-1447 remove late-project/basic-project and supply the functionality with the database Issue Type: Improvement Assignee: Unassigned Created: 2015/04/22 1:25 PM Fix Versions: PDB 3.0.0 Priority: Normal Reporter: Wyatt Alt Currently when we query facts there is an implicit selection of the type column. We do this because on the database side we coalesce three columns of fact_values into a single string column value. This creates issues with group-by queries like this: /v4/facts -d 'query=[extract,[[function,count],value], [=, name,operatingsystem], [group_by, value]] since the selected fields must appear in the grouping. We should return a single column that includes both type and value information. One way to do this would be to overload the existing value_json column with type information, and return that single column for all