[wp-trac] [WordPress Trac] #43044: Data inconsistencies

[WordPress Trac]

#43044: Data inconsistencies
--------------------------+-----------------------------
 Reporter:  robertorodes  |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  General       |    Version:  4.9.1
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 Hi there,

 The point is that I’ve seen no trace of database ACID transactions usage
 or any other mechanism to ensure data is always (or eventually) consistent
 when performing write operations. This seems to me like a general and
 critical issue for any Wordpress based development or simply running
 Wordpress as is.

 Since it’s pretty usual to find use cases in which a user request triggers
 multiple write operations, this might eventually lead to a broken database
 and unpredictable application behavior at some point.

 Is there any implemented approach to manage database transactions or any
 other means to ensure data is consistent (eventually, at least)? Am I
 missing something?

 Otherwise, do you have any plans on this matter?

--
Ticket URL: <https://core.trac.wordpress.org/ticket/43044>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform