[Spacewalk-list] Error after upgrade to 1.3
Sander Grendelman
sander at grendelman.com
Wed Feb 9 14:12:52 UTC 2011
I haven't upgraded to 1.3 yet ( and I'm quite glad I didn't at the
moment ). So I can only offer some pointers from my experience working
with Oracle DB's ;)
* Did you remove the 10.2 instantclient or did you install the
11g-instantclient side-by-side?
* Could this be a non-upgrade-related DB-issue (e.g. size > 4GB)?
* What are the differences between the pre- and post-upgrade rhn.conf
files?
On Wed, Feb 09, 2011 at 12:58:11PM +0000, Kobus Bensch wrote:
> Is anybody able to assist please. I need to manage some servers
>
> Thanks
>
> Kobus
>
> 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>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
More information about the Spacewalk-list
mailing list