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

[DiOrio, Max]

Hi Michael,

Nothing interesting in the postgres logs actually.

Like others, I've had to do a wipe and reload of the database and reinstall spacewalk.

Before I reinstalled postgres, I found that the LC_ALL was not set.  So I set using export LC_ALL=en-US,UTF-8

After doing this, the postgres install set the collation to UTF8 everywhere.  I set up the repos again and all of them synced properly including EPEL.


Max DiOrio
Global Systems Administrator

-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Michael Mraka
Sent: Wednesday, January 24, 2018 5:54 AM
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] LOCK TABLE can only be used in transaction blocks syncing EPEL

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
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list