updatesearchindex.php - php script interpreter stops

Next topic

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

Author

Message

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

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

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 04:18:36
Script start
Timing:	Jan 18 2025 04:18:36
Module start 'layout'
Timing:	Jan 18 2025 04:18:36
Module start 'content'
Timing:	Jan 18 2025 04:18:37
Module end 'content'
Timing:	Jan 18 2025 04:18:37
Script end

Main resources:

Total runtime	1.2676 sec
Peak memory usage	4,096.0000 KB
Database Queries	57

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0056	588.0469	152.6406
Module start 'layout'	0.0056	0.0033	740.6875	39.4922
Module start 'content'	0.0090	1.2574	780.1797	553.4766
Module end 'content'	1.2664	0.0011	1,333.6563	12.1250
Script end	1.2675		1,345.7813

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0033	0.2639	16	0.0002
Check MTime	0.0014	0.1125	16	0.0001
Mysql Total
Database connection	0.0006	0.0473	1	0.0006
Mysqli_queries	1.2108	95.5237	57	0.0212
Looping result	0.0006	0.0501	55	0.0000
Template Total	1.2356	97.5	2	0.6178
Template load	0.0021	0.1652	2	0.0010
Template processing	1.2335	97.3082	2	0.6167
Template load and register function	0.0001	0.0083	1	0.0001
states
state_id_array	0.0012	0.0925	1	0.0012
state_identifier_array	0.0018	0.1431	2	0.0009
Override
Cache load	0.0017	0.1310	32	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0009	0.0718	2	0.0005
Fetch class attribute name	0.0024	0.1868	5	0.0005
XML
Image XML parsing	0.0022	0.1743	2	0.0011
class_abstraction
Instantiating content class attribute	0.0000	0.0011	6	0.0000
General
dbfile	0.0018	0.1402	22	0.0001
String conversion	0.0000	0.0009	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
3	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
6	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
7	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 21 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs