field_data_commerce_order_total table has leftover data

[serhatozkara]

When a user adds a booking and proceeds to checkout page and then leaves the page as is and then cancels all reservations in the cart, field_data_commerce_order_total table has leftover data. This eventually leads to PDOException.

Expected Behavior

After user clears the cart, relevant field_data_commerce_order_total row should also be deleted.

Current Behavior

field_data_commerce_order_total table has leftover data with amount 0.

Possible Solution

Commerce related bug?

Steps to Reproduce from a clean installation of the latest release

1. Make a booking search and click book now.
2. Proceed to the checkout page.
3. In the checkout page, decide to cancel and go to homepage without cancel button.
4. Visit /cart page and cancel reservation.
5. Now field_data_commerce_order_total table has a redundant row.

Context (Environment)

Tried with vanilla master installation and 1.5.1 release.