Return to previous page

The table wp_814147_options is filling up

This topic has 9 replies, 2 voices, and was last updated 2 years, 2 months ago ago by Rose Tyler

Flavio

Participant

September 27, 2022 at 08:59

Since 2 weeks, the table wp_814147_options is filling up and /home/nfs_clients is full to 100% after a while.

This is what our hosting company sent us:

It is a query that starts with:

UPDATE wp_814147_options SET

And which contains as value for example :

158953:{i:0;a:2:{s:6:\”family\”;s:21:\”Mulish:300|Mulish:300\”;s:4:\”name\”;s:6:\”Mulish\”;}i:1;a:2:{s:6:
\”family\”;s:27:\”Open Sans:700|Open Sans:700\”;s:4:\”name\”;s:8:\”OpenSans\”;}i:2;a:2:{s:6:\”family\”;s:21:\”Mulish:300|Mulish:300\”;s:4:\”name\”;s:6:\”Mul
ish\”;}i:3;a:2:{s:6:\”family\”;s:27:\”Open Sans:700|Open Sans:700\”;s:4:\”name\”;s:8:\”OpenSans\”;}i:4;a:2:{s:6:\”family\”;s:21:\”Mulish:300|Mulish:300\”;s:
4:\”name\”;s:6:\”Mulish\”;}i:5;a:2:{

This query is repeated a lot.

This table is updated often, it seems that only it is concerned.

Here are some (beginning of) log requests, knowing that UPDATE are the biggest, and the ones that fill the log server the fastest:

INSERT INTO wp_814147_options (option_name, option_value, autoload) VALUES (‘_transient_global_styles_svg_filters_xstore-child’, ‘option_value UPDATE wp_814147_options SET option_value INSERT INTO wp_814147_options (option_name, option_value, autoload) VALUES (‘_transient_doing_cron’, ‘1663839841.1910200119018554687500’, ‘yes’) ON DUPLICATE KEY UPDATE option_name UPDATE wp_814147_options SET option_value UPDATE wp_814147_options SET option_value UPDATE wp_814147_actionscheduler_actions SET claim_id INSERT INTO wp_814147_options (option_name, option_value, autoload) VALUES (‘_transient_timeout_jetpack_sync_callables_await’, ‘1663839903’, ‘no’) ON DUPLICATE KEY UPDATE option_name INSERT INTO wp_814147_options (option_name, option_value, autoload) VALUES (‘_transient_jetpack_sync_callables_await’, ‘1663839843.2637’, ‘no’) ON DUPLICATE KEY UPDATE option_name UPDATE wp_814147_options SET option_value UPDATE wp_814147_options SET option_value UPDATE wp_814147_options SET option_value INSERT INTO wp_814147_options (option_name, option_value, autoload) VALUES (‘_transient_timeout_global_styles_xstore-child’, ‘1663839947’, ‘no’) ON DUPLICATE KEY UPDATE option_name

As for their frequency, it is almost every second.

#335172 Copied Theme version: 8.3.3 WooCommerce version: 6.9.3

8 Answers

Flavio

Participant

September 27, 2022 at 12:59

We just received an email from our hosting saying:

-> Your disk is filled with binlogs because of the following request :

UPDATE wp_814147_options SET option_value = … WHERE option_name = ‘et_header_builder_fonts’\G

#335188 Copied

Rose Tyler

Support staff

September 27, 2022 at 13:11

Hello,

Please provide temporary wp-admin and FTP access.
Where should we go on your site to be able to see the problem?

Regards

#335189 Copied

Flavio

Participant

September 27, 2022 at 13:51

The problem is with the /home/users space. binlogs are filling it and it seems that the following query is the cause:

UPDATE wp_814147_options SET option_value = … WHERE option_name = ‘et_header_builder_fonts’\G

Please contact administrator
for this information.

#335195 Copied

Rose Tyler

Support staff

September 28, 2022 at 11:57

Hello,

Fixed. The fix will be added in the next update also.

Regards

#335257 Copied

Flavio

Participant

September 28, 2022 at 13:25

That is in the 8.3.4/4.3.4?

#335269 Copied

Rose Tyler

Support staff

September 28, 2022 at 14:04

No, it will be added in the next one.

Regards

#335276 Copied

Flavio

Participant

September 28, 2022 at 14:52

OK, thanks!

#335290 Copied

Rose Tyler

Support staff

September 28, 2022 at 15:17

You’re welcome!

Regards

#335297 Copied
Tagged: filling, persuasive, templates, woocommerce, wordpress, wp_814147_options
Viewing 9 results - 1 through 9 (of 9 total)