Page MenuHomePhabricator

DBQuery error: Column 'rc_this_oldid' cannot be null
Closed, ResolvedPublic

Description

Noticed these errors (not a bit rate, but something to try to investigate and fix): https://logstash.wikimedia.org/goto/d58faa614b473f98789b468c86af2e7c

Error 1048 from RecentChange::save, Column 'rc_this_oldid' cannot be null (10.64.48.35) INSERT INTO `recentchanges` (rc_timestamp,rc_namespace,rc_title,rc_type,rc_source,rc_minor,rc_cur_id,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_comment_id,rc_actor) VALUES ('20210215073047',828,'Clickable_button_2',3,'mw.log',0,309274,NULL,0,0,'xxx',2,0,NULL,NULL,0,338329,'import','interwiki','a:2:{s:14:\"4:number:count\";i:12;s:22:\"5:title-link:interwiki\";s:28:\"en:Module:Clickable_button_2\";}','1',139) 10.64.48.35



url: /w/index.php?title=%E0%B0%AA%E0%B1%8D%E0%B0%B0%E0%B0%A4%E0%B1%8D%E0%B0%AF%E0%B1%87%E0%B0%95:%E0%B0%A6%E0%B0%BF%E0%B0%97%E0%B1%81%E0%B0%AE%E0%B0%A4%E0%B0%BF&action=submit

mwversion: 1.36.0-wmf.27
	
normalized_message: Error 1048 from RecentChange::save, {error} {sql1line} {db_server}
	
phpversion: 7.2.31-1+0~20200514.41+debian9~1.gbpe2a56b+wmf1+buster1

exception.trace: from /srv/mediawiki/php-1.36.0-wmf.27/includes/libs/rdbms/database/Database.php(1683)
#0 /srv/mediawiki/php-1.36.0-wmf.27/includes/libs/rdbms/database/Database.php(1661): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#1 /srv/mediawiki/php-1.36.0-wmf.27/includes/libs/rdbms/database/Database.php(1230): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#2 /srv/mediawiki/php-1.36.0-wmf.27/includes/libs/rdbms/database/Database.php(2346): Wikimedia\Rdbms\Database->query(string, string, integer)
#3 /srv/mediawiki/php-1.36.0-wmf.27/includes/libs/rdbms/database/Database.php(2326): Wikimedia\Rdbms\Database->doInsert(string, array, string)
#4 /srv/mediawiki/php-1.36.0-wmf.27/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->insert(string, array, string)
#5 /srv/mediawiki/php-1.36.0-wmf.27/includes/libs/rdbms/database/DBConnRef.php(369): Wikimedia\Rdbms\DBConnRef->__call(string, array)

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

Change 664352 had a related patch set uploaded (by Ammarpad; owner: Ammarpad):
[mediawiki/core@master] RecentChange: Cast rev_id attr value to integer

https://gerrit.wikimedia.org/r/664352

Change 664352 merged by jenkins-bot:
[mediawiki/core@master] RecentChange: Cast rev_id attr value to integer

https://gerrit.wikimedia.org/r/664352

Ammarpad claimed this task.