[Spacewalk-list] Error after upgrade to 1.3
Kobus Bensch
kobus.bensch at lovefilm.com
Thu Feb 10 09:02:12 UTC 2011
Hi Thomas
Loaded plugins: fastestmirror, rhnplugin
This system is not registered with RHN.
RHN support will be disabled.
Loading mirror speeds from cached hostfile
* addons: mirror.ox.ac.uk
* base: mirror.netrino.co.uk
* epel: mirror01.th.ifl.net
* extras: www.mirrorservice.org
* rpmforge: fr2.rpmfind.net
* updates: mirror.netrino.co.uk
repo id repo
name status
addons CentOS-5 -
Addons enabled: 0
base CentOS-5 -
Base enabled: 3,434
epel Extra Packages for Enterprise Linux 5
- x86_64 enabled: 6,218
extras CentOS-5 -
Extras enabled: 296
rpmforge RHEL 5 - RPMforge.net -
dag enabled: 10,272
spacewalk
Spacewalk
enabled: 199
spacewalk-client Spacewalk Client
Tools enabled: 22
updates CentOS-5 -
Updates enabled: 1,135
repolist: 21,576
Tomas Lestach wrote:
> 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
>
> _______________________________________________
> 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/783efb5a/attachment.htm>
-------------- 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/783efb5a/attachment.gif>
More information about the Spacewalk-list
mailing list