From aef035034639211587bda9b98ba46514dac409a4 Mon Sep 17 00:00:00 2001 From: Mario Date: Wed, 5 May 2021 09:15:02 +0000 Subject: remove duplicate singletons hublocs once a day --- include/hubloc.php | 3 +++ 1 file changed, 3 insertions(+) (limited to 'include/hubloc.php') diff --git a/include/hubloc.php b/include/hubloc.php index 94d1af5f0..2cce7a725 100644 --- a/include/hubloc.php +++ b/include/hubloc.php @@ -175,8 +175,11 @@ function remove_obsolete_hublocs() { /** * @brief Remove duplicate singleton hublocs * + * This should not actually happen but it appears it does - probably due to race conditions. * This function will just leave the hubloc with the highest id (latest) * + * TODO: we should probably do something about that at the DB level. + * */ function remove_duplicate_singleton_hublocs() { $hublocs = dbq("SELECT hubloc_hash, COUNT(hubloc_hash) FROM hubloc WHERE -- cgit v1.2.3