Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [indexing]

Questions about the Magento indexer. This includes the flat catalog index. For MySQL indexes, use the "mysql -indexes" tag instead.

4
votes
2answers
36 views

Understanding the Magento 2 index

Generally Magento's index can be updated in 3 ways (depending on usage and configuration): "On Save" "By Schedule" Using indexer:reindex command This is what I can gather from the description in the ...
0
votes
2answers
46 views

magento product flat tables row size too large

When I re-index data in magento 1.x with large attribute set about 200 attributes. The got me followin MySQL error. Product Flat Data index process unknown error: exception 'PDOException' with ...
0
votes
0answers
18 views

Magento 2 custom indexer (update by schedule) does nothing?

On the admin UI it says that it last updated the last minute (every minute). So it's updating every minute, but, the execute method is not called and I don't see my table in the database changing. ...
5
votes
1answer
50 views

Catalog indexing take 3 to 4 days

I have facing problem about manual indexing from cli and my command php indexer.php reindexall will take 3 to 4 day to compelete the indexing. Here is some states of current catalog. Number of ...
1
vote
2answers
40 views

Reindex from different computer

Ok so basically I have been given this one task to manage the admin side for a website that used Magento 2. But then, I have encountered some problem with the reindexing. I have been searching about ...
-1
votes
1answer
143 views

removing categorty in product page is giving error [duplicate]

We are facing issues - https://prnt.sc/mgdybf why we are not able to remove the Deal and Pre Owned category. Could not save product "26652" with position 0 to category 435 What is this error ...
0
votes
0answers
20 views

Grouped products, attributes changes on save not visible in frontend. - ver. 1.9

I have a strange behavior in ver. 1.9.3.9 with atributes and grouped products. Steps to reproduce: Choose a single product which is part of GROUPED PRODUCT. Change desired attribute value (it's a ...
0
votes
0answers
15 views

Search on front end not working = Cannot initialize the indexer process FOR Rebuild Catalog product fulltext search index (Catalog Search Index)

Magento 1.9.1 Porto theme We had some server performance problems. I did a re-index couple of times and broke one of the indexes (I guess). Now - when anyone tries to search on the front end - they ...
0
votes
0answers
32 views

InnoDB temporary tablespace size explodes after reindex

Within a Magento 2.2.6 installation we currently have a peculiar problem, where MySQL's Temporary Tablespace of InnoDB (ibtmp1) suddenly explodes in size, growing seemingly indefinitely until the disk ...
1
vote
0answers
164 views

”Undefined offset: 4” when reindexing “Search indexer”

After module update I've got such error for indexing via SSH Catalog Search indexer process unknown error: Notice: Undefined offset: 4 in /home/sellastu/public_html/vendor/magento/module-catalog-...
3
votes
2answers
615 views

Magento 2.2.6 Catalog Search indexer process unknown error - Notice: Undefined offset: 53

I'm currently using Magento 2.2.6. I've recently encountered the following error while trying to reindex the catalogsearch_fulltext: Notice: Undefined offset: 53 in vendor/magento/module-catalog-...
3
votes
1answer
315 views

Magento 2 Is it possible to run reindexing per storeview?

My site has more than 100.000 products and almost 20 storeviews. Each time I run a full reindexing, it takes about 10 hours for reindexing to be finished. I wonder if it's possible to just run ...
1
vote
1answer
30 views

Magento1.9 Indexing fast

My catalog_product_flat indexing take too long time. How to make this indexing faster in Magento 1.9
0
votes
1answer
234 views

Error Elasticsearch on reindexing - No handler for type [text] declared on field [search]

When I launch a full reindex (php bin/magento indexer:reindex), I have two errors for these indexes : "Catalog Search" , "ElasticSuite Category" I have the Smile/Elasticsuite module installed on my ...
0
votes
2answers
38 views

Can't reindex from web admin

I can't reindex catalog_category_flat index from web admin, I see an error message. But I can reindex it from the console by running php shell/indexer.php --reindex catalog_category_flat without ...
0
votes
0answers
9 views

Indexing the Core Magento 2 table columns without effecting the update query performance

my doubt is regarding the indexing in database tables columns of Magento 2 instance. I want to put index on few of the columns in my heavy database tables columns of my core Magento 2 tables. Can ...
2
votes
1answer
341 views

Magento 2 Down: replica Tales not found when reindexing!

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: ...
0
votes
1answer
304 views

Magento 2 : Schedule Status : suspended

I'm on Magento 2.2.4 with php7. I have a cron job already set that reindexes it all twice a day. I usually also reindex manually and when i see a suspended index I reset it. But, when I do reindex:...
9
votes
2answers
889 views

How to solve indexer status “suspended” (n in backlog)

One of the indexers that are configured to be updated on schedule is locked in the state "suspended" and does not get updated anymore. Output of bin/magento indexer:status +-------------------------...
5
votes
1answer
112 views

Magento 2.1 - On reindex start event

I am looking for an observer event that is triggered when any re-index starts. I want to create an observer that sends out an email whenever an index has been initiated for re-indexing.
0
votes
0answers
93 views

DROP TABLE customer_grid_flat hangs - deadlock during customer grid indexing?

We have had an issue with Magento 2.2.5 on an AWS RDS instance (MySQL 5.7): Every then and when, essential Magento Admin functionality is blocked. It is possible to login, but order and customer list ...
0
votes
1answer
31 views

Magento 2.2 : Execute customer grid reindex after customer gets locked

My question is basically on the title, I've been trying to find some event being dispatched when an user gets locked for password attempts but so far I haven't find anything, maybe I'm coming at this ...
0
votes
0answers
193 views

catalog_category_product_index not generating correctly

I've had this problem on one of my sites for a while now. We go to a category in our wholesale side of our site and multiple products are missing. It will still show some products (eg. 2 out of 24 ...
0
votes
1answer
136 views

Why are new products not showing?

Note: I'm aware of the existing question. This is a different, more specific question. A bigger multi-store setup recently stopped to show new products unless I run bin/magento indexer:reindex. ...
0
votes
0answers
19 views

Null product titles in Product Flat Data index after editing

We have noticed some products appearing on category pages with missing titles (specifically the name attribute). From further investigation we found these products in the catalog_product_flat_1 table ...
3
votes
1answer
580 views

M2.2.5 : Can someone explain the role / functionality of the various tables used by the indexing process?

I've read the documentation about indexing in Magento 2, but it's very much on the surface. What I am wondering is how do the internals of the indexing mechanism work. Can somebody explain this to me? ...
0
votes
0answers
117 views

Magento 2 Reindexing is taking too long + Freezing website!

I'm on magento 2.2.4, php 7, dev mode. I've never had a problem with reindexing until lately, the website frozes and stops working while reindexing (Most of the times), espacially when rebuilding ...
1
vote
0answers
131 views

Magento 2 how to run reindex for single product or some cart line products

Is there any way in magento to achieve to reindex only single product or some items. I have a inventory existing /update call on product page load and cart page load. Right now doing indexing for ...
1
vote
1answer
35 views

Yet another bulk product import issue

We are planning to import a few thousands of products with custom options in Magento CE 1.9. We use SOAP for that, CSV is not an option since additional attributes may store html, json or serialized ...
2
votes
2answers
644 views

Column not found: 1054 Unknown column 'at_status_default.value'

I'm actually kind of desperate.I tried many times to update my Community Edition from 2.2.1 to 2.2.5, always failing due to what I guess is a database inconsistency.After the update procedure - done ...
0
votes
1answer
135 views

Magento 2: How to reindex specific ids and in specific indexer using an observer

I know I can programatically trigger the indexer to index a list of product ids with the following: /** * @var \Magento\Framework\Indexer\IndexerInterfaceFactory */ protected $indexerFactory; ...
0
votes
0answers
63 views

Magento 2. catalogsearch_fulltext indexing fails and no products are shown in categories in frontend

I have imported 17 Million Products in Magento 2. When I run indexing, all indexing is completed successfully but catalogsearch_fulltext exits without generating any error or success message, after ...
0
votes
0answers
39 views

Magento 2 Bulk Index exception

We are using elastic search suite with Magento 2 and I am continuously seeing an exception in magento 2 logs: Bulk index operation failed 4180 times in index ...
0
votes
1answer
126 views

Indexer always getting stuck processing when using the admin GUI

When completing a reindex via the admin GUI it always gets stuck and never completes. If I reindex via the command line it completes rather 3 minutes. Could anyone advise the best way to make the GUI ...
1
vote
1answer
44 views

Cleaning Changelog tables - Cron Enterprise_Index scheduledCleanup issue

Our instance is throwing an error on this cronjob PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name '' The code is pulling empty table ...
1
vote
0answers
32 views

What will be the background process execute when click on reindexing in Magento 2?

I want to know more about indexing. How in Magento2 re-indexing request processed in background.
1
vote
2answers
391 views

Magento2: How to temporarily disable “update on save” when saving products programatically?

I have a CLI command on my module that runs through the products collection & updates some of the attributes. I noticed that it's extremely slow. Each save() takes about 4-5 seconds, which is a ...
0
votes
0answers
13 views

indexes in magento 2 tables are not updated

Table indexes are not updated - neither by Cron, nor from Admin, nor through SSH. The rights to all files are 600/700. Help me please.
0
votes
1answer
74 views

Magento 2 : After Data Migration(Indexer issue)

After successfully migrated from Magento 1.x to 2.x I am getting issues with Indexer, Check below screen. (I need to Show products on frontend So, re-indexing is must) Please Help Thanks in Advance.
1
vote
1answer
2k views

Magento2 reindex via cron job

I have a store with 300k products, I set up the reindex to be "Update by Schedule", But I don't know what is the best way for reindexing, Should I do this manually by SSH command every 24 hours by ...
0
votes
1answer
114 views

Special price time dependent on frontend

I am trying to make special price dependent to time on frontend. I have already managed to save the date with time on backend and inside data table catalog_product_entity_datetimethanks to this post ...
0
votes
1answer
154 views

Turn off url rewrite indexing for disabled products

How can I turn off Catalog URL Rewrites indexing for disabled products in magento 1.9?
1
vote
0answers
199 views

Why some attributes can't search in storefront?

I have two custom attributes, all with these options: Products are imported programatically by cron, set in website and have these attributes. When I search one attribute I see results but by the ...
1
vote
0answers
274 views

ReIndex after updating the Product name via API's in Magento 2?

Am re-indexing the Product programmatically every time its name is updated via API. But still, it shows old data. The code which I use to reindex a product, $indexers = array('...
1
vote
1answer
1k views

Magento 2 catalog search full text reindex problem

I'm facing strange issue in my website. The products are not getting appeared if I reindex only flat and product related reindex. It requires catalogsearch_fulltext reindex. If I dont do catalog ...
0
votes
0answers
317 views

Magento1 reindexing: running indexer from command is queuing instead of reindexing

I am trying to run Magento indexer with: php shell/indexer.php --reindex catalog_url But I am getting: Catalog URL Rewrites index was rebuilt successfully in 00:00:00 Which first made no sense to ...
1
vote
1answer
253 views

Execute Custom Index before Magento Indexes - Re-order Indexing

I have created a custom module which contains indexing logic. The indexing is working and my data is being indexed. But the problem is that my custom indexes always executes after Magento's default ...
1
vote
0answers
81 views

Error whilst indexing price + products

The error started when I made the switch to flat catalogues. Exception 1: 2018-02-07T01:14:41+00:00 DEBUG (7): Exception message: SQLSTATE[21S01]: Insert value list does not match column list: 1136 ...
3
votes
1answer
303 views

Rogue “enterprise_refresh_index” causing excessive Merchandising failures

Thanks in advance for reading, and for any help you can hopefully offer. My company uses Magento for our marketplace, and while we've always had occasional issues with AOE Scheduler unable to kick ...
0
votes
0answers
67 views

Updating products on back end not reflected on front end

I have 2 problems and I am not sure if they are related. First of all I have added a new category with new products, I can click on the Category but no products are displayed. If I go to the actual ...