Forums / Developer / updatesearchindex.php - php script interpreter stops

updatesearchindex.php - php script interpreter stops

Author Message

Anja Lundin

Tuesday 03 April 2007 12:05:57 am

Hi!
I have a database with lots of information and I need to run the script: updatesearchindex.php to re-indexing objects. The searching doesn't work like it should after the latest upgade and therefore I thought I'd run the updatesearchindex.php again....

When I try to do this the php script interpreter stops at 63.15 %. It's the same procent everytime. I get no error messages from the script. PHP Script Interpreter just stops and the process dies... I've tried to use cli in different PHP versions (4.3.1, 4.4.1 and 4.4.6) but it always stops at 63.15%.....

The database is huge. 63.15% takes at least one hour to reach. Current eZ publish version is 3.8.0, but the database has been updated several times:
1. from eZ publish 3.3 to 3.4.2
2. from eZ publish 3.4.2 to 3.4.4
3. from eZ publish 3.4.4 to 3.8.0

I've also tried to use the Update search index Segfaulting fix: http://lists.ez.no/pipermail/sdk-public/2006-November/002463.html but it doesn't work either. I'm not sure my problem has anything to do with that fix... I don't get the error message about segmentation fault.

Does anyone have a clue what the problem can be?

Thanks in advance!

Best regards!
/Anja Bjerleus, Novitell AB

------------------------------------
Anja Lundin
Developer, Novitell AB
Sweden

www.novitell.se

Brookins Consulting

Saturday 14 April 2007 7:58:23 am

Greetings Anja!

Brookins Consulting has recently released a new eZ Publish extension which provides scripts which will successfully index your eZ publish content objects without errors via an alternative replacement for the stock eZ publish search index update shell scripts.

Project, <i>http://projects.ez.no/updatesearchindex</i>
Release News, <i>http://projects.ez.no/updatesearchindex/news/updatesearchindex_extension_0_0_1_released</i>
Download extension, <i>http://projects.ez.no/content/download/757/2989/version/2/file/updatesearchindex-0_0_1.tar.gz</i>

Feel free to ask further questions about this solution within the project forum, <i>http://projects.ez.no/updatesearchindex/forum/general/updatesearchindex_forum#msg451</i>

eZ Partner | North American Experience
http://brookinsconsulting.com/experience

Anja Lundin

Tuesday 17 April 2007 11:09:11 pm

Hi Brookins Consulting,
The solution you presented above was of great help for us. It solved our problems and we successfully completed the search indexing.

I really recommend this solution to others with similar problems!

Thank you very much for providing this extension!

Best regards!
Anja Bjerleus, Novitell AB

------------------------------------
Anja Lundin
Developer, Novitell AB
Sweden

www.novitell.se

eZ debug

Timing: Jan 18 2025 01:00:24
Script start
Timing: Jan 18 2025 01:00:24
Module start 'content'
Timing: Jan 18 2025 01:00:25
Module end 'content'
Timing: Jan 18 2025 01:00:25
Script end

Main resources:

Total runtime1.1194 sec
Peak memory usage4,096.0000 KB
Database Queries194

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0066 587.8594180.8125
Module start 'content' 0.00660.9981 768.6719558.5703
Module end 'content' 1.00470.1146 1,327.2422336.7422
Script end 1.1194  1,663.9844 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00390.3482210.0002
Check MTime0.00160.1437210.0001
Mysql Total
Database connection0.00090.079110.0009
Mysqli_queries1.043893.24551940.0054
Looping result0.00190.16731920.0000
Template Total1.087997.220.5439
Template load0.00190.166420.0009
Template processing1.086097.013320.5430
Template load and register function0.00010.012210.0001
states
state_id_array0.00210.189810.0021
state_identifier_array0.00130.112720.0006
Override
Cache load0.00160.1462320.0001
Sytem overhead
Fetch class attribute can translate value0.00120.111230.0004
Fetch class attribute name0.00190.166850.0004
XML
Image XML parsing0.00240.217930.0008
class_abstraction
Instantiating content class attribute0.00000.001460.0000
General
dbfile0.00700.6246330.0002
String conversion0.00000.000530.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
3content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
3content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
6content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
7content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 21
 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs