Still me and my issue... Sorry for bothering you.<div>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?</div><div><br>
</div><div><div>INFO | jvm 1 | 2011/09/15 05:40:00 | com.redhat.rhn.common.db.WrappedSQLException: ERROR: relation "old_packages" already exists</div><div>INFO | jvm 1 | 2011/09/15 05:40:00 | at com.redhat.rhn.common.translation.SqlExceptionTranslator.postgreSqlException(SqlExceptionTranslator.java:56)</div>
<div>INFO | jvm 1 | 2011/09/15 05:40:00 | at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:45)</div><div>INFO | jvm 1 | 2011/09/15 05:40:00 | at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:118)</div>
<div>INFO | jvm 1 | 2011/09/15 05:40:00 | at com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable(CachedStatement.java:511)</div><div>INFO | jvm 1 | 2011/09/15 05:40:00 | at com.redhat.rhn.common.db.datasource.CallableMode.execute(CallableMode.java:34)</div>
<div>INFO | jvm 1 | 2011/09/15 05:40:00 | at com.redhat.rhn.manager.errata.cache.ErrataCacheManager.updateErrataAndPackageCacheForChannel(ErrataCacheManager.java:403)</div><div>INFO | jvm 1 | 2011/09/15 05:40:00 | at com.redhat.rhn.manager.errata.cache.UpdateErrataCacheCommand.updateErrataCacheForChannel(UpdateErrataCacheCommand.java:180)</div>
<div>INFO | jvm 1 | 2011/09/15 05:40:00 | at com.redhat.rhn.taskomatic.task.errata.ErrataCacheWorker.run(ErrataCacheWorker.java:77)</div><div>INFO | jvm 1 | 2011/09/15 05:40:00 | at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:761)</div>
<div>INFO | jvm 1 | 2011/09/15 05:40:00 | at java.lang.Thread.run(Thread.java:636)</div><div>INFO | jvm 1 | 2011/09/15 05:40:00 | Caused by: org.postgresql.util.PSQLException: ERROR: relation "old_packages" already exists</div>
<div>INFO | jvm 1 | 2011/09/15 05:40:00 | at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)</div><div>INFO | jvm 1 | 2011/09/15 05:40:00 | at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)</div>
<div>INFO | jvm 1 | 2011/09/15 05:40:00 | at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)</div><div>INFO | jvm 1 | 2011/09/15 05:40:00 | at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)</div>
<div>INFO | jvm 1 | 2011/09/15 05:40:00 | at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)</div><div>INFO | jvm 1 | 2011/09/15 05:40:00 | at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:347)</div>
<div>INFO | jvm 1 | 2011/09/15 05:40:00 | at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:2706)</div><div>INFO | jvm 1 | 2011/09/15 05:40:00 | at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:115)</div>
<div>INFO | jvm 1 | 2011/09/15 05:40:00 | ... 7 more</div><div><br></div><div>I have activated the statement logging in pgsql, and herre is what I get:</div><div><div>ERROR: relation "old_packages" already exists</div>
<div>CONTEXT: SQL statement "create temp table old_packages ( errata_id numeric, package_id numeric ) on commit drop"</div><div> PL/pgSQL function "update_needed_cache" line 7 at SQL statement</div>
<div> SQL statement "SELECT rhn_server.update_needed_cache( $1 )"</div><div> PL/pgSQL function "update_needed_cache" line 12 at PERFORM</div><div>STATEMENT: select * from rhn_channel.update_needed_cache($1) as result</div>
<div>WARNING: nonstandard use of \\ in a string literal at character 99</div><div>HINT: Use the escape string syntax for backslashes, e.g., E'\\'.</div><div>WARNING: nonstandard use of \\ in a string literal at character 1247</div>
<div>HINT: Use the escape string syntax for backslashes, e.g., E'\\'.</div><div>ERROR: current transaction is aborted, commands ignored until end of transaction block</div><div>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</div>
<div>WARNING: nonstandard use of \\ in a string literal at character 99</div></div><div><br></div><div><br></div><div>Thanks in advance for your help.</div><div><br></div><div><br></div><div>Pierre</div><br><div class="gmail_quote">
2011/9/14 Pierre Casenove <span dir="ltr"><<a href="mailto:pcasenove@gmail.com">pcasenove@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hello,<div>I've rhnpushed the latest kernel package available (2.6.18-274.3.1.el5) on rhn and still the same issue:</div><div>- Which version installed on the client (2.6.18-274.el5)</div><div>- is in primary.xml.gz : 2.6.18-274 and 2.6.18-274.3.1</div>
<div>- yum list kernel --showduplicate:</div><div><div># yum list kernel --showduplicates</div><div>Loaded plugins: rhnplugin, security</div><div>Installed Packages</div><div>kernel.x86_64 2.6.18-238.el5 installed</div>
<div>kernel.x86_64 2.6.18-274.el5 installed</div><div>Available Packages</div><div>kernel.x86_64 2.6.18-238.el5 rhel-5-server-x64</div>
<div>kernel.x86_64 2.6.18-274.el5 rhel-5-server-x64</div><div>kernel.x86_64 2.6.18-274.3.1.el5 rhel-5-server-x64</div>
<div><br></div><div>- In List/Remove: 2.6.18-274</div><div>- In Upgrade: No Packages</div><div>- In Packages of channel : 3 kernel rpm: 2.6.18-238, 2.6.18-274, 2.6.18-274.3.1</div><div>- In primary.xml.gz on spacewalk: 2.6.18-274 and 2.6.18-274.3.1</div>
<div>- sha1sums are identical</div><div>- Last modified:</div><div><div>Last Modified:<span style="white-space:pre-wrap"> </span>2011-09-14 11:32:20 CEST</div><div>Last Repo Build:<span style="white-space:pre-wrap"> </span> 2011-09-14 11:32:20 CEST</div>
<div>Repo Cache Status:<span style="white-space:pre-wrap"> </span> Completed</div></div><div><br></div><div>Of course, after running rhn-profile-sync, it's ok, the package is listed as needed for the client.</div>
<div><br></div><div>Thanks,</div><div><br></div><font color="#888888"><div>Pierre</div><div><br></div><br></font><div class="gmail_quote"><div class="im">2011/9/14 Michael Mraka <span dir="ltr"><<a href="mailto:michael.mraka@redhat.com" target="_blank">michael.mraka@redhat.com</a>></span><br>
</div><div><div></div><div class="h5"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Pierre Casenove wrote:<br>
% Thanks for the answer:<br>
<div>% 1) I checked the details of the base channel, the repo cache is sync'ed:<br>
% Last Modified: 2011-09-12 11:11:24 CEST<br>
% Last Repo Build: 2011-09-12 11:11:24 CEST<br>
% Repo Cache Status: Completed<br>
%<br>
% 2) For information, I used rhnpush and not reposync to push the rpms in the<br>
% base channel.<br>
%<br>
% 3) I don't have any process related to a repo sync running on my server.<br>
%<br>
% I don't know what's wrong....<br>
<br>
</div>I'd choose one package which should be upgraded but it isn't and checked which<br>
version of the package<br>
* is installed on client? (rpm -q)<br>
* is in client:/var/cache/yum/<channel>/primary.xml.gz?<br>
* What does say yum list <package> --showduplicates?<br>
* is in Spacewalk WebUI: Systems > <client> > Software > List / Remove ?<br>
* is in Spacewalk WebUI: Systems > <client> > Software > Upgrade ?<br>
* is in Spacewalk WebUI: Channels > <channel> > Packages ?<br>
* is in spacewalk:/var/cache/rhn/repodata/<channel>/primary.xml.gz?<br>
* Do sha1sums of client:/var/cache/yum/<channel>/primary.xml.gz and<br>
spacewalk:/var/cache/rhn/repodata/<channel>/primary.xml.gz match?<br>
* What timestamps are on Spacewalk WebUI: Channels > <channel> > Details ><br>
Last Modified & Last Repo Build?<br>
<br>
This should hopefully reveal where the chain break...<br>
<br>
% Pierre<br>
<br>
Regards,<br>
<font color="#888888"><br>
--<br>
Michael Mráka<br>
Satellite Engineering, Red Hat<br>
</font><div><div></div><div><br>
_______________________________________________<br>
Spacewalk-list mailing list<br>
<a href="mailto:Spacewalk-list@redhat.com" target="_blank">Spacewalk-list@redhat.com</a><br>
<a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a></div></div></blockquote></div></div></div><br></div>
</blockquote></div><br></div>