Page MenuHomePhabricator

"Phabricator monthly statistics - 2025-06" reports same median age for (almost) every priority
Closed, ResolvedPublicBUG REPORT

Description

https://lists.wikimedia.org/hyperkitty/list/wikitech-l@lists.wikimedia.org/thread/27UDGKHJWV5GL3OUQG5FWDWZVDMAMRZE/

Median age in days of open tasks by priority:

Unbreak now: 0
Needs Triage: 20270
High: 20270
Normal: 20270
Low: 20270
Lowest: 20270

Event Timeline

The prior month's report showed more variance:

Unbreak now: 113
Needs Triage: 1124
High: 1411
Normal: 2221
Low: 2697
Lowest: 3469

Change #1165461 had a related patch set uploaded (by Aklapper; author: Aklapper):

[operations/puppet@production] Phabricator monthly email: Rename var (now reserved word in MariaDB)

https://gerrit.wikimedia.org/r/1165461

ROW_NUMBER became a reserved word in MariaDB 10.7 (though we seem to be on 10.5.x on phab1004?) but we use that as an alias in the query.
Still renaming the var seems to work for me. No more failure when I try directly on phab1004. Shrug.

Change #1165461 merged by Dzahn:

[operations/puppet@production] Phabricator monthly email: Rename var (now reserved word in MariaDB)

https://gerrit.wikimedia.org/r/1165461

Fixed; should not happen again.

Thanks!

Lowest: 3501.402326389

Precision down to the microsecond reminds me of xkcd 2710. :-) Some more floor() needed?