liveBook · Manning

Serialization anomaly

A serialization anomaly is an outcome of concurrent operations that cannot be explained by any serial execution order.

How 2 Manning books explain it

PostgreSQL Mistakes and How to Avoid Them

A distributed serialization anomaly is an inconsistency in the apparent ordering or isolation of concurrent operations across database nodes.

How it is used
Explains why read replicas and multi-node transactions can violate isolation or cancel queries during concurrent updates.
How deep it goes
Works through a PostgreSQL standby failure, identifies a read-write conflict, and weighs synchronous replication against stale reads.
Examples
Uses a long-running standby report, primary-side deletes and VACUUM, and PostgreSQL's recovery-conflict error output.
What you can do after
Diagnose recovery-conflict failures and evaluate synchronous replication or stale reads for a distributed workload.

Read how PostgreSQL Mistakes and How to Avoid Them explains serialization anomaly →

Microservices Patterns, Second Edition

A concurrency anomaly in which the combined outcome of interleaved transactions or sagas is not equivalent to any serial execution.

How it is used
Explains how concurrent sagas can produce inconsistent outcomes across services.
How deep it goes
Defines the anomaly, names five forms, and explains why local transaction isolation cannot guarantee global saga isolation.
Examples
Uses concurrent create-order and cancel-order sagas to show overwritten order state and incorrect credit handling.
What you can do after
Evaluate concurrent saga outcomes for nonserializable interleavings and business-invariant violations.

Read how Microservices Patterns, Second Edition explains serialization anomaly →

Related concepts

Questions about serialization anomaly

What is serialization anomaly?

A serialization anomaly is an outcome of concurrent operations that cannot be explained by any serial execution order.

Which Manning books explain serialization anomaly?

PostgreSQL Mistakes and How to Avoid Them and Microservices Patterns, Second Edition.

What kinds of serialization anomaly are there?

Kinds of serialization anomaly include lost update anomaly and write skew.

These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.