[Spacewalk-list] Spacewalk 2.7 database corruption?

[Brian Long]

My team recently updated from 2.5 to 2.7 but we also had an operational
issue where the database partition filled up (while running SW 2.5) and
postgres came to a halt.  Since that time we have experienced a few issues
although the upgrade to 2.7 went smoothly.

One of them is that the Web UI shows packages available (and I can download
them from within the Web UI), but our clients cannot see the same packages
even if I remove /var/cache/yum, yum clean all, etc. on the client.  I am
trying to determine how to clean up the database and package repository
such that the clients see exactly what is shown in the Web UI.  We have
tried iterations of spacewalk-data-fsck to no avail.

Second, we have the following database errors when we try removing one of
our admins:
2017-10-12 15:11:14.752 EDT ERROR:  could not read block 0 of relation
base/16384/22380: read only 0 of 8192 bytes
2017-10-12 15:11:14.752 EDT STATEMENT:  SELECT wce.id AS ID,
               wce.login,
               wce.login_uc,
               UI.last_logged_in
          FROM rhnWebContactEnabled wce
                inner join rhnUserInfo UI on UI.user_id = wce.id
         WHERE wce.org_id = $1
        ORDER BY wce.login_uc
2017-10-12 15:11:14.752 EDT ERROR:  current transaction is aborted,
commands ignored until end of transaction block
2017-10-12 15:11:14.752 EDT STATEMENT:  select 'c3p0 ping' from dual
2017-10-12 15:11:27.458 EDT ERROR:  could not read block 0 of relation
base/16384/22380: read only 0 of 8192 bytes
2017-10-12 15:11:27.458 EDT STATEMENT:  SELECT ugm.user_id
             FROM rhnUserGroupMembers ugm
             JOIN rhnwebcontactenabled wce on wce.id = ugm.user_id
            WHERE ugm.user_group_id = (SELECT id
                                         FROM rhnUserGroup
                                        WHERE org_id = $1
                                          AND group_type = (SELECT id FROM
                  rhnUserGroupType WHERE label = 'org_admin'))
              AND wce.read_only = 'N'
             ORDER BY ugm.user_id
2017-10-12 15:11:27.458 EDT ERROR:  current transaction is aborted,
commands ignored until end of transaction block
2017-10-12 15:11:27.458 EDT STATEMENT:  select 'c3p0 ping' from dual

How can we go about fixing these two issues?

Thank you for any assistance!

/Brian/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20171012/871d1fcd/attachment.htm>