864391 - create tables to support skiplist in database

Status: RESOLVED FIXED

(Socorro :: Database, task)

Description

[K Lars Lohn [:lars] [:klohn]]

we need a new table to hold the skip list information that's currently held in configuration and/or hard coded.

The table should look like this;

   category: text
   rule: text

Some sample data could look like this:

   category    rule
   ----------- ---------------------------------
   prefix      (libxul\.so|xul\.dll|XUL)@0x.*
   ignore      @0x[0-9a-fA-F]{2,}
   prefix      SocketShutdown
   prefix      operator new\([^,\)]+\)
   sentinel    '_purecall',
               ('mozilla::ipc::RPCChannel::Call(IPC::Message*, IPC::Message*)',
                lambda x: 'CrashReporter::CreatePairedMinidumps(void*, '
                  'unsigned long, nsAString_internal*, nsILocalFile**, '
                  'nsILocalFile**)' in x
               )
   prefix      arena_.*


order is unimportant

This table will be read once at the beginning of a run of the processor.  If we ever implement SIGHUP in the processors, then this table would be read again after SIGHUP.

Comment 1

[K Lars Lohn [:lars] [:klohn]]

rather than the values listed in Comment #0, valid values for `category` should be
   prefix
   irrelevant
   line_number
   sentinel

Comment 2

[[github robot]]

Commits pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/05ee39c7aecec94b12ed8a00e036a9b22cd6db6a
bug 864391 - Add skiplist table and migration

https://github.com/mozilla/socorro/commit/b47f8bc3033dd81152ba20e7db21cdd7b509a909
Merge pull request #1259 from selenamarie/bug864391-skiplist-db

bug 864391 - Add skiplist table and migration