#106188DataHandler is running endless for no reason
Description
Hello, i don’t know why, but when i try to localize an entity, the commands run several hours until i kill the process. But why this happens? No errors nothing
\TYPO3\CMS\Core\Core\Bootstrap::initializeBackendAuthentication();
$this->dataHandler = GeneralUtility::makeInstance(DataHandler::class);
$this->siteFinder = GeneralUtility::makeInstance(SiteFinder::class);
$cmd['tx_XXXX_domain_model_product'][3379]['localize'] = 4;
$dataHandler->start([], $cmd);
$dataHandler->process_cmdmap();Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.
Files 1
History 5
-
Oliver Hader commented and changed status
NewNeeds Feedback <span data-processor="relativetime" data-value="2025-02-17T16:35:06+00:00" > 02/17/25, 16:35 </span> -
Daniel Elskamp commented and changed attached Tables.zip <span data-processor="relativetime" data-value="2025-02-18T07:17:49+00:00" > 02/18/25, 07:17 </span>
Here the model files.
i find out some products can be translated directly and some product needs a lot of hours for just one
-
Jasmina Ließmann commented <span data-processor="relativetime" data-value="2025-06-03T17:51:21+00:00" > 06/03/25, 17:51 </span>
For testing purposes, I added the following to my local ext_tables.sql. This information may not match that of the issue reporter.
CREATE TABLE tx_XXX_domain_model_product ( article_number varchar(255) DEFAULT '' NOT NULL, bric_code varchar(255) DEFAULT '' NOT NULL, manufacturer_number varchar(255) DEFAULT '' NOT NULL, variation_group int(11) DEFAULT '0' NOT NULL, name varchar(255) DEFAULT '' NOT NULL, slug varchar(2048), description mediumtext, video_url varchar(255) DEFAULT '' NOT NULL, main_image int(11) unsigned DEFAULT '0' NOT NULL, gallery_images int(11) unsigned DEFAULT '0' NOT NULL, documents int(11) unsigned DEFAULT '0' NOT NULL, specification_groups int(11) DEFAULT '0' NOT NULL, categories int(11) DEFAULT '0' NOT NULL, ); CREATE TABLE tx_XXX_domain_model_property_group ( title varchar(255) DEFAULT '' NOT NULL, ); CREATE TABLE tx_XXX_domain_model_property_name ( title varchar(255) DEFAULT '' NOT NULL, unit varchar(255) DEFAULT '' NOT NULL, ); CREATE TABLE tx_XXX_domain_model_specification_group ( group int(11) DEFAULT '0' NOT NULL, items int(11) DEFAULT '0' NOT NULL, product varchar(255) DEFAULT '' NOT NULL, ); CREATE TABLE tx_XXX_domain_model_specification ( name int(11) DEFAULT '0' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, group varchar(255) DEFAULT '' NOT NULL, ); CREATE TABLE tx_XXX_domain_model_variation_group ( title varchar(255) DEFAULT '' NOT NULL, );And the following lines for all TCA tables from the zip:
'ctrl' => [ 'security' => [ 'ignoreRootLevelRestriction' => true, 'ignorePageTypeRestriction' => true, ], ], -
Christian Kuhn commented <span data-processor="relativetime" data-value="2025-06-03T18:01:04+00:00" > 06/03/25, 18:01 </span>
Hey.
We played around on this for a while in a v12 instance and are unable to reproduce an issue: we added a default language product with all of the inline fields, categories, images and group fields having selected something. We were able to localize the record without much trouble and quickly.
I fear we need some more info to see if and where an issue comes from: What is special with your instance? Are you dealing with many somethings? like tons and tons of images, or one of the group fields is very huge or something like that? Could you try to somehow give an indicator which area drains performance so much? is your db attached with high latency? do you see lots and lots of queries in database log for many minutes and could find out which tca field triggers this? could you maybe reduce TCA piece by piece to see which column is the biggest offender?
It would also be interesting if the issue is mitigated on your side when the extension is based on a young v13 core: we optimized quite a bit in v13 and reduced query load in DataHandler. i know various further areas to look at, but it would be great to know if there is another specific area triggered by your setup that should have additional attention to look at.
-
Riccardo De Contardi commented and changed status
Needs FeedbackClosed <span data-processor="relativetime" data-value="2026-09-14T09:39:28+00:00" > 09/14/26, 09:39 </span>Since long time has passed with no feedback, I think it is safe to close this issue.
If you think that this is the wrong decision or experience the issue again on recent TYPO3 versions, please reopen it or open a new issue with a reference to this one.
Thank you.
Can you please share the TCA configuration of the affected models?
I guess there recursion occurs with one of the
select,grouporinlinefields (incl.categoryandfile).