Page MenuHomePhabricator

Attempting to move with subpages to a namespace allowing subpages fails with DB error
Closed, ResolvedPublic

Description

Trying to move [[testwiki:User:MER-C]] with subpages and talk pages generates the following database error:

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 "Article::insertOn". MySQL returned error "1062: Duplicate entry '2-MER-C' for key 2 (10.0.0.101)".

Only one page is moved. Logs of attempts are at http://test.wikipedia.org/w/index.php?title=Special%3ALog&type=move&user=MER-C&limit=6 .


Version: 1.13.x
Severity: major

Details

Reference
bz14258

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 10:12 PM
bzimport set Reference to bz14258.
bzimport added a subscriber: Unknown Object (MLST).

Same here on enwiki. Trying to move [[User:Ilmari Karonen/sandbox]] and subpages to [[User:Ilmari Karonen/just testing]] gives:

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 "Article::insertOn". MySQL returned error "1062: Duplicate entry '2-Ilmari_Karonen/sandbox' for key 2 (10.0.0.235)".

and none of the subpages get moved. See also discussion at [[WP:VPT#Subpage moves]].

I can't reproduce this on my testwiki

ayg wrote:

I'm not sure what the problem might be from the error given. It might help if a shell user could provide the SQL query that's failing?

Fixed in r35762; same problem as bug 14368. The list of additional pages was being pulled from a slave server, which was not up to date, and ended up including the original page, so it tried to move it twice.

Yup, seems to be working now: [[Special:Contributions/The_red_sun_rises.%E2%80%A6]] :-/ Now we just need to fix the throttle issue (bug 14356)...