Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-13188

Sphinx index() function triggers slow queries that time out replies

    Details

    • Type: Bug
    • Status: Unverified Fix
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 3.1.0-RC5
    • Fix Version/s: 3.1.0-RC6
    • Component/s: Search
    • Labels:
      None

      Description

      It seems that the query in https://github.com/phpbb/phpbb/blob/develop-ascraeus/phpBB/phpbb/search/fulltext_sphinx.php#L698 is entirely missing a WHERE clause and simply selecting all posts of all topics joined with all other posts which can be millions of results.

        Attachments

          Activity

            People

            • Assignee:
              naderman Nils Adermann
              Reporter:
              naderman Nils Adermann
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: