Bug 231964
| Summary: | Satellite Installation documentation bug - database block size | ||
|---|---|---|---|
| Product: | Red Hat Satellite 5 | Reporter: | Nick Strugnell <nstrug> |
| Component: | Installer | Assignee: | John Ha <jha> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Corey Welton <cwelton> |
| Severity: | medium | Docs Contact: | |
| Priority: | medium | ||
| Version: | 410 | CC: | adstrong, cperry |
| Target Milestone: | --- | Keywords: | Documentation |
| Target Release: | --- | ||
| Hardware: | All | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | sat510 | Doc Type: | Bug Fix |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2008-04-03 00:35:55 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
| Bug Depends On: | |||
| Bug Blocks: | 248622 | ||
Reassign bugs to jha. Moving Status to 'Assigned' This is fixed in the latest build of Satellite 5.1.0 Installation Guide. Here is the content with the 8kb block size database requirement stated: http://lacrosse.corp.redhat.com/~jha/rhn_510/installation-guide/s1-requirements-database.html QA Verified, text exists in db requirements on iso. 5.1 Sat GA so Docs bugs Closed for Current Release. |
Description of problem: The section in the installation guide for satellite regarding the configuration of an external database makes no mention of what database block size to use therefore we have used the defaults in all installations. However, the default on Oracle 9.2.0.1.0 for Windows 2000 is 4KB rather than the more usual 8KB. This turns out to be too small to hold the index keys for the rhn_pkg_cl_pid_n_txt_time_uq index created on the rhnPackageChangelog table. Thus, schema creation fails. Unfortunately this failure happens silently, and the problem is not apparent until satellite activation fails at a later stage of the install.pl script. Version-Release number of selected component (if applicable): 4.1.5 however I suspect that this affects all versions of satellite. How reproducible: Always Steps to Reproduce: 1. Configure external database with 4KB block size (the default on 9iR2 on Windows 2000) 2. Install satellite with external database 3. Actual results: Satellite activation fails. No further error messages are given. Further investigation shows the following in populate_db.log:- SQL> create unique index rhn_pkg_cl_pid_n_txt_time_uq on rhnPackageChangelog(package_id, name, text, time) nologging tablespace RHNSS_DATA storage ( freelists 16 ) initrans 32; on rhnPackageChangelog(package_id, name, text, time) * ERROR at line 2: ORA-01450: maximum key length (3118) exceeded Expected results: Satellite installation should proceed normally. Additional info: Two things we need to do here:- * Fix installer.pl so that it detects failure of the schema to create properly and does not carry on with the satellite installation. * Fix documentation so that it states clearly that an 8KB minimum db_block_size is required to install satellite with an external database.