MySQL Bugs: #45368: Can't create databse with the same name when the database itself doesn't exist

Bug #45368	Can't create databse with the same name when the database itself doesn't exist
Submitted:	8 Jun 2009 10:29	Modified:	8 Jul 2009 11:08
Reporter:	asier berasategui	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: General	Severity:	S2 (Serious)
Version:	4.1.18	OS:	Linux (embebed Linux)
Assigned to:		CPU Architecture:	Any
Tags:	CREATE TABLE, embebed, linux

Description:
I have a "mysql  Ver 14.7 Distrib 4.1.18" in a embebed PC.
Also, I have a script to create and load a database (name = carInfo)when de PC is starting.
If the database already exists the script does nothing.
The tables are created with MyISAN Engine with out any special command.

In one of those reboots, the database is not created.
The script fails, so in Mysql Server the database "carInfo" doesn't exist.

I've tried to create the database, with the same name, manually but I couldn't.
Obviously, before do this, I've confirmed that the database "CarInfo" doesn't exist in the database system.

However, I could create a new database with a different noun.

I think that the problem is in one of the configurations files of mysql, but I can't find it.

Could anybody help me.

How to repeat:
I don't know how to repeat the problem. 
It is a bug that occurs on a random.

The tags were badly written

Thank you for the report.

But version 4.1.18 is old. Please try with current version 4.1.22 (or better with fully supported version 5.1.35) and if problem still exists provide part of the script which checks database for existence, the creates if needed and full server error log file.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".