[MCOL-4087] SQL syntax error upon uninstallation of Columnstore plugin package Created: 2020-06-20  Updated: 2020-09-21  Resolved: 2020-08-26

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.5.2
Fix Version/s: 5.4.1

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
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.



 Comments   
Comment by Roman [ 2020-07-13 ]

4QA there must be no error messages uninstalling the plugin like in the example.

Comment by Daniel Lee (Inactive) [ 2020-08-26 ]

Build verified: 1.5.4-1, ubuntu16.08 (drone b452)

[ubuntu16:root~]# 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:
linux-headers-4.4.0-185 linux-headers-4.4.0-185-generic linux-image-4.4.0-185-generic linux-modules-4.4.0-185-generic
linux-modules-extra-4.4.0-185-generic
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 31 not upgraded.
After this operation, 1,525 kB disk space will be freed.
Do you want to continue? [Y/n] Y
(Reading database ... 195624 files and directories currently installed.)
Removing mariadb-plugin-columnstore (1:10.4.14.8+maria~xenial) ...

Generated at Thu Feb 08 02:47:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.