BestHub
Sign in
Tag

Rollback

0 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 3, 2025 · Databases

Root Cause Analysis of MySQL 5.7 JSON NOT NULL Rollback Failure and Its Fix

The article details a MySQL 5.7 bug where rollback SQL generated for a JSON NOT NULL column produces an empty string instead of NULL, explains the underlying binlog behavior, reproduces the issue with sample tables, and provides a practical workaround by converting the JSON column to TEXT before re‑importing the data, while recommending strict SQL_MODE for production.

Database TroubleshootingJSONMySQL
0 likes · 7 min read
Root Cause Analysis of MySQL 5.7 JSON NOT NULL Rollback Failure and Its Fix
Cognitive Technology Team
Cognitive Technology Team
Apr 15, 2025 · Backend Development

Common Pitfalls of Spring Transaction Management and How to Avoid Them

This article explains the typical reasons why Spring @Transactional annotations may fail—including AOP proxy limitations, method visibility, self‑invocation, exception handling, propagation settings, async execution, multiple data sources, and database constraints—and provides practical solutions to ensure reliable transaction behavior.

AOPBackendException
0 likes · 6 min read
Common Pitfalls of Spring Transaction Management and How to Avoid Them
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 18, 2025 · Databases

Parsing Delete Undo Log in MySQL 8.0.32 InnoDB

This article explains how to read and parse the Undo log generated by a DELETE operation in MySQL 8.0.32 InnoDB, covering preparation, log extraction, detailed field parsing, locating the primary index record, and the step‑by‑step rollback of secondary and primary index records.

Database InternalsInnoDBMySQL
0 likes · 10 min read
Parsing Delete Undo Log in MySQL 8.0.32 InnoDB
JD Tech
JD Tech
Jan 23, 2025 · Databases

Comprehensive Migration Plan for MongoDB to Alternative Data Stores

This article presents a complete MongoDB migration solution, detailing the migration rhythm, code refactoring using a decorator pattern, data source replacement with JImKV, MySQL and ES, bulk and incremental data transfer strategies, and deployment safeguards such as monitoring, gray release, and rollback to ensure a seamless cut‑over without service disruption.

Data MigrationDecorator PatternDistributed Systems
0 likes · 8 min read
Comprehensive Migration Plan for MongoDB to Alternative Data Stores
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 22, 2025 · Databases

Parsing and Rolling Back Update Undo Logs in MySQL 8.0.32 (InnoDB)

This article explains how MySQL 8.0.32's InnoDB engine generates, reads, and parses Undo logs for an UPDATE operation, and details the step‑by‑step process of locating the primary record, constructing a rollback record, and restoring both secondary and primary index entries.

Database InternalsInnoDBMySQL
0 likes · 14 min read
Parsing and Rolling Back Update Undo Logs in MySQL 8.0.32 (InnoDB)
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 18, 2024 · Databases

How MySQL InnoDB Allocates Undo Segments

This article explains the internal process MySQL 8.0.32 InnoDB uses to allocate, create, and manage Undo segments—including cached segment retrieval, new segment creation, insertion into rollback segment lists, conflict avoidance through mutexes, and a concise step‑by‑step summary of the entire workflow.

InnoDBMySQLRollback
0 likes · 9 min read
How MySQL InnoDB Allocates Undo Segments
JD Tech Talk
JD Tech Talk
Dec 4, 2024 · Operations

Gray Release, Verification, and Rollback Strategies in Software Deployment

The article outlines a comprehensive release management framework that emphasizes gray (canary) deployments, detailed verification steps, monitoring practices, and rollback procedures to mitigate risks and ensure system stability for production rollouts.

DeploymentMonitoringRollback
0 likes · 13 min read
Gray Release, Verification, and Rollback Strategies in Software Deployment
JD Tech Talk
JD Tech Talk
Oct 17, 2024 · Operations

Comprehensive Guide to Change Management: Compatibility Design, Release Planning, Gray Deployment, Data Migration, Rollback, and Configuration Control

This article presents a detailed overview of change management practices, covering compatibility design across hardware, base software, and applications, release strategies, gray‑deployment techniques, data migration analysis, rollback planning, configuration change control, and verification procedures to ensure system stability and reliability.

Change ManagementCompatibilityRelease Planning
0 likes · 26 min read
Comprehensive Guide to Change Management: Compatibility Design, Release Planning, Gray Deployment, Data Migration, Rollback, and Configuration Control
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Sep 11, 2024 · Databases

Upgrade Pika to 3.5.x: Key New Features, Migration Guide & Rollback Tips

This article introduces Pika 3.5.x’s major enhancements—including a new sync mechanism, expanded Redis command support, RocksDB upgrades, BlobDB, containerization, observability tools, ACL and transaction support—while providing a step‑by‑step upgrade procedure, optional data synchronization, and two rollback strategies for safe migration.

Database upgradePikaRedis compatibility
0 likes · 17 min read
Upgrade Pika to 3.5.x: Key New Features, Migration Guide & Rollback Tips
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 31, 2024 · Databases

InnoDB Deadlock Resolution: Selecting Victim Transaction, Updating Weights, Logging, and Wakeup

This article explains how InnoDB resolves a deadlock by ordering the involved transactions, selecting a victim based on priority, rollback cost and table modifications, updating transaction weights, optionally logging the deadlock details, and finally waking the victim transaction to roll back.

DeadlockInnoDBLogging
0 likes · 13 min read
InnoDB Deadlock Resolution: Selecting Victim Transaction, Updating Weights, Logging, and Wakeup
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 17, 2024 · Databases

Understanding MySQL Transaction Rollback: Binlog and InnoDB Rollback Process

This article explains how MySQL 8.0.32 rolls back a transaction by first attempting a binlog rollback (which does nothing for a plain ROLLBACK), then performing InnoDB undo‑log processing, committing the internal InnoDB changes, and finally clearing temporary binlog data from the transaction cache.

InnoDBMySQLRollback
0 likes · 8 min read
Understanding MySQL Transaction Rollback: Binlog and InnoDB Rollback Process
Soul Technical Team
Soul Technical Team
Oct 9, 2023 · Databases

Understanding SQLite Log Modes and Fixing Duplicate Message ID Issues in Chat Applications

This article explains SQLite's Rollback and WAL logging modes, compares their performance and concurrency characteristics, investigates a real‑world problem where duplicate IM message IDs appear after app upgrades, and presents a step‑by‑step solution using UNIQUE constraints and index checks to prevent repeated inserts.

Chat ApplicationRollbackSQLite
0 likes · 26 min read
Understanding SQLite Log Modes and Fixing Duplicate Message ID Issues in Chat Applications
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Aug 5, 2023 · Frontend Development

Second‑Level (秒级) Front‑End Rollback: A Step‑by‑Step Demo Using Vite, React, and Node

This article presents a complete tutorial for implementing a near‑instant (second‑level) rollback mechanism for single‑page front‑end applications, covering the underlying idea, project setup with Vite and React, history recording, a lightweight Node server, and a petite‑Vue visual interface for selecting and applying previous builds.

DeploymentFrontendNode
0 likes · 20 min read
Second‑Level (秒级) Front‑End Rollback: A Step‑by‑Step Demo Using Vite, React, and Node
Code Ape Tech Column
Code Ape Tech Column
Jun 6, 2023 · Backend Development

Business Compensation Mechanisms: Rollback and Retry Strategies in Distributed Systems

The article explains business compensation mechanisms in distributed microservice architectures, detailing rollback and retry approaches, their implementation patterns, strategies, and practical considerations for achieving eventual consistency while handling failures and outlines best practices for idempotency, monitoring, and workflow engine design.

Distributed SystemsIdempotencyRetry
0 likes · 14 min read
Business Compensation Mechanisms: Rollback and Retry Strategies in Distributed Systems
Top Architect
Top Architect
May 4, 2023 · Backend Development

Business Compensation Mechanisms: Rollback and Retry Strategies in Distributed Systems

The article explains how distributed applications face consistency challenges, defines business compensation as a way to resolve inconsistent states, and details practical rollback and retry mechanisms—including explicit/implicit rollback, various retry strategies, code examples, and design considerations for microservice architectures.

BackendDistributed SystemsRetry
0 likes · 14 min read
Business Compensation Mechanisms: Rollback and Retry Strategies in Distributed Systems
Architecture Digest
Architecture Digest
Apr 29, 2023 · Fundamentals

Business Compensation Mechanisms: Rollback, Retry, and Consistency in Distributed Systems

The article explains how distributed applications handle failures through business compensation mechanisms—defining rollback and retry strategies, consistency models, and practical considerations to maintain eventual consistency across multiple services.

Distributed SystemsRetryRollback
0 likes · 11 min read
Business Compensation Mechanisms: Rollback, Retry, and Consistency in Distributed Systems
Selected Java Interview Questions
Selected Java Interview Questions
Mar 26, 2023 · Databases

9 Common Pitfalls of SQL Scripts During System Deployment and How to Avoid Them

This article outlines nine typical problems that arise when executing SQL scripts in production—such as missing scripts, syntax errors, wrong order, timing issues, wrong database selection, long‑running updates, lack of rollback, missing indexes, and field renaming—and provides practical solutions to prevent each pitfall.

Best PracticesDBADatabase Deployment
0 likes · 11 min read
9 Common Pitfalls of SQL Scripts During System Deployment and How to Avoid Them