Red Hat Satellite Server upgrade to v.5.8 fails at database upgrade step while copying relation table

Solution Unverified - Updated -

Issue

  • Upgrading the Red Hat Satellite Server to v.5.8, failed at the database upgrade step:
error while copying relation "public.rhn_ckspb_check_suite_id_idx" ("/opt/rh/postgresql92/root/var/lib/pgsql/data/base/16384/87478" to "/var/opt/rh/rh-postgresql95/lib/pgsql/data/base/16400/87478"): No such file or directory
Failure, exiting
  • Below error capture in postgres logs :
 ERROR: could not read block 256065 of relation base/16384/87478: read only 0 of 8192 bytes

Environment

  • Red Hat Satellite v5.8
  • Red Hat Satellite v5.7
  • Red Hat Satellite v5.6

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content