[Spacewalk-list] SyncRepo failure with "name_id" violates not-null constraint

[Matthew Ife]

I am trying to setup spacewalk-2.0.1-3 on SL6 and followed the
instructions in the wiki provided.

I can install and initially configure spacewalk, but repository
syncing always fails.
Please note all my install attempts use an external database,
disconnected mode is set. I have removed disconnected from the
spacewalk server once it is up.

For example; Doing the following results in a failure

# /usr/bin/python -u /usr/bin/spacewalk-repo-sync
--url="http://desktop-6.admin.coxbs.i0/mirror/sl/6.4/x86_64/os"
--channel localrepo --type yum --fail

Points to note:
  Channel localrepo is setup with the sl6 6.4 base repository being
used as a repo.
  Desktop-6 contains access to a yum repository, for which yum can
access and work properly with.
  Desktop-6 proxies requests to another host.
  I have tried other repositories but all via desktop-6 (it is my only
accessible endpoint)  and all work adequately via yum. None of which
work with the spacewalk-sync-repo.

When running the output is as follows;

Repo URL: http://desktop-6.admin.coxbs.i0/mirror/sl/6.4/x86_64/os
Packages in repo:              6449
Packages already synced:          0
Packages to sync:              6449
1/6449 : ConsoleKit-0.4.1-3.el6-0.x86_64
null value in column "name_id" violates not-null constraint
CONTEXT:  Error occurred on dblink connection named "at_conn": could
not execute command.
SQL statement "SELECT  dblink_exec('at_conn',  $1 , true)"
PL/pgSQL function "pg_dblink_exec" line 7 at PERFORM
SQL statement "SELECT  pg_dblink_exec( 'insert into
rhnPackageNEVRA(id, name_id, evr_id, package_arch_id) values (' ||  $1
 || ', ' || coalesce(quote_literal( $2 ), 'NULL') || ', ' ||
coalesce(quote_literal( $3 ), 'NULL') || ', ' ||
coalesce(quote_literal( $4 ), 'NULL') || ')')"
PL/pgSQL function "lookup_package_nevra" line 19 at PERFORM

ERROR: null value in column "name_id" violates not-null constraint
CONTEXT:  Error occurred on dblink connection named "at_conn": could
not execute command.
SQL statement "SELECT  dblink_exec('at_conn',  $1 , true)"
PL/pgSQL function "pg_dblink_exec" line 7 at PERFORM
SQL statement "SELECT  pg_dblink_exec( 'insert into
rhnPackageNEVRA(id, name_id, evr_id, package_arch_id) values (' ||  $1
 || ', ' || coalesce(quote_literal( $2 ), 'NULL') || ', ' ||
coalesce(quote_literal( $3 ), 'NULL') || ', ' ||
coalesce(quote_literal( $4 ), 'NULL') || ')')"
PL/pgSQL function "lookup_package_nevra" line 19 at PERFORM

Traceback (most recent call last):
  File "/usr/bin/spacewalk-repo-sync", line 106, in <module>
    sys.exit(abs(main() or 0))
  File "/usr/bin/spacewalk-repo-sync", line 99, in main
    sync.sync()
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/reposync.py",
line 134, in sync
    [self.channel_label], [], "server.app.yumreposync")
  File "/usr/lib/python2.6/site-packages/spacewalk/server/taskomatic.py",
line 65, in add_to_repodata_queue_for_channel_package_subscription
    add_to_repodata_queue(channel, caller, reason[:128])
  File "/usr/lib/python2.6/site-packages/spacewalk/server/taskomatic.py",
line 51, in add_to_repodata_queue
    queue.add(entry)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/taskomatic.py",
line 43, in add
    bypass_filters=self._boolean_as_char(entry.bypass_filters))
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py",
line 163, in execute
    return apply(self._execute_wrapper, (self._execute, ) + p, kw)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
line 279, in _execute_wrapper
    raise sql_base.SQLSchemaError(error_code, e.pgerror, e)
spacewalk.server.rhnSQL.sql_base.SQLSchemaError: (99999, 'ERROR:
current transaction is aborted, commands ignored until end of
transaction block', '', InternalError('current transaction is aborted,
commands ignored until end of transaction block\n',))


The furthest I have tracked this down to in python indicates that the
'name_id' is filled in by the class 'GenericPackageImport' in
importlib/importLib.py, the method '_postprocessPackageNEVRA' is
called. It relies on a value 'self.names[package.name]', which is
always "None" (python nonetype).

I assume that this value is meant to be filled in somewhere or
somehow, presumably through the use of another database table. It
doesn't exist at the moment since it is the first time I am syncing
the repository. Looking through that region of code did not indicate
to me any place where 'self.names' in that class is being modified to
anything but to serve up 'None' values.

I have tried reinstalling from scratch but get the same problem again.

I am certain I must be doing something wrong procedurally somewhere,
going through the mailing list for the last 3 months provides no
indication anybody else has experienced a similar issue.

Any help at this stage is greatly appreciated.