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! _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
