systag_by_tagid index is not created via occ db:add-missing-indices #39379
Description
I don't know if this is the right place but I just updated 3 instances, two with MySQL, one with PostgreSQL to 27.0.1 RC1
The /settings/admin/overview throws this message:
but on all of the three instances
occ db:add-missing-indices
does not make any changes at all nor do i get the sql query with
occ db:add-missing-indices --dry-run
and the warning does not disapear.
MariaDB [nextcloud]> explain select * from oc_systemtag_object_mapping where systemtagid = 568;
+------+-------------+-----------------------------+-------+---------------+---------+---------+------+--------+--------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+-----------------------------+-------+---------------+---------+---------+------+--------+--------------------------+
| 1 | SIMPLE | oc_systemtag_object_mapping | index | NULL | PRIMARY | 524 | NULL | 143547 | Using where; Using index |
+------+-------------+-----------------------------+-------+---------------+---------+---------+------+--------+--------------------------+
1 row in set (0.000 sec)
MariaDB [nextcloud]> DESCRIBE oc_systemtag_object_mapping;
+-------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+---------------------+------+-----+---------+-------+
| objectid | varchar(64) | NO | PRI | | |
| objecttype | varchar(64) | NO | PRI | | |
| systemtagid | bigint(20) unsigned | NO | PRI | 0 | |
+-------------+---------------------+------+-----+---------+-------+
3 rows in set (0.001 sec)
MariaDB [nextcloud]> SHOW INDEXES FROM oc_systemtag_object_mapping;
+-----------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-----------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| oc_systemtag_object_mapping | 0 | PRIMARY | 1 | objecttype | A | 2 | NULL | NULL | | BTREE | | |
| oc_systemtag_object_mapping | 0 | PRIMARY | 2 | objectid | A | 143547 | NULL | NULL | | BTREE | | |
| oc_systemtag_object_mapping | 0 | PRIMARY | 3 | systemtagid | A | 143547 | NULL | NULL | | BTREE | | |
+-----------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
3 rows in set (0.001 sec)
Originally posted by @ernolf in #38928 (comment)