[Spacewalk-list] oracle error during repo sync

FRANK Michael michael.frank at faurecia.com
Fri Nov 22 14:41:12 UTC 2013


Hello All,

Many thanks for all  of your tremendous with Spacewalk.
I run In to an Oracle error each time I run the below repo sync. Regarding our database expert "size" is a reserved word in SQL ANSI and must not be used as a bind variable.
We running Oracle 11.2.0.3.0.
Maybe this is a possible bug in Spacewalk?

[root at euedcapp0028 ~]# spacewalk-repo-sync -c centos_6_x86_64_base  -f  --sync-kickstart
Repo URL: ftp://ftp.ciril.fr/pub/linux/centos/6.4/os/x86_64
Packages in repo:              6381
No new packages to sync.
Repo ftp://ftp.ciril.fr/pub/linux/centos/6.4/os/x86_64 has 0 errata.
Retrieving .discinfo
ERROR: (1745, 'ORA-01745: invalid host/bind variable name\n', "insert into rhnKSTreeFile (kstree_id, relative_filename, checksum_id, file_size, last_modified, created, modified) values (:id, :path, lookup_checksum('sha256', :checksum), :size, epoch_seconds_to_timestamp_tz(:st_time), current_timestamp, current_timestamp)")
Sync completed.
Total time: 0:04:31

Regards

Mike


DISCLAIMER:
This electronic transmission (and any attachments thereto) is intended solely for the use of the addressee(s). It may contain confidential or legally privileged information. If you are not the intended recipient of this message, you must delete it immediately and notify the sender. Any unauthorized use or disclosure of this message is strictly prohibited. Faurecia does not guarantee the integrity of this transmission and shall therefore never be liable if the message is altered or falsified nor for any virus, interception or damage to your system.





More information about the Spacewalk-list mailing list