hello sebastian,
thank you for your support!
i did run the maintenance commands as user “root”, but it did not help.
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 33
Server version: 10.3.22-MariaDB-0+deb10u1 Debian 10
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [fog]> DELETE FROM `hosts` WHERE `hostID` = '0';
Query OK, 0 rows affected (0.000 sec)
MariaDB [fog]> DELETE FROM `hostMAC` WHERE hmID = '0' OR `hmHostID` = '0';
Query OK, 0 rows affected (0.001 sec)
MariaDB [fog]> DELETE FROM `groupMembers` WHERE `gmID` = '0' OR `gmHostID` = '0' OR `gmGroupID` = '0';
Query OK, 2 rows affected (0.017 sec)
MariaDB [fog]> DELETE FROM `snapinGroupAssoc` WHERE `sgaID` = '0' OR `sgaSnapinID` = '0' OR `sgaStorageGroupID` = '0';
Query OK, 0 rows affected (0.000 sec)
MariaDB [fog]> DELETE from `snapinAssoc` WHERE `saID` = '0' OR `saHostID` = '0' OR `saSnapinID` = '0';
Query OK, 15 rows affected (0.024 sec)
MariaDB [fog]> DELETE FROM `hosts` WHERE `hostID` NOT IN (SELECT `hmHostID` FROM `hostMAC` WHERE `hmPrimary` = '1');
Query OK, 0 rows affected (0.026 sec)
MariaDB [fog]> DELETE FROM `hosts` WHERE `hostID` NOT IN (SELECT `hmHostID` FROM `hostMAC`);
Query OK, 0 rows affected (0.001 sec)
MariaDB [fog]> DELETE FROM `hostMAC` WHERE `hmhostID` NOT IN (SELECT `hostID` FROM `hosts`);
Query OK, 0 rows affected (0.001 sec)
MariaDB [fog]> DELETE FROM `snapinAssoc` WHERE `saHostID` NOT IN (SELECT `hostID` FROM `hosts`);
Query OK, 0 rows affected (0.001 sec)
MariaDB [fog]> DELETE FROM `groupMembers` WHERE `gmHostID` NOT IN (SELECT `hostID` FROM `hosts`)
-> ;
Query OK, 0 rows affected (0.001 sec)
MariaDB [fog]> DELETE FROM `tasks` WHERE `taskStateID` IN ("1","2","3");
Query OK, 0 rows affected (0.000 sec)
MariaDB [fog]> DELETE FROM `snapinTasks` WHERE `stState` in ("1","2","3");
Query OK, 0 rows affected (0.016 sec)
MariaDB [fog]> TRUNCATE TABLE multicastSessions;
Query OK, 0 rows affected (0.001 sec)
MariaDB [fog]> TRUNCATE TABLE multicastSessionsAssoc;
Query OK, 0 rows affected (0.001 sec)
MariaDB [fog]> DELETE FROM tasks WHERE taskTypeId=8;
Query OK, 0 rows affected (0.000 sec)
MariaDB [fog]> TRUNCATE TABLE history;
Query OK, 0 rows affected (0.023 sec)
MariaDB [fog]> TRUNCATE TABLE userTracking;
Query OK, 0 rows affected (0.001 sec)
MariaDB [fog]>
quit
