Ah yes, I fixed this for spacewalk 0.3..if you already have the git repo
checked out you should have the fix for this. If not, Jus apply the
following patch on your spacewalk server:
$ diff -u /usr/share/rhn/server/importlib/backend.py.old
/usr/share/rhn/server/importlib/backend.py
--- /usr/share/rhn/server/importlib/backend.py.old 2008-10-17
11:00:16.000000000 -0400
+++ /usr/share/rhn/server/importlib/backend.py 2008-10-17
11:00:30.000000000 -0400
@@ -270,7 +270,7 @@
"""
h = self.dbmodule.prepare(_query_org_family)
- h.execute(org_id =family['label'])
+ h.execute(label =family['label'])
row = h.fetchone_dict()
if row:
return
That should fix your issue.
Thanks,
~ Prad
[EMAIL PROTECTED] wrote:
Hi There
It is spacewalk 0.2. In meantime I have rebuild the server on real
hardware instead of VMWARE. Performance now is very good. I am able to
sync actual channels, but not cloned channels. frozen is a cloned
channel.
/var/log/rhn/rhn_server_satellite.log
2008/10/16 19:18:48 +13:00 RHN Entitlement Certificate sync complete
2008/10/16 19:18:48 +13:00
2008/10/16 19:18:48 +13:00 Retrieving / parsing arches data
2008/10/16 19:18:48 +13:00 arches data complete
2008/10/16 19:18:48 +13:00
2008/10/16 19:18:48 +13:00 Retrieving / parsing additional arches data
2008/10/16 19:18:48 +13:00 additional arches data complete
2008/10/16 19:18:48 +13:00
2008/10/16 19:18:48 +13:00 Retrieving / parsing channel data
2008/10/16 19:18:49 +13:00 p = previously imported/synced channel
2008/10/16 19:18:49 +13:00 . = channel not yet imported/synced
2008/10/16 19:18:49 +13:00 base-channels:
2008/10/16 19:18:49 +13:00 . frozen-080608-rhel-s390x-server-5
4675
2008/10/16 19:18:49 +13:00
2008/10/16 19:18:49 +13:00
SYNC ERROR: unhandled exception occurred:
Exception reported from wgplsat01.nz.thenational.com
Time: Thu Oct 16 19:18:49 2008
Exception type server.rhnSQL.sql_base.SQLError
Exception Handler Information
Traceback (most recent call last):
File "/usr/bin/satellite-sync", line 142, in main
return satsync.Runner().main()
File "/usr/share/rhn/satellite_tools/satsync.py", line 206, in main
ret = method()
File "/usr/share/rhn/satellite_tools/satsync.py", line 279, in
_step_channels
self.syncer.process_channels()
File "/usr/share/rhn/satellite_tools/satsync.py", line 611, in
process_channels
sync_handlers.import_channels(requested_channels)
File "/usr/share/rhn/satellite_tools/sync_handlers.py", line 199, in
import_channels
importer.run()
File "/usr/share/rhn/server/importlib/importLib.py", line 628, in run
self.fix()
File "/usr/share/rhn/server/importlib/channelImport.py", line 59, in
fix
self.__postprocessChannel(channel)
File "/usr/share/rhn/server/importlib/channelImport.py", line 81, in
__postprocessChannel
self.backend.lookupOrgFamily(family, channel['org_id'])
File "/usr/share/rhn/server/importlib/backend.py", line 273, in
lookupOrgFamily
h.execute(org_id=family['label'])
File "/usr/share/rhn/server/rhnSQL/int_oracle.py", line 112, in execute
return apply(self._execute_wrapper, (self._execute, ) + p, kw)
File "/usr/share/rhn/server/rhnSQL/int_oracle.py", line 155, in
_execute_wrapper
retval = apply(function, p, kw)
File "/usr/share/rhn/server/rhnSQL/int_oracle.py", line 251, in
_execute
return self._execute_(args, kwargs)
File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 101,
in _execute_
'Not all variables bound', k)
SQLError: (1008, 'Not all variables bound', 'LABEL')
*Andy Linux*
Lead Linux Engineer
UNIX Team
BNZ
DDI: 04 4746330
Mobile: 0212840435
Pradeep Kilambi <[EMAIL PROTECTED]> wrote on 15/10/2008 02:05:35 a.m.:
> Yea looks like some query is throwing an SQL exception while trying to
> execute with label param. Please look at
> /var/log/rhn/rhn_server_satellite.log and look for traceback. Attach it
> here so I can look at whats happening. Also is this in spacewalk-0.2?
>
> Thanks,
> ~ Prad
>
>
> [EMAIL PROTECTED] wrote:
> >
> > Hello There
> >
> > I am trying to import an exported channel from a satellite server
> > (5.1) and when I run the satellite-sync on the spacewalk server I get
> > the following error and I don't get any emails either. Goolging it
> > looks like some oracle error.
> >
> > /usr/bin/satellite-sync -m . -c frozen-080608-rhel-s390x-server-5
> >
> >
> > 13:56:03 Red Hat Network Satellite - file-system synchronization
> > 13:56:03 mp:
> > /var/satellite/rhn-sat-import/frozen-080608-rhel-s390x-server-5
> > 13:56:03 db: spacewalk/<password>@xe
> > 13:56:03
> > 13:56:03 Retrieving / parsing channel-families data
> > 13:56:04 channel-families data complete
> > 13:56:04
> > 13:56:04 Retrieving / parsing arches data
> > 13:56:05 arches data complete
> > 13:56:05
> > 13:56:05 Retrieving / parsing additional arches data
> > 13:56:05 additional arches data complete
> > 13:56:05
> > 13:56:05 Retrieving / parsing channel data
> > 13:56:05 p = previously imported/synced channel
> > 13:56:05 . = channel not yet imported/synced
> > 13:56:05 base-channels:
> > 13:56:05 . frozen-080608-rhel-s390x-server-5 4675
> > 13:56:05
> > +++ sending log as an email +++
> >
> > SYNC ERROR: unhandled exception occurred:
> >
> > (Check logs/email for potentially more detail)
> >
> > (1008, 'Not all variables bound', 'LABEL')
> >
> >
> > *Andy Linux*
> > Lead Linux Engineer
> > UNIX Team
> > BNZ
> >
> > DDI: 04 4746330
> > Mobile: 0212840435
> > CAUTION - This message may contain privileged and confidential
information
> > intended only for the use of the addressee named above. If you are
not the
> > intended recipient of this message you are hereby notified that
any use,
> > dissemination, distribution or reproduction of this message is
prohibited.
> > This email was sent by the Bank of New Zealand. You can contact us on
> > 0800 ASK BNZ (0800 275 269). Any views expressed in this message
are those
> > of the individual sender and may not necessarily reflect the views
of Bank
> > of New Zealand.
> >
> >
------------------------------------------------------------------------
> >
> > _______________________________________________
> > Spacewalk-list mailing list
> > [email protected]
> > https://www.redhat.com/mailman/listinfo/spacewalk-list
>
CAUTION - This message may contain privileged and confidential information
intended only for the use of the addressee named above. If you are not the
intended recipient of this message you are hereby notified that any use,
dissemination, distribution or reproduction of this message is prohibited.
This email was sent by the Bank of New Zealand. You can contact us on
0800 ASK BNZ (0800 275 269). Any views expressed in this message are those
of the individual sender and may not necessarily reflect the views of Bank
of New Zealand.
--
--
Pradeep Kilambi
RHN Satellite Engineering
[EMAIL PROTECTED]
Phone: +1 919 754 4285
RHCE # 805008680430554
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
