On 19/04/10 02:32, Michael Hudson wrote:
> to trigger the puller to run. Last time this clogged up the branch
> puller queue for several hours, so maybe we should run something like:
>
> update branch set next_mirror_time = CURRENT_TIMESTAMP AT TIME ZONE
> 'UTC' where id in (select branch from seriessourcepackagebranch where
> distroseries in (select distroseries.id from distroseries, distribution
> where distroseries.name in ('lucid', 'maverick') and distribution.name =
> 'ubuntu' limit 500))
>
> every so often until it doesn't update any rows, or something that
> spreads next_mirror_time for these branches evenly over the next 10 hours.I think your limit clause is in the wrong place and you're missing a qualification to avoid touching branches a previous execution of the query has already touched. Max.
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Mailing list: https://launchpad.net/~launchpad-dev Post to : [email protected] Unsubscribe : https://launchpad.net/~launchpad-dev More help : https://help.launchpad.net/ListHelp
