ISPsystem.com Forums - "Error: Database name already exists" BUT IT DOES NOT!

ISPsystem.com Forums (http://forum.ispsystem.com//index.php)

- Troubleshooting (http://forum.ispsystem.com//forumdisplay.php?f=11)

- - "Error: Database name already exists" BUT IT DOES NOT! (http://forum.ispsystem.com//showthread.php?t=2050)

dimitar

11-15-2012 01:12 AM

"Error: Database name already exists" BUT IT DOES NOT!

When I try to create a database which actually doesn't exist (was deleted in the past) I get an error.

ISPmanager:
Error: Database name already exists

ispmgr.log:
[ 4314:4180] ERROR Exception 2: 'name' already exists

MySQL:
ERROR 1049 (42000): Unknown database 'user_dbname'

Where does ispmgr keep track of existing mysql databases, so I can delete it from ispmgr's list?

ISPmanager-Pro 4.4.8.3

Thanks.

slava

11-15-2012 09:01 PM

Hello
check mysql table db in mysql database 'mysql', for example

Code:

mysql> use mysql

Database changed

mysql> select Db from db;

+-----------+

| Db        |

+-----------+

| test      |

| test\_%   |

| blog      |

| ihtiandr  |

| ritaphoto |

+-----------+

5 rows in set (0.00 sec)

dimitar

11-16-2012 01:08 AM

There are 382 rows in mysql.db, but actually 233 databases really exist. There are 149 dummy entries in mysql.db, which are actually from previously deleted users from the control panel. Seems like ispmgr doesn't make proper user delete? Is this a bug?

Also, is it safe to delete dummy entries in mysql.db ? Is there any other table which is related and should be cleaned? What is the safest way of fixing this issue?

Thank you.

slava

11-16-2012 09:40 PM

This is not bug in ISPmanager, this is problem in mysql server. ISPmanager run 'drop database' command only, but MySQL hang (?) in your server. You can delete this records in database.

All times are GMT +2. The time now is 10:56 PM.