Re: Bugzilla DB error displaying PR25331

[Andrew Pinski <pinskia@gmail.com>]

On Sun, Jun 28, 2020 at 11:20 PM Hans-Peter Nilsson via Overseers
<overseers@sourceware.org> wrote:
>
> After finally fixing this bug, i.e.
> https://sourceware.org/bugzilla/show_bug.cgi?id=25331 I was
> adding a few final words and changing the status to
> resolved/fixed, but got a message about bugzilla being edited:
> "overwrite, throw away, or add just your new comment"
> (inaccurate quote but I hope you get what's referred).

I know this does not help you but accessing
https://gcc.gnu.org/bugzilla/ also times out.  I was going to submit a
new bug which was found by a co-worker and ran into this.

Thanks,
Andrew

>
> I choose "add just your new comment" and was greeted by a page
> with a request to send this report and a big red error message
> that starts as follows:
>
> "undef error - DBD::mysql::st execute failed: Out of
> resources when opening file '/var/tmp/#sql_f6f0_0.MAI'
> (Errcode: 24 "Too many open files") [for Statement "SELECT
> DISTINCT groups.id, name, description, CASE WHEN
> bug_group_map.group_id IS NOT NULL THEN 1 ELSE 0 END, CASE WHEN
> groups.id IN(8,7) THEN 1 ELSE 0 END, isactive, membercontrol,
> othercontrol FROM groups LEFT JOIN bug_group_map ON
> bug_group_map.group_id = groups.id AND bug_id = ? LEFT JOIN
> group_control_map ON group_control_map.group_id = groups.id AND
> group_control_map.product_id = ? WHERE isbuggroup = 1 ORDER BY
> description" with ParamValues: 0=25331, 1=4] at Bugzilla/Bug.pm
> line 3869"
>
> ...and that you probably see just by visiting PR25331 (as I did
> on another machine).  If not, I printed to a PDF, to be sent on
> request.
>
> Sorry.
>
> brgds, H-P