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

SPIDER plugin initialization failed at 'create table if not exists mysql.spider_tables ... with 'Specified key was too long; max key length is 1000 bytes', Warning: Memory not freed: 10720

    XMLWordPrintable

Details

    Description

      SET GLOBAL old_mode=4;
      INSTALL PLUGIN Spider SONAME 'ha_spider.so';
      

      Leads to:

      11.4.0 9bd95e914f3f12d0d9d93e7a1f2c49e6e8841f17 (Debug)

      2024-01-15 14:27:31 0 [Note] /test/MD271223-mariadb-11.4.0-linux-x86_64-dbg/bin/mariadbd: ready for connections.
      Version: '11.4.0-MariaDB-debug'  socket: '/test/MD271223-mariadb-11.4.0-linux-x86_64-dbg/socket.sock'  port: 10292  MariaDB Server
      [ERROR] SPIDER plugin initialization failed at 'create table if not exists mysql.spider_tables(  db_name char(64) not null default '',  table_name char(199) not null default '',  link_id int not null default 0,  priority bigint not null default 0,  server char(64) default null,  scheme char(64) default null,  host char(64) default null,  port char(5) default null,  socket text,  username char(64) default null,  password char(64) default null,  ssl_ca text,  ssl_capath text,  ssl_cert text,  ssl_cipher char(64) default null,  ssl_key text,  ssl_verify_server_cert tinyint not null default 0,  monitoring_binlog_pos_at_failing tinyint not null default 0,  default_file text,  default_group char(64) default null,  dsn char(64) default null,  filedsn text default null,  driver char(64) default null,  tgt_db_name char(64) default null,  tgt_table_name char(64) default null,  link_status tinyint not null default 1,  block_status tinyint not null default 0,  static_link_id char(64) default null,  primary key (db_name, table_name, link_id),  key idx1 (priority),  unique key uidx1 (db_name, table_name, static_link_id)) engine=MyISAM default charset=utf8 collate=utf8_bin' by 'Specified key was too long; max key length is 1000 bytes'
      2024-01-15 14:27:33 4 [ERROR] Plugin 'SPIDER' registration as a STORAGE ENGINE failed.
      

      And

      11.4.0 9bd95e914f3f12d0d9d93e7a1f2c49e6e8841f17 (Debug)

      2024-01-15 14:27:34 0 [Note] /test/MD271223-mariadb-11.4.0-linux-x86_64-dbg/bin/mariadbd: Shutdown complete
      Warning: Memory not freed: 10720
      

      The memory loss is the same in all versions. 10.11 To 11.4 are affected. Occurs in both dbg+opt builds.

      Attachments

        Issue Links

          Activity

            People

              ycp Yuchen Pei
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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