Last modified: 2013-06-18 15:26:44 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T24010, the corresponding Phabricator task for complete and up-to-date bug report information.
First Last Prev Next    This bug is not in your last search results.
Bug 22010 - SQL error while deleting on SQLite
SQL error while deleting on SQLite
Status: RESOLVED WORKSFORME
Product: MediaWiki
Classification: Unclassified
Page deletion (Other open bugs)
1.16.x
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks: sqlite
  Show dependency tree / graph
 
Reported: 2010-01-04 13:29 UTC by Max Semenik
Modified: 2013-06-18 15:26 UTC (History)
4 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description Max Semenik 2010-01-04 13:29:57 UTC 
INSERT INTO archive (ar_namespace,ar_title,ar_comment,ar_user,ar_user_text,ar_timestamp,ar_minor_edit,ar_rev_id,ar_text_id,ar_text,ar_flags,ar_len,ar_page_id,ar_deleted) SELECT page_namespace,page_title,rev_comment,rev_user,rev_user_text,rev_timestamp,rev_minor_edit,rev_id,rev_text_id,'','',rev_len,page_id,rev_deleted FROM page,revision WHERE page_id = '3040' AND (page_id = rev_page)
Comment 1 Mark A. Hershberger 2010-01-12 04:03:33 UTC 
not enough information to reproduce.
Comment 2 Mark A. Hershberger 2010-01-12 04:19:47 UTC 
As tstarling said, missed that the sqlite maintainer was the one who opened this and gave it to himself.
Comment 3 Max Semenik 2010-01-13 09:15:38 UTC 
Yes, I should have given more details. This bug was just a quick note to myself, while doing something else.

Error 19: column ar_len is not unique.

Doesn't happen at all times, does not happen frequently. I was able to reproduce it consistently on one page, but it vanished after I edited it. The bug is pretty critical when deleting files, because SQL error at that time does not lead to rollback of non-database changes, such as move of file to archive storage. Page deletion seems to fail gracefully.
Comment 4 Chad H. 2010-01-13 23:39:30 UTC 
(In reply to comment #3)
> The bug is pretty critical when deleting files, because SQL error at that time does
> not lead to rollback of non-database changes, such as move of file to archive
> storage. Page deletion seems to fail gracefully.
> 

That's related to bug 17560 and its friend bug 19751.
Comment 5 tskahatapitiya 2010-10-20 03:05:00 UTC 
WINDOWS RESTORE AND SQL RECOWER SOFTWEAR INSTROL THEN RECOWER AFTER UPDATE SQL
Comment 6 Max Semenik 2011-02-24 16:58:15 UTC 
Downgrading severity, it can't result in data loss now.
Comment 7 Bugmeister Bot 2011-08-19 19:12:33 UTC 
Unassigning default assignments. http://article.gmane.org/gmane.science.linguistics.wikipedia.technical/54734
Comment 8 Max Semenik 2011-11-02 19:34:53 UTC 
Can't repro any longer, closing pending more reports.
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.

Navigation
Links