[Spacewalk-list] Error after upgrade to 1.3

Tomas Lestach tlestach at redhat.com
Wed Feb 9 17:53:45 UTC 2011


Hello Kobus,

would you post output of

yum repolist

?

Regards,
Tomas
--
Tomas Lestach
RHN Satellite Engineering, Red Hat

On 02/09/2011 03:29 PM, Kobus Bensch wrote:
> Hi Sander
>
> Sander Grendelman wrote:
>> 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?
>>
> removed the 10g version and installed the 11g one
>> * Could this be a non-upgrade-related DB-issue (e.g. size>  4GB)?
>>
> db size = 2.47GB
>> * What are the differences between the pre- and post-upgrade rhn.conf
>>    files?
>>
> diff is that i am now not using tnsnames.ora, but get the same result no
> matter which one I use.
> ran spacewalk-setup --upgrade after tnsnames.ora removal
>> 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 visithttp://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
>>>
>>
>> _______________________________________________
>> 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