• Jacob Mathew's avatar
    MDEV-15786: ERROR 1062 (23000) at line 365: Duplicate entry 'spider' for key 'PRIMARY' · a86a02a8
    Jacob Mathew authored
    The problem occurs on Ubuntu where a Spider package is installed on the system
    separately from the MariaDB package.  MariaDB and Spider upgrades leave the
    Spider plugin improperly installed.  Spider is present in the mysql.plugin
    table but is not present in information_schema.
    
    The problem has been corrected in Spider's installation script.  Logic has
    been added to check for Spider entries in both information_schema and
    mysql.plugin.  If Spider is present in mysql.plugin but is not present in
    information_schema, then Spider is first removed from mysql.plugin.  The
    subsequent plugin install of Spider will insert entries in both mysql.plugin
    and information_schema.
    
    Author:
      Jacob Mathew.
    
    Reviewer:
      Kentoku Shiba.
    
    Cherry-Picked:
      Commit 0897d81 on branch bb-10.3-MDEV-15786
    a86a02a8
install_spider.sql 19.8 KB