Bug 627933 - 'ORA-01400: cannot insert NULL into ("RHNSAT"."RHNTASKQUEUE"."ORG_ID")\n' when satellite-sync-ing
Summary: 'ORA-01400: cannot insert NULL into ("RHNSAT"."RHNTASKQUEUE"."ORG_ID")\n' whe...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Satellite Synchronization
Version: 540
Hardware: All
OS: Linux
medium
medium
Target Milestone: ---
Assignee: Michael Mráka
QA Contact: Šimon Lukašík
URL:
Whiteboard:
: 627150 (view as bug list)
Depends On:
Blocks: sat540-blockers
TreeView+ depends on / blocked
 
Reported: 2010-08-27 12:46 UTC by Jan Hutař
Modified: 2010-10-28 14:55 UTC (History)
5 users (show)

Fixed In Version: spacewalk-backend-1.2.8-1
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2010-10-28 14:55:32 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Jan Hutař 2010-08-27 12:46:01 UTC
Description of problem:
When I have synced from Errara.stage or from Prod, I got exception thrown by satellite-sync.


Version-Release number of selected component (if applicable):
Galactica 20100820.0
spacewalk-schema-1.2.3-1.el5sat


How reproducible:
1 of 1


Steps to Reproduce:
1. # grep rhn_parent /etc/rhn/rhn.conf
   #server.satellite.rhn_parent = satellite.rhn.errata.stage.redhat.com
   server.satellite.rhn_parent = satellite.rhn.redhat.com
2. # satellite-sync -c rhel-ia64-server-5 -c rhel-ia64-as-4 -c rhn-tools-rhel-ia64-server-5 -c rhn-tools-rhel-4-as-ia64 -c rhel-ia64-server-vt-5


Actual results:
[...]
07:25:29 Importing channel errata
07:25:52    Importing *relevant* errata: rhel-ia64-as-4 (101)
            ________________________________________
Downloading:######################################## - complete
07:28:22    Importing *relevant* errata: rhn-tools-rhel-ia64-server-5 (4)
            ________________________________________
Downloading:######################################## - complete
07:29:12    Importing *relevant* errata: rhel-ia64-server-5 (302)
            ________________________________________
Downloading:######################################## - complete
07:42:28    Importing *relevant* errata: rhel-ia64-server-vt-5 (13)
            ________________________________________
Downloading:######################################## - complete
07:42:45    Importing *relevant* errata: rhn-tools-rhel-4-as-ia64 (1)
            ________________________________________
Downloading:######################################## - complete
+++ sending log as an email +++

SYNC ERROR: unhandled exception occurred:

(Check logs/email for potentially more detail)

(1400, 'ORA-01400: cannot insert NULL into ("RHNSAT"."RHNTASKQUEUE"."ORG_ID")\n', "insert into rhnTaskQueue (org_id, task_name, task_data, priority, earliest) select c.org_id, 'update_errata_cache_by_channel', c.id, 0, SYSDATE from rhnChannel c where c.label = :label")


Expected results:
Should work as expected


Additional info:
Error mail says:

07:42:46 
SYNC ERROR: unhandled exception occurred:

Exception reported from test03-64.rhndev.redhat.com
Time: Fri Aug 27 07:42:46 2010
Exception type server.rhnSQL.sql_base.SQLError

Exception Handler Information
Traceback (most recent call last):
  File "/usr/bin/satellite-sync", line 143, in main
    return satsync.Runner().main()
  File "/usr/share/rhn/satellite_tools/satsync.py", line 218, in main
    ret = method()
  File "/usr/share/rhn/satellite_tools/satsync.py", line 342, in _step_errata
    schedule_errata_cache_update(self._affected_channels)
  File "/usr/share/rhn/server/importlib/errataCache.py", line 32, in schedule_errata_cache_update
    h.executemany(label=channels)
  File "/usr/share/rhn/server/rhnSQL/sql_base.py", line 177, in executemany
    return apply(self._execute_wrapper, (self._executemany, ) + p, kw)
  File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 118, in _execute_wrapper
    raise apply(sql_base.SQLError, ret)
SQLError: (1400, 'ORA-01400: cannot insert NULL into ("RHNSAT"."RHNTASKQUEUE"."ORG_ID")\n', "insert into rhnTaskQueue (org_id, task_na
me, task_data, priority, earliest) select c.org_id, 'update_errata_cache_by_channel', c.id, 0, SYSDATE from rhnChannel c where c.label
 = :label")

Comment 1 Justin Sherrill 2010-08-27 13:03:41 UTC
This should be fixed by Michael's commit f6f212507731d2ee4f350e616bd94393ec6df5b3  on august 24th.  

spacewalk-backend-1.2.8-1  or newer should have the fix.

Comment 3 Michael Mráka 2010-08-30 16:59:23 UTC
*** Bug 627150 has been marked as a duplicate of this bug. ***

Comment 4 Šimon Lukašík 2010-09-29 06:43:18 UTC
QA: Changing to VERIFIED:

Testing procedure:
Reproducer from comment 1, on i386 and x86_64 machine. 
No traceback occurred, channels were correctly synced.

Verified against:
Satellite-5.4.0-RHEL5-re20100924.0

Comment 5 Dimitar Yordanov 2010-10-26 10:05:25 UTC
Verified on Stage.
nohup satellite-sync -c rhel-ia64-server-5 -c rhel-ia64-as-4 -c rhn-tools-rhel-ia64-server-5 -c rhn-tools-rhel-4-as-ia64 -c rhel-ia64-server-vt-5 &

Dimi

Comment 6 Clifford Perry 2010-10-28 14:50:42 UTC
The 5.4.0 RHN Satellite and RHN Proxy release has occurred. This issue has been resolved with this release. 


RHEA-2010:0801 - RHN Satellite Server 5.4.0 Upgrade
https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10332

RHEA-2010:0803 - RHN Tools enhancement update
https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10333

RHEA-2010:0802 - RHN Proxy Server 5.4.0 bug fix update
https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10334

RHEA-2010:0800 - RHN Satellite Server 5.4.0
https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10335

Docs are available:

http://docs.redhat.com/docs/en-US/Red_Hat_Network_Satellite/index.html 

Regards,
Clifford


Note You need to log in before you can comment on or make changes to this bug.