US: 1-941-4621-069
  
Cyprus: 3-572-2052-781

Go Back   ISPsystem.com Forums > ISPmanager > Troubleshooting

Notices

Reply
 
Thread Tools
Old 11-15-2012, 01:12 AM   #1
Junior Member
 
Join Date: Nov 2012
Posts: 2
dimitar is on a distinguished road
Angry "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.
dimitar is offline   Reply With Quote
Old 11-15-2012, 09:01 PM   #2
ISPsystem team
 
slava's Avatar
 
Join Date: May 2008
Location: ISPsystem
Posts: 588
slava is on a distinguished road
Default

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)
slava is offline   Reply With Quote
Old 11-16-2012, 01:08 AM   #3
Junior Member
 
Join Date: Nov 2012
Posts: 2
dimitar is on a distinguished road
Default

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.
dimitar is offline   Reply With Quote
Old 11-16-2012, 09:40 PM   #4
ISPsystem team
 
slava's Avatar
 
Join Date: May 2008
Location: ISPsystem
Posts: 588
slava is on a distinguished road
Default

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.
slava is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 12:38 PM.