[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!

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/bin/spacewalk-repo-sync", line 257, in <module>
    sys.exit(abs(main() or 0))
  File "/usr/bin/spacewalk-repo-sync", line 240, in main
    elapsed_time, channel_ret_code = sync.sync()
  File "/usr/lib/python2.7/site-packages/spacewalk/satellite_tools/reposync.py", line 475, in sync
    ret = self.import_packages(plugin, repo_id, url)
  File "/usr/lib/python2.7/site-packages/spacewalk/satellite_tools/reposync.py", line 1038, in import_packages
    importer.run()
  File "/usr/lib/python2.7/site-packages/spacewalk/server/importlib/importLib.py", line 664, in run
    self.fix()
  File "/usr/lib/python2.7/site-packages/spacewalk/server/importlib/packageImport.py", line 76, in fix
    self.backend.lookupChecksums(self.checksums)
  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',))

2018-01-21 18:58:20,989 [DefaultQuartzScheduler_Worker-3] ERROR com.redhat.rhn.taskomatic.task.RepoSyncTask  - Executing a task threw an exception: org.quartz.JobExecutionException
2018-01-21 18:58:20,989 [DefaultQuartzScheduler_Worker-3] ERROR com.redhat.rhn.taskomatic.task.RepoSyncTask  - Message: Command '[/usr/bin/spacewalk-repo-sync, --channel, ieeegs_epel_rhel7_x86_64, --type, yum]'
exited with error code 1
2018-01-21 18:58:20,989 [DefaultQuartzScheduler_Worker-3] ERROR com.redhat.rhn.taskomatic.task.RepoSyncTask  - Cause: null
2018-01-21 18:58:21,007 [DefaultQuartzScheduler_Worker-3] ERROR com.redhat.rhn.taskomatic.task.RepoSyncTask  - Stack trace:org.quartz.JobExecutionException: Command '[/usr/bin/spacewalk-repo-sync, --channel, iee
egs_epel_rhel7_x86_64, --type, yum]' exited with error code 1
        at com.redhat.rhn.taskomatic.task.RhnJavaJob.executeExtCmd(RhnJavaJob.java:103)
        at com.redhat.rhn.taskomatic.task.RepoSyncTask.execute(RepoSyncTask.java:70)
        at com.redhat.rhn.taskomatic.task.RhnJavaJob.execute(RhnJavaJob.java:88)
        at com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:186)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)



Max DiOrio
Global Systems Administrator
[cid:image002.jpg at 01D26A5C.D5C0BF00]
201 Fuller Road, Suite 202
Albany, NY 12203-3621
Phone: +518-238-6516 | Mobile: +518-944-5289
max.diorio at ieeeglobalspec.com<mailto:max.diorio at ieeeglobalspec.com>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20180123/b7e2facd/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 2276 bytes
Desc: image001.jpg
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20180123/b7e2facd/attachment.jpg>