Re: Upgrade (to 0.9.3) hangs

Clemens Robbenhaar wrote:

>  [...]
>  > I try to upgrade a site from Silva 0.9.1 to Silva 1.0. All goes well in the
>  > first step which calls the Silva upgrade092.py. Then the next upgrade step
>  > starts calling the Silva script upgrade093.py. Suddenly the upgrade stops
>  > without any error message.
>  > The last message printed out was:
>  > Upgrading object http://foo/silva_ethz/ETH/imprint (still 130 objects to go)
>  > Setting title to: u'Impressum'
>  [...]
> 
>  This looks like a hang due to some resource exhaustion or lock ...
> 
>  A wild guess: maybe because the transaction holds more objects in
> memory than some ZODB cache size allows this hangs the process.

You'd think the subtransactions would help..

>  You could try to increase the ZODB cache size (via the ZMI Control Panel >
> Database Mamagement > Cache Parameters) before the upgrade, or lower the
> "subtransaction threshold" (thats a constant in the Silva/upgrade.py,
> near the top of the file around line 10: "threshold = 500").

Those are good suggestions to try.

>  Don't know if that helps. If it doesn't, at least is seems not to be
> the ZODB cache ;-/

Benno, how big is this database?

Are you using the upgrade script that zooms from 091 -> 093 or doing it 
manually?

Did you wait a long time for the commit to happen? You may want to start 
uncommenting print statements in the upgradeTree method in upgrade.py to 
see where exactly the hang occurs.

Regards,

Martijn