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

mySQLD does not have the access rights to InnoDB.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Not a Bug
    • None
    • N/A
    • OTHER
    • None
    • zLINUX / Redhat 6.4 / s390x

    Description

      Hello we are doing some testing for mariaDB in our environment. Can you please take a look and offer a possible resolution?

      Thank you!

      [mweiner@mariadb sql]$ ./mysqld &
      [1] 2261
      [mweiner@mariadb sql]$ 141104 12:52:31 [Warning] An old style --language or -lc-message-dir value with language specific part detected: /opt/mariadb-10.0.14/sql/share/english/
      141104 12:52:31 [Warning] Use --lc-messages-dir without language specific part instead.
      141104 12:52:31 [Warning] Can't create test file /opt/mariadb-10.0.14/mariadb.lower-test
      141104 12:52:31 [Note] InnoDB: Using mutexes to ref count buffer pool pages
      141104 12:52:31 [Note] InnoDB: The InnoDB memory heap is disabled
      141104 12:52:31 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      141104 12:52:31 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
      141104 12:52:31 [Note] InnoDB: Compressed tables use zlib 1.2.3
      141104 12:52:31 [Note] InnoDB: Not using CPU crc32 instructions
      141104 12:52:31 [Note] InnoDB: Initializing buffer pool, size = 128.0M
      141104 12:52:31 [Note] InnoDB: Completed initialization of buffer pool
      141104 12:52:31 [Note] InnoDB: Highest supported file format is Barracuda.
      2014-11-04 12:52:31 3fffd6a8720  InnoDB: Operating system error number 13 in a file operation.
      InnoDB: The error means mysqld does not have the access rights to
      InnoDB: the directory.
      141104 12:52:31 [ERROR] InnoDB: Could not find a valid tablespace file for 'mysql/gtid_slave_pos'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
      141104 12:52:31 [ERROR] InnoDB: Tablespace open failed for '"mysql"."gtid_slave_pos"', ignored.
      2014-11-04 12:52:31 3fffd6a8720  InnoDB: Operating system error number 13 in a file operation.
      InnoDB: The error means mysqld does not have the access rights to
      InnoDB: the directory.
      141104 12:52:31 [ERROR] InnoDB: Could not find a valid tablespace file for 'mysql/innodb_index_stats'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
      141104 12:52:31 [ERROR] InnoDB: Tablespace open failed for '"mysql"."innodb_index_stats"', ignored.
      2014-11-04 12:52:31 3fffd6a8720  InnoDB: Operating system error number 13 in a file operation.
      InnoDB: The error means mysqld does not have the access rights to
      InnoDB: the directory.
      141104 12:52:31 [ERROR] InnoDB: Could not find a valid tablespace file for 'mysql/innodb_table_stats'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
      141104 12:52:31 [ERROR] InnoDB: Tablespace open failed for '"mysql"."innodb_table_stats"', ignored.
      141104 12:52:31 [Note] InnoDB: 128 rollback segment(s) are active.
      141104 12:52:31 [Note] InnoDB: Waiting for purge to start
      141104 12:52:31 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.20-68.0 started; log sequence number 1616718
      141104 12:52:31 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
      141104 12:52:31 [Warning] ./mysqld: unknown option '--loose-mutex-deadlock-detector'
      141104 12:52:31 [Warning] ./mysqld: unknown option '--loose-mutex-deadlock-detector'
      141104 12:52:31 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
      141104 12:52:31 [Note] Server socket created on IP: '::'.
      141104 12:52:31 [ERROR] Can't start server : Bind on unix socket: Permission denied
      141104 12:52:31 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
      141104 12:52:31 [ERROR] Aborting
       
      141104 12:52:31 [Note] InnoDB: FTS optimize thread exiting.
      141104 12:52:31 [Note] InnoDB: Starting shutdown...
      141104 12:52:34 [Note] InnoDB: Shutdown completed; log sequence number 1616728
      141104 12:52:34 [Note] ./mysqld: Shutdown complete

      ^C
      [1]+ Exit 1 ./mysqld

      Attachments

        Activity

          People

            Unassigned Unassigned
            mweiner5641 Michael Weiner
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.