[dev] move_history_out_of_datatree.php script stalls

[Kevin M. Myer]

Hello,

I'm trying to convert a test site to use horde_histories and using the upgrade
script to make the conversion.  Problem is, the script runs for a few seconds
and then emits nothing.  I straced it and the last few syscalls are brk calls,
followed by a few munmap calls.  Behavior is reproducible with both Red Hat EL
3 and 4 (PHP 4.3.2 and PHP 4.3.9 respectively).  The script takes up 100% CPU
on RHEL 4 (only 25% on RHEL 3) but seems to be hanging on the last munmap call.

I've logged queries on my database server and the initial query is being
generated and executed (captured traffic to confirm this too).  Running the
query manually generates about 45,000 results, so the query is fine.  Overall
datatree_attributes contains about 160,000 entries.

By inserting an echo function in the script, I can see its hanging on this line:

$all = $datatree->get(DATATREE_FORMAT_FLAT, DATATREE_ROOT, true);

But I'm pretty much lost at that point.  Any ideas?  Any way to chunk the
migration?

Kevin

-- 
Kevin M. Myer
Senior Systems Administrator
Lancaster-Lebanon Intermediate Unit 13  http://www.iu13.org