602984 - WARNING: 2 sort operations have occurred for the SQL statement '0xac7e15d8'.

Status: RESOLVED DUPLICATE of bug 552023

(Firefox :: Sync, defect)

Description

[Brian Crowder]

I'm seeing thousands of error messages like this for the following SQL statement:

SELECT visit_type type, visit_date date FROM moz_historyvisits_temp WHERE place_id = IFNULL( (SELECT id FROM moz_places_temp WHERE url = :url), (SELECT id FROM moz_places WHERE url = :url) ) UNION SELECT visit_type type, visit_date date FROM moz_historyvisits WHERE place_id = IFNULL( (SELECT id FROM moz_places_temp WHERE url = :url), (SELECT id FROM moz_places WHERE url = :url) ) ORDER BY date DESC LIMIT 10

Not sure how severe this is, but it seems to be happening during a time in which we are experiencing other Weave-related responsiveness issues.

Comment 1

[Brian Crowder]

The patch in bug 552023 kills this bug entirely, so duping there.