[Spacewalk-list] Re: Spacewalk-list Digest, Vol 7, Issue 21

Ross rmarshall at solidodesign.com
Mon Dec 22 16:01:38 UTC 2008 

spacewalk-list-request at redhat.com wrote:
> Send Spacewalk-list mailing list submissions to
> 	spacewalk-list at redhat.com
>
> 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
> 	spacewalk-list-request at redhat.com
>
> You can reach the person managing the list at
> 	spacewalk-list-owner at redhat.com
>
> 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 <rmarshall at solidodesign.com>
> Subject: RE: [Spacewalk-list] unregister clients or remove pacakges
> 	fromchannel
> To: spacewalk-list at redhat.com
> Message-ID: <494BE9E5.8070100 at solidodesign.com>
> 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" <amorgan at rackspace.com>
> Subject: RE: [Spacewalk-list] unregister clients or remove pacakges
> 	fromchannel
> To: <spacewalk-list at redhat.com>
> Message-ID:
> 	<10525_1229713859_mBJJAeF7023973_96AF20FDF4301D419B33CCE8E3A0132B0661FBBF at 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: spacewalk-list-bounces at redhat.com
> [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Ross
> Sent: Friday, December 19, 2008 12:37 PM
> To: spacewalk-list at redhat.com
> 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 abuse at rackspace.com, 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 <rmarshall at solidodesign.com>
> Subject: RE: [Spacewalk-list] unregister clients or remove pacakges
> 	fromchannel
> To: spacewalk-list at redhat.com
> Message-ID: <494C0285.6030804 at solidodesign.com>
> 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" <amorgan at rackspace.com>
> Subject: RE: [Spacewalk-list] unregister clients or remove pacakges
> 	fromchannel
> To: <spacewalk-list at redhat.com>
> Message-ID:
> 	<11584_1229718898_mBJKYNxo026996_96AF20FDF4301D419B33CCE8E3A0132B0661FBC0 at 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 abuse at rackspace.com, and delete the original message.
> Your cooperation is appreciated.
>
>
>
>
> ------------------------------
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
> End of Spacewalk-list Digest, Vol 7, Issue 21
> *********************************************
>   
Hi Aric

After running that command, I get 'no rows selected', so I suspect (go 
powers of deduction) that this is my problem.

Ross

More information about the Spacewalk-list mailing list