Uploaded image for project: 'OpenVZ'
  1. OpenVZ
  2. OVZ-6747

mysql socket lost after vzctl suspend/resume

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Verified
    • Priority: Major
    • Resolution: Fixed
    • Fix Version/s: Vz7.0-RTM
    • Component/s: CRIU
    • Security Level: Public
    • Environment:
      OVZ7/Centos 7 on generic x86_64 hardware

      Description

      >Description of problem:
      When suspend and resume CT running mysql, mysql socket is lost

      >How reproducible:
      100%

      >Steps to Reproduce:
      1. verify mysql running in ct (e.g. "mysqladmin status")
      2. suspend/resume ct
      3. check mysql again: can't connect, socket gone

      >Actual results:
      root@dbserv:~# mysqladmin status
      mysqladmin: connect to server at 'localhost' failed
      error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
      Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
      root@dbserv:~# ls -l /var/run/mysqld/
      total 4
      -rw-rw---- 1 mysql mysql 5 May 29 18:15 mysqld.pid
      root@dbserv:~#

      >Expected results:
      root@dbserv:~# mysqladmin status
      Uptime: 65009 Threads: 1 Questions: 112 Slow queries: 0 Opens: 76 Flush tables: 1 Open tables: 69 Queries per second avg: 0.001
      root@dbserv:~# ls -l /var/run/mysqld/
      total 4
      -rw-rw---- 1 mysql mysql 4 May 30 12:21 mysqld.pid
      srwxrwxrwx 1 mysql mysql 0 May 30 12:21 mysqld.sock

      >Host OS:
      virtuozzo-release-7.0.0-42.vz7.x86_64
      centos-release-7-2.1511.el7.centos.2.10.x86_64

      >Guest OS:
      NAME="Ubuntu"
      VERSION="14.04.2 LTS, Trusty Tahr"


      >Additional info (see https://openvz.org/Reporting_OpenVZ_problem):

        Attachments

        1. dbserv-commands.txt
          0.7 kB
        2. vzctl.log
          2 kB
        3. dump.log.gz
          158 kB

          Activity

            People

            Assignee:
            kgorkunov.int Kirill Gorkunov
            Reporter:
            sloan J J Sloan
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: