Last modified: 2010-05-15 14:36:27 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 1239 - New page created, db lag, result in double entries in categories
New page created, db lag, result in double entries in categories
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Categories (Other open bugs)
unspecified
All All
: Normal major with 3 votes (vote)
: ---
Assigned To: Nobody - You can work on this!
:
: 1285 1320 2179 (view as bug list)
Depends on: 1202
Blocks: db-repl-track
  Show dependency treegraph
 
Reported: 2004-12-30 21:11 UTC by Anthony Liekens
Modified: 2010-05-15 14:36 UTC (History)
3 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Anthony Liekens 2004-12-30 21:11:15 UTC
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]]
Comment 1 peter green 2004-12-30 21:16:50 UTC
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

Comment 2 JeLuF 2004-12-31 00:24:08 UTC
I removed the duplicate entry from the database.
Comment 3 Zigger 2005-01-08 16:05:29 UTC
*** Bug 1285 has been marked as a duplicate of this bug. ***
Comment 4 Jeff 2005-01-08 16:19:58 UTC
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
Comment 6 Nikiforov 2005-01-10 09:56:14 UTC
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.
Comment 7 Nikiforov 2005-01-10 09:59:02 UTC
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.

Comment 8 Nikiforov 2005-01-10 10:01:45 UTC
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.
Comment 9 Jamesday 2005-01-10 10:08:02 UTC
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.
Comment 10 Zigger 2005-01-13 22:16:42 UTC
*** Bug 1320 has been marked as a duplicate of this bug. ***
Comment 11 Brion Vibber 2005-05-05 20:54:43 UTC
*** Bug 2080 has been marked as a duplicate of this bug. ***
Comment 12 Zigger 2005-05-15 11:42:22 UTC
*** Bug 2179 has been marked as a duplicate of this bug. ***
Comment 13 lɛʁi לערי ריינהארט 2005-06-11 10:29:03 UTC
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]]"
Comment 14 Brion Vibber 2005-06-16 18:52:52 UTC
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.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links