DiOrio, Max:
> Hi,
> 
> New Spacewalk user trying to sync the EPEL repo and getting the following 
> error.  I'm not the only one, as it appears in December, there have been an 
> increasing number of people reporting this issue.
> 
> https://bugzilla.redhat.com/show_bug.cgi?id=1529253
> 
> It supposedly stems from the Postgres database being in ASCII mode, which 
> mine was.  However a dump of the data, conversion to UTF8, re-installing 
> postgres with UTF8 and restoring the data yields the same error.  All other 
> repos that I'm syncing are working properly - only the EPEL is an issue.
> 
> Any thoughts?  Thanks!

Hi Max,

Are there any new / different error messages in
/var/lib/pgsql/data/pg_log/postgresql-*.log (since conversion to UTF*)?
Does removing of /var/cache/rhn/reposync/* make any difference?

> Importing packages:     |##################################################| 
> 99.96%
> Importing packages:     |##################################################| 
> 99.98%
> Importing packages:     |##################################################| 
> 99.99%
> Importing packages:     |##################################################| 
> 100.0%
> 18:58:13 Linking packages to channel.
> 
> 2018-01-21 18:58:20,678 [Thread-18452] ERROR 
> com.redhat.rhn.taskomatic.task.RepoSyncTask  - 14:49:41
> 42/8534 : kipi-plugins-doc-4.10.0-6.el7.noarch.rpm (failed)
> 14:49:48 50/8534 : knot-2.6.1-1.el7.x86_64.rpm (failed)
> 14:49:56 51/8534 : koan-2.8.2-1.el7.noarch.rpm (failed)
> 14:50:09 57/8534 : koji-1.14.0-1.el7.noarch.rpm (failed)
> (All other packages after this point fail.)
> 
> 
> Traceback (most recent call last):
...
>   File 
> "/usr/lib/python2.7/site-packages/spacewalk/server/importlib/backendOracle.py",
>  line 686, in lookupChecksums
>     raise e
> spacewalk.server.rhnSQL.sql_base.SQLSchemaError: (99999, 'ERROR:  LOCK TABLE 
> can only be used in transaction blocks', '', InternalError('LOCK TABLE can 
> only be used in transaction blocks\n',))
> 

Regards,

--
Michael Mráka
System Management Engineering, Red Hat

_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list

Reply via email to