Bug 859330

Description of problem:


Version-Release number of selected component (if applicable):

Spacewalk-1.7 

How reproducible:
Every time



Steps to Reproduce:
1. In spacewalk gui, navigate to Systems>System Name>Provisioning>Snapshot>Snapshot Tags>Create New System Tag>Enter Tag name>Tag Current Snapshot

  
Actual results:
Server gives 500 execption and emails log:
The following exception occurred while executing this request:
 POST /network/systems/details/history/snapshots/add_system_tag.pxt HTTP/1.1 (from browser)  /network/systems/details/history/snapshots/add_system_tag.pxt (from Apache)

Date:
  Fri Sep 21 17:19:51 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: 59
  Content-Type: application/x-www-form-urlencoded
  Cookie: pxt-session-cookie=25195x0c1dfb9e64e4ab61a47b7dfc0ee23250
  Host: spacewalk
  Referer: https://spacewalk/network/systems/details/history/snapshots/add_system_tag.pxt?sid=1000010201
  User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:15.0) Gecko/20100101 Firefox/15.0.1

Form variables:
  pxt:trap => rhn:add_system_tag_cb
  sid => 1000010201
  tag => Hello

User Information:
  User AWickhaPa (id 112, org_id 1)

Error notes:
  (none)

Initial Request:
  Yes

Error message:
  RHN::Exception: DBD::Pg::st execute failed: ERROR:  function quote_literal(numeric, unknown) does not exist at character 120
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
QUERY:  SELECT  pg_dblink_exec( 'insert into rhnTag(id, org_id, name_id) values (' ||  $1  || ', ' ||  $2  || ', ' || coalesce(quote_literal(lookup_tag_name( $3 ), 'NULL')) || ')')
CONTEXT:  PL/pgSQL function "lookup_tag" line 13 at PERFORM SQL statement "insert into rhnSnapshotTag (snapshot_id, server_id, tag_id) select  $1 , server_id, lookup_tag( $2 ,  $3 ) from rhnSnapshot where id =  $1 "
PL/pgSQL function "tag_snapshot" line 2 at SQL statement

  RHN::DB /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 121 RHN::Exception::DB::throw
  RHN::DB::db /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 355 RHN::DB::handle_error
  RHN::DB::db /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm 319 RHN::DB::db::call_function
  RHN::DB::SystemSnapshot /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/SystemSnapshot.pm 233 RHN::DB::db::call_procedure
  RHN::DB::Server /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB/Server.pm 454 RHN::DB::SystemSnapshot::add_tag_to_snapshot
  Sniglets::Snapshot /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/Snapshot.pm 247 RHN::DB::Server::add_system_tag
  Sniglets::Snapshot /usr/lib/perl5/vendor_perl/5.8.8/Sniglets/Snapshot.pm 246 (eval)
  PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 482 Sniglets::Snapshot::add_system_tag_cb
  PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 103 PXT::ApacheHandler::pxt_parse_data
  PXT::ApacheHandler /usr/lib/perl5/vendor_perl/5.8.8/PXT/ApacheHandler.pm 103 (eval)
  main -e 0 PXT::ApacheHandler::handler
  main -e 0 (eval)



Expected results:
Current Snapshot is tagged

Additional info:

Also unable to delete snapshots:

The following exception occurred while executing this request:
 POST /network/systems/details/history/snapshots/remove_confirm.pxt HTTP/1.1 (from browser)  /network/systems/details/history/snapshots/remove_confirm.pxt (from Apache)

Date:
  Fri Sep 21 17:12:28 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: 485
  Content-Type: application/x-www-form-urlencoded
  Cookie: pxt-session-cookie=25195x0c1dfb9e64e4ab61a47b7dfc0ee23250
  Host: spacewalk
  Referer: https://spacewalk/network/systems/details/history/snapshots/remove_confirm.pxt?sid=1000010201&set_label=removable_snapshot_tag_list
  User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:15.0) Gecko/20100101 Firefox/15.0.1

Form variables:
  alphabar_column =>
  first_lower => 1
  first_upper => 25
  formvars => set_label
  formvars => set_label
  formvars => set_label
  last_lower => 1
  last_upper => 1
  list_action_label_confirm_snapshot_tag_removal => Confirm
  list_action_url_confirm_snapshot_tag_removal => /network/systems/details/history/snapshots/system_tags.pxt
  list_mode => snapshot_tags_in_set
  lower => 1
  next_lower => 1
  next_upper => 1
  prev_lower => 1
  prev_upper => 25
  pxt:trap => rhn:general_list_cb
  set_label => removable_snapshot_tag_list
  sid => 1000010201
  upper => 1

User Information:
  User AWickhaPa (id 112, org_id 1)

Error notes:
  (none)

Initial Request:
  Yes

Error message:
  Please use DBI functions for transaction handling at /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/DBD/Pg.pm line 190.