http_kill
Kill VSP process whose details match parameter inputs
http_kill
(in client_IP_address varchar,
in URL varchar,
[in process_request_id integer]);
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.
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.
Errors
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
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.