[Spacewalk-list] Error after upgrade to 1.3
Kobus Bensch
kobus.bensch at lovefilm.com
Thu Feb 10 14:59:15 UTC 2011
As I have had NO HELP from anybody on this issue, here or bugzilla, i
will be reinstalling spacewalk
thanks for nothing
Kobus Bensch wrote:
> Hi Michael
>
> Here is result from commands you requested:
> 1.) s-08 ~]# egrep 'hibernate|db_name' /etc/rhn/rhn.conf
> db_name = //localhost/XE
> hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
> hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
> hibernate.connection.driver_proto=jdbc:oracle:oci
>
> 2.) s-08 ~]# sqlplus $(spacewalk-cfg-get default_db)
>
> SQL*Plus: Release 11.2.0.2.0 Production on Tue Feb 8 10:26:27 2011
>
> Copyright (c) 1982, 2010, Oracle. All rights reserved.
>
>
> Connected to:
> Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
>
> SQL>
>
> 3.) see attached
>
> 4.) I have now also restarted SW
> s-08 ~]# /usr/sbin/spacewalk-service restart
> Shutting down spacewalk services...
> Stopping RHN Taskomatic...
> RHN Taskomatic was not running.
> Stopping cobbler daemon: [ OK ]
> Stopping rhn-search...
> rhn-search was not running.
> Stopping MonitoringScout ...
> [ OK ]
> Stopping Monitoring ...
> [ OK ]
> Stopping httpd: [ OK ]
> Stopping tomcat5: [ OK ]
> Shutting down osa-dispatcher: [FAILED]
> Terminating jabberd processes ...
> Stopping router: [ OK ]
> Stopping sm: [ OK ]
> Stopping c2s: [ OK ]
> Stopping s2s: [ OK ]
> Done.
> Starting spacewalk services...
> Initializing jabberd processes ...
> Starting router: [ OK ]
> Starting sm: [ OK ]
> Starting c2s: [ OK ]
> Starting s2s: [ OK ]
> Starting osa-dispatcher: [ OK ]
> Starting tomcat5: [ OK ]
> Waiting for tomcat to be ready ...
> Starting httpd: [ OK ]
> Starting Monitoring ...
> [ OK ]
> Starting MonitoringScout ...
> [ OK ]
> Starting rhn-search...
> Starting cobbler daemon: [ OK ]
> Starting RHN Taskomatic...
> Done.
>
> 5.) and result from point 3 again attached in seperate file
>
> Kobus
>
> Michael Mraka wrote:
>> Kobus Bensch wrote:
>> % Ok, renamed the tnsnames.ora and re-ran spacewalk-setup --upgrade
>> %
>> % Stopped and started oracle and spacewalk and getting the folloign in
>> % the catalina logs:
>> %
>> % 07-Feb-2011 15:56:19
>> % com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run
>> % WARNING:
>> % com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask at 2857a293
>> % -- Acquisition Attempt Failed!!! Clearing pending acquires. While
>> % trying to acquire a needed new resource, we failed to succeed more
>> % than the maximum number of allowed acquisition attempts (30).
>> % 2011-02-07 15:56:19,562 [TP-Processor3] WARN
>> % org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState:
>> % null
>> % 2011-02-07 15:56:19,562 [TP-Processor3] ERROR
>> % org.hibernate.util.JDBCExceptionReporter - Connections could not be
>> % acquired from the underlying database!
>> % 2011-02-07 15:56:19,562 [TP-Processor3] ERROR
>> % com.redhat.rhn.frontend.servlets.SessionFilter - Error during
>> % transaction. Rolling back
>> % com.redhat.rhn.common.hibernate.HibernateRuntimeException: couldn't
>> % open session
>>
>> It still looks like tomcat wasn't able connect to database.
>> What's your db connection in rhn.conf?
>>
>> # egrep 'hibernate|db_name' /etc/rhn/rhn.conf
>>
>> Are you able connect to database with sqlplus?
>>
>> # sqlplus $(spacewalk-cfg-get default_db)
>>
>> Does any other java based service (e.g rhn-search, taskomatic) work?
>>
>> # service rhn-search status
>> # grep ERROR /var/log/rhn/search/rhn_search_daemon.log
>> # service taskomatic status
>> # grep ERROR /var/log/rhn/rhn_taskomatic_daemon.log
>>
>> 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
>
> --
> *Kobus Bensch*
> Linux Administrator
> kobus.bensch at lovefilm.com
>
> No.9 | 6 Portal Way | London | W3 6RU |
> T: +44 (0)20 8896 8014 | F: +44 (0)20 8896 8111
> <http://www.lovefilm.com>
>
>
> ------------------------------------------------------------------------
>
> LOVEFiLM UK Limited is a company registered in England and Wales.
> Registered Number: 06528297.
> Registered Office: No.9, 6 Portal Way, London W3 6RU, United Kingdom.
>
> This e-mail is confidential to the ordinary user of the e-mail address
> to which it was
> addressed. If you have received it in error, please delete it from
> your system and notify
> the sender immediately.
>
> This email message has been delivered safely and archived online by
> Mimecast.
> For more information please visit http://www.mimecast.co.uk
>
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
--
*Kobus Bensch*
Linux Administrator
kobus.bensch at lovefilm.com
No.9 | 6 Portal Way | London | W3 6RU |
T: +44 (0)20 8896 8014 | F: +44 (0)20 8896 8111
<http://www.lovefilm.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110210/ef5904f5/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 1641 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110210/ef5904f5/attachment.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: lfi.gif
Type: image/gif
Size: 1641 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110210/ef5904f5/attachment-0001.gif>
More information about the Spacewalk-list
mailing list