<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#ffffff" text="#000000">
<pre wrap="">Hi Josh,
I have just now done a very fresh clean install:
1 VMWare Fedora 12
2 yum update
3 installation of spacewalk nightly (using an existing Oracle DB server on a different machine)
I still get
Starting osa-dispatcher: /usr/lib/python2.6/site-packages/jabber/jabber.py:68: DeprecationWarning: the sha module is deprecated; use the hashlib module instead
import sha, time
RHN 4682 2010/02/09 21:36:39 +02:00: ('Traceback (most recent call last):\n File "/usr/share/rhn/osad/jabber_lib.py", line 254, in setup_connection\n c = self._get_jabber_client(js)\n File "/usr/share/rhn/osad/jabber_lib.py", line 311, in _get_jabber_client\n c.connect()\n File "/usr/share/rhn/osad/jabber_lib.py", line 577, in connect\n jabber.Client.connect(self)\n File "/usr/lib/python2.6/site-packages/jabber/xmlstream.py", line 464, in connect\n else: self._sock.connect((self._hostIP, self._port))\n File "<string>", line 1, in connect\nerror: [Errno 111] Connection refused\n',)
Now I am testing around a bit:
telnet spacewalk 5222 -> Connection Successful
netstat -ptnl -> c2s is listening on 5222 IPv4
<font>db_verify authreg.db sm.db ; echo $? -> 0
</font><font>xmllint --noout /etc/jabberd/*.xml -> no error
</font>/etc/rhn/rhn.conf looks ok
Some log extracts which might mean something:
osa-dispatcher.log
2010/02/09 21:01:17 +02:00 4701 0.0.0.0: rhnSQL/driver_cx_Oracle.connect('Connecting to database', 'XE')
2010/02/09 21:01:17 +02:00 4701 0.0.0.0: osad/jabber_lib.__init__
2010/02/09 21:01:17 +02:00 4701 0.0.0.0: osad/jabber_lib.print_message('socket error',)
2010/02/09 21:01:17 +02:00 4701 0.0.0.0: osad/jabber_lib.print_message('Could not connect to jabber server', 'spacewalk.domain.com')
messages log on /usr/sbin/rhn-satellite stop
Feb 9 21:49:51 spacewalk jabberd/c2s[7024]: connection to router closed
Feb 9 21:49:51 spacewalk jabberd/c2s[7024]: attempting reconnect (3 left)
Feb 9 21:49:51 spacewalk jabberd/sm[7001]: connection to router closed
Feb 9 21:49:51 spacewalk jabberd/sm[7001]: attempting reconnect (3 left)
Feb 9 21:49:51 spacewalk jabberd/s2s[7047]: connection to router closed
Feb 9 21:49:51 spacewalk jabberd/s2s[7047]: attempting reconnect (3 left)
Feb 9 21:49:52 spacewalk jabberd/sm[7001]: attempting connection to router at 127.0.0.1, port=5347
Feb 9 21:49:52 spacewalk jabberd/sm[7001]: shutting down
Feb 9 21:49:53 spacewalk jabberd/c2s[7024]: attempting connection to router at 127.0.0.1, port=5347
Feb 9 21:49:53 spacewalk jabberd/c2s[7024]: [5] [router] write error: Connection refused (111)
Feb 9 21:49:53 spacewalk jabberd/c2s[7024]: connection to router closed
Feb 9 21:49:53 spacewalk jabberd/c2s[7024]: attempting reconnect (2 left)
Feb 9 21:49:53 spacewalk jabberd/s2s[7047]: attempting connection to router at 127.0.0.1, port=5347
Feb 9 21:49:53 spacewalk jabberd/s2s[7047]: [6] [router] write error: Connection refused (111)
Feb 9 21:49:53 spacewalk jabberd/s2s[7047]: connection to router closed
Feb 9 21:49:53 spacewalk jabberd/s2s[7047]: attempting reconnect (2 left)
Feb 9 21:49:53 spacewalk jabberd/c2s[7024]: attempting connection to router at 127.0.0.1, port=5347
Feb 9 21:49:53 spacewalk jabberd/c2s[7024]: shutting down
Feb 9 21:49:54 spacewalk jabberd/s2s[7047]: attempting connection to router at 127.0.0.1, port=5347
Feb 9 21:49:54 spacewalk jabberd/s2s[7047]: shutting down
Feb 9 21:49:54 spacewalk jabberd/s2s[7047]: connection to router closed
the start only shows successes in the messages log.
I keep getting these errors via email. Are they of any concern?
com.redhat.rhn.common.hibernate.HibernateRuntimeException: HibernateException executing CachedStatement
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:280)
at com.redhat.rhn.common.db.datasource.SelectMode.execute(SelectMode.java:105)
at com.redhat.rhn.taskomatic.task.repomd.ChannelRepodataDriver.getCandidates(ChannelRepodataDriver.java:86)
at com.redhat.rhn.taskomatic.task.threaded.TaskQueue.run(TaskQueue.java:106)
at com.redhat.rhn.taskomatic.task.ChannelRepodata.execute(ChannelRepodata.java:58)
at com.redhat.rhn.taskomatic.task.SingleThreadedTestableTask.execute(SingleThreadedTestableTask.java:54)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
Caused by: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0;
expected: 1
at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:61)
at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:46)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:24)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2520)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2697)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:74)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:146)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at com.redhat.rhn.common.db.datasource.CachedStatement.stealConnection(CachedStatement.java:853)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:441)
... 11 more
Is there a way I can initiate and test the connections manually and manually simulate the behaviour?
</pre>
</body>
</html>