[MCOL-4109] A ColumnStore warning returned when dropping an non-existing table Created: 2020-06-25  Updated: 2020-07-13  Resolved: 2020-07-09

Status: Closed
Project: MariaDB ColumnStore
Component/s: DDLProc, MDB Plugin
Affects Version/s: 1.5.2
Fix Version/s: 1.5.3

Type: Bug Priority: Critical
Reporter: Daniel Lee (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MCOL-4164 Multi-table DROP Closed

 Description   

Build tested: 1.5.2-1 (community edition b33685)

MariaDB [(none)]> create database d1;
Query OK, 1 row affected (0.001 sec)

MariaDB [(none)]> use d1
Database changed
MariaDB [d1]> show tables;
Empty set (0.001 sec)

MariaDB [d1]> drop table d1;
Query OK, 0 rows affected, 1 warning (0.034 sec)

MariaDB [d1]> show warnings;
-------------------------------------------------------------------------------------------------------------

Level Code Message

-------------------------------------------------------------------------------------------------------------

Warning 9999 Error occured during file deletion. Restart DDLProc or use command tool ddlcleanup to clean up.

-------------------------------------------------------------------------------------------------------------
1 row in set (0.000 sec)

MariaDB [d1]> drop table hello;
Query OK, 0 rows affected, 1 warning (0.031 sec)

MariaDB [d1]> show warnings;
-------------------------------------------------------------------------------------------------------------

Level Code Message

-------------------------------------------------------------------------------------------------------------

Warning 9999 Error occured during file deletion. Restart DDLProc or use command tool ddlcleanup to clean up.

-------------------------------------------------------------------------------------------------------------
1 row in set (0.000 sec)

Not sure why it gets to ColumnStore for deleting data files since there is no reference to the ColumnStore engine.

This issue did not occur in release 1.4.4.

 Comments   
Comment by Daniel Lee (Inactive) [ 2020-07-09 ]

Build verified: 1.5.3-1 (drone build #287)

The warning messages no longer displayed.

MariaDB [mytest]> create database d1;
Query OK, 1 row affected (0.003 sec)

MariaDB [mytest]> use d1
Database changed
MariaDB [d1]> show tables;
Empty set (0.001 sec)

MariaDB [d1]> drop table t1;
ERROR 1051 (42S02): Unknown table 'd1.t1'
MariaDB [d1]> drop table d1;
ERROR 1051 (42S02): Unknown table 'd1.d1'

Comment by Daniel Lee (Inactive) [ 2020-07-10 ]

also verified in 1.5.3-1 (drone #280)

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