CData section too big when loading timeline

[JeroenVanLeusden]

Timeline won't load on our production servers, it generates:

Warning: DOMDocumentFragment::appendXML(): Entity: line 1: parser error : CData section too big found in /vendor/magento/framework/View/TemplateEngine/Xhtml/Template.php on line 60

[Ethan3600]

@JeroenVanLeusden I think this is a Magento bug: magento/magento2#8084 (comment) BUT they say it's fixed in v2.2.x (I'm very skeptical)...

What version of Magento are you running?

[JeroenVanLeusden]

We're on 2.2.2, should be fixed in 2.2.3 so maybe there is no issue after we upgraded the webshop.

[Ethan3600]

@JeroenVanLeusden Not ready to give up investigating just yet!

I setup my local environment to be on version 2.2.2 and ran a large sql query to load a little over 10,000 crons in cron_schedule, and I loaded up the Timeline with no errors.

I tried this on production mode and developer mode; I'm using CJM v1.5.0, testing on Ubuntu 16.04 (doubt that the OS is the issue, but I figure it's worth mentioning). Still no luck.

BUT, I grepped for the error you posted above and found it in var/log/system.log with a time stamp of April 29th, but I have no idea how to trigger it again.

Do you have any other information to help me reproduce? Maybe some steps? Can you consistently reproduce this error?

[JeroenVanLeusden]

We consistently see this error, which makes me believe it might be a php configuration somewhere? We run the following:

• Ubuntu 16.04.1 LTS
• PHP 7.0.28-1
• max_execution_time => 18000
• max_file_uploads => 50
• max_input_nesting_level => 64
• max_input_time => 60
• max_input_vars => 10000
• memory_limit => 2048M

[JeroenVanLeusden]

Just checked my cron_schedule and saw a whopping 170k records. After flushing them there are ~13k records.

The warning message disappeared but not my browser window is crashing trying to render the timeline.

[Ethan3600]

I don't think it's a PHP configuration. See this comment here: magento/magento2#8084 (comment). I think by pulling 170k records through the uiComponent we're going way over the 10MB limit set by libxml.

I didn't account for the timeline to be able to support over 100k records. This is most definitely attributed to a Magento core bug: magento/magento2#11002

There is a PR that was merged that (supposedly) fixes this here: magento/magento2#12497 (I personally haven't seen this issue happen on v2.2.3, so maybe it does work).

But, while the timeline may not be able to support 100k records, this does bring an issue to light regarding performance on the timeline.

This is something we can fix. I noticed performance starts to slow down at ~2k records.

I'm going to close this issue and blame Magento on this one, but I will open another issue regarding performance in another ticket.

Thanks for helping troubleshoot this issue! If you still have concerns, feel free to comment even if the issue is closed, or create a new issue if another arises.

[amelojunior]

@Ethan3600 This is related to the issue #65 ?
I have the same problem in version 2.2.5

[Ethan3600]

Yep. Is that still happening on the latest version? I hardcoded a limit to the amount of crons hoping it'll be low enough so we don't see this error.