20190410
第一次写博客,留影做个纪念
mongoldb 事务
看《mongodb应用设计模式》,看到了里面的事务模拟,感觉挺繁琐的,突然想起mongo4好像支持事务了,就百度了一下,实际测试一下.
mongodb事务需要mongo4以上版本,且是在副本集下,本机装了mongo3.2升级失败,就选择了docker部署,参考下面网址:
https://www.cnblogs.com/cowboys/p/9264494.html
-
部署成功后用可视化工具连到副本集
image.png
springboot maven项目搭建
https://gitee.com/humaohua/mongo-transaction.git
- 项目运行时会报错下面错误(需要在shell里创建数据库,集合):
Whitelabel Error Page
This application has no explicit mapping for /error, so you are seeing this as a fallback.
Wed Apr 10 18:12:47 CST 2019
There was an unexpected error (type=Internal Server Error, status=500).
Command failed with error 263 (OperationNotSupportedInTransaction): 'Cannot create namespace testdb1.test in multi-document transaction.' on server 192.168.0.12:37017. The full response is { "operationTime" : { "$timestamp" : { "t" : 1554891165, "i" : 1 } }, "ok" : 0.0, "errmsg" : "Cannot create namespace testdb1.test in multi-document transaction.", "code" : 263, "codeName" : "OperationNotSupportedInTransaction", "$clusterTime" : { "clusterTime" : { "$timestamp" : { "t" : 1554891165, "i" : 1 } }, "signature" : { "hash" : { "$binary" : "AAAAAAAAAAAAAAAAAAAAAAAAAAA=", "$type" : "00" }, "keyId" : { "$numberLong" : "0" } } } }; nested exception is com.mongodb.MongoCommandException: Command failed with error 263 (OperationNotSupportedInTransaction): 'Cannot create namespace testdb1.test in multi-document transaction.' on server 192.168.0.12:37017. The full response is { "operationTime" : { "$timestamp" : { "t" : 1554891165, "i" : 1 } }, "ok" : 0.0, "errmsg" : "Cannot create namespace testdb1.test in multi-document transaction.", "code" : 263, "codeName" : "OperationNotSupportedInTransaction", "$clusterTime" : { "clusterTime" : { "$timestamp" : { "t" : 1554891165, "i" : 1 } }, "signature" : { "hash" : { "$binary" : "AAAAAAAAAAAAAAAAAAAAAAAAAAA=", "$type" : "00" }, "keyId" : { "$numberLong" : "0" } } } }
-
解决方法可以手动使用mongo shell 创建数据库和集合
image.png
image.png
image.png
-
再测试创建数据,就不会报错了
http://localhost:8080/test/t1?rollback=false
image.png -
测试事务回滚,不会插入数据
http://localhost:8080/test/t1?rollback=true
image.png
