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: [email protected] [mailto:[email protected]] On Behalf Of Michael Mraka Sent: Wednesday, January 24, 2018 5:54 AM To: [email protected] 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 [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
