Name

http_kill — Kill VSP process whose details match parameter inputs

Synopsis

http_kill ( in client_IP_address varchar ,
  in URL varchar ,
  in process_request_id integer );
 

Description

This function requires dba privileges.

This function is used to kill the process whose details match that of the input parameters. If Client's IP and URL are specified, then it will try to kill all matching pending HTTP requests for that peer requesting that URL. If all three parameters are given, then it will try to kill only that pending HTTP request.

Parameters

client_IP_address

Client's IP as per the output of http_pending_req()

URL

Process' URL as per the output of http_pending_req()

process_request_id

The task ID of the request.

Errors

Table 24.41. Errors signalled by http_kill

SQLState Error Code Error Text Description
42000 SR159 Function http_kill restricted to dba group  
22023 SR014 Function http_kill needs a string as argument 1, not an arg of type %s  
22023 SR014 Function http_kill needs a string as argument 2, not an arg of type %s  
22023 SR014 Function http_kill needs a string as argument 3, not an arg of type %s  

Examples

Example 24.166. Retrieving a list of VSP processes

declare ps any;

ps := http_pending_req ();

-- the ps value is (('127.0.0.1', '/long.vsp', 1234567), ('192.168.1.1', '/long.vsp', 345678))

http_kill ('192.168.1.1', '/long.vsp', 345678);

after this and calling http_pending_req() again we get (('127.0.0.1', '/long.vsp', 1234567)) only.