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

Mysql would not start (service hangs on startup due to missing ini file)

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 5.5.39, 10.0.12, 10.1.0
        • Fix Version/s: 10.1, 10.0, 5.5
        • Component/s: None
        • Labels:
        • Environment:
          windows 2012 R2 datacenter

          Description

          In Windows the service gets stuck in "Starting", as shown in the services applet. It started fine the first time, then I changed my.cnf so data would be stored in a different drive, stopped the service, copied the data directory to the new drive, set the permissions on the new destination so "everybody" would have full rights, then the service started, I loaded a 40 GB of data just fine. Then I stopped the service, and it never started again. I rebooted and it still did not start. I can give you access to the box. It is a development box accessible via remote desktop.
          Note: there are no messages in the windows application log.

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                serg Sergei Golubchik added a comment -

                Could you provide any more information? Like, error logs, error messages, anything?

                Show
                serg Sergei Golubchik added a comment - Could you provide any more information? Like, error logs, error messages, anything?
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                Hi,

                You can send me connection info either via email or in a private message on IRC, or any other way suitable for you.

                Show
                elenst Elena Stepanova added a comment - Hi, You can send me connection info either via email or in a private message on IRC, or any other way suitable for you.
                Hide
                Permalink
                philip_38 Philip orleans added a comment -

                my skype is philip_38

                On Tue, Aug 5, 2014 at 1:07 PM, Elena Stepanova (JIRA)

                Show
                philip_38 Philip orleans added a comment - my skype is philip_38 On Tue, Aug 5, 2014 at 1:07 PM, Elena Stepanova (JIRA)
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                Investigation has shown that the server did not start because my.ini file did not exist in the location configured for the Windows service. Creating the required path fixed the issue.

                However, it is still a bug because the service shouldn't hang, it should fail with a proper error message (as a normal standalone server does if it's started with a non-existing --defaults-file).

                Show
                elenst Elena Stepanova added a comment - Investigation has shown that the server did not start because my.ini file did not exist in the location configured for the Windows service. Creating the required path fixed the issue. However, it is still a bug because the service shouldn't hang, it should fail with a proper error message (as a normal standalone server does if it's started with a non-existing --defaults-file).

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    philip_38 Philip orleans
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated: