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.
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.
--
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
