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

Replica server crashes after CREATE TABLE with SPATIAL KEY

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      In prepare for upgrade in our enviroment from MariaDB 10.3.15 to MariaDB 12.3.2, I have one MariaDB server with new version replicating from a chain of old servers.

      Query:

      CREATE TABLE IF NOT EXISTS `table`(
          ...
          `geometry` point NOT NULL,
          SPATIAL KEY `xgeometry` (`geometry`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8
      

      gets propagated through replication on MariaDB 10.3 without a problem, but 12.3.2 crashes with exception 0xc0000005 at server.dll!Sql_cmd_create_table_like::execute() .

      If I take the same query from binlog on master server and run it manually on new server (12.3.2) it passes correctly and server doesnt crash.

      So this issue have to be specific for those:

      • source of query is replication
      • CREATE TABLE IF NOT EXISTS gets wrongly passed to method Sql_cmd_create_table_like (there is no LIKE in this CREATE TABLE)
      • crash only happens when there is SPATIAL KEY

      Attachments

        Activity

          People

            bnestere Brandon Nesterenko
            laky Lukáš Pavlas
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.