Failure to display large report schedule/template folders
Bug #1756142 reported by
Blake GH
This bug affects 8 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Confirmed
|
Medium
|
Unassigned | ||
3.1 |
Won't Fix
|
Medium
|
Unassigned | ||
3.2 |
Won't Fix
|
Undecided
|
Unassigned | ||
3.3 |
Won't Fix
|
Medium
|
Unassigned | ||
3.4 |
Won't Fix
|
Medium
|
Unassigned | ||
3.5 |
Won't Fix
|
Medium
|
Unassigned |
Bug Description
When displaying folders within the staff client, it's sometimes possible for this nasty error to show in gateway.log
Returning NULL from app_request_recv after timeout: open-ils.
This query can help identify large output folders
select rof.id,
from
reporter.schedule rs,
reporter.
where
rof.id=rs.folder
group by 1,2
having count(*) > 68
and for template folders:
select rtf.id,
from
reporter.template rt,
reporter.
where
rtf.id=rt.folder
group by 1,2
having count(*) > 68
Sometimes opening these folders (with limit output set to "ALL") can throw an error.
tags: | added: reports |
Changed in evergreen: | |
milestone: | none → 3.1-rc |
tags: | added: pullrequest |
Changed in evergreen: | |
importance: | Undecided → Medium |
Changed in evergreen: | |
milestone: | 3.1-rc → 3.1.1 |
Changed in evergreen: | |
milestone: | 3.1.1 → 3.1.2 |
Changed in evergreen: | |
milestone: | 3.1.2 → 3.1.3 |
Changed in evergreen: | |
milestone: | 3.1.3 → 3.1.4 |
Changed in evergreen: | |
milestone: | 3.1.4 → 3.1.5 |
Changed in evergreen: | |
milestone: | 3.1.5 → 3.1.6 |
no longer affects: | evergreen/2.12 |
Changed in evergreen: | |
milestone: | 3.1.6 → 3.2.1 |
Changed in evergreen: | |
milestone: | 3.2.1 → 3.2.2 |
Changed in evergreen: | |
milestone: | 3.2.2 → 3.2.3 |
Changed in evergreen: | |
status: | Confirmed → New |
milestone: | 3.2.3 → 3.3-beta1 |
Changed in evergreen: | |
milestone: | 3.3-beta1 → 3.3-rc |
Changed in evergreen: | |
milestone: | 3.3-rc → 3.3.1 |
Changed in evergreen: | |
milestone: | 3.3.1 → 3.3.2 |
Changed in evergreen: | |
milestone: | 3.3.2 → 3.3.3 |
Changed in evergreen: | |
milestone: | 3.3.3 → 3.3.4 |
no longer affects: | evergreen/3.0 |
Changed in evergreen: | |
milestone: | 3.3.4 → 3.3.5 |
Changed in evergreen: | |
milestone: | 3.3.5 → 3.4.2 |
status: | New → Confirmed |
Changed in evergreen: | |
milestone: | 3.4.2 → 3.4.3 |
Changed in evergreen: | |
milestone: | 3.4.3 → 3.4.4 |
Changed in evergreen: | |
milestone: | 3.4.4 → 3.5.1 |
Changed in evergreen: | |
milestone: | 3.5.1 → 3.5.2 |
tags: | added: needsrepatch |
Changed in evergreen: | |
milestone: | 3.5.2 → 3.6.1 |
Changed in evergreen: | |
milestone: | 3.6.1 → 3.6.2 |
Changed in evergreen: | |
milestone: | 3.6.2 → 3.6.3 |
Changed in evergreen: | |
milestone: | 3.6.3 → none |
tags: |
added: needswork removed: needsrepatch |
To post a comment you must log in.
Here is a fix for master (top two commits):
http:// git.evergreen- ils.org/ ?p=working/ Evergreen. git;a=shortlog; h=refs/ heads/collab/ dbwells/ stream_ reporter_ retreive_ by_folder
The diff for 2.12 will be a little different due to the paging added in 3.0. I'll push that version shortly.