installation of MW on oracle 11g fail
Closed, ResolvedPublic
Actions

Assigned To

None

Authored By

	Petrb
	Jul 26 2013, 1:45 PM

Project Tags

Referenced Files

None

Subscribers

Petrb

• wikibugs-l-list

Description

I am running it on latest GIT head

Could not insert main page: ORA-02091: transaction rolled back ORA-02291: integrity constraint (WIKI.REVISION_FK2) violated - parent key not found

This happens during installation, database oracle 11g enterprise edition

user was created:

CREATE USER wiki

IDENTIFIED BY testwiki
DEFAULT TABLESPACE DATA
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 1 Role for MW 
GRANT RESOURCE TO wiki;
ALTER USER wiki DEFAULT ROLE ALL;
-- 3 System Privileges for MW 
GRANT CREATE SEQUENCE TO wiki;
GRANT UNLIMITED TABLESPACE TO wiki;
GRANT CONNECT TO wiki;
GRANT CREATE SESSION TO wiki;

Version: unspecified
Severity: normal

Details

Reference: bz52094

Event Timeline

• bzimport raised the priority of this task from to Medium.Nov 22 2014, 1:51 AM

• bzimport added a project: MediaWiki-Installer.

• bzimport set Reference to bz52094.

• bzimport added a subscriber: Unknown Object (MLST).

Petrb created this task.Jul 26 2013, 1:45 PM

Setting up database... done
Creating database user... done
Creating tables... done
Populating default interwiki table... done
Initializing statistics... done
Generating secret keys... done
Creating administrator user account... done
Creating main page with default content... failed

Could not insert main page: ORA-02091: transaction rolled back ORA-02291: integrity constraint (WIKI.REVISION_FK2) violated - parent key not found

ccing Jure who knows about Oracle :-]

freak wrote:

See comment 21 on https://bugzilla.wikimedia.org/show_bug.cgi?id=38411#c21

I haven't managed to get that patch into the repo yet ($busyBunnyMode=true).

*** This bug has been marked as a duplicate of bug 38411 ***

tstarling added a project: Oracle Database.May 19 2017, 10:17 AM

tstarling removed a parent task: T40916: [DO NOT USE] Oracle DB support (tracking).May 19 2017, 10:21 AM

installation of MW on oracle 11g failClosed, ResolvedPublicActions

Description

Details

Event Timeline

installation of MW on oracle 11g fail
Closed, ResolvedPublic
Actions