MySQL undefined “user”

I saw this odd exception today:


Caused by: java.sql.SQLException: There is no 'anotherdeveloper'@'localhost' registered
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:116


This happens after my server has started up, I’ve logged in through the web app, browsed around and then try to insert a message. It’s a little puzzling at first, how can the database user just change midstream. It turns out that it’s caused by a trigger trying to fire but the DEFINER for the trigger is set to “otherdeveloper@localhost” which is not a valid account on my local database. Would be nice if mysql import warned you about this or perhaps change it to the user the schema is being imported as if the DEFINER does not exist.

SSH throughput

I found this very good article that explains what I observed and commented on in my gigabit upgrade post, SSH is not CPU and disk bound on my gigabit network.

Eclipse Perm Gen errors

got you down? According to this article, if you’re using the Sun VM, add the following to your eclipse.ini:

-XX:MaxPermSize=[memory size]

I’m trying this right now on my Macbook Pro using the Apple supplied VM (build 1.5.0_07-154), so far so good. I hope it’s not a leaky VM. And while we’re on this topic, it would be really nice if Apple could stay a little bit more up to date with VM releases. There’s been some crappy java.util.Date bugs that’s apparently only been fixed in 1.5.0_10 which has been out for ages.