insights: After oob-migration, all backend insights showed as waiting on processing
Created by: CristinaBirkel
Okay I didn't realize we were intentionally wiping all of the insight_series
as part of the migration. I'm actually not sure we should do this.. from 1000000022_settings_migration_wipe_definition_tables.up.sql
:
TRUNCATE insight_view CASCADE;
TRUNCATE insight_series CASCADE;
TRUNCATE dashboard CASCADE;
Should we be leaving the series alone? Otherwise it will result in this re-processing. Or maybe this isn't a huge deal.
UPDATE: The idea will be to find series_points
based on their hashed id field and fixup the ids of those series_points
so that they match the new series that they correspond to. I would also imagine that the insight_query_runner_jobs
need to be updated as well.