[Spacewalk-list] osa-dispatcher problems. no system ever, reports

Stefan Bluhm stefanbluhm2 at alice-dsl.net
Tue Feb 9 22:06:36 UTC 2010


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
db_verify authreg.db sm.db ; echo $? ->  0
xmllint --noout /etc/jabberd/*.xml  ->  no error
/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?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20100209/8eb2165c/attachment.htm>


More information about the Spacewalk-list mailing list