Jira (PDB-2398) PuppetDB should enable emergency deletion of historical data

[Charlie Sharpsteen (JIRA)]

Title: Message Title

Charlie Sharpsteen commented on PDB-2398   Re: PuppetDB should enable emergency deletion of historical data Currently, in PDB 3.x, the certnames_reports_id_fkey constraint is what propagates TRUNCATE CASCADE beyond the reports and resource_events tables: pe-puppetdb=# \d+ reports Table "public.reports" Column | Type | Modifiers | Storage | Stats target | Description -----------------------+--------------------------+------------------------------------------------------+----------+--------------+------------- id | bigint | not null default nextval('reports_id_seq'::regclass) | plain | | hash | bytea | not null | extended | | transaction_uuid | uuid | | plain | | certname | text | not null | extended | | puppet_version | character varying(255) | not null | extended | | report_format | smallint | not null | plain | | configuration_version | character varying(255) | not null | extended | | start_time | timestamp with time zone | not null | plain | | end_time | timestamp with time zone | not null | plain | | receive_time | timestamp with time zone | not null | plain | | noop | boolean | | plain | | environment_id | bigint | | plain | | status_id | bigint | | plain | | metrics_json | json | | extended | | logs_json | json | | extended | | producer_timestamp | timestamp with time zone | not null | plain | | metrics | jsonb | | extended | | logs | jsonb | | extended | | resources | jsonb | | extended | | Indexes: "reports_pkey" PRIMARY KEY, btree (id) "reports_hash_expr_idx" UNIQUE, btree (ltrim(hash::text, '\x'::text)) "idx_reports_producer_timestamp" btree (producer_timestamp) "reports_certname_idx" btree (certname) "reports_end_time_idx" btree (end_time) "reports_environment_id_idx" btree (environment_id) "reports_status_id_idx" btree (status_id) "reports_tx_uuid_expr_idx" btree ((transaction_uuid::text)) Foreign-key constraints: "reports_certname_fkey" FOREIGN KEY (certname) REFERENCES certnames(certname) ON DELETE CASCADE "reports_env_fkey" FOREIGN KEY (environment_id) REFERENCES environments(id) ON DELETE CASCADE "reports_status_fkey" FOREIGN KEY (status_id) REFERENCES report_statuses(id) ON DELETE CASCADE Referenced by: TABLE "certnames" CONSTRAINT "certnames_reports_id_fkey" FOREIGN KEY (latest_report_id) REFERENCES reports(id) ON DELETE SET NULL TABLE "resource_events" CONSTRAINT "resource_events_report_id_fkey" FOREIGN KEY (report_id) REFERENCES reports(id) ON DELETE CASCADE Add Comment   This message was sent by Atlassian JIRA (v6.4.12#64027-sha1:e3691cc) -- 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 post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.