[MDEV-10248] Cannot Remove Test Tables Created: 2016-06-17  Updated: 2020-12-08  Resolved: 2016-07-15

Status: Closed
Project: MariaDB Server
Component/s: Scripts & Clients
Affects Version/s: 5.5, 10.0, 10.1
Fix Version/s: 5.5.51, 10.1.17, 10.0.27

Type: Bug Priority: Minor
Reporter: Espresso Bean Assignee: Elena Stepanova
Resolution: Fixed Votes: 0
Labels: None
Environment:

Debian 8.5


 Description   

This is a new install of Debian 8.5 with all updates installed. When I install MariaDB for the first time and attempt to remove the test tables it errors out but allows removing privileges for it. Not sure why this suddenly started happening when I could remove them before.

https://dpaste.de/L7gm

 Comments   
Comment by Elena Stepanova [ 2016-06-17 ]

Do you actually have the test database? I think debian packages don't install it (anymore?).
If you don't have it, the message is correct; but we need to modify scripts/mysql_secure_installation.sh to do DROP DATABASE IF EXISTS instead of just DROP.
If you do have it, maybe there is a more serious problem.

Comment by Elena Stepanova [ 2016-07-15 ]

Fixed the error upon an attempt to drop a non-existing database by doing IF EXISTS.

https://github.com/MariaDB/server/commit/5cf49cdf92bb57c2e20f72422a22768be8c7a8a8

With the lack of response, I'll assume it was indeed the reason of the error in this case.

Generated at Thu Feb 08 07:40:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.