mysqld cannot start.
Hi, guys, I'm new to MySQL. I installed MySQL step-by-step according to the manual from source code. The version is mysql-5.5.28. When I start the server using: #bin/mysqld_safe --user=mysql The server failed to start with the following message in the log (attached below). There're two problems according to the log messages: 1. 121112 13:00:59 [ERROR] Can't read from messagefile '/usr/local/mysql/data/errmsg.sys I'm confused because I do have this file which is owned by user mysql: #ll /usr/local/mysql/data/errmsg.sys -rw-r--r-- 1 mysql mysql 0 Nov 12 12:35 /usr/local/mysql/data/errmsg.sys 2. 121112 13:00:59 [ERROR] An old style --language value with language specific part detected: /usr/local/mysql/data/ I commented the lc-messages-dir configuration entry in the my.cnf, but the error still exists... Could anyone take a look at the error log? Thanks a lot! T -- 121112 13:00:59 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 121112 13:00:59 [ERROR] An old style --language value with language specific part detected: /usr/local/mysql/data/ 121112 13:00:59 [ERROR] Use --lc-messages-dir without language specific part instead. 121112 13:00:59 [ERROR] Can't read from messagefile '/usr/local/mysql/data/errmsg.sys' 121112 13:00:59 InnoDB: The InnoDB memory heap is disabled 121112 13:00:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins 121112 13:00:59 InnoDB: Compressed tables use zlib 1.2.3.4 121112 13:00:59 InnoDB: Initializing buffer pool, size = 128.0M 121112 13:00:59 InnoDB: Completed initialization of buffer pool 121112 13:00:59 InnoDB: highest supported file format is Barracuda. 121112 13:00:59 InnoDB: Waiting for the background threads to start 121112 13:01:00 InnoDB: 1.1.8 started; log sequence number 1595675 121112 13:01:00 [ERROR] Aborting 121112 13:01:00 InnoDB: Starting shutdown... 121112 13:01:00 InnoDB: Shutdown completed; log sequence number 1595675 121112 13:01:00 [Note] 121112 13:01:00 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 121112 13:03:49 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 121112 13:03:49 [ERROR] Can't find messagefile '/usr/share/errmsg.sys' 121112 13:03:49 InnoDB: The InnoDB memory heap is disabled 121112 13:03:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins 121112 13:03:49 InnoDB: Compressed tables use zlib 1.2.3.4 121112 13:03:49 InnoDB: Initializing buffer pool, size = 128.0M 121112 13:03:49 InnoDB: Completed initialization of buffer pool 121112 13:03:49 InnoDB: highest supported file format is Barracuda. 121112 13:03:49 InnoDB: Waiting for the background threads to start 121112 13:03:50 InnoDB: 1.1.8 started; log sequence number 1595675 121112 13:03:50 [ERROR] Aborting 121112 13:03:50 InnoDB: Starting shutdown... 121112 13:03:50 InnoDB: Shutdown completed; log sequence number 1595675 121112 13:03:50 [Note] 121112 13:03:50 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended -- Tianyin XU, http://cseweb.ucsd.edu/~tixu/
Re: mysqld cannot start.
On Mon, Nov 12, 2012 at 2:11 PM, Tianyin Xu t...@cs.ucsd.edu wrote: Hi, guys, I'm new to MySQL. I installed MySQL step-by-step according to the manual from source code. The version is mysql-5.5.28. When I start the server using: #bin/mysqld_safe --user=mysql The server failed to start with the following message in the log (attached below). There're two problems according to the log messages: 1. 121112 13:00:59 [ERROR] Can't read from messagefile '/usr/local/mysql/data/errmsg.sys I'm confused because I do have this file which is owned by user mysql: #ll /usr/local/mysql/data/errmsg.sys -rw-r--r-- 1 mysql mysql 0 Nov 12 12:35 /usr/local/mysql/data/errmsg.sys Check the permissions of all the dirs in that path: /usr, /usr/local, /usr/local/mysql, /usr/local/mysql/data. The mysql user will need r-x access to all of them. 2. 121112 13:00:59 [ERROR] An old style --language value with language specific part detected: /usr/local/mysql/data/ I commented the lc-messages-dir configuration entry in the my.cnf, but the error still exists... Don't know what platform you're on, but on my Mac I had this issue, and I got around it by starting the server with: --lc-messages-dir=/usr/local/mysql/share/ On CentOS and RHEL I did not have this issue. HTH- larry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysqld cannot start.
Hi, Larry, Thanks a lot for the reply! On Mon, Nov 12, 2012 at 1:27 PM, Larry Martell larry.mart...@gmail.comwrote: On Mon, Nov 12, 2012 at 2:11 PM, Tianyin Xu t...@cs.ucsd.edu wrote: Hi, guys, I'm new to MySQL. I installed MySQL step-by-step according to the manual from source code. The version is mysql-5.5.28. When I start the server using: #bin/mysqld_safe --user=mysql The server failed to start with the following message in the log (attached below). There're two problems according to the log messages: 1. 121112 13:00:59 [ERROR] Can't read from messagefile '/usr/local/mysql/data/errmsg.sys I'm confused because I do have this file which is owned by user mysql: #ll /usr/local/mysql/data/errmsg.sys -rw-r--r-- 1 mysql mysql 0 Nov 12 12:35 /usr/local/mysql/data/errmsg.sys Check the permissions of all the dirs in that path: /usr, /usr/local, /usr/local/mysql, /usr/local/mysql/data. The mysql user will need r-x access to all of them. I already did so. It's weird... From the log, it seems that mysqld encountered some problem when reading the messagefile. But the file does exist with permission. 2. 121112 13:00:59 [ERROR] An old style --language value with language specific part detected: /usr/local/mysql/data/ I commented the lc-messages-dir configuration entry in the my.cnf, but the error still exists... Don't know what platform you're on, but on my Mac I had this issue, and I got around it by starting the server with: --lc-messages-dir=/usr/local/mysql/share/ I'm working on Ubuntu-12.04. Yes, the configuration parameter is set as /usr/local/mysql/data/ (see the error message). I tried your setting but this time mysqld tells me 121112 13:46:28 [ERROR] bin/mysqld: unknown variable 'lc-message-dir=/usr/local/mysql/share/' 121112 13:46:28 [ERROR] Aborting What a mess... On CentOS and RHEL I did not have this issue. HTH- larry Probably I shall go to GDB to understand what's happening here... Great thanks! T -- Tianyin XU, http://cseweb.ucsd.edu/~tixu/
Re: mysqld cannot start.
On Mon, Nov 12, 2012 at 1:47 PM, Tianyin Xu t...@cs.ucsd.edu wrote: Hi, Larry, Thanks a lot for the reply! On Mon, Nov 12, 2012 at 1:27 PM, Larry Martell larry.mart...@gmail.comwrote: On Mon, Nov 12, 2012 at 2:11 PM, Tianyin Xu t...@cs.ucsd.edu wrote: Hi, guys, I'm new to MySQL. I installed MySQL step-by-step according to the manual from source code. The version is mysql-5.5.28. When I start the server using: #bin/mysqld_safe --user=mysql The server failed to start with the following message in the log (attached below). There're two problems according to the log messages: 1. 121112 13:00:59 [ERROR] Can't read from messagefile '/usr/local/mysql/data/errmsg.sys I'm confused because I do have this file which is owned by user mysql: #ll /usr/local/mysql/data/errmsg.sys -rw-r--r-- 1 mysql mysql 0 Nov 12 12:35 /usr/local/mysql/data/errmsg.sys Check the permissions of all the dirs in that path: /usr, /usr/local, /usr/local/mysql, /usr/local/mysql/data. The mysql user will need r-x access to all of them. I already did so. It's weird... From the log, it seems that mysqld encountered some problem when reading the messagefile. But the file does exist with permission. 2. 121112 13:00:59 [ERROR] An old style --language value with language specific part detected: /usr/local/mysql/data/ I commented the lc-messages-dir configuration entry in the my.cnf, but the error still exists... Don't know what platform you're on, but on my Mac I had this issue, and I got around it by starting the server with: --lc-messages-dir=/usr/local/mysql/share/ I'm working on Ubuntu-12.04. Yes, the configuration parameter is set as /usr/local/mysql/data/ (see the error message). I tried your setting but this time mysqld tells me 121112 13:46:28 [ERROR] bin/mysqld: unknown variable 'lc-message-dir=/usr/local/mysql/share/' 121112 13:46:28 [ERROR] Aborting What a mess... Oh, the above error message is caused by my typo. Yes, I set --lc-messages-dir=/usr/local/mysql/share/, and everything's ok... The latter error message (i.e., messagefile) is the chain reaction caused by the previous one (lc-messages-dir) which confused me. Thanks a lot, Larry! Tianyin On CentOS and RHEL I did not have this issue. HTH- larry Probably I shall go to GDB to understand what's happening here... Great thanks! T -- Tianyin XU, http://cseweb.ucsd.edu/~tixu/ -- Tianyin XU, http://cseweb.ucsd.edu/~tixu/
Re: help! mysqld cannot start!
It doesn't particularly say, but this: 120116 19:15:29 120116 19:15:29 InnoDB: 1.1.8 started; log sequence number 1595675 suggests to me that there's still junk from a previous install around. You might want to clean that up. - Original Message - From: mantianyu mantia...@gmail.com To: mysql@lists.mysql.com Sent: Monday, 16 January, 2012 12:37:07 PM Subject: help! mysqld cannot start! I have download the Linux - Generic 2.6 (x86, 32-bit), Compressed TAR Archive binary edition and I installed it all followed the INSTALL_BINARY but at last step I start the service by run sudo bin/mysqld_safe --user=mysql I got following error message cifer@Pig:/usr/local/mysql$ 120116 19:15:28 mysqld_safe Logging to '/var/log/mysql/error.log'. 120116 19:15:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 120116 19:15:30 mysqld_safe mysqld from pid file /var/lib/mysql/Pig.pid ended and I check the error.log file it shows that 120116 19:15:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 120116 19:15:28 [ERROR] Can't find messagefile '/usr/share/errmsg.sys' 120116 19:15:28 [Note] Plugin 'FEDERATED' is disabled. 120116 19:15:28 InnoDB: The InnoDB memory heap is disabled 120116 19:15:28 InnoDB: Mutexes and rw_locks use InnoDB's own implementation 120116 19:15:28 InnoDB: Compressed tables use zlib 1.2.3 120116 19:15:28 InnoDB: Using Linux native AIO 120116 19:15:28 InnoDB: Initializing buffer pool, size = 128.0M 120116 19:15:28 InnoDB: Completed initialization of buffer pool 120116 19:15:28 InnoDB: highest supported file format is Barracuda. 120116 19:15:28 InnoDB: Waiting for the background threads to start 120116 19:15:29 InnoDB: 1.1.8 started; log sequence number 1595675 120116 19:15:29 [ERROR] Aborting 120116 19:15:29 InnoDB: Starting shutdown... 120116 19:15:30 InnoDB: Shutdown completed; log sequence number 1595675 120116 19:15:30 [Note] 120116 19:15:30 mysqld_safe mysqld from pid file /var/lib/mysql/Pig.pid ended every step I followed the INSTALL_BINARY file why it still can't start? who can help me? thanks! -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: help! mysqld cannot start!
2012/01/16 19:37 +0800, mantianyu but at last step I start the service by run sudo bin/mysqld_safe --user=mysql I got following error message cifer@Pig:/usr/local/mysql$ 120116 19:15:28 mysqld_safe Logging to '/var/log/mysql/error.log'. Your means of starting does not show where the MySQL own files are. The flag -b (--basedir) is used for that. It works also to start mysqld in the directory where the default my.cnf was left. If that has everything that MySQL needs, it works also to start with --defaults-file=/my.cnf--the four dots stand for the rest of the full pathname. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: help! mysqld cannot start!
On Mon, Jan 16, 2012 at 4:37 AM, mantianyu mantia...@gmail.com wrote: I have download the Linux - Generic 2.6 (x86, 32-bit), Compressed TAR Archive binary edition and I installed it all followed the INSTALL_BINARY but at last step I start the service by run sudo bin/mysqld_safe --user=mysql I got following error message cifer@Pig:/usr/local/mysql$ 120116 19:15:28 mysqld_safe Logging to '/var/log/mysql/error.log'. 120116 19:15:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 120116 19:15:30 mysqld_safe mysqld from pid file /var/lib/mysql/Pig.pid ended and I check the error.log file it shows that 120116 19:15:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 120116 19:15:28 [ERROR] Can't find messagefile '/usr/share/errmsg.sys' 120116 19:15:28 [Note] Plugin 'FEDERATED' is disabled. 120116 19:15:28 InnoDB: The InnoDB memory heap is disabled 120116 19:15:28 InnoDB: Mutexes and rw_locks use InnoDB's own implementation 120116 19:15:28 InnoDB: Compressed tables use zlib 1.2.3 120116 19:15:28 InnoDB: Using Linux native AIO 120116 19:15:28 InnoDB: Initializing buffer pool, size = 128.0M 120116 19:15:28 InnoDB: Completed initialization of buffer pool 120116 19:15:28 InnoDB: highest supported file format is Barracuda. 120116 19:15:28 InnoDB: Waiting for the background threads to start 120116 19:15:29 InnoDB: 1.1.8 started; log sequence number 1595675 120116 19:15:29 [ERROR] Aborting 120116 19:15:29 InnoDB: Starting shutdown... 120116 19:15:30 InnoDB: Shutdown completed; log sequence number 1595675 120116 19:15:30 [Note] 120116 19:15:30 mysqld_safe mysqld from pid file /var/lib/mysql/Pig.pid ended every step I followed the INSTALL_BINARY file why it still can't start? who can help me? thanks! I had the same issue, and I solved it by starting the server with this command line option: --lc-messages-dir=/usr/local/mysql/share/ HTH, -larry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysqld cannot start - Can't find file: './mysql/host.frm' (errno: 13)
magnus, Monday, April 15, 2002, 9:04:10 PM, you wrote: mllDescription: mll I installed the binary distribution (first time I am installing mysql ever) for Solaris 8 in a non-standard location (/data/mysql/3.23.47/SunOS_5.8) which is local on the server. I then mll moved the data directory to a file server so it will be part of daily backups (/proj/webamt/rel/mysqldb). I followed the steps in the INSTALL-BINARY file for the non-standard location. mll I changed all permissions and ownership as described in the doc - modified and copied the startup script, support-files/mysql.server to /etc/init.d and made symbolic links in rc2.d. Then mll (as root) I ran 'scripts/mysql_install_db --datadir=/proj/webamt/rel/mysqldb' and then 'bin/safe_mysqld --user=mysql --datadir=/proj/webamt/rel/mysqldb ' and the following error was reported in mll the log file (/proj/webamt/rel/mysqldb/amthq2.err): mll 020415 11:33:39 mysqld started mll 020415 11:33:39 /data/mysql/3.23.47/SunOS_5.8/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) mll 020415 11:33:39 mysqld ended Error code 13 means that your *nix user has no permissions on MySQL data dir. Try: chown -R mysql.mysql /proj/webamt/rel/mysqldb -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqld cannot start - Can't find file: './mysql/host.frm' (errno: 13)
Description: I installed the binary distribution (first time I am installing mysql ever) for Solaris 8 in a non-standard location (/data/mysql/3.23.47/SunOS_5.8) which is local on the server. I then moved the data directory to a file server so it will be part of daily backups (/proj/webamt/rel/mysqldb). I followed the steps in the INSTALL-BINARY file for the non-standard location. I changed all permissions and ownership as described in the doc - modified and copied the startup script, support-files/mysql.server to /etc/init.d and made symbolic links in rc2.d. Then (as root) I ran 'scripts/mysql_install_db --datadir=/proj/webamt/rel/mysqldb' and then 'bin/safe_mysqld --user=mysql --datadir=/proj/webamt/rel/mysqldb ' and the following error was reported in the log file (/proj/webamt/rel/mysqldb/amthq2.err): 020415 11:33:39 mysqld started 020415 11:33:39 /data/mysql/3.23.47/SunOS_5.8/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020415 11:33:39 mysqld ended How-To-Repeat: Fix: Submitter-Id: [EMAIL PROTECTED] Originator:Magnus Larsson Organization: Ericsson Amplifier Technologies Inc. 49 Wireless Blvd. Hauppauge, NY 11788 USA MySQL support: none Synopsis: Startup/config truoble Severity: non-critical Priority: medium Category: mysql Class: support Release: mysql-3.23.47 (Official MySQL binary) Environment: Sun Netra T1 (Ultra-SPARC), 1 GB RAM, 64 GB HDD; Solaris 8 (64-bit); /data/mysql/3.23.47/SunOS_5.8 (install dir); /proj/webamt/rel/mysqldb (database dir); LD_LIBRARY_PATH /data/mysql/0/SunOS_5.8/lib:/data/webserver/1.0.1/SunOS_5.8/lib:/usr/lib:/usr/local/lib:/usr/dt/lib:/usr/openwin/lib:/usr/ccs/lib:/usr/share/lib System: SunOS amthq2 5.8 Generic_108528-09 sun4u sparc SUNW,UltraAX-i2 Architecture: sun4 Some paths: /data/webserver/1.0.1/SunOS_5.8/bin/perl /data/webserver/1.0.1/SunOS_5.8/bin/make /usr/local/bin/gmake /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1759400 Jul 30 2001 /lib/libc.a lrwxrwxrwx 1 root root 11 Aug 3 2001 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136720 Jul 30 2001 /lib/libc.so.1 -rw-r--r-- 1 root bin 1759400 Jul 30 2001 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Aug 3 2001 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136720 Jul 30 2001 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --enable-assembler --disable-shared - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php