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:[email protected]] 201 Fuller Road, Suite 202 Albany, NY 12203-3621 Phone: +518-238-6516 | Mobile: +518-944-5289 [email protected]<mailto:[email protected]>
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
