Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL)
Description
Spider does not load if the server is running with sql_mode=ORACLE.
It is true both when the server is started in ORACLE mode and plugin-load-add=ha_spider or when they are set/loaded at runtime.
I didn't check, but it must have started around the same time as other similar issues, with MDEV-27095 and further fixes.
bb-10.10-release 04d9a46c41b36b61057741abddf7840962e76893 |
[ERROR] SPIDER plugin initialization failed at 'if @win_plugin = 0 then begin not atomic declare exit handler for 1041, 1123 replace into mysql.func values ('spider_direct_sql', 2, 'ha_spider.so', 'function'), ('spider_bg_direct_sql', 2, 'ha_spider.so', 'aggregate'), ('spider_ping_table', 2, 'ha_spider.so', 'function'), ('spider_copy_tables', 2, 'ha_spider.so', 'function'), ('spider_flush_table_mon_cache', 2, 'ha_spider.so', 'function'); create function if not exists spider_direct_sql returns int soname 'ha_spider.so'; create aggregate function if not exists spider_bg_direct_sql returns int soname 'ha_spider.so'; create function if not exists spider_ping_table returns int soname 'ha_spider.so'; create function if not exists spider_copy_tables returns int soname 'ha_spider.so'; create function if not exists spider_flush_table_mon_cache returns int soname 'ha_spider.so'; end;else begin not atomic declare exit handler for 1041, 1123 replace into mysql.func values ('spider_direct_sql', 2, 'ha_spider.dll', 'function'), ('spider_bg_direct_sql', 2, 'ha_spider.dll', 'aggregate'), ('spider_ping_table', 2, 'ha_spider.dll', 'function'), ('spider_copy_tables', 2, 'ha_spider.dll', 'function'), ('spider_flush_table_mon_cache', 2, 'ha_spider.dll', 'function'); create function if not exists spider_direct_sql returns int soname 'ha_spider.dll'; create aggregate function if not exists spider_bg_direct_sql returns int soname 'ha_spider.dll'; create function if not exists spider_ping_table returns int soname 'ha_spider.dll'; create function if not exists spider_copy_tables returns int soname 'ha_spider.dll'; create function if not exists spider_flush_table_mon_cache returns int soname 'ha_spider.dll'; end;end if;' by 'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'create function if not exists spider_direct_sql returns int soname 'ha_s...' at line 1'
|
Attachments
Issue Links
- blocks
-
MDEV-29870 Backport fixes to spider init bugs to 10.4-10.6 once they have SQL service
- Closed
-
MDEV-32773 Syntax error upon Spider initialization under ORACLE mode (a different one)
- Closed
- is caused by
-
MDEV-22979 "mysqld --bootstrap" / mysql_install_db hangs when Spider is installed
- Closed
- relates to
-
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
- Closed
-
MDEV-33494 spider plugin init failure with no_zero_date sql_mode
- Closed