Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4087

SQL syntax error upon uninstallation of Columnstore plugin package

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.5.2
    • Fix Version/s: 5.4.1
    • Component/s: None
    • Labels:
      None
    • Environment:
      1.5.2-1 / packages from bb-10.5-cs 19d09e49912, tarbuildnum 33657

      Description

      elenst@xenial:~$ sudo apt-get remove mariadb-plugin-columnstore
      Reading package lists... Done
      Building dependency tree       
      Reading state information... Done
      The following packages were automatically installed and are no longer required:
        libboost-atomic1.58.0 libboost-chrono1.58.0 libboost-regex1.58.0 libboost-thread1.58.0 libjemalloc1 libsnappy1v5
        snapd-login-service
      Use 'sudo apt autoremove' to remove them.
      The following packages will be REMOVED:
        mariadb-plugin-columnstore
      0 upgraded, 0 newly installed, 1 to remove and 4 not upgraded.
      After this operation, 32,3 MB disk space will be freed.
      Do you want to continue? [Y/n] y
      (Reading database ... 213650 files and directories currently installed.)
      Removing mariadb-plugin-columnstore (1:10.5.4+maria~xenial) ...
      ERROR 1064 (42000) at line 1: 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 '2' at line 1
       
      Mariab Columnstore uninstall completed
      

      Here is the general log:

      200620  2:59:55      4 Connect  root@localhost on  using Socket
                           4 Query    DROP DATABASE IF EXISTS infinidb_querystats
                           4 Quit     
                           5 Connect  root@localhost on  using Socket
                           5 Query    DELETE FROM mysql.func WHERE dl="libcalmysql.so"
                           5 Quit     
                           6 Connect  root@localhost on  using Socket
                           6 Query    DROP DATABASE IF EXISTS calpontsys
                           6 Quit     
                           7 Connect  root@localhost on  using Socket
                           7 Query    DROP PROCEDURE IF EXISTS infinidb_querystats.calSetUserPriority
                           7 Quit     
                           8 Connect  root@localhost on  using Socket
                           8 Query    DROP PROCEDURE IF EXISTS infinidb_querystats.calRemoveUserPriority(IN host VARCHAR(50), IN usr VARCHAR(50))
                           8 Quit     
                           9 Connect  root@localhost on  using Socket
                           9 Query    DROP PROCEDURE IF EXISTS infinidb_querystats.calShowProcessList
                           9 Query    2
                           9 Quit     
                          10 Connect  root@localhost on  using Socket
                          10 Query    DROP DATABASE IF EXISTS columnstore_info
                          10 Quit     
      

      Reproducible at least on Ubuntu Xenial, CentOS 7 and openSUSE 15.1.

        Attachments

          Activity

            People

            Assignee:
            dleeyh Daniel Lee
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration