]> git.mxchange.org Git - friendica.git/blobdiff - src/Core/Worker.php
Don't show the connect link in the profile on the "follow" page
[friendica.git] / src / Core / Worker.php
index 19a74aa4f50fdbd77593d051894e82a2b290eeb9..760b40b1d30eb19adb742d85b8077fe385d5e730 100644 (file)
@@ -1,24 +1,31 @@
 <?php
+/**
+ * @file src/Core/Worker.php
+ */
 namespace Friendica\Core;
 
 use Friendica\App;
 use Friendica\Core\System;
 use Friendica\Core\Config;
+use Friendica\Core\Worker;
+use Friendica\Database\DBM;
 use Friendica\Util\Lock;
 
 use dba;
-use dbm;
+
+require_once 'include/dba.php';
 
 /**
- * @file include/Core/Worker.php
+ * @file src/Core/Worker.php
  *
- * @brief Contains the class for all worker relevant stuff
+ * @brief Contains the class for the worker background job processing
  */
 
 /**
  * @brief Worker methods
  */
-class Worker {
+class Worker
+{
        private static $up_start;
        private static $db_duration;
        private static $last_update;
@@ -28,8 +35,10 @@ class Worker {
         * @brief Processes the tasks that are in the workerqueue table
         *
         * @param boolean $run_cron Should the cron processes be executed?
+        * @return void
         */
-       public static function processQueue($run_cron = true) {
+       public static function processQueue($run_cron = true)
+       {
                $a = get_app();
 
                self::$up_start = microtime(true);
@@ -83,12 +92,11 @@ class Worker {
 
                // We fetch the next queue entry that is about to be executed
                while ($r = self::workerProcess($passing_slow)) {
-
                        // When we are processing jobs with a lower priority, we don't refetch new jobs
                        // Otherwise fast jobs could wait behind slow ones and could be blocked.
                        $refetched = $passing_slow;
 
-                       foreach ($r AS $entry) {
+                       foreach ($r as $entry) {
                                // Assure that the priority is an integer value
                                $entry['priority'] = (int)$entry['priority'];
 
@@ -107,7 +115,7 @@ class Worker {
                                }
                        }
 
-                       // To avoid the quitting of multiple pollers only one poller at a time will execute the check
+                       // To avoid the quitting of multiple workers only one worker at a time will execute the check
                        if (Lock::set('poller_worker', 0)) {
                                $stamp = (float)microtime(true);
                                // Count active workers and compare them with a maximum value that depends on the load
@@ -125,7 +133,7 @@ class Worker {
                                self::$db_duration += (microtime(true) - $stamp);
                        }
 
-                       // Quit the poller once every 5 minutes
+                       // Quit the worker once every 5 minutes
                        if (time() > ($starttime + 300)) {
                                logger('Process lifetime reached, quitting.', LOGGER_DEBUG);
                                return;
@@ -139,10 +147,11 @@ class Worker {
         *
         * @return integer Number of non executed entries in the worker queue
         */
-       private static function totalEntries() {
-               $s = q("SELECT COUNT(*) AS `total` FROM `workerqueue` WHERE `executed` <= '%s' AND NOT `done`", dbesc(NULL_DATE));
-               if (dbm::is_result($s)) {
-                       return $s[0]["total"];
+       private static function totalEntries()
+       {
+               $s = dba::fetch_first("SELECT COUNT(*) AS `total` FROM `workerqueue` WHERE `executed` <= ? AND NOT `done`", NULL_DATE);
+               if (DBM::is_result($s)) {
+                       return $s["total"];
                } else {
                        return 0;
                }
@@ -151,12 +160,14 @@ class Worker {
        /**
         * @brief Returns the highest priority in the worker queue that isn't executed
         *
-        * @return integer Number of active poller processes
+        * @return integer Number of active worker processes
         */
-       private static function highestPriority() {
-               $s = q("SELECT `priority` FROM `workerqueue` WHERE `executed` <= '%s' AND NOT `done` ORDER BY `priority` LIMIT 1", dbesc(NULL_DATE));
-               if (dbm::is_result($s)) {
-                       return $s[0]["priority"];
+       private static function highestPriority()
+       {
+               $condition = array("`executed` <= ? AND NOT `done`", NULL_DATE);
+               $s = dba::select('workerqueue', array('priority'), $condition, array('limit' => 1, 'order' => array('priority')));
+               if (DBM::is_result($s)) {
+                       return $s["priority"];
                } else {
                        return 0;
                }
@@ -169,10 +180,10 @@ class Worker {
         *
         * @return integer Is there a process running with that priority?
         */
-       private static function processWithPriorityActive($priority) {
-               $s = q("SELECT `id` FROM `workerqueue` WHERE `priority` <= %d AND `executed` > '%s' AND NOT `done` LIMIT 1",
-                               intval($priority), dbesc(NULL_DATE));
-               return dbm::is_result($s);
+       private static function processWithPriorityActive($priority)
+       {
+               $condition = array("`priority` <= ? AND `executed` > ? AND NOT `done`", $priority, NULL_DATE);
+               return dba::exists('workerqueue', $condition);
        }
 
        /**
@@ -182,7 +193,8 @@ class Worker {
         *
         * @return boolean "true" if further processing should be stopped
         */
-       public static function execute($queue) {
+       public static function execute($queue)
+       {
                $a = get_app();
 
                $mypid = getmypid();
@@ -210,9 +222,37 @@ class Worker {
                // Check for existance and validity of the include file
                $include = $argv[0];
 
+               if (method_exists(sprintf('Friendica\Worker\%s', $include), 'execute')) {
+                       // We constantly update the "executed" date every minute to avoid being killed too soon
+                       if (!isset(self::$last_update)) {
+                               self::$last_update = strtotime($queue["executed"]);
+                       }
+
+                       $age = (time() - self::$last_update) / 60;
+                       self::$last_update = time();
+
+                       if ($age > 1) {
+                               $stamp = (float)microtime(true);
+                               dba::update('workerqueue', array('executed' => datetime_convert()), array('pid' => $mypid, 'done' => false));
+                               self::$db_duration += (microtime(true) - $stamp);
+                       }
+
+                       array_shift($argv);
+
+                       self::execFunction($queue, $include, $argv, true);
+
+                       $stamp = (float)microtime(true);
+                       if (dba::update('workerqueue', array('done' => true), array('id' => $queue["id"]))) {
+                               Config::set('system', 'last_poller_execution', datetime_convert());
+                       }
+                       self::$db_duration = (microtime(true) - $stamp);
+
+                       return true;
+               }
+
                // The script could be provided as full path or only with the function name
                if ($include == basename($include)) {
-                       $func = "include/".$include.".php";
+                       $include = "include/".$include.".php";
                }
 
                if (!validate_include($include)) {
@@ -221,12 +261,11 @@ class Worker {
                        return true;
                }
 
-               require_once($include);
+               require_once $include;
 
                $funcname = str_replace(".php", "", basename($argv[0]))."_run";
 
                if (function_exists($funcname)) {
-
                        // We constantly update the "executed" date every minute to avoid being killed too soon
                        if (!isset(self::$last_update)) {
                                self::$last_update = strtotime($queue["executed"]);
@@ -241,7 +280,7 @@ class Worker {
                                self::$db_duration += (microtime(true) - $stamp);
                        }
 
-                       self::execFunction($queue, $funcname, $argv);
+                       self::execFunction($queue, $funcname, $argv, false);
 
                        $stamp = (float)microtime(true);
                        if (dba::update('workerqueue', array('done' => true), array('id' => $queue["id"]))) {
@@ -259,11 +298,14 @@ class Worker {
        /**
         * @brief Execute a function from the queue
         *
-        * @param array $queue Workerqueue entry
-        * @param string $funcname name of the function
-        * @param array $argv Array of values to be passed to the function
+        * @param array   $queue       Workerqueue entry
+        * @param string  $funcname    name of the function
+        * @param array   $argv        Array of values to be passed to the function
+        * @param boolean $method_call boolean
+        * @return void
         */
-       private static function execFunction($queue, $funcname, $argv) {
+       private static function execFunction($queue, $funcname, $argv, $method_call)
+       {
                $a = get_app();
 
                $mypid = getmypid();
@@ -302,7 +344,11 @@ class Worker {
                // Reset global data to avoid interferences
                unset($_SESSION);
 
-               $funcname($argv, $argc);
+               if ($method_call) {
+                       call_user_func_array(sprintf('Friendica\Worker\%s::execute', $funcname), $argv);
+               } else {
+                       $funcname($argv, $argc);
+               }
 
                $a->process_id = $old_process_id;
                unset($a->queue);
@@ -316,10 +362,14 @@ class Worker {
                 * The execution time is the productive time.
                 * By changing parameters like the maximum number of workers we can check the effectivness.
                */
-               logger('DB: '.number_format(self::$db_duration, 2).
+               logger(
+                       'DB: '.number_format(self::$db_duration, 2).
                        ' - Lock: '.number_format(self::$lock_duration, 2).
                        ' - Rest: '.number_format($up_duration - self::$db_duration - self::$lock_duration, 2).
-                       ' - Execution: '.number_format($duration, 2), LOGGER_DEBUG);
+                       ' - Execution: '.number_format($duration, 2),
+                       LOGGER_DEBUG
+               );
+
                self::$lock_duration = 0;
 
                if ($duration > 3600) {
@@ -341,7 +391,7 @@ class Worker {
                        if (Config::get("rendertime", "callstack")) {
                                if (isset($a->callstack["database"])) {
                                        $o = "\nDatabase Read:\n";
-                                       foreach ($a->callstack["database"] AS $func => $time) {
+                                       foreach ($a->callstack["database"] as $func => $time) {
                                                $time = round($time, 3);
                                                if ($time > 0) {
                                                        $o .= $func.": ".$time."\n";
@@ -350,7 +400,7 @@ class Worker {
                                }
                                if (isset($a->callstack["database_write"])) {
                                        $o .= "\nDatabase Write:\n";
-                                       foreach ($a->callstack["database_write"] AS $func => $time) {
+                                       foreach ($a->callstack["database_write"] as $func => $time) {
                                                $time = round($time, 3);
                                                if ($time > 0) {
                                                        $o .= $func.": ".$time."\n";
@@ -359,7 +409,7 @@ class Worker {
                                }
                                if (isset($a->callstack["network"])) {
                                        $o .= "\nNetwork:\n";
-                                       foreach ($a->callstack["network"] AS $func => $time) {
+                                       foreach ($a->callstack["network"] as $func => $time) {
                                                $time = round($time, 3);
                                                if ($time > 0) {
                                                        $o .= $func.": ".$time."\n";
@@ -370,14 +420,18 @@ class Worker {
                                $o = '';
                        }
 
-                       logger("ID ".$queue["id"].": ".$funcname.": ".sprintf("DB: %s/%s, Net: %s, I/O: %s, Other: %s, Total: %s".$o,
-                               number_format($a->performance["database"] - $a->performance["database_write"], 2),
-                               number_format($a->performance["database_write"], 2),
-                               number_format($a->performance["network"], 2),
-                               number_format($a->performance["file"], 2),
-                               number_format($duration - ($a->performance["database"] + $a->performance["network"] + $a->performance["file"]), 2),
-                               number_format($duration, 2)),
-                               LOGGER_DEBUG);
+                       logger(
+                               "ID ".$queue["id"].": ".$funcname.": ".sprintf(
+                                       "DB: %s/%s, Net: %s, I/O: %s, Other: %s, Total: %s".$o,
+                                       number_format($a->performance["database"] - $a->performance["database_write"], 2),
+                                       number_format($a->performance["database_write"], 2),
+                                       number_format($a->performance["network"], 2),
+                                       number_format($a->performance["file"], 2),
+                                       number_format($duration - ($a->performance["database"] + $a->performance["network"] + $a->performance["file"]), 2),
+                                       number_format($duration, 2)
+                               ),
+                               LOGGER_DEBUG
+                       );
                }
 
                $cooldown = Config::get("system", "worker_cooldown", 0);
@@ -393,42 +447,39 @@ class Worker {
         *
         * @return bool Are more than 3/4 of the maximum connections used?
         */
-       private static function maxConnectionsReached() {
-
+       private static function maxConnectionsReached()
+       {
                // Fetch the max value from the config. This is needed when the system cannot detect the correct value by itself.
                $max = Config::get("system", "max_connections");
 
-               // Fetch the percentage level where the poller will get active
+               // Fetch the percentage level where the worker will get active
                $maxlevel = Config::get("system", "max_connections_level", 75);
 
                if ($max == 0) {
                        // the maximum number of possible user connections can be a system variable
-                       $r = q("SHOW VARIABLES WHERE `variable_name` = 'max_user_connections'");
-                       if (dbm::is_result($r)) {
-                               $max = $r[0]["Value"];
+                       $r = dba::fetch_first("SHOW VARIABLES WHERE `variable_name` = 'max_user_connections'");
+                       if (DBM::is_result($r)) {
+                               $max = $r["Value"];
                        }
                        // Or it can be granted. This overrides the system variable
-                       $r = q("SHOW GRANTS");
-                       if (dbm::is_result($r)) {
-                               foreach ($r AS $grants) {
-                                       $grant = array_pop($grants);
-                                       if (stristr($grant, "GRANT USAGE ON")) {
-                                               if (preg_match("/WITH MAX_USER_CONNECTIONS (\d*)/", $grant, $match)) {
-                                                       $max = $match[1];
-                                               }
+                       $r = dba::p('SHOW GRANTS');
+                       while ($grants = dba::fetch($r)) {
+                               $grant = array_pop($grants);
+                               if (stristr($grant, "GRANT USAGE ON")) {
+                                       if (preg_match("/WITH MAX_USER_CONNECTIONS (\d*)/", $grant, $match)) {
+                                               $max = $match[1];
                                        }
                                }
                        }
+                       dba::close($r);
                }
 
                // If $max is set we will use the processlist to determine the current number of connections
                // The processlist only shows entries of the current user
                if ($max != 0) {
-                       $r = q("SHOW PROCESSLIST");
-                       if (!dbm::is_result($r)) {
-                               return false;
-                       }
-                       $used = count($r);
+                       $r = dba::p('SHOW PROCESSLIST');
+                       $used = dba::num_rows($r);
+                       dba::close($r);
 
                        logger("Connection usage (user values): ".$used."/".$max, LOGGER_DEBUG);
 
@@ -442,19 +493,19 @@ class Worker {
 
                // We will now check for the system values.
                // This limit could be reached although the user limits are fine.
-               $r = q("SHOW VARIABLES WHERE `variable_name` = 'max_connections'");
-               if (!dbm::is_result($r)) {
+               $r = dba::fetch_first("SHOW VARIABLES WHERE `variable_name` = 'max_connections'");
+               if (!DBM::is_result($r)) {
                        return false;
                }
-               $max = intval($r[0]["Value"]);
+               $max = intval($r["Value"]);
                if ($max == 0) {
                        return false;
                }
-               $r = q("SHOW STATUS WHERE `variable_name` = 'Threads_connected'");
-               if (!dbm::is_result($r)) {
+               $r = dba::fetch_first("SHOW STATUS WHERE `variable_name` = 'Threads_connected'");
+               if (!DBM::is_result($r)) {
                        return false;
                }
-               $used = intval($r[0]["Value"]);
+               $used = intval($r["Value"]);
                if ($used == 0) {
                        return false;
                }
@@ -471,16 +522,24 @@ class Worker {
 
        /**
         * @brief fix the queue entry if the worker process died
-        *
+        * @return void
         */
-       private static function killStaleWorkers() {
-               $entries = dba::select('workerqueue', array('id', 'pid', 'executed', 'priority', 'parameter'),
-                                       array('`executed` > ? AND NOT `done` AND `pid` != 0', NULL_DATE),
-                                       array('order' => array('priority', 'created')));
+       private static function killStaleWorkers()
+       {
+               $entries = dba::select(
+                       'workerqueue',
+                       array('id', 'pid', 'executed', 'priority', 'parameter'),
+                       array('`executed` > ? AND NOT `done` AND `pid` != 0', NULL_DATE),
+                       array('order' => array('priority', 'created'))
+               );
+
                while ($entry = dba::fetch($entries)) {
                        if (!posix_kill($entry["pid"], 0)) {
-                               dba::update('workerqueue', array('executed' => NULL_DATE, 'pid' => 0),
-                                               array('id' => $entry["id"]));
+                               dba::update(
+                                       'workerqueue',
+                                       array('executed' => NULL_DATE, 'pid' => 0),
+                                       array('id' => $entry["id"])
+                               );
                        } else {
                                // Kill long running processes
                                // Check if the priority is in a valid range
@@ -511,9 +570,11 @@ class Worker {
                                        } elseif ($entry["priority"] != PRIORITY_CRITICAL) {
                                                $new_priority = PRIORITY_NEGLIGIBLE;
                                        }
-                                       dba::update('workerqueue',
-                                                       array('executed' => NULL_DATE, 'created' => datetime_convert(), 'priority' => $new_priority, 'pid' => 0),
-                                                       array('id' => $entry["id"]));
+                                       dba::update(
+                                               'workerqueue',
+                                               array('executed' => NULL_DATE, 'created' => datetime_convert(), 'priority' => $new_priority, 'pid' => 0),
+                                               array('id' => $entry["id"])
+                                       );
                                } else {
                                        logger("Worker process ".$entry["pid"]." (".implode(" ", $argv).") now runs for ".round($duration)." of ".$max_duration." allowed minutes. That's okay.", LOGGER_DEBUG);
                                }
@@ -526,7 +587,8 @@ class Worker {
         *
         * @return bool Are there too much workers running?
         */
-       public static function tooMuchWorkers() {
+       public static function tooMuchWorkers()
+       {
                $queues = Config::get("system", "worker_queues", 4);
 
                $maxqueues = $queues;
@@ -550,9 +612,13 @@ class Worker {
                                $listitem = array();
 
                                // Adding all processes with no workerqueue entry
-                               $processes = dba::p("SELECT COUNT(*) AS `running` FROM `process` WHERE NOT EXISTS
+                               $processes = dba::p(
+                                       "SELECT COUNT(*) AS `running` FROM `process` WHERE NOT EXISTS
                                                        (SELECT id FROM `workerqueue`
-                                                       WHERE `workerqueue`.`pid` = `process`.`pid` AND NOT `done` AND `pid` != ?)", getmypid());
+                                                       WHERE `workerqueue`.`pid` = `process`.`pid` AND NOT `done` AND `pid` != ?)",
+                                       getmypid()
+                               );
+
                                if ($process = dba::fetch($processes)) {
                                        $listitem[0] = "0:".$process["running"];
                                }
@@ -571,7 +637,7 @@ class Worker {
 
                                $intervals = array(1, 10, 60);
                                $jobs_per_minute = array();
-                               foreach ($intervals AS $interval) {
+                               foreach ($intervals as $interval) {
                                        $jobs = dba::p("SELECT COUNT(*) AS `jobs` FROM `workerqueue` WHERE `done` AND `executed` > UTC_TIMESTAMP() - INTERVAL ".intval($interval)." MINUTE");
                                        if ($job = dba::fetch($jobs)) {
                                                $jobs_per_minute[$interval] = number_format($job['jobs'] / $interval, 0);
@@ -598,8 +664,7 @@ class Worker {
                        // Are there fewer workers running as possible? Then fork a new one.
                        if (!Config::get("system", "worker_dont_fork") && ($queues > ($active + 1)) && ($entries > 1)) {
                                logger("Active workers: ".$active."/".$queues." Fork a new worker.", LOGGER_DEBUG);
-                               $args = array("include/poller.php", "no_cron");
-                               get_app()->proc_run($args);
+                               self::spawnWorker();
                        }
                }
 
@@ -607,14 +672,15 @@ class Worker {
        }
 
        /**
-        * @brief Returns the number of active poller processes
+        * @brief Returns the number of active worker processes
         *
-        * @return integer Number of active poller processes
+        * @return integer Number of active worker processes
         */
-       private static function activeWorkers() {
-               $workers = q("SELECT COUNT(*) AS `processes` FROM `process` WHERE `command` = 'poller.php'");
+       private static function activeWorkers()
+       {
+               $workers = dba::fetch_first("SELECT COUNT(*) AS `processes` FROM `process` WHERE `command` = 'Worker.php'");
 
-               return $workers[0]["processes"];
+               return $workers["processes"];
        }
 
        /**
@@ -626,22 +692,26 @@ class Worker {
         * @param string $highest_priority Returns the currently highest priority
         * @return bool We let pass a slower process than $highest_priority
         */
-       private static function passingSlow(&$highest_priority) {
-
+       private static function passingSlow(&$highest_priority)
+       {
                $highest_priority = 0;
 
-               $r = q("SELECT `priority`
-                       FROM `process`
-                       INNER JOIN `workerqueue` ON `workerqueue`.`pid` = `process`.`pid` AND NOT `done`");
+               $r = dba::p(
+                       "SELECT `priority`
+                               FROM `process`
+                               INNER JOIN `workerqueue` ON `workerqueue`.`pid` = `process`.`pid` AND NOT `done`"
+               );
 
                // No active processes at all? Fine
-               if (!dbm::is_result($r)) {
+               if (!DBM::is_result($r)) {
                        return false;
                }
                $priorities = array();
-               foreach ($r AS $line) {
+               while ($line = dba::fetch($r)) {
                        $priorities[] = $line["priority"];
                }
+               dba::close($r);
+
                // Should not happen
                if (count($priorities) == 0) {
                        return false;
@@ -654,7 +724,7 @@ class Worker {
                        return false;
                }
                $high = 0;
-               foreach ($priorities AS $priority) {
+               foreach ($priorities as $priority) {
                        if ($priority == $highest_priority) {
                                ++$high;
                        }
@@ -674,7 +744,8 @@ class Worker {
         * @param boolean $passing_slow Returns if we had passed low priority processes
         * @return boolean Have we found something?
         */
-       private static function findWorkerProcesses(&$passing_slow) {
+       private static function findWorkerProcesses(&$passing_slow)
+       {
                $mypid = getmypid();
 
                // Check if we should pass some low priority process
@@ -698,8 +769,12 @@ class Worker {
 
                if (self::passingSlow($highest_priority)) {
                        // Are there waiting processes with a higher priority than the currently highest?
-                       $result = dba::select('workerqueue', array('id'), array("`executed` <= ? AND `priority` < ? AND NOT `done`", NULL_DATE, $highest_priority),
-                                       array('limit' => $limit, 'order' => array('priority', 'created'), 'only_query' => true));
+                       $result = dba::select(
+                               'workerqueue',
+                               array('id'),
+                               array("`executed` <= ? AND `priority` < ? AND NOT `done`", NULL_DATE, $highest_priority),
+                               array('limit' => $limit, 'order' => array('priority', 'created'), 'only_query' => true)
+                       );
 
                        while ($id = dba::fetch($result)) {
                                $ids[] = $id["id"];
@@ -710,8 +785,12 @@ class Worker {
 
                        if (!$found) {
                                // Give slower processes some processing time
-                               $result = dba::select('workerqueue', array('id'), array("`executed` <= ? AND `priority` > ? AND NOT `done`", NULL_DATE, $highest_priority),
-                                               array('limit' => $limit, 'order' => array('priority', 'created'), 'only_query' => true));
+                               $result = dba::select(
+                                       'workerqueue',
+                                       array('id'),
+                                       array("`executed` <= ? AND `priority` > ? AND NOT `done`", NULL_DATE, $highest_priority),
+                                       array('limit' => $limit, 'order' => array('priority', 'created'), 'only_query' => true)
+                               );
 
                                while ($id = dba::fetch($result)) {
                                        $ids[] = $id["id"];
@@ -725,8 +804,12 @@ class Worker {
 
                // If there is no result (or we shouldn't pass lower processes) we check without priority limit
                if (!$found) {
-                       $result = dba::select('workerqueue', array('id'), array("`executed` <= ? AND NOT `done`", NULL_DATE),
-                                       array('limit' => $limit, 'order' => array('priority', 'created'), 'only_query' => true));
+                       $result = dba::select(
+                               'workerqueue',
+                               array('id'),
+                               array("`executed` <= ? AND NOT `done`", NULL_DATE),
+                               array('limit' => $limit, 'order' => array('priority', 'created'), 'only_query' => true)
+                       );
 
                        while ($id = dba::fetch($result)) {
                                $ids[] = $id["id"];
@@ -751,15 +834,17 @@ class Worker {
         * @param boolean $passing_slow Returns if we had passed low priority processes
         * @return string SQL statement
         */
-       public static function workerProcess(&$passing_slow) {
+       public static function workerProcess(&$passing_slow)
+       {
                $stamp = (float)microtime(true);
 
                // There can already be jobs for us in the queue.
-               $r = q("SELECT * FROM `workerqueue` WHERE `pid` = %d AND NOT `done`", intval(getmypid()));
-               if (dbm::is_result($r)) {
+               $r = dba::select('workerqueue', array(), array('pid' => getmypid(), 'done' => false));
+               if (DBM::is_result($r)) {
                        self::$db_duration += (microtime(true) - $stamp);
-                       return $r;
+                       return dba::inArray($r);
                }
+               dba::close($r);
 
                $stamp = (float)microtime(true);
                if (!Lock::set('poller_worker_process')) {
@@ -774,15 +859,18 @@ class Worker {
                Lock::remove('poller_worker_process');
 
                if ($found) {
-                       $r = q("SELECT * FROM `workerqueue` WHERE `pid` = %d AND NOT `done`", intval(getmypid()));
+                       $r = dba::select('workerqueue', array(), array('pid' => getmypid(), 'done' => false));
+                       return dba::inArray($r);
                }
-               return $r;
+               return false;
        }
 
        /**
         * @brief Removes a workerqueue entry from the current process
+        * @return void
         */
-       public static function unclaimProcess() {
+       public static function unclaimProcess()
+       {
                $mypid = getmypid();
 
                dba::update('workerqueue', array('executed' => NULL_DATE, 'pid' => 0), array('pid' => $mypid, 'done' => false));
@@ -790,8 +878,10 @@ class Worker {
 
        /**
         * @brief Call the front end worker
+        * @return void
         */
-       public static function callWorker() {
+       public static function callWorker()
+       {
                if (!Config::get("system", "frontend_worker")) {
                        return;
                }
@@ -802,13 +892,15 @@ class Worker {
 
        /**
         * @brief Call the front end worker if there aren't any active
+        * @return void
         */
-       public static function executeIfIdle() {
+       public static function executeIfIdle()
+       {
                if (!Config::get("system", "frontend_worker")) {
                        return;
                }
 
-               // Do we have "proc_open"? Then we can fork the poller
+               // Do we have "proc_open"? Then we can fork the worker
                if (function_exists("proc_open")) {
                        // When was the last time that we called the worker?
                        // Less than one minute? Then we quit
@@ -816,7 +908,7 @@ class Worker {
                                return;
                        }
 
-                       set_config("system", "worker_started", time());
+                       Config::set("system", "worker_started", time());
 
                        // Do we have enough running workers? Then we quit here.
                        if (self::tooMuchWorkers()) {
@@ -829,10 +921,8 @@ class Worker {
 
                        self::runCron();
 
-                       logger('Call poller', LOGGER_DEBUG);
-
-                       $args = array("include/poller.php", "no_cron");
-                       get_app()->proc_run($args);
+                       logger('Call worker', LOGGER_DEBUG);
+                       self::spawnWorker();
                        return;
                }
 
@@ -843,51 +933,65 @@ class Worker {
 
                self::clearProcesses();
 
-               $workers = q("SELECT COUNT(*) AS `processes` FROM `process` WHERE `command` = 'worker.php'");
+               $workers = dba::fetch_first("SELECT COUNT(*) AS `processes` FROM `process` WHERE `command` = 'worker.php'");
 
-               if ($workers[0]["processes"] == 0) {
+               if ($workers["processes"] == 0) {
                        self::callWorker();
                }
        }
 
        /**
         * @brief Removes long running worker processes
+        * @return void
         */
-       public static function clearProcesses() {
+       public static function clearProcesses()
+       {
                $timeout = Config::get("system", "frontend_worker_timeout", 10);
 
                /// @todo We should clean up the corresponding workerqueue entries as well
-               q("DELETE FROM `process` WHERE `created` < '%s' AND `command` = 'worker.php'",
-                       dbesc(datetime_convert('UTC','UTC',"now - ".$timeout." minutes")));
+               $condition = array("`created` < ? AND `command` = 'worker.php'",
+                               datetime_convert('UTC', 'UTC', "now - ".$timeout." minutes"));
+               dba::delete('process', $condition);
        }
 
        /**
         * @brief Runs the cron processes
+        * @return void
         */
-       private static function runCron() {
+       private static function runCron()
+       {
                logger('Add cron entries', LOGGER_DEBUG);
 
                // Check for spooled items
-               self::add(PRIORITY_HIGH, "include/spool_post.php");
+               self::add(PRIORITY_HIGH, "SpoolPost");
 
                // Run the cron job that calls all other jobs
-               self::add(PRIORITY_MEDIUM, "include/cron.php");
+               self::add(PRIORITY_MEDIUM, "Cron");
 
                // Run the cronhooks job separately from cron for being able to use a different timing
-               self::add(PRIORITY_MEDIUM, "include/cronhooks.php");
+               self::add(PRIORITY_MEDIUM, "CronHooks");
 
                // Cleaning dead processes
                self::killStaleWorkers();
        }
 
+       /**
+        * @return void
+        */
+       public static function spawnWorker()
+       {
+               $args = array("scripts/worker.php", "no_cron");
+               get_app()->proc_run($args);
+       }
+
        /**
         * @brief Adds tasks to the worker queue
         *
-        * @param (integer|array) priority or parameter array, $cmd atrings are deprecated and are ignored
+        * @param (integer|array) priority or parameter array, strings are deprecated and are ignored
         *
         * next args are passed as $cmd command line
-        * or: Worker::add(PRIORITY_HIGH, "include/notifier.php", "drop", $drop_id);
-        * or: Worker::add(array('priority' => PRIORITY_HIGH, 'dont_fork' => true), "include/create_shadowentry.php", $post_id);
+        * or: Worker::add(PRIORITY_HIGH, "Notifier", "drop", $drop_id);
+        * or: Worker::add(array('priority' => PRIORITY_HIGH, 'dont_fork' => true), "CreateShadowEntry", $post_id);
         *
         * @note $cmd and string args are surrounded with ""
         *
@@ -896,9 +1000,8 @@ class Worker {
         *
         * @return boolean "false" if proc_run couldn't be executed
         */
-       public static function add($cmd) {
-               $a = get_app();
-
+       public static function add($cmd)
+       {
                $proc_args = func_get_args();
 
                $args = array();
@@ -933,7 +1036,7 @@ class Worker {
                }
 
                $priority = PRIORITY_MEDIUM;
-               $dont_fork = get_config("system", "worker_dont_fork");
+               $dont_fork = Config::get("system", "worker_dont_fork");
                $created = datetime_convert();
 
                if (is_int($run_parameter)) {
@@ -965,7 +1068,7 @@ class Worker {
                        dba::insert('workerqueue', array('parameter' => $parameters, 'created' => $created, 'priority' => $priority));
                }
 
-               // Should we quit and wait for the poller to be called as a cronjob?
+               // Should we quit and wait for the worker to be called as a cronjob?
                if ($dont_fork) {
                        return true;
                }
@@ -983,10 +1086,8 @@ class Worker {
                        return true;
                }
 
-               // Now call the poller to execute the jobs that we just added to the queue
-               $args = array("include/poller.php", "no_cron");
-
-               $a->proc_run($args);
+               // Now call the worker to execute the jobs that we just added to the queue
+               self::spawnWorker();
 
                return true;
        }