Skip to main content

mz_catalog/durable/
upgrade.rs

1// Copyright Materialize, Inc. and contributors. All rights reserved.
2//
3// Use of this software is governed by the Business Source License
4// included in the LICENSE file.
5//
6// As of the Change Date specified in that file, in accordance with
7// the Business Source License, use of this software will be governed
8// by the Apache License, Version 2.0.
9
10//! This module contains all the helpers and code paths for upgrading/migrating the `Catalog`.
11//!
12//! We facilitate migrations by keeping snapshots of the objects we previously stored, and relying
13//! entirely on these snapshots. These snapshots exist in the [`mz_catalog_protos`] crate in the
14//! form of `catalog-protos/protos/objects_vXX.proto`. By maintaining and relying on snapshots we
15//! don't have to worry about changes elsewhere in the codebase effecting our migrations because
16//! our application and serialization logic is decoupled, and the objects of the Catalog for a
17//! given version are "frozen in time".
18//!
19//! > **Note**: The protobuf snapshot files themselves live in a separate crate because it takes a
20//!             relatively significant amount of time to codegen and build them. By placing them in
21//!             a separate crate we don't have to pay this compile time cost when building the
22//!             catalog, allowing for faster iteration.
23//!
24//! You cannot make any changes to the following message or anything that they depend on:
25//!
26//!   - Config
27//!   - Setting
28//!   - FenceToken
29//!   - AuditLog
30//!
31//! When you want to make a change to the `Catalog` you need to follow these steps:
32//!
33//! 1. Check the current [`CATALOG_VERSION`], make sure an `objects_v<CATALOG_VERSION>.proto` file
34//!    exists. If one doesn't, copy and paste the current `objects.proto` file, renaming it to
35//!    `objects_v<CATALOG_VERSION>.proto`.
36//! 2. Bump [`CATALOG_VERSION`] by one.
37//! 3. Make your changes to `objects.proto`.
38//! 4. Copy and paste `objects.proto`, naming the copy `objects_v<CATALOG_VERSION>.proto`. Update
39//!    the package name of the `.proto` to `package objects_v<CATALOG_VERSION>;`
40//! 5. We should now have a copy of the protobuf objects as they currently exist, and a copy of
41//!    how we want them to exist. For example, if the version of the Catalog before we made our
42//!    changes was 15, we should now have `objects_v15.proto` and `objects_v16.proto`.
43//! 6. Rebuild Materialize which will error because the hashes stored in
44//!    `src/catalog-protos/protos/hashes.json` have now changed. Update these to match the new
45//!    hashes for objects.proto and `objects_v<CATALOG_VERSION>.proto`.
46//! 7. Add `v<CATALOG_VERSION>` to the call to the `objects!` macro in this file
47//! 8. Add a new file to `catalog/src/durable/upgrade` which is where we'll put the new migration
48//!    path.
49//! 9. Write upgrade functions using the two versions of the protos we now have, e.g.
50//!    `objects_v15.proto` and `objects_v16.proto`. In this migration code you __should not__
51//!    import any defaults or constants from elsewhere in the codebase, because then a future
52//!    change could then impact a previous migration.
53//! 10. Add an import for your new module to this file: mod v<CATALOG_VERSION-1>_to_v<CATALOG_VERSION>;
54//! 11. Call your upgrade function in [`run_upgrade()`].
55//! 12. Generate a test file for the new version:
56//!     ```ignore
57//!     cargo test --package mz-catalog --lib durable::upgrade::tests::generate_missing_encodings -- --ignored
58//!     ```
59//!
60//! When in doubt, reach out to the Surfaces team, and we'll be more than happy to help :)
61
62pub mod json_compatible;
63#[cfg(test)]
64mod tests;
65
66use mz_ore::{soft_assert_eq_or_log, soft_assert_ne_or_log};
67use mz_repr::Diff;
68use paste::paste;
69#[cfg(test)]
70use proptest::prelude::*;
71#[cfg(test)]
72use proptest::strategy::ValueTree;
73#[cfg(test)]
74use proptest_derive::Arbitrary;
75use timely::progress::Timestamp as TimelyTimestamp;
76
77use crate::durable::initialize::USER_VERSION_KEY;
78use crate::durable::objects::serialization::proto;
79use crate::durable::objects::state_update::{
80    IntoStateUpdateKindJson, StateUpdate, StateUpdateKind, StateUpdateKindJson,
81};
82use crate::durable::persist::{Mode, Timestamp, UnopenedPersistCatalogState};
83use crate::durable::{CatalogError, DurableCatalogError};
84
85#[cfg(test)]
86const ENCODED_TEST_CASES: usize = 100;
87
88/// Generate per-version support code.
89///
90/// Here we have to deal with the fact that the pre-v79 objects had a protobuf-generated format,
91/// which gives them additional levels of indirection that the post-v79 objects don't have and thus
92/// requires slightly different code to be generated.
93macro_rules! objects {
94    ( [$( $x_old:ident ),*], [$( $x:ident ),*] ) => {
95        paste! {
96            $(
97                pub(crate) mod [<objects_ $x_old>] {
98                    pub use mz_catalog_protos::[<objects_ $x_old>]::*;
99
100                    use crate::durable::objects::state_update::StateUpdateKindJson;
101
102                    impl From<StateUpdateKind> for StateUpdateKindJson {
103                        fn from(value: StateUpdateKind) -> Self {
104                            let kind = value.kind.expect("kind should be set");
105                            // TODO: This requires that the json->proto->json roundtrips
106                            // exactly, see database-issues#7179.
107                            StateUpdateKindJson::from_serde(&kind)
108                        }
109                    }
110
111                    impl From<StateUpdateKindJson> for StateUpdateKind {
112                        fn from(value: StateUpdateKindJson) -> Self {
113                            let kind: state_update_kind::Kind = value.to_serde();
114                            StateUpdateKind { kind: Some(kind) }
115                        }
116                    }
117                }
118            )*
119
120            $(
121                pub(crate) mod [<objects_ $x>] {
122                    pub use mz_catalog_protos::[<objects_ $x>]::*;
123
124                    use crate::durable::objects::state_update::StateUpdateKindJson;
125
126                    impl From<StateUpdateKind> for StateUpdateKindJson {
127                        fn from(value: StateUpdateKind) -> Self {
128                            // TODO: This requires that the json->proto->json roundtrips
129                            // exactly, see database-issues#7179.
130                            StateUpdateKindJson::from_serde(&value)
131                        }
132                    }
133
134                    impl From<StateUpdateKindJson> for StateUpdateKind {
135                        fn from(value: StateUpdateKindJson) -> Self {
136                            value.to_serde()
137                        }
138                    }
139                }
140            )*
141
142            // Generate test helpers for each version.
143
144            #[cfg(test)]
145            #[derive(Debug, Arbitrary)]
146            enum AllVersionsStateUpdateKind {
147                $(
148                    [<$x_old:upper>](crate::durable::upgrade::[<objects_ $x_old>]::StateUpdateKind),
149                )*
150                $(
151                    [<$x:upper>](crate::durable::upgrade::[<objects_ $x>]::StateUpdateKind),
152                )*
153            }
154
155            #[cfg(test)]
156            impl AllVersionsStateUpdateKind {
157                #[cfg(test)]
158                fn arbitrary_vec(version: &str) -> Result<Vec<Self>, String> {
159                    let mut runner = proptest::test_runner::TestRunner::deterministic();
160                    std::iter::repeat(())
161                        .filter_map(|_| {
162                            AllVersionsStateUpdateKind::arbitrary(version, &mut runner)
163                                .transpose()
164                        })
165                        .take(ENCODED_TEST_CASES)
166                        .collect::<Result<_, _>>()
167                }
168
169                #[cfg(test)]
170                fn arbitrary(
171                    version: &str,
172                    runner: &mut proptest::test_runner::TestRunner,
173                ) -> Result<Option<Self>, String> {
174                    match version {
175                        $(
176                            concat!("objects_", stringify!($x_old)) => {
177                                let arbitrary_data =
178                                    crate::durable::upgrade
179                                        ::[<objects_ $x_old>]::StateUpdateKind::arbitrary()
180                                        .new_tree(runner)
181                                        .expect("unable to create arbitrary data")
182                                        .current();
183                                // Skip over generated data where kind is None
184                                // because they are not interesting or possible in
185                                // production. Unfortunately any of the inner fields
186                                // can still be None, which is also not possible in
187                                // production.
188                                // TODO(jkosh44) See if there's an arbitrary config
189                                // that forces Some.
190                                let arbitrary_data = if arbitrary_data.kind.is_some() {
191                                    Some(Self::[<$x_old:upper>](arbitrary_data))
192                                } else {
193                                    None
194                                };
195                                Ok(arbitrary_data)
196                            }
197                        )*
198                        $(
199                            concat!("objects_", stringify!($x)) => {
200                                let arbitrary_data =
201                                    crate::durable::upgrade
202                                        ::[<objects_ $x>]::StateUpdateKind::arbitrary()
203                                        .new_tree(runner)
204                                        .expect("unable to create arbitrary data")
205                                        .current();
206                                Ok(Some(Self::[<$x:upper>](arbitrary_data)))
207                            }
208                        )*
209                        _ => Err(format!("unrecognized version {version} add enum variant")),
210                    }
211                }
212
213                #[cfg(test)]
214                fn try_from_raw(version: &str, raw: StateUpdateKindJson) -> Result<Self, String> {
215                    match version {
216                        $(
217                            concat!("objects_", stringify!($x_old)) => Ok(Self::[<$x_old:upper>](raw.into())),
218                        )*
219                        $(
220                            concat!("objects_", stringify!($x)) => Ok(Self::[<$x:upper>](raw.into())),
221
222                        )*
223                        _ => Err(format!("unrecognized version {version} add enum variant")),
224                    }
225                }
226
227                #[cfg(test)]
228                fn raw(self) -> StateUpdateKindJson {
229                    match self {
230                        $(
231                            Self::[<$x_old:upper>](kind) => kind.into(),
232                        )*
233                        $(
234                            Self::[<$x:upper>](kind) => kind.into(),
235                        )*
236                    }
237                }
238            }
239        }
240    }
241}
242
243objects!(
244    [v74, v75, v76, v77, v78],
245    [
246        v79, v80, v81, v82, v83, v84, v85, v86, v87, v88, v89, v90, v91, v92
247    ]
248);
249
250/// The current version of the `Catalog`.
251pub use mz_catalog_protos::CATALOG_VERSION;
252/// The minimum `Catalog` version number that we support migrating from.
253pub use mz_catalog_protos::MIN_CATALOG_VERSION;
254
255// Note(parkmycar): Ideally we wouldn't have to define these extra constants,
256// but const expressions aren't yet supported in match statements.
257const TOO_OLD_VERSION: u64 = MIN_CATALOG_VERSION - 1;
258const FUTURE_VERSION: u64 = CATALOG_VERSION + 1;
259
260mod v74_to_v75;
261mod v75_to_v76;
262mod v76_to_v77;
263mod v77_to_v78;
264mod v78_to_v79;
265mod v79_to_v80;
266mod v80_to_v81;
267mod v81_to_v82;
268mod v82_to_v83;
269mod v83_to_v84;
270mod v84_to_v85;
271mod v85_to_v86;
272mod v86_to_v87;
273mod v87_to_v88;
274mod v88_to_v89;
275mod v89_to_v90;
276mod v90_to_v91;
277mod v91_to_v92;
278
279/// Describes a single action to take during a migration from `V1` to `V2`.
280#[derive(Debug, Clone, PartialEq, Eq, PartialOrd, Ord)]
281enum MigrationAction<V1: IntoStateUpdateKindJson, V2: IntoStateUpdateKindJson> {
282    /// Deletes the provided key.
283    #[allow(unused)]
284    Delete(V1),
285    /// Inserts the provided key-value pair. The key must not currently exist!
286    #[allow(unused)]
287    Insert(V2),
288    /// Update the key-value pair for the provided key.
289    #[allow(unused)]
290    Update(V1, V2),
291}
292
293impl<V1: IntoStateUpdateKindJson, V2: IntoStateUpdateKindJson> MigrationAction<V1, V2> {
294    /// Converts `self` into a `Vec<StateUpdate<StateUpdateKindBinary>>` that can be appended
295    /// to persist.
296    fn into_updates(self) -> Vec<(StateUpdateKindJson, Diff)> {
297        match self {
298            MigrationAction::Delete(kind) => {
299                vec![(kind.into(), Diff::MINUS_ONE)]
300            }
301            MigrationAction::Insert(kind) => {
302                vec![(kind.into(), Diff::ONE)]
303            }
304            MigrationAction::Update(old_kind, new_kind) => {
305                vec![
306                    (old_kind.into(), Diff::MINUS_ONE),
307                    (new_kind.into(), Diff::ONE),
308                ]
309            }
310        }
311    }
312}
313
314/// Upgrades the data in the catalog to version [`CATALOG_VERSION`].
315///
316/// Returns the current upper after all migrations have executed.
317#[mz_ore::instrument(name = "persist::upgrade", level = "debug")]
318pub(crate) async fn upgrade(
319    persist_handle: &mut UnopenedPersistCatalogState,
320    mut commit_ts: Timestamp,
321) -> Result<Timestamp, CatalogError> {
322    soft_assert_ne_or_log!(
323        persist_handle.upper,
324        Timestamp::minimum(),
325        "cannot upgrade uninitialized catalog"
326    );
327
328    // Consolidate to avoid migrating old state.
329    persist_handle.consolidate();
330    let mut version = persist_handle
331        .get_user_version()
332        .await?
333        .expect("initialized catalog must have a version");
334    // Run migrations until we're up-to-date.
335    while version < CATALOG_VERSION {
336        (version, commit_ts) = run_upgrade(persist_handle, version, commit_ts).await?;
337    }
338
339    Ok(commit_ts)
340}
341
342/// Determines which upgrade to run for the `version` and executes it.
343///
344/// Returns the new version and upper.
345async fn run_upgrade(
346    unopened_catalog_state: &mut UnopenedPersistCatalogState,
347    version: u64,
348    commit_ts: Timestamp,
349) -> Result<(u64, Timestamp), CatalogError> {
350    let incompatible = DurableCatalogError::IncompatibleDataVersion {
351        found_version: version,
352        min_catalog_version: MIN_CATALOG_VERSION,
353        catalog_version: CATALOG_VERSION,
354    }
355    .into();
356
357    match version {
358        ..=TOO_OLD_VERSION => Err(incompatible),
359
360        74 => {
361            run_versioned_upgrade(
362                unopened_catalog_state,
363                version,
364                commit_ts,
365                v74_to_v75::upgrade,
366            )
367            .await
368        }
369        75 => {
370            run_versioned_upgrade(
371                unopened_catalog_state,
372                version,
373                commit_ts,
374                v75_to_v76::upgrade,
375            )
376            .await
377        }
378        76 => {
379            run_versioned_upgrade(
380                unopened_catalog_state,
381                version,
382                commit_ts,
383                v76_to_v77::upgrade,
384            )
385            .await
386        }
387        77 => {
388            run_versioned_upgrade(
389                unopened_catalog_state,
390                version,
391                commit_ts,
392                v77_to_v78::upgrade,
393            )
394            .await
395        }
396        78 => {
397            run_versioned_upgrade(
398                unopened_catalog_state,
399                version,
400                commit_ts,
401                v78_to_v79::upgrade,
402            )
403            .await
404        }
405        79 => {
406            run_versioned_upgrade(
407                unopened_catalog_state,
408                version,
409                commit_ts,
410                v79_to_v80::upgrade,
411            )
412            .await
413        }
414        80 => {
415            run_versioned_upgrade(
416                unopened_catalog_state,
417                version,
418                commit_ts,
419                v80_to_v81::upgrade,
420            )
421            .await
422        }
423        81 => {
424            run_versioned_upgrade(
425                unopened_catalog_state,
426                version,
427                commit_ts,
428                v81_to_v82::upgrade,
429            )
430            .await
431        }
432        // v82→v83 is a one-shot byte-level repair, not a proto evolution. It
433        // needs raw access to the snapshot's diffs (which `run_versioned_upgrade`
434        // strips) so it plugs into `run_upgrade` directly.
435        82 => v82_to_v83::upgrade(unopened_catalog_state, commit_ts).await,
436        83 => v83_to_v84::upgrade(unopened_catalog_state, commit_ts).await,
437        84 => {
438            run_versioned_upgrade(
439                unopened_catalog_state,
440                version,
441                commit_ts,
442                v84_to_v85::upgrade,
443            )
444            .await
445        }
446        85 => {
447            run_versioned_upgrade(
448                unopened_catalog_state,
449                version,
450                commit_ts,
451                v85_to_v86::upgrade,
452            )
453            .await
454        }
455        86 => {
456            run_versioned_upgrade(
457                unopened_catalog_state,
458                version,
459                commit_ts,
460                v86_to_v87::upgrade,
461            )
462            .await
463        }
464        87 => {
465            run_versioned_upgrade(
466                unopened_catalog_state,
467                version,
468                commit_ts,
469                v87_to_v88::upgrade,
470            )
471            .await
472        }
473        88 => {
474            run_versioned_upgrade(
475                unopened_catalog_state,
476                version,
477                commit_ts,
478                v88_to_v89::upgrade,
479            )
480            .await
481        }
482        89 => {
483            run_versioned_upgrade(
484                unopened_catalog_state,
485                version,
486                commit_ts,
487                v89_to_v90::upgrade,
488            )
489            .await
490        }
491        90 => {
492            run_versioned_upgrade(
493                unopened_catalog_state,
494                version,
495                commit_ts,
496                v90_to_v91::upgrade,
497            )
498            .await
499        }
500        91 => {
501            run_versioned_upgrade(
502                unopened_catalog_state,
503                version,
504                commit_ts,
505                v91_to_v92::upgrade,
506            )
507            .await
508        }
509        // Up-to-date, no migration needed!
510        CATALOG_VERSION => Ok((CATALOG_VERSION, commit_ts)),
511        FUTURE_VERSION.. => Err(incompatible),
512    }
513}
514
515/// Runs `migration_logic` on the contents of the current catalog assuming a current version of
516/// `current_version`.
517///
518/// Returns the new version and upper.
519async fn run_versioned_upgrade<V1: IntoStateUpdateKindJson, V2: IntoStateUpdateKindJson>(
520    unopened_catalog_state: &mut UnopenedPersistCatalogState,
521    current_version: u64,
522    mut commit_ts: Timestamp,
523    migration_logic: impl FnOnce(Vec<V1>) -> Vec<MigrationAction<V1, V2>>,
524) -> Result<(u64, Timestamp), CatalogError> {
525    tracing::info!(current_version, "running versioned Catalog upgrade");
526
527    // 1. Use the V1 to deserialize the contents of the current snapshot.
528    let snapshot: Vec<_> = unopened_catalog_state
529        .snapshot
530        .iter()
531        .map(|(kind, ts, diff)| {
532            soft_assert_eq_or_log!(
533                *diff,
534                Diff::ONE,
535                "snapshot is consolidated, ({kind:?}, {ts:?}, {diff:?})"
536            );
537            V1::try_from(kind.clone()).expect("invalid catalog data persisted")
538        })
539        .collect();
540
541    // 2. Generate updates from version specific migration logic.
542    let migration_actions = migration_logic(snapshot);
543    let mut updates: Vec<_> = migration_actions
544        .into_iter()
545        .flat_map(|action| action.into_updates().into_iter())
546        .collect();
547    // Validate that we're not migrating an un-migratable collection.
548    for (update, _) in &updates {
549        if update.is_always_deserializable() {
550            panic!("migration to un-migratable collection: {update:?}\nall updates: {updates:?}");
551        }
552    }
553
554    // 3. Add a retraction for old version and insertion for new version into updates.
555    let next_version = current_version + 1;
556    let version_retraction = (version_update_kind(current_version), Diff::MINUS_ONE);
557    updates.push(version_retraction);
558    let version_insertion = (version_update_kind(next_version), Diff::ONE);
559    updates.push(version_insertion);
560
561    // 4. Apply migration to catalog.
562    if matches!(unopened_catalog_state.mode, Mode::Writable) {
563        commit_ts = unopened_catalog_state
564            .compare_and_append(updates, commit_ts)
565            .await
566            .map_err(|e| e.unwrap_fence_error())?;
567    } else {
568        let ts = commit_ts;
569        let updates = updates
570            .into_iter()
571            .map(|(kind, diff)| StateUpdate { kind, ts, diff });
572        commit_ts = commit_ts.step_forward();
573        unopened_catalog_state.apply_updates_and_consolidate(updates)?;
574    }
575
576    // 5. Consolidate snapshot to remove old versions.
577    unopened_catalog_state.consolidate();
578
579    Ok((next_version, commit_ts))
580}
581
582/// Generates a [`proto::StateUpdateKind`] to update the user version.
583fn version_update_kind(version: u64) -> StateUpdateKindJson {
584    // We can use the current version because Configs can never be migrated and are always wire
585    // compatible.
586    StateUpdateKind::Config(
587        proto::ConfigKey {
588            key: USER_VERSION_KEY.to_string(),
589        },
590        proto::ConfigValue { value: version },
591    )
592    .into()
593}