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

create or replace table from innodb to spider Got error 128

    XMLWordPrintable

Details

    Description

      Hi,

      create or replace table catalog engine=spider comment='wrapper "mysql", table "catalog", srv "xxxxx"';
      ERROR 1030 (HY000): Got error 128 "Out of memory in engine" from storage engine SPIDER
      

      Workaround is to drop the innodb table first and later create the spider table.

      The DDL of the table is :

      CREATE TABLE `catalog` (
        `uid` bigint(20) unsigned NOT NULL,
        `security_uid` int(10) unsigned DEFAULT NULL,
        `agent_security_uid` int(10) unsigned DEFAULT NULL,
        `owner` varbinary(255) NOT NULL DEFAULT '',
        `viewable_owner` varbinary(255) NOT NULL DEFAULT '',
        `viewable_associate` varbinary(255) NOT NULL DEFAULT '',
        `path` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
        `relative_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
        `parent_uid` bigint(20) unsigned DEFAULT 0,
        `id` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
        `description` text COLLATE utf8_unicode_ci DEFAULT NULL,
        `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
        `meta_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
        `portal_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
        `opportunity_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
        `corporate_registration_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
        `ean13_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
        `validation_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
        `simulation_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
        `causality_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
        `invoice_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
        `payment_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
        `event_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
        `immobilisation_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
        `reference` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
        `grouping_reference` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
        `grouping_date` datetime DEFAULT NULL,
        `source_reference` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
        `destination_reference` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
        `string_index` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
        `int_index` int(11) DEFAULT NULL,
        `float_index` double DEFAULT NULL,
        `has_cell_content` tinyint(1) DEFAULT NULL,
        `creation_date` datetime DEFAULT NULL,
        `modification_date` datetime DEFAULT NULL,
        `indexation_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
        PRIMARY KEY (`uid`),
        KEY `security_uid` (`security_uid`),
        KEY `owner` (`owner`),
        KEY `viewable_owner` (`viewable_owner`),
        KEY `viewable_associate` (`viewable_associate`),
        KEY `Parent` (`parent_uid`),
        KEY `Path` (`path`),
        KEY `Title` (`title`),
        KEY `Reference` (`reference`),
        KEY `relative_url` (`relative_url`),
        KEY `Portal Type` (`portal_type`,`reference`),
        KEY `source_reference` (`source_reference`,`portal_type`),
        KEY `destination_reference` (`destination_reference`,`portal_type`),
        KEY `validation_state_portal_type` (`validation_state`,`portal_type`),
        KEY `simulation_state_portal_type` (`simulation_state`,`portal_type`),
        KEY `causality_state_portal_type` (`causality_state`,`portal_type`),
        KEY `grouping_reference` (`grouping_reference`,`portal_type`),
        KEY `agent_security_uid` (`agent_security_uid`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci 
      

      Spider plugin is installed but default configuration was used

      Thanks

      Attachments

        Activity

          People

            ycp Yuchen Pei
            stephane@skysql.com VAROQUI Stephane
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.