MySQL problem on Ubuntu

Troubleshooting with your custom scripts/programs installed on Polarhome.

Moderator: Moderators

MySQL problem on Ubuntu

Postby zoli » Tue Jun 17, 2014 2:43 pm

I have spent at least half hour to realize what caused that the MySQL stopped working on Ubuntu.
Normally, the data directory can grow huge, therefore it is symlinked on most of the systems to the biggest partition - usually /home and added to the users' file quota.
Suddenly, on Ubuntu MySQL stopped to work... and it failed with
Code: Select all
140617 13:43:11 InnoDB: Completed initialization of buffer pool
140617 13:43:11  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.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.


Finnaly I realized that the symbolic link caused the problem.
Read more at http://serverfault.com/questions/404007/symbolic-link-to-mysql-database the second comment :)
Regards,
Z
---
Zoltan Arpadffy
zoli
Forum Admin
Forum Admin
 
Posts: 785
Joined: Mon Sep 30, 2002 1:27 am
Location: Stockholm, Sweden

Re: MySQL problem on Ubuntu

Postby sjaz » Tue Jun 17, 2014 10:00 pm

Very useful info, thanks for the link:)
User avatar
sjaz
Forum Admin
Forum Admin
 
Posts: 694
Joined: Fri Feb 14, 2003 11:08 pm
Location: London, UK


Return to Troubleshooting

Who is online

Users browsing this forum: No registered users and 13 guests

cron