1031614 - Stale queries to the database to tables that no longer exist

Status: RESOLVED FIXED

(Socorro :: Infra, task)

Description

[Selena Deckelmann :selenamarie :selena]

Probably pretty easy bug for someone to tackle.

We're getting these queries hitting the database every few minutes: 

2014-06-28 00:40:33.609 GMT,"ganglia","breakpad",5161,"127.0.0.1:47416",53ae0f01.1429,1,"SELECT",2014-06-28 00:40:33 GMT,2/163508,0,ERROR,42P01,"relation ""jobs_in_queue"" does not exist",,,,,,"select count(*) from jobs_in_queue",22,,""
2014-06-28 00:40:33.666 GMT,"ganglia","breakpad",5163,"127.0.0.1:47418",53ae0f01.142b,1,"SELECT",2014-06-28 00:40:33 GMT,2/163512,0,ERROR,42P01,"relation ""top_crashes_by_url"" does not exist",,,"SELECT max(window_end)
                 FROM top_crashes_by_url",46,"PL/pgSQL function last_record(text) line 24 at SQL statement","select last_record('top_crashes_by_url')",,,""


Would be nice to sort out where that's coming from and turn this off. :)

Comment 1

[JP Schneider [:jp]]

Closing as wontfix, but if this is still something someone wants to grab, feel free to reopen.