Bug #1700: Large audit log takes a long time to pull up. (25 secs+) - Foreman

Custom queries

3.11.5 release DONE
3.11.5 release TODO
3.12.2 release DONE
3.12.2 release TODO
3.13.1 release DONE
3.13.1 release TODO
All bugs by votes
All issues closed in the last 3 weeks
Easy and Trivial Issues
Easy Issues (only)
Foreman - new open issues in last 10 days
Good first issues - Foreman core
high prio open bugs
Host registration [open]
Mine
My issues closed in the last 3 weeks
old bugs
Open with target version set (aka blockers)
registration
taken-none
Team Atlas untriaged bugs
templates
Trivial Issues
Untriaged and opened in the past two weeks

Actions

Copy link

Bug #1700

closed

Large audit log takes a long time to pull up. (25 secs+)

Added by Brian Gupta over 12 years ago. Updated over 12 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Amos Benari

Category:

Audit Log

Target version:

1.0

Difficulty:

Triaged:

Bugzilla link:

Pull request:

Fixed in Releases:

Found in Releases:

Red Hat JIRA:

Description

Need to set to debug, and see which query is taking a long time.

History
Notes
Property changes
Associated revisions

Actions

Copy link

Updated by Brian Gupta over 12 years ago

Assignee set to Ohad Levy

Debug output.. http://pastebin.com/w5VKWDxx

Actions

Copy link

Updated by Ohad Levy over 12 years ago

Assignee changed from Ohad Levy to Amos Benari

Actions

Copy link

Updated by Amos Benari over 12 years ago

Status changed from New to Closed
% Done changed from 0 to 100

Applied in changeset de3fb0d718467e9e8236b387044f725f8f5c1e34.

Actions

Copy link

Updated by Brian Gupta over 12 years ago

Performance is a lot better, but I may have discovered a regression.

I'm not 100% sure if it's related, but now searching the audit history by user seems to be broken, and it was (Largely) working a couple days ago.

Mmmm. Testing further indicated that for example if my username is bgupta and my display name is "Brian Gupta", if I click on a name in the audit list, it searchs for the display name, which doesn't work, but if I manually type in my login name (bgupta) into the search it works. Searching for the Admin user audit still seems broken.

Actions

Copy link