[Spacewalk-list] error creating new kickstart profile

[Dale Bewley]

On Fri, 2011-04-01 at 22:04 +0200, Michael Mraka wrote:
> % I'm setting up a new spacewalk server for the first time (v1.3 on F14),
> % and following along in the documentation until I get more oriented. I'm
> % on to the directions at
> % https://fedorahosted.org/spacewalk/wiki/HowToKickstartCobbler
> % 
> % Creating a cobbler distro went fine, but I hit a snag while creating the
> % kickstart profile for the distro. My steps are below.
> ...
> % 2011-03-29 13:57:59,999 [TP-Processor2] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 2F005
> % 2011-03-29 13:58:00,000 [TP-Processor2] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: control reached end of trigger procedure without RETURN
> %   Where: PL/pgSQL function "rhn_ks_session_history_trigger_fun"
> % 2011-03-29 13:58:00,000 [TP-Processor2] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session org.hibernate.exception.GenericJDBCException: could not insert: [com.redhat.rhn.domain.kickstart.KickstartSession]
> 
> rhn_ks_session_history_trigger_fun issue has been fixed in nightly by
> http://git.fedorahosted.org/git/?p=spacewalk.git;a=commitdiff;h=a14b2f07e579a3d47aac1f76006f8f7f9f767ca9
> 
> As for current Spacewalk 1.3 installation - you can fix it manually by applying 
> http://git.fedorahosted.org/git/?p=spacewalk.git;a=blob_plain;f=schema/spacewalk/upgrade/spacewalk-schema-1.3-to-spacewalk-schema-1.4/007-rhn_ks_session_history_trigger_fun.sql.postgresql;h=cce4dab8d438a80cc384fb77464b72bc6b573deb;hb=a14b2f07e579a3d47aac1f76006f8f7f9f767ca9
> directly to your postgresql schema.

Awesome. After saving the second URL to a file and applying it like
this:

 PGPASSWORD=pass psql -a -U spaceuser spaceschema < fix-postgres.sql

I can now create a kickstart profile and continue testing.

Thanks so much for the helpful response!