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

allow automatic table re-discover

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Stalled (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      Automatic re-discover is supported as a feature, but currently it is only allowed when a table is being opened. Because of table definition cache tables are rarely opened, instead, open tables are put in the TDC for reuse without reopening.

      Thus an engine must either block all table changes while the table is opened - that is, for undefined amount of time, because the engine cannot force the table to be closed, it can only wait for the user to issue FLUSH TABLES.

      Or the engine should issue a HA_ERR_TABLE_DEF_CHANGED after the table was opened - it will cause an error message sent to the user "table definition was changed, need re-discovery".

      We need to allow automatic re-discover to happen more often. Options:

      • every time a table is taken from the TDC, the server calls a new special method "is the table definition up-to-date"?
      • on HA_ERR_TABLE_DEF_CHANGED error from the external_lock() the server does fallback-and-retry, just as when it gets this error from open().

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              serg Sergei Golubchik
              Votes:
              4 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.