db-control gather-stats ERROR: missing chunk number <#> for toast value <#> in pg_toast_<#>
Issue
- db-control gather-stats errors out with the following error message:
# db-control gather-stats
Gathering statistics...
WARNING: this may be a very slow process.
DBD::Pg::db do failed: ERROR: missing chunk number 0 for toast value 235947 in pg_toast_2619 at /usr/share/perl5/vendor_perl/Dobby/DB.pm line 228.
- spacewalk-report errata-list errors out with a like traceback:
# spacewalk-report errata-list
SQL error occurred, traceback follows...
Traceback (most recent call last):
File "/usr/bin/spacewalk-report", line 246, in <module>
h.execute(**dict(report.params.items() + the_dict_where.items()))
File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 147, in execute
return self._execute_wrapper(self._execute, *p, **kw)
File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 292, in _execute_wrapper
raise sql_base.SQLSchemaError(error_code, e.pgerror, e)
spacewalk.server.rhnSQL.sql_base.SQLSchemaError: (99999, 'ERROR: missing chunk number 0 for toast value 235947 in pg_toast_2619', '', InternalError('missing chunk number 0 for toast value 235947 in pg_toast_2619\n',))
Environment
Red Hat Satellite 5.7
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.