{"id":1361,"date":"2019-08-12T19:58:17","date_gmt":"2019-08-12T17:58:17","guid":{"rendered":"https:\/\/www.mcgill.org.za\/stuff\/?p=1361"},"modified":"2019-08-12T20:00:16","modified_gmt":"2019-08-12T18:00:16","slug":"plugin-spider-registration-as-a-storage-engine-failed","status":"publish","type":"post","link":"https:\/\/www.mcgill.org.za\/stuff\/archives\/1361","title":{"rendered":"Plugin ‘SPIDER’ registration as a STORAGE ENGINE failed."},"content":{"rendered":"\n

I fixed a stupid error which had me stumped. Here’s the answer for posterity:<\/p>\n\n\n\n

mysql_upgrade<\/code><\/pre>\n\n\n\n
I was doing this on mariadb to install the spiderdb<\/code> engine, and it was not working:<\/p>\n\n\n\n
MariaDB [(none)]>  install plugin spider soname 'ha_spider';\nERROR 1123 (HY000): Can't initialize function 'spider'; Plugin initialization function failed.<\/code><\/pre>\n\n\n\n
The .so<\/code> file was present, and there’s really no reason for it to fail.  Since I couldn’t find the log file, I was stumped … it was hiding away in \/var\/lib\/mysql\/$(hostname).err<\/code> and saying:<\/p>\n\n\n\n
2019-08-12 18:35:51 10 [ERROR] Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50541, now running 100407. Please use mysql_upgrade to fix this error\n[ERROR] Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50541, now running 100407. Please use mysql_upgrade to fix this error\n2019-08-12 18:35:51 9 [ERROR] Plugin 'SPIDER' init function returned error.\n2019-08-12 18:35:51 9 [ERROR] Plugin 'SPIDER' registration as a STORAGE ENGINE failed.<\/code><\/pre>\n\n\n\n
And then I remembered that this is an installation that was upgraded from previous versions a few times over – and after running mysql_upgrade<\/code> to create the table that says what plugins are enabled, it worked just great:<\/p>\n\n\n\n
MariaDB [(none)]>  install plugin SPIDER soname 'ha_spider';<\/strong>
 Query OK, 0 rows affected (0.075 sec)<\/pre>\n","protected":false},"excerpt":{"rendered":"
I fixed a stupid error which had me stumped. Here’s the answer for posterity: I was doing this on mariadb to install the spiderdb engine, and it was not working: The .so file was present, and there’s really no reason … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[274,20,190,11],"class_list":["post-1361","post","type-post","status-publish","format-standard","hentry","category-stuff","tag-mariadb","tag-mysql","tag-stuff","tag-stupidity"],"_links":{"self":[{"href":"https:\/\/www.mcgill.org.za\/stuff\/wp-json\/wp\/v2\/posts\/1361","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mcgill.org.za\/stuff\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mcgill.org.za\/stuff\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mcgill.org.za\/stuff\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mcgill.org.za\/stuff\/wp-json\/wp\/v2\/comments?post=1361"}],"version-history":[{"count":3,"href":"https:\/\/www.mcgill.org.za\/stuff\/wp-json\/wp\/v2\/posts\/1361\/revisions"}],"predecessor-version":[{"id":1364,"href":"https:\/\/www.mcgill.org.za\/stuff\/wp-json\/wp\/v2\/posts\/1361\/revisions\/1364"}],"wp:attachment":[{"href":"https:\/\/www.mcgill.org.za\/stuff\/wp-json\/wp\/v2\/media?parent=1361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mcgill.org.za\/stuff\/wp-json\/wp\/v2\/categories?post=1361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mcgill.org.za\/stuff\/wp-json\/wp\/v2\/tags?post=1361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}