Bugzilla DB error displaying PR25331

Bugzilla DB error displaying PR25331

[Hans-Peter Nilsson]

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 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

Re: Bugzilla DB error displaying PR25331

[Andrew Pinski]

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

Re: Bugzilla DB error displaying PR25331

[Frank Ch. Eigler]

Hi -

It appears that mysqld was wedged sometime overnight, which causes
every single mysql client (and there are plenty) to go into a busy
loop of connecting to the unix-domain socket, EAGAIN, retry. ;(
Hundreds of them, all at once, for minutes each.

Force-restarted mysql, mysqlcheck'd the databases, things seem fine
again.

- FChE