[Bug web/45785] New: Bugzilla search sometimes fails with an internal error

[Bug web/45785] New: Bugzilla search sometimes fails with an internal error

[zsojka at seznam dot cz]

http://gcc.gnu.org/bugzilla/show_bug.cgi?id=45785

           Summary: Bugzilla search sometimes fails with an internal error
           Product: gcc
           Version: unknown
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: web
        AssignedTo: unassigned@gcc.gnu.org
        ReportedBy: zsojka@seznam.cz


Created attachment 21877
  --> http://gcc.gnu.org/bugzilla/attachment.cgi?id=21877
Internal Server Error

In about half of cases I try to search for a bug:

http://gcc.gnu.org/bugzilla/buglist.cgi?cf_known_to_fail_type=allwords&cf_known_to_work_type=allwords&query_format=advanced&bug_status=RESOLVED&bug_status=VERIFIED&bug_status=CLOSED&longdesc=bit_value_binop&longdesc_type=allwordssubstr

I get an internal server error (see attachment). The error page is shown after
~1-2 minutes of waiting.

-- 
Configure bugmail: http://gcc.gnu.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.

[Bug web/45785] Bugzilla search sometimes fails with an internal error

[LpSolit at netscape dot net]

http://gcc.gnu.org/bugzilla/show_bug.cgi?id=45785

--- Comment #1 from Frédéric Buclin <LpSolit at netscape dot net> 2010-09-24 22:40:28 UTC ---
Yeah, there seems to be some performance problems with the DB server.

-- 
Configure bugmail: http://gcc.gnu.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.

[Bug web/45785] Bugzilla search sometimes fails with an internal error

[LpSolit at netscape dot net]

http://gcc.gnu.org/bugzilla/show_bug.cgi?id=45785

--- Comment #2 from Frédéric Buclin <LpSolit at netscape dot net> 2010-10-16 13:04:59 UTC ---
Is it still an issue?

[Bug web/45785] Bugzilla search sometimes fails with an internal error

[zsojka at seznam dot cz]

http://gcc.gnu.org/bugzilla/show_bug.cgi?id=45785

--- Comment #3 from Zdenek Sojka <zsojka at seznam dot cz> 2010-10-16 13:17:14 UTC ---
I get the feeling search isn't as quick as it used to be, but it's just a
feeling without any data to support it.
However, I haven't seen a search failure for some time now.

[Bug web/45785] Bugzilla search sometimes fails with an internal error

[zsojka at seznam dot cz]

http://gcc.gnu.org/bugzilla/show_bug.cgi?id=45785

--- Comment #4 from Zdenek Sojka <zsojka at seznam dot cz> 2010-10-18 15:54:45 UTC ---
http://gcc.gnu.org/bugzilla/buglist.cgi?cf_known_to_fail_type=allwords&cf_known_to_work_type=allwords&query_format=advanced&bug_status=UNCONFIRMED&bug_status=NEW&bug_status=ASSIGNED&bug_status=SUSPENDED&bug_status=WAITING&bug_status=REOPENED&bug_status=RESOLVED&bug_status=VERIFIED&bug_status=CLOSED&longdesc=lto_symtab_merge_decls_1&longdesc_type=allwordssubstr

still fails (search isn't done after several minutes)

It is a search with only "A Comment:" filled, within all bugs ("Status:
RESOLVED" seems to be enough). It used to work in the past

[Bug web/45785] Bugzilla search sometimes fails with an internal error

[LpSolit at netscape dot net]

http://gcc.gnu.org/bugzilla/show_bug.cgi?id=45785

--- Comment #5 from Frédéric Buclin <LpSolit at netscape dot net> 2010-10-27 09:52:17 UTC ---
Could you try:

http://gcc.gnu.org/bugzilla/buglist.cgi?quicksearch=ALL+comment%3Alto_symtab_merge_decls_1

[Bug web/45785] Bugzilla search sometimes fails with an internal error

[zsojka at seznam dot cz]

http://gcc.gnu.org/bugzilla/show_bug.cgi?id=45785

--- Comment #6 from Zdenek Sojka <zsojka at seznam dot cz> 2010-10-27 10:48:13 UTC ---
That is indeed much faster

[Bug web/45785] Bugzilla search sometimes fails with an internal error

[zsojka at seznam dot cz]

http://gcc.gnu.org/bugzilla/show_bug.cgi?id=45785

Zdenek Sojka <zsojka at seznam dot cz> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|                            |WORKSFORME

--- Comment #7 from Zdenek Sojka <zsojka at seznam dot cz> 2011-01-24 02:12:08 UTC ---
I haven't seen an internal error for long time now.
Also, now I search with all fields unselected, instead of all selected.