Mysql Operating System Error Number 13
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta
Docker Innodb Operating System Error Number 13 In A File Operation
Discuss the workings and policies of this site About Us Learn innodb operating system error number 13 in a file operation ubuntu more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us
Innodb: Os_file_get_status() Failed On './ibdata1'. Can't Determine File Permissions
Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, can't find file: './mysql/plugin.frm' (errno: 13) helping each other. Join them; it only takes a minute: Sign up Mysql won't start - ibdata1 corrupt? - operating system error number 13 - permissions issue up vote 24 down vote favorite 6 Server shutdown from power failure. Mysql will not start now. Disk is not full. Syslog is below Oct 11 15:03:31 joe mysqld_safe[24757]: started can't create test file /var/lib/mysql/ Oct 11 15:03:31 joe mysqld[24760]: 101011 15:03:31 InnoDB: Operating system error number 13 in a file operation. Oct 11 15:03:31 joe mysqld[24760]: InnoDB: The error means mysqld does not have the access rights to Oct 11 15:03:31 joe mysqld[24760]: InnoDB: the directory. Oct 11 15:03:31 joe mysqld[24760]: InnoDB: File name ./ibdata1 Oct 11 15:03:31 joe mysqld[24760]: InnoDB: File operation call: 'create'. Oct 11 15:03:31 joe mysqld[24760]: InnoDB: Cannot continue operation. mysql file permissions innodb share|improve this question asked Oct 11 '10 at 15:32 eat_a_lemon 1,56252334 1 Checked permissions for ibdata1 I assume? In /var/lib/mysql on debian and its derivatives i think –Alexander Sagen Oct 11 '10 at 15:36 Yea nothing has changed. Permissions are owned by mysql. The file must be corrupt. It is the only thing I can think of at this point. –eat_a_lemon Oct 11 '10 at 17:14 add a comment| 12 Answers 12 active oldest votes up vote 15 down vote accepted The file is not corrupt. You can find out the source
starting MySQL server on a new machine that you've copied over the databases folder from another server? 140612 21:38:29 mysqld started 140612 21:38:29
Innodb: Operating System Error Number 2 In A File Operation.
InnoDB: Operating system error number 13 in a file operation. InnoDB: can't open and lock privilege tables: table 'mysql.host' doesn't exist The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1
[error] Can't Open The Mysql.plugin Table. Please Run Mysql_upgrade To Create It.
InnoDB: File operation call: ‘open'. InnoDB: Cannot continue operation. 140612 21:38:29 mysqld ended Even though the permissions are correct as followed : MySQL data directory [/var/lib] Shell output Shell http://stackoverflow.com/questions/3907666/mysql-wont-start-ibdata1-corrupt-operating-system-error-number-13-permis drwxr-xr-x 32 mysql mysql 4096 Jun 12 21:38 mysql 1 drwxr-xr-x 32 mysql mysql 4096 Jun 12 21:38 mysql MySQL databases folder /var/lib/mysql Shell output Shell -rw-rw---- 1 mysql mysql 85983232 Jun 12 20:12 ibdata1 -rw-rw---- 1 mysql mysql 5242880 Jun 12 20:12 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 Jun 12 20:10 ib_logfile1 http://www.itechlounge.net/2014/07/linux-mysql-innodb-operating-system-error-number-13-in-a-file-operation/ drwx------ 2 mysql mysql 4096 Nov 30 2008 mysql 1234 -rw-rw---- 1 mysql mysql 85983232 Jun 12 20:12 ibdata1-rw-rw---- 1 mysql mysql 5242880 Jun 12 20:12 ib_logfile0-rw-rw---- 1 mysql mysql 5242880 Jun 12 20:10 ib_logfile1drwx------ 2 mysql mysql 4096 Nov 30 2008 mysql MySQL database [/var/lib/mysql/mysql] Shell output Shell [...] -rw-rw---- 1 mysql mysql 9494 Nov 30 2008 db.frm -rw-rw---- 1 mysql mysql 23652 Jan 10 2013 db.MYD -rw-rw---- 1 mysql mysql 4096 Jan 11 2013 db.MYI -rw-rw---- 1 mysql mysql 10330 Nov 30 2008 user.frm -rw-rw---- 1 mysql mysql 1972 May 3 13:11 user.MYD -rw-rw---- 1 mysql mysql 2048 May 5 00:00 user.MYI [...] 12345678 [...]-rw-rw---- 1 mysql mysql 9494 Nov 30 2008 db.frm-rw-rw---- 1 mysql mysql 23652 Jan 10 2013 db.MYD-rw-rw---- 1 mysql mysql 4096 Jan 11 2013 db.MYI-rw-rw---- 1 mysql mysql 10330 Nov 30 2008 user.frm-rw-rw---- 1 mysql mysql 1972 May 3 13:11 user.MYD-rw-rw---- 1 mysql mysql 2048 May 5 00:00 user.MYI[...] This issue is probably caused by SELinux. You may disable it… Edit SELinux configuration file : Configuration Shell /etc/selinux/config 1
wolf Email Updates: Status: No Feedback Impact on me: None Category:MySQL Server: DDL Severity:S3 (Non-critical) Version:5.6 OS:Linux (CentOS, Fedora) Assigned to: https://bugs.mysql.com/bug.php?id=70717 Tags: data directory View Add Comment Files Developer Edit Submission View Progress Log Contributions [24 Oct 2013 1:22] wolf wolf Description: I had set the access right for this directory to 777 using the following command: chown -R 777 mysql:mysql /home/mysqldata And the right description is "drwxrwxrwx" for the directory /home/mysqldata after I use the linux command operating system "ll". Now, I want to locate my table data file to the directory /home/mysqldata, and the test script to create table is: create table tb1(id int, title varchar(100), primary key(id)) engine = innodb, data directory = '/home/mysqldata'; The mysql server returns: ERROR 1030 (HY000): Got error -1 from storage engine And the error log shows: InnoDB: Operating system operating system error error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File /home/mysqldata/test: 'mkdir' returned OS error 113. Why have no access right to the directory? I had set all the right for the directory to all users! How to repeat: hemowolf@hotmail.com [12 Nov 2013 19:10] Miguel Solorzano Check for SELinux Issue. Thanks. [13 Dec 2013 1:00] Bugs System No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". Legal Policies Your Privacy Rights Terms of Use Contact Us Portions of this website are copyright © 2001, 2002 The PHP Group Page generated in 0.022 sec. using MySQL 5.7.12-enterprise-commercial-advanced-log Content reproduced on this site is the property of the respective copyright holders.It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle