happy to wait for 0.3 or get the git, since I now get the following error +++ sending log as an email +++ SYNC ERROR: unhandled exception occurred: (Check logs/email for potentially more detail) (1400, 'ORA-01400: cannot insert NULL into ("SPACEWALK"."RHNCHANNELFAMILY"."NAME")\n', 'INSERT INTO rhnChannelFamily (id, name, label, org_id, product_url) VALUES (rhn_channel_family_id_seq.nextval, :name, :label, :org, :url)') Andy Linux Lead Linux Engineer UNIX Team BNZ DDI: 04 4746330 Mobile: 0212840435 <tt>Pradeep Kilambi <pkilambi@redhat.com> wrote on 18/10/2008 04:02:25 a.m.: > 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@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@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@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@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@redhat.com > Phone: +1 919 754 4285 > RHCE # 805008680430554 > > </tt><pre> 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. </pre>