[Spacewalk-list] creating a snapshot tag fails

Evan Frey efrey2 at optonline.net
Tue Oct 16 15:45:15 UTC 2012


Every time we try to create a snapshot tag it fails with the following 
error:

RHN::Exception: DBD::Pg::st execute failed: ERROR:  function 
quote_literal(numeric, unknown) does not exist LINE 1: ...es (' ||  $1 
|| ', ' ||  $2  || ', ' || coalesce(quote_lite...
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/share/perl5/vendor_perl/RHN/DB.pm 121 
RHN::Exception::DB::throw
   RHN::DB::db /usr/share/perl5/vendor_perl/RHN/DB.pm 355 
RHN::DB::handle_error
   RHN::DB::db /usr/share/perl5/vendor_perl/RHN/DB.pm 319 
RHN::DB::db::call_function
   RHN::DB::SystemSnapshot 
/usr/share/perl5/vendor_perl/RHN/DB/SystemSnapshot.pm 233 
RHN::DB::db::call_procedure
   RHN::DB::Server /usr/share/perl5/vendor_perl/RHN/DB/Server.pm 454 
RHN::DB::SystemSnapshot::add_tag_to_snapshot
   Sniglets::Snapshot /usr/share/perl5/vendor_perl/Sniglets/Snapshot.pm 
247 RHN::DB::Server::add_system_tag
   Sniglets::Snapshot /usr/share/perl5/vendor_perl/Sniglets/Snapshot.pm 
246 (eval)
   PXT::ApacheHandler /usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 
482 Sniglets::Snapshot::add_system_tag_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)

this occurs both from the gui and the api.  We are running version 1.7 
on x86_64 with the postgresql backend.  Any ideas on how to address 
this?

Regards

Evan




More information about the Spacewalk-list mailing list