I am getting error whenever I try to dump mysql on VPS [root@99 init.d]# mysqldump -u root -p megablog_mega > megablog_blog.sql > Enter password: > mysqldump: Got error: 1017: Can't find file: > './megablog_mega/wp_63_post2cat.frm' (errno: 24) when using LOCK TABLES All resources on VPS are set to unlimited. Thanks.
Hi whatever, please post your my.conf esp. the value of "open-files-limit", may you set it to to a higher value. Regards, Thorsten
#define EMFILE 24 /* Too many open files */ it is either mysql config or UBC settings.
Hello /etc/my.cnf is blank there are no values my.cnf details [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid -------------------------------------------- how can I increase value in my.cnf or UBC for the same. Thanks
ok, let's do the following: in VE: # cat /proc/user_beancounters > bc1 # strace -o out mysqldump -u root -p megablog_mega > megablog_blog.sql # cat /proc/user_beancounters > bc2 and send me files bc1, bc2, out after that.
dev wrote on Wed, 11 October 2006 01:30 ok, let's do the following: in VE: # cat /proc/user_beancounters > bc1 # strace -o out mysqldump -u root -p megablog_mega > megablog_blog.sql # cat /proc/user_beancounters > bc2 and send me files bc1, bc2, out after that. ---------------------------------------------- # cat /proc/user_beancounters > bc1 # cat /proc/user_beancounters > bc2 No output --------------------------------------------------------- # strace -o out mysqldump -u root -p megablog_mega > megablog_blog.sql mysqldump: Got error: 1105: File './megablog_mega/wp_43_categories.MYD' not found (Errcode: 24) when using LOCK TABLES ----------------------------------------------------------
I see only one of 3 files requested. files: bc1, bc2, out. BTW, small mistake, run mysql-dump as: # strace -f -o out mysqldump -u root -p megablog_mega > megablog_blog.sql
I gave output of three files you requested I give again 1. # cat /proc/user_beancounters > bc1 No output 2. # cat /proc/user_beancounters > bc2 No output 3. # strace -f -o out mysqldump -u root -p megablog_mega > megablog_mega.sql mysqldump: Got error: 1105: File './megablog_mega/wp_43_options.MYD' not found (Errcode: 24) when using LOCK TABLES Thanks dev wrote on Wed, 11 October 2006 01:53 I see only one of 3 files requested. files: bc1, bc2, out. BTW, small mistake, run mysql-dump as: # strace -f -o out mysqldump -u root -p megablog_mega > megablog_blog.sql
1. are you running mysql inside VE? 2. what kernel do you use? # uname -a 3. I need files content. # cat /proc/user_beancounters > bc1 doesn't generate output on the screen (if no error), but saves it to file 'bc1'. Are you trying to say, that file bc1 is empty? Same for files "bc2" and "out". Can you provide an access to the node? it will be quicker...
# uname -a 2.6.9 #1 Wed Jun 21 12:01:20 MSD 2006 i686 i686 i386 GNU/Linux The output of bc1 and bc2 are attached. Shall I pm you the root access? dev wrote on Wed, 11 October 2006 02:34 1. are you running mysql inside VE? 2. what kernel do you use? # uname -a 2.6.9 #1 Wed Jun 21 12:01:20 MSD 2006 i686 i686 i386 GNU/Linux 3. I need files content. # cat /proc/user_beancounters > bc1 doesn't generate output on the screen (if no error), but saves it to file 'bc1'. Are you trying to say, that file bc1 is empty? Same for files "bc2" and "out". Can you provide an access to the node? it will be quicker...
Not all the resources are set unlimited. You have ulimit for files = 1024: [root@v1 ~]# ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited pending signals (-i) 1024 max locked memory (kbytes, -l) unlimited max memory size (kbytes, -m) unlimited open files (-n) 1024 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 16317 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited So mysqld can't open more than 1024 files. To fix it you need to run /usr/bin/mysqld_safe with --open-files-limit argument or or specify open-files-limit=4096 in /etc/my.cnf But you added open_files_limit, not open-files-limit.
Seems you have modified the /etc/my.cnf to make it work I see open-files-limit=14096 Shall I try to take dump? Thanks
Thank you so much. I will try now and update you with the results
Thank you. It works perfectly fine dev wrote on Wed, 11 October 2006 04:35 yes. it should work now.