Hey there folks, We're using puppetdb and we see this error fairly regularly in our logs. Anyone have any ideas? We're using puppet8 under FreeBSD, with postgres 17.
2025-06-18T00:46:27+00:00 repo-us postgres [local0.warning] [7-1] 2025-06-18 00:46:27.415 UTC [93417] ERROR: no partition of relation "reports_historical" found for row 2025-06-18T00:46:27+00:00 repo-us postgres [local0.warning] [7-2] 2025-06-18 00:46:27.415 UTC [93417] DETAIL: Partition key of the failing row contains (producer_timestamp) = (2025-06-18 00:16:27.044+00). 2025-06-18T00:46:27+00:00 repo-us postgres [local0.warning] [7-3] 2025-06-18 00:46:27.415 UTC [93417] STATEMENT: UPDATE reports SET latest = $1 WHERE latest = true and certname = $2 We don't have any reports_ttl set or anything like that, only a node_ttl which is at 365d. Any other info that would help? -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/puppet-users/4b2e2328-6682-45cf-abab-c29629975240n%40googlegroups.com.
