% On Wed, Dec 21, 2011 at 10:06:46AM -0500, Eric Lake wrote:
% > I ran into an issue earlier this week where I synced my centos 6 repo
% > with the mirrors and received a traceback when I tried to merge it
% > with my centos 6 test channel that my client systems use. I could get
% > all the way to the confirmation stage of the merge but when I clicked
% > confirm I would get a "500 Internal Server Error" and the traceback.
% > The traceback looked like this:
% >
% > Error message:
% > RHN::Exception: DBD::Pg::st execute failed: ERROR: missing
% > FROM-clause entry for table "rhn_repo_regen_queue_id_seq" at character
%
% [...]
%
% > To address that I changed instances of "VALUES
% > (rhn_repo_regen_queue_id_seq.nextval," to "VALUES
% > (sequence_nextval('rhn_repo_regen_queue_id_seq')," in
% > /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/ChannelEditor.pm
% >
% > Once that was addressed it led to another traceback that looked like this:
% >
% > Error message:
% > RHN::Exception: DBD::Pg::st execute failed: ERROR: column "sysdate"
% > does not exist at character 252
%
% [...]
%
% > This one seems to work if instances of sysdate are replaced with
% > current_timestamp in
% > /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/ChannelEditor.pm like this:
%
% [...]
%
% > I would try to submit a patch but right now I am trying to see how to
% > do fix it so that it will work for both postgresql and oracle-xe.
Hi Eric,
I've commited both changes into spacewalk master (commit
c888cfa4c4f384e712f49f43ead15217d877efcd, package spacewalk-web-1.7.3-1).
Thanks for your contribution.
% Both fixes are correct and will work both on Oracle and PostgreSQL,
% in Spacewalk schema. You might want to crosscheck
%
% https://fedorahosted.org/spacewalk/wiki/PostgreSQLPortingGuide
%
% when in doubt with the proposed approach -- the page lists the
% types of issues/errors that we've already seen in the past.
Regards,
--
Michael Mráka
Satellite Engineering, Red Hat
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
