Last modified: 2014-05-09 16:50:12 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 T63015, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 61015 - Oracle installation fails on creation of mainpage (column PAGE.PAGE_LINKS_UPDATED missing)
Oracle installation fails on creation of mainpage (column PAGE.PAGE_LINKS_UPD...
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Installer (Other open bugs)
1.23.0
All All
: Normal normal (vote)
: 1.23.0 release
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks: oracle
  Show dependency treegraph
 
Reported: 2014-02-07 09:53 UTC by Peter Bena
Modified: 2014-05-09 16:50 UTC (History)
7 users (show)

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


Attachments

Description Peter Bena 2014-02-07 09:53:33 UTC
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
Comment 1 Peter Bena 2014-02-07 09:55:33 UTC
this would be duplicate of https://bugzilla.wikimedia.org/show_bug.cgi?id=58435 but the versions are different here
Comment 2 Andre Klapper 2014-02-07 10:09:40 UTC
(In reply to comment #0)
> Latest version:

What's that? Git master? 1.22.2 tarball?
Comment 3 Peter Bena 2014-02-07 10:36:20 UTC
git master
Comment 4 Peter Bena 2014-02-07 10:36:53 UTC
1.22.2 tarball produces https://bugzilla.wikimedia.org/show_bug.cgi?id=61016
Comment 5 Andre Klapper 2014-02-07 10:46:05 UTC
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.]
Comment 6 db [inactive,noenotif] 2014-02-07 15:02:14 UTC
Sounds like Gerrit change #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.
Comment 7 Jure Kajzer 2014-02-07 15:32:27 UTC
(In reply to comment #6)
Yup, that change solves this issue ... just somone has to merge it.
Comment 8 Peter Bena 2014-02-07 16:07:11 UTC
(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
Comment 9 Tyler Romeo 2014-02-25 00:51:06 UTC
This gerrit change:

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

Has worsened the status of this bug.
Comment 10 Gerrit Notification Bot 2014-03-03 21:31:38 UTC
Change 116627 had a related patch set uploaded by CSteipp:
Add Updater for Oracle

https://gerrit.wikimedia.org/r/116627
Comment 11 Gerrit Notification Bot 2014-03-03 23:53:39 UTC
Change 116627 merged by jenkins-bot:
Add Updater for Oracle

https://gerrit.wikimedia.org/r/116627
Comment 12 Jure Kajzer 2014-03-04 09:19:01 UTC
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
Comment 13 Andre Klapper 2014-04-25 06:49:58 UTC
https://gerrit.wikimedia.org/r/#/c/111735/ still outstanding.
Comment 14 Andre Klapper 2014-05-09 15:39:59 UTC
(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.
Comment 15 Mark A. Hershberger 2014-05-09 16:50:12 UTC
Merged to 1.23.  No bug reference there so the bot isn't updating Bugzilla.  Closed!

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


Navigation
Links