Uploaded image for project: 'PuppetDB'
  1. PuppetDB
  2. PDB-5559

Ensure partition drops and migrations can eliminate all competitors

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Normal
    • Resolution: Fixed
    • None
    • PDB 6.22.2, PDB 7.12.0
    • PuppetDB
    • None
    • Skeletor
    • 1
    • Skeletor 11/23/2022, Skeletor 12/07/2022
    • Needs Assessment
    • Bug Fix
    • Hide
      The coordination of report-related garbage collection has been improved. Previously, if a separate `read-database` user were configured, incoming queries could block the garbage collection. Whenever a separate `read-database` user *is* specified, the normal (write) database user must have the right to terminate the read user's queries. The [recommended configuration]({{puppetdb}}/configure_postgres.html) has been updated to include a suitable `grant puppetdb_read to puppetdb`.

      The coordination of migrations has also been improved. Previously if a separate `read-database` user were configured, it wouldn't actually be evicted during migrations. Note that the migrator user (role) must have the ability to terminate the read user's connections. The [recommended configuration]({{puppetdb}}/configure_postgres.html) accomplishes this by granting the write user's role to the migrator via the `grant puppetdb to puppetdb_migrator`, which allows the migrator to terminate the read user's connections indirectly via the write user's membership in the read user's role, as described above.
      Show
      The coordination of report-related garbage collection has been improved. Previously, if a separate `read-database` user were configured, incoming queries could block the garbage collection. Whenever a separate `read-database` user *is* specified, the normal (write) database user must have the right to terminate the read user's queries. The [recommended configuration]({{puppetdb}}/configure_postgres.html) has been updated to include a suitable `grant puppetdb_read to puppetdb`. The coordination of migrations has also been improved. Previously if a separate `read-database` user were configured, it wouldn't actually be evicted during migrations. Note that the migrator user (role) must have the ability to terminate the read user's connections. The [recommended configuration]({{puppetdb}}/configure_postgres.html) accomplishes this by granting the write user's role to the migrator via the `grant puppetdb to puppetdb_migrator`, which allows the migrator to terminate the read user's connections indirectly via the write user's membership in the read user's role, as described above.
    • Needs Assessment

    Description

      Make sure that partition drops and migration coordination have the rights to and always do terminate both the read and write users.  See the commit messages, doc changes, and release notes for additional information.

      Attachments

        Activity

          People

            rob.browning Rob Browning
            rob.browning Rob Browning
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Zendesk Support