Closed Bug 423502 Opened 14 years ago Closed 8 years ago

add ability to search for part of comment string in crash reports


(Socorro :: Webapp, task, P3)


(Not tracked)



(Reporter: chofmann, Assigned: adrian)




(Whiteboard: [search])


(1 file)

basically the same as the search box for stacksignature

[comments]  [contains | is exactly ]   [enter search string here]

we also need 

[URL]       [contains | is exactly ]   [enter search string here]

but comments would really help out right now with the analysis.

this will allow us to associate similar user provided commments with the crashes they are seeing.
recommending P2.
OS: Mac OS X → All
Priority: -- → P2
URLs aren't public, so I don't think it's safe to let everyone search on them.

I'd love being able to search for specific comments, and also just being able to search for items that have comments at all.
Comments should be a no-brainer, except that column is probably not full-text indexed, so it will suck.
Summary: add ability to search for part of comment string and/or URL in blackboxes on → add ability to search for part of comment string in crash reports
This WFM, but we'll still probably need an index on reports.comments to make this feasible.
Assignee: nobody → ted.mielczarek
Attachment #314824 - Flags: review?(morgamic)
Comment on attachment 314824 [details] [diff] [review]
allow querying by comment

This is going to hurt -- chofmann can you avoid putting these queries into a single page with 12 iframes?  :)
Attachment #314824 - Flags: review?(morgamic) → review+
morgamic: more than that, it will probably never succeed currently due to the table size. I really think we'll need an index before we can put this in production.
Assignee: ted.mielczarek → nobody
Assignee: nobody → ted.mielczarek
Yeah... I'd recommend using Tsearch2 to create a ftext index or use OpenFTS:

Anybody have experience w/ fulltext on postgres?
I've used tsearch2 before, so I can do the SQL-fu to get that setup, but my RHEL/CentOS admin skills are lacking, so I have no idea how to get the tsearch2 module installed. It appears to come in the postgresql-contrib package, but that's not in the base repo, so I'm sort of stuck.
Aravind: do you know what sort of effort it would take to get tsearch2 installed?
installed it on khan.
Assignee: ted.mielczarek → nobody
Do with other search bugs.
Whiteboard: [search]
Target Milestone: --- → 1.8
This will now be 2.x
Target Milestone: 1.8 → 2.0
Assignee: nobody → adrian
Actually searching into the users' comments would be really simple to solve with ES (almost as simple as adding a box in the UI). For the URLs, see

I don't know how hard it would be with PostgreSQL.
Target Milestone: 2.0 → 2.1
Target Milestone: 2.1 → 2.2
Target Milestone: 2.2 → 2.3
Blocks: 678101
Target Milestone: 2.3 → 2.4
Target Milestone: 2.4 → ---
Component: Socorro → General
Product: Webtools → Socorro
Depends on: 656297
No longer blocks: 678101
Depends on: 678101
Component: General → Webapp
Priority: P2 → P3
Hardware: x86 → All
Closed: 8 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.