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:
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

[8 Jun 2009 10:29] asier berasategui
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.
[8 Jun 2009 10:31] asier berasategui
The tags were badly written
[8 Jun 2009 11:08] Sveta Smirnova
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.
[8 Jul 2009 23:00] Bugs System
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".