Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 568371

Summary: Cannot import a system file into a config channel
Product: [Community] Spacewalk Reporter: Nuno Marques <nmm>
Component: WebUIAssignee: Michael Mráka <mmraka>
Status: CLOSED CURRENTRELEASE QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: medium Docs Contact:
Priority: low    
Version: 0.8CC: mmraka, nmm, roysjosh
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2010-06-07 09:50:09 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    

Description Nuno Marques 2010-02-25 15:13:16 UTC
Description of problem:
Importing a system file into a config channel results in a web traceback

Version-Release number of selected component (if applicable):
0.7 and 0.8

How reproducible:
always

Steps to Reproduce:
1. Select a system
2. Configuration -> Add files -> Import files
3. Enter a file path
4. Import configuration files and confirm

Actual results:
Exception reported from gale.di.fc.ul.pt
Time: Thu Feb 25 15:11:42 2010
Exception type server.rhnSQL.sql_base.SQLStatementPrepareError
Exception while handling function config.client.upload_file
Request object information:
URI: /CONFIG-MANAGEMENT
Remote Host: swteste1.di.fc.ul.pt
Server Name: gale.di.fc.ul.pt:443
Headers passed in:
	Accept-Encoding: identity
	Content-Length: 735
	Host: gale.di.fc.ul.pt:443
	content-encoding: x-gzip
	content-transfer-encoding: binary
	content-type: application/binary
	user-agent: rhn.rpclib.py/$Revision$
	x-client-version: 1
	x-info: RPC Processor (C) Red Hat, Inc (version $Revision$)
	x-rhn-client-capability: rhncfg.dirs_enabled(1)=1,configfiles.base64_enc(1)=1
	x-rhn-transport-capability: follow-redirects=3
	x-transport-info: Extended Capabilities Transport (C) Red Hat, Inc (version $Revision$)
Extra information about this error:
SQL Error generated: ('ORA-00918: column ambiguously defined\n', 918, 'select id, c.checksum_type, c.checksum, file_size, contents, is_binary from rhnConfigContent, rhnChecksumView c where c.checksum = :checksum and c.checksum_type = :checksum_type and file_size = :file_size and checksum_id = c.id')
 
Exception Handler Information
Traceback (most recent call last):
  File "/usr/share/rhn/server/apacheRequest.py", line 120, in call_function
    response = apply(func, params)
  File "/usr/share/rhn/server/handlers/config/rhn_config_management.py", line 254, in client_upload_file
    return self.push_file(config_channel_id, file)
  File "/usr/share/rhn/server/configFilesHandler.py", line 194, in push_file
    result = self._push_file(config_channel_id, file)
  File "/usr/share/rhn/server/configFilesHandler.py", line 167, in _push_file
    self._push_contents(file)
  File "/usr/share/rhn/server/configFilesHandler.py", line 291, in _push_contents
    apply(h.execute, (), file)
  File "/usr/share/rhn/server/rhnSQL/sql_base.py", line 168, in execute
    return apply(self._execute_wrapper, (self._execute, ) + p, kw)
  File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 108, in _execute_wrapper
    raise apply(sql_base.SQLStatementPrepareError, args)
SQLStatementPrepareError: ('ORA-00918: column ambiguously defined\n', 918, 'select id, c.checksum_type, c.checksum, file_size, contents, is_binary from rhnConfigContent, rhnChecksumView c where c.checksum = :checksum and c.checksum_type = :checksum_type and file_size = :file_size and checksum_id = c.id')
 
Local variables by frame
Frame _execute_wrapper in /usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py at line 108
	            function = <type 'instancemethod'> <bound method Cursor._execute of <__builtin__.OracleCursor on <cx_Oracle.Connection to spacewalk@xe>>>
	                   e = <type 'instance'> ORA-00918: column ambiguously defined
 
	               errno = <type 'int'> 918
	                self = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to spacewalk@xe>>
	                args = <type 'tuple'> (918, 'ORA-00918: column ambiguously defined\n', 'select id, c.checksum_type, c.checksum, file_size, contents, is_binary from rhnConfigContent, rhnChecksumView c where c.checksum = :checksum and c.checksum_type = :checksum_type and file_size = :file_size and checksum_id = c.id')
	     modified_params = <type 'list'> []
	               value = <type 'int'> 36
	                   p = <type 'tuple'> ()
	              params = <type 'str'> username: root,group: root,ctime: 1267015822,groupname: root,checksum: 03c5f5d4d3a23f256060551a759efd92,user: root,delim_start: {|,delim_end: |},config_file_type_id: 1,file_contents: ClNwYWNld2FsayBraWNrc3RhcnQgb24gMjAxMC0wMi0yNAoK
,enc64: 1,file_size: 36,mode: 644,file_mode: 644,mtime: 1267015822,path: /etc/motd,checksum_type: md5,selinux_ctx: system_u:object_r:etc_runtime_t,is_binary: N,size: 36
	                 ret = <type 'tuple'> (918, 'ORA-00918: column ambiguously defined\n', 'select id, c.checksum_type, c.checksum, file_size, contents, is_binary from rhnConfigContent, rhnChecksumView c where c.checksum = :checksum and c.checksum_type = :checksum_type and file_size = :file_size and checksum_id = c.id')
	                 key = <type 'str'> size
	                  kw = <type 'dict'> {'username': 'root', 'group': 'root', 'ctime': 1267015822, 'groupname': 'root', 'checksum': '03c5f5d4d3a23f256060551a759efd92', 'user': 'root', 'delim_start': '{|', 'delim_end': '|}', 'config_file_type_id': 1, 'file_contents': 'ClNwYWNld2FsayBraWNrc3RhcnQgb24gMjAxMC0wMi0yNAoK\n', 'enc64': 1, 'file_size': 36, 'mode': 644, 'file_mode': 644, 'mtime': 1267015822, 'path': '/etc/motd', 'checksum_type': 'md5', 'selinux_ctx': 'system_u:object_r:etc_runtime_t', 'is_binary': 'N', 'size': 36}
	              errmsg = <type 'str'> ORA-00918: column ambiguously defined
 
 
Frame execute in /usr/share/rhn/server/rhnSQL/sql_base.py at line 168
	                   p = <type 'tuple'> ()
	                self = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to spacewalk@xe>>
	                  kw = <type 'dict'> {'username': 'root', 'size': 36, 'group': 'root', 'ctime': 1267015822, 'config_file_type_id': 1, 'checksum': '03c5f5d4d3a23f256060551a759efd92', 'delim_start': '{|', 'file_contents': 'ClNwYWNld2FsayBraWNrc3RhcnQgb24gMjAxMC0wMi0yNAoK\n', 'groupname': 'root', 'delim_end': '|}', 'enc64': 1, 'mtime': 1267015822, 'mode': 644, 'file_mode': 644, 'file_size': 36, 'path': '/etc/motd', 'checksum_type': 'md5', 'selinux_ctx': 'system_u:object_r:etc_runtime_t', 'is_binary': 'N', 'user': 'root'}
 
Frame _push_contents in /usr/share/rhn/server/configFilesHandler.py at line 291
	                   c = <type 'str'> 
 
	                   h = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to spacewalk@xe>>
	                self = <type 'instance'> <server.handlers.config.rhn_config_management.ConfigManagement instance at 0x999844c>
	       file_contents = <type 'str'> 
Spacewalk kickstart on 2010-02-24
 
 
	                file = <type 'dict'> {'username': 'root', 'group': 'root', 'ctime': 1267015822, 'groupname': 'root', 'checksum': '03c5f5d4d3a23f256060551a759efd92', 'delim_start': '{|', 'delim_end': '|}', 'mode': 644, 'config_file_type_id': 1, 'file_contents': 'ClNwYWNld2FsayBraWNrc3RhcnQgb24gMjAxMC0wMi0yNAoK\n', 'enc64': 1, 'file_size': 36, 'user': 'root', 'file_mode': 644, 'mtime': 1267015822, 'path': '/etc/motd', 'checksum_type': 'md5', 'selinux_ctx': 'system_u:object_r:etc_runtime_t', 'is_binary': 'N', 'size': 36}
	       checksum_type = <type 'str'> md5
	           file_path = <type 'str'> /etc/motd
 
Frame _push_file in /usr/share/rhn/server/configFilesHandler.py at line 169
	                path = <type 'str'> /etc/motd
	                self = <type 'instance'> <server.handlers.config.rhn_config_management.ConfigManagement instance at 0x999844c>
	              result = <type 'dict'> {}
	                file = <type 'dict'> {'username': 'root', 'group': 'root', 'ctime': 1267015822, 'groupname': 'root', 'checksum': '03c5f5d4d3a23f256060551a759efd92', 'delim_start': '{|', 'delim_end': '|}', 'mode': 644, 'config_file_type_id': 1, 'file_contents': 'ClNwYWNld2FsayBraWNrc3RhcnQgb24gMjAxMC0wMi0yNAoK\n', 'enc64': 1, 'file_size': 36, 'user': 'root', 'file_mode': 644, 'mtime': 1267015822, 'path': '/etc/motd', 'checksum_type': 'md5', 'selinux_ctx': 'system_u:object_r:etc_runtime_t', 'is_binary': 'N', 'size': 36}
	   config_channel_id = <type 'int'> 42
 
Frame push_file in /usr/share/rhn/server/configFilesHandler.py at line 218
	                self = <type 'instance'> <server.handlers.config.rhn_config_management.ConfigManagement instance at 0x999844c>
	                file = <type 'dict'> {'username': 'root', 'group': 'root', 'ctime': 1267015822, 'groupname': 'root', 'checksum': '03c5f5d4d3a23f256060551a759efd92', 'delim_start': '{|', 'delim_end': '|}', 'mode': 644, 'config_file_type_id': 1, 'file_contents': 'ClNwYWNld2FsayBraWNrc3RhcnQgb24gMjAxMC0wMi0yNAoK\n', 'enc64': 1, 'file_size': 36, 'user': 'root', 'file_mode': 644, 'mtime': 1267015822, 'path': '/etc/motd', 'checksum_type': 'md5', 'selinux_ctx': 'system_u:object_r:etc_runtime_t', 'is_binary': 'N', 'size': 36}
	   config_channel_id = <type 'int'> 42
 
Frame client_upload_file in /usr/share/rhn/server/handlers/config/rhn_config_management.py at line 254
	                   h = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to spacewalk@xe>>
	                self = <type 'instance'> <server.handlers.config.rhn_config_management.ConfigManagement instance at 0x999844c>
	            systemid = <type 'str'> <?xml version="1.0"?>
<params>
<param>
<value><struct>
<member>
<name>username</name>
<value><string>admin</string></value>
</member>
<member>
<name>operating_system</name>
<value><string>centos-release</string></value>
</member>
<member>
<name>description</name>
<value><string>Initial Registration Parameters:
OS: centos-release
Release: 5
CPU Arch: i686-redhat-linux</string></value>
</member>
<member>
<name>checksum</name>
<value><string>170c950fa9f75d232071702453c69b1c</string></value>
</member>
<member>
<name>profile_name</name>
<value><string>sw1</string></value>
</member>
<member>
<name>system_id</name>
<value><string>ID-1000010221</string></value>
</member>
<member>
<name>architecture</name>
<value><string>i686-redhat-linux</string></value>
</member>
<member>
<name>os_release</name>
<value><string>5</string></value>
</member>
<member>
<name>fields</name>
<value><array><data>
<value><string>system_id</string></value>
<value><string>os_release</string></value>
<value><string>operating_system</string></value>
<value><string>architecture</string></value>
<value><string>username</string></value>
<value><string>type</string></value>
</data></array></value>
</member>
<member>
<name>type</name>
<value><string>REAL</string></value>
</member>
</struct></value>
</param>
</params>
 
	                file = <type 'dict'> {'username': 'root', 'group': 'root', 'ctime': 1267015822, 'groupname': 'root', 'checksum': '03c5f5d4d3a23f256060551a759efd92', 'delim_start': '{|', 'delim_end': '|}', 'mode': 644, 'config_file_type_id': 1, 'file_contents': 'ClNwYWNld2FsayBraWNrc3RhcnQgb24gMjAxMC0wMi0yNAoK\n', 'enc64': 1, 'file_size': 36, 'user': 'root', 'file_mode': 644, 'mtime': 1267015822, 'path': '/etc/motd', 'checksum_type': 'md5', 'selinux_ctx': 'system_u:object_r:etc_runtime_t', 'is_binary': 'N', 'size': 36}
	   config_channel_id = <type 'int'> 42
	           action_id = <type 'int'> 621
	                 row = <type 'dict'> {'action_status': 'Picked Up', 'config_channel_id': 42}
 
Frame call_function in /usr/share/rhn/server/apacheRequest.py at line 166
	                   e = <type 'instance'> ('ORA-00918: column ambiguously defined\n', 918, 'select id, c.checksum_type, c.checksum, file_size, contents, is_binary from rhnConfigContent, rhnChecksumView c where c.checksum = :checksum and c.checksum_type = :checksum_type and file_size = :file_size and checksum_id = c.id')
	                self = <type 'instance'> <server.apacheRequest.apachePOST instance at 0xb368570c>
	      force_rollback = <type 'int'> 1
	              params = <type 'tuple'> ('<?xml version="1.0"?>\n<params>\n<param>\n<value><struct>\n<member>\n<name>username</name>\n<value><string>admin</string></value>\n</member>\n<member>\n<name>operating_system</name>\n<value><string>centos-release</string></value>\n</member>\n<member>\n<name>description</name>\n<value><string>Initial Registration Parameters:\nOS: centos-release\nRelease: 5\nCPU Arch: i686-redhat-linux</string></value>\n</member>\n<member>\n<name>checksum</name>\n<value><string>170c950fa9f75d232071702453c69b1c</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string>sw1</string></value>\n</member>\n<member>\n<name>system_id</name>\n<value><string>ID-1000010221</string></value>\n</member>\n<member>\n<name>architecture</name>\n<value><string>i686-redhat-linux</string></value>\n</member>\n<member>\n<name>os_release</name>\n<value><string>5</string></value>\n</member>\n<member>\n<name>fields</name>\n<value><array><data>\n<value><strin
 g>system_id</string></value>\n<value><string>os_release</string></value>\n<value><string>operating_system</string></value>\n<value><string>architecture</string></value>\n<value><string>username</string></value>\n<value><string>type</string></value>\n</data></array></value>\n</member>\n<member>\n<name>type</name>\n<value><string>REAL</string></value>\n</member>\n</struct></value>\n</param>\n</params>\n', 621, {'username': 'root', 'group': 'root', 'ctime': 1267015822, 'groupname': 'root', 'checksum': '03c5f5d4d3a23f256060551a759efd92', 'delim_start': '{|', 'delim_end': '|}', 'mode': 644, 'config_file_type_id': 1, 'file_contents': 'ClNwYWNld2FsayBraWNrc3RhcnQgb24gMjAxMC0wMi0yNAoK\n', 'enc64': 1, 'file_size': 36, 'user': 'root', 'file_mode': 644, 'mtime': 1267015822, 'path': '/etc/motd', 'checksum_type': 'md5', 'selinux_ctx': 'system_u:object_r:etc_runtime_t', 'is_binary': 'N', 'size': 36})
	                func = <type 'instancemethod'> <bound method ConfigManagement.client_upload_file of <server.handlers.config.rhn_config_management.ConfigManagement instance at 0x999844c>>
	              method = <type 'unicode'> config.client.upload_file
 
Frame process in /usr/share/rhn/server/apacheRequest.py at line 473
	                  fd = <type 'instance'> <cStringIO.StringO object at 0x99984c0>
	               _body = <type 'str'> <?xml version='1.0'?>
<methodCall>
<methodName>config.client.upload_file</methodName>
<params>
<param>
<value><string>&lt;?xml version="1.0"?&gt;
&lt;params&gt;
&lt;param&gt;
&lt;value&gt;&lt;struct&gt;
&lt;member&gt;
&lt;name&gt;username&lt;/name&gt;
&lt;value&gt;&lt;string&gt;admin&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;operating_system&lt;/name&gt;
&lt;value&gt;&lt;string&gt;centos-release&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;description&lt;/name&gt;
&lt;value&gt;&lt;string&gt;Initial Registration Parameters:
OS: centos-release
Release: 5
CPU Arch: i686-redhat-linux&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;checksum&lt;/name&gt;
&lt;value&gt;&lt;string&gt;170c950fa9f75d232071702453c69b1c&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;profile_name&lt;/name&gt;
&lt;value&gt;&lt;string&gt;sw1&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;system_id&lt;/name&gt;
&lt;value&gt;&lt;string&gt;ID-1000010221&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;architecture&lt;/name&gt;
&lt;value&gt;&lt;string&gt;i686-redhat-linux&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;os_release&lt;/name&gt;
&lt;value&gt;&lt;string&gt;5&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;fields&lt;/name&gt;
&lt;value&gt;&lt;array&gt;&lt;data&gt;
&lt;value&gt;&lt;string&gt;system_id&lt;/string&gt;&lt;/value&gt;
&lt;value&gt;&lt;string&gt;os_release&lt;/string&gt;&lt;/value&gt;
&lt;value&gt;&lt;string&gt;operating_system&lt;/string&gt;&lt;/value&gt;
&lt;value&gt;&lt;string&gt;architecture&lt;/string&gt;&lt;/value&gt;
&lt;value&gt;&lt;string&gt;username&lt;/string&gt;&lt;/value&gt;
&lt;value&gt;&lt;string&gt;type&lt;/string&gt;&lt;/value&gt;
&lt;/data&gt;&lt;/array&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;type&lt;/name&gt;
&lt;value&gt;&lt;string&gt;REAL&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;/struct&gt;&lt;/value&gt;
&lt;/param&gt;
&lt;/params&gt;
</string></value>
</param>
<param>
<value><int>621</int></value>
</param>
<param>
<value><struct>
<member>
<name>size</name>
<value><int>36</int></value>
</member>
<member>
<name>group</name>
<value><string>root</string></value>
</member>
<member>
<name>ctime</name>
<value><int>1267015822</int></value>
</member>
<member>
<name>delim_start</name>
<value><string>{|</string></value>
</member>
<member>
<name>file_contents</name>
<value><string>ClNwYWNld2FsayBraWNrc3RhcnQgb24gMjAxMC0wMi0yNAoK
</string></value>
</member>
<member>
<name>config_file_type_id</name>
<value><int>1</int></value>
</member>
<member>
<name>delim_end</name>
<value><string>|}</string></value>
</member>
<member>
<name>enc64</name>
<value><int>1</int></value>
</member>
<member>
<name>user</name>
<value><string>root</string></value>
</member>
<member>
<name>mtime</name>
<value><int>1267015822</int></value>
</member>
<member>
<name>path</name>
<value><string>/etc/motd</string></value>
</member>
<member>
<name>selinux_ctx</name>
<value><string>system_u:object_r:etc_runtime_t</string></value>
</member>
<member>
<name>mode</name>
<value><int>644</int></value>
</member>
</struct></value>
</param>
</params>
</methodCall>
 
	              params = <type 'tuple'> ('<?xml version="1.0"?>\n<params>\n<param>\n<value><struct>\n<member>\n<name>username</name>\n<value><string>admin</string></value>\n</member>\n<member>\n<name>operating_system</name>\n<value><string>centos-release</string></value>\n</member>\n<member>\n<name>description</name>\n<value><string>Initial Registration Parameters:\nOS: centos-release\nRelease: 5\nCPU Arch: i686-redhat-linux</string></value>\n</member>\n<member>\n<name>checksum</name>\n<value><string>170c950fa9f75d232071702453c69b1c</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string>sw1</string></value>\n</member>\n<member>\n<name>system_id</name>\n<value><string>ID-1000010221</string></value>\n</member>\n<member>\n<name>architecture</name>\n<value><string>i686-redhat-linux</string></value>\n</member>\n<member>\n<name>os_release</name>\n<value><string>5</string></value>\n</member>\n<member>\n<name>fields</name>\n<value><array><data>\n<value><strin
 g>system_id</string></value>\n<value><string>os_release</string></value>\n<value><string>operating_system</string></value>\n<value><string>architecture</string></value>\n<value><string>username</string></value>\n<value><string>type</string></value>\n</data></array></value>\n</member>\n<member>\n<name>type</name>\n<value><string>REAL</string></value>\n</member>\n</struct></value>\n</param>\n</params>\n', 621, {'username': 'root', 'group': 'root', 'ctime': 1267015822, 'groupname': 'root', 'checksum': '03c5f5d4d3a23f256060551a759efd92', 'delim_start': '{|', 'delim_end': '|}', 'mode': 644, 'config_file_type_id': 1, 'file_contents': 'ClNwYWNld2FsayBraWNrc3RhcnQgb24gMjAxMC0wMi0yNAoK\n', 'enc64': 1, 'file_size': 36, 'user': 'root', 'file_mode': 644, 'mtime': 1267015822, 'path': '/etc/motd', 'checksum_type': 'md5', 'selinux_ctx': 'system_u:object_r:etc_runtime_t', 'is_binary': 'N', 'size': 36})
	              method = <type 'unicode'> config.client.upload_file
	                self = <type 'instance'> <server.apacheRequest.apachePOST instance at 0xb368570c>
 
Frame handler in /usr/share/rhn/server/apacheHandler.py at line 198
	                   h = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to spacewalk@xe>>
	                self = <type 'instance'> <server.apacheHandler.apacheHandler instance at 0xb3685a0c>
	                 req = <type 'mp_request'> <mp_request object at 0xb7f4cd2c>
	                 ret = <type 'int'> 0
	     templateStrings = <type 'dict'> {'email_account_info': '\nAccount Information:\n  Your Spacewalk login:         <login />\n  Your Spacewalk email address: <email-address />', 'email_footer': '--the Spacewalk Team', 'hostname': 'gale.di.fc.ul.pt'}
	                 row = <type 'NoneType'> None
 
Frame __call__ in /usr/share/rhn/server/apacheServer.py at line 58
	                self = <type 'instance'> <server.apacheServer.HandlerWrap instance at 0xb3739eec>
	                 req = <type 'mp_request'> <mp_request object at 0xb7f4cd2c>
	                   f = <type 'instancemethod'> <bound method apacheHandler.handler of <server.apacheHandler.apacheHandler instance at 0xb3685a0c>>
 
Frame HandlerDispatch in /usr/lib/python2.4/site-packages/mod_python/apache.py at line 299
	                 req = <type 'mp_request'> <mp_request object at 0xb7f4cd2c>
	              config = <type 'mp_table'> {'PythonInterpreter': 'rhn.server', 'PythonPath': 'sys.path+['/usr/share/rhn']'}
	                self = <type 'instance'> <mod_python.apache.CallBack instance at 0xb7f5a36c>
	              object = <type 'instance'> <server.apacheServer.HandlerWrap instance at 0xb3739eec>
	                   l = <type 'list'> ['server.apacheServer', 'Handler']
	              module = <type 'module'> <module 'server.apacheServer' from '/usr/share/rhn/server/apacheServer.pyc'>
	               hlist = <type 'mp_hlist'> {'handler:'server.apacheServer::Handler','directory':'/CONFIG-MANAGEMENT/','silent':0}
	          object_str = <type 'str'> Handler
	               debug = <type 'int'> 0
	         module_name = <type 'str'> server.apacheServer
	          pathstring = <type 'str'> sys.path+['/usr/share/rhn']
	              result = <type 'int'> 500
 
 
Environment for PID=13172 on exception:
CONSOLE = /dev/console
HOME = /
INIT_VERSION = sysvinit-2.86
LANG = C
NLS_LANG = english.AL32UTF8
ORACLE_HOME = /opt/oracle
PATH = /sbin:/usr/sbin:/bin:/usr/bin
PERL_BADFREE = 0
PREVLEVEL = N
PWD = /
RUNLEVEL = 3
SELINUX_INIT = YES
SHLVL = 3
TERM = linux
_ = /usr/sbin/httpd
previous = N
runlevel = 3
 

Expected results:
File uploaded to configuration channel

Additional info:

Comment 1 Michael Mráka 2010-03-08 09:47:09 UTC
I'm not able to reproduce the error. It might have been some upgrade issue...

Please post the output of
# sqlplus $(spacewalk-cfg-get default_db)
SQL> desc rhnConfigContent
SQL> desc rhnChecksumView
SQL> desc rhnChecksum
SQL> desc rhnChecksumType
SQL> quit

Comment 2 Nuno Marques 2010-03-08 10:04:13 UTC
(In reply to comment #1)
> I'm not able to reproduce the error. It might have been some upgrade issue...
> 
> Please post the output of
> # sqlplus $(spacewalk-cfg-get default_db)
> SQL> desc rhnConfigContent
> SQL> desc rhnChecksumView
> SQL> desc rhnChecksum
> SQL> desc rhnChecksumType
> SQL> quit    

[root@gale ~]# sqlplus $(spacewalk-cfg-get default_db)

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 8 10:01:51 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL> desc rhnConfigContent
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID                                        NOT NULL NUMBER
 CONTENTS                                           BLOB
 FILE_SIZE                                          NUMBER
 IS_BINARY                                 NOT NULL CHAR(1)
 CREATED                                   NOT NULL DATE
 MODIFIED                                  NOT NULL DATE
 CHECKSUM_ID                               NOT NULL NUMBER

SQL> desc rhnChecksumView
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID                                        NOT NULL NUMBER
 CHECKSUM_TYPE                             NOT NULL VARCHAR2(32)
 CHECKSUM                                  NOT NULL VARCHAR2(128)

SQL> desc rhnChecksum       
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID                                        NOT NULL NUMBER
 CHECKSUM_TYPE_ID                          NOT NULL NUMBER
 CHECKSUM                                  NOT NULL VARCHAR2(128)

SQL> desc rhnChecksumType
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID                                        NOT NULL NUMBER
 LABEL                                     NOT NULL VARCHAR2(32)
 DESCRIPTION                               NOT NULL VARCHAR2(64)
 CREATED                                   NOT NULL DATE
 MODIFIED                                  NOT NULL DATE

Comment 3 Joshua Roys 2010-06-03 20:00:39 UTC
This was fixed in spacewalk.git on March 4th, 2010 at 25dd5837f6352c24d150adac680f12e2fa2709fd

Comment 4 Michael Mráka 2010-06-07 09:46:23 UTC
Fixed in package spacewalk-backend-0.9.7-1.

Comment 5 Michael Mráka 2010-06-07 09:50:09 UTC
This bug has been fixed in Spacewalk 1.0.