Page MenuHomePhabricator

New page created, db lag, result in double entries in categories
Closed, ResolvedPublic


Author: anthony

After creating the page

I received a "page does not exist, please create one", so I tried saved it
again, which resulted in another "page does not exist". Probably because of db
lag, the page had been saved anyway as I was looking for what went wrong. So
that didn't seem to be buggy.

However, in the mean time the page -- which had been saved twice because of db
lag -- had put itself into its categories twice, see e.g.

Removing the categories from the page didn't help, as only one of two entries
was removed from the category. Bringing the categopries back to the article,
also brought the number of entries in the categories back to two.

Thanks in advance,


Version: unspecified
Severity: major



Revisions and Commits

Event Timeline

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

plugwash wrote:

so we have an orphaned catagory entry and no easy way to remove it (the only way
i can think of is probablly for a developer to use sql directly)

i don't know how wikipedia stores pages so i don't know if we also have two page
records in there for the same page name

maybe the database could be made to enforce no duplicates on entrys in a catagory.

i've marked this as major because its database curruption that isn't easy to undo

jeluf wrote:

I removed the duplicate entry from the database.

zigger wrote:

*** Bug 1285 has been marked as a duplicate of this bug. ***

gal86 wrote:

Category "Логика" in
contains 2 exact same entries "Парадокс"

Only one should be there.

gal86 wrote:

Category "X86" in
contains 2 exact same entries "Am486 SX2"
Only one should be there. wrote:

Do not save again when you see the page not there after creating it. If you
didn't get a database error, the save worked. Wait 30 seconds, reload, and
you'll probably see the new page.

The database setup is being changed to use a unique index which will make it
impossible to create duplicates. You'll get a database error on the second and
later saves instead. Part of the process of creating that will remove all of the
existing duplicates.

zigger wrote:

*** Bug 1320 has been marked as a duplicate of this bug. ***

  • Bug 2080 has been marked as a duplicate of this bug. ***

zigger wrote:

*** Bug 2179 has been marked as a duplicate of this bug. ***

gangleri wrote:

bug 2382: "existence of duplicate records as a result of bug 1202"
bug 2388: "handling: add a "purge" link to [[MediaWiki:Noarticletext]]"

1.5 quite firmly fixes this index on the conversion.
We've already fixed most of the Wikimedia sites as well manually.

Resolving FIXED again.

epriestley added a commit: Unknown Object (Diffusion Commit).Mar 4 2015, 8:21 AM