search

taylorkelly / BigBrother

GNU General Public License v3.0
29 stars 20 forks source link

max_user_connections #17

Closed tgrosinger closed 13 years ago

tgrosinger commented 13 years ago

I have 3 worlds on my map and since I added them I have been getting this error:

20:20:24 [SEVERE] [BBROTHER] Error getting connection com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: User redundan_mcuser already has more than 'max_user_connections' active connections at sun.reflect.GeneratedConstructorAccessor56.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2031) at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:718) at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46) at sun.reflect.GeneratedConstructorAccessor37.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at me.taylorkelly.bigbrother.datasource.ConnectionService.getConnection(ConnectionService.java:77) at me.taylorkelly.bigbrother.datasource.JDCConnectionDriver.connect(JDCConnectionDriver.java:41) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:207) at me.taylorkelly.bigbrother.datasource.ConnectionManager.getConnection(ConnectionManager.java:14) at me.taylorkelly.bigbrother.datasource.DataBlockSender.sendBlocksMySQL(DataBlockSender.java:67) at me.taylorkelly.bigbrother.datasource.DataBlockSender.access$100(DataBlockSender.java:25) at me.taylorkelly.bigbrother.datasource.DataBlockSender$Sender.run(DataBlockSender.java:248)

Also, when I try to use /bb here it sometimes seems to not work, not sure why. Please let me know if I can provide more helpful information.

N3X15 commented 13 years ago

I've planned to make some changes to the database engine in BB so it doesn't open so many connections. This may help.