Page MenuHomePhabricator
Create Task
Maniphest T3239

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

Description

Author: anthony

Description:
After creating the page

http://en.wikipedia.org/wiki/Singles_93-03

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.

http://en.wikipedia.org/wiki/Category:The_Chemical_Brothers_albums
http://en.wikipedia.org/wiki/Category:2003_albums
...

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,

[[User:Aliekens]]

Version: unspecified
Severity: major

Details

Reference
bz1239
TitleReferenceAuthorSource BranchDest Branch
Update search UIsebastian-berlin-wmse/wikipedia-homepage!12sebastian-berlin-wmsecherry-pick-b965357fmain
plugins: use proxy to download plugins on production hostsrepos/releng/jenkins-deploy!12jnucheplugins-proxymaster
jenkins-rel: add missing releases target releases2002.codfw.wmnetrepos/releng/jenkins-deploy!11jnucheadd-cold-releases-jenkins-targetmaster
Update search UIsebastian-berlin-wmse/wikipedia-homepage!11sebastian-berlin-wmsesearch-fieldmain
jenkins-rel: sync plugins/CasC config with latest production versionrepos/releng/jenkins-deploy!10jnuchejenkins-rel-versionsmaster
jenkins-rel: add CasC configuration for secretsrepos/releng/jenkins-deploy!9jnuchejenkins-rel-secretsmaster
jenkins-rel: add configuration for devtools environmentrepos/releng/jenkins-deploy!8jnuchejenkins-rel-devtoolsmaster
jenkins-rel: add secretsrepos/releng/scap3-dev!11jnuchejenkins-rel-secretsmaster
deploy_services.sh: inject local scap.cfg configrepos/releng/scap3-dev!10jnucheinject-envmaster
scap.cfg: factor common configuration out of environmentsrepos/releng/jenkins-deploy!7jnuchefactor-out-scap-configmaster
jenkins-deploy: update deployment paths to match productionrepos/releng/scap3-dev!9jnucheprod-values-updatesmaster
add production valuesrepos/releng/jenkins-deploy!6jnucheprod-values-updatesmaster
kubernetes.py: Ensure log messages aren't too largerepos/releng/scap!55dancyreview/dancy/split-big-log-messagesmaster
releasing casc: add authentication/authorization configrepos/releng/jenkins-deploy!5jnucheauthenticationmaster
add new service with OpenLDAP serverrepos/releng/scap3-dev!8jnucheldap-servicemaster
Send image build/deploy transcripts to syslogrepos/releng/scap!51dancyreview/dancy/T323939-k8s-build-transcriptsmaster
add plugins and CasC config from production releasing instancerepos/releng/jenkins-deploy!3jnuchecasc-config-and-plugins-releasingmaster
Show related patches Customize query in GitLab

Revisions and Commits

Unknown Object (Diffusion Commit)

Related Objects
Search...

Event Timeline

• bzimport raised the priority of this task from to Medium.Nov 21 2014, 8:08 PM
• bzimport added a project: MediaWiki-Categories.
• bzimport set Reference to bz1239.
• bzimport added a subscriber: Unknown Object (MLST).
• bzimport created this task.Dec 30 2004, 9:11 PM
• bzimport added a comment.Dec 30 2004, 9:16 PM

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

• bzimport added a comment.Dec 31 2004, 12:24 AM

jeluf wrote:

I removed the duplicate entry from the database.

• bzimport added a comment.Jan 8 2005, 4:05 PM

zigger wrote:

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

• bzimport added a comment.Jan 8 2005, 4:19 PM

geiger581 wrote:

My duplicate bug is in regards to:

http://en.wikipedia.org/wiki/Castlevania_DS

which has been 5x categorized in both:

http://en.wikipedia.org/wiki/Category:Castlevania_games
http://en.wikipedia.org/wiki/Category:Nintendo_DS_games

• bzimport added a comment.Jan 8 2005, 11:08 PM

dig.mediazilla wrote:

Category "Антигипертензивные средства, влияющие на сосудодвигательные центры
головного мозга" in ru.wikipedia.org
(http://ru.wikipedia.org/wiki/Category:%D0%90%D0%BD%D1%82%D0%B8%D0%B3%D0%B8%D0%BF%D0%B5%D1%80%D1%82%D0%B5%D0%BD%D0%B7%D0%B8%D0%B2%D0%BD%D1%8B%D0%B5_%D1%81%D1%80%D0%B5%D0%B4%D1%81%D1%82%D0%B2%D0%B0%2C_%D0%B2%D0%BB%D0%B8%D1%8F%D1%8E%D1%89%D0%B8%D0%B5_%D0%BD%D0%B0_%D1%81%D0%BE%D1%81%D1%83%D0%B4%D0%BE%D0%B4%D0%B2%D0%B8%D0%B3%D0%B0%D1%82%D0%B5%D0%BB%D1%8C%D0%BD%D1%8B%D0%B5_%D1%86%D0%B5%D0%BD%D1%82%D1%80%D1%8B_%D0%B3%D0%BE%D0%BB%D0%BE%D0%B2%D0%BD%D0%BE%D0%B3%D0%BE_%D0%BC%D0%BE%D0%B7%D0%B3%D0%B0
) contains 4 exact same entries "Урапидил"
(http://ru.wikipedia.org/wiki/%D0%A3%D1%80%D0%B0%D0%BF%D0%B8%D0%B4%D0%B8%D0%BB).

Only one should be there.
• bzimport added a comment.Jan 10 2005, 9:56 AM

gal86 wrote:

Category "Логика" in ru.wikipedia.org
(http://ru.wikipedia.org/wiki/Category:%D0%9B%D0%BE%D0%B3%D0%B8%D0%BA%D0%B0)
contains 2 exact same entries "Парадокс"
(http://ru.wikipedia.org/wiki/%D0%9F%D0%B0%D1%80%D0%B0%D0%B4%D0%BE%D0%BA%D1%81).

Only one should be there.
• bzimport added a comment.Jan 10 2005, 9:59 AM

gal86 wrote:

Category "X86" in ru.wikipedia.org
(http://ru.wikipedia.org/wiki/Category:X86)
contains 2 exact same entries "Am486 SX2"
(http://ru.wikipedia.org/wiki/Am486_SX2).
Only one should be there.

• bzimport added a comment.Jan 10 2005, 10:01 AM

gal86 wrote:

Category "Программное обеспечение" in ru.wikipedia.org
(http://ru.wikipedia.org/wiki/Category:%D0%9F%D1%80%D0%BE%D0%B3%D1%80%D0%B0%D0%BC%D0%BC%D0%BD%D0%BE%D0%B5_%D0%BE%D0%B1%D0%B5%D1%81%D0%BF%D0%B5%D1%87%D0%B5%D0%BD%D0%B8%D0%B5)
contains 2 exact same entries "Лексикон (программа)"
(http://ru.wikipedia.org/wiki/%D0%9B%D0%B5%D0%BA%D1%81%D0%B8%D0%BA%D0%BE%D0%BD_%28%D0%BF%D1%80%D0%BE%D0%B3%D1%80%D0%B0%D0%BC%D0%BC%D0%B0%29).
Only one should be there.

• bzimport added a comment.Jan 10 2005, 10:08 AM

bugzilla_wikipedia_org.to.jamesd 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.

• bzimport added a comment.Jan 13 2005, 10:16 PM

zigger wrote:

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

• brion added a comment.May 5 2005, 8:54 PM
  • Bug 2080 has been marked as a duplicate of this bug. ***
• bzimport added a comment.May 15 2005, 11:42 AM

zigger wrote:

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

• bzimport added a comment.Jun 11 2005, 10:29 AM

gangleri wrote:

see http://bugzilla.wikimedia.org/show_bug.cgi?id=2382#c1
bug 2382: "existence of duplicate records as a result of bug 1202"
bug 2388: "handling: add a "purge" link to [[MediaWiki:Noarticletext]]"

• brion added a comment.Jun 16 2005, 6:52 PM

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
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL