[Spacewalk-list] Cannot sync confluent (debian) repository to Spacewalk repo

Ihor Lawrin ILawrin at deltadentalmi.com
Thu Feb 7 13:26:03 UTC 2019


I ran my sync with high verbosity hoping that someone can help with my sync failure...

2019/02/07 08:20:45 -04:00 Command: ['/usr/bin/spacewalk-repo-sync', '-vvvvvv', '--channel', 'confluent-ubuntu-amd64']
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql.convert_named_query_params('Converting query for PostgreSQL: \n           select s.source_url, c.label\n                       from rhnContentSource s,\n                       rhnChannelContentSource cs,\n                       rhnChannel c\n                       where s.id = cs.source_id and cs.channel_id=c.id\n           ',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql.convert_named_query_params('New query: \n           select s.source_url, c.label\n                       from rhnContentSource s,\n                       rhnChannelContentSource cs,\n                       rhnChannel c\n                       where s.id = cs.source_id and cs.channel_id=c.id\n           ',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "\n           select s.source_url, c.label\n                       from rhnContentSource s,\n                       rhnChannelContentSource cs,\n                       rhnChannel c\n                       where s.id = cs.source_id and cs.channel_id=c.id\n           " with bind params: {}',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql.convert_named_query_params('Converting query for PostgreSQL: select 1',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql.convert_named_query_params('New query: select 1',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "select 1" with bind params: {}',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql.convert_named_query_params('Converting query for PostgreSQL: \n        select c1.label, c2.label parent_channel, c1.id\n        from rhnChannel c1 left outer join rhnChannel c2 on c1.parent_channel = c2.id\n        order by c2.label desc, c1.label asc\n    ',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql.convert_named_query_params('New query: \n        select c1.label, c2.label parent_channel, c1.id\n        from rhnChannel c1 left outer join rhnChannel c2 on c1.parent_channel = c2.id\n        order by c2.label desc, c1.label asc\n    ',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "\n        select c1.label, c2.label parent_channel, c1.id\n        from rhnChannel c1 left outer join rhnChannel c2 on c1.parent_channel = c2.id\n        order by c2.label desc, c1.label asc\n    " with bind params: {}',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: server/rhnChannel.isCustomChannel(104,)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql.convert_named_query_params('Converting query for PostgreSQL: \n    select\n        rcf.label\n    from\n        rhnChannelFamily rcf,\n        rhnChannelFamilyMembers rcfm\n    where\n        rcfm.channel_id = :channel_id\n        and rcfm.channel_family_id = rcf.id\n        and rcf.org_id is not null\n    ',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql.convert_named_query_params('New query: \n    select\n        rcf.label\n    from\n        rhnChannelFamily rcf,\n        rhnChannelFamilyMembers rcfm\n    where\n        rcfm.channel_id = %(channel_id)s\n        and rcfm.channel_family_id = rcf.id\n        and rcf.org_id is not null\n    ',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "\n    select\n        rcf.label\n    from\n        rhnChannelFamily rcf,\n        rhnChannelFamilyMembers rcfm\n    where\n        rcfm.channel_id = %(channel_id)s\n        and rcfm.channel_family_id = rcf.id\n        and rcf.org_id is not null\n    " with bind params: {channel_id: 104}',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: server/rhnChannel.isCustomChannel(104, 'is a custom channel')
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: server/rhnChannel.isCustomChannel(101,)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql.convert_named_query_params('Converting query for PostgreSQL: \n    select\n        rcf.label\n    from\n        rhnChannelFamily rcf,\n        rhnChannelFamilyMembers rcfm\n    where\n        rcfm.channel_id = :channel_id\n        and rcfm.channel_family_id = rcf.id\n        and rcf.org_id is not null\n    ',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql.convert_named_query_params('New query: \n    select\n        rcf.label\n    from\n        rhnChannelFamily rcf,\n        rhnChannelFamilyMembers rcfm\n    where\n        rcfm.channel_id = %(channel_id)s\n        and rcfm.channel_family_id = rcf.id\n        and rcf.org_id is not null\n    ',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "\n    select\n        rcf.label\n    from\n        rhnChannelFamily rcf,\n        rhnChannelFamilyMembers rcfm\n    where\n        rcfm.channel_id = %(channel_id)s\n        and rcfm.channel_family_id = rcf.id\n        and rcf.org_id is not null\n    " with bind params: {channel_id: 101}',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: server/rhnChannel.isCustomChannel(101, 'is a custom channel')
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: server/rhnChannel.isCustomChannel(103,)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql.convert_named_query_params('Converting query for PostgreSQL: \n    select\n        rcf.label\n    from\n        rhnChannelFamily rcf,\n        rhnChannelFamilyMembers rcfm\n    where\n        rcfm.channel_id = :channel_id\n        and rcfm.channel_family_id = rcf.id\n        and rcf.org_id is not null\n    ',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql.convert_named_query_params('New query: \n    select\n        rcf.label\n    from\n        rhnChannelFamily rcf,\n        rhnChannelFamilyMembers rcfm\n    where\n        rcfm.channel_id = %(channel_id)s\n        and rcfm.channel_family_id = rcf.id\n        and rcf.org_id is not null\n    ',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "\n    select\n        rcf.label\n    from\n        rhnChannelFamily rcf,\n        rhnChannelFamilyMembers rcfm\n    where\n        rcfm.channel_id = %(channel_id)s\n        and rcfm.channel_family_id = rcf.id\n        and rcf.org_id is not null\n    " with bind params: {channel_id: 103}',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: server/rhnChannel.isCustomChannel(103, 'is a custom channel')
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: server/rhnChannel.isCustomChannel(102,)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql.convert_named_query_params('Converting query for PostgreSQL: \n    select\n        rcf.label\n    from\n        rhnChannelFamily rcf,\n        rhnChannelFamilyMembers rcfm\n    where\n        rcfm.channel_id = :channel_id\n        and rcfm.channel_family_id = rcf.id\n        and rcf.org_id is not null\n    ',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql.convert_named_query_params('New query: \n    select\n        rcf.label\n    from\n        rhnChannelFamily rcf,\n        rhnChannelFamilyMembers rcfm\n    where\n        rcfm.channel_id = %(channel_id)s\n        and rcfm.channel_family_id = rcf.id\n        and rcf.org_id is not null\n    ',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "\n    select\n        rcf.label\n    from\n        rhnChannelFamily rcf,\n        rhnChannelFamilyMembers rcfm\n    where\n        rcfm.channel_id = %(channel_id)s\n        and rcfm.channel_family_id = rcf.id\n        and rcf.org_id is not null\n    " with bind params: {channel_id: 102}',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: server/rhnChannel.isCustomChannel(102, 'is a custom channel')
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql.convert_named_query_params('Converting query for PostgreSQL: select 1',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql.convert_named_query_params('New query: select 1',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "select 1" with bind params: {}',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql.convert_named_query_params('Converting query for PostgreSQL: \n        select c1.label, c2.label parent_channel, c1.id\n        from rhnChannel c1 left outer join rhnChannel c2 on c1.parent_channel = c2.id\n        order by c2.label desc, c1.label asc\n    ',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql.convert_named_query_params('New query: \n        select c1.label, c2.label parent_channel, c1.id\n        from rhnChannel c1 left outer join rhnChannel c2 on c1.parent_channel = c2.id\n        order by c2.label desc, c1.label asc\n    ',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "\n        select c1.label, c2.label parent_channel, c1.id\n        from rhnChannel c1 left outer join rhnChannel c2 on c1.parent_channel = c2.id\n        order by c2.label desc, c1.label asc\n    " with bind params: {}',)
2019/02/07 08:20:45 -04:00 ======================================
2019/02/07 08:20:45 -04:00 | Channel: confluent-ubuntu-amd64
2019/02/07 08:20:45 -04:00 ======================================
2019/02/07 08:20:45 -04:00 Sync of channel started.
                           Please check 'reposync/confluent-ubuntu-amd64.log' for sync log of this channel.
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql.convert_named_query_params('Converting query for PostgreSQL: select 1',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql.convert_named_query_params('New query: select 1',)
2019/02/07 08:20:45 -04:00 1817 0.0.0.0: rhnSQL/driver_postgresql._execute_wrapper('Executing SQL: "select 1" with bind params: {}',)
2019/02/07 08:20:46 -04:00 Sync of channel completed.
2019/02/07 08:20:46 -04:00 Total time: 0:00:00

Ihor Lawrin
Technical Services
Senior System Administrator (UNIX)
Delta Dental of Michigan, Ohio, and Indiana
(517) 381-4207 Direct Line
(517) 648-7312 Cell

[cid:2BF1C32F-CF05-469B-B08B-26DA6BF62BA0]
ISO 9001 Quality Certified  *  Certified Call Center of Excellence  *  Rated A (Excellent) by A.M. Best Company


From: Ihor Lawrin
Sent: Monday, January 28, 2019 4:18 PM
To: 'spacewalk-list at redhat.com' <spacewalk-list at redhat.com>
Subject: Cannot sync confluent (debian) repository to Spacewalk repo


[https://secure.gravatar.com/avatar/3fdaab3ce23a4db0a6d7f0bbb52e48cd?size=40&default=https%3A%2F%2Fassets.zendesk.com%2Fimages%2F2016%2Fdefault-avatar-80.png&r=g]

Michael Jorgensen
Jan 25, 20:45 GMT
We are trying to create a confluent Ubuntu repository on Spacewalk. We get the following error when trying to sync from the Confluent  site:

root at clokvadm01.ddmi.intra.renhsc.com<mailto:root at clokvadm01.ddmi.intra.renhsc.com> [/var/log]
$ /usr/bin/spacewalk-repo-sync -c confluent-ubuntu-amd64 -u https://packages.confluent.io/deb/5.1<https://urldefense.proofpoint.com/v2/url?u=https-3A__packages.confluent.io_deb_5.1&d=DwMFaQ&c=Jnf2Cp4PGnCPtuPxt-OIQR21MChqGaHuqvEjP9X2AA0&r=nH4RHOYxjoHu7_fk_jY-Is7EuK8LvOMsN1m668gkv40&m=3aiBmv4Gx92nve264fDYVfsmd8gK4Ew_PtC9G0ei8vs&s=rI0jlZK51At4ydhVR3Ri4wP2UZvT9V1PDVTWBr4x92M&e=> -t deb
15:40:06 ======================================
15:40:06 | Channel: confluent-ubuntu-amd64
15:40:06 ======================================
15:40:06 Sync of channel started.
15:40:08
15:40:08 Processing repository with URL: https://packages.confluent.io/deb/5.1<https://urldefense.proofpoint.com/v2/url?u=https-3A__packages.confluent.io_deb_5.1&d=DwMFaQ&c=Jnf2Cp4PGnCPtuPxt-OIQR21MChqGaHuqvEjP9X2AA0&r=nH4RHOYxjoHu7_fk_jY-Is7EuK8LvOMsN1m668gkv40&m=3aiBmv4Gx92nve264fDYVfsmd8gK4Ew_PtC9G0ei8vs&s=rI0jlZK51At4ydhVR3Ri4wP2UZvT9V1PDVTWBr4x92M&e=>
ERROR: requests.exceptions.RequestException occured
ERROR: requests.exceptions.RequestException occured
ERROR: requests.exceptions.RequestException occured
ERROR: requests.exceptions.RequestException occured
^C
Process has been interrupted.


root at clokvadm01.ddmi.intra.renhsc.com<mailto:root at clokvadm01.ddmi.intra.renhsc.com> [/var/log]
$ /usr/bin/spacewalk-repo-sync -c confluent-ubuntu-amd64 -u http://packages.confluent.io/deb/5.1<https://urldefense.proofpoint.com/v2/url?u=http-3A__packages.confluent.io_deb_5.1&d=DwMFaQ&c=Jnf2Cp4PGnCPtuPxt-OIQR21MChqGaHuqvEjP9X2AA0&r=nH4RHOYxjoHu7_fk_jY-Is7EuK8LvOMsN1m668gkv40&m=3aiBmv4Gx92nve264fDYVfsmd8gK4Ew_PtC9G0ei8vs&s=vUQSQG3drknP5oeIQaOehGhd14W8hWQTT7NZ6kUzk-Y&e=> -t deb
15:40:17 ======================================
15:40:17 | Channel: confluent-ubuntu-amd64
15:40:17 ======================================
15:40:17 Sync of channel started.
15:40:18
15:40:18 Processing repository with URL: http://packages.confluent.io/deb/5.1<https://urldefense.proofpoint.com/v2/url?u=http-3A__packages.confluent.io_deb_5.1&d=DwMFaQ&c=Jnf2Cp4PGnCPtuPxt-OIQR21MChqGaHuqvEjP9X2AA0&r=nH4RHOYxjoHu7_fk_jY-Is7EuK8LvOMsN1m668gkv40&m=3aiBmv4Gx92nve264fDYVfsmd8gK4Ew_PtC9G0ei8vs&s=vUQSQG3drknP5oeIQaOehGhd14W8hWQTT7NZ6kUzk-Y&e=>
ERROR: Download of package list failed.
15:40:19 Packages in repo: 0
15:40:19 No new packages to sync.
15:40:19
15:40:19 Errata in repo: 0.
15:40:21 Sync of channel completed in 0:00:02.
15:40:21 Total time: 0:00:02


NOTE:  We were successful with the RedHat version. See below

2018/10/31 07:29:03 -04:00 Command: ['/usr/bin/spacewalk-repo-sync', '--channel', 'confluent-dist-rhel7-x86_64', '--type', 'yum']
2018/10/31 07:29:03 -04:00 Sync of channel started.
2018/10/31 07:29:04 -04:00
2018/10/31 07:29:04 -04:00   Processing repository with URL: http://packages.confluent.io/rpm/3.1/7
2018/10/31 07:29:04 -04:00     Packages in repo:                17
2018/10/31 07:29:04 -04:00     Packages already synced:          0
2018/10/31 07:29:04 -04:00     Packages to sync:                13
2018/10/31 07:29:04 -04:00     New packages to download:        13
2018/10/31 07:29:04 -04:00   Downloading packages:
2018/10/31 07:29:05 -04:00     1/13 : avro-c-1.8.0_confluent3.1.2-1.el7.x86_64.rpm
2018/10/31 07:29:05 -04:00     2/13 : avro-c-devel-1.8.0_confluent3.1.2-1.el7.x86_64.rpm
2018/10/31 07:29:05 -04:00     3/13 : avro-c-debuginfo-1.8.0_confluent3.1.2-1.el7.x86_64.rpm
2018/10/31 07:29:05 -04:00     4/13 : avro-cpp-debuginfo-1.8.0_confluent3.1.2-1.el7.x86_64.rpm
2018/10/31 07:29:05 -04:00     5/13 : avro-c-tools-1.8.0_confluent3.1.2-1.el7.x86_64.rpm
2018/10/31 07:29:05 -04:00     6/13 : avro-cpp-1.8.0_confluent3.1.2-1.el7.x86_64.rpm
2018/10/31 07:29:05 -04:00     7/13 : confluent-libserdes-3.1.2-1.el7.x86_64.rpm
2018/10/31 07:29:05 -04:00     8/13 : confluent-libserdes-devel-3.1.2-1.el7.x86_64.rpm
2018/10/31 07:29:05 -04:00     9/13 : confluent-libserdes-debuginfo-3.1.2-1.el7.x86_64.rpm
2018/10/31 07:29:05 -04:00     10/13 : librdkafka1-0.9.2_confluent3.1.2-1.el7.x86_64.rpm
2018/10/31 07:29:05 -04:00     11/13 : librdkafka-devel-0.9.2_confluent3.1.2-1.el7.x86_64.rpm
2018/10/31 07:29:05 -04:00     12/13 : librdkafka-debuginfo-0.9.2_confluent3.1.2-1.el7.x86_64.rpm
2018/10/31 07:29:05 -04:00     13/13 : avro-cpp-devel-1.8.0_confluent3.1.2-1.el7.x86_64.rpm
2018/10/31 07:29:06 -04:00 Importing packages started.
2018/10/31 07:29:06 -04:00
2018/10/31 07:29:06 -04:00   Importing packages to DB:
2018/10/31 07:29:09 -04:00 Importing packages finished.
2018/10/31 07:29:09 -04:00
2018/10/31 07:29:09 -04:00   Linking packages to the channel.
2018/10/31 07:29:09 -04:00
2018/10/31 07:29:09 -04:00   Errata in repo: 0.
2018/10/31 07:29:11 -04:00 Sync of channel completed in 0:00:07.



Ihor Lawrin
Technical Services
Senior System Administrator (UNIX)
Delta Dental of Michigan, Ohio, and Indiana
(517) 381-4207 Direct Line
(517) 648-7312 Cell

[cid:2BF1C32F-CF05-469B-B08B-26DA6BF62BA0]
ISO 9001 Quality Certified  *  Certified Call Center of Excellence  *  Rated A (Excellent) by A.M. Best Company


**********************************************************************
CONFIDENTIALITY NOTICE: The information contained in this email is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, dissemination, distribution or copying of this communication is prohibited and may be subject to legal restriction or sanction. If you have received this email in error, please notify the sender immediately to arrange for return or destruction of the information and all copies. If you are the intended recipient but do not wish to receive communications through this medium, please advise the sender immediately. Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20190207/ac6df5fe/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 10677 bytes
Desc: image002.png
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20190207/ac6df5fe/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 11139 bytes
Desc: image003.png
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20190207/ac6df5fe/attachment-0001.png>


More information about the Spacewalk-list mailing list