SUSE Support

Here When You Need Us

SUSE Manager Inter-Server Synchronization (ISS) ending with error: null value in column "checksum" violates not-null constraint

This document (000019792) is provided subject to the disclaimer at the end of this document.

Environment

SUSE Manager 4.1 Server

Situation

Using a SUSE Manager Inter-Server-Sync setup (ISS) the following error can be found in the logs when trying a sync:
# satellite-sync -c pfs3_3-stable-sle-product-sles15-sp1-pool-x86_64
> 11:57:35 SUSE Manager - live synchronization
> 11:57:35    url: https://XXX.YYY.ZZZ
> 11:57:35    debug/output level: 1
> 11:57:35    db:  susemanager/<password>@susemanager
> 11:57:35
> 11:57:35 Retrieving / parsing orgs data
> 11:57:35 orgs data complete
> 11:57:35
> 11:57:35 Retrieving / parsing channel-families data
> 11:57:35 channel-families data complete
> 11:57:35
> 11:57:35 Retrieving / parsing product names data
> 11:57:35 product names data complete
> 11:57:35
> 11:57:35 Retrieving / parsing arches data
> 11:57:35 arches data complete
> 11:57:35
> 11:57:35 Retrieving / parsing additional arches data
> 11:57:35 additional arches data complete
> 11:57:35
> 11:57:35 Retrieving / parsing channel data
> 11:57:36    p = previously imported/synced channel
> 11:57:36    . = channel not yet imported/synced
> 11:57:36    base-channels:
> 11:57:36       . sle-product-sles15-sp1-pool-x86_64    3       full import from Thu Oct  8 13:21:18 2020
> 11:57:36
> ERROR: Encountered IntegrityError:
> null value in column "installer_updates" violates not-null constraint
> DETAIL:  Failing row contains (120, null, 1, 513, sle-product-sles15-sp1-pool-x86_64, /dev/null, SLE-Product-SLES15-SP1-Pool for x86_64, SUSE Linux Enterprise Server 15 SP1 x86_64, null, null, Y, null, null, null, null, 3, N, 2020-11-03 09:57:36.338362-01, null, null, private, null, null, null, null, SLE-Product-SLES, 2020-11-03 09:57:36.338362-01, 2020-11-03 09:57:36.338362-01, null).
> consider removing satellite-sync cache at /var/cache/rhn/satsync/* and re-run satellite-sync with same options.
> If this error persits after removing cache, please contact SUSE support.

Resolution

The following command should be run on the Master, just for reporting purposes (in case further help from Support is needed at a later point of time):
 

grep -v rhn-channel-installer-updates /var/cache/rhn/xml-channels/*xml


After that, the cache should be deleted, and the apache service restarted (commands to be run on the master):
 

rm -rf /var/cache/rhn/xml-*
capache2 restart

 

The same applies to the slave:
 

rm -rf /var/cache/rhn/satsync/*
rcapache2 restart

 

They sync should be possible after this. If symptoms should still be present, run the following commands both on the master and on the slave and report the results to Support:
 

spacewalk-sql --select-mode - <<<"SELECT id, label, installer_updates FROM rhnChannel;"
rpm -qi spacewalk-backend

Cause

Chances are a master-side cache still exists with old entries.

Status

Reported to Engineering

Disclaimer

This Support Knowledgebase provides a valuable tool for SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.

  • Document ID:000019792
  • Creation Date: 23-Nov-2020
  • Modified Date:25-Nov-2020
    • SUSE Manager Server

< Back to Support Search

For questions or concerns with the SUSE Knowledgebase please contact: tidfeedback[at]suse.com

SUSE Support Forums

Get your questions answered by experienced Sys Ops or interact with other SUSE community experts.

Support Resources

Learn how to get the most from the technical support you receive with your SUSE Subscription, Premium Support, Academic Program, or Partner Program.

Open an Incident

Open an incident with SUSE Technical Support, manage your subscriptions, download patches, or manage user access.