Fix errors encountered on production by collapse_duplicate_users.php

RESOLVED INCOMPLETE

Status

support.mozilla.org
General
RESOLVED INCOMPLETE
8 years ago
7 years ago

People

(Reporter: paulc, Assigned: paulc)

Tracking

unspecified
1.5.6

Firefox Tracking Flags

(Not tracked)

Details

(Assignee)

Description

8 years ago
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.
(Assignee)

Updated

8 years ago
Assignee: nobody → paulc
Target Milestone: --- → 1.5.6
Status: NEW → RESOLVED
Last Resolved: 7 years ago
Resolution: --- → INCOMPLETE
You need to log in before you can comment on or make changes to this bug.