Satellite upgrade throws an error : "ORA-01653: unable to extend table xxx by 128 in tablespace DATA_TBS"
Issue
- Upgrading From Satellite 5.4 to Satellite 5.7 exits with errors in /var/log/rhn/rhn_db_migration.log :
Running: psql -U rhnuser -d rhnschema -v ON_ERROR_STOP=ON -f -
DBD::Oracle::st execute failed: ORA-01653: unable to extend table RHNSAT.RHNPACKAGECHANGELOGDATA by 128 in tablespace DATA_TBS (DBD ERROR: error possibly near <*> indicator at char 25 in ' insert /*+append*/ into <*>rhnPackageChangeLogData (id, name, text, time, created) select min(id), name, text, time, min(created) from rhnPackageChangelog group by name, text, time') [for Statement " insert /*+append*/ into rhnPackageChangeLogData (id, name, text, time, created) select min(id), name, text, time, min(created) from rhnPackageChangelog group by name, text, time"] at /usr/bin/spacewalk-dump-schema line 442.
DBD::Oracle::st execute failed: ORA-01653: unable to extend table RHNSAT.RHNPACKAGECHANGELOGDATA by 128 in tablespace DATA_TBS (DBD ERROR: error possibly near <*> indicator at char 25 in ' insert /*+append*/ into <*>rhnPackageChangeLogData (id, name, text, time, created) select min(id), name, text, time, min(created) from rhnPackageChangelog group by name, text, time') [for Statement " insert /*+append*/ into rhnPackageChangeLogData (id, name, text, time, created) select min(id), name, text, time, min(created) from rhnPackageChangelog group by name, text, time"] at /usr/bin/spacewalk-dump-schema line 442.
DBD::Oracle::st execute failed: ORA-00942: table or view does not exist (DBD ERROR: error possibly near <*> indicator at char 12 in ' drop table <*>rhnOrgConfiguration') [for Statement " drop table rhnOrgConfiguration"] at /usr/bin/spacewalk-dump-schema line 442.
DBD::Oracle::st execute failed: ORA-00942: table or view does not exist (DBD ERROR: error possibly near <*> indicator at char 12 in ' drop table <*>rhnOrgConfiguration') [for Statement " drop table rhnOrgConfiguration"] at /usr/bin/spacewalk-dump-schema line 442.
END failed--call queue aborted at /usr/bin/spacewalk-dump-schema line 442.
Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Oracle::db handle rhnsat at /usr/bin/spacewalk-dump-schema line 442.
- Command
db-control extendthrows an error :
No such command 'extend'
Environment
- Red Hat Satellite 5.4
- Red Hat Enterprise Linux (RHEL6)
- x86_64 Architecture
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.