[MDEV-3365] LP:950786 - Minecraft looses connection with mariadb 5.3.5 Created: 2012-03-09  Updated: 2012-10-04  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug
Reporter: Alexander C. Neblett (Inactive) Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug950786.xml    

 Description   

With minecraft server, you can use craftbukkit to add plugins to create a custom minecraft server for minecraft clients. An easy way to test this bug is to use the combination of minecraft, craftbukkit and permissionsex. Craftbukkit and PermissionsEx should be confingured in their yml files to use the mariadb database. Minecraft runs on java. In my case, I use openSUSE_12.1 x86_64 with the latest openjdk6, but Ubuntu or any other good distro will produce the same results.

After running for a minute or sometimes less, database connections start becoming lost. As time passes, more an more become lost and you end up in a state where no connections are possible. To fix the issue, either revert to 5.3.4 or any earlier version of Mariadb (no database change required). Or revert to 5.2.10 or earlier, but a database rebuild will be required since the binary structure was updated for the 5.3.x series.

My belief is that the issue is larger than minecraft and extends to any java program. Minecraft uses the standard java connector so it may be that an update is required there. As I stated earlier, it runs just fine with all versions prior to 5.3.5.

Mariadb generates no errors or warnings, but I do get messesages from MInecraft stating that the database connection was lost or that the database could not be found. I am running minecraft on the same server as mariadb and the connection is as localhost.

Thanks,

Alex



 Comments   
Comment by Elena Stepanova [ 2012-03-09 ]

Re: Minecraft looses connection with mariadb 5.3.5
Hi Alexander,

Could you please

  • quote exact error messages you are receiving when a connection gets lost and when a connection cannot be established;
  • provide MariaDB error log (even if it does not contain errors or warnings);
  • provide the cnf file your server is running with;
  • specify which version of java connector you are using;
  • turn on MariaDB general log for a while (for a few min should be enough, since the problem shows up after a minute or so), and provide the log too (you need to set global general_log=on, and general_log_file variable contains the path and name of the log);
  • turn on profileSQL property for the connector (see http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-configuration-properties.html), and provide the log which includes the application STDERR.

Thank you.

Comment by Rasmus Johansson (Inactive) [ 2012-03-16 ]

Launchpad bug id: 950786

Generated at Thu Feb 08 06:48:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.