Requota Make Server Highload And Mysql Failed

Aug 24, 2007

today mysql server just went down and below is ps aux result

Quote:

khuvuich 4821 0.1 1.2 34580 24760 ? S 08:44 0:00 /usr/local/cpanel/cpanel ./frontend/x3/index.html
root 4822 0.0 0.0 1980 644 ? D 08:44 0:00 quota -v
nobody 5079 0.0 0.2 9248 4612 ? S 08:46 0:00 /usr/local/apache/bin/httpd -DSSL
root 5202 0.1 0.1 12344 4060 ? Ss 08:46 0:00 /usr/sbin/exim -Mc 1IOjnZ-0001Lt-Sq
mailnull 5207 0.0 0.1 12348 2236 ? S 08:46 0:00 /usr/sbin/exim -Mc 1IOjnZ-0001Lt-Sq
root 5233 0.3 0.2 9940 5064 ? S 08:46 0:00 /usr/bin/perl /scripts/restartsrv_mysql --restart
root 5262 0.0 0.0 4580 1200 ? S 08:46 0:00 /bin/sh /etc/rc.d/init.d/mysql start
root 5423 0.0 0.0 5796 528 ? S 08:47 0:00 sleep 1
root 5424 0.0 0.0 4288 788 pts/5 R+ 08:47 0:00 ps aux
root 5592 0.0 0.1 7612 4012 ? S Aug23 0:01 /etc/authlib/authProg
root 6889 0.0 0.0 3216 644 ? D 05:00 0:00 quota -v
root 8687 100 0.0 3360 556 ? R 01:47 419:13 /usr/sbin/repquota -auv
root 8701 0.0 0.0 2196 524 ? D 01:47 0:00 /usr/sbin/repquota -auv
root 10187 0.0 0.1 7612 4084 ? S Aug23 0:01 /etc/authlib/authProg
root 10833 0.0 0.0 0 0 ? S Aug24 0:15 [pdflush]
root 11900 0.0 0.0 3340 524 ? D 02:02 0:00 /usr/sbin/repquota -auv
root 11921 0.0 0.0 2012 524 ? D 02:02 0:00 /usr/sbin/repquota -auv
root 12142 0.0 0.1 7612 4088 ? S Aug23 0:01 /etc/authlib/authProg
root 14413 0.0 0.0 2172 524 ? D 02:15 0:00 /usr/sbin/repquota -auv
root 14437 0.0 0.0 3172 524 ? D 02:15 0:00 /usr/sbin/repquota -auv
root 14534 0.0 0.0 2888 520 ? D 02:16 0:00 /usr/sbin/repquota -auv
root 14601 0.0 0.1 7612 4012 ? S Aug23 0:02 /etc/authlib/authProg
root 14805 0.0 0.0 2564 524 ? D 02:18 0:00 /usr/sbin/repquota -auv
root 14959 0.0 0.0 1848 520 ? D 02:19 0:00 /usr/sbin/repquota -auv
root 15695 0.0 0.4 20540 10060 ? S Aug24 0:01 cpsrvd - waiting for connections
root 16091 0.0 0.0 3096 632 ? DN 02:25 0:00 quota -v kd4rumn
root 17065 0.0 0.1 7612 4088 ? S Aug23 0:01 /etc/authlib/authProg
root 18882 0.0 0.0 3416 644 ? D 02:41 0:00 quota -v
root 19232 0.0 0.0 2428 644 ? D 07:14 0:00 quota -v
root 20506 0.0 0.0 3460 644 ? D 07:26 0:00 quota -v
root 20751 0.0 0.0 2896 640 ? D 07:28 0:00 quota -v
root 20808 0.0 0.0 3760 644 ? D 02:53 0:00 quota -v
root 21143 0.0 0.0 2676 644 ? D 07:30 0:00 quota -v
root 21615 0.0 0.0 3336 644 ? D 02:58 0:00 quota -v
root 21732 0.0 0.0 2076 520 ? D 07:32 0:00 /usr/sbin/repquota -auv
root 21871 0.0 0.0 3196 524 ? D 07:33 0:00 /usr/sbin/repquota -auv
root 21885 0.0 0.0 3408 640 ? D 03:00 0:00 quota -v
root 22190 0.0 0.0 2116 640 ? D 03:02 0:00 quota -v
root 22333 0.0 0.0 3196 520 ? D 07:34 0:00 /usr/sbin/repquota -auv
root 22350 0.0 0.0 2716 524 ? D 07:34 0:00 /usr/sbin/repquota -auv
root 22959 0.0 0.0 2748 640 ? D 03:08 0:00 quota -v
root 23312 0.0 0.0 3104 576 ? D 07:35 0:00 shutdown -r 0 w
root 23712 0.0 0.0 3116 520 ? D 07:36 0:00 /usr/sbin/repquota -auv
root 23941 0.0 0.0 3856 640 ? D 07:38 0:00 quota -v
root 24197 0.0 0.0 3512 644 ? D 03:16 0:00 quota -v
root 24928 0.0 0.0 2512 640 ? D 03:20 0:00 quota -v
root 25144 0.0 0.0 3844 644 ? D 03:21 0:00 quota -v
root 25830 0.0 0.0 1980 644 ? D 07:44 0:00 quota -v
root 26838 0.0 0.0 3204 640 ? D 03:32 0:00 quota -v
root 27238 0.0 0.0 3832 640 ? D 03:34 0:00 quota -v
root 27377 0.0 0.0 2912 640 ? D 03:36 0:00 quota -v
root 27433 0.0 0.0 2752 640 ? D 03:36 0:00 quota -v
root 27503 0.0 0.0 2176 644 ? D 03:37 0:00 quota -v
root 27659 0.0 0.0 2144 644 ? D 07:52 0:00 quota -v
root 27713 0.0 0.0 3832 1080 ? S 07:52 0:00 /usr/bin/perl /scripts/quota_auto_fix
root 27714 0.0 0.0 3832 440 ? S 07:52 0:00 /usr/bin/perl /scripts/quota_auto_fix
root 27715 0.0 0.0 3340 520 ? D 07:52 0:00 /usr/sbin/repquota -a
root 28543 0.0 0.0 2500 640 ? D 03:43 0:00 quota -v
root 29352 0.0 0.0 1520 576 ? D 07:59 0:00 shutdown -r 0 w
root 29417 0.0 0.0 0 0 ? Ds 08:00 0:00 [bash]
root 29538 0.0 0.2 9240 5248 ? Ss 08:01 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29543 0.0 0.2 9520 5264 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29546 0.0 0.2 9500 5232 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29547 0.0 0.2 9520 5376 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29548 0.0 0.2 9380 5416 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29549 0.0 0.2 9380 4792 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL
root 29556 0.0 0.0 3180 640 ? D 03:48 0:00 quota -v
root 29597 0.0 0.0 0 0 ? S Aug24 0:09 [pdflush]
nobody 29637 0.0 0.2 10044 5624 ? S 08:01 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29763 0.0 0.2 9380 5392 ? S 08:02 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29878 0.0 0.2 9520 4868 ? S 08:02 0:00 /usr/local/apache/bin/httpd -DSSL
nobody 29939 0.0 0.2 9520 4904 ? S 08:02 0:00 /usr/local/apache/bin/httpd -DSSL
root 30271 0.0 0.0 5812 576 ? D 08:03 0:00 /sbin/quotaoff -a
root 30425 0.0 0.0 2552 644 ? D 03:54 0:00 quota -v
root 30432 0.0 0.0 2636 640 ? D 08:04 0:00 quota -v
nobody 30466 0.0 0.2 9512 4844 ? S 08:05 0:00 /usr/local/apache/bin/httpd -DSSL
root 30609 0.0 0.0 3732 640 ? D 08:06 0:00 quota -v
root 30616 0.0 0.0 2328 640 ? D 08:06 0:00 quota -v
root 30994 0.0 0.0 2464 640 ? D 08:09 0:00 quota -v
root 31071 0.0 0.0 2156 644 ? D 08:09 0:00 quota -v
root 31250 0.0 0.0 2296 644 ? D 08:10 0:00 quota -v
root 31800 0.0 0.0 3508 524 ? D 08:12 0:00 /usr/sbin/repquota -auv
root 31828 0.0 0.1 8852 2328 ? Rs 08:12 0:00 sshd: root@pts/5
root 31851 0.0 0.0 4812 1444 pts/5 Ss 08:12 0:00 -bash
root 32295 0.0 0.0 2172 644 ? D 08:15 0:00 quota -v

and top result

Quote:

8687 root 19 0 3360 556 468 R 100 0.0 422:52.37 repquota
5817 nobody 16 0 9384 4728 1288 S 0 0.2 0:00.03 httpd
6119 root 17 0 3480 1024 764 R 0 0.0 0:00.01 top
1 root 16 0 2716 548 468 S 0 0.0 0:01.37 init
2 root RT 0 0 0 0 S 0 0.0 0:02.45 migration/0
3 root 34 19 0 0 0 R 0 0.0 0:00.05 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:00.75 migration/1
5 root 34 19 0 0 0 S 0 0.0 0:00.01 ksoftirqd/1
6 root 5 -10 0 0 0 R 0 0.0 0:04.17 events/0
7 root 5 -10 0 0 0 S 0 0.0 0:00.52 events/1
8 root 8 -10 0 0 0 S 0 0.0 0:00.00 khelper
9 root 15 -10 0 0 0 S 0 0.0 0:00.00 kacpid
35 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/0
36 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/1
37 root 15 0 0 0 0 S 0 0.0 0:00.00 khubd
56 root 16 0 0 0 0 S 0 0.0 0:48.82 kswapd0
57 root 12 -10 0 0 0 S 0 0.0 0:00.00 aio/0
58 root 12 -10 0 0 0 S 0 0.0 0:00.00 aio/1
202 root 25 0 0 0 0 S 0 0.0 0:00.00 kseriod
332 root 18 0 2356 644 560 D 0 0.0 0:00.00 quota
429 root 8 -10 0 0 0 S 0 0.0 0:00.00 ata/0
430 root 8 -10 0 0 0 S 0 0.0 0:00.00 ata/1
431 root 6 -10 0 0 0 S 0 0.0 0:00.00 ata_aux
435 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_0
436 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_1
437 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_2
438 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_3
439 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_4
440 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_5
461 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_6
462 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_7
523 root 15 0 0 0 0 S 0 0.0 0:43.22 kjournald
679 root 18 0 3516 640 560 D 0 0.0 0:00.00 quota
718 root 20 0 2648 644 560 D 0 0.0 0:00.00 quota
1017 root 19 0 2388 524 448 D 0 0.0 0:00.00 repquota
1213 root 18 0 2064 644 560 D 0 0.0 0:00.00 quota
1495 root 18 0 2124 644 560 D 0 0.0 0:00.00 quota
1678 root 18 0 3464 640 560 D 0 0.0 0:00.00 quota
1694 root 19 0 3576 640 560 D 0 0.0 0:00.00 quota

It make mysql server failed and when i try to restart got this

Quote:

MySQL manager or server PID file could not be found! [FAILED]

This issue is really strange as i never put requota to run in cronjob.

View 14 Replies


ADVERTISEMENT

Plesk 12.x / Linux :: Server Backup Failed - Could Not Run Make Dump With Pmmcli

Mar 5, 2015

I try to backup server and become error

Code:
# plesk bin pleskbackup server
UNIVERSAL->import is deprecated and will be removed in a future perl at (eval 13) line 3.
UNIVERSAL->import is deprecated and will be removed in a future perl at /usr/local/psa/PMM/agents/shared/IPC/Run.pm line 1060.
UNIVERSAL->import is deprecated and will be removed in a future perl at /usr/local/psa/PMM/agents/shared/IPC/Run/IO.pm line 78.
UNIVERSAL->import is deprecated and will be removed in a future perl at /usr/local/psa/PMM/agents/shared/IPC/Run/Timer.pm line 161.
Runtime error: Could not run make dump with pmmcli[Illegal seek]

Code:
# /usr/local/psa/admin/sbin/pmmcli
Traceback (most recent call last):
File "/usr/local/psa/admin/sbin/pmmcli", line 5, in <module>
import pmmcli
File "/usr/local/psa/admin/share/pmmcli/pmmcli.py", line 21, in <module>
import pmmcli_session
File "/usr/local/psa/admin/share/pmmcli/pmmcli_session.py", line 15, in <module>
import pmm_migration_handler
File "/usr/local/psa/admin/share/pmmcli/pmm_migration_handler.py", line 16, in <module>
import migration_handler
ImportError: Bad magic number in /usr/local/psa/admin/share/migration-handler/migration_handler.pyc

View 19 Replies View Related

How To Make MySQL Functions In PHP In Server

Mar 16, 2008

how to make MySQL functions in PHP in server,bcz when i intall VB in my dedicated server it comeing is there is any option in WHM to chnage these funtion!

View 14 Replies View Related

Is It Possible To Make Joomla Connect To An External Mysql Database Server

Jul 31, 2007

Is it possible to make Joomla connect to an external mysql database server?

Meaning, the database for Joomla won't be local, but on another server.

Will it work by just entering the mysql hostname, user and password in Joomla's config?

What issues might arose by doing this?

View 3 Replies View Related

HOW Ido That ( Suspend Account If Doing Highload Auto)

Oct 26, 2007

isee in bluehost.com if account doing high load is suspended some minute and back again

View 1 Replies View Related

Plesk Automation :: MySQL Server Not Starting Anymore - Failed To Restart Service

Jun 5, 2014

What could I fix by trying to start mysql server, recieve following errors:

plesk interface:

Code:
Failed to restart the "mysql" service.
Cannot start/stop/restart service: Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql restart
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the stop(8) and then start(8) utilities,
e.g. stop mysql ; start mysql. The restart(8) utility is also available.
start: Job failed to start

from the console:

Code:
sudo service mysql start
start: Job failed to start

Code:
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
output of plesk_11.5.30_reset_instance_data.log:

[Code] ...

View 4 Replies View Related

Plesk 12.x / Linux :: Enable To Create New MySQL Database Server - Test Connection Failed

May 7, 2015

I freshly installed Plesk 12.0 on Ubuntu 14.04. Everything works accept the MySQL database creation.

When I try to create one, i get this error :

error: the test connection to the database server has failed because of network problems: connection refused...

View 1 Replies View Related

Mysql Command To Make A New Database

Feb 22, 2008

what is SSH command - to make a new database with database name as ( ra_ra ) with database user as ( ra_ra ) and database password as 'ra'

View 4 Replies View Related

Plesk 12.x / Linux :: How To Make Different MySQL Settings For Customers

Oct 13, 2014

We are running Plesk 12.0.18 with MySQL (Server Version: 5.5.33-MariaDB - openSUSE package) on OpenSuSE 13.1

MySQL is running in strict mode and its fine for the most of our customers. But some are trying to run Contenido, thats a CMS, which could work with this mode and we have to disable mysql strict mode.

So my question is: Is it possible to disable mysql strict mode just for choosen customers?

View 5 Replies View Related

Starting MySQL .... [FAILED]

Feb 25, 2008

Sudden on my server is started getting this error relating sql

Lost connection to MySQL server during query

When i do service mysql start i get the error
/etc/init.d/mysql start

Starting MySQL................................... [FAILED]

View 7 Replies View Related

Eximstats / Mysql Failed

Mar 8, 2008

After a reboot mysql / eximstats remain failed.

I received no errors on restart eximstats, exim, mysql or cpanel.

I did a forced mysql upgrade and forced exim upgrade.

chmod 1777 /tmp did not help either.

What could be the cause? Everything else is green.

View 1 Replies View Related

Failed To Restart Mysql Service

Apr 12, 2009

My vps is run well, then i reboot and i see mysql no longer working. I check in WHM
mysql (5.0.67-community) failed

And when restart (by WHM )

Restarting MySQL Server

whmappname='Restarting Service'; if (self['update_ui_status']) { update_ui_status('MySQL Server'); } Waiting for mysql to restart..............finished.

mysqld_safe (/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/server.xxxx.com.pid) running as root with PID 5275

mysql has failed, please contact the sysadmin (result was "mysql has failed").

My VPS in unmanaged, i can't access mysql.

View 4 Replies View Related

Error: Install: %pre Scriptlet Failed (2), Skipping MYSQL-PACKAGE-NAME

Mar 31, 2008

I've been having trouble installing MySQL 5, strangely, on this VPS.

Upon every install, it is bound to give me the same error.

Quote:

root@host [~/src]# rpm -i --nodeps MySQL-server-community-5.0.51a-0.rhel5.i386.rpm
error: install: %pre scriptlet failed (2), skipping MySQL-server-community-5.0.51a-0.rhel5

Quote:

root@zendfree [~/src]# rpm -i --nodeps MySQL-server-5.0.51a-0.glibc23.i386.rpm
error: install: %pre scriptlet failed (2), skipping MySQL-server-5.0.51a-0.glibc23

I've tried out various RPMs - all of which gives :

error: install: %pre scriptlet failed (2), skipping MYSQL-PACKAGE-NAME.

View 14 Replies View Related

Plesk 11.x / Linux :: Failed To Execute Backup Of Mysql Database

Feb 19, 2015

My OS is CentOS 5.8.
Plesk is 11.0.9.

Having problems with failed daily domain backups. All databases that have been created by Plesk cannot be backed up, thus backup fails with the following message:

<?xml version="1.0" encoding="UTF-8"?>
<execution-result status="error" log-location="/usr/local/psa/PMM/sessions/2015-02-19-044701.875/migration.result">

[Code]...

View 4 Replies View Related

Plesk 11.x / Windows :: Import MySQL - Database Failed After Upgrade

Aug 13, 2013

Since we upgraded to Plesk 11.5 or (I'm not shure) the last Update 12, user can not import MySQL-Databases anymore.

If the user open phpMyAdmin for import and select the database and click on Ok, phpMyAdmin does nothing.

I heard that could be a problem with JQUERY and I checked the files in ParallelsadminhtdocsdomainsdatabasesphpMyAdminjsjquery and all files seems to be there.

Only if I check the source of the phpMyAdmin Import-Website it seems, there is a problem with jquery-1.6.2+fix-9521.js.

But how I can fix this problem for all Windows-Servers.

View 19 Replies View Related

How To Make Own Server

Apr 23, 2008

i want to make one web site i want to show there some movies same like youtube but my video will on media player .i want to make own server for hosting and i need more than 1tb storage .i don,t know which thing i need for own server .i just found there these kind of things Netgear ReadyNAS Duo RND2150 500GB i don,t know it will work for me or not

View 1 Replies View Related

How Can I Make Sure If My Server Is Hacked?

Jan 20, 2008

the data center tell me we use a lot of bandwidth,

and i check from the mrtg they offer to check,it reach about 80M,

my server really used a lot of bandwidth,

but i login whm to check the bandwidth of accounts,

and it looks likely my customers did not use a lot of bandwidth,

i worry if my server is hacked to attack others or other things,

how can i check this?

View 3 Replies View Related

How Do I Make Sure Everything I Got Is Actually Included On Server

May 1, 2009

I've recently ordered two new servers with Windows OS, and am wondering how I go about making sure the hard drives I ordered are the ones actually installed, and the RAM i ordered is the ram actually installed.

I know the amount of ram and amount of diskspace is correct by Properties and My Computer but not sure how to figure out the others.

View 5 Replies View Related

Make My Computer A Server

Jun 14, 2008

i heard from a friend that i can make my computer a server, is this true? how can this happen & is it safe, cheap?

View 9 Replies View Related

What Would Make For A Cool DNS Server

Aug 10, 2007

What makes DNS run the smoothest computer wise. What cpu combo for a dedicated DNS server would work the best?

View 14 Replies View Related

Would A Vps Make A Good Gaming Server?

Nov 4, 2009

Would a vps make a good gaming server?

I was thinking about marketing this type of service. I have no experience in implementing a gameing server so not sure about the requirements

Servers are hosted with rapidswitch in London with 1000mbps connectivity and low latency

Hosts are running vmware vsphere.

View 14 Replies View Related

How To Know Sites That Make Load On The Server

Jun 3, 2009

way to know the sites that make load on the server through SSH

View 5 Replies View Related

Can I Make A Web Hosting Server From An Old Computer

Aug 6, 2008

I want to make a website but I dont want to pay the hosting fees. I have a few old but pretty powerful old computers sitting around my house just collecting dust. Is there a way to make a web hosting server from those old computers to host my site? They have umbutu and I can make them dedicated.

View 14 Replies View Related

How Can I Make VPSs From Dedicated Server

Jul 6, 2007

I'm searching for how to create a VPSs From dedicated servers and sell it ..

the dedicated server will be :
4 processors 3.0
8 GB ram
1024 GB H.D.D. Sata II
1 GB Uplink

View 14 Replies View Related

Too Many DNS (Domain Name Server) Requests. How To Make It Lower ?

May 8, 2007

I host my DNS with DNSmadeeasy.com , I noticed that I have daily more than 350.000 DNS requests for main domain, This domains got about 80.000 uniqes/day, so this is strange how can there be 350.000 DNS requests/day. Seems that I'll go over the quota because of this.

The TTL for all domains is set to 86400.

Is there a way to discover how its possible ? And also is there a way to do something to make this number lower (DNS requests)

View 1 Replies View Related

What Domain Name Server (DNS) Changes To Make When Moving Hosts?

Mar 10, 2008

I have example.com as a reseller account hosted on a shared server. I have ns1.example.com and ns2.example.com on that server and client domains use these nameservers.

I want to move to a VPS for more control and so I have acquired vps.example.com. This also has vps_ns1.example.com and vps_ns2.example.com with it.

Can I move everything to the VPS? Assuming that I move the files over, if I simply changed the DNS of example.com to point to nameservers vps_ns1(and 2).example.com, what would happen?

Have I made it over complicated for me to understand, and it's actually a lot easier than I think? Or have I shot myself in the foot by using vps.example.com as the name for the VPS?

I am using cPanel/WHM for both servers.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved