[Spacewalk-list] Merge Packages in Spacewalk 1.6 and postgresql via the Web GUI throws Error 500 - Internal Server Error

[Scott Worthington]

Hello,

I am trying to merge packages from one channel to another through web GUI using 
Spacewalk 1.6 on CentOS 6.2 with Postgresql but it fails.  Any assistance would be
helpful (should I file a Redhat Bugzilla?)

Doing the following process causes an "Error 500 - Internal Server Error" and throws the following "WEB TRACEBACK"

#--------------------------------------

Channels -> Manage Software Channels -> select a channel -> Packages -> 
Compare Packages -> "Compare to:" -> using the Drop-down, select the
channel you'd like to compare -> click on "Compare" button

#wait patiently since my Spacewalk server is (upped RAM to 6GB):
du -h -s /var/lib/pgsql/data
12G     /var/lib/pgsql/data

#when next screen comes up...

Click on "Merge Differences" button
Bullet the item "Make identical to <channel_comparing_to>"
Click on "Preview Merge" button
Check only one package item to merge into your channel
Click on "Merge Packages" button 
(next web page will display your one package to merge)
Click on "Confirm" button

Note: It does not matter if you select one item or more items, the
traceback below is the same.

#--------------------------------------

In the Web GUI you get "Error 500".  

#--------------------------------------
This is the WEB TRACEBACK e-mail:
#--------------------------------------

The following exception occurred while executing this request:
 POST /network/software/channels/manage/packages/compare/sync_confirm.pxt HTTP/1.1 (from browser)  /network/software/channels/manage/packages/compare/sync_confirm.pxt (from Apache)

Date:
  Fri Mar  9 09:23:58 2012

Headers:
  Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
  Accept-Encoding: gzip, deflate
  Accept-Language: en-us,en;q=0.5
  Connection: keep-alive
  Content-Length: 532
  Content-Type: application/x-www-form-urlencoded
  Cookie: __utma=55795707.1190598479.1328633658.1328633658.1328633658.1; __utmz=55795707.1328633658.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); pxt-session-cookie=38682x4ed91dcbf1804887b1d30224a69ed0c9
  Host: <fqdn_host_name>
  Referer: https://<fqdn_host_name>/network/software/channels/manage/packages/compare/sync_confirm.pxt?set_label=packages_for_merge&sync_type=full_sync&view_channel=channel_198&cid=218
  User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.2) Gecko/20100101 Firefox/10.0.2
  X-ClickOnceSupport: ( .NET CLR 3.5.30729; .NET4.0E)

Form variables:
  alphabar_column =>
  cid => 218
  first_lower => 1
  first_upper => 50
  formvars => set_label
  formvars => set_label
  formvars => set_label
  formvars => set_label
  formvars => set_label
  last_lower => 1
  last_upper => 1
  list_action_label_sync_packages_to_channel => Confirm
  list_action_url_sync_packages_to_channel => /rhn/channels/manage/ChannelPackages.do
  list_mode => sync_confirm_packages_in_set
  lower => 1
  next_lower => 1
  next_upper => 1
  prev_lower => 1
  prev_upper => 50
  pxt:trap => rhn:package_list_cb
  set_label => packages_for_merge
  sync_type => full_sync
  upper => 1
  view_channel => channel_198

User Information:
  User <a_user_name> (id 2, org_id 1)

Error notes:
  (none)

Initial Request:
  Yes

Error message:
  RHN::Exception: DBD::Pg::st execute failed: ERROR:  missing FROM-clause entry for table "rhn_repo_regen_queue_id_seq"
LINE 4: VALUES (rhn_repo_regen_queue_id_seq.nextval,
                ^
  RHN::DB /usr/share/perl5/vendor_perl/RHN/DB.pm 228 RHN::Exception::DB::throw
  RHN::DB::st /usr/share/perl5/vendor_perl/RHN/DB.pm 564 RHN::DB::handle_error
  RHN::DB::ChannelEditor /usr/share/perl5/vendor_perl/RHN/DB/ChannelEditor.pm 221 RHN::DB::st::execute_h
  Sniglets::ListView::PackageList /usr/share/perl5/vendor_perl/Sniglets/ListView/PackageList.pm 1917 RHN::DB::ChannelEditor::add_channel_packages
  Sniglets::ListView::PackageList /usr/share/perl5/vendor_perl/Sniglets/ListView/PackageList.pm 274 Sniglets::ListView::PackageList::sync_packages_to_channel_cb
  Sniglets::ListView::List /usr/share/perl5/vendor_perl/Sniglets/ListView/List.pm 374 Sniglets::ListView::PackageList::default_callback
  Sniglets::Lists /usr/share/perl5/vendor_perl/Sniglets/Lists.pm 135 Sniglets::ListView::List::callback
  PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 489 Sniglets::Lists::listview_cb
  PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 103 PXT::ApacheHandler::pxt_parse_data
  PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 103 (eval)
  main -e 0 PXT::ApacheHandler::handler
  main -e 0 (eval)

#--------------------------------------
no additional information in /var/log/httpd/error_log
#--------------------------------------