[Spacewalk-list] Updates not seen as needed for clients
Pierre Casenove
pcasenove at gmail.com
Thu Sep 15 06:12:05 UTC 2011
Still me and my issue... Sorry for bothering you.
I found an error in rhn_taskomatic log. For information, I've upgraded my
spacewalk pgsql install from 1.4 to 1.5. Could this be related to my issue?
INFO | jvm 1 | 2011/09/15 05:40:00 |
com.redhat.rhn.common.db.WrappedSQLException: ERROR: relation "old_packages"
already exists
INFO | jvm 1 | 2011/09/15 05:40:00 | at
com.redhat.rhn.common.translation.SqlExceptionTranslator.postgreSqlException(SqlExceptionTranslator.java:56)
INFO | jvm 1 | 2011/09/15 05:40:00 | at
com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:45)
INFO | jvm 1 | 2011/09/15 05:40:00 | at
com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:118)
INFO | jvm 1 | 2011/09/15 05:40:00 | at
com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable(CachedStatement.java:511)
INFO | jvm 1 | 2011/09/15 05:40:00 | at
com.redhat.rhn.common.db.datasource.CallableMode.execute(CallableMode.java:34)
INFO | jvm 1 | 2011/09/15 05:40:00 | at
com.redhat.rhn.manager.errata.cache.ErrataCacheManager.updateErrataAndPackageCacheForChannel(ErrataCacheManager.java:403)
INFO | jvm 1 | 2011/09/15 05:40:00 | at
com.redhat.rhn.manager.errata.cache.UpdateErrataCacheCommand.updateErrataCacheForChannel(UpdateErrataCacheCommand.java:180)
INFO | jvm 1 | 2011/09/15 05:40:00 | at
com.redhat.rhn.taskomatic.task.errata.ErrataCacheWorker.run(ErrataCacheWorker.java:77)
INFO | jvm 1 | 2011/09/15 05:40:00 | at
EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:761)
INFO | jvm 1 | 2011/09/15 05:40:00 | at
java.lang.Thread.run(Thread.java:636)
INFO | jvm 1 | 2011/09/15 05:40:00 | Caused by:
org.postgresql.util.PSQLException: ERROR: relation "old_packages" already
exists
INFO | jvm 1 | 2011/09/15 05:40:00 | at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
INFO | jvm 1 | 2011/09/15 05:40:00 | at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
INFO | jvm 1 | 2011/09/15 05:40:00 | at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
INFO | jvm 1 | 2011/09/15 05:40:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
INFO | jvm 1 | 2011/09/15 05:40:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
INFO | jvm 1 | 2011/09/15 05:40:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:347)
INFO | jvm 1 | 2011/09/15 05:40:00 | at
com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:2706)
INFO | jvm 1 | 2011/09/15 05:40:00 | at
com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:115)
INFO | jvm 1 | 2011/09/15 05:40:00 | ... 7 more
I have activated the statement logging in pgsql, and herre is what I get:
ERROR: relation "old_packages" already exists
CONTEXT: SQL statement "create temp table old_packages ( errata_id numeric,
package_id numeric ) on commit drop"
PL/pgSQL function "update_needed_cache" line 7 at SQL statement
SQL statement "SELECT rhn_server.update_needed_cache( $1 )"
PL/pgSQL function "update_needed_cache" line 12 at PERFORM
STATEMENT: select * from rhn_channel.update_needed_cache($1) as result
WARNING: nonstandard use of \\ in a string literal at character 99
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING: nonstandard use of \\ in a string literal at character 1247
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
ERROR: current transaction is aborted, commands ignored until end of
transaction block
STATEMENT: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS
TABLE_NAME, CASE n.nspname LIKE 'pg\\_%' OR n.nspname =
'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR
n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM
TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE
NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN
'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END
ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'i' THEN
'TEMPORARY INDEX' ELSE NULL END END WHEN false THEN CASE c.relkind
WHEN 'r' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE'
WHEN 'v' THEN 'VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE,
d.description AS REMARKS FROM pg_catalog.pg_namespace n,
pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid =
d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON
(d.classoid=dc.oid AND dc.relname='pg_class') LEFT JOIN
pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND
dn.nspname='pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE
'PROBABLYNOT' AND (false OR ( c.relkind = 'r' AND n.nspname NOT LIKE
'pg\\_%' AND n.nspname <> 'information_schema' ) ) ORDER BY
TABLE_TYPE,TABLE_SCHEM,TABLE_NAME
WARNING: nonstandard use of \\ in a string literal at character 99
Thanks in advance for your help.
Pierre
2011/9/14 Pierre Casenove <pcasenove at gmail.com>
> Hello,
> I've rhnpushed the latest kernel package available (2.6.18-274.3.1.el5) on
> rhn and still the same issue:
> - Which version installed on the client (2.6.18-274.el5)
> - is in primary.xml.gz : 2.6.18-274 and 2.6.18-274.3.1
> - yum list kernel --showduplicate:
> # yum list kernel --showduplicates
> Loaded plugins: rhnplugin, security
> Installed Packages
> kernel.x86_64 2.6.18-238.el5
> installed
> kernel.x86_64 2.6.18-274.el5
> installed
> Available Packages
> kernel.x86_64 2.6.18-238.el5
> rhel-5-server-x64
> kernel.x86_64 2.6.18-274.el5
> rhel-5-server-x64
> kernel.x86_64 2.6.18-274.3.1.el5
> rhel-5-server-x64
>
> - In List/Remove: 2.6.18-274
> - In Upgrade: No Packages
> - In Packages of channel : 3 kernel rpm: 2.6.18-238,
> 2.6.18-274, 2.6.18-274.3.1
> - In primary.xml.gz on spacewalk: 2.6.18-274 and 2.6.18-274.3.1
> - sha1sums are identical
> - Last modified:
> Last Modified: 2011-09-14 11:32:20 CEST
> Last Repo Build: 2011-09-14 11:32:20 CEST
> Repo Cache Status: Completed
>
> Of course, after running rhn-profile-sync, it's ok, the package is listed
> as needed for the client.
>
> Thanks,
>
> Pierre
>
>
> 2011/9/14 Michael Mraka <michael.mraka at redhat.com>
>
>> Pierre Casenove wrote:
>> % Thanks for the answer:
>> % 1) I checked the details of the base channel, the repo cache is sync'ed:
>> % Last Modified: 2011-09-12 11:11:24 CEST
>> % Last Repo Build: 2011-09-12 11:11:24 CEST
>> % Repo Cache Status: Completed
>> %
>> % 2) For information, I used rhnpush and not reposync to push the rpms in
>> the
>> % base channel.
>> %
>> % 3) I don't have any process related to a repo sync running on my server.
>> %
>> % I don't know what's wrong....
>>
>> I'd choose one package which should be upgraded but it isn't and checked
>> which
>> version of the package
>> * is installed on client? (rpm -q)
>> * is in client:/var/cache/yum/<channel>/primary.xml.gz?
>> * What does say yum list <package> --showduplicates?
>> * is in Spacewalk WebUI: Systems > <client> > Software > List / Remove ?
>> * is in Spacewalk WebUI: Systems > <client> > Software > Upgrade ?
>> * is in Spacewalk WebUI: Channels > <channel> > Packages ?
>> * is in spacewalk:/var/cache/rhn/repodata/<channel>/primary.xml.gz?
>> * Do sha1sums of client:/var/cache/yum/<channel>/primary.xml.gz and
>> spacewalk:/var/cache/rhn/repodata/<channel>/primary.xml.gz match?
>> * What timestamps are on Spacewalk WebUI: Channels > <channel> > Details >
>> Last Modified & Last Repo Build?
>>
>> This should hopefully reveal where the chain break...
>>
>> % Pierre
>>
>> Regards,
>>
>> --
>> Michael Mráka
>> Satellite Engineering, Red Hat
>>
>> _______________________________________________
>> Spacewalk-list mailing list
>> Spacewalk-list at redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110915/1d615178/attachment.htm>
More information about the Spacewalk-list
mailing list