Killed SQL Queries : Redux Activation Problem

  • Hello,

    I’m using this plugin with Advanced AMP ADS extension and my site was off for hours caused by these querys:

    _transient__redux_activation_redirect
    || DELETE FROM wp_options WHERE option_name IN (‘jpsq_sync-1486894334.760848-555755-1’, ‘jpsq_sync-1486894337.363101-676354-1’, ‘jpsq_sync-1486894337.543707-258248-1’, ‘jpsq_sync-1486894339.591195-637486-1’, ‘jpsq_sync-1486894340.158755-384296-1’, ‘jpsq_sync-1486894341.399151-6471-1’, ‘jpsq_sync-1486894343.009949-782161-1’, ‘jpsq_sync-1486894343.049367-824816-1’, ‘jpsq_sync-1486894343.639980-914718-1’, ‘jpsq_sync-1486894343.715487-442818-1’, ‘jpsq_sync-1486894345.361381-106401-1’) |

    For your ifo post_meta table has more than 2MM entries and 1,5GB

    Regards,

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

  • Hi @miguelgaton
    This seems not to be related with this plugin but with this other

    Thread Starter miguelgaton

    (@miguelgaton)

    Hello,

    I’m not sure because after “Accelerated Mobile Pages” plugin deactivation the site is OK again.

    regards,

    Hi @miguelgaton
    The error messages are the same in both cases. And this snippet ‘jpsq_sync- sound related to the JetPack Sync as the post says.

    Thread Starter miguelgaton

    (@miguelgaton)

    Hello,

    But why the site is loading fine with Jetpack and without Accelerated Mobile Pages ?
    And when I activate Accelerated Mobile Pages it crush.

    Regards,

    Maybe plugin triger an event that make jetpack to clean these entries in the database. Try to delete it manually before enable the plugin then enable it ….
    Is safe to delete the entries in the database, are info fron sync conections that jetpack make to wordpress.com, and I think you have a very big bunch of it

    Thread Starter miguelgaton

    (@miguelgaton)

    Hello @lofesa,

    Wp-posts has 140.000 entries (100.000 are images) and wp-post-meta has 2 MM related with all this posts.

    In this situation the plugin is not working fine, I have 3 sites with this volumen of posts/images and all 3 present the same problem when AMP for WP is activated. I think the plugin is not ready for sites with a huge volume of data.

    I have cleaned all transient entries but the site still off. I can only recover with AMP for WP off.

    Regards,

    Plugin Author Ahmed Kaludi

    (@ahmedkaludi)

    Hey @miguelgaton

    The latest update had some conflicts with Jetpack photon, but those are fixed in 0.9.42 update that was pushed 15 hours ago. I am sure this will be resolved in that update.

    Regards,
    Ahmed

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Killed SQL Queries : Redux Activation Problem’ is closed to new replies.