Jira (PDB-5534) PuppetDB query slowdown with Postgres 9.6.4
Title: Message Title
Zaeem Arshad commented on PDB-5534
Re: PuppetDB query slowdown with Postgres 9.6.4
Austin Blatt This is the query:
WITH inactive_nodes AS (SELECT certname FROM certnames WHERE (deactivated IS NOT NULL AND deactivated > '2022-08-18T23:59:00.376Z') OR (expired IS NOT NULL and expired > '2022-08-18T23:59:00.376Z')), not_active_nodes AS (SELECT certname FROM certnames WHERE (deactivated IS NOT NULL OR expired IS NOT NULL)) SELECT certnames.certname AS "certname" FROM certnames LEFT JOIN catalogs ON catalogs.certname = certnames.certname LEFT JOIN factsets fs ON certnames.certname = fs.certname LEFT JOIN reports ON (certnames.certname = reports.certname AND certnames.latest_report_id = reports.id) LEFT JOIN environments catalog_environment ON catalog_environment.id = catalogs.environment_id LEFT JOIN report_statuses ON reports.status_id = report_statuses.id LEFT JOIN environments facts_environment ON facts_environment.id = fs.environment_id LEFT JOIN environments reports_environment ON reports_environment.id = reports.environment_id WHERE certnames.certname) in (SELECT certname FROM ( (SELECT fc.certname AS "certname" FROM (select certname, flattened.* from factsets fs left join lateral ( with recursive flattened_one (parent_path, parent_types, key, value, type) as ( select array[]::text[], '', (jsonb_each(fs.stable||fs.volatile))., 's' union all select parent_path || flattened_one.key, parent_types || flattened_one.type, sub_paths.key, sub_paths.value, sub_paths.type from flattened_one inner join lateral ( select (jsonb_each(value))., 's' as type where jsonb_typeof(value) = 'object' union all select generate_series::text as key, value->generate_series as value, 'i' as type from generate_series(0, jsonb_array_length(value) - 1) where jsonb_typeof(value) = 'array' ) as sub_paths on true ) select environment_id, parent_path || key as path, parent_types || type as types, coalesce(parent_path[1], key) as name, value from flattened_one where not jsonb_typeof(value) = any('{"array", "object"}') ) as flattened on true) fc LEFT JOIN environments env ON fc.environment_id = env.id WHERE ((fc.path = (array['bc_cluster']) and fc.types = 's') AND (jsonb_typeof("value") = 'string' AND (value = '"store-resque-cell-2"' ) sub)) AND ((certnames.certname) in (SELECT certname FROM ( (SELECT fc.certname AS "certname" FROM (select certname, flattened.* from factsets fs left join lateral ( with recursive flattened_one (parent_path, parent_types, key, value, type) as ( select array[]::text[], '', (jsonb_each(fs.stable||fs.volatile))., 's' union all select parent_path || flattened_one.key, parent_types || flattened_one.type, sub_paths.key, sub_paths.value, sub_paths.type from flattened_one inner join lateral ( select (jsonb_each(value))., 's' as type where jsonb_typeof(value) = 'object'
Jira (FACT-3135) YAML anchors no longer function properly in Facter 4
Title: Message Title Aria Li updated an issue Facter / FACT-3135 YAML anchors no longer function properly in Facter 4 Change By: Aria Li Release Notes Summary: This change enabled YAML anchors in Facter 4, a feature that was available previously in Facter 3. Additionally, testing was added to ensure Facter continues to behave as expected when handling YAML anchors. Add Comment This message was sent by Atlassian Jira (v8.20.11#820011-sha1:0629dd8) -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.454471.1657297143000.28997.1662593700193%40Atlassian.JIRA.
Jira (FACT-3135) YAML anchors no longer function properly in Facter 4
Title: Message Title Aria Li updated an issue Facter / FACT-3135 YAML anchors no longer function properly in Facter 4 Change By: Aria Li Release Notes: Bug Fix Add Comment This message was sent by Atlassian Jira (v8.20.11#820011-sha1:0629dd8) -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.454471.1657297143000.28993.1662593640140%40Atlassian.JIRA.
Jira (FACT-3142) Add support for Mariner to Facter
Title: Message Title Morgan Rhodes updated an issue Facter / FACT-3142 Add support for Mariner to Facter Change By: Morgan Rhodes Team: Phoenix Add Comment This message was sent by Atlassian Jira (v8.20.11#820011-sha1:0629dd8) -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.466226.1661986076000.28818.1662585360048%40Atlassian.JIRA.
Jira (PUP-11603) Puppet Wont Write SELinux Labels on ZFS
Title: Message Title Michael Hashizume updated an issue Puppet / PUP-11603 Puppet Wont Write SELinux Labels on ZFS Change By: Michael Hashizume Release Notes: Enhancement Release Notes Summary: Marks ZFS as an SELinux-Capable Filesystem Add Comment This message was sent by Atlassian Jira (v8.20.11#820011-sha1:0629dd8) -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.458513.1659699296000.28809.1662584100116%40Atlassian.JIRA.
Jira (PUP-11552) Puppet on Ruby 3.1 warns about ERB passing safe_level as non-keyword argument
Title: Message Title Michael Hashizume updated an issue Puppet / PUP-11552 Puppet on Ruby 3.1 warns about ERB passing safe_level as non-keyword argument Change By: Michael Hashizume Release Notes: Enhancement Release Notes Summary: Passes ERB arguments as keywords Add Comment This message was sent by Atlassian Jira (v8.20.11#820011-sha1:0629dd8) -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.451982.1655286432000.28808.1662584100044%40Atlassian.JIRA.
Jira (PUP-11586) Add Documentation field to systemd unit
Title: Message Title Michael Hashizume updated an issue Puppet / PUP-11586 Add Documentation field to systemd unit Change By: Michael Hashizume Fix Version/s: PUP 7.19.0 Add Comment This message was sent by Atlassian Jira (v8.20.11#820011-sha1:0629dd8) -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.454118.1657035482000.28806.1662583800081%40Atlassian.JIRA.
Jira (FACT-3133) Facter 4 Does Not Support Built-In Windows Commands
Title: Message Title Michael Hashizume updated an issue Facter / FACT-3133 Facter 4 Does Not Support Built-In Windows Commands Change By: Michael Hashizume Fix Version/s: FACT 4.2.12 Add Comment This message was sent by Atlassian Jira (v8.20.11#820011-sha1:0629dd8) -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.453891.1656569785000.28803.1662583740168%40Atlassian.JIRA.
Jira (FACT-3135) YAML anchors no longer function properly in Facter 4
Title: Message Title Michael Hashizume updated an issue Facter / FACT-3135 YAML anchors no longer function properly in Facter 4 Change By: Michael Hashizume Fix Version/s: FACT 4.2.12 Add Comment This message was sent by Atlassian Jira (v8.20.11#820011-sha1:0629dd8) -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.454471.1657297143000.28804.1662583740217%40Atlassian.JIRA.
