[Spacewalk-list] satellite sync problem
Andy_Hamberger at bnz.co.nz
Andy_Hamberger at bnz.co.nz
Sat Oct 18 02:57:12 UTC 2008
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
Pradeep Kilambi <pkilambi at 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 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
>
>
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20081018/caaacbb8/attachment.htm>
More information about the Spacewalk-list
mailing list