Indexer script stops indexing at 36% without error message

Tuesday 11 March 2008 3:13:39 am

Hi,

I currently use eZFind 1.0.0beta2 on eZPublish 4.0.

I have a strange eZFind indexer script behaviour : It starts indexing and stops at 36% without any error message... (when run without special debug / loging params)

Indexer script terminates with following output:

Creating a new thread: 2645
.................................................. 34.19%
...................................................................... 35.17%
...................................................................... 36.15%
..........Process finished: 2643
Process finished: 2645
Optimizing. Please wait ...
Indexing took 242.269028902 secs ( average: 29.5745602831 objects/sec )
Finished updating the search index.

Solr server output:

INFO: Closing Searcher@fbf51d main
        filterCache{lookups=0,hits=0,hitratio=0.00,inserts=0,evictions=0,size=0,cumulative_lookups=0,cumulative_hits=0,cumulative_hitratio=0.00,cumulative_inserts=0,cumulative_evictions=0}
        queryResultCache{lookups=0,hits=0,hitratio=0.00,inserts=0,evictions=0,size=0,cumulative_lookups=0,cumulative_hits=0,cumulative_hitratio=0.00,cumulative_inserts=0,cumulative_evictions=0}
        documentCache{lookups=0,hits=0,hitratio=0.00,inserts=0,evictions=0,size=0,cumulative_lookups=0,cumulative_hits=0,cumulative_hitratio=0.00,cumulative_inserts=0,cumulative_evictions=0}

eZPublish error log:

[ Mar 11 2008 11:07:02 ] [] eZMySQLDB:
Query error: MySQL server has gone away. Query: BEGIN WORK
[ Mar 11 2008 11:07:02 ] [] eZMySQLDB:
Query error: MySQL server has gone away. Query: COMMIT
[ Mar 11 2008 11:07:02 ] [] eZMySQLDB:
Query error: MySQL server has gone away. Query: DELETE FROM ezsession WHERE session_key='d7bddb3cb470f958bc95d88d835477fc'
[ Mar 11 2008 11:07:08 ] [] eZMySQLDB:
Query error: MySQL server has gone away. Query: BEGIN WORK
[ Mar 11 2008 11:07:08 ] [] eZMySQLDB:
Query error: MySQL server has gone away. Query: COMMIT
[ Mar 11 2008 11:07:08 ] [] eZMySQLDB:
Query error: MySQL server has gone away. Query: DELETE FROM ezsession WHERE session_key='d7bddb3cb470f958bc95d88d835477fc'

So it appears that there is a mysql connexion error but I can't figure why.
I try to index ~20.000 ezpublish objects.
Trying to index few basic objects works normaly.

Does anyone can help please?

Benjamin Plaquevent
Project Manager
Smile

Tuesday 11 March 2008 3:47:41 am

I start Solr with:

java -Xms512M -Xmx512M -jar start.jar

But even if I change memory heap, indexer script keep on stoping at the same point (36%).

I don't hava a clue of what's going wrong...

I changed php.ini memory_limit too but no success.

Benjamin Plaquevent
Project Manager
Smile

Friday 14 March 2008 8:34:30 am

I finally found a temporary work around:
I disabled fork by setting $useFork to false in updatesearchindexsolr.php.
I can't figure out what exactly happens but I think it is in relation with concurrent processes running.
I noticed that indexer stops when it finishes indexing the first top node...

Shouldn't I report this is the issue tracker?

Benjamin Plaquevent
Project Manager
Smile

Friday 14 March 2008 9:41:33 am

Hi,

I use PHP 5.2.0.
I tried with both UsePersistentConnection=enabled and UsePersistentConnection=disabled, no success.
Is there a more recent version of eZ Find for eZ Publish 4.0 available over there?

Thank you for your response.

Benjamin Plaquevent
Project Manager
Smile

Sunday 25 May 2008 3:10:11 pm

Hi,

I use ezfind in ezp4 and i have to put $useFork = false; because i get HTTP error 500.

thanks,
fran

Iguana IT, SL - http://www.iguanait.com