Git command list 1. Overall understanding of Git 2. From the local warehouse in the temporary storage area 3. From local warehouse to remote warehouse 4. Conflict handling 5. Git branch operation 6. Branches of bugs 7. Feature branch 8. Use of temporary storage 9. Operation of remote warehouse 10. Use of labels 11. Git […]
Tag: rollback
Multiple databases in distributed systems realize distributed transaction rollback (1.7.0 seata integrates 2.0.4nacos)
Text 1. The application scenario solved is distributed transaction, and each service has an independent database. 2. For example: the database of service A is A1, the database of service B is B2, service A calls service B through the feign interface, B involves submitting data to B2, and the business is to report an […]
Spring Boot multi-threaded transaction rollback, easily done with one annotation
When we develop, we often encounter problems with multi-threaded transactions. I thought that adding the @Transactional annotation would be enough. In fact, after you add the annotation, you will find that the transaction is invalid. Reason: The database connection spring is placed in threadLocal. In a multi-thread scenario, the database connections obtained are different, that […]
MongoDB replica set rollback (Rollbacks) mechanism verification
Replica set architecture (Architecture) A classic multi-node replica set architecture is as follows. Elections When the slave node ec1-notificationdb-02 of the replica set finds that it cannot contact the master node ec1-notificationdb-01 and the slave node has the conditions to become the master node, the slave node ec1-notificationdb-02 will notify all other reachable nodes. The […]
MySQL transaction processing and how to use COMMIT and ROLLBACK statements to manage transaction processing
Manage transactions This chapter explains what transactions are and how to manage them using the COMMIT and ROLLBACK statements. transaction processing Not all engines support transaction processing MySQL supports several basic database engines, and not all engines support explicit transaction processing management. MyISAM and InnoDB are the two most commonly used engines. The former does […]
Spring transaction propagation isolation startup optimization and rollback—–Spring framework
package com.powernode.bank.service.impl; import com.powernode.bank.dao.AccountDao; import com.powernode.bank.pojo.Account; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import javax.annotation.Resource; import java.io.IOException; @Service(“is2”) public class IsolationService2 { // READ_UNCOMMITTED reads uncommitted transaction information (will cause dirty reads, non-rereadable (because the data is not saved to the database, it may be modified at any time), phantom reads) // READ_COMMITTED reads the submitted data (it […]
@Transactional annotation configuration in Spring, rollbackFor = Exception.class
In Spring, the @Transactional annotation is used to define the scope of the transaction. Transaction is used to ensure that a set of database operations are either all successfully committed or rolled back to maintain data consistency and integrity. In some cases, Spring will rollback the transaction by default when an exception is thrown, but […]
Jenkins-CICD-python/Java package upgrade and rollback
Jenkins-CICD pipeline python/Java code upgrade and rollback 1. Implementation ideas 1.1, code upgrade Click upgrade and code version number –${tag} on jenkins Jenkins pushes code and execution script to the target server/opt directory Execute the command sh run.sh code name version number upgrade The version number comes from the tag parameter in the build parameters […]
How to handle multi-threaded transaction rollback
An An An An Future 2023-08-07 08:01 Published in Jiangsu Included in the collection #MySql35 Hello everyone, I am Yian~ Background 1. Recently, there is a business scenario where a large amount of data is inserted into the warehouse. It is necessary to do some other modification operations before performing the insertion operation. Since there […]
Java transaction annotation @Transactional rollback (involving try catch, nesting) issues
Regarding transaction rollback, I want to say: Java @Transactional rollback (try catch, nesting) problem, Spring transaction annotation @Transactional can guarantee atomicity, if there is an error in the transaction, the entire transaction can guarantee rollback , but with try catch or transaction nesting, it may cause transaction rollback failure In daily code moving, we use […]