[Spacewalk-list] syncing epel to spacewalk 2.7

[Michael Mraka]

Ku Dude:
> Hi all,
> 
> I keep getting the following error when i try to sync the EPEL repo with my
> spacewalk 2.7 install:
> 
> Importing packages:
>  |##################################################| 100.0%
> 13:05:16 Linking packages to channel.
> Traceback (most recent call last):
>   File "/usr/bin/spacewalk-repo-sync", line 257, in <module>
...
> 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',))
> 
> My server is running CentOS Linux release 7.4.1708.
> 
> Any advice is appreciated.

It looks like an issue in db schema. Can you verify that your schema
package is not modified (rpm -V spacewalk-schema) and your schema is
up-to-date (spacewalk-schema-upgrade).

Maybe even check if other spacewalk packages has not been changed
(rpm -V ...).

Regards,

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