[Spacewalk-list] satellite sync problem
Pradeep Kilambi
pkilambi at redhat.com
Fri Oct 17 15:02:25 UTC 2008
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
Andy_Hamberger at bnz.co.nz 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 <pkilambi at redhat.com> 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
> >
> >
> > Andy_Hamberger at bnz.co.nz 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
> > > Spacewalk-list at redhat.com
> > > 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
pkilambi at redhat.com
Phone: +1 919 754 4285
RHCE # 805008680430554
More information about the Spacewalk-list
mailing list