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