Bug 528424

Summary: TRACEBACK rhnpush "Exception type server.rhnSQL.sql_base.SQLError", result = <type 'int'> 500
Product: [Community] Spacewalk Reporter: Vasiliy Kotikov <elnone>
Component: ServerAssignee: Michael Mráka <mmraka>
Status: CLOSED WORKSFORME QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: high Docs Contact:
Priority: low    
Version: 0.6   
Target Milestone: ---   
Target Release: ---   
Hardware: i386   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2010-05-04 12:19:57 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 582354    
Attachments:
Description Flags
RHN TRACEBACK log none

Description Vasiliy Kotikov 2009-10-12 06:14:43 UTC
Created attachment 364426 [details]
RHN TRACEBACK log

Description of problem:
I have installed Spacewalk according to documentation from 
http://www.redhat.com/spacewalk/ and
http://wiki.centos.org/HowTos/PackageManagement/Spacewalk
with some differences:
1) Oracle DB is used as Oracle Standard 10.2.0 (patched to ver. 10.2.0.4)
2) /var/satellite partition is mounted via nfs to FibreCAT datastore. 
nfs:/data/netstore/repository/cobbler/ks_mirror    /var/www/cobbler/ks_mirror nfs  rw,soft,intr,rsize=32768,wsize=32768,fg
nfs:/data/netstore/repository/cobbler/repo_mirror  /var/www/cobbler/repo_mirror    nfs     rw,soft,intr,rsize=32768,wsize=32768,fg
nfs:/data/netstore/repository/satellite    /var/satellite  nfs     rw,soft,intr,rsize=32768,wsize=32768,fg

3) The Server itself resides on VMware ESX 3.5 on RX200 with 2G Rams set and is RHEL5.4.
The virtual server is purely dedicated for spacewalk.
Running the command:
rhnpush --channel=rhel-i386-server-5  --server=https://localhost/APP --dir=/var/www/cobbler/repo_mirror/rhel-i386-server-5/getPackage/ --username=xxxxx --password=xxxxxx -v --tolerant

leads to "Exception type server.rhnSQL.sql_base.SQLError" and many packages cannot be uploaded.

The repository was synced using cobbler reposync with active subscription of rhn.redhat.com server.

Version-Release number of selected component (if applicable):
rhn-check-0.6.4-1.el5
yum-rhn-plugin-0.6.2-1.el5
rhn-setup-0.6.4-1.el5
rhn-org-httpd-ssl-key-pair-uni076-1.0-1
rhnpush-5.4.2-1.el5
rhnlib-2.5.13-1.el5
rhnsd-4.7.0-4.el5
rhn-client-tools-0.6.4-1.el5
spacewalk-certs-tools-0.6.3-1.el5
spacewalk-backend-server-0.6.31-1.el5
spacewalk-backend-app-0.6.31-1.el5
spacewalk-backend-iss-export-0.6.31-1.el5
spacewalk-backend-applet-0.6.31-1.el5
spacewalk-pxt-0.6.20-1.el5
spacewalk-grail-0.6.20-1.el5
spacewalk-java-0.6.47-1.el5
spacewalk-monitoring-0.6.7-1.el5
spacewalk-schema-0.6.22-1.el5
spacewalk-java-config-0.6.47-1.el5
spacewalk-branding-0.6.8-1.el5
spacewalk-html-0.6.20-1.el5
spacewalk-backend-0.6.31-1.el5
spacewalk-backend-xml-export-libs-0.6.31-1.el5
spacewalk-search-0.6.11-1.el5
spacewalk-backend-package-push-server-0.6.31-1.el5
spacewalk-monitoring-selinux-0.6.12-1.el5
spacewalk-cypress-0.6.20-1.el5
spacewalk-selinux-0.6.13-1.el5
spacewalk-java-lib-0.6.47-1.el5
spacewalk-doc-indexes-0.6.1-1.el5
spacewalk-backend-config-files-common-0.6.31-1.el5
spacewalk-backend-config-files-0.6.31-1.el5
spacewalk-backend-iss-0.6.31-1.el5
spacewalk-base-0.6.20-1.el5
spacewalk-backend-tools-0.6.31-1.el5
spacewalk-sniglets-0.6.20-1.el5
spacewalk-setup-0.6.21-1.el5
spacewalk-0.6.4-1.el5
spacewalk-config-0.6.13-1.el5
spacewalk-backend-sql-0.6.31-1.el5
spacewalk-backend-xmlrpc-0.6.31-1.el5
spacewalk-backend-config-files-tool-0.6.31-1.el5
spacewalk-backend-xp-0.6.31-1.el5
spacewalk-base-minimal-0.6.20-1.el5
spacewalk-admin-0.6.3-1.el5
spacewalk-moon-0.6.20-1.el5
spacewalk-taskomatic-0.6.47-1.el5

How reproducible:


Steps to Reproduce:
1.
2.
3.
  
Actual results:
Exception type server.rhnSQL.sql_base.SQLError
Exception while handling function upload_server._wrapper

Expected results:
All packages are uploaded (pushed to Spacewalk server) with no errors.

Additional info:
Strange that nothing criminal is with log: rhn_upload_package_push.log

Comment 1 Michael Mráka 2010-04-14 11:50:08 UTC
It might be an instance of bug 567659, which is fixed.
Could you please recheck it with Spacewalk 0.8 or even better with Spacewalk nightly (to-be-0.9)?