-
Notifications
You must be signed in to change notification settings - Fork 20
Troubleshooting + faq
Please note that users on CraftBukkit 600+ MUST use the Recommended Snapshot, as 1.7.1 is incompatible with those versions.
This MySQL error usually means your username or password is incorrect for the server you're connecting to. It can also occur if you didn't create the user you're connecting as with the ability to log in from other servers while connecting remotely.
- First of all, make sure that you want to use MySQL. If you don't, change type: MySQL to type: H2 or type: Postgres (whatever you use).
- Next, check your username and password. Also check that the address you're connecting to is correct.
- Make sure the user has all permissions on the database.
- If you're connecting to a remote database server, make sure you created the user as username@%, and not username@localhost or something else. (@localhost means you're only allowed to connect from the same server the database is on).
If all else fails, recreate the database and username from scratch. This error is generally user error-related.
Delete the database and restart, your bbdata table appears to have been screwed up.
We removed SQLite due to several persistant issues that it caused. Instead, your file-based database will be provided by H2, which is more efficient, although far from being as powerful as MySQL.
We're not really sure, but we're currently looking into it. We suspect that BigBrother handles the double-slashes strangely, but we need to test to be sure and to isolate the problem area.
After upgrading to 1.6, my database server and minecraft server locks up on startup. What's going on?!
First of all, BigBrother (prior to 1.6.4) deletes a LOT of excess database records on startup. This can take a long time, since there can be millions. If your server's hard drive is churning and a bunch of other things are going on, it's the database server deleting millions of records to comply with the new trimming rules.
Tell your users that the server's doing some serious cleaning and it'll be a few minutes, and go get a snack. Whatever you do, don't restart the server in the middle of the cleanup, it'll just take longer OR CORRUPT YOUR ENTIRE TABLE. If you want to keep those records, tweak the BB config before starting up.
First, ensure you have enough memory and diskspace to run MySQL. BigBrother produces a large amount of data for the databases, so you may need to upgrade to a dedicated server for it if your load is high enough. You may also need to tweak your MySQL config or try a different storage engine (NOTE for those on 1.6.3 and older: Try MyISAM instead of INNODB)
Next, Restart the MySQL server FIRST. It will start up and begin trying to restore the table, and roll back some transactions. After the server's up and resource load is down to normal (e.g. HDD light has changed from constantly-on), you can then start up the Minecraft server.
H2 is supposed to be an alternative in case MySQL is not available. Please use MySQL unless it is absolutely impossible to install!
CraftBukkit builds from Jenkins can often be unstable, making it difficult to find a version that works. Therefore, the bukkit team marks some builds as "Recommended", meaning that they're stable enough to use on a production server "for a week". (According to LukeGB, anyway :P). Therefore, as directed by Bukkit plugin development recommendations, we only use Recommended builds, as they don't change as often and are more likely to work. If it doesn't work on your build, check to see if it works on Recommended CraftBukkit.