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.40. 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.