Project

General

Profile

Actions

Task #2941

closed

Search error in Bugzilla

Added by Regina Henschel over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Category:
-
Target version:
-
Start date:
Due date:
% Done:

0%

Tags:

Description

I have made the following advanced search:
In project LibreOffice:
Check all first column in section 'Search by People' and enter rb.henschel@t-online in field below 'contains'.
Enter 180d in section 'Search by History' instead of the default 1d.

The search answer is:

Software error:

DBD::Pg::db selectcol_arrayref failed: ERROR: index "bugs_delta_ts_idx" contains corrupted page at block 187
HINT: Please REINDEX it. [for Statement "SELECT bugs.bug_id AS bug_id, bugs.delta_ts AS changeddate, bugs.resolution AS resolution
FROM bugs
LEFT JOIN bug_group_map AS security_map ON bugs.bug_id = security_map.bug_id AND NOT ( security_map.group_id IN (12,7,6,27) )
LEFT JOIN cc AS security_cc ON bugs.bug_id = security_cc.bug_id AND security_cc.who = 19202
INNER JOIN resolution AS map_resolution ON bugs.resolution = map_resolution.value
INNER JOIN profiles AS name_assigned_to_1 ON bugs.assigned_to = name_assigned_to_1.userid
INNER JOIN profiles AS name_reporter_2 ON bugs.reporter = name_reporter_2.userid
LEFT JOIN (SELECT DISTINCT bug_id FROM cc AS cc_3 INNER JOIN profiles AS name_cc_3 ON cc_3.who = name_cc_3.userid AND name_cc_3.login_name::text ILIKE '%' ESCAPE '|') AS cc_3_3 ON bugs.bug_id = cc_3_3.bug_id
LEFT JOIN (SELECT DISTINCT bug_id,isprivate FROM longdescs AS commenter_4 INNER JOIN profiles AS name_commenter_4 ON commenter_4.who = name_commenter_4.userid AND name_commenter_4.login_name::text ILIKE '%' ESCAPE '|') AS commenter_4_4 ON bugs.bug_id = commenter_4_4.bug_id AND commenter_4_4.isprivate = 0
WHERE bugs.creation_ts IS NOT NULL
AND (security_map.group_id IS NULL
OR (bugs.reporter_accessible = 1 AND bugs.reporter = 19202)
OR (bugs.cclist_accessible = 1 AND security_cc.who IS NOT NULL)
OR bugs.assigned_to = 19202
)
AND bugs.product_id IN (109) AND ( ( name_assigned_to_1.login_name::text ILIKE '%' ESCAPE '|' OR name_reporter_2.login_name::text ILIKE '%' ESCAPE '|' OR cc_3_3.bug_id IS NOT NULL OR commenter_4_4.bug_id IS NOT NULL ) ) AND bugs.delta_ts >= '2019-02-05 12:55:04'
GROUP BY bugs.bug_id, bugs.delta_ts,bugs.resolution,map_resolution.sortkey,map_resolution.value
ORDER BY changeddate DESC, map_resolution.sortkey, map_resolution.value, bug_id DESC
LIMIT 500
"] at Bugzilla/Search.pm line 775.
Bugzilla::Search::data(Bugzilla::Search=HASH) called at /srv/bugzilla/bugzilla-5.0.4/buglist.cgi line 742

For help, please send mail to this site's webmaster, giving this error message and the time and date of the error.

Actions #1

Updated by Florian Effenberger over 4 years ago

  • Assignee set to Guilhem Moulin

Version: Q3/2019

Guilhem, can you have a look? Could be related to the recent database
issues?

Actions #2

Updated by Guilhem Moulin over 4 years ago

  • Status changed from New to Resolved

Could be related to the recent database issues?

Indeed, fixed.

Actions #3

Updated by Guilhem Moulin over 4 years ago

  • Status changed from Resolved to Closed

Guilhem Moulin wrote:

Indeed, fixed.

Just for the record, while all tables are clean since last week, I forgot to run a REINDEX on that index afterwards :-/

Actions

Also available in: Atom PDF