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

Semaphore timeout due to large fulltext indexes

    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: