Page MenuHomePhabricator

"column rev_parent_id does not exist" error after update
Closed, ResolvedPublic

Description

Author: s_angelov

Description:
update.php output (1.11.0 to 1.13.0)

after upgrade from 1.11.0 to 1.13.0 i get the following error when trying to open any of the content pages:

A database error has occurred Query: SELECT rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,page_namespace,page_title,page_latest FROM page,revision WHERE (page_id=rev_page) AND rev_id = '581' LIMIT 1 Function: Revision::fetchRow Error: 1 ERROR: column "rev_parent_id" does not exist
Backtrace:
#0 /my-dir-tree/wiki/includes/db/Database.php(561): DatabasePostgres->reportQueryError('ERROR: column ...', 1, 'SELECT rev_id,...', 'Revision::fetch...', false)
#1 /my-dir-tree/wiki/includes/db/Database.php(969): Database->query('SELECT rev_id,...', 'Revision::fetch...')
#2 /my-dir-tree/wiki/includes/Revision.php(236): Database->select(Array, Array, Array, 'Revision::fetch...', Array)
#3 /my-dir-tree/wiki/includes/Revision.php(165): Revision::fetchFromConds(Object(DatabasePostgres), Array)
#4 /my-dir-tree/wiki/includes/Revision.php(146): Revision::loadFromConds(Object(DatabasePostgres), Array)
#5 /my-dir-tree/wiki/includes/Revision.php(27): Revision::newFromConds(Array)
#6 /my-dir-tree/wiki/includes/Article.php(430): Revision::newFromId('581')
#7 /my-dir-tree/wiki/includes/Article.php(300): Article->fetchContent(0)
#8 /my-dir-tree/wiki/includes/Article.php(218): Article->loadContent()
#9 /my-dir-tree/wiki/includes/Article.php(803): Article->getContent()
#10 /my-dir-tree/wiki/includes/Wiki.php(437): Article->view()
#11 /my-dir-tree/wiki/includes/Wiki.php(59): MediaWiki->performAction(Object(OutputPage), Object(Article), Object(Title), Object(User), Object(WebRequest))
#12 /my-dir-tree/wiki/index.php(93): MediaWiki->initialize(Object(Title), Object(Article), Object(OutputPage), Object(User), Object(WebRequest))
#13 {main}

the database postmaster.log also shows the error:
ERROR: column "rev_parent_id" does not exist

postgresql is version 8.1.11. update.php completed with no errors - i am attaching the output for reference.
i have reverted back to 1.11.0 and restored the database from backup.


Version: 1.13.x
Severity: major
OS: Solaris
Platform: Other

Attached:

Details

Reference
bz15281

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
InvalidNone
ResolvedNone

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 10:21 PM
bzimport set Reference to bz15281.
bzimport added a subscriber: Unknown Object (MLST).

elly wrote:

I'm experiencing the same thing on a Linux server RH4, PHP5.2+ that is using PostgreSQL for its db. It looks like that column is missing from the updates in updaters.inc and is not populating the column

niccolo wrote:

Same problem here upgrading from 1.9.2 to 1.13.0, PostgreSQL 8.2. No error or warning message was printed during "php update.php".

The problem can be that the maintenance/archives/patch-rev_parent_id.sql executes

ALTER TABLE revision ADD rev_parent_id int unsigned default NULL;

which is an error in PostgreSQL. Removing the "unsigned" does the trick.

Jdforrester-WMF subscribed.

Migrating from the old tracking task to a tag for PostgreSQL-related tasks.