584558 - Fix errors encountered on production by collapse_duplicate_users.php

Status: RESOLVED INCOMPLETE

(support.mozilla.org :: General, defect)

Description

[Paul Craciunoiu [:paulc]]

There was a failure on production with this message:
http://oremj.pastebin.mozilla.org/761988

Previous failure showed this on $db_tiki->errorInfo():
Array
(
    [0] => HY000
    [1] => 2014
    [2] => Cannot execute queries while other unbuffered queries are active.  Consider using PDOStatement::fetchAll().  Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.
)


At first few glances, this looks to be a problem with having multiple prepared statements at once.

Since using buffered queries didn't fix the problem, another possible solution is to not use prepared statements when running multiple queries, or to close one prepared statement before starting another.