Page MenuHomePhabricator

Oracle installation fails on creation of mainpage (column PAGE.PAGE_LINKS_UPDATED missing)
Closed, ResolvedPublic

Description

Latest version:

Creating main page with default content... failed
Information

Could not insert main page: A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: SELECT /* WikiPage::pageData 10.1.20.47 */ * FROM (SELECT page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_links_updated,page_latest,page_len,page_content_model FROM /*Q*/PAGE WHERE page_namespace = '0' AND page_title = 'Main_Page' ) WHERE rownum >= (1 + 0) AND rownum < (1 + 1 + 0) Function: DatabaseOracle::doQuery Error: 904 ORA-00904: "PAGE_LINKS_UPDATED": invalid identifier

select * from v$version;

PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production


Version: 1.23.0
Severity: normal

Details

Reference
bz61015

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 3:05 AM
bzimport set Reference to bz61015.
bzimport added a subscriber: Unknown Object (MLST).

this would be duplicate of https://bugzilla.wikimedia.org/show_bug.cgi?id=58435 but the versions are different here

(In reply to comment #0)

Latest version:

What's that? Git master? 1.22.2 tarball?

There are three tickets now (bug 58435, bug 61015, bug 61016) and I'm confused.

We don't have separate bugs per version so something is probably a duplicate, and something should be marked as blocking / depending on something.
[The "Backport to Stable" dropdown (for backporting to 1.22) can be set to "?" once a patch for git master is in.]

Sounds like gerrit 111735 will fix this.

Maybe the database error should be [part of] the bug summary, because all the failed main page creation have different errors.

freak wrote:

(In reply to comment #6)
Yup, that change solves this issue ... just somone has to merge it.

(In reply to comment #5)

There are three tickets now (bug 58435, bug 61015, bug 61016) and I'm
confused.

We don't have separate bugs per version so something is probably a duplicate,
and something should be marked as blocking / depending on something.
[The "Backport to Stable" dropdown (for backporting to 1.22) can be set to
"?"
once a patch for git master is in.]

These bugs are always different in something, at least 2 bugs I reported had a different error, so these were 2 bugs, not 1

This gerrit change:

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

Has worsened the status of this bug.

Change 116627 had a related patch set uploaded by CSteipp:
Add Updater for Oracle

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

Change 116627 merged by jenkins-bot:
Add Updater for Oracle

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

freak wrote:

There was a bug in the updater and tables.sql, but it was merged before i noticed ... i rebased my older changesed and included the fix for it in https://gerrit.wikimedia.org/r/111735

(In reply to Andre Klapper from comment #13)

https://gerrit.wikimedia.org/r/#/c/111735/ still outstanding.

This patch got merged into master today.
Please elaborate if more work is needed.

Backporting to 1.23 is likely wanted; hence setting Backport_to_Stable flag to "?" and CC'ing hexmode. Please set the flag to "+" once merged.

I'm not closing this as FIXED as our Gerrit notification bot would reset the status back to PATCH_TO_REVIEW anyway, once a patch in Gerrit to backport has been created.

Merged to 1.23. No bug reference there so the bot isn't updating Bugzilla. Closed!