[Spacewalk-list] LOCK TABLE can only be used in transaction blocks syncing EPEL

[Michael Mraka]

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