Numerous bugs can't be displayed due to "internal error: It must be numeric" caused by invalid entries in bugs_activity table
Categories
(bugzilla.mozilla.org :: General, defect)
Tracking
()
People
(Reporter: bj, Assigned: dkl)
Details
Attachments
(1 file)
|
(deleted),
image/png
|
Details |
Screenshot_2021-03-05 Invalid Parameter.png
Attempts to view bug 17880 fail. The response is:
Bugzilla has suffered an internal error:
Invalid parameter ? passed to Bugzilla::User->visible_bugs: It must be numeric.
|
||
Updated•3 years ago
|
|
Assignee | |
Comment 1•3 years ago
|
||
This is due to some DB corruption that must have happened a long time ago. The bugs activity table has values for added and removed of '? ?' for the dependency fields of the bugs.
mysql> select count(distinct bug_id) from bugs_activity where (added = '? ?' or removed = '? ?')
count(distinct bug_id)
539
The easy fix would be to just delete the offending rows from the bugs_activity table which will allow the bugs to be able load again. The right fix would be to also make sure the current blocked/dependson values have proper matching entries in the bugs_activity table as well and add them if the '? ?' entries were supposed to be those.
Will look into how much work it would be to fix this properly.
|
|
Assignee | |
Updated•3 years ago
|
|
|
Assignee | |
Updated•3 years ago
|
|
|
Assignee | |
Updated•3 years ago
|
Description
•