Just to add a bit, it certainly looks mysql related. But one thing that's
really got me stumped is that my db is showing almost as many "update" and
"replace" queries as "select" queries, which seems kind of odd. I'm not
creating new users, and the mysql logging is disabled. As far as I can
recall, vpopmail is just doing select's right?
On Thu, 1 Jul 2004, Charles Sprickman wrote:
> I read with some interest the thread about 5.4.5 that mentions this
> particular error:
> Jul 1 19:11:41 blah pop3d: vmysql: sql error: Can't create database
> 'vpopmail'. Database exists
> Today we've been getting a ton of complaints about users needing to enter
> their passwords multiple times. This is pop, imap, and smtp-auth.
> Additionally it looks like the chkusr patch is having issues as well; I've
> seen a few bounces (my C-coding buddy is hopefully going to get that patch
> to act a bit more nicely if it can't hit mysql). This is vpopmail 5.3.30,
> mysql 4.0.17 on FreeBSD 4.8.
> Seeing as I'm getting failures across the board, I have to assume there's
> some issue with accessing mysql.
> The box is working hard, but not struggling. I've seen the above errors
> when the load is as low as .40. MySQL is set to a max-connections of
> 2000. MySQL does not log anything interesting when I enable logging
> except for the expected "Aborted connection" messages from the vpopmail
> stuff not calling mysql_close().
> I'm stumped here. MySQL seems to be fine, the load isn't insane, the
> vpopmail user has no cpu/file limits, nor does MySQL's user, yet all
> vpopmail stuff that hits the db fails periodically.
> Any ideas what to look at?
> I know I should get on 5.4.x, but I have to test that elsewhere for any
> surprises first.