launchpad-dev team mailing list archive

[Max Bowsher <maxb@xxxxxxx>]

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.

Attachment: signature.asc
Description: OpenPGP digital signature