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
#--------------------------------------
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
