257546 2023-05-31 09:41:44 -0700 bugs.webkit.org internal server error when limiting search by 1 month 2023-06-01 18:10:50 -0700 1 1 1 Unclassified WebKit WebKit Website WebKit Nightly Build Unspecified Unspecified RESOLVED FIXED InRadar P2 Normal --- 257577 1 ap lingho commit-queue jond lingho webkit-bug-importer oldest_to_newest 1959059 0 ap 2023-05-31 09:41:44 -0700 When I search for bugs changed in the last month, I get an internal server error. Steps to reproduce: 1. Open https://bugs.webkit.org/query.cgi 2. Show advanced fields. 3. Enter anything for the search string. 4. In "Search By Change History" below, set the search from "1m" to "Now". 5. Hit Enter. Results: ------------------- Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator at admin@webkit.org to inform them of the time this error occurred, and the actions you performed just before this error. More information about this error may be available in the server error log. ------------------- This isn't happening when searching within 2 months from now, but happens again with 3 months from now. So I suspect that this is a date arithmetic bug that happens on 31st of each month, and won't reproduce tomorrow. But despite this, I suspect that this is a regression (perhaps from upgrading something underlying), because I search like this all the time, and would likely have run into this earlier if it always happened. 1959099 1 lingho 2023-05-31 12:01:53 -0700 It appears that the SqlifyDate function in Bugzilla/Search.pm takes today's date and substracts month without changing the day. For example, giving 1m to the function returns 2023-04-31 11:06:09; giving 3m to the function returns 2023-02-31 11:07:38 . The error most likely cause by database query with invalid date. 1959109 2 webkit-bug-importer 2023-05-31 12:32:48 -0700 <rdar://problem/110075621> 1959111 3 lingho 2023-05-31 12:33:51 -0700 Pull request: https://github.com/WebKit/WebKit/pull/14546 1959165 4 ews-feeder 2023-05-31 15:09:25 -0700 Committed 264758@main (a9b9e3661656): <https://commits.webkit.org/264758@main> Reviewed commits have been landed. Closing PR #14546 and removing active labels. 1959215 5 commit-queue 2023-05-31 18:13:44 -0700 Re-opened since this is blocked by bug 257577 1959241 6 lingho 2023-05-31 20:28:23 -0700 Pull request https://github.com/WebKit/WebKit/pull/14569 1959462 7 ews-feeder 2023-06-01 18:10:48 -0700 Committed 264820@main (48759ded673b): <https://commits.webkit.org/264820@main> Reviewed commits have been landed. Closing PR #14569 and removing active labels.