Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-20126

Semaphore timeout due to large fulltext indexes

    XMLWordPrintable

    Details

      Description

      MySQL 5.6.45 contains a change that refers to Oracle Bug #25289359 DML/DDL ON LARGE FULLTEXT TABLES CAUSE SEMAPHORE TIMEOUTS AND ASSERTION/SUICIDE.

      There is no test case, but there is debug instrumentation. The change continues the bogus assumption that time(NULL)) is a monotonically increasing sequence. That assumption is demonstrably broken in MDEV-14154. The change might also assume fair scheduling among the threads, which might not hold on a heavily loaded system.

      I think that we should study what the problem is and whether it affects MariaDB, and then come up with a better fix.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              thiru Thirunarayanan Balathandayuthapani
              Reporter:
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated: