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}