Data Loss During Database Upgrade about woocommerce HOT 1 OPEN

Thanks for reporting this, @natestone.

Unfortunately, we had two orders that were open and locked.

To be absolutely sure I'm understanding, you mean locked in the user interface sense (ie, if another user opened the same order for editing they'd see a message reading something like, "Another user is currently editing this order. Do you want to take over?"

I don't have an easy way to replicate the process.

OK, it's not always easy (and, so far, I also cannot replicate). Approximately how often are you encountering this, though?

It appears that locked orders were not properly upgraded by the database upgrade process and were deleted due to being locked during the upgrade.

Perhaps, but I don't think so. You haven't stated which version you updated from, but I can't think of any recent migration logic (that is, routines that execute during database updates) that would have triggered this. In fact, the very most recently added migrations don't touch order data at all.

Is it at all possible that human error was to blame? Could the order editor have been opened in order to manually create some orders, but were closed without being saved first of all?

from woocommerce.