[Mapbender-dev] Telascience autoupdate disabled
Seven of Nine (aka Arnulf)
seven at arnulf.us
Sat Apr 10 13:39:03 EDT 2010
On Sat, 2010-04-10 at 18:11 +0200, Karim Malhas wrote:
> Dear all,
> > I disabled the automatic updates at mapbender.telascience.org
> > Loading the updatesqls takes nearly 1.5h for some reason.
> > Up until now, an update was started every 10 minutes, resulting in a very
> > broken system.
> So today I investigated and found out that updating every 10 minutes is
> too much if postgres is not autovacuumed.
> Does anyone know why there are two postgres installations (8.0.8 and
> 8.1.5) are on that system. (The currently active version is 8.0.8)
> And a note:
> The cronjob contained these lines:
> */10 * * * * svnupdate
> */11 * * * * dbupdate
> That runs svnupdate every 10 minutes and dbupdate every 11 minutes
Hehe. No wonder that the machine choked on that.
Thanks for fixing.
> I don't think thats what is intended, which would rather be: "run dbupdate one minute
> after svnupdate"
> To accomplish this I suggest we make a single script that runs
> svnupdate waits for it to finish, and then runs dbupdate
> In fact I have taken the liberty of doing exactly that.
> The script can be found at /usr/local/bin/mapbender_update
> Mapbender_dev mailing list
> Mapbender_dev at lists.osgeo.org
More information about the Mapbender_dev