ALTER TABLE commands running multiple times, bogging down site

  • Resolved jondaley

    (@jondaley)


    1 year, 11 months ago

    This appears to have started with a recent update. I can’t find the code that is doing it, but there is some bug that keeps trying to upgrade the database over and over again, which locks the tables, and brings the site to a halt.

    Can you point me to the place in your code where it runs such commands like:

    ALTER TABLE wp_tec_occurrences CHANGE COLUMN start_date start_date VARCHAR(19) NOT NULL

    I’m not doing anything in the plugin particularly, just normal site visitors (or maybe a cron job?) are triggering this update over and over again (and lots more queries just like it, on lots/every? column.

    • This topic was modified 1 year, 11 months ago by jondaley.
Viewing 4 replies - 16 through 19 (of 19 total)
  • Thread Starter jondaley

    (@jondaley)

    I can’t disable it, since that would make the site go slowly. We saw a great improvement with the site when we enabled memcached years ago. It seems to me that something has changed with the events plugin, because we have used this plugin for a long time, and have only started having problems with it in the last release or two.

    Plugin Support Darian

    (@d0153)

    Hi @jondaley

    Thank you for your patience and for sharing additional details.

    We have created an internal bug ticket to address this issue and our engineers are currently working on a solution. However, due to its complexity, it may take some time to develop and validate before it can be released.

    Unfortunately, we cannot provide an estimated time of arrival at this moment, but we will keep you updated through this thread once a solution is available.

    Please create a separate support topic if you have any other concerns or issues that require assistance.

    —-
    Internal Bug Ticket Reference: TEC-4797

    Plugin Support Gladys

    (@greventscalendar)

    Hi @jondaley,
    ?
    With our latest release of?The Events Calendar 6.1.0, we have resolved the ALTER TABLES command issue that was bogging down the site. Please be sure to review our full?Release Notes?for more details and update your plugin whenever you get a chance.
    ?
    We recommend that you update The Events Calendar to the latest released versions.
    ?
    As always, we suggest testing updates on a staging site first and having a recent backup ready, but it should all be smooth sailing. If you implemented any workarounds, you can remove them after updating the plugins.
    ?
    If you still have issues after updating to the latest releases, please open a new support thread and include as many specific details as possible.
    ?
    Have a great day,
    Events Calendar Support Team

    Plugin Support Darian

    (@d0153)

    Hi @jondaley

    This thread has been inactive for a while, so we’ll go ahead and mark it Resolved. Please open a new thread if any other questions arise, and we’d be happy to help.

Viewing 4 replies - 16 through 19 (of 19 total)
  • The topic ‘ALTER TABLE commands running multiple times, bogging down site’ is closed to new replies.