setupdbmap eats all server memory

[RACKSET]

/usr/local/cpanel/bin/setupdbmap eats all server memory and causes server overload on each run with upcp.
-- CentOS 6.2 KVM Guest.
This only effects one server, as we have other servers the same config (actually clone) without any issue. I think the script should itself check it's memory usage to prevent this. Any advise to resolve this?

Also have to mention I have not any report of db/mysql issues from users, seems all works ok.

 

[MilesWeb]

@RACKSET How many databases on your server ? I have had executed it on many of the shared servers, but never had such issue. Check mysql error logs file under /var/lib/mysql. See if any database is corrupt.

 

[cPanelNick]

/usr/local/cpanel/bin/setupdbmap eats all server memory and causes server overload on each run with upcp.
-- CentOS 6.2 KVM Guest.
This only effects one server, as we have other servers the same config (actually clone) without any issue. I think the script should itself check it's memory usage to prevent this. Any advise to resolve this?

Also have to mention I have not any report of db/mysql issues from users, seems all works ok.

It would be very helpful to take a look at the server that is encountering the problem. If you could open a ticket using the link in my signature, we would be happy to help you out.

Thanks!

 

[RACKSET]

I found the cause of this, the script runs mysql query "SELECT User, Db FROM db WHERE user REGEXP '\\_' " and this caused mysql to eat all memory. I also was able to reproduce this issue from mysql console with running the same query. So it's not an issue on setupdbmap script, but why mysql is not able to handle this query? That's the story.

Mysql process status shows this thread in "Sending data". There is about 3000 db's on the server and all db's as I know work correctly. Any advise to improve "mysql db" appreciated.

 

[RACKSET]

Anyone can help to resolve mysql issue please?

 

[Infopro]

Anyone can help to resolve mysql issue please?

Have you opened a ticket on this? That would be your best way forward I believe.