1972959 - buglist issue caused by incorrect date 2024-04-31

Status: RESOLVED WORKSFORME

(Bugzilla :: Bugzilla-General, defect)

Description

[greg k]

User Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36

Steps to reproduce:

Date: Oct 31, 2024
navigate to apache bugzilla page via https://bz.apache.org/bugzilla/buglist.cgi?chfield=%5BBug%20creation%5D&chfieldfrom=6m

Actual results:

Page response:

Please stand by ...

Data is being retrieved...
Software error:

DBD::mysql::db selectcol_arrayref failed: Incorrect DATETIME value: '2024-04-31 03:05:22' [for Statement "SELECT bugs.bug_id AS bug_id, bugs.bug_status AS bug_status, bugs.priority AS priority, map_assigned_to.login_name AS assigned_to
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 (7,6) )
LEFT JOIN cc AS security_cc ON bugs.bug_id = security_cc.bug_id AND security_cc.who = 78473
INNER JOIN profiles AS map_assigned_to ON bugs.assigned_to = map_assigned_to.userid
INNER JOIN bug_status AS map_bug_status ON bugs.bug_status = map_bug_status.value
INNER JOIN priority AS map_priority ON bugs.priority = map_priority.value
LEFT JOIN bugs AS bugs_g2 ON bugs.bug_id = bugs_g2.bug_id
WHERE bugs.creation_ts IS NOT NULL
AND (security_map.group_id IS NULL
OR (bugs.reporter_accessible = 1 AND bugs.reporter = 78473)
OR (bugs.cclist_accessible = 1 AND security_cc.who IS NOT NULL)
OR bugs.assigned_to = 78473
)
AND bugs.delta_ts >= '2024-04-31 03:05:22' AND ( 1 = 1 AND bugs_g2.creation_ts >= '2024-04-31 03:05:22' )
GROUP BY bugs.bug_id
ORDER BY map_bug_status.sortkey, map_bug_status.value, map_priority.sortkey, map_priority.value, assigned_to, bug_id
LIMIT 500
"] at Bugzilla/DB.pm line 64.
      Bugzilla::DB::ANON(Bugzilla::DB::Mysql=HASH(0x5605d4cadaa0), "SELECT bugs.bug_id AS bug_id, bugs.bug_status AS bug_status, "...) called at Bugzilla/Search.pm line 711
      Bugzilla::Search::data(Bugzilla::Search=HASH(0x5605d5510608)) called at /var/www/bugzilla-asf/buglist.cgi line 760

Expected results:

Normal buglist

Comment 1

[Dave Miller [:justdave]]

"The requested URL was not found on this server."

Are you the admin of that server? If not, you might want to report it to that server's admin first just in case they customized something that affects it.

Comment 2

[greg k]

En... yes, some links of apache bugzilla are lost now.
Last night, their bz instances were unavailable (DB connection error?). It is another story, I will report a new issue later.

I am not the admin of apache bz. I responsibly reported this issue to the apache bz administrator immediately on Oct 31 last year, but unfortunately I have not received any feedback so far. I guess it is a problem with the BZ product, so I posted it here.

Once the BZ website is back to work and this problem still exists, I will try to contact the apache bz admin.

Thank you.

Comment 3

[Dave Miller [:justdave]]

The equivalent URL on this server would be:

https://bugzilla.mozilla.org/buglist.cgi?chfield=%5BBug%20creation%5D&chfieldfrom=6m

On our test server of the current release version of Bugzilla:

https://bugzilla52.allizgub.org/buglist.cgi?chfield=%5BBug%20creation%5D&chfieldfrom=6m

That doesn't produce an error on either of those.

Since we can't reproduce upstream I'm going to assume this is an issue with Apache's instance.