Percona MySQL 5.5 fails to start
Posted
by
keymone
on Server Fault
See other posts from Server Fault
or by keymone
Published on 2011-08-08T16:22:28Z
Indexed on
2012/04/06
11:33 UTC
Read the original article
Hit count: 473
trying to setup new server here but keep getting this in error log:
mysqld_safe Starting mysqld daemon with databases from /data/mysql/myisam
[Warning] Can't create test file /data/mysql/myisam/hostname.lower-test
[Warning] Can't create test file /data/mysql/myisam/hostname.lower-test
[Note] Flashcache bypass: disabled
[Note] Flashcache setup error is : setmntent failed
/usr/sbin/mysqld: File '/var/mysql/bin/bin-log.index' not found (Errcode: 13)
[ERROR] Aborting
[Note] /usr/sbin/mysqld: Shutdown complete
mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
everything under /data/mysql
(it's ibdata and myisam folders) is owned my mysql:mysql and has proper permissions
same goes for folders with bin and relay logs under /var/mysql
apparmor is purged from server
any ideas?
PS
it seems like something else apart from apparmor is affecting permissions to access mysql files
after i changed data directory to more default one - /var/lib/mysql and "Can't create test file" error is gone, but "'/var/mysql/bin/bin-log.index' not found (Errcode: 13)" is still there
PPS
so i installed apparmor back and added all folders to mysqld's profile and errors mentioned above are now gone(or mysql doesn't even get to that point now)
what i have now is this: /usr/sbin/mysqld: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
banging my head against the wall.
© Server Fault or respective owner