Page MenuHomePhabricator

update.php errors on sqlite - patch-ar_rev_id-not-null.sql - no such column: ar_actor
Closed, ResolvedPublic

Description

[...]
Migrating archive ar_text to modern storage.
Migrating ar_text to modern storage...
Completed ar_text migration, 0 rows updated, 0 missing data.
Dropping ar_text and ar_flags columns ...done.
...actor table already exists.
...rev_text_id in table revision already modified by patch patch-rev_text_id-default.sql.
...table site_stats already modified by patch patch-site_stats-modify.sql.
Populating ar_rev_id.
...Update 'PopulateArchiveRevId' already logged as completed.
Making ar_rev_id not nullable ...[b262c67926efcd664520735f] [no req]   Wikimedia\Rdbms\DBQueryError from line 1443 of /var/www/w/mediawiki/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 
Query: INSERT OR IGNORE INTO archive_tmp (
 ar_id, ar_namespace, ar_title, ar_comment, ar_comment_id, ar_user,
 ar_user_text, ar_actor, ar_timestamp, ar_minor_edit, ar_rev_id,
 ar_text_id, ar_deleted, ar_len, ar_page_id, ar_parent_id, ar_sha1,
 ar_content_model, ar_content_format)
 SELECT
 ar_id, ar_namespace, ar_title, ar_comment, ar_comment_id, ar_user,
 ar_user_text, ar_actor, ar_timestamp, ar_minor_edit, ar_rev_id,
 ar_text_id, ar_deleted, ar_len, ar_page_id, ar_parent_id, ar_sha1,
 ar_content_model, ar_content_format
 FROM archive

Function: Wikimedia\Rdbms\Database::sourceFile( /var/www/w/mediawiki/maintenance/sqlite/archives/patch-ar_rev_id-not-null.sql )
Error: 1 no such column: ar_actor

Event Timeline

Vvjjkkii renamed this task from update.php errors on sqlite - patch-ar_rev_id-not-null.sql - no such column: ar_actor to e6aaaaaaaa.Jul 1 2018, 1:04 AM
Vvjjkkii triaged this task as High priority.
Vvjjkkii updated the task description. (Show Details)
Vvjjkkii removed a subscriber: Aklapper.
CommunityTechBot renamed this task from e6aaaaaaaa to update.php errors on sqlite - patch-ar_rev_id-not-null.sql - no such column: ar_actor.Jul 2 2018, 2:02 PM
CommunityTechBot raised the priority of this task from High to Needs Triage.
CommunityTechBot updated the task description. (Show Details)
CommunityTechBot added a subscriber: Aklapper.
Umherirrender subscribed.

With T227662 the actor patches are splitted. The output here shows that the addition of table actor is skipped, because the table exists.

Before the fix for T227662 that also skippes all the other actor fields and that could result in the problem that ar_actor does not exists when running the next update of that table. The order of both updates is correct