[Bug 46086] action=delete fails with internal_api_error_DBQueryError

2013-04-14 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=46086

Rainer Rillke @commons.wikimedia rainerril...@hotmail.com changed:

   What|Removed |Added

   See Also||https://bugzilla.wikimedia.
   ||org/show_bug.cgi?id=13921

--- Comment #20 from Rainer Rillke @commons.wikimedia 
rainerril...@hotmail.com ---
According to moogsi, the following more descriptive error message is shown in
the UI:

A database query syntax error has occurred. This may indicate a bug in the
software. The last attempted database query was:

(SQL query hidden)

from within function WikiPage::updateCategoryCounts. Database returned error
1213: Deadlock found when trying to get lock; try restarting transaction
(10.64.16.27).

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 46086] action=delete fails with internal_api_error_DBQueryError

2013-04-14 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=46086

--- Comment #21 from MZMcBride b...@mzmcbride.com ---
(In reply to comment #20)
 According to moogsi, the following more descriptive error message is shown in
 the UI:
 
 A database query syntax error has occurred. This may indicate a bug in the
 software. The last attempted database query was:
 
 (SQL query hidden)
 
 from within function WikiPage::updateCategoryCounts. Database returned error
 1213: Deadlock found when trying to get lock; try restarting transaction
 (10.64.16.27).

I believe this is bug 13921.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 46086] action=delete fails with internal_api_error_DBQueryError

2013-04-14 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=46086

--- Comment #22 from Tim Starling tstarl...@wikimedia.org ---
Yes, we do have logs, and it's not hard to see that this started happening a
lot more often a couple of days before the bug was filed:

http://paste.tstarling.com/p/yVUjkB.html

It is somewhat alarming that it has taken a month of 200 errors per day for a
developer to be added to the CC list.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 46086] action=delete fails with internal_api_error_DBQueryError

2013-04-14 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=46086

Tim Starling tstarl...@wikimedia.org changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |DUPLICATE

--- Comment #23 from Tim Starling tstarl...@wikimedia.org ---
By searching the exception backtraces for ApiDelete::delete, I can confirm that
this is identical to bug 13921. For example, in the April 11 log, I see 71 from
WikiPage::updateCategoryCounts(), 12 from Title::invalidateCache() and 8 from
RecentChange::save(), so pretty much the same as bug 13921 comments 12 and 13.

*** This bug has been marked as a duplicate of bug 13921 ***

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 46086] action=delete fails with internal_api_error_DBQueryError

2013-04-13 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=46086

Andre Klapper aklap...@wikimedia.org changed:

   What|Removed |Added

   Keywords||platformeng
   Priority|Highest |High
 CC||g...@wikimedia.org
Summary|internal_api_error_DBQueryE |action=delete fails with
   |rror|internal_api_error_DBQueryE
   ||rror

--- Comment #17 from Andre Klapper aklap...@wikimedia.org ---
I don't see a reason to suddenly bump this issue to highest prio, as it has
been existing for months and there's no indicators that situation has gotten
worse in the last days. This doesn't mean that it shouldn't get fixed though.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 46086] action=delete fails with internal_api_error_DBQueryError

2013-04-13 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=46086

MZMcBride b...@mzmcbride.com changed:

   What|Removed |Added

 CC||ro...@wikimedia.org,
   ||s...@reedyboy.net,
   ||tstarl...@wikimedia.org

--- Comment #18 from MZMcBride b...@mzmcbride.com ---
(In reply to comment #17)
 I don't see a reason to suddenly bump this issue to highest prio, as it has
 been existing for months and there's no indicators that situation has gotten
 worse in the last days. This doesn't mean that it shouldn't get fixed though.

I agree that it's probably not critical, but this should be investigated.
Copying Sam, Rob L., and Tim on this bug. It's gonna require someone looking at
the backend to figure out what database query is erroring and why.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 46086] action=delete fails with internal_api_error_DBQueryError

2013-04-13 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=46086

INeverCry inevercry.comm...@gmail.com changed:

   What|Removed |Added

 CC||inevercry.comm...@gmail.com

--- Comment #19 from INeverCry inevercry.comm...@gmail.com ---
(In reply to comment #18)
 (In reply to comment #17)
  I don't see a reason to suddenly bump this issue to highest prio, as it has
  been existing for months and there's no indicators that situation has gotten
  worse in the last days. This doesn't mean that it shouldn't get fixed 
  though.
 
 I agree that it's probably not critical, but this should be investigated.
 Copying Sam, Rob L., and Tim on this bug. It's gonna require someone looking
 at
 the backend to figure out what database query is erroring and why.

This bug limits Commons admins' ability to delete copyright violations and
other problem images. There are 1000s of these images on Commons right now.
This bug limits mine and other's ability to help get rid of them. If not
critical, I'd atleast say this is highly important.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l