High CPU usage and database performance problems

Hi, we’re experiencing some problems in our website while using Caldera Forms as we described in the following Github issue.

https://github.com/CalderaWP/Caldera-Forms/issues/3617

We need help because Caldera Forms seems to be generating a lot of stuck queries in our database that slow down the entire website and making it unusable.

WordPress Version: 5.4.2
PHP Version: 7.3.16
MySQL Version: 5.7.26
Caldera Forms Version: 1.9.2

Caldera Forms is generating a lot of queries like the following ones:
UPDATE wp_options SET option_value = ‘7’ WHERE option_name = ‘CF_DB’
UPDATE wp_options SET option_value = ‘8’ WHERE option_name = ‘CF_DB’

As well, here you have some of the PHP errors we also get. How can we proceed to solve this?

Could it be related to stuck data, transients or something like that? We need a solution because we can’t use website as we have done so far. Thanks

[Sun Sep 06 19:12:27.048021 2020] [php7:notice] [pid 22241] [client 10.0.3.229:62174] Error Lock wait timeout exceeded; try restarting transaction from the WordPress database for the query UPDATE wp_options SET option_value = ‘7’ WHERE option_name = ‘CF_DB’ made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, Caldera_Forms::init_cf_internal, update_option, referer: https://ourwebsite.com/

[Sun Sep 06 19:12:27.048269 2020] [php7:notice] [pid 21817] [client 10.0.1.14:2682] Error Lock wait timeout exceeded; try restarting transaction from the WordPress database for the query UPDATE wp_options SET option_value = ‘7’ WHERE option_name = ‘CF_DB’ made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, Caldera_Forms::init_cf_internal, update_option, referer: https://ourwebsite.com/

[Sun Sep 06 19:12:27.048479 2020] [php7:notice] [pid 21820] [client 10.0.3.229:62176] Error Lock wait timeout exceeded; try restarting transaction from the WordPress database for the query UPDATE wp_options SET option_value = ‘7’ WHERE option_name = ‘CF_DB’ made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, Caldera_Forms::init_cf_internal, update_option, referer: https://ourwebsite.com/

[Sun Sep 06 19:12:27.048671 2020] [php7:notice] [pid 22243] [client 10.0.3.229:62178] Error Lock wait timeout exceeded; try restarting transaction from the WordPress database for the query UPDATE wp_options SET option_value = ‘7’ WHERE option_name = ‘CF_DB’ made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, Caldera_Forms::init_cf_internal, update_option, referer: https://ourwebsite.com/

[Sun Sep 06 19:12:27.048896 2020] [php7:notice] [pid 22252] [client 10.0.1.14:2356] Error Lock wait timeout exceeded; try restarting transaction from the WordPress database for the query UPDATE wp_options SET option_value = ‘8’ WHERE option_name = ‘CF_DB’ made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, Caldera_Forms::init_cf_internal, caldera_forms_write_db_flag, update_option, referer: https://ourwebsite.com/subdomain-1/subdomain-2/subdomain-3/subdomain-4/final-link-1/

[Sun Sep 06 19:12:29.116185 2020] [php7:notice] [pid 22267] [client 10.0.3.112:51550] Error Lock wait timeout exceeded; try restarting transaction from the WordPress database for the query UPDATE wp_options SET option_value = ‘7’ WHERE option_name = ‘CF_DB’ made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, Caldera_Forms::init_cf_internal, update_option

[Sun Sep 06 19:12:30.032582 2020] [php7:notice] [pid 22013] [client 10.0.3.229:61974] Error Lock wait timeout exceeded; try restarting transaction from the WordPress database for the query UPDATE wp_options SET option_value = ‘7’ WHERE option_name = ‘CF_DB’ made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, Caldera_Forms::init_cf_internal, update_option, referer: https://ourwebsite.com/subdomain-1/subdomain-2/subdomain-3/subdomain-4/final-link-2/

[Sun Sep 06 19:12:33.701280 2020] [php7:notice] [pid 22269] [client 10.0.1.14:2822] Error Lock wait timeout exceeded; try restarting transaction from the WordPress database for the query UPDATE wp_options SET option_value = ‘7’ WHERE option_name = ‘CF_DB’ made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, Caldera_Forms::init_cf_internal, update_option, referer: https://ourwebsite.com/subdomain-1/subdomain-2/subdomain-3/subdomain-4/final-link-3/

[Sun Sep 06 19:12:34.047351 2020] [php7:notice] [pid 22271] [client 10.0.1.14:2834] Error Lock wait timeout exceeded; try restarting transaction from the WordPress database for the query UPDATE wp_options SET option_value = ‘7’ WHERE option_name = ‘CF_DB’ made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, Caldera_Forms::init_cf_internal, update_option

[Sun Sep 06 19:12:38.826918 2020] [php7:notice] [pid 22270] [client 10.0.3.229:62258] Error Lock wait timeout exceeded; try restarting transaction from the WordPress database for the query UPDATE wp_options SET option_value = ‘7’ WHERE option_name = ‘CF_DB’ made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, Caldera_Forms::init_cf_internal, update_option

[Sun Sep 06 19:12:40.827839 2020] [php7:notice] [pid 22274] [client 10.0.1.14:2904] Error Lock wait timeout exceeded; try restarting transaction from the WordPress database for the query UPDATE wp_options SET option_value = ‘7’ WHERE option_name = ‘CF_DB’ made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, Caldera_Forms::init_cf_internal, update_option, referer: https://ourwebsite.com/subdomain-1/subdomain-2/subdomain-3/subdomain-4/final-link-4/