Questions tagged [reindex]

459 questions
0
votes
1 answer

Opengrok OutOfMemoryError when re-indexing

I have checked out from SVN 19 projects, all are in code source directory. I run indexing from jenkins with following command: C:\Jenkins\workspace\Grok-Multiple-Projects-Checkout-And-Indexing>java -Xmx12288m -Xms2048m -jar…
misha
  • 85
  • 4
  • 13
0
votes
1 answer

Can I reduce the size of my catalog_product_index_eav table or increase my indexing speed?

In Magento 1.9.2.4 table catalog_product_index_eav contains 3.802.998 records and catalog_product_index_eav_idx contains 2.447.411 records. The sizes of other tables are 100000 records or less, normal sizes I think. Reindexing table…
Jeroen
  • 1
  • 1
0
votes
1 answer

Can Solr provide search service when reindexing?

As described in the tile, can Solr provide search service when reindexing? If not, is there a solution cover such scenario?
Nan Wang
  • 19
  • 5
0
votes
1 answer

Reindex elasticsearch 2.3.3 when using Java NodeClient

With the deprecation of SearchTye.SCAN and the newly Reindex API we want to migrate our elasticsearch cluster and clients from 2.1.1 to 2.3.3. We use java and the appropiate libraries to access elasticsearch. To access the cluster we use the…
Dag
  • 10,079
  • 8
  • 51
  • 74
0
votes
0 answers

Magento 1.9 reindex error - catalog search sql violation 1064

Sorry I am a complete novice. I am getting this error from my exception report in magento. If anyone can tell me how to fix it i'd appreciate it. 2016-06-06T19:03:22+00:00 DEBUG (7): Exception message: SQLSTATE[42000]: Syntax error or access…
Shaky6p2
  • 1
  • 1
0
votes
1 answer

Re-index magento using command line or Shell

I have seen some tutorials on re-indexing magento. with command line , shell, ssh. But i'm not very good with magento. I want some explanation on re-indexing through shell>indexer.php.(how to execute a command). I will be very grateful to you if…
Sandro
  • 59
  • 1
  • 1
  • 7
0
votes
4 answers

How to resolve the issue with reindexing process.Magento

I have just re-index the data using custom script and its generate this error : SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the…
Xabby
  • 435
  • 6
  • 26
0
votes
2 answers

pandas re-indexing with missing dates

from dateutil.rrule import rrule, MONTHLY def fread_year_month(strt_dt, end_dt): dates = [dt for dt in rrule(MONTHLY, dtstart=strt_dt, until=end_dt)] return dates df = pd.DataFrame({ 'value' : [4,2,5,6,7,8,6,5,4,1,2,4], 'date':…
codingknob
  • 11,108
  • 25
  • 89
  • 126
0
votes
1 answer

After magento verison upgrade from 1.5 to 1.9.2.3 re-indexing and caching not working

Last day I upgraded my magneto site from 1.5 to 1.9.2.3. But after that Re-indexing and flush magento cache is not working. On Re-indexing it throws error 'Cannot initialize the indexer process.' and when try to flush magento cache logout action is…
dhi_m
  • 1,235
  • 12
  • 21
0
votes
1 answer

Magento - Should I do mass update about 5k in mid night or separate multiple times in a day

I'm using magento EE 1.14.2.1.I have about 50k products in databases.I just want some useful advice about updating products. As I mentioned in title , in everyday I have about 5k product need to be update stock and price.So,should I do it in…
0
votes
0 answers

Reindexing elastic search data from version 1.3.4 to 2.0.0

I have data on elasticsearch server 1.3.4. I want to reindex data to server having version 2.0.0. using java api. Both versions require different Jars to make a connection to servers. When I used jar of version 2.0 it failed to make connection to…
0
votes
2 answers

How to set up elasticsearch routing on existing index?

I have an index which uses the default routing of elasticsearch. Now I want to set up my own routing, how do I implement this? The example in the official doc is: $ curl -XPUT 'http://localhost:9200/store/order/_mapping' -d ' { "order":{ …
user2767176
0
votes
0 answers

Error: The Flat Catalog module has a limit of 64 filterable and/or sortable attributes. Currently there are 66 of them

In My Magento Backend Admin Panel:- System -> Configuration -> Index Management -> Product Flat Data -> Reindex Data It Shows Error :- The Flat Catalog module has a limit of 64 filterable and/or sortable attributes. Currently there are 66 of them.…
Lalji
  • 17
  • 1
  • 11
0
votes
2 answers

What is the fastest way to change type_mapping from long to string, when having HUGE amount of data?

I tried once with alias index by moving data to new index, and I found it took too long, by following this guide https://www.elastic.co/blog/changing-mapping-with-zero-downtime. In addition, I have around 75 millions documents,and also growing up in…
Tanapat Sainak
  • 734
  • 1
  • 10
  • 22
0
votes
1 answer

Adding new fields to solr after indexing with Dynamic fields

I am trying to learn and implement Solr for a customer use case where we faced a question what if we need to add more fields(for storing and indexing) is it possible without re-indexing or reloading the data, and when I searched over the net for it…
Agarwal
  • 5
  • 3