have you tried using the DBI's "commit" call immediately after doing the update

Assuming that all I would need to do is add $order->commit;, yes, I tried that. No change in behavior.