GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Percona Server Not Starting

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Percona Server Not Starting

    mysql is barfing about a PID that doesn't exist when trying to start. no pid file in /var/run or in /var/lib/mysql... any suggestions?

    [root@host mysql]# /etc/init.d/mysql start
    Starting MySQL (Percona Server).The server quit without upd[FAILED]D file (/var/lib/mysql/host.domain.pid).

    [root@host mysql]# /etc/init.d/mysql status
    MySQL (Percona Server) is not running, but lock file (/var/[FAILED]sys/mysql) exists

    [root@host mysql]# tail -f /var/log/mysqld.log
    /usr/sbin/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13)
    110921 1:39:00 [ERROR] Aborting

    110921 1:39:00 [Note] /usr/sbin/mysqld: Shutdown complete

    110921 01:39:00 mysqld_safe mysqld from pid file /var/lib/mysql/host.domain.pid ended

  • #2
    ---

    Comment


    • #3
      The "perror" command is your friend when you see an error code.

      $ perror 13
      OS error code 13: Permission denied

      Comment


      • #4
        xaprb wrote on Wed, 21 September 2011 04:32
        The "perror" command is your friend when you see an error code.

        $ perror 13
        OS error code 13: Permission denied
        [root@host run]# ls -la /var/lib | grep mysql
        \drwxr-xr-x 3 mysql mysql 47 Sep 21 00:58 mysql

        I thought that might be an issue and checked a similar installation on a different server. Looks like my permissions are correct.

        Comment


        • #5
          I actually intended to link to http://forum.percona.com/index.php?t=msg&goto=7321
          there are some solutions mentioned there

          Comment


          • #6
            The report of error 13 is not a bug. If it says error 13, something is denying permission, regardless of whether the permissions look correct to you. It's usually SELinux, or a problem such as the server not running as the user you think it is, or sometimes lack of permissions on / or /var.

            Comment


            • #7
              Thanks for the help. I went ahead and re-formatted and re-installed everything and it seems to work fine now. =)

              Comment

              Working...
              X