798689 - tbpl.mozilla.org not getting finished results

Status: RESOLVED FIXED

(Developer Services :: General, task)

Description

[Phil Ringnalda (:philor)]

I know, I know, you want a better bug report, but I don't know why it's not successfully fetching build results or not successfully inserting them in its database, what I know is that https://tbpl.mozilla.org/ isn't showing results for jobs that finished in the last few hours, and so every tree is closed.

Comment 1

[Corey Shields [:cshields]]

importer script (run from cron every 5 mins) was timing out on: DELETE FROM runs_logs WHERE content IS NULL

paged mpressman, who added an index to content idx_content (content(1)) which sped that up a lot.

Comment 2

[Corey Shields [:cshields]]

I was a little brief as to the RFO last night, but mpressman explains why the delete statement was timing out:

< mpressman> it was performing a full table scan on ~140GB table

he has optimized the db so this doesn't happen again.

Comment 3

[Ed Morley [:emorley]]

This will need the in-tree schema to be updated as well, I'll file a bug shortly.

(For future bugs outside of the tinderboxpushlog component, please can [e-mail] be CCed too :-))