Last modified: 2014-08-11 00:01:11 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 T42667, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 40667 - Drop unused rc_cur_time field from recentchanges table in version 1.24
Drop unused rc_cur_time field from recentchanges table in version 1.24
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.20.x
All All
: Low normal (vote)
: 1.24.0 release
Assigned To: Umherirrender
: schema-change
Depends on:
Blocks: 67151
  Show dependency treegraph
 
Reported: 2012-10-01 19:35 UTC by db [inactive,noenotif]
Modified: 2014-08-11 00:01 UTC (History)
7 users (show)

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


Attachments

Description db [inactive,noenotif] 2012-10-01 19:35:02 UTC
From tables.sql:
  -- This is no longer used
  rc_cur_time varbinary(14) NOT NULL default '',

So please clean up and remove it. Thanks.
Comment 1 Umherirrender 2012-11-28 18:46:59 UTC
Commited Gerrit change #35659
Comment 2 Umherirrender 2013-01-20 14:06:38 UTC
(In reply to comment #1)
> Commited Gerrit change #35659

No longer support for this commit by me.
Comment 3 Gerrit Notification Bot 2013-11-09 16:33:15 UTC
Change 42278 restored by Umherirrender:
(bug 40667) deprecate rc_cur_time of recentchanges

Reason:
Column is still unused and should dropped same day.
Start with removing it from sql statements.

https://gerrit.wikimedia.org/r/42278
Comment 4 Gerrit Notification Bot 2013-11-09 16:45:18 UTC
Change 42278 had a related patch set uploaded by Umherirrender:
Deprecate rc_cur_time of recentchanges

https://gerrit.wikimedia.org/r/42278
Comment 5 MZMcBride 2013-11-09 16:48:20 UTC
Is there a bug tracking dropping database columns from MediaWiki core?
Comment 6 Gerrit Notification Bot 2013-11-15 23:22:28 UTC
Change 42278 merged by jenkins-bot:
Remove recentchanges.rc_cur_time from sql statements

https://gerrit.wikimedia.org/r/42278
Comment 7 Umherirrender 2013-11-16 02:03:37 UTC
Field was removed from sql statements.

Milestone is now 1.24

Keeping the field until 1.24 allows easier rollback on version update from 1.22 -> 1.23, when something gets wrong with the new version.
Comment 8 Marcin Cieślak 2013-12-04 10:58:59 UTC
I am now getting 

Query: INSERT INTO "recentchanges" (rc_timestamp,rc_namespace,rc_title,rc_type,rc_source,rc_minor,rc_cur_id,rc_user,rc_user_text,rc_comment,rc_this_oldid,rc_last_oldid,rc_bot,rc_ip,rc_patrolled,rc_new,rc_old_len,rc_new_len,rc_deleted,rc_logid,rc_log_type,rc_log_action,rc_params,rc_id) VALUES ('2013-12-04 10:54:26 GMT','0','Main_Page','1','mw.new','0','1','0','MediaWiki default',,'1','0','0','127.0.0.1','0','1','0','524','0','0',NULL,,,'1')
Function: RecentChange::save
Error: 23502 ERROR:  null value in column "rc_cur_time" violates not-null constraint

when installing git master (now at 0a54e70cdd2162be4b331aacb79ad5a3926dd2c6) on PostgreSQL.
Comment 9 Marcin Cieślak 2013-12-04 11:19:59 UTC
Submitted Gerrit change #99068 to revert this for now.
Comment 10 Marcin Cieślak 2013-12-05 10:59:22 UTC
To reiterate what I said in the code review for Gerrit change #99068:

I think that the commit should remove the field from both SQL as well as all table definitions and add updater definitions for three major databases as you did in the original gerrit change. WMF is using neither installer nor updater so I believe they can live with it.
Comment 11 Umherirrender 2013-12-06 14:02:25 UTC
This way was used to avoid the third party updaters to restore his database,
when he have to downgrade (or roll back the upgrade).
Comment 12 Gerrit Notification Bot 2014-04-14 18:33:14 UTC
Change 125769 had a related patch set uploaded by Umherirrender:
Drop rc_cur_time from recentchanges

https://gerrit.wikimedia.org/r/125769
Comment 13 Gerrit Notification Bot 2014-05-06 20:05:55 UTC
Change 131852 had a related patch set uploaded by EBernhardson:
Stop populating rc_cur_time

https://gerrit.wikimedia.org/r/131852
Comment 14 Gerrit Notification Bot 2014-05-06 20:25:54 UTC
Change 131852 merged by jenkins-bot:
Stop populating rc_cur_time

https://gerrit.wikimedia.org/r/131852
Comment 15 Gerrit Notification Bot 2014-05-16 20:23:15 UTC
Change 125769 merged by jenkins-bot:
Drop rc_cur_time from recentchanges

https://gerrit.wikimedia.org/r/125769
Comment 16 Umherirrender 2014-05-16 21:29:57 UTC
Field is now dropped in master

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


Navigation
Links