When i login to the root for the server and go to mysql process list i see a lot of processes that are connected to photo handling and the sate is Locked with over 500 seconds of each one.
I see there is one process that the state says: Copying to tmp table
I read online that if this is taking long it might lock up other queries causing your server to perform slow and only solution is to restart mysql servers.
Right now i have over 100 queries that say Locked and one that says Copying to tmp table....each time i have to restart the mysql services but this happens every 10 minutes as i have enough traffic to cause this problem.
Aug 17, 2007 01:06:16 PM VPS is locked at the moment. It may take some time.(locked) VPS is up and running now.running Aug 17, 2007 01:06:10 PM VPS is locked at the moment. It may take some time.(locked,mounted) VPS is locked at the moment. It may take some time.(locked,running) Aug 17, 2007 01:06:04 PM VPS is mounted now. It is not running and some operations are not available.mounted VPS is locked at the moment. It may take some time.(locked) Aug 17, 2007 01:05:49 PM VPS is up and running now.running VPS is mounted now. It is not running and some operations are not available.mounted Aug 17, 2007 12:46:10 PM VPS is locked at the moment. It may take some time.(locked) VPS is up and running now.running Aug 17, 2007 12:46:04 PM VPS is mounted now. It is not running and some operations are not available.mounted VPS is locked at the moment. It may take some time.(locked) Aug 17, 2007 12:45:16 PM VPS is up and running now.running VPS is mounted now. It is not running and some operations are not available.mounted Aug 17, 2007 09:37:13 AM VPS is starting up at the moment. It may take some time.(starting) VPS is up and running now.running Aug 17, 2007 09:37:10 AM VPS is stopping now. It may take some time.(stopping) VPS is starting up at the moment. It may take some time.(starting) Aug 17, 2007 09:36:52 AM VPS is up and running now.running VPS is stopping now. It may take some time.(stopping) Aug 17, 2007 08:51:46 AM VPS is locked at the moment. It may take some time.(locked) VPS is up and running now.running Aug 17, 2007 08:51:25 AM VPS is up and running now.running VPS is locked at the moment. It may take some time.(locked) Aug 16, 2007 03:00:18 PM VPS is locked at the moment. It may take some time.(locked) VPS is up and running now.running Aug 16, 2007 03:00:03 PM VPS is mounted now. It is not running and some operations are not available.mounted VPS is locked at the moment. It may take some time.(locked) Aug 16, 2007 02:59:39 PM VPS is up and running now.running VPS is mounted now. It is not running and some operations are not available.mounted Also I'm receiving emails with ftpd, exim, cpsrvd failed when that happens:
Code: ftpd failed @ Fri Aug 17 09:37:26 2007. A restart was attempted automagically.
Code: Kernel Version2.6.18-4-686 (SMP) Distro Name Debian 4.0 Model Intel(R) Pentium(R) 4 CPU 2.40GHz I've installed the default apache 2, mysql, php using aptitude.
The server load is not at all high, around 1-1.5 max. The apache processes running are at an avg 60-80. It has 1GB ram and Disk Swap usage is 0kB
My server keeps rebooting every now and then. These are the messages I get in the ssh session just before the reboot..
Code: Message from syslogd@xxx at xxx kernel: Bad page state in process 'apache2' kernel: page:c17bc0a0 flags:0xc0000000 mapping:00800040 mapcount:0 count:0 kernel: Trying to fix it up, but a reboot is needed kernel: Backtrace:
This has happened twice now. I have my wait_timeout variable set to 60 seconds, but occasionally my database gets overloaded with "locked" queries. Here's an example of my processlist:
This continues on with locked queries all the way up to my limit of 450 connections, then the whole server goes down. Note the time spent processing these queries, 35483 seconds and counting! Surely the wait_timeout is supposed to prevent this from happening?!
Also, this appears to start with queries in the State "statistics". Then the State for the following queries becomes "locked". Does anyone know what these mean? Can I get them to timeout normally? Queries which never timeout are guaranteed to bring your server down eventually, surely this is not the desired behaviour.
I have a constant mysql process using 10-20% CPU, its very strange because the process is always present, if I restart apache and mysql and I just open the phpmyadmin or any website connecting to the DB I get this error.
With strace I have seen that the process details are:
futex(0x87326c4, 0x5 /* FUTEX_??? */, 1) = 1 futex(0x8732174, FUTEX_WAKE, 1) = 1 select(15, [13 14], NULL, NULL, NULL) = 1 (in [14]) fcntl64(14, F_SETFL, O_RDWR|O_NONBLOCK) = 0 accept(14, {sa_family=AF_FILE, path="ӿ"}, [2]) = 25 fcntl64(14, F_SETFL, O_RDWR) = 0 getsockname(25, {sa_family=AF_FILE, path="/var/run/mysql"}, [30]) = 0 fcntl64(25, F_SETFL, O_RDONLY) = 0 fcntl64(25, F_GETFL) = 0x2 (flags O_RDWR) fcntl64(25, F_SETFL, O_RDWR|O_NONBLOCK) = 0 setsockopt(25, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported) The strace show that this piece of code is being repeated everytime that any website or app is using the database.
I have seen that the process call to the path /var/run/mysql in:
getsockname(15, {sa_family=AF_FILE, path="/var/run/mysql "}, [30]) = 0 ...but in my system the path doesnt exists, its /var/run/mysqld/ and I cant find a call to "/var/run/mysql" in any file of the server (i have tryed with sudo grep -nr '/var/run/mysql' /)
Server specs: CENTOS Enterprise 4.6 i686 Linux 2.6.9-67.0.7.ELsmp Core2Duo E6750 PHP Version 5.2.5 MySQL 5.0.45
I have a single mysql process that never stops and running with 10-200% CPU load: URL....
I restart mysql => process coming back I restart server => process coming back I kill process => process coming back
I have run: # mysqladmin -uadmin -p`cat /etc/psa/.psa.shadow` -i 1 processlist but there was noting that runs >10min.
Code: > SHOW FULL PROCESSLIST; +------+-------+-----------+------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+-------+-----------+------+---------+------+-------+-----------------------+ | 328 | admin | localhost | psa | Sleep | 56 | | NULL | | 8110 | admin | localhost | NULL | Query | 0 | init | SHOW FULL PROCESSLIST | +------+-------+-----------+------+---------+------+-------+-----------------------+ 2 rows in set (0.00 sec) I have strace the PID
Code: # timeout 1m strace -f -c -p 5873 Process 5873 attached with 30 threads - interrupt to quit Process 10499 attached (waiting for parent) Process 10499 resumed (parent 5873 ready) Process 10502 attached (waiting for parent) Process 10502 resumed (parent 5873 ready) Process 10503 attached (waiting for parent)
[code]....
I found with google a hint for high cpu URL....I have deinstalled "health monitor" module, but that was not the reason.I use plesk 12.0.18 Update #38 with CentOS 6.6 (Final).
I need to get a list of suspend domains from mysql. The domains are suspend because they exceeded quota.So far I have done this query:
#############
select domains.id, domains.name as domena, Round(((sum(domains.real_size))/1048576),2) realMB,
(select Round((limits.value/1048576),2) from limits left join (domains, subscriptions, subscriptionproperties) on (domains.id=subscriptions.object_id and subscriptions.id=subscriptionproperties.subscription_id and subscriptionproperties.value=limits.id) where subscriptionproperties.name='limitsId' and limits.limit_name='disk_space' and domains.name=domena) quotaMB from domains where domains.status='2' and (select (sum(domains.real_size)))>0 group by domains.cl_id;
but I didnt managed to get only those that exceed the quota.
I'm sure by now we have all noticed the Liquid Web ads for solid state drives by now. These offerings would make for incredible database servers, among other things.My questions is:
How many of you are going to run out and get a solution like this, from liquidweb or anyone else? Why or why not?
when I tried to reboot my VPS via Hypervm Enterprise I got this error:
=========== Alert: The vps myvps.vm is locked by another user. This would also be because you had interrupted an earlier activity that would take long time to complete. HyperVM has waited 15 seconds for the other process to finish. Please try after sometime. ===========
and memory usage going crazy it's going from 400MB "natural usage level" to 1024MB then the vps and all sites going down.
Today i got home from work to find none of my websites responding. When i ping the server i get a response as normal so i know its online. It seems the firewall iptables is blocking all incoming access to the server. When trying to connect to ssh nothing happens (just a blank black screen) heres a screenshot: [url]
I rang my datacenter but no one is there as its sunday evening.
Is there anyway i can get into the server to turn off the firewall?
Have a new client who's locked themselves out of their web server. Basically they've forgotten their password. Sadly there's no backup admin account.
It's a Dell PE1950 running Win2K3 R2 (SP2). Standalone server (non-domain). OS is in RAID-1 on a PERC 5i card.
I've attempted to use BartPE and UBCD with various instruction sets I've found online regarding PERC controllers, but I can't actually get either of them to boot (just hangs at the 'loading PE' screen with the bar).
I've tried using
I'm thinking I'm screwing up the driver part somehow, as the discs otherwise boot on standard, non-RAID IDE systems. I'm using Win2K3 R2 media for my base package.
When account is accessed via Outlook an error is generated saying "mailbox is temp unavaliable because another email message is being delivered or another application is accessing it. The server responded: -ERR Timeout while obtaining a lock on /home/user/mail/domain.com/emailuser/inbox"
When attempt to login using HORDE I just cycle through logging in, going from login and trying to get to the In box and timing out as content fails to complete
I tried searching the forums for this, nothing. Anyone know what to do about this?
I have a customer that currently is paying a nice chunk of money every month for WebsitePros.com (one of those do it yourself sites).
Domain is registered by them and they are claiming if we want to cancel and get access to the domain name we have to pay a $100 fee(to gain access to the domain name).
I had to bump a server we have over at the planet, but I cannot seem to determine the cause of its unresponsiveness (everything down to even simple ping). I checked APF logs and it didn't show anything except its normal periodic refresh of rules and such. I also see an selinux warning about proftpd trying to get to proftpd.conf and I saw something about selinux blocking mysql from using mysql.sock as well - I temporarily disabled SELINUX all together (it was in targeted mode). In the log files, it did log the fact though that it received SIGTERM and was going to runlevel 0, so it wasn't completely dead. I've gone through quite a few other logs and have come up empty handed. Is there anything else I can do? I want to get to the bottom of this.
i want to star a real state portal, but i have some questions on what kind of server i will need.
So my real state portal will have: PHP/Sql Databases (for all the information) Up to 20000 images (50kb each) Up to 500 Videos (encoded in flv. 400kbps at full screen)
Visitors / moth: 100000
Assuming that every user that enter the site, views many houses, and videos and photos.
What kind of server or servers will i need to keep this website running?
connection state ESTABLISHED,RELATED is not working in my iptaables...?
Accept If input interface is lo Accept If state of connection is ESTABLISHED,RELATED Drop If protocol is ICMP Accept If protocol is TCP and destination port is 80 Accept If protocol is TCP and destination port is 99 Accept If protocol is TCP and destination port is 25 Accept If protocol is TCP and destination port is 110 Accept If protocol is TCP and destination port is 10000 Accept If protocol is TCP and destination port is 21 Accept If protocol is TCP and destination port is 30000:30500 Accept If protocol is UDP and destination port is 53 Accept If protocol is UDP and source port is 53 Accept If protocol is TCP and destination port is 445 Accept If protocol is TCP and destination port is 2390
this in my Incoming packets rules..
Outgoing packets are all accepted..
so if i made connection from the server the input rules shuld accept them because it is established and related connection.. But it wont work.. any ideas about it..? my vps is running on cent os 5.2 final..
