OpenVZ Forum


Home » General » Support » *SOLVED* Mysql dump error in VPS
*SOLVED* Mysql dump error in VPS [message #7304] Tue, 10 October 2006 16:58 Go to next message
whatever is currently offline  whatever
Messages: 142
Registered: September 2006
Senior Member
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.

[Updated on: Wed, 11 October 2006 08:12] by Moderator

Report message to a moderator

Re: Mysql dump error in VPS [message #7309 is a reply to message #7304] Wed, 11 October 2006 01:51 Go to previous messageGo to next message
curx
Messages: 739
Registered: February 2006
Location: Nürnberg, Germany
Senior Member
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

[Updated on: Wed, 11 October 2006 01:53]

Report message to a moderator

Re: Mysql dump error in VPS [message #7315 is a reply to message #7304] Wed, 11 October 2006 04:54 Go to previous messageGo to next message
dev is currently offline  dev
Messages: 1693
Registered: September 2005
Location: Moscow
Senior Member
#define EMFILE 24 /* Too many open files */

it is either mysql config or UBC settings.

http://static.openvz.org/userbars/openvz-developer.png

Report message to a moderator

Re: Mysql dump error in VPS [message #7316 is a reply to message #7304] Wed, 11 October 2006 05:03 Go to previous messageGo to next message
whatever is currently offline  whatever
Messages: 142
Registered: September 2006
Senior Member
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

Report message to a moderator

Re: Mysql dump error in VPS [message #7317 is a reply to message #7316] Wed, 11 October 2006 05:30 Go to previous messageGo to next message
dev is currently offline  dev
Messages: 1693
Registered: September 2005
Location: Moscow
Senior Member
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.

http://static.openvz.org/userbars/openvz-developer.png

Report message to a moderator

Re: Mysql dump error in VPS [message #7318 is a reply to message #7317] Wed, 11 October 2006 05:42 Go to previous messageGo to next message
whatever is currently offline  whatever
Messages: 142
Registered: September 2006
Senior Member
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
----------------------------------------------------------

Report message to a moderator

Re: Mysql dump error in VPS [message #7319 is a reply to message #7318] Wed, 11 October 2006 05:53 Go to previous messageGo to next message
dev is currently offline  dev
Messages: 1693
Registered: September 2005
Location: Moscow
Senior Member
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

http://static.openvz.org/userbars/openvz-developer.png

Report message to a moderator

Re: Mysql dump error in VPS [message #7320 is a reply to message #7319] Wed, 11 October 2006 06:14 Go to previous messageGo to next message
whatever is currently offline  whatever
Messages: 142
Registered: September 2006
Senior Member
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

Report message to a moderator

Re: Mysql dump error in VPS [message #7321 is a reply to message #7320] Wed, 11 October 2006 06:34 Go to previous messageGo to next message
dev is currently offline  dev
Messages: 1693
Registered: September 2005
Location: Moscow
Senior Member
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...

http://static.openvz.org/userbars/openvz-developer.png

Report message to a moderator

Re: Mysql dump error in VPS [message #7323 is a reply to message #7321] Wed, 11 October 2006 06:45 Go to previous messageGo to next message
whatever is currently offline  whatever
Messages: 142
Registered: September 2006
Senior Member
# 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...

Report message to a moderator

Re: Mysql dump error in VPS [message #7325 is a reply to message #7323] Wed, 11 October 2006 07:08 Go to previous messageGo to next message
dev is currently offline  dev
Messages: 1693
Registered: September 2005
Location: Moscow
Senior Member
yes, please pm

http://static.openvz.org/userbars/openvz-developer.png

Report message to a moderator

Re: Mysql dump error in VPS [message #7329 is a reply to message #7304] Wed, 11 October 2006 08:11 Go to previous messageGo to next message
dev is currently offline  dev
Messages: 1693
Registered: September 2005
Location: Moscow
Senior Member
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.

http://static.openvz.org/userbars/openvz-developer.png

Report message to a moderator

Re: Mysql dump error in VPS [message #7330 is a reply to message #7329] Wed, 11 October 2006 08:22 Go to previous messageGo to next message
whatever is currently offline  whatever
Messages: 142
Registered: September 2006
Senior Member
Seems you have modified the /etc/my.cnf to make it work Smile
I see
open-files-limit=14096
Shall I try to take dump?
Thanks

Report message to a moderator

Re: Mysql dump error in VPS [message #7331 is a reply to message #7330] Wed, 11 October 2006 08:35 Go to previous messageGo to next message
dev is currently offline  dev
Messages: 1693
Registered: September 2005
Location: Moscow
Senior Member
yes. it should work now.

http://static.openvz.org/userbars/openvz-developer.png

Report message to a moderator

Re: Mysql dump error in VPS [message #7333 is a reply to message #7331] Wed, 11 October 2006 08:41 Go to previous messageGo to next message
whatever is currently offline  whatever
Messages: 142
Registered: September 2006
Senior Member
Thank you so much.
I will try now and update you with the results Smile
Very Happy

Report message to a moderator

Re: Mysql dump error in VPS [message #7342 is a reply to message #7331] Wed, 11 October 2006 12:18 Go to previous message
whatever is currently offline  whatever
Messages: 142
Registered: September 2006
Senior Member
Thank you. It works perfectly fine Smile

dev wrote on Wed, 11 October 2006 04:35

yes. it should work now.

Report message to a moderator

Previous Topic: modconf
Next Topic: *SOLVED* getting rid of venet0 - just physical interfaces
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Sat Nov 02 16:02:22 GMT 2024

Total time taken to generate the page: 0.03594 seconds
Powered by FUDforum Powered by Virtuozzo Containers