Can't creat database 'vpopmail'. Database exists

[davidcl]

I'm seeing intermittent failures of vpopmail to do various things involving the MySQL database.

The symptoms are:

1) users fail to authenticate occasionally.
2) Mail is occasionally bounced with the message:
vmysql: sql error[1]: Can't create database 'vpopmail'. Database exists
3) clearopensmtp occasionally fails with the same message.

Watching the MySQL log, I occasionally see the "CREATE DATABASE vpopmail" command being issued.

95% of the time, everything works fine.

Load and memory usage on the MySQL server are extremely low, so I don't think it is refusing connections or anything like that.

This started after I moved my machines to a new physical location and changed their IP addresses.  No other significant changes were made.

Using vpopmail 5.4.0.

I did see one reference to a similar problem on the mailing list about a year ago, but no solution.

Any suggestions?

[davidcl]

Problem apparently solved, thanks to Matt.  See the mailing list archives if you're interested in his full post, but:

> Is there hostname or IP issues involved? Bad DNS?  Try using /etc/hosts
> entries to override DNS.

I thought I had already done this, but apparently not.  After adding the /etc/hosts entry, I ran clearopensmtp from the command line 100 times without failure, so that appears to have solved the problem.  (Previously it was failing about 1 in 20 times).