BUG : Wrong version in DB causes slow down

  • Hello,

    Since a week I’ve got really slow display for admin pages.

    I’ve checked with Query Monitor today and found that a DELETE query from EM Plugin was really slow (15 to 30 seconds) and caused an horrific TTFB only in admin … (hopefully we’re using a cache…)..

    Such request was launched in line 1023 of em_install.php
    $migration_result = em_migrate_datetime_timezones( false );

    Problem : This code is called only if ‘dbem_version’ <5.821 … and we’re in 5.9.6 !!!

    The next step was to request the ‘dbem_version’ option value and it was …
    5,96 instead of 5.96 (a comma instead of dot as we’re in french format …).
    I’ve checked quickly my option table and did not find any other real number with comma instead of dot.

    The new version is pushed in line 46 of em_install.php
    update_option('dbem_version', EM_VERSION);
    and EM_Version is set to 5.96 …

    All seems ok except that on the 3 db I used (prod/staging/dev) I’ve got the same 5,96 … (FYI, staging and dev DB are old clones of prod)

    All these 3 sites are using PHP7.2 so I think that it is related to some data cast before updating the version (or a specific DB config)

    So I’ve fixed this on my prod DB and I have now a TTFB < 1s but I think that there is a bug somewhere …

    Do not hesitate to ask if you need more information !

Viewing 2 replies - 1 through 2 (of 2 total)

  • Hello,

    Have you recently updated from a very old version of EM to latest one? It seems like the error if from the timezones. Can you perhaps try and reset the timezones (Events > Settings > Admin Tools > Reset Timezones)

    If the query is still showing as slow, Please let us know. Are the only only plugins activated only EM and query log monitor only? If possible please try it with only those plugins as enabled also to minimize possible plugin conflicts .

    Thread Starter Christian Denat

    (@yakafaucon)

    @timrv I always have the latest release of all plugins I use.

    And as I have fixed this issue by committing the right value in the DB I’m 200% sure of the root cause.

    Do not understand why I got this wrong value.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘BUG : Wrong version in DB causes slow down’ is closed to new replies.