Database

DELIMITER $$
CREATE DEFINER='root'@'localhost' EVENT `db`.`kill_processes`

ON SCHEDULE EVERY 5 SECOND
ENABLE
DO
	BEGIN
	    DECLARE process_to_kill VARCHAR(25);
	    DECLARE done BOOLEAN DEFAULT FALSE;
	    DECLARE find_process CURSOR FOR
	    SELECT CONCAT('KILL ', `ID`, ';') FROM `information_schema`.`PROCESSLIST`
	    WHERE `information_schema`.`PROCESSLIST`.`USER` = 'some_user' AND
	    `information_schema`.`PROCESSLIST`.`COMMAND` = 'Sleep' AND
	    `information_schema`.`PROCESSLIST`.`TIME` > 90;
	    
	    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
	    
	    OPEN find_process;
	    
	    loop_process : LOOP
		FETCH find_process INTO process_to_kill;
		
		IF done THEN
			CLOSE find_process;
			LEAVE loop_process;
		END IF;
		
		SET @f_p = find_process;
		PREPARE stmt FROM @f_p;
		EXECUTE stmt;
		DEALLOCATE PREPARE stmt;
		
	    END LOOP loop_process;
	END$$

DELIMITER ;

An exception of type 'System.NullReferenceException' occurred in Version1.dll but was not handled in user code

An exception of type 'System.NullReferenceException' occurred in Version1.dll but was not handled in user code