phabricator_worker.worker_archivetask has unkeyed query on dateModified
Closed, ResolvedPublic
Actions

Assigned To

None

Authored By

	epriestley
	Aug 17 2016, 7:47 PM

Description

The daemon status page issues this query:

SELECT * FROM `worker_archivetask` WHERE (dateModified > 1471462314) ORDER BY id DESC

There is no key on dateModified, and this table may be enormous.

Restricted Differential Revision

Restricted Diffusion Commit

eadler added a project: Restricted Project.Aug 18 2016, 2:33 PM

epriestley added a revision: Restricted Differential Revision.Aug 19 2016, 6:32 PM

epriestley closed this task as Resolved by committing Restricted Diffusion Commit.Aug 19 2016, 6:53 PM

epriestley added a commit: Restricted Diffusion Commit.

This should now be fixed in HEAD of master. Thanks for the report!

(The actual key will be created the next time you run bin/storage adjust explicitly, or implicitly via bin/storage upgrade.)