X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=src%2FWorker%2FCron.php;h=94f002805b4baf2974eb823e6e051833906e359a;hb=088a3b6bc429973381e6eb2931c6eacd5b8c8927;hp=90042e30f6631d039c7cdb72de6e8bd4f258cc74;hpb=9704a9bf25b8b072c2b25fd0655a989172c099a7;p=friendica.git

diff --git a/src/Worker/Cron.php b/src/Worker/Cron.php
index 90042e30f6..94f002805b 100644
--- a/src/Worker/Cron.php
+++ b/src/Worker/Cron.php
@@ -1,6 +1,6 @@
 <?php
 /**
- * @copyright Copyright (C) 2020, Friendica
+ * @copyright Copyright (C) 2010-2022, the Friendica project
  *
  * @license GNU AGPL version 3 or any later version
  *
@@ -24,8 +24,12 @@ namespace Friendica\Worker;
 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;
+use Friendica\Util\DateTimeFormat;
 
 class Cron
 {
@@ -54,77 +58,93 @@ 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($a->queue['priority'], 'cron');
+		Hook::fork(Worker::PRIORITY_MEDIUM, 'cron');
 
 		// Poll contacts
-		Worker::add(PRIORITY_MEDIUM, 'PollContacts');
+		Worker::add(Worker::PRIORITY_MEDIUM, 'PollContacts');
 
 		// Update contact information
-		Worker::add(PRIORITY_LOW, 'UpdatePublicContacts');		
+		Worker::add(Worker::PRIORITY_LOW, 'UpdateContacts');
+
+		// Update server information
+		Worker::add(Worker::PRIORITY_LOW, 'UpdateGServers');
 
 		// run the process to update server directories in the background
-		Worker::add(PRIORITY_LOW, 'UpdateServerDirectories');
+		Worker::add(Worker::PRIORITY_LOW, 'UpdateServerDirectories');
 
 		// Expire and remove user entries
-		Worker::add(PRIORITY_MEDIUM, 'ExpireAndRemoveUsers');
+		Worker::add(Worker::PRIORITY_MEDIUM, 'ExpireAndRemoveUsers');
 
 		// Call possible post update functions
-		Worker::add(PRIORITY_LOW, 'PostUpdate');
+		Worker::add(Worker::PRIORITY_LOW, 'PostUpdate');
 
 		// Hourly cron calls
 		if (DI::config()->get('system', 'last_cron_hourly', 0) + 3600 < time()) {
 
+
 			// Update trending tags cache for the community page
 			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');
+				Worker::add(Worker::PRIORITY_LOW, 'PullDirectory');
 			}
 
-			// Delete all done workerqueue entries			
-			Worker::add(PRIORITY_LOW, 'CleanWorkerQueue');
-
 			// Clear cache entries
-			Worker::add(PRIORITY_LOW, 'ClearCache');
+			Worker::add(Worker::PRIORITY_LOW, 'ClearCache');
 
 			DI::config()->set('system', 'last_cron_hourly', time());
 		}
 
-		// Daily cron calls
-		if (DI::config()->get('system', 'last_cron_daily', 0) + 86400 < time()) {
-
-			Worker::add(PRIORITY_LOW, 'UpdateContactBirthdays');
+		// Daily maintenance cron calls
+		if (Worker::isInMaintenanceWindow(true)) {
 
-			Worker::add(PRIORITY_LOW, 'UpdatePhotoAlbums');
+			Worker::add(Worker::PRIORITY_LOW, 'UpdateContactBirthdays');
 
-			// update nodeinfo data
-			Worker::add(PRIORITY_LOW, 'NodeInfo');
+			Worker::add(Worker::PRIORITY_LOW, 'UpdatePhotoAlbums');
 
-			Worker::add(PRIORITY_LOW, 'UpdateGServers');
+			Worker::add(Worker::PRIORITY_LOW, 'ExpirePosts');
 
-			// Repair entries in the database
-			Worker::add(PRIORITY_LOW, 'RepairDatabase');
+			Worker::add(Worker::PRIORITY_LOW, 'ExpireActivities');
 
-			Worker::add(PRIORITY_LOW, 'Expire');
+			Worker::add(Worker::PRIORITY_LOW, 'RemoveUnusedTags');
 
-			Worker::add(PRIORITY_LOW, 'ExpirePosts');
+			Worker::add(Worker::PRIORITY_LOW, 'RemoveUnusedContacts');
 
-			Worker::add(PRIORITY_LOW, 'ExpireConversations');
-
-			Worker::add(PRIORITY_LOW, 'CleanItemUri');
+			Worker::add(Worker::PRIORITY_LOW, 'RemoveUnusedAvatars');
 
 			// check upstream version?
-			Worker::add(PRIORITY_LOW, 'CheckVersion');
+			Worker::add(Worker::PRIORITY_LOW, 'CheckVersion');
+
+			Worker::add(Worker::PRIORITY_LOW, 'CheckDeletedContacts');
 
-			Worker::add(PRIORITY_LOW, 'CheckDeletedContacts');
+			Worker::add(Worker::PRIORITY_LOW, 'UpdateAllSuggestions');
 
 			if (DI::config()->get('system', 'optimize_tables')) {
-				Worker::add(PRIORITY_LOW, 'OptimizeTables');
+				Worker::add(Worker::PRIORITY_LOW, 'OptimizeTables');
 			}
+
+			$users = DBA::select('owner-view', ['uid'], ["`homepage_verified` OR (`last-activity` > ? AND `homepage` != ?)", DateTimeFormat::utc('now - 7 days', 'Y-m-d'), '']);
+			while ($user = DBA::fetch($users)) {
+				Worker::add(Worker::PRIORITY_LOW, 'CheckRelMeProfileLink', $user['uid']);
+			}
+			DBA::close($users);
 	
+			// Resubscribe to relay servers
+			Relay::reSubscribe();
+
 			DI::config()->set('system', 'last_cron_daily', time());
 		}
 
@@ -132,4 +152,25 @@ class Cron
 
 		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);
+	}
 }