Send Spacewalk-list mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://www.redhat.com/mailman/listinfo/spacewalk-list
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Spacewalk-list digest..."
Today's Topics:
1. RE: unregister clients or remove pacakges fromchannel (Ross)
2. RE: unregister clients or remove pacakges fromchannel
(Aric Morgan)
3. RE: unregister clients or remove pacakges fromchannel (Ross)
4. RE: unregister clients or remove pacakges fromchannel
(Aric Morgan)
----------------------------------------------------------------------
Message: 1
Date: Fri, 19 Dec 2008 12:37:25 -0600
From: Ross <[email protected]>
Subject: RE: [Spacewalk-list] unregister clients or remove pacakges
fromchannel
To: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset="iso-8859-1"
Hi Aric
After bumping up the debugging, the error I get:
2008-12-19 12:29:20,665 [TP-Processor3] WARN
org.apache.struts.action.RequestProcessor - Unhandled Exception thrown: class
com.redhat.rhn.common.db.WrappedSQLException
2008-12-19 12:29:20,849 [TP-Processor3] ERROR
com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction.
Rolling back
javax.servlet.ServletException: ORA-00942: table or view does not exist
and further down:
Caused by: com.redhat.rhn.common.db.WrappedSQLException: ORA-00942: table or
view does not exist
and even further:
2008-12-19 12:29:20,941 [TP-Processor3] ERROR
org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rhn].[action] -
Servlet.service() for servlet action threw exception
java.sql.SQLException: ORA-00942: table or view does not exist
Version 0.4, is that from SVN?
Thanks
Ross
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
https://www.redhat.com/archives/spacewalk-list/attachments/20081219/8e0a0294/attachment.html
------------------------------
Message: 2
Date: Fri, 19 Dec 2008 13:10:07 -0600
From: "Aric Morgan" <[email protected]>
Subject: RE: [Spacewalk-list] unregister clients or remove pacakges
fromchannel
To: <[email protected]>
Message-ID:
<10525_1229713859_mbjjaef7023973_96af20fdf4301d419b33cce8e3a0132b0661f...@sat4mx07.rackspace.corp>
Content-Type: text/plain; charset="us-ascii"
Ross,
So looking back at the changes I made the other day, I also added to
/etc/rhn/default/rhn_hibernate.conf -- hibernate.show_sql=true. This
should show you something like:
Hibernate: select legacyrhnu0_.id as id235_4_, legacyrhnu0_.login as
login235_4_, legacyrhnu0_.login_uc as login3_235_4_,
legacyrhnu0_.password as password23
5_4_, legacyrhnu0_.created as created235_4_, legacyrhnu0_.modified as
modified235_4_, legacyrhnu0_.org_id as org7_235_4_,
personalin1_.web_user_id as web1_23
2_0_, personalin1_.prefix as prefix232_0_, personalin1_.first_names as
first3_232_0_, personalin1_.last_name as last4_232_0_,
personalin1_.company as company
232_0_, personalin1_.title as title232_0_, personalin1_.phone as
phone232_0_, personalin1_.fax as fax232_0_, personalin1_.email as
email232_0_, personalin1_.
created as created232_0_, personalin1_.modified as modified232_0_,
orgimpl2_.id as id44_1_, orgimpl2_.name as name44_1_,
orgimpl2_.oracle_customer_id as orac
le3_44_1_, orgimpl2_.oracle_customer_number as oracle4_44_1_,
orgimpl2_.customer_type as customer5_44_1_, orgimpl2_.created as
created44_1_, orgimpl2_.credit
_application_completed as credit7_44_1_, orgimpl2_.modified as
modified44_1_, orgimpl2_1_.reg_token_id as reg2_47_1_,
entitlemen3_.org_id as org1_6_, orgenti
tle4_.id as entitlem2_6_, orgentitle4_.id as id43_2_, orgentitle4_.label
as label43_2_, orgentitle4_.name as name43_2_, orgentitle4_.created as
created43_2_,
orgentitle4_.modified as modified43_2_, trustedorg5_.org_id as org1_7_,
orgimpl6_.id as org2_7_, orgimpl6_.id as id44_3_, orgimpl6_.name as
name44_3_, orgim
pl6_.oracle_customer_id as oracle3_44_3_,
orgimpl6_.oracle_customer_number as oracle4_44_3_,
orgimpl6_.customer_type as customer5_44_3_, orgimpl6_.created as
created44_3_, orgimpl6_.credit_application_completed as credit7_44_3_,
orgimpl6_.modified as modified44_3_, orgimpl6_1_.reg_token_id as
reg2_47_3_ from WEB_
CONTACT legacyrhnu0_, WEB_USER_PERSONAL_INFO personalin1_, WEB_CUSTOMER
orgimpl2_, rhnRegTokenOrgDefault orgimpl2_1_, rhnOrgEntitlements
entitlemen3_, RHNORG
ENTITLEMENTTYPE orgentitle4_, rhnTrustedOrgs trustedorg5_, WEB_CUSTOMER
orgimpl6_, rhnRegTokenOrgDefault orgimpl6_1_ where
legacyrhnu0_.id=personalin1_.web_u
ser_id and legacyrhnu0_.org_id=orgimpl2_.id and
orgimpl2_.id=orgimpl2_1_.org_id(+) and
orgimpl2_.id=entitlemen3_.org_id(+) and entitlemen3_.entitlement_id=or
gentitle4_.id(+) and orgimpl2_.id=trustedorg5_.org_id(+) and
trustedorg5_.org_trust_id=orgimpl6_.id(+) and
orgimpl6_.id=orgimpl6_1_.org_id(+) and legacyrhnu0
_.id=?
2008-12-15 10:23:14,157 [TP-Processor3] WARN
org.hibernate.util.JDBCExceptionReporter - SQL Error: 942, SQLState:
42000
2008-12-15 10:23:14,157 [TP-Processor3] ERROR
org.hibernate.util.JDBCExceptionReporter - ORA-00942: table or view does
not exist
I broke this query down a bit and checked it within Oracle and was able
to duplicate the error with:
'select trustedorg5_.org_id as org1_7_ from rhnTrustedOrgs
trustedorg5_;'
>From the git repo I saw in
schema/spacewalk/upgrade/spacewalk-0.3-spacewalk-0.4 the file
116-rhnTrustedOrgs.sql which creates that table. Unfortunately I
haven't had the chance to get any further with this.
Aric
From: [email protected]
[mailto:[email protected]] On Behalf Of Ross
Sent: Friday, December 19, 2008 12:37 PM
To: [email protected]
Subject: RE: [Spacewalk-list] unregister clients or remove pacakges
fromchannel
Hi Aric
After bumping up the debugging, the error I get:
2008-12-19 12:29:20,665 [TP-Processor3] WARN
org.apache.struts.action.RequestProcessor - Unhandled Exception thrown:
class com.redhat.rhn.common.db.WrappedSQLException
2008-12-19 12:29:20,849 [TP-Processor3] ERROR
com.redhat.rhn.frontend.servlets.SessionFilter - Error during
transaction. Rolling back
javax.servlet.ServletException: ORA-00942: table or view does not exist
and further down:
Caused by: com.redhat.rhn.common.db.WrappedSQLException: ORA-00942:
table or view does not exist
and even further:
2008-12-19 12:29:20,941 [TP-Processor3] ERROR
org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rhn].[ac
tion] - Servlet.service() for servlet action threw exception
java.sql.SQLException: ORA-00942: table or view does not exist
Version 0.4, is that from SVN?
Thanks
Ross
Confidentiality Notice: This e-mail message (including any attached or
embedded documents) is intended for the exclusive and confidential use of the
individual or entity to which this message is addressed, and unless otherwise
expressly indicated, is confidential and privileged information of Rackspace.
Any dissemination, distribution or copying of the enclosed material is
prohibited.
If you receive this transmission in error, please notify us immediately by
e-mail
at [email protected], and delete the original message.
Your cooperation is appreciated.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
https://www.redhat.com/archives/spacewalk-list/attachments/20081219/4c32ff68/attachment.html
------------------------------
Message: 3
Date: Fri, 19 Dec 2008 14:22:29 -0600
From: Ross <[email protected]>
Subject: RE: [Spacewalk-list] unregister clients or remove pacakges
fromchannel
To: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Okay, now I have gotten the sql statements.
Hibernate: select channelfam0_.channel_id as channel1_1_,
channelfam0_.channel_family_id as channel2_1_, channelfam1_.id as id38_0_,
channelfam1_.name as name38_0_, channelfam1_.label as label38_0_,
channelfam1_.product_url as product4_38_0_, channelfam1_.created as
created38_0_, channelfam1_.modified as modified38_0_, channelfam1_.org_id as
org7_38_0_ from rhnChannelFamilyMembers channelfam0_, rhnChannelFamily
channelfam1_ where channelfam0_.channel_family_id=channelfam1_.id(+) and
channelfam0_.channel_id=?
Hibernate: update PXTSessions set value=?, web_user_id=?, expires=? where id=?
2008-12-19 13:57:20,153 [TP-Processor8] WARN
org.apache.struts.action.RequestProcessor - Unhandled Exception thrown: class
com.redhat.rhn.common.db.WrappedSQLException
2008-12-19 13:57:20,236 [TP-Processor8] ERROR
com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction.
Rolling back
javax.servlet.ServletException: ORA-00942: table or view does not exist
From this, I am assuming that the table that doesn't exist is:
rhnChannelFamilyMembers ?
I am not versed in oracle, just MySQL (and MS-SQL, don't tell anyone
though). How would I know if this tables exists or not?
Thanks
Ross
------------------------------
Message: 4
Date: Fri, 19 Dec 2008 14:34:55 -0600
From: "Aric Morgan" <[email protected]>
Subject: RE: [Spacewalk-list] unregister clients or remove pacakges
fromchannel
To: <[email protected]>
Message-ID:
<11584_1229718898_mbjkynxo026996_96af20fdf4301d419b33cce8e3a0132b0661f...@sat4mx07.rackspace.corp>
Content-Type: text/plain; charset="US-ASCII"
Ross,
Try logging into oracle/sqlplus and run the query "select table_name
from user_tables;" or "select table_name from user_tables where
table_name=' rhnChannelFamilyMembers';"
Aric
Confidentiality Notice: This e-mail message (including any attached or
embedded documents) is intended for the exclusive and confidential use of the
individual or entity to which this message is addressed, and unless otherwise
expressly indicated, is confidential and privileged information of Rackspace.
Any dissemination, distribution or copying of the enclosed material is
prohibited.
If you receive this transmission in error, please notify us immediately by
e-mail
at [email protected], and delete the original message.
Your cooperation is appreciated.
------------------------------
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
End of Spacewalk-list Digest, Vol 7, Issue 21
*********************************************
