We've been noticing one of our foreman servers has been suffering from
major memory leaks on a weekly basis. Upon further investigation, we
believe it's related to the Trends functionality that's bringing the server
to it's knees. We only have 1 trend, and the entire trends page is
painfully slow, and when I attempted to delete the trend, it took hours to
finally spit out this message:
Warning!ERROR: update or delete on table "trends" violates foreign key
constraint "trend_counters_trend_id_fk" on table "trend_counters" DETAIL:
Key (id)=(2) is still referenced from table "trend_counters".
Any ideas on how to forcefully delete this trend?