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

A ColumnStore warning returned when dropping an non-existing table

Details

    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.

      Attachments

        Issue Links

          Activity

            dleeyh Daniel Lee (Inactive) added a comment - - edited

            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'

            dleeyh Daniel Lee (Inactive) added a comment - - edited 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'

            also verified in 1.5.3-1 (drone #280)

            dleeyh Daniel Lee (Inactive) added a comment - also verified in 1.5.3-1 (drone #280)

            People

              dleeyh Daniel Lee (Inactive)
              dleeyh Daniel Lee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.