The table wp_814147_options is filling up

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

  • Avatar: Flavio
    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’, ‘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_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.

    8 Answers
    Avatar: Flavio
    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

    Avatar: Rose Tyler
    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

    Avatar: Flavio
    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.
    Avatar: Rose Tyler
    Rose Tyler
    Support staff
    September 28, 2022 at 11:57

    Hello,

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

    Regards

    Avatar: Flavio
    Flavio
    Participant
    September 28, 2022 at 13:25

    That is in the 8.3.4/4.3.4?

    Avatar: Rose Tyler
    Rose Tyler
    Support staff
    September 28, 2022 at 14:04

    No, it will be added in the next one.

    Regards

    Avatar: Flavio
    Flavio
    Participant
    September 28, 2022 at 14:52

    OK, thanks!

    Avatar: Rose Tyler
    Rose Tyler
    Support staff
    September 28, 2022 at 15:17

    You’re welcome!

    Regards

  • Viewing 9 results - 1 through 9 (of 9 total)

You must be logged in to reply to this topic.Log in/Sign up

We're using our own and third-party cookies to improve your experience and our website. Keep on browsing to accept our cookie policy.