Postgresql Database Error

Thu Nov 19 05:32:52 UTC 2009

2009/11/19 <fedora-buildsys-list-request at redhat.com>

> Send Fedora-buildsys-list mailing list submissions to
>        fedora-buildsys-list at redhat.com
>
> To subscribe or unsubscribe via the World Wide Web, visit
>        https://www.redhat.com/mailman/listinfo/fedora-buildsys-list
> or, via email, send a message with subject or body 'help' to
>        fedora-buildsys-list-request at redhat.com
>
> You can reach the person managing the list at
>        fedora-buildsys-list-owner at redhat.com
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Fedora-buildsys-list digest..."
>
>
> Today's Topics:
>
>   1. Postgresql Database Error (peng chen)
>   2. Re: Postgresql Database Error (Mike Bonnet)
>   3. Re: Postgresql Database Error (Mike McLean)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 18 Nov 2009 15:15:46 +0800
> From: peng chen <peng.chen22 at gmail.com>
> Subject: Postgresql Database Error
> To: fedora-buildsys-list at redhat.com
> Message-ID:
>        <7e200e7f0911172315q4b2fc425p8575bdd7e2b74765 at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> hello, fedora-buildsys-list:
>
>       when I requset a build task for pakcage "anaconda" to koji,
> one errie error come out.
> It detailed as follow:
>    pg.DatabaseError: error ' ERROR: new row for relation "task" violates
> check constraint "task_weight_check" '
> in ' UPDATE task SET weight=-0.9838856091396 WHERE id = 16296 '
>    I'm sure that the source rpm of anaconda is OK,because I succed to build
> it in local mock environment. and
> the repo is the same as the koji build server.
>    hope you do me a favor sincerely!
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> https://www.redhat.com/archives/fedora-buildsys-list/attachments/20091118/b463b957/attachment.html
>
> ------------------------------
>
> Message: 2
> Date: Wed, 18 Nov 2009 08:51:54 -0500
> From: Mike Bonnet <mikeb at redhat.com>
> Subject: Re: Postgresql Database Error
> To: fedora-buildsys-list at redhat.com
> Message-ID: <4B03FBFA.2000001 at redhat.com>
> Content-Type: text/plain; charset=UTF-8
>
> On 11/18/2009 02:15 AM, peng chen wrote:
> > hello, fedora-buildsys-list:
> >
> >        when I requset a build task for pakcage "anaconda" to koji,
> > one errie error come out.
> > It detailed as follow:
> >     pg.DatabaseError: error ' ERROR: new row for relation "task" violates
> > check constraint "task_weight_check" '
> > in ' UPDATE task SET weight=-0.9838856091396 WHERE id = 16296 '
> >     I'm sure that the source rpm of anaconda is OK,because I succed to
> build
> > it in local mock environment. and
> > the repo is the same as the koji build server.
> >     hope you do me a favor sincerely!
>
> Does one of the builds have a completion_time earlier than its
> create_event time?  Koji uses the build duration to dynamically
> calculate the weight of the task.  It should probably be checking for a
> negative result, but it doesn't.
>
>
>
> ------------------------------
>
> Message: 3
> Date: Wed, 18 Nov 2009 08:56:59 -0500
> From: Mike McLean <mikem at redhat.com>
> Subject: Re: Postgresql Database Error
> To: fedora-buildsys-list at redhat.com
> Message-ID: <4B03FD2B.5040909 at redhat.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> On 11/18/2009 02:15 AM, peng chen wrote:
> > hello, fedora-buildsys-list:
> >
> >         when I requset a build task for pakcage "anaconda" to koji,
> > one errie error come out.
> > It detailed as follow:
> >      pg.DatabaseError: error ' ERROR: new row for relation "task"
> violates
> > check constraint "task_weight_check" '
> > in ' UPDATE task SET weight=-0.9838856091396 WHERE id = 16296 '
> >      I'm sure that the source rpm of anaconda is OK,because I succed to
> build
> > it in local mock environment. and
> > the repo is the same as the koji build server.
> >      hope you do me a favor sincerely!
>
> The system time on your hub must have been set back during an anaconda
> build and there must be sufficiently few anaconda builds for this to
> cause getAverageBuildDuration('anaconda') to return a negative number.
>
> We should of course fix this, but you should also avoid rolling back the
> time on your koji hosts, especially the hub and db hosts.
>
> In the meantime, this patch should help
> --- a/builder/kojid
> +++ b/builder/kojid
> @@ -2033,6 +2033,9 @@ class BuildArchTask(BaseTaskHandler):
>          avg = session.getAverageBuildDuration(name)
>          if not avg:
>              return
> +        if avg < 0:
> +            self.logger.warn("Negative average build duration for %s:
> %s", name, avg)
> +            return
>          # increase the task weight by 0.75 for every hour of build
> duration
>          adj = (avg / 4800.0)
>          # cap the adjustment at +4.5
>
>
>
> ------------------------------
> As Mike Bonnet said in message 2, one of anaconda builds had a
> completion_time earlier than creation_time, so I find the one and remember
> the build ID, then update the table "build"  to make the completion_time
> later than creation_time.
>

Now the problem was solved.

Thanks again!

> --
> Fedora-buildsys-list mailing list
> Fedora-buildsys-list at redhat.com
> https://www.redhat.com/mailman/listinfo/fedora-buildsys-list
>
> End of Fedora-buildsys-list Digest, Vol 57, Issue 5
> ***************************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.fedoraproject.org/pipermail/buildsys/attachments/20091119/eaf70192/attachment.html 