Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.9
-
None
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