[Spacewalk-list] spacewalk v1.5 startup error -- ORA-01882

Mon Sep 19 23:34:45 UTC 2011

> On Sun, Sep 18, 2011 at 08:53:23PM +0100, Imran Javeed wrote:
> ?
> All dependencies were eventually satisfied by YUM, i just had to download them
> manually.. ?

> You should not need to if you setup the yum repositories as described
> athttps://fedorahosted.org/spacewalk/wiki/HowToInstall. If you
> followed the instructions and you still had to download some packages
> manually, we'd love to hear the details so that we can fix the world
> for other users.

I did follow the instructions, Yum complained of the following which were
downloaded manually

The manual downloads were

compat-libstdc++-33-3.2.3-69.el6.i686.rpm
libntlm-1.0-3.el6.i686.rpm
perl-Class-Inspector-1.24-1.el6.rfx.noarch.rpm
perl-Class-Singleton-1.4-1.el6.rfx.noarch.rpm
perl-DateTime-0.5300-2.el6.rfx.i686.rpm
perl-DateTime-Format-Builder-0.7901-1.el6.rf.noarch.rpm
perl-DateTime-Format-DateParse-0.04-1.el6.rfx.noarch.rpm
perl-DateTime-Locale-0.45-1.el5.rf.noarch.rpm
perl-DateTime-TimeZone-1.08-1.el5.rf.noarch.rpm
perl-FCGI-0.68-1.el6.rf.i686.rpm
perl-IO-Socket-SSL-1.44-1.el6.rfx.noarch.rpm
perl-IO-stringy-2.110-1.2.el6.rfx.noarch.rpm
perl-List-MoreUtils-0.25.2-1.el6.test.i686.rpm
perl-MailTools-2.08-1.el6.rfx.noarch.rpm
perl-MIME-tools-5.502-2.el6.rfx.noarch.rpm
perl-Net-SSLeay-1.36-1.el6.rfx.i686.rpm
perl-Params-Validate-0.95-1.el6.rfx.i686.rpm
perl-SOAP-Lite-0.712-3.el6.rfx.noarch.rpm
perl-Task-Weaken-1.03-1.el6.rfx.noarch.rpm
perl-Test-1.25-1.el5.rf.noarch.rpm
perl-Test-Pod-1.45-1.el6.rfx.noarch.rpm
perl-TimeDate-1.20-1.el6.rfx.noarch.rpm

Imran 

On 19 September 2011 at 17:00 spacewalk-list-request at redhat.com wrote:

> Send Spacewalk-list mailing list submissions to
>         spacewalk-list at redhat.com
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         https://www.redhat.com/mailman/listinfo/spacewalk-list
> or, via email, send a message with subject or body 'help' to
>         spacewalk-list-request at redhat.com
>
> You can reach the person managing the list at
>         spacewalk-list-owner at redhat.com
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Spacewalk-list digest..."
>
>
> Today's Topics:
>
>    1. Re: spacewalk v1.5 startup error -- >  ORA-01882 (Imran Javeed)
>    2. FINAL: Re:spacewalk v1.5 startup error -- >        ORA-01882
>       (Imran Javeed)
>    3. Re: spacewalk v1.5 startup error -- >  ORA-01882 (Jan Pazdziora)
>    4. Re: Wrong kernel information in System Info (Pierre Casenove)
>    5. Eror in osa-dispatcher log (Pierre Casenove)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sun, 18 Sep 2011 20:53:23 +0100 (BST)
> From: Imran Javeed <imran.javeed at snapimported.co.uk>
> To: spacewalk-list at redhat.com
> Subject: Re: [Spacewalk-list] spacewalk v1.5 startup error -- >
>         ORA-01882
> Message-ID:
>       
> <365422724.17527.1316375603939.JavaMail.open-xchange at oxltgw16.schlund.de>
>         
> Content-Type: text/plain; charset=UTF-8
>
> > > Hello
> > > ?
> > > I have just installed Spacewalk 1.5 on RHEL6, installation was OK bar a
> > > few
> > > perl
> > > modules missing which i resolved manually?
> >
> > What Perl modules were missing? There should be no failed dependencies.
> ?
> All dependencies were eventually satisfied by YUM, i just had to download them
> manually.. ?
> ?
> ?> > Sep 18, 2011 1:33:21 AM
> > > com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run
> > > WARNING: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask at 1609812
> > > --
> > > 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). Last acquisition attempt exception:
> > > java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
> > > ORA-01882: timezone region? not found
> > >
> > > ??????? at
> > > oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:759)
> >
> > What timezone do you have set on your system? What does
> >
> >? ? ? ? ?# date
> >
> ?
> [root at RHEL6-DOM tomcat6]# date
> Sun Sep 18 20:47:32 BST 2011
> [root at RHEL6-DOM tomcat6]#
> ?
> ?
> ?
> ?
> ?
> ?
> ?
> ?
> On 18 September 2011 at 17:00 spacewalk-list-request at redhat.com wrote:
>
> > Send Spacewalk-list mailing list submissions to
> >? ? ? ? ?spacewalk-list at redhat.com
> >
> > To subscribe or unsubscribe via the World Wide Web, visit
> >? ? ? ? ?https://www.redhat.com/mailman/listinfo/spacewalk-list
> > or, via email, send a message with subject or body 'help' to
> >? ? ? ? ?spacewalk-list-request at redhat.com
> >
> > You can reach the person managing the list at
> >? ? ? ? ?spacewalk-list-owner at redhat.com
> >
> > When replying, please edit your Subject line so it is more specific
> > than "Re: Contents of Spacewalk-list digest..."
> >
> >
> > Today's Topics:
> >
> >? ? 1. Re: spacewalk v1.5 startup error -- ORA-01882 (Jan Pazdziora)
> >
> >
> > ----------------------------------------------------------------------
> >
> > Message: 1
> > Date: Sun, 18 Sep 2011 15:50:08 +0200
> > From: Jan Pazdziora <jpazdziora at redhat.com>
> > To: spacewalk-list at redhat.com
> > Subject: Re: [Spacewalk-list] spacewalk v1.5 startup error --
> >? ? ? ? ?ORA-01882
> > Message-ID: <20110918135008.GA20920 at redhat.com>
> > Content-Type: text/plain; charset=iso-8859-1
> >
> > On Sun, Sep 18, 2011 at 01:46:00AM +0100, Imran Javeed wrote:
> > > Hello
> > > ?
> > > I have just installed Spacewalk 1.5 on RHEL6, installation was OK bar a
> > > few
> > > perl
> > > modules missing which i resolved manually?
> >
> > What Perl modules were missing? There should be no failed dependencies.
> >
> > > I have now started the spacewalk server & have received the following
> > > error
> > > ?
> > > Can anyone please help?
> >
> > > Sep 18, 2011 1:33:21 AM
> > > com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run
> > > WARNING: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask at 1609812
> > > --
> > > 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). Last acquisition attempt exception:
> > > java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
> > > ORA-01882: timezone region? not found
> > >
> > > ??????? at
> > > oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:759)
> >
> > What timezone do you have set on your system? What does
> >
> >? ? ? ? ?# date
> >
> > command return?
> >
> > --
> > Jan Pazdziora
> > Principal Software Engineer, Satellite Engineering, Red Hat
> >
> >
> >
> > ------------------------------
> >
> > _______________________________________________
> > Spacewalk-list mailing list
> > Spacewalk-list at redhat.com
> > https://www.redhat.com/mailman/listinfo/spacewalk-list
> >
> > End of Spacewalk-list Digest, Vol 40, Issue 42
> > **********************************************
> Imran Javeed
> Director
> SnapImported Ltd
> Tel : +44 (0)7748 875264
> Email: imran dot javeed at snapimported dot co dot uk
>
>
>
> ------------------------------
>
> Message: 2
> Date: Mon, 19 Sep 2011 01:41:40 +0100 (BST)
> From: Imran Javeed <imran.javeed at snapimported.co.uk>
> To: spacewalk-list at redhat.com
> Subject: [Spacewalk-list] FINAL: Re:spacewalk v1.5 startup error -- >
>         ORA-01882
> Message-ID:
>       
> <149472063.180115.1316392900650.JavaMail.open-xchange at oxltgw00.schlund.de>
>         
> Content-Type: text/plain; charset=UTF-8
>
>
>
>
> On 18 September 2011 at 20:53 Imran Javeed <imran.javeed at snapimported.co.uk>
> wrote:
>
> > > > Hello
> > > > ?
> > > > I have just installed Spacewalk 1.5 on RHEL6, installation was OK bar a
> > > > few
> > > > perl
> > > > modules missing which i resolved manually?
> > >
> > > What Perl modules were missing? There should be no failed dependencies.
> > ?
> > All dependencies were eventually satisfied by YUM, i just had to download
> > them
> ?
> ?
> After reading many unrelated forums on similar issues i added
> ?
> -Duser.timezone=Europe/London
> ?
> to the JAVA_OPTS within /etc/tomcat6/tomcat6.conf
> ?
> This is now resolved & spacewalk is now working as expected?
> ?
> ?
> Imran
> ?
> ?
> ?
> ?
> ?
> ?
> > manually.. ?
> > ?
> > ?> > Sep 18, 2011 1:33:21 AM
> > > > com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run
> > > > WARNING:
> > > > com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask at 1609812
> > > > --
> > > > 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). Last acquisition attempt exception:
> > > > java.sql.SQLException: ORA-00604: error occurred at recursive SQL level
> > > > 1
> > > > ORA-01882: timezone region? not found
> > > >
> > > > ??????? at
> > > > oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:759)
> > >
> > > What timezone do you have set on your system? What does
> > >
> > >? ? ? ? ?# date
> > >
> > ?
> > [root at RHEL6-DOM tomcat6]# date
> > Sun Sep 18 20:47:32 BST 2011
> > [root at RHEL6-DOM tomcat6]#
> > ?
> > ?
> > ?
> > ?
> > ?
> > ?
> > ?
> > ?
> > On 18 September 2011 at 17:00 spacewalk-list-request at redhat.com wrote:
> >
> > > Send Spacewalk-list mailing list submissions to
> > >? ? ? ? ?spacewalk-list at redhat.com
> > >
> > > To subscribe or unsubscribe via the World Wide Web, visit
> > >? ? ? ? ?https://www.redhat.com/mailman/listinfo/spacewalk-list
> > > or, via email, send a message with subject or body 'help' to
> > >? ? ? ? ?spacewalk-list-request at redhat.com
> > >
> > > You can reach the person managing the list at
> > >? ? ? ? ?spacewalk-list-owner at redhat.com
> > >
> > > When replying, please edit your Subject line so it is more specific
> > > than "Re: Contents of Spacewalk-list digest..."
> > >
> > >
> > > Today's Topics:
> > >
> > >? ? 1. Re: spacewalk v1.5 startup error -- ORA-01882 (Jan Pazdziora)
> > >
> > >
> > > ----------------------------------------------------------------------
> > >
> > > Message: 1
> > > Date: Sun, 18 Sep 2011 15:50:08 +0200
> > > From: Jan Pazdziora <jpazdziora at redhat.com>
> > > To: spacewalk-list at redhat.com
> > > Subject: Re: [Spacewalk-list] spacewalk v1.5 startup error --
> > >? ? ? ? ?ORA-01882
> > > Message-ID: <20110918135008.GA20920 at redhat.com>
> > > Content-Type: text/plain; charset=iso-8859-1
> > >
> > > On Sun, Sep 18, 2011 at 01:46:00AM +0100, Imran Javeed wrote:
> > > > Hello
> > > > ?
> > > > I have just installed Spacewalk 1.5 on RHEL6, installation was OK bar a
> > > > few
> > > > perl
> > > > modules missing which i resolved manually?
> > >
> > > What Perl modules were missing? There should be no failed dependencies.
> > >
> > > > I have now started the spacewalk server & have received the following
> > > > error
> > > > ?
> > > > Can anyone please help?
> > >
> > > > Sep 18, 2011 1:33:21 AM
> > > > com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run
> > > > WARNING:
> > > > com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask at 1609812
> > > > --
> > > > 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). Last acquisition attempt exception:
> > > > java.sql.SQLException: ORA-00604: error occurred at recursive SQL level
> > > > 1
> > > > ORA-01882: timezone region? not found
> > > >
> > > > ??????? at
> > > > oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:759)
> > >
> > > What timezone do you have set on your system? What does
> > >
> > >? ? ? ? ?# date
> > >
> > > command return?
> > >
> > > --
> > > Jan Pazdziora
> > > Principal Software Engineer, Satellite Engineering, Red Hat
> > >
> > >
> > >
> > > ------------------------------
> > >
> > > _______________________________________________
> > > Spacewalk-list mailing list
> > > Spacewalk-list at redhat.com
> > > https://www.redhat.com/mailman/listinfo/spacewalk-list
> > >
> > > End of Spacewalk-list Digest, Vol 40, Issue 42
> > > **********************************************
> > Imran Javeed
> > Director
> > SnapImported Ltd
> > Tel : +44 (0)7748 875264
> > Email: imran dot javeed at snapimported dot co dot uk
> Imran Javeed
> Director
> SnapImported Ltd
> Tel : +44 (0)7748 875264
> Email: imran dot javeed at snapimported dot co dot uk
>
>
>
> ------------------------------
>
> Message: 3
> Date: Mon, 19 Sep 2011 08:46:54 +0200
> From: Jan Pazdziora <jpazdziora at redhat.com>
> To: spacewalk-list at redhat.com
> Subject: Re: [Spacewalk-list] spacewalk v1.5 startup error -- >
>         ORA-01882
> Message-ID: <20110919064654.GA17790 at redhat.com>
> Content-Type: text/plain; charset=iso-8859-1
>
> On Sun, Sep 18, 2011 at 08:53:23PM +0100, Imran Javeed wrote:
> > ?
> > All dependencies were eventually satisfied by YUM, i just had to download
> > them
> > manually.. ?
>
> You should not need to if you setup the yum repositories as described
> at https://fedorahosted.org/spacewalk/wiki/HowToInstall. If you
> followed the instructions and you still had to download some packages
> manually, we'd love to hear the details so that we can fix the world
> for other users.
>
> > [root at RHEL6-DOM tomcat6]# date
> > Sun Sep 18 20:47:32 BST 2011
> > [root at RHEL6-DOM tomcat6]#
>
> I assume Oracle does not like the BST timezone. Can you use something
> which would be semantially equivalent?
>
> --
> Jan Pazdziora
> Principal Software Engineer, Satellite Engineering, Red Hat
>
>
>
> ------------------------------
>
> Message: 4
> Date: Mon, 19 Sep 2011 11:24:53 +0200
> From: Pierre Casenove <pcasenove at gmail.com>
> To: spacewalk-list at redhat.com
> Subject: Re: [Spacewalk-list] Wrong kernel information in System Info
> Message-ID:
>         <CAALa77m3styQ6e2j5POqs1Z2eDA1++LjhKtjdiLEK3kyPCia4Q at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hello,
> Could someone tell me where and when information should be updated so that I
> can try to debug it?
>
> Thanks,
>
> Pierre
>
> 2011/9/16 Pierre Casenove <pcasenove at gmail.com>
>
> > hello list,
> > Now that I can correctly see needed updates for the clients, I've noticed
> > another thing: the kernel version information in Systems--> <Client> -->
> > Overview --> System Info is never refreshed.
> > I registered a client with kernel version 2.6.18-238.el5.
> > I've upgraded the kernel of this client from spacewalk to version
> > 2.6.18-274 and then removed the old kernel.
> > But the version printed on System Info is still 2.6.18-238. I've ran a
> > rhn_check and a rhn-profile-sync on the client, still no luck.
> >
> > Coud you please tell me how this field is updated? I think that the query
> > is broken for postgresql, but I don't konw hos spacewalk updates this
> > information, so it is not easy to debug this.
> >
> > Thanks in advance for you help,
> >
> > Pierre
> >
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> <https://www.redhat.com/archives/spacewalk-list/attachments/20110919/675a2447/attachment.html>
>
> ------------------------------
>
> Message: 5
> Date: Mon, 19 Sep 2011 12:16:09 +0200
> From: Pierre Casenove <pcasenove at gmail.com>
> To: spacewalk-list at redhat.com
> Subject: [Spacewalk-list] Eror in osa-dispatcher log
> Message-ID:
>         <CAALa77mE35Yjm4tauhYC63CGDh6=wwy=M-NEVnnhM0TjLfZsVA at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hello,
> I have an error message in osa-dispatcher.log on my spacewalk 1/5 on
> postgresql install
> 2011/09/19 08:52:46 -00:00 6294 0.0.0.0: osad/jabber_lib.main('ERROR',
> 'Traceback (most recent call last):\n  File
> "/usr/share/rhn/osad/jabber_lib.py", line 115, in main\n
>  self.setup_config(config)\n  File "/usr/share/rhn/osad/osa_dispatcher.py",
> line 82, in setup_config\n    rhnSQL.initDB()\n  File
> "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/__init__.py", line
> 124, in initDB\n    __init__DB(backend, host, port, username, password,
> database)\n  File
> "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/__init__.py", line
> 55, in __init__DB\n    __DB.connect()\n  File
> "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
> line 163, in connect\n    return self.connect(reconnect=0)\n  File
> "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
> line 167, in connect\n    [self.database, e.pgcode, e.pgerror, "Attempting
> Re-Connect to the database failed",])\nSQLConnectError: (None, None,
> \'spaceschema\', \'Attempting Re-Connect to the database failed\')\n')
> 2011/09/19 08:52:56 -00:00 6294 0.0.0.0:
> rhnSQL/driver_postgresql.check_connection('ERROR', "DATABASE CONNECTION TO
> 'spaceschema' LOST", "Exception information: Database instance has no
> attribute 'dbh'")
>
> What could be the origin of this message?
>
> Thanks,
>
> Pierre
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> <https://www.redhat.com/archives/spacewalk-list/attachments/20110919/5d2076b1/attachment.html>
>
> ------------------------------
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
> End of Spacewalk-list Digest, Vol 40, Issue 43
> **********************************************
Imran Javeed
Director
SnapImported Ltd
Tel : +44 (0)7748 875264
Email: imran dot javeed at snapimported dot co dot uk