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

MariaDB reports failure to start

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 5.5.36, 10.0.6
    • Fix Version/s: 5.5.37, 10.0.11
    • Component/s: None
    • Labels:
    • Environment:
      debian 7 64 bits

      Description

      root@production3:/var/lib/mysql# service mysql start
      [FAIL] Starting MariaDB database server: mysqld . . . . . . . . . . . . . . . . . . . failed!

      but in fact if you wait 60 seconds, and try "mysql", the software is up.
      The issue is using a large amount of memory and memlock=1
      It seems that the OS takes time to lock the memory and the software reports a failure to start when in fact, the process has not finished yet.
      The issue may be compounded by the fact that the machine is virtual, Vmware, and it may take longer to acquire a lock on memory.
      I use large-pages=1.
      I have no idea if the memory is actually locked or not

      cat /proc/meminfo | grep -i pages
      AnonPages:      11784856 kB
      AnonHugePages:         0 kB
      HugePages_Total:   27000
      HugePages_Free:     1668
      HugePages_Rsvd:        0
      HugePages_Surp:        0
      Hugepagesize:       2048 kB

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              philip_38 Philip orleans
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: