<?php
/**
- * @copyright Copyright (C) 2020, Friendica
+ * @copyright Copyright (C) 2010-2022, the Friendica project
*
* @license GNU AGPL version 3 or any later version
*
use Friendica\Core\Hook;
use Friendica\Core\Logger;
use Friendica\Core\Worker;
+use Friendica\Database\DBA;
use Friendica\DI;
use Friendica\Model\Tag;
+use Friendica\Protocol\ActivityPub\Queue;
+use Friendica\Protocol\Relay;
class Cron
{
copy($basepath . '/.htaccess-dist', $basepath . '/.htaccess');
}
+ if (DI::config()->get('system', 'delete_sleeping_processes')) {
+ self::deleteSleepingProcesses();
+ }
+
// Fork the cron jobs in separate parts to avoid problems when one of them is crashing
Hook::fork(PRIORITY_MEDIUM, 'cron');
Tag::setLocalTrendingHashtags(24, 20);
Tag::setGlobalTrendingHashtags(24, 20);
+ // Remove old pending posts from the queue
+ Queue::clear();
+
+ // Process all unprocessed entries
+ Queue::processAll();
+
// Search for new contacts in the directory
if (DI::config()->get('system', 'synchronize_directory')) {
Worker::add(PRIORITY_LOW, 'PullDirectory');
}
- // Delete all done workerqueue entries
- Worker::add(PRIORITY_LOW, 'CleanWorkerQueue');
-
// Clear cache entries
Worker::add(PRIORITY_LOW, 'ClearCache');
Worker::add(PRIORITY_LOW, 'UpdatePhotoAlbums');
- // update nodeinfo data
- Worker::add(PRIORITY_LOW, 'NodeInfo');
-
- // Repair entries in the database
- Worker::add(PRIORITY_LOW, 'RepairDatabase');
-
- Worker::add(PRIORITY_LOW, 'Expire');
-
Worker::add(PRIORITY_LOW, 'ExpirePosts');
- Worker::add(PRIORITY_LOW, 'ExpireConversations');
+ Worker::add(PRIORITY_LOW, 'ExpireActivities');
- Worker::add(PRIORITY_LOW, 'CleanItemUri');
+ Worker::add(PRIORITY_LOW, 'RemoveUnusedTags');
Worker::add(PRIORITY_LOW, 'RemoveUnusedContacts');
+ Worker::add(PRIORITY_LOW, 'RemoveUnusedAvatars');
+
// check upstream version?
Worker::add(PRIORITY_LOW, 'CheckVersion');
if (DI::config()->get('system', 'optimize_tables')) {
Worker::add(PRIORITY_LOW, 'OptimizeTables');
}
-
+
+ // Resubscribe to relay servers
+ Relay::reSubscribe();
+
DI::config()->set('system', 'last_cron_daily', time());
}
DI::config()->set('system', 'last_cron', time());
}
+
+ /**
+ * Kill sleeping database processes
+ *
+ * @return void
+ */
+ private static function deleteSleepingProcesses()
+ {
+ Logger::info('Looking for sleeping processes');
+
+ $processes = DBA::p("SHOW FULL PROCESSLIST");
+ while ($process = DBA::fetch($processes)) {
+ if (($process['Command'] != 'Sleep') || ($process['Time'] < 300) || ($process['db'] != DBA::databaseName())) {
+ continue;
+ }
+
+ DBA::e("KILL ?", $process['Id']);
+ Logger::notice('Killed sleeping process', ['id' => $process['Id']]);
+ }
+ DBA::close($processes);
+ }
}