Forums / Extensions / eZ Find / Can't re-index existing or new content in Solr

Can't re-index existing or new content in Solr

Next topic

Author

Message

Monday 10 January 2011 5:12:30 pm

Seems as though around Sept 2010 we were having indexing issue due to the problem mentioned here: http://share.ez.no/forums/extensions/ez-find/indexing-trouble/(language)/eng-GB. I've fixed that. Yes, it's been like that for moths. Now if i run

php extension/ezfind/bin/php/updatesearchindexsolr.php -s admin --clean-all
php extension/ezfind/bin/php/updatesearchindexsolr.php -s manage

the only content that's indexed is ones modified before Sept 2010. The only way I can index articles after that is by update an article or creating a new one in EZP. EZP immediately indexes after I hit the "publish" button.

I've tried disabling forking as per http://share.ez.no/forums/extensions/ez-find/solved-ezfind-solr-issues-not-indexing-old-content. But that didn't help.

I've also tried clearing the ezsearch_object_word_link and ezsearch_word tables and running updatesearchindex.php as suggested in http://share.ez.no/forums/setup-design/re-indexing/(language)/eng-GB. No luck.

Are there another ideas out there? Any logs I should looks at during indexing to tell what it's doing? What is the query it uses to determine which content to index?

ezfind 2.1
Solr Specification Version: 1.4.1

Bertrand Dunogier

Tuesday 11 January 2011 1:26:45 am

Is there any content in ezsearch_object_word_link and ezsearch_word after you index ? The tables should remain empty, as they aren't used by ezfind, but by the default eZ Publish search engine.

You can inspect the standard logs, especially the debug and error ones, eZ Find should use them while indexing.

What platform are you on ?

Bertrand Dunogier
eZ Systems Engineering, Lyon
http://twitter.com/bdunogier
http://gplus.to/BertrandDunogier

Thanh Nguyen

Wednesday 12 January 2011 4:46:31 pm

Yes, the tables are still empty.

We're running CentOS 5.3 connecting to MySQL 5.1.48. I'm not sure where to look for the logs you speak of. I ran updatesearchindexsolr.php with --debug and --sql switches and didn't see anything very helpful. And /var/log/solr0.log.0 is empty.

Thanh Nguyen

Monday 24 January 2011 6:01:32 pm

It turned out that we had configured eZFind incorrectly and pointed it to the wrong database schema. Problem solved.

Bertrand Dunogier

Tuesday 25 January 2011 1:47:41 am

Problem solved => can you please mark the topic as solved ? thanks :-)

Bertrand Dunogier
eZ Systems Engineering, Lyon
http://twitter.com/bdunogier
http://gplus.to/BertrandDunogier

Timing:	Jan 18 2025 03:08:26
Script start
Timing:	Jan 18 2025 03:08:26
Module start 'content'
Timing:	Jan 18 2025 03:08:26
Module end 'content'
Timing:	Jan 18 2025 03:08:26
Script end

Total runtime	0.0241 sec
Peak memory usage	2,048.0000 KB
Database Queries	4

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0103	587.9844	180.7656
Module start 'content'	0.0103	0.0055	768.7500	99.6484
Module end 'content'	0.0158	0.0083	868.3984	74.6875
Script end	0.0240		943.0859

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0025	10.4063	12	0.0002
Check MTime	0.0011	4.6355	12	0.0001
Mysql Total
Database connection	0.0009	3.6623	1	0.0009
Mysqli_queries	0.0044	18.3223	4	0.0011
Looping result	0.0000	0.1493	2	0.0000
Template Total	0.0079	32.8	1	0.0079
Template load	0.0010	4.0193	1	0.0010
Template processing	0.0069	28.7711	1	0.0069
Override
Cache load	0.0007	2.8909	1	0.0007
General
dbfile	0.0028	11.6880	10	0.0003
String conversion	0.0000	0.0336	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Usage	Requested template	Template	Template loaded	Edit	Override
1	pagelayout.tpl	<No override>	extension/sevenx/design/simple/templates/pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Can't re-index existing or new content in Solr

eZ debug

Main resources:

Timing points:

Time accumulators:

Templates used to render the page: