[Spacewalk-list] Error looking at Security Errata in Errata menu

Fouts, Christopher Christopher.Fouts at Teradata.com
Wed May 10 14:58:03 UTC 2017


The issue was c3p0. I updated the packages on the SW server, and c3p0 happened to be one of them. I found this by restarting taskomatic and saw

# systemctl status taskomatic -l
● taskomatic.service - Taskomatic
   Loaded: loaded (/usr/lib/systemd/system/taskomatic.service; enabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Wed 2017-05-10 14:39:16 UTC; 6min ago
  Process: 4247 ExecStop=/usr/sbin/taskomatic stop (code=exited, status=0/SUCCESS)
  Process: 1769 ExecStart=/usr/sbin/taskomatic start (code=exited, status=0/SUCCESS)
Main PID: 1797 (code=exited, status=255)

May 10 14:39:11 ip-10-22-2-123 taskomatic[1769]: Starting RHN Taskomatic...
May 10 14:39:11 ip-10-22-2-123 wrapper[1797]: --> Wrapper Started as Daemon
May 10 14:39:11 ip-10-22-2-123 wrapper[1797]: Launching a JVM...
May 10 14:39:11 ip-10-22-2-123 systemd[1]: Started Taskomatic.
May 10 14:39:13 ip-10-22-2-123 wrapper[1797]: com/mchange/v2/c3p0/DataSources
                                              java.lang.NoClassDefFoundError: com/mchange/v2/c3p0/DataSources
                                                      at org.hibernate.connection.C3P0ConnectionProvider.configure(C3P0ConnectionProvider.java:154)
                                                      at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
                                                      at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
                                                      at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:414)
                                                      at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:62)
                                                      at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
                                                      at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
                                                      at com.redhat.rhn.common.hibernate.ConnectionManager.createSessionFactory(ConnectionManager.java:205)
                                                      at com.redhat.rhn.common.hibernate.ConnectionManager.initialize(ConnectionManager.java:134)
                                                      at com.redhat.rhn.common.hibernate.HibernateFactory.createSessionFactory(HibernateFactory.java:107)
                                                      at com.redhat.rhn.taskomatic.core.SchedulerKernel.startup(SchedulerKernel.java:139)
                                                      at com.redhat.rhn.taskomatic.core.TaskomaticDaemon$1.run(TaskomaticDaemon.java:86)
                                                      at java.lang.Thread.run(Thread.java:748)
                                              Caused by: java.lang.ClassNotFoundException: com.mchange.v2.c3p0.DataSources
                                                      at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
                                                      at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
                                                      at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:335)
                                                      at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
                                                      ... 13 more
May 10 14:39:16 ip-10-22-2-123 systemd[1]: taskomatic.service: main process exited, code=exited, status=255/n/a
May 10 14:39:16 ip-10-22-2-123 taskomatic[4247]: Stopping RHN Taskomatic...
May 10 14:39:16 ip-10-22-2-123 taskomatic[4247]: RHN Taskomatic was not running.
May 10 14:39:16 ip-10-22-2-123 systemd[1]: Unit taskomatic.service entered failed state.
May 10 14:39:16 ip-10-22-2-123 systemd[1]: taskomatic.service failed.



So I did…



[root at ip-10-22-2-123 init.d]# yum info c3p0
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: repo1.ash.innoscale.net
* epel: mirror.cogentco.com
* extras: mirror.cs.vt.edu
* updates: mirror.umd.edu
Installed Packages
Name        : c3p0
Arch        : noarch
Version     : 0.9.2.1
Release     : 5.el7
Size        : 270 k
Repo        : installed
From repo   : epel
Summary     : JDBC DataSources/Resource Pools
URL         : https://github.com/swaldman/c3p0
License     : LGPLv2 or EPL
Description : c3p0 is an easy-to-use library for augmenting traditional JDBC drivers with
            : JNDI-bindable DataSources, including DataSources that implement Connection
            : and Statement Pooling, as described by the jdbc3 spec and jdbc2 standard
            : extension.


…and did…



[root at ip-10-22-2-123 init.d]# yum downgrade c3p0
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: repo1.ash.innoscale.net
* epel: mirror.cogentco.com
* extras: mirror.cs.vt.edu
* updates: mirror.umd.edu
Resolving Dependencies
--> Running transaction check
---> Package c3p0.noarch 0:0.9.1.2-2.jpp5 will be a downgrade
---> Package c3p0.noarch 0:0.9.2.1-5.el7 will be erased
--> Finished Dependency Resolution

Dependencies Resolved

==============================================================================================================
Package            Arch                 Version                         Repository                      Size
==============================================================================================================
Downgrading:
c3p0               noarch               0.9.1.2-2.jpp5                  jpackage-generic               583 k

Transaction Summary
==============================================================================================================
Downgrade  1 Package

Total download size: 583 k
Is this ok [y/d/N]: y
Downloading packages:
c3p0-0.9.1.2-2.jpp5.noarch.rpm                                                         | 583 kB  00:00:01
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : c3p0-0.9.1.2-2.jpp5.noarch                                                                 1/2
  Cleanup    : c3p0-0.9.2.1-5.el7.noarch                                                                  2/2
  Verifying  : c3p0-0.9.1.2-2.jpp5.noarch                                                                 1/2
  Verifying  : c3p0-0.9.2.1-5.el7.noarch                                                                  2/2

Removed:
  c3p0.noarch 0:0.9.2.1-5.el7

Installed:
  c3p0.noarch 0:0.9.1.2-2.jpp5

Complete!
[root at ip-10-22-2-123 init.d]# yum info c3p0
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: repo1.ash.innoscale.net
* epel: mirror.cogentco.com
* extras: mirror.cs.vt.edu
* updates: mirror.umd.edu
Installed Packages
Name        : c3p0
Arch        : noarch
Version     : 0.9.1.2
Release     : 2.jpp5
Size        : 740 k
Repo        : installed
From repo   : jpackage-generic
Summary     : JDBC DataSources/Resource Pools
URL         : http://sourceforge.net/projects/c3p0/
License     : LGPLv2+
Description : c3p0 is an easy-to-use library for augmenting
            : traditional (DriverManager-based) JDBC drivers
            : with JNDI-bindable DataSources, including
            : DataSources that implement Connection and Statement
            : Pooling, as described by the jdbc3 spec and jdbc2
            : standard extension.

Available Packages
Name        : c3p0
Arch        : noarch
Version     : 0.9.2.1
Release     : 5.el7
Size        : 81 k
Repo        : epel/x86_64
Summary     : JDBC DataSources/Resource Pools
URL         : https://github.com/swaldman/c3p0
License     : LGPLv2 or EPL
Description : c3p0 is an easy-to-use library for augmenting traditional JDBC drivers with
            : JNDI-bindable DataSources, including DataSources that implement Connection
            : and Statement Pooling, as described by the jdbc3 spec and jdbc2 standard
            : extension.



Thought I’d share


Chris

From: <spacewalk-list-bounces at redhat.com> on behalf of "Fouts, Christopher" <Christopher.Fouts at Teradata.com>
Reply-To: "spacewalk-list at redhat.com" <spacewalk-list at redhat.com>
Date: Wednesday, May 10, 2017 at 10:29 AM
To: "spacewalk-list at redhat.com" <spacewalk-list at redhat.com>
Subject: Re: [Spacewalk-list] Error looking at Security Errata in Errata menu

I’m getting this error all over the place, not just when looking at errata data from the Errata menu. It seems to be at random menus. For example

-      Clicking on Admin menu

-      Clicking on Systems, pick a system, Details->(any sub-menu item)

What logs can I look at to get a clue?

Chris

From: <spacewalk-list-bounces at redhat.com> on behalf of "Fouts, Christopher" <Christopher.Fouts at Teradata.com>
Reply-To: "spacewalk-list at redhat.com" <spacewalk-list at redhat.com>
Date: Tuesday, May 9, 2017 at 4:48 PM
To: "spacewalk-list at redhat.com" <spacewalk-list at redhat.com>
Subject: [Spacewalk-list] Error looking at Security Errata in Errata menu

Spacewalk v2.6

I click on Errata tab, and see the errata files as expected, All Errata tab shows all errata, Bug Fix Errata tab shows bug fix errata, and Enhancement Errata tab shows enhancements errata However, when I click on the Security Errata tab, I get the following. Why is this so?

Internal Server Error
The server experienced a problem which prevented your request from being filled out. It may not be possible to execute this action at this time.
Please help us correct this problem by contacting us with details of how you received this message

Thanks,
Chris

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20170510/6e951e12/attachment.htm>


More information about the Spacewalk-list mailing list