[Spacewalk-list] Error after upgrade to 1.3
Kobus Bensch
kobus.bensch at lovefilm.com
Wed Feb 9 14:29:16 UTC 2011
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 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
>>
>
> _______________________________________________
> 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/20110209/d4a84076/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/20110209/d4a84076/attachment.gif>
More information about the Spacewalk-list
mailing list