Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-12130

Problem populating the index when using updatesearchindexsolr.php

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Medium Medium
    • 4.0.0
    • 3.10.0beta1
    • None
    • Operating System: RHEL4
      PHP Version: (please be specific, like '4.4.3' or '5.1.5') 5.2.4
      Database and version: 5.0.48
      Browser (and version):

    Description

      Hi there, after some troubleshooting this morning with Paul Borgemans, we reached the conclusion that this could be a bug:

      Basically, on a box with php 5.2.4 and a fresh snapshot of ez find out of svn, if I run the following command, look at the output:

      [root@vwtn1 bd14]# /usr/local/php5/bin/php extension/ezfind/bin/php/updatesearchindexsolr.php -s site_admin --clean --php-exec=/usr/local/php5/bin/php -v --sql
      eZSearchEngine: Cleaning up search data
      Starting object re-indexing
      Using fork.
      Using 2 concurent process(es)
      Number of objects to index: 130
      
      Creating a new thread: 24181
      ...................................................................... 53.85%
      ............................................................           100.00%
      
      Creating a new thread: 24184
      
      Fatal error: eZ Publish did not finish its request
      The execution of eZ Publish was abruptly ended, the debug output is present below.
      
      Did not index content correctly: 
      array (
      )
      
      Creating a new thread: 24190
      Process finished: 24184
      Process finished: 24190
      Optimizing. Please wait ...
      Indexing took 3.227884054184 secs ( average: 40.274061217129 objects/sec )
      Finished updating the search index.
      

      This is what I see in the error log of ez publish:

       Nov 29 2007 11:37:59 ] [vwtn1] eZMySQLDB:
      Query error: MySQL server has gone away. Query: SELECT ezcontentobject.*,
                             ezcontentobject_tree.*,
                             ezcontentclass.serialized_name_list as class_serialized_name_list,
                             ezcontentclass.identifier as class_identifier,
                             ezcontentclass.is_container as is_container
                             , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                      FROM ezcontentobject_tree,
                           ezcontentobject,
                           ezcontentclass
                           , ezcontentobject_name 
                      WHERE node_id IN ( 48 ) AND
                            ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                            ezcontentclass.version=0  AND
                            ezcontentclass.id = ezcontentobject.contentclass_id
                             AND 
       ezcontentobject.language_mask & 3 > 0 
      
                             and  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                        ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
       ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
           ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
         + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
         <
           ( ezcontentobject_name.language_id & 1 )
         + ( ( ezcontentobject_name.language_id & 2 ) )
       )
      [ Nov 29 2007 11:37:59 ] [vwtn1] eZMySQLDB:
      Query error: MySQL server has gone away. Query: SELECT ezcontentobject.*,
                             ezcontentobject_tree.*,
                             ezcontentclass.serialized_name_list as class_serialized_name_list,
                             ezcontentclass.identifier as class_identifier,
                             ezcontentclass.is_container as is_container
                             , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                      FROM ezcontentobject_tree,
                           ezcontentobject,
                           ezcontentclass
                           , ezcontentobject_name 
                      WHERE node_id IN ( 58 ) AND
                            ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
                            ezcontentclass.version=0  AND
                            ezcontentclass.id = ezcontentobject.contentclass_id
                             AND 
       ezcontentobject.language_mask & 3 > 0 
      
                             and  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                        ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
       ( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
           ( (   ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
         + ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
         <
           ( ezcontentobject_name.language_id & 1 )
         + ( ( ezcontentobject_name.language_id & 2 ) )
       )
      [ Nov 29 2007 11:38:00 ] [vwtn1] eZMySQLDB:
      Query error: MySQL server has gone away. Query: BEGIN WORK
      [ Nov 29 2007 11:38:00 ] [vwtn1] eZMySQLDB:
      Query error: MySQL server has gone away. Query: COMMIT
      [ Nov 29 2007 11:38:00 ] [vwtn1] eZMySQLDB:
      Query error: MySQL server has gone away. Query: DELETE FROM ezsession WHERE session_key='87032c2ff8c1f3173cc88b213a5ac84d'
      [ Nov 29 2007 11:38:02 ] [vwtn1] eZMySQLDB:
      Query error: MySQL server has gone away. Query: BEGIN WORK
      [ Nov 29 2007 11:38:02 ] [vwtn1] eZMySQLDB:
      Query error: MySQL server has gone away. Query: COMMIT
      [ Nov 29 2007 11:38:02 ] [vwtn1] eZMySQLDB:
      Query error: MySQL server has gone away. Query: DELETE FROM ezsession WHERE session_key='87032c2ff8c1f3173cc88b213a5ac84d'
      

      This is the php error log instead:

      [29-Nov-2007 12:43:03] PHP Fatal error:  Call to a member function setAttribute() on a non-object in /userhome/uat_php5/bd14/svn/extension/ezfind/classes/ezsolrdoc.php on line 78
      

      As a side note, I tried to install ez find on a virtual machine with centos 5 and php 5.2.5 and it worked without any error on a stock installation, so i'm a bit puzzled now. The site I'm trying to install ez find on, is instead a client's website in the making although it's almost empty now (130 objects about).

      Attachments

        Activity

          People

            kk kk
            41302bda-6fe4-4c68-b526-aaafa5485935@accounts.ibexa.co Massimo Sanna
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: