Reindex never ends

  • Resolved Carret

    (@carret)


    7 years, 7 months ago

    Hi.

    The Indexing / Reindexation seems never ending. Table aws_index grows non-stop, duplicating products: ID, term, term_source, … 100% appears next to the reindex table button, but does not end and loader icon continues.

    The message “Advanced Woo Search: Please go to plugin setting page and start indexing your products” does not disappear.

    It only seems to end when you save your changes or exit the General tab. I have had an aws_index table for 105 products of over 300MB and over 640,000 rows.

    It does not happen on localhost, if on the actual server.

    With debug set to true there are no errors or warnings.

    Wordpress 4.8.1, Advanced Woo Search 1.20, Woocommerce 3.1.1

    • This topic was modified 7 years, 7 months ago by Carret.
    • This topic was modified 7 years, 7 months ago by Carret.
Viewing 15 replies - 1 through 15 (of 15 total)
  • Plugin Author ILLID

    (@mihail-barinov)

    Hi,

    Can you please enable debug ( if you disable it ) and also add this two
    constant in wp-config.php after define(‘WP_DEBUG’, true);

    define( ‘WP_DEBUG_LOG’, true );
    define( ‘WP_DEBUG_DISPLAY’, false );

    that reindex table one more time.

    After this in your wp-content folder must appear debug.log file. Please open it and write me its content.

    Thanks!

    Thread Starter Carret

    (@carret)

    I tried but no luck, no error was reported.

    It’s happening to me also.

    It was good with about 1200 products indexed. After making some changes, transforming some simple products to variable, i reindexed.

    The result was a fast 100 but looping forever and only 200 indexed.

    Plugin Author ILLID

    (@mihail-barinov)

    @carret, @semespinhas

    What WooCommerce versions your are using?

    Thanks.

    Thread Starter Carret

    (@carret)

    Woocommerce 3.1.1, WordPress 4.8.1, Advanced Woo Search 1.20

    Woo: 3.1.1
    Wp: 4.8.1
    Adv. Woo: 1.21
    Theme: Divi > Child theme Nellie

    • This reply was modified 7 years, 7 months ago by semespinhas.
    Plugin Author ILLID

    (@mihail-barinov)

    @carret, @semespinhas

    One more thing.

    Please open browser console ( Usually F12->Console ) and press “Reindex table” one more time. Write me what you see in console after this.

    Thanks!

    Plugin Author ILLID

    (@mihail-barinov)

    @carret, @semespinhas

    Please update to version 1.22 and tell me if you still have any problems?

    Thanks.

    Im in phone, so limited acess.

    I updated, cleared cache for browser and plugin and reindexed.

    Again 100% in about 2s and looping forever. Opening in a different tab or refreshing page the same 200 indexed results

    Plugin Author ILLID

    (@mihail-barinov)

    And what about console that I write above?

    Thread Starter Carret

    (@carret)

    I tried version 1.22 and it works in my case.

    In the options table the aws_reindex_version row is now created with the value 1.22, before that row was not created.

    Also in the options table, another row (I can not remember the name) with reindex data now disappears, before it stayed.

    Console

    
JQMIGRATE: Migrate is installed, version 1.4.1
admin.js:60 

{offset: 0, start: true, found_posts: 108}found_posts: 108offset: 0start: true__proto__: Object
admin.js:60 

{offset: 50, start: false, found_posts: 108}found_posts: 108offset: 50start: false__proto__: Object
admin.js:60 

{offset: 100, start: false, found_posts: 108}found_posts: 108offset: 100start: false__proto__: Object
admin.js:60 

{offset: 108, start: false, found_posts: 108}found_posts: 108offset: 108start: false__proto__: Object
admin.js:52 

Reindex finished!
    Plugin Author ILLID

    (@mihail-barinov)

    So version 1.22 solve your issue?

    All your products is now indexed?

    Thread Starter Carret

    (@carret)

    Yes, with 1.22 works well.

    Thank you.

    Sorry for the delay answering.

    After update, clear cache and reindex table looks like it’s fixed.

    Hi Illid,

    I just purchased Advanced Woo Search PRO and installed it, but I see that the version I installed is version 1.21.

    I see in this support thread that you have built v1.22.

    Should I be asking you for 1.22 and waiting to run the plugin? I don’t want to experience the “never ending reindex” problem. ??

    Thank you.

    Connie

    • This reply was modified 7 years, 1 month ago by zimshah.
Viewing 15 replies - 1 through 15 (of 15 total)
  • The topic ‘Reindex never ends’ is closed to new replies.