Bug #29749
closed
Big tt_news articles causes errors
0%
Description
tt_news articles in the concept workspace ("Entwurfsumgebung") with more than 40.000 characters cause connection errors. First no records are shown in the list, then the connection errors appear.
After this both cores are completely used to capacity. I tested serveral max execution times, nothing changes.
The server is optimized for TYPO3 and should normally handle this.
Core™2Duo
2x2,66 GHz
4 GB RAM
TYPO3 4.5.5
workspaces 4.5.1
tt_news 3.0.1
Updated by Tolleiv Nietsch about 13 years ago
Are you able to reproduce this on more than one machine (using the Introduction Package?)
Updated by Tobias Liebig about 13 years ago
Did you mean any other workspace then the live workspace?
I just tested to create a tt_news record with way more then 40000 chars using a blank introduction package. I had no problem saving the record. Would be great, if you could double check the issue using the introduction package.
Updated by Alex about 13 years ago
I meant any other worspace than the live workspace.
But: If I use a new installation and the old database, i can reproduce it. But with a blank introduction package I cannot reproduce it...
Updated by Oliver Hader about 13 years ago
- Status changed from New to Needs Feedback
What is the encoding of your database and it's version?
I guess the database fields are updated correctly (Install Tool > Database Analyzer > Compare)
Updated by Alex about 13 years ago
The server uses MySQL 5.0.67
The table tt_news is set to MyISAM - InnoDB doesn't chance anything.
The site has about 20.000 articles and 6.000 categories with many relations.
The compare tool says everything is alright.
Updated by Stefan Neufeind almost 13 years ago
There are other workspace-related issues reported here about working with several thousand pages or tt_news-records. Could it be that the number of SQL-queries performed is the root of the problems you experience and not the size of an article? If you can, please try to perform an SQL-log. I expect you have a large/long-running query. Maybe because of the article-size the query grows that large that it swaps to temp-tables or so?
Updated by Markus Klein almost 11 years ago
What is the state here? Still an issue? Can you, Alex, provide the log requested by Stefan?
Updated by Michael Stucki almost 11 years ago
- Category changed from Bugs to Workspaces
Updated by Michael Stucki almost 11 years ago
- Project changed from 624 to TYPO3 Core
- Category changed from Workspaces to Workspaces
- Target version deleted (
4.5.1)
Updated by Alexander Opitz over 10 years ago
- Status changed from Needs Feedback to Closed
- Is Regression set to No
No feedback within the last 90 days => closing this ticket.
If you think that this is the wrong decision or experience this issue again, then please write to the mailing list typo3.teams.bugs with issue number and an explanation or open a new ticket and add a relation to this ticket number.