Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-3365

LP:950786 - Minecraft looses connection with mariadb 5.3.5

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Incomplete
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      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

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            elenst Elena Stepanova added a comment -

            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.

            Show
            elenst Elena Stepanova added a comment - 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.
            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 950786

            Show
            ratzpo Rasmus Johansson added a comment - Launchpad bug id: 950786

              People

              • Assignee:
                Unassigned
                Reporter:
                alexanderc.neblett Alexander C. Neblett
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: