Skip to content

Postgres warnings from PuppetDB #4020

@raybellis

Description

@raybellis

We're getting the following warnings every day from a clean PuppetDB 8 installation with Postgres 17:

[local0.warning] [7-1] 2025-06-02 00:41:48.906 UTC [53444] ERROR:  no partition of relation "reports_historical" found for row
[7-2] 2025-06-02 00:41:48.906 UTC [53444] DETAIL:  Partition key of the failing row contains (producer_timestamp) = (2025-06-02 00:11:48.939+00).
[local0.warning] [7-3] 2025-06-02 00:41:48.906 UTC [53444] STATEMENT:  UPDATE reports SET latest = $1 WHERE latest = true and certname = $2

Should I be concerned about them, or is there a simple schema fix to resolve them?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions