[QUESTION] Lock wait timeout exceeded UPDATE tig_postnl_order

[Webwijs]

I'm getting this error when placing an order on a development instance.

I had this before and fixed it by creating a new export from the live DB and imported it.

Is there any way I can fix this without doing this again?

main.CRITICAL: Placing an order with quote_id B4Sp9HxskwdW7S793NL5Fpltvq9Q49f2 is failed: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction, query was: UPDATE tig_postnl_order SET order_id = ?, quote_id = ?, type = ?, ac_characteristic = ?, ac_option = ?, ac_information = ?, delivery_date = '2024-09-05 00:00:00', shipping_duration = ?, expected_delivery_time_start = ?, expected_delivery_time_end = ?, is_pakjegemak = ?, is_stated_address_only = ?, pg_order_address_id = ?, pg_location_code = ?, pg_retail_network_id = ?, product_code = ?, parcel_count = ?, fee = ?, ship_at = '2024-09-04', confirmed_at = ?, confirmed = ?, created_at = '2024-09-04 13:26:37', updated_at = '2024-09-04 13:26:53', insured_tier = ? WHERE (entity_id=50840) [] []