After 7.2.1 update action scheduler and debug log have gone crazy

Action scheduler actions and logs don’t clear and get millions of rows in the DB. It produces about 2MB of data a minute.

Debug log increases about 1GB per 20 mins with millions of these errors.

[21-Dec-2022 09:40:09 UTC] WordPress database error Unknown column ‘wp_postmeta.post_id’ in ‘where clause’ for query SELECT meta_id FROM m31w_postmeta,
????????????????????(SELECT DISTINCT post_id FROM m31w_postmeta
????????????????????WHERE (meta_key = ‘_billing_country’ OR meta_key=’_shipping_country’) AND meta_value=’NZ’)
????????????????????AS states_in_country
????????????????WHERE (meta_key=’_billing_state’ OR meta_key=’_shipping_state’)
????????????????AND meta_value=’NL’
????????????????AND wp_postmeta.post_id = states_in_country.post_id
????????????????LIMIT 100 made by do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action->execute, do_action_ref_array(‘woocommerce_run_update_callback’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Install::run_update_callback, wc_update_721_adjust_new_zealand_states, Automattic\WooCommerce\Database\Migrations\MigrationHelper::migrate_country_states, Automattic\WooCommerce\Database\Migrations\MigrationHelper::migrate_country_states_for_orders