http://forge.typo3.org/http://forge.typo3.org/themes/typo3_forge/favicon/favicon.png?17058661692018-08-30T08:01:29ZTYPO3 ForgeTYPO3 Core - Bug #86028: getTreeList inserts duplicate keys in cache_treelisthttp://forge.typo3.org/issues/86028?journal_id=3717722018-08-30T08:01:29ZOlaf Döringmail@olaf-doering.de
<ul></ul><p>Some additions:<br />I upgraded my TYPO3 from 6.2 to 8.7, there was no problem with 6.2. Maybe the insertion of a duplicate entry into a key field in 6.2 did not throw such an exception.</p>
<p>Our TYPO3 intallation is a web- and intranetsite, used by over 1000 visitors daily (website) and over 1000 employees (intranet). Our pagetree is very large, the site is online since 2001, and so we have hundreds of new pages every year. The large pagetree is a problem since many years, it slows down the menu-creation and the handling in backend.</p> TYPO3 Core - Bug #86028: getTreeList inserts duplicate keys in cache_treelisthttp://forge.typo3.org/issues/86028?journal_id=3732492018-09-13T14:39:26ZRens Admiraalrens@simplyadmire.com
<ul></ul><p>Quick FYI without digging deep: we run into the same issue, but not with a lot of pages (there's 262 pages in the list of the failing query)</p> TYPO3 Core - Bug #86028: getTreeList inserts duplicate keys in cache_treelisthttp://forge.typo3.org/issues/86028?journal_id=3911222018-11-26T10:21:19ZAlexander Schnitzler
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Accepted</i></li><li><strong>Assignee</strong> set to <i>Alexander Schnitzler</i></li><li><strong>Target version</strong> set to <i>Candidate for patchlevel</i></li></ul> TYPO3 Core - Bug #86028: getTreeList inserts duplicate keys in cache_treelisthttp://forge.typo3.org/issues/86028?journal_id=3911292018-11-26T11:23:02ZAlexander Schnitzler
<ul><li><strong>Has duplicate</strong> <i><a class="issue tracker-1 status-5 priority-4 priority-default closed" href="/issues/86491">Bug #86491</a>: Duplicate entry for PRIMARY key in cache_treelist</i> added</li></ul> TYPO3 Core - Bug #86028: getTreeList inserts duplicate keys in cache_treelisthttp://forge.typo3.org/issues/86028?journal_id=3911322018-11-26T11:27:21ZGerrit Code Review
<ul><li><strong>Status</strong> changed from <i>Accepted</i> to <i>Under Review</i></li></ul><p>Patch set 1 for branch <strong>master</strong> of project <strong>Packages/TYPO3.CMS</strong> has been pushed to the review server.<br />It is available at <a class="external" href="https://review.typo3.org/58951">https://review.typo3.org/58951</a></p> TYPO3 Core - Bug #86028: getTreeList inserts duplicate keys in cache_treelisthttp://forge.typo3.org/issues/86028?journal_id=3911352018-11-26T11:37:26ZAlexander Schnitzler
<ul></ul><p>Short explanation why this issue occurres:</p>
<p>By default all new cache_treelist entries do not expire. This means, that if there is a cache entry for a given hash, you will get that entry.</p>
<p>There is just one exception though. If the endtime of a page gets updated, the cache entry gets said endtime as expiry timestamp. The problem with that is, that the method \TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer::getTreeList didn't check for expired entries and also didn't delete them.<br />The method "thought", there is no entry at all and that it is fine to create a new one, which obviously failes.</p> TYPO3 Core - Bug #86028: getTreeList inserts duplicate keys in cache_treelisthttp://forge.typo3.org/issues/86028?journal_id=3911372018-11-26T11:39:45ZGerrit Code Review
<ul></ul><p>Patch set 2 for branch <strong>master</strong> of project <strong>Packages/TYPO3.CMS</strong> has been pushed to the review server.<br />It is available at <a class="external" href="https://review.typo3.org/58951">https://review.typo3.org/58951</a></p> TYPO3 Core - Bug #86028: getTreeList inserts duplicate keys in cache_treelisthttp://forge.typo3.org/issues/86028?journal_id=3915702018-12-04T19:35:29ZGerrit Code Review
<ul></ul><p>Patch set 1 for branch <strong>TYPO3_8-7</strong> of project <strong>Packages/TYPO3.CMS</strong> has been pushed to the review server.<br />It is available at <a class="external" href="https://review.typo3.org/59031">https://review.typo3.org/59031</a></p> TYPO3 Core - Bug #86028: getTreeList inserts duplicate keys in cache_treelisthttp://forge.typo3.org/issues/86028?journal_id=3915732018-12-04T20:00:05ZAnonymous
<ul><li><strong>Status</strong> changed from <i>Under Review</i> to <i>Resolved</i></li><li><strong>% Done</strong> changed from <i>0</i> to <i>100</i></li></ul><p>Applied in changeset <a class="changeset" title="[BUGFIX] Remove expired cache_treelist entries during runtime When \TYPO3\CMS\Frontend\ContentOb..." href="http://forge.typo3.org/projects/typo3cms-core/repository/1749/revisions/b63f03d68a7c324bef798d5ad87d08b51c347c6b">b63f03d68a7c324bef798d5ad87d08b51c347c6b</a>.</p> TYPO3 Core - Bug #86028: getTreeList inserts duplicate keys in cache_treelisthttp://forge.typo3.org/issues/86028?journal_id=3916112018-12-05T17:27:32ZGerrit Code Review
<ul><li><strong>Status</strong> changed from <i>Resolved</i> to <i>Under Review</i></li></ul><p>Patch set 1 for branch <strong>TYPO3_8-7</strong> of project <strong>Teams/Security/TYPO3v4-Core</strong> has been pushed to the review server.<br />It is available at <a class="external" href="https://review.typo3.org/59040">https://review.typo3.org/59040</a></p> TYPO3 Core - Bug #86028: getTreeList inserts duplicate keys in cache_treelisthttp://forge.typo3.org/issues/86028?journal_id=3920702018-12-12T09:17:45ZStefan P
<ul></ul><p>We also have this issue. According to the changelog this patch is in 8.7.21 -- but we still experience it with this version. Completly random the Frontend is populated with occassional "Ooops, an error occured" and the log always says "Duplicate entry 'hash' for key 'PRIMARY' in..."</p> TYPO3 Core - Bug #86028: getTreeList inserts duplicate keys in cache_treelisthttp://forge.typo3.org/issues/86028?journal_id=3920752018-12-12T13:15:37ZGuido Schmechel
<ul></ul><p>Same here with 8.7.21</p> TYPO3 Core - Bug #86028: getTreeList inserts duplicate keys in cache_treelisthttp://forge.typo3.org/issues/86028?journal_id=3920772018-12-12T16:22:19ZChristian Toffolo
<ul></ul><p>Same here after yesterday I upgraded from 8.7.20 to 8.7.21, in the various "typo3_xxxxxxxxxxx.log" files of my installations I have many errors related to `MysqliException: Duplicate entry` in table `cache_treelist`.</p>
<p>I have a script that crawl my websites and this errors happen completely randomly.</p>
<p>I reverted <a class="external" href="https://review.typo3.org/#/c/58951/">https://review.typo3.org/#/c/58951/</a> and after many runs of my crawler the errors didn't show up again.</p> TYPO3 Core - Bug #86028: getTreeList inserts duplicate keys in cache_treelisthttp://forge.typo3.org/issues/86028?journal_id=3920942018-12-12T22:51:34ZAlexander Schnitzler
<ul><li><strong>Related to</strong> <i><a class="issue tracker-1 status-5 priority-4 priority-default closed" href="/issues/87139">Bug #87139</a>: Regression: getTreeList inserts duplicate keys in cache_treelist</i> added</li></ul> TYPO3 Core - Bug #86028: getTreeList inserts duplicate keys in cache_treelisthttp://forge.typo3.org/issues/86028?journal_id=3920982018-12-12T22:52:05ZAlexander Schnitzler
<ul><li><strong>Status</strong> changed from <i>Under Review</i> to <i>Closed</i></li></ul>