Stack Overflow
Stack Overflow

Questions tagged [reindex]

459 questions
2
votes
1 answer

Filling missing lines with "nan" with pandas reindex

Thanks to Jeff, I could find the missing lines in my file data structure and fill the missing lines. However, filled missing lines in output show "2013-07-01 00:00:00,,,,,,,,,,,,,,,,,,", not with nan. I would like to fill "NaN" or "nan" inside of…
Isaac
  • 885
  • 2
  • 15
  • 35
2
votes
2 answers

magento reindexing just the prices tried every solution

I tried everything I could think of to fix this issue and have been going through everything i could find on fixing reindexing issue... Ill take any advice possible, I tried everything through SSH/Shell, I tried truncating everything possible,…
user3760917
  • 29
  • 9
2
votes
2 answers

Upgrade Alfresco 4.0 to Alfresco 4.2 => Lucene reindex failing

I'm upgrading an Alfresco 4.0 to an Alfresco 4.2. All went well, except for the lucene indexes. The reindexing starts, but ends in a, so it seems, indefinete "Index cleaner running". I got this message by raising the loglevels for lucene indexing.…
goodgrid
  • 21
  • 1
2
votes
1 answer

Does mongodb reindex if you change the field that it is used in index?

Lets say you have a collection with a field called "primary_key", {"primary_key":"1234", "name":"jimmy", "lastname":"page"} and I have an index on "primary_key". This collection has millions of rows, I want to see how expensive is to change…
mike
  • 187
  • 3
  • 8
2
votes
2 answers

Search too slow. How do I reindex postgres database in a rails app using pg_search gem?

I am using pg_search gem to my app for search function. Before adding pg_search, I already added 130,000 rows of data to a table in my Postgres database. Now when I run a search it takes too long i.e around 16000ms. I am following Railscasts…
Subrat Rout
  • 95
  • 2
  • 16
2
votes
2 answers

Magento - Unable to reindex Product Prices - Foreign Key Constraint Fails

I've just recently upgraded my magento store from 1.4.2 to 1.7.0.2.. And The upgrade went smoothly but when I try to reindex data after the upgrade.. It fails on the Product Prices.. I've tried using php shell/indexer.php --reindexall from SSH and…
krizalis
  • 75
  • 3
  • 5
2
votes
3 answers

Magento Indexing taking so much time to complete

I have imported more than 10M products and i am trying to index it. When i tried to index it taking so much time especially "Catalog URL Rewrites, Product Flat Data, Catalog Search Index" . Is there is any way that i can perform indexing on those…
kedar
  • 23
  • 1
  • 3
2
votes
5 answers

Magento 1.7 cannot reindex product flat data

Magento 1.7 cannot reindex product flat data... I get the following error when trying to reindex my database. Product Flat Data index process unknown error: exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1452…
David Vendryes
  • 99
  • 1
  • 4
  • 11
2
votes
2 answers

Magento Product Attributes index process unknown error after importing multiselect attribute

After importing a multiselect product attribute, when I try to reindex from magento admin the indexer shows error. "There was a problem with reindexing process." Exception log : 2012-12-05T12:21:36+00:00 DEBUG (7): Exception message:…
Zach
  • 21
  • 2
2
votes
1 answer

Rails3 sunspot:reindex - rake aborted! undefined method

I have a rails model that has multiple "has_many through" relationships. I defined these in active record and in the searchable block. When I define the relationship on a single-word model name (ex: Contributor) and re-index, it works fine. When I…
user1507632
  • 23
  • 4
2
votes
2 answers

Reindex Magento

What is the best way to do a reindex from the data? I was thinking to create a cronjob every day at night and set the index mode to "manual update". Now i'm not sure what is the best way to do this. Because i don't know what happens with product…
Lexperts
  • 353
  • 2
  • 7
  • 19
1
vote
2 answers

Magento 1.6.2 Wont Reindex Product Flat Data

I can no longer get magento to reindex correctly as it states there was a problem with the reindexing process. I have used SSH access to try and manually reindex the data. Using SSH access i see the error but unsure as to how to resolve the error…
user1220486
  • 101
  • 3
  • 11
1
vote
2 answers

Pandas df.reindex() doesn't work for level>0 for MultiIndex

I've got two DataFrames A and B, both with a MultiIndex in the columns. B however has the order of the columns switched up. Now I would simply like to get the columns of B in the same order as in A. The clue is, the order depends on the second level…
Nicoleue
  • 45
  • 6
1
vote
1 answer

Need to have non NaN value within same sampling window in a DataFrame

I am trying to write an implementation of the GAPS operator in Kairos in Python. What the GAPS operator does is introduces NaN values where there is no data point based on the sampling frequency. ` This an example in a sample dataset: import pandas…
nkstack
  • 11
  • 2
1
vote
3 answers

Sort/reindex a pandas multiindex dataframe when level 1 indicies are different for each level 0 index. Only one level 0 group needs to be sorted

I am struggling with finding a way to sort the rows in a grouped pandas dataframe with two levels of indicies. This is an example of what a dataframe df I have: I could not paste the table in a nice format, but here is code for creating the…
confusedstudent
  • 35
  • 6
1 2 3
…
30 31