Issue Bug Closed

#54848Important Actions - Endless DB-analyser alter table

Thomas Skierlo 01/08/14, 18:31 updated 10/24/15, 01:16

Description

TYPO3 6.2.0beta3 (TYPO3.CMS-HEAD-6335a24) – fresh install (no upgrade)

Install tool’s db-analyser change fields are shown endless:

ALTER TABLE sys_history DROP KEY recordident_1;
ALTER TABLE sys_history ADD KEY recordident_1 (tablename,recuid);
ALTER TABLE sys_history DROP KEY recordident_2;
ALTER TABLE sys_history ADD KEY recordident_2 (tablename,tstamp);
ALTER TABLE sys_refindex DROP KEY lookup_rec;
ALTER TABLE sys_refindex ADD KEY lookup_rec (tablename,recuid);
ALTER TABLE sys_refindex DROP KEY lookup_uid;
ALTER TABLE sys_refindex ADD KEY lookup_uid (ref_table,ref_uid);
ALTER TABLE sys_refindex DROP KEY lookup_string;
ALTER TABLE sys_refindex ADD KEY lookup_string (ref_string);
ALTER TABLE sys_category_record_mm DROP KEY uid_foreign_tablenames;
ALTER TABLE sys_category_record_mm ADD KEY uid_foreign_tablenames (uid_foreign,tablenames);
ALTER TABLE cf_cache_hash DROP KEY cache_id;
ALTER TABLE cf_cache_hash ADD KEY cache_id (identifier,expires);
ALTER TABLE cf_cache_hash_tags DROP KEY cache_id;
ALTER TABLE cf_cache_hash_tags ADD KEY cache_id (identifier);
ALTER TABLE cf_cache_hash_tags DROP KEY cache_tag;
ALTER TABLE cf_cache_hash_tags ADD KEY cache_tag (tag);
ALTER TABLE cf_cache_pages DROP KEY cache_id;
ALTER TABLE cf_cache_pages ADD KEY cache_id (identifier,expires);
ALTER TABLE cf_cache_pages_tags DROP KEY cache_id;
ALTER TABLE cf_cache_pages_tags ADD KEY cache_id (identifier);
ALTER TABLE cf_cache_pages_tags DROP KEY cache_tag;
ALTER TABLE cf_cache_pages_tags ADD KEY cache_tag (tag);
ALTER TABLE cf_cache_pagesection DROP KEY cache_id;
ALTER TABLE cf_cache_pagesection ADD KEY cache_id (identifier,expires);
ALTER TABLE cf_cache_pagesection_tags DROP KEY cache_id;
ALTER TABLE cf_cache_pagesection_tags ADD KEY cache_id (identifier);
ALTER TABLE cf_cache_pagesection_tags DROP KEY cache_tag;
ALTER TABLE cf_cache_pagesection_tags ADD KEY cache_tag (tag);
ALTER TABLE cf_cache_rootline DROP KEY cache_id;
ALTER TABLE cf_cache_rootline ADD KEY cache_id (identifier,expires);
ALTER TABLE cf_cache_rootline_tags DROP KEY cache_id;
ALTER TABLE cf_cache_rootline_tags ADD KEY cache_id (identifier);
ALTER TABLE cf_cache_rootline_tags DROP KEY cache_tag;
ALTER TABLE cf_cache_rootline_tags ADD KEY cache_tag (tag);
ALTER TABLE cf_extbase_reflection DROP KEY cache_id;
ALTER TABLE cf_extbase_reflection ADD KEY cache_id (identifier,expires);
ALTER TABLE cf_extbase_reflection_tags DROP KEY cache_id;
ALTER TABLE cf_extbase_reflection_tags ADD KEY cache_id (identifier);
ALTER TABLE cf_extbase_reflection_tags DROP KEY cache_tag;
ALTER TABLE cf_extbase_reflection_tags ADD KEY cache_tag (tag);
ALTER TABLE cf_extbase_typo3dbbackend_tablecolumns DROP KEY cache_id;
ALTER TABLE cf_extbase_typo3dbbackend_tablecolumns ADD KEY cache_id (identifier,expires);
ALTER TABLE cf_extbase_typo3dbbackend_tablecolumns_tags DROP KEY cache_id;
ALTER TABLE cf_extbase_typo3dbbackend_tablecolumns_tags ADD KEY cache_id (identifier);
ALTER TABLE cf_extbase_typo3dbbackend_tablecolumns_tags DROP KEY cache_tag;
ALTER TABLE cf_extbase_typo3dbbackend_tablecolumns_tags ADD KEY cache_tag (tag);
ALTER TABLE cf_extbase_datamapfactory_datamap DROP KEY cache_id;
ALTER TABLE cf_extbase_datamapfactory_datamap ADD KEY cache_id (identifier,expires);
ALTER TABLE cf_extbase_datamapfactory_datamap_tags DROP KEY cache_id;
ALTER TABLE cf_extbase_datamapfactory_datamap_tags ADD KEY cache_id (identifier);
ALTER TABLE cf_extbase_datamapfactory_datamap_tags DROP KEY cache_tag;
ALTER TABLE cf_extbase_datamapfactory_datamap_tags ADD KEY cache_tag (tag);
ALTER TABLE cf_workspaces_cache DROP KEY cache_id;
ALTER TABLE cf_workspaces_cache ADD KEY cache_id (identifier,expires);
ALTER TABLE cf_workspaces_cache_tags DROP KEY cache_id;
ALTER TABLE cf_workspaces_cache_tags ADD KEY cache_id (identifier);
ALTER TABLE cf_workspaces_cache_tags DROP KEY cache_tag;
ALTER TABLE cf_workspaces_cache_tags ADD KEY cache_tag (tag);
ALTER TABLE cf_extbase_object DROP KEY cache_id;
ALTER TABLE cf_extbase_object ADD KEY cache_id (identifier,expires);
ALTER TABLE cf_extbase_object_tags DROP KEY cache_id;
ALTER TABLE cf_extbase_object_tags ADD KEY cache_id (identifier);
ALTER TABLE cf_extbase_object_tags DROP KEY cache_tag;
ALTER TABLE cf_extbase_object_tags ADD KEY cache_tag (tag); 

After first run db fields are changed, but message to change field is shown again (endless).

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.