Description of problem:
This bug report is to track problems with schema upgrade scriptlet
012-2-rhnPackageFile-data.sql, introduced in Spacewalk 0.8.
It's aim is to update rhnPackageFile and rhnChecksum tables with
correct sha256 checksums and checksum ids. For very large
customer databases (> 20GB DATA_TBS), this schema upgrade scriptlet
is very likely to run out of standard UNDO_TBS tablespace size (500 MB).
For very large rhnPackageFile tables (~ 50M rows), this update
needs further optimizations.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Satellite 5.3.0 and earlier with very large rhnPackageFile table
(~ 50M rows)
2. Upgrade to newer Satellite version
You run out of standard - sized UNDO_TBS during schema upgrade.
You won't run out of standard - sized UNDO_TBS during schema upgrade.
At the time of writing this bug, I'm referring to non-existent, future
version of Satellite product.
We made several attempts to optimize sql upgrade script for current minimal UNDO (500MB) and TEMP (250MB) size unfortunately all of them took more then 24 hours to complete.
As this is an unacceptable long upgrade window for customers we agreed to change minimal sizes to 1GB UNDO and 1GB TEMP space.
After this modified upgrade script completed in about 4hrs (on ~ 50M row rhnPackageFile table).
563902 - tuned sql upgrade script
we have to fit into 1GB TEMP and 1GB UNDO here
563902 - let's make default TEMP and UNDO 1GB
and save us from many troubles during upgrades
Make sure upgrade instructions for satellite >5.3.X contain:
Prior running schema upgrade (spacewalk-schema-upgrade) extend both UNDO and TEMP_TBS tablespaces to at least 1GB.
the instruction about extending UND_TBS and TEMP_TBS both to 1GB is written in both rhel4, rhel5 rhn-upgrade documents.
The 5.4.0 RHN Satellite and RHN Proxy release has occurred. This issue has been resolved with this release.
RHEA-2010:0801 - RHN Satellite Server 5.4.0 Upgrade
RHEA-2010:0803 - RHN Tools enhancement update
RHEA-2010:0802 - RHN Proxy Server 5.4.0 bug fix update
RHEA-2010:0800 - RHN Satellite Server 5.4.0
Docs are available: