[BUG] database analyzer shows permanent errors

[haraldwitt]

Hi, I'm using version 9.0.2 with 10.1.41-MariaDB-0+deb9u1. I can't get rid of the following because the length of a field inside an index is limited in MariaDb:

DROP INDEX item_id ON tx_solr_indexqueue_item CREATE INDEX item_id ON tx_solr_indexqueue_item (item_type, item_uid) DROP INDEX pages_mountpoint ON tx_solr_indexqueue_item CREATE INDEX pages_mountpoint ON tx_solr_indexqueue_item (item_type, item_uid, has_indexing_properties, pages_mountidentifier) DROP INDEX cache_id ON tx_solr_cache CREATE INDEX cache_id ON tx_solr_cache (identifier) DROP INDEX cache_id ON tx_solr_cache_tags CREATE INDEX cache_id ON tx_solr_cache_tags (identifier) DROP INDEX cache_tag ON tx_solr_cache_tags CREATE INDEX cache_tag ON tx_solr_cache_tags (tag)

Limiting the index lenght per field to 191 (especially for varchar 255) solves the problem. E. g. use "KEY cache_tag (tag(191))" instaed of "KEY cache_tag (tag)"

Greetings Harald

[seirerman]

Same here with solr 11.0.5/TYPO3 9.5.30.

There was a similar issue just fixed for tt_address: https://github.com/FriendsOfTYPO3/tt_address/issues/359

[dkd-kaehm]

@seirerman could you please provide a PR for that issue? We want it for master, release-11.1.x and release-11.0.x branches.