You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
These were incorrectly classified as "not in use" and omitted from the early migrations (where they should have been). They should now be added to the database. They are:
monthly_agg
daily_agg
daily_view
hourly_view
Their removal from CRMP2 so that the migration to revision 879f0efa125f could proceed is documented in a Redmine issue. That issue also contains definitions of all views removed, in case they were removed in error (which they were).
These views have the following dependency relations (dependency indented below dependent):
monthly_agg (view; dropped)
daily_agg (view; dropped)
daily_view (view; dropped)
meta_vars (table; exists)
obs_raw (table; exists)
meta_history (table; exists)
obs_raw_native_flags (table; exists)
meta_native_flag USING (table; exists)
obs_raw_pcic_flags (table; exists)
meta_pcic_flag (table; exists)
hourly_view
meta_vars (table; exists)
obs_raw (table; exists)
meta_history (table; exists)
obs_raw_native_flags (table; exists)
meta_native_flag USING (table; exists)
obs_raw_pcic_flags (table; exists)
meta_pcic_flag (table; exists)
This analysis indicates that the only objects that need to be restored are the 4 views listed above; all other dependents exist.
The original errors were provoked by a migration step attempting to alter the type of column meta_vars.net_var_name. That alteration has now been performed, so the views can be restored using the same definitions or with slight modifications. All information needed for that is in the Redmine issue.
The text was updated successfully, but these errors were encountered:
These were incorrectly classified as "not in use" and omitted from the early migrations (where they should have been). They should now be added to the database. They are:
monthly_agg
daily_agg
daily_view
hourly_view
Their removal from CRMP2 so that the migration to revision 879f0efa125f could proceed is documented in a Redmine issue. That issue also contains definitions of all views removed, in case they were removed in error (which they were).
These views have the following dependency relations (dependency indented below dependent):
monthly_agg
(view; dropped)daily_agg
(view; dropped)daily_view
(view; dropped)meta_vars
(table; exists)obs_raw
(table; exists)meta_history
(table; exists)obs_raw_native_flags
(table; exists)meta_native_flag
USING (table; exists)obs_raw_pcic_flags
(table; exists)meta_pcic_flag
(table; exists)meta_vars
(table; exists)obs_raw
(table; exists)meta_history
(table; exists)obs_raw_native_flags
(table; exists)meta_native_flag
USING (table; exists)obs_raw_pcic_flags
(table; exists)meta_pcic_flag
(table; exists)This analysis indicates that the only objects that need to be restored are the 4 views listed above; all other dependents exist.
The original errors were provoked by a migration step attempting to alter the type of column
meta_vars.net_var_name
. That alteration has now been performed, so the views can be restored using the same definitions or with slight modifications. All information needed for that is in the Redmine issue.The text was updated successfully, but these errors were encountered: