ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    MySQL db refusing to start after Ubuntu 16.04.1 reboot

    IT Discussion
    4
    24
    3.5k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • DustinB3403D
      DustinB3403
      last edited by

      What does journalctl -xe have to say?

      NashBrydgesN 2 Replies Last reply Reply Quote 0
      • NashBrydgesN
        NashBrydges @DustinB3403
        last edited by

        @DustinB3403 said in MySQL db refusing to start after Ubuntu 16.04.1 reboot:

        What does journalctl -xe have to say?

        I've posted that output in my original post. It's at the bottom of the post.

        1 Reply Last reply Reply Quote 0
        • NashBrydgesN
          NashBrydges @DustinB3403
          last edited by

          @DustinB3403 It basically shows apparmor is denying mysql startup.

          DustinB3403D 1 Reply Last reply Reply Quote 0
          • DustinB3403D
            DustinB3403 @NashBrydges
            last edited by

            @NashBrydges How is this mySQL system being run, with sudo?

            NashBrydgesN 1 Reply Last reply Reply Quote 0
            • NashBrydgesN
              NashBrydges @DustinB3403
              last edited by

              @DustinB3403 Correct. To start I used "sudo service mysql status" and this is where I discovered it wasn't running.

              1 Reply Last reply Reply Quote 0
              • DustinB3403D
                DustinB3403
                last edited by

                It looks to me like a dependency was removed when you upgraded.

                Process: 3129 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)

                NashBrydgesN 1 Reply Last reply Reply Quote 0
                • scottalanmillerS
                  scottalanmiller
                  last edited by

                  I thought that Ubuntu came with MariaDB, not MySQL. Where did you get MySQL?

                  NashBrydgesN 1 Reply Last reply Reply Quote 0
                  • NashBrydgesN
                    NashBrydges @DustinB3403
                    last edited by

                    @DustinB3403 said in MySQL db refusing to start after Ubuntu 16.04.1 reboot:

                    /usr/sbin/mysqld

                    Just checked. There is no file named "/usr/sbin/mysqld"

                    DustinB3403D 2 Replies Last reply Reply Quote 0
                    • NashBrydgesN
                      NashBrydges @scottalanmiller
                      last edited by

                      @scottalanmiller said in MySQL db refusing to start after Ubuntu 16.04.1 reboot:

                      I thought that Ubuntu came with MariaDB, not MySQL. Where did you get MySQL?

                      Installed from "sudo apt-get install mysql-server"

                      scottalanmillerS 1 Reply Last reply Reply Quote 0
                      • DustinB3403D
                        DustinB3403 @NashBrydges
                        last edited by

                        @NashBrydges said in MySQL db refusing to start after Ubuntu 16.04.1 reboot:

                        @DustinB3403 said in MySQL db refusing to start after Ubuntu 16.04.1 reboot:

                        /usr/sbin/mysqld

                        Just checked. There is no file named "/usr/sbin/mysqld"

                        Did you create a user outside of root on this system? If so check under that user account.

                        NashBrydgesN 1 Reply Last reply Reply Quote 0
                        • scottalanmillerS
                          scottalanmiller @NashBrydges
                          last edited by

                          @NashBrydges said in MySQL db refusing to start after Ubuntu 16.04.1 reboot:

                          @scottalanmiller said in MySQL db refusing to start after Ubuntu 16.04.1 reboot:

                          I thought that Ubuntu came with MariaDB, not MySQL. Where did you get MySQL?

                          Installed from "sudo apt-get install mysql-server"

                          Oh okay, maybe they didn't switch. I run my databases on CentOS so might have missed that they hung back on MySQL.

                          1 Reply Last reply Reply Quote 0
                          • DustinB3403D
                            DustinB3403 @NashBrydges
                            last edited by

                            @NashBrydges said in MySQL db refusing to start after Ubuntu 16.04.1 reboot:

                            @DustinB3403 said in MySQL db refusing to start after Ubuntu 16.04.1 reboot:

                            /usr/sbin/mysqld

                            Just checked. There is no file named "/usr/sbin/mysqld"

                            The fact that you don't see the path means that either your running under the wrong account (don't have permission) or that something was removed.

                            NashBrydgesN 1 Reply Last reply Reply Quote 0
                            • NashBrydgesN
                              NashBrydges @DustinB3403
                              last edited by

                              @DustinB3403 I created a new user with select, update, insert delete privs on a new database within mysql but there nothing under any other users anywhere. I've been using this user for the past 2 days and it worked well.

                              I should mention that mysql is running on the standard port and nothing has been changed on the mysqld.cnf file.

                              1 Reply Last reply Reply Quote 0
                              • scottalanmillerS
                                scottalanmiller
                                last edited by

                                Can you try this...

                                sudo apt-get install apparmor-profiles apparmor-profiles-extra apparmor-docs apparmor-utils

                                See if that does anything?

                                NashBrydgesN 1 Reply Last reply Reply Quote 0
                                • NashBrydgesN
                                  NashBrydges @DustinB3403
                                  last edited by

                                  @DustinB3403 said in MySQL db refusing to start after Ubuntu 16.04.1 reboot:

                                  @NashBrydges said in MySQL db refusing to start after Ubuntu 16.04.1 reboot:

                                  @DustinB3403 said in MySQL db refusing to start after Ubuntu 16.04.1 reboot:

                                  /usr/sbin/mysqld

                                  Just checked. There is no file named "/usr/sbin/mysqld"

                                  The fact that you don't see the path means that either your running under the wrong account (don't have permission) or that something was removed.

                                  The root account still existed in the mysql.user table, along with the debian maintenance account that is setup during install. I added a new underpriviledged user to the mysql.user table but not to the server. Thatis still running under the only account that exists.

                                  1 Reply Last reply Reply Quote 0
                                  • NashBrydgesN
                                    NashBrydges @scottalanmiller
                                    last edited by

                                    @scottalanmiller said in MySQL db refusing to start after Ubuntu 16.04.1 reboot:

                                    Can you try this...

                                    sudo apt-get install apparmor-profiles apparmor-profiles-extra apparmor-docs apparmor-utils

                                    See if that does anything?

                                    This did install additional packages but mysql service still isn't starting however this time the output of journalctl -xe shows:

                                    -- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has failed.
--
-- The result is failed.
Feb 11 12:42:35 REDACTED systemd[1]: mysql.service: Unit entered failed state.
Feb 11 12:42:35 REDACTED systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 11 12:42:35 REDACTED systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Feb 11 12:42:35 REDACTED systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has finished shutting down.
Feb 11 12:42:35 REDACTED systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has begun starting up.
Feb 11 12:42:37 REDACTED systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

                                    This seems even more cryptic than the first output.

                                    1 Reply Last reply Reply Quote 0
                                    • NashBrydgesN
                                      NashBrydges
                                      last edited by

                                      Ok, I started looking into the error.log file to get more info about what was happening. I found that there was an error about not being able to load something but the log file was pretty large so I created a new log file to replace this one and went to restart mysql so I would have the one attempt's worth of records to review. To my surprise, after having provided a new error.log file, mysql started up no problem. Not sure wtf that was all about or why it failed with the current error.log contents.

                                      I'm removing mysql and starting from scratch to see if I can replicate the issue.

                                      1 Reply Last reply Reply Quote 2
                                      • scottalanmillerS
                                        scottalanmiller
                                        last edited by

                                        That's a weird one!

                                        DustinB3403D 1 Reply Last reply Reply Quote 0
                                        • DustinB3403D
                                          DustinB3403 @scottalanmiller
                                          last edited by

                                          @scottalanmiller Why the heck would a log file stop a service from loading?!

                                          NashBrydgesN 1 Reply Last reply Reply Quote 0
                                          • NashBrydgesN
                                            NashBrydges @DustinB3403
                                            last edited by

                                            @DustinB3403 No idea. But it worked.

                                            1 Reply Last reply Reply Quote 0
                                            • 1
                                            • 2
                                            • 1 / 2
                                            • First post
                                              Last post