Abstract:While a number of weak consistency mechanisms have been developed in recent years to improve performance and ensure availability in distributed, replicated systems, ensuring correctness of transactional applications running on top of such systems remains a difficult and important problem. Serializability is a well-understood correctness criterion for transactional programs; understanding whether applications are serializable when executed in a weakly-consistent environment, however remains a challenging exercise. In this work, we combine the dependency graph-based characterization of serializability and the framework of abstract executions to develop a fully automated approach for statically finding bounded serializability violations under \emph{any} weak consistency model. We reduce the problem of serializability to satisfiability of a formula in First-Order Logic, which allows us to harness the power of existing SMT solvers. We provide rules to automatically construct the FOL encoding from programs written in SQL (allowing loops and conditionals) and the consistency specification written as a formula in FOL. In addition to detecting bounded serializability violations, we also provide two orthogonal schemes to reason about unbounded executions by providing sufficient conditions (in the form of FOL formulae) whose satisfiability would imply the absence of anomalies in any arbitrary execution. We have applied the proposed technique on TPC-C, a real world database program with complex application logic, and were able to discover anomalies under Parallel Snapshot Isolation, and verify serializability for unbounded executions under Snapshot Isolation, two consistency mechanisms substantially weaker than serializability.

Solvability-Based Comparison of Failure Detectors

The Impact Failure Detector

A Uniform Framework for Diagnosis of Discrete-Event Systems with Unreliable Sensors using Linear Temporal Logic

A unified method to decentralized state inference and fault diagnosis/prediction of discrete-event systems

An in-depth and insightful exploration of failure detection in distributed systems

Diagnosis via Proofs of Unsatisfiability for First-Order Logic with Relational Objects

Formally expressing the semantics of observer-based fault detection software

Failure Detectors in Homonymous Distributed Systems (with an Application to Consensus)

An automatic system to detect equivalence between iterative algorithms

Competing failure analysis in non-repairable binary systems subject to functional dependence

PASDA: A partition-based semantic differencing approach with best effort classification of undecided cases

Recoverable and Detectable Self-Implementations of Swap

Hybrid Sat Solver Considering Circuit Observability

Copula based Measures of Repairable Parallel System with Fault Coverage

Dual-Failure Distance and Connectivity Oracles

Reliability Comparison of Schedulability Test in Ubiquitous Computing.

Dependency Stochastic Boolean Satisfiability: A Logical Formalism for NEXPTIME Decision Problems with Uncertainty

A New Algorithm for Testing Diagnosability of Fuzzy Discrete Event Systems

Equivalence Checking of Non-deterministic Operations

An Efficient Sequential Equivalence Checking Framework Using Boolean Satisfiability

Automated Detection of Serializability Violations under Weak Consistency