https://www.puppet.com/community logo
Join Slack
Powered by
# puppet-enterprise
  • v

    vchepkov

    09/14/2022, 3:23 PM
    jira tickets also all caps
  • b

    bastelfreak

    09/14/2022, 3:27 PM
    in FOSS environments, r10k converts JIRA-1234 to JIRA_1234 and that works totally fine for the puppet agent
  • b

    bastelfreak

    09/14/2022, 3:28 PM
    in PE it just seems to break task/plan support
  • g

    Glen Mangiantini

    09/14/2022, 3:46 PM
    The r10k configuration option that adjusts the git branch names to conform to Puppet standards is invalid_branches: "correct" and this can be set in /etc/puppetlabs/puppetserver/conf.d/code-manager.conf. Posting this because it took me a while to find where to set it. I don't know if this would also help with tasks/plans.
  • v

    vchepkov

    09/14/2022, 3:47 PM
    That's what I posted above
  • v

    vchepkov

    09/14/2022, 3:47 PM
    it's just not lowercase the environment name
  • v

    vchepkov

    09/14/2022, 3:48 PM
    it's just not lowercase the environment name
  • h

    hbui

    09/14/2022, 5:07 PM
    We're trying to start using stdlib 8.1.0 on PE 2019.8.12 and are getting this error:
    Copy code
    2022-09-14T09:23:59.017-05:00 ERROR [qtp521455647-138959] [p.r.core] Internal Server Error: org.jruby.exceptions.LoadError: (LoadError) no such file to load -- puppet_x/stdlib
    
            at org.jruby.RubyKernel.require(org/jruby/RubyKernel.java:974)
    any tips on getting stdlib 8.1 working on PE 2019?
  • v

    vchepkov

    09/14/2022, 5:30 PM
    I have 2019.8.11 with stdlib 8.4.0, haven't seen any issues
  • h

    hbui

    09/14/2022, 6:26 PM
    good to know
  • m

    Marty Ewings

    09/15/2022, 2:42 PM
    do you have compilers or anything? could be a filesync issue @hbui
  • m

    Marty Ewings

    09/15/2022, 2:42 PM
    do you have compilers or anything? could be a filesync issue @hbui
  • h

    hbui

    09/15/2022, 2:44 PM
    it's a single server
  • s

    simonhoenscheid

    09/15/2022, 2:51 PM
    Hi Community, we have a very long running query in a customers puppet-db postgres installation, is there an option to configure it to run more frequently?:
    Copy code
    DELETE FROM resource_params_cache WHERE NOT EXISTS ( SELECT * FROM catalog_resources cr WHERE cr.resource = resource_params_cache.resource);
  • s

    simonhoenscheid

    09/15/2022, 2:52 PM
    Hi Community, we have a very long running query in a customers puppet-db postgres installation, is there an option to configure it to run more frequently?:
    Copy code
    DELETE FROM resource_params_cache WHERE NOT EXISTS ( SELECT * FROM catalog_resources cr WHERE cr.resource = resource_params_cache.resource);
  • s

    simonhoenscheid

    09/15/2022, 3:03 PM
    This query is blocking the database for 5+ hours on a regular basis
  • y

    Yorokobi

    09/15/2022, 3:04 PM
    If you're deleting records regularly, are you also (auto)vacuuming the tables?
  • s

    simonhoenscheid

    09/15/2022, 3:05 PM
    running this query every 30 or 60 minutes would be much more convenient
  • s

    simonhoenscheid

    09/15/2022, 3:05 PM
    @Yorokobi yes we do
  • b

    bastelfreak

    09/15/2022, 3:30 PM
    so the query is coming from https://github.com/puppetlabs/puppetdb/blob/6.22.1/src/puppetlabs/puppetdb/scf/storage.clj#L969-L976
  • b

    bastelfreak

    09/15/2022, 3:30 PM
    so the query is coming from https://github.com/puppetlabs/puppetdb/blob/6.22.1/src/puppetlabs/puppetdb/scf/storage.clj#L969-L976
  • b

    bastelfreak

    09/15/2022, 3:32 PM
    and we see 457 million deleted tuples in
    resource_params
    within a week
  • b

    bastelfreak

    09/15/2022, 3:32 PM
    which is... a lot?
  • b

    bastelfreak

    09/15/2022, 3:34 PM
    and the query runs for up to 6 hours and blocks some other inserts
  • b

    bastelfreak

    09/15/2022, 3:35 PM
    It would really help a lot if it had a
    LIMIT 1000000
    or similar and would execute multiple times
  • b

    bastelfreak

    09/15/2022, 3:43 PM
    in the meantime, • do we have an option to run it more often? • can someone explain why there is so data/is it supposed to be that much?
  • b

    bastelfreak

    09/15/2022, 7:06 PM
    aha! https://github.com/puppetlabs/puppetdb/blob/b3d6d10555561657150fa70b6d1e609fba9c0eda/src/puppetlabs/puppetdb/cli/services.clj#L399
  • b

    bastelfreak

    09/15/2022, 7:06 PM
    aha! https://github.com/puppetlabs/puppetdb/blob/b3d6d10555561657150fa70b6d1e609fba9c0eda/src/puppetlabs/puppetdb/cli/services.clj#L399
  • b

    bastelfreak

    09/15/2022, 7:09 PM
    so I could curl the cmd api and trigger a manual delete for resource_params with the
    other
    key
  • b

    bastelfreak

    09/15/2022, 7:09 PM
    I just dont yet understand how puppetdb schedules the garbage collection
1...252627...73Latest