1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Magento 2 Down: replica Tales not found when reindexing!

Discussion in 'Programming/Internet' started by Mer Gh, Oct 8, 2018.

  1. Mer Gh

    Mer Gh Guest

    My server went down because the disk was full, after fixing it, I noticed that the magento 2 website never came back: (Magento 2.2.4, PHP 7.0.30)

    When re-indexing, i get the following error:


    Table "cataloginventory_stock_status_replica" does not exist Table Table "catalog_product_index_eav_replica" does not exist Table Table "cataloginventory_stock_status_replica" does not exist

    [​IMG]

    Exception Logs only shows this:


    [2018-10-07 10:00:58] main.CRITICAL: SQLSTATE[HY000]: General error: 3 Error writing file './databse_mag2/catalogrule_product__temp30fd3506.frm' (Errcode: 28 - No space left on device), query was: create table catalogrule_product__temp30fd3506 like catalogrule_product {"exception":"[object] (Zend_Db_Statement_Exception(code: 0): SQLSTATE[HY000]: General error: 3 Error writing file './databse_mag2/catalogrule_product__temp30fd3506.frm

    System logs shows this:


    [2018-10-08 15:01:05] main.WARNING: Memory size allocated for the temporary table is more than 20% of innodb_buffer_pool_size. Please update innodb_buffer_pool_size or decrease batch size value (which decreases memory usages for the temporary table). Current batch size: 100000; Allocated memory size: 200000000 bytes; InnoDB buffer pool size: 134217728 bytes. [] []

    The website is loading in vain, I've no idea where or how to fix it, anyone has an idea how to fix this, please?

    Login To add answer/comment
     

Share This Page