3 * @file src/Model/Queue.php
5 namespace Friendica\Model;
7 use Friendica\Core\Config;
8 use Friendica\Core\Logger;
9 use Friendica\Database\DBA;
10 use Friendica\Util\DateTimeFormat;
12 require_once 'include/dba.php';
17 * @param string $id id
19 public static function updateTime($id)
21 Logger::log('queue: requeue item ' . $id);
22 $queue = DBA::selectFirst('queue', ['retrial'], ['id' => $id]);
23 if (!DBA::isResult($queue)) {
27 $retrial = $queue['retrial'];
30 self::removeItem($id);
33 // Calculate the delay until the next trial
34 $delay = (($retrial + 3) ** 4) + (rand(1, 30) * ($retrial + 1));
35 $next = DateTimeFormat::utc('now + ' . $delay . ' seconds');
37 DBA::update('queue', ['last' => DateTimeFormat::utcNow(), 'retrial' => $retrial + 1, 'next' => $next], ['id' => $id]);
41 * @param string $id id
43 public static function removeItem($id)
45 Logger::log('queue: remove queue item ' . $id);
46 DBA::delete('queue', ['id' => $id]);
50 * @brief Checks if the communication with a given contact had problems recently
52 * @param int $cid Contact id
54 * @return bool The communication with this contact has currently problems
56 public static function wasDelayed($cid)
58 // Are there queue entries that were recently added?
59 $r = q("SELECT `id` FROM `queue` WHERE `cid` = %d
60 AND `last` > UTC_TIMESTAMP() - INTERVAL 15 MINUTE LIMIT 1",
64 $was_delayed = DBA::isResult($r);
66 // We set "term-date" to a current date if the communication has problems.
67 // If the communication works again we reset this value.
69 $r = q("SELECT `term-date` FROM `contact` WHERE `id` = %d AND `term-date` <= '1000-01-01' LIMIT 1",
72 $was_delayed = !DBA::isResult($r);
79 * @param string $cid cid
80 * @param string $network network
81 * @param string $msg message
82 * @param boolean $batch batch, default false
84 public static function add($cid, $network, $msg, $batch = false, $guid = '')
87 $max_queue = Config::get('system', 'max_contact_queue');
92 $batch_queue = Config::get('system', 'max_batch_queue');
93 if ($batch_queue < 1) {
97 $r = q("SELECT COUNT(*) AS `total` FROM `queue` INNER JOIN `contact` ON `queue`.`cid` = `contact`.`id`
98 WHERE `queue`.`cid` = %d AND `contact`.`self` = 0 ",
102 if (DBA::isResult($r)) {
103 if ($batch && ($r[0]['total'] > $batch_queue)) {
104 Logger::log('too many queued items for batch server ' . $cid . ' - discarding message');
106 } elseif ((! $batch) && ($r[0]['total'] > $max_queue)) {
107 Logger::log('too many queued items for contact ' . $cid . ' - discarding message');
112 DBA::insert('queue', [
114 'network' => $network,
116 'created' => DateTimeFormat::utcNow(),
117 'last' => DateTimeFormat::utcNow(),
119 'batch' =>($batch) ? 1 : 0
121 Logger::log('Added item ' . $guid . ' for ' . $cid);