My mysql server keeps on crashing. I wonder if it is because of out of memory. Last week, I upgraded my memory from 2GB to 6GB and I executed the command "free" to check memory usage. It uses 5GB in memory usage and leave under 10,000k unuse. Do you think this might be the cause of weekly mysql crashes?
I only use the server for mysql, so it is a dedicated mysql server.
I have a colocated server with the following specs:
Intel Core 2 Quad Q6600 2.4Ghz
4GB RAM
400GB SATA Drive
I have a problem every few days, the server keeps hanging up and giving an "Out of Memory" message and SSH just hangs and doesn't connect. Every time i have to call out a tech to manually reboot it.
Is there a setting i can change to make SSH connect even when it is out of memory, or anything that can prevent it happening?
We have recently recompiled Apache and now we are receiving MySQL errors on some of our sites. The errors are only displayed sometimes (not on every single load of the page).
We have been advised that the problem may be due to MySQL running out of memory - is this correct?
I have tried changing the 'memory_limit' in php.ini to 100MB but still this does not change anything. Here is the error we are receiving:
Code:
Warning: mysql_list_tables() [function.mysql-list-tables]: Unable to save MySQL query result in /home/username/public_html/includes/tables.php on line 16
Does anyone know if MySQL 5.1 or 5.0 uses less memory than 4.1 does?
View 3 Replies View RelatedI have a vps with 1GB of ram and mysql consume lots of memory I googled about this subject but everywhere mysql performance tuning is described
mysql has 10 threads like below
7338 mysql 0 0.0 4.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking
7339 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking
7378 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking
2507 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking
2517 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking
2518 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking
2519 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking
2520 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking
7399 mysql 0 0.14.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking
5162 mysql 0 0.04.5 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeta60.wuhosting.com.pid --skip-external-locking
my.cnf properties are
set-variable = max_connections=90
set-variable = wait_timeout=10
set-variable = connect_timeout=10
set-variable = long_query_time=4
skip-locking
key_buffer = 2M
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K
table_cache = 1M
query_cache_size = 1M
[isamchk]
key_buffer = 8M
sort_buffer_size = 8M
[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M
[mysqlhotcopy]
interactive-timeout
Since upgrading to Apache 2 I am no longer able to tell which domains are the busiest using CPU/Memory/MySQL Usage. Now Apache processes are all lumped together and individual domains only show cron, mail and FTP usage. I opened a ticket with cPanel and they know of the problem but there is still no solution. Is there another way I can tell which of my sites is using the most resources until this bug is fixed?
View 2 Replies View RelatedMySQL Error : Out of memory
I'm getting this very frequently today
MySQL Error : Out of memory (Needed 76760 bytes)
Error Number : 5
Request Date : Friday, November 7th 2008 @ 01:52:17 PM
Error Date : Friday, November 7th 2008 @ 01:52:18 PM
Script : [url]
Referrer : [url]
IP Address :
Username :
Classname : vB_Database
MySQL Version :
I have Mysql 5 installed, on a Centos/Cpanel box. Server has 4GB memory, server load is green/normal.
I already ran optimization on the database too.
It started happening yesterday, pretty much after I installed this hack:[url]
Quote:
[mysqld]
local-infile=0
datadir=/var/lib/mysql
skip-locking
skip-networking
safe-show-database
query_cache_limit=2M
query_cache_size=128M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=500
max_connections=500
interactive_timeout=10
wait_timeout=28800
connect_timeout=20
thread_cache_size=128
key_buffer=512M ## 128MB for every 1GB of RAM
join_buffer=8M
max_connect_errors=20
max_allowed_packet=32M
table_cache=1024
record_buffer=8M
sort_buffer_size=4M ## 1MB for every 1GB of RAM
read_buffer_size=4M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=4M ## 1MB for every 1GB of RAM
thread_concurrency=8 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
collation-server=latin1_swedish_ci
[mysql.server]
user=mysql
old-passwords = 1
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=24M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
Warning: mysql_connect() [function.mysql-connect]: Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug in /home/user/public_html/includes/functions.php on line 423
Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug
My mysql is using alot of memory although there is not much data into the mysql tables.
I tried to control mysql usage by editing my.cnf file but that didnt help.
Which variables should I edit in my.cnf to keep mysql using low memory?
I edited sort_buffer_size, key_buffer_size but that didnt help much. It uses alot of per-thread memory as well.
I'm always having MySQL consuming quite a bit of cpu & ram.
what's happening here?
PHP Code:
mysql 27519 7.2 12.8 158736 132496 ? Sl Mar08 180:57 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/server.hostname.pid --skip-external
I have replaced my server's real hostname to server.hostname
I am very low of system resources but wish to use MYSQL as my database backend so I have installed MYSQL 4.0 on my Debian Sarge 3.1 VPS with linuxthreads and configured it to use least possible resources as my VPS only offers 32MB main memory. Generally I use the PS command to get the memory usage of running processes. But MYSQL being threaded confuses me. My system uses linuxthreads so all the threads get listed as seperate processes but show same stats in PS command output. On initialization, MYSQL starts 3 threads which according to documentation, are necessary for its functioning. This is what I see:
root 139 0.0 0.0 2436 4 ? S Feb07 mysqld_safe
mysql 163 0.0 4.5 5480 1264 ? S Feb07 0:02 mysqld
mysql 164 0.0 4.5 5480 1264 ? S Feb07 0:00 mysqld
mysql 165 0.0 4.5 5480 1264 ? S Feb07 0:00 mysqld
Is that means MYSQL is using only 1264 Kb of real memory? If that is the case, I am really happy about my tweaking skills. After doing a query through PHP, the output becomes:
root 139 0.0 0.0 2436 4 ? S Feb07 mysqld_safe
mysql 163 0.0 4.5 5510 1278 ? S Feb07 0:02 mysqld
mysql 164 0.0 4.5 5510 1278 ? S Feb07 0:00 mysqld
mysql 165 0.0 4.5 5510 1278 ? S Feb07 0:00 mysqld
Thats just very nominal resource usage. I am assuming that what PS is showing are just duplicate entries for a single MYSQLD process and 1278 Kb can be safely taken as its RAM usage. I hope it is not (1278 X No. of mysqld threads).
I had a 280 MB MySQL db on a 384 MB Linux Dual Xeon 3.2 GHz VPS (no CP, no additional software) and it was no where near enough. Even if I upgraded the VPS to say 1 GB of Memory, it would take no time at all to over load it at this rate. There must be something wrong with the setup, I can't see MySQL being so resource heavy... or is it?
View 7 Replies View RelatedI have a VPS.
I have installed "Lighttpd, php5cgi, mysql-server, mysql-client,
libmysqlclient15-dev"
I have optimized the MySQL Server (/etc/mysql/my.cnf).
All these together just take 30 mb Memory.
Lighttpd use just 12mb memory And everything is very good.
But,
When I install php5 mod MySQL:
apt-get install php5-mysql
Then the Lighttpd memory increases to 90mb!
I am using updated Debian Lenny, MySQL5, php5.
I'm checking my CPU/Memory/MySQL Usage and I'm seeing that something called Munin is running at 54%. That is apparently the average for today. Can anyone give me any insight as to what this is?
Wikipedia classifies Munin as a network monitoring application. I don't think it should be using this much processing.
It appears that I may have enabled this plugin when I rebuilt my apache using EasyApache. Are there any big benefits to this? Looking at the graphics at first glance it doesn't look like there is. but then again, I'm not that knowledgable about this stuff.
I have migrate any sites to new server, where there is mysql 5
Centos 5
WHM/Cpanel
When I try to open phpmyadmin I see this:/
query SQL:
SHOW CHARACTER SET;
Messaggio di MySQL:
#5 - Out of memory (Needed 1677360 bytes)
--
What is the average memory/cput usage for httpd connections.?One of the site is using 2.8% memory. Is it acceptable for 1 GB RAM servers?
View 6 Replies View RelatedNot displaying CPU/Memory/MySQL Usage stats.Can u tell me how can i do it.
View 2 Replies View RelatedI have a VPS with 256MB ram. i want to limit mysql memory access. suppose i want that mysql should not use more than 128MB ram.
is this possible? if yes how?
is this possible for all other services too?
I'm trying to do a FULLTEXT search (1 field) on a ~3 gig table with ~650,000 rows. A lot of queries work fine and give results in seconds, but for queries on words that (I believe) occur very commonly in the database (e.g., this is a Italian database, the word 'italia' probably occurs a lot) take a while and then give the following errror:
#2008 - MySQL client ran out of memory
But the server has 8 gigs of RAM (and plenty of free hard disk space). Server is Linux with MySQL 4.0.27.
Here's my /etc/my.cnf file:
[mysqld]
set-variable = max_connections=1000
safe-show-database
log_slow_queries
long_query_time=5
max_allowed_packet=16M
ft_min_word_len=3
what I can do to make this work?
cpu speed/type single or dual cpus): Intel Xeon 2x3.6
how much memory installed: 2048MB
hard drive type/configuration: 2x160GB SATA
linux distributor or windows version: CentOS 4.5 x86_64
apache/IIS version: apache 1.3.37
PHP version: php 4.4.7
MySQL version: 4.1.22-standard
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
19017 teknoloj 16 0 0 0 0 Z 27 0.0 0:00.93 php <defunct>
17751 mysql 15 0 241m 55m 3148 S 25 2.8 0:53.73 mysqld
19025 root 18 0 16204 6104 1392 D 6 0.3 0:00.17 cpcpan_check_in
18968 sohbetgo 16 0 44596 7540 3556 S 5 0.4 0:00.44 php
18552 nobody 15 0 32636 4208 1204 S 2 0.2 0:00.28 httpd
18808 resimsit 17 0 46944 9960 3616 R 1 0.5 0:00.23 php
18896 resimsit 16 0 46944 9984 3616 D 1 0.5 0:00.08 php
18921 resimsit 17 0 46404 9444 3572 R 1 0.5 0:00.09 php
18819 nobody 17 0 32644 4176 1192 S 1 0.2 0:00.06 httpd
18868 haylazt 16 0 0 0 0 Z 1 0.0 0:00.48 php <defunct>
18871 nobody 15 0 32504 4056 1148 S 1 0.2 0:00.06 httpd
18892 root 16 0 6416 1180 756 R 1 0.1 0:00.24 top
18978 nobody 16 0 32504 4028 1132 S 1 0.2 0:00.02 httpd
11 root 5 -10 0 0 0 S 0 0.0 0:24.56 events/1
2638 root 0 -20 0 0 0 S 0 0.0 0:16.96 loop0
2981 named 18 0 88016 2328 1152 S 0 0.1 8:44.12 named
3592 mailman 16 0 50316 2320 1828 S 0 0.1 0:00.78 python2.4
my.cnf
[mysqld]
safe-show-database
skip-innodb
max_connections = 500
key_buffer = 80M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 25
connect_timeout = 10
tmp_table_size = 128M
max_heap_table_size = 128M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 4M
query_cache_size = 96M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 32768
ft_min_word_len=3
ft_max_word_len=25
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
ft_min_word_len=3
ft_max_word_len=25
[mysqlhotcopy]
interactive-timeout
MySQL 4.1.22-standard uptime 0 0:39:9 Sat Jun 30 21:33:29 2007
__ Key __________________________________________________ _______________
Buffer used 19.34M of 80.00M %Used: 24.17
Current 33.70M %Usage: 42.12
Write hit 32.57%
Read hit 98.45%
__ Questions __________________________________________________ _________
Total 63.26k 26.9/s
Slow 2 0.0/s %Total: 0.00 %DMS: 0.01
DMS 32.14k 13.7/s 50.80
__ Table Locks __________________________________________________ _______
Waited 40 0.0/s %Total: 0.08
Immediate 50.58k 21.5/s
__ Tables __________________________________________________ ____________
Open 486 of 1800 %Cache: 27.00
Opened 702 0.3/s
__ Connections __________________________________________________ _______
Max used 12 of 500 %Max: 2.40
Total 4.33k 1.8/s
__ Created Temp __________________________________________________ ______
Disk table 26 0.0/s
Table 2.23k 1.0/s
File 428 0.2/s
6-7 vbulletin sites-vbseo and other scripts online avarage;
120 registered user ve 500+ unregistered user
cookie timeout : 7200
unique hit : 15000-20000
KeepAlive ON
MaxKeepAliveRequests 100
KeepAliveTimeout 2
MinSpareServers 10
MaxSpareServers 15
StartServers 10
MaxClients 180
Maxrequestsperchild value 1000
[root@server ~]# uname -a
Linux server.xxxxx 2.6.9-55.ELsmp #1 SMP Wed May 2 14:04:42 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux
[root@server ~]# ulimit -aH
core file size (blocks, -c) 1000000
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 4096
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) 14335
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
[root@server ~]# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.60GHz
stepping : 10
cpu MHz : 3600.322
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7207.08
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.60GHz
stepping : 10
cpu MHz : 3600.322
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 3
cpu cores : 1
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7199.29
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.60GHz
stepping : 10
cpu MHz : 3600.322
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7509.03
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.60GHz
stepping : 10
cpu MHz : 3600.322
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 3
cpu cores : 1
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7199.26
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
I am running a dedicated server.
My apache crashes daily and I am investigating the cause of it.
I have found this strange message in my apache error_log....
I have remote uptime tracking on my server, and I am regularly getting text messages and emails regarding my server going down. This in itself isn't odd, however the fact is, everytime the problem is cPanel.
I log into my PC and find an email from my server and it contains the following;
Quote:
cpsrvd failed @ Thu Aug 7 19:11:17 2008. A restart was attempted automagically.
Failure Reason: Unable to connect to port 2086
what's causing this? It's on a VPS and the main server hasn't been down once, but this VPS constantly goes offline, at least once a day...
I have a server ($200)
I got tired from these frequent crashes.
I do not know how companies promising 99% uptime while customers do not get 80% uptime.
Just see this snapshot
Every week my server is down at least twice.
I have 7000-8000 daily uniques.
I really got tired.
Got tired from life also.
I have a VPS and almost once per day PIM has to restart the DNS service. I think it is because of the high volume of sites on it.
Could someone point me to which log files I could have a look at and maybe get a clue why it crashes?
I have seen this on a few different cpanel servers. Mainly seems an issue with some kernels but I have a server at softlayer and it seems it does it after a server has been up a few days.
At first I thought this was just an issue with grsecurity kernels but seems its an issue with any kernel on it after it been up a few days. On other servers though I have been able to change kernel versions and fix it. I suppose this may be related to disk space used as well.
Problem with my softlayer server is that teh tech didnt follow my partitong directions and installed everything in one slab / so I guess when you edit or add quota it has to scan the entire disk.
I had recently rebooted that server into a 2.6.29-grsecurity kernel and it fixed the issue but tonight I was messing around and it started all over. Not as bad as before but still around 305 minutes of totally lagging the server.
My mount options are
LABEL=/ / ext3 defaults,noatime,usrquota 1 1
Seems to do the same with or without noatime.
Has anyone ran into this issue or know any solution?
os is centos5 64 bit
I tried to upgrade from apache 2.0.51 to 2.0.63 but it crashes as soon as new version is started and httpd is reloaded.
here is a part of the log
[Fri Apr 25 10:57:46 2008] [notice] Apache/2.0.63 (Unix) configured -- resuming normal operations
Segmentation Fault in 3642, waiting for debugger
Segmentation Fault in 3697, waiting for debugger
Segmentation Fault in 3696, waiting for debugger
[Fri Apr 25 10:58:11 2008] [notice] caught SIGTERM, shutting down
[Fri Apr 25 10:58:22 2008] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Fri Apr 25 10:58:22 2008] [notice] mod_security/1.9.4 configured
[Fri Apr 25 10:58:22 2008] [notice] Digest: generating secret for digest authentication ...
[Fri Apr 25 10:58:22 2008] [notice] Digest: done
[Fri Apr 25 10:58:22 2008] [notice] LDAP: Built with OpenLDAP LDAP SDK
[Fri Apr 25 10:58:22 2008] [notice] LDAP: SSL support unavailable
[Fri Apr 25 10:58:23 2008] [notice] Apache/2.0.63 (Unix) configured -- resuming normal operations
Segmentation Fault in 5422, waiting for debugger
Segmentation Fault in 5421, waiting for debugger
Segmentation Fault in 5452, waiting for debugger
Segmentation Fault in 5461, waiting for debugger
Segmentation Fault in 5451, waiting for debugger
Segmentation Fault in 5466, waiting for debugger
Segmentation Fault in 5465, waiting for debugger
Segmentation Fault in 7363, waiting for debugger
Segmentation Fault in 5435, waiting for debugger
Segmentation Fault in 5906, waiting for debugger
Segmentation Fault in 7251, waiting for debugger
Segmentation Fault in 6041, waiting for debugger
Segmentation Fault in 7723, waiting for debugger
Segmentation Fault in 7986, waiting for debugger
Segmentation Fault in 9659, waiting for debugger
Segmentation Fault in 9643, waiting for debugger
Segmentation Fault in 9361, waiting for debugger
Segmentation Fault in 9744, waiting for debugger
Segmentation Fault in 9543, waiting for debugger
Segmentation Fault in 9879, waiting for debugger
Segmentation Fault in 9794, waiting for debugger
Segmentation Fault in 9758, waiting for debugger
[Fri Apr 25 11:01:10 2008] [notice] caught SIGTERM, shutting down
[Fri Apr 25 11:01:12 2008] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Fri Apr 25 11:01:12 2008] [notice] mod_security/1.9.4 configured
[Fri Apr 25 11:01:12 2008] [notice] Digest: generating secret for digest authentication ...
[Fri Apr 25 11:01:12 2008] [notice] Digest: done
[Fri Apr 25 11:01:12 2008] [notice] LDAP: Built with OpenLDAP LDAP SDK
[Fri Apr 25 11:01:12 2008] [notice] LDAP: SSL support unavailable
[Fri Apr 25 11:01:13 2008] [notice] Apache/2.0.63 (Unix) configured -- resuming normal operations
Segmentation Fault in 11634, waiting for debugger
Segmentation Fault in 11635, waiting for debugger
Segmentation Fault in 11661, waiting for debugger
Segmentation Fault in 11695, waiting for debugger
Segmentation Fault in 11760, waiting for debugger
Segmentation Fault in 11723, waiting for debugger
Segmentation Fault in 11694, waiting for debugger
Segmentation Fault in 11837, waiting for debugger
Segmentation Fault in 11812, waiting for debugger
Segmentation Fault in 12022, waiting for debugger
Segmentation Fault in 11848, waiting for debugger
Segmentation Fault in 11879, waiting for debugger
Segmentation Fault in 13342, waiting for debugger
Segmentation Fault in 12062, waiting for debugger
Segmentation Fault in 13428, waiting for debugger
Segmentation Fault in 13569, waiting for debugger
Segmentation Fault in 11849, waiting for debugger
Segmentation Fault in 13881, waiting for debugger
Segmentation Fault in 13380, waiting for debugger
[Fri Apr 25 11:02:27 2008] [notice] caught SIGTERM, shutting down
[Fri Apr 25 11:02:29 2008] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Fri Apr 25 11:02:29 2008] [notice] mod_security/1.9.4 configured
[Fri Apr 25 11:02:29 2008] [notice] Digest: generating secret for digest authentication ...
[Fri Apr 25 11:02:29 2008] [notice] Digest: done
[Fri Apr 25 11:02:29 2008] [notice] LDAP: Built with OpenLDAP LDAP SDK
[Fri Apr 25 11:02:29 2008] [notice] LDAP: SSL support unavailable
[Fri Apr 25 11:02:30 2008] [notice] Apache/2.0.63 (Unix) configured -- resuming normal operations
Segmentation Fault in 14123, waiting for debugger
Segmentation Fault in 14154, waiting for debugger
Segmentation Fault in 14156, waiting for debugger
Segmentation Fault in 14273, waiting for debugger
Segmentation Fault in 14114, waiting for debugger
Segmentation Fault in 14308, waiting for debugger
Segmentation Fault in 14316, waiting for debugger
Segmentation Fault in 14274, waiting for debugger
Segmentation Fault in 14315, waiting for debugger
Segmentation Fault in 15562, waiting for debugger
Segmentation Fault in 14113, waiting for debugger
Segmentation Fault in 15583, waiting for debugger
Segmentation Fault in 15615, waiting for debugger
Segmentation Fault in 15616, waiting for debugger
Segmentation Fault in 15584, waiting for debugger
Segmentation Fault in 15637, waiting for debugger
Segmentation Fault in 15631, waiting for debugger
Segmentation Fault in 15614, waiting for debugger
Segmentation Fault in 16332, waiting for debugger
Segmentation Fault in 14262, waiting for debugger
Segmentation Fault in 17504, waiting for debugger
Segmentation Fault in 15638, waiting for debugger
Segmentation Fault in 17515, waiting for debugger
Segmentation Fault in 18105, waiting for debugger
Segmentation Fault in 17516, waiting for debugger
Segmentation Fault in 18163, waiting for debugger
Segmentation Fault in 18175, waiting for debugger
Segmentation Fault in 18177, waiting for debugger
Segmentation Fault in 18178, waiting for debugger
Segmentation Fault in 18149, waiting for debugger
Segmentation Fault in 19931, waiting for debugger
Segmentation Fault in 20098, waiting for debugger
Segmentation Fault in 18176, waiting for debugger
I am on VPS and myself am quite a noob in this. Upgrade is performed by the support people.
If you guys can help please explain in lame terms
Let me know if you need some specific info about the system.
I was suggested that some modules might not be upgraded yet and they cause the crash, so to fix I should remove modules one by one from httpd config until get to the problematic one.
I am running CPanel and WHM, and every morning, I need to restart apache manually in order to work. Then it works for the whole day. It crashes I guess, but I don't know why. What logs do I need to check?
View 9 Replies View RelatedToday, I put a new server on our racks.
Problem: the machine crashes exactly every 10 minutes. The crash occurs with no entry on the logs and with 0.00 load. It is as if someone take out the current every 10 minutes.
Here are the specs:
- 2 CPU Intel Xeon 2.0
- 8 Gb RAM ECC
- 2 x 250 Gb HDs
This machine needs plenty of current. I wonder if I am not going over the rack power quota. May be there is a system to allow overages for then 10 minutes, then it cut back the current to the rack quota.
I have to reboot this server each day. It seems to crash (or freeze if you call it) around 11:55 pm server time (central US). How do I trace the cause of this? I installed CSF / LFD in replacement of APF/BFD.
This is a centos 3.9 / cpanel 11 box.
crontab -e shows nothing out of the default ordinary
/var/log/messages shows this
Nov 23 19:14:00 server sshd(pam_unix)[29523]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=a2.f5.5646.static.theplanet.com
Nov 23 19:14:02 server sshd(pam_unix)[29533]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=a2.f5.5646.static.theplanet.com user=gopher
Nov 23 19:14:02 server sshd(pam_unix)[29541]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=a2.f5.5646.static.theplanet.com user=gopher
Nov 23 19:14:02 server sshd(pam_unix)[29553]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=a2.f5.5646.static.theplanet.com user=gopher
Nov 23 19:14:02 server sshd(pam_unix)[29570]: check pass; user unknown
Nov 23 19:14:02 server sshd(pam_unix)[29570]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=a2.f5.5646.static.theplanet.com
Nov 23 19:14:05 server sshd(pam_unix)[29580]: check pass; user unknown
Nov 23 19:14:05 server sshd(pam_unix)[29580]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=a2.f5.5646.static.theplanet.com
Nov 23 19:14:08 server sshd(pam_unix)[29584]: check pass; user unknown
Nov 23 19:14:08 server sshd(pam_unix)[29584]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=a2.f5.5646.static.theplanet.com
Nov 23 19:14:11 server sshd(pam_unix)[29588]: check pass; user unknown
Nov 23 19:14:11 server sshd(pam_unix)[29588]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=a2.f5.5646.static.theplanet.com
Nov 23 19:14:13 server sshd(pam_unix)[29592]: check pass; user unknown
Nov 23 19:14:13 server sshd(pam_unix)[29592]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=a2.f5.5646.static.theplanet.com
Nov 23 19:14:16 server sshd(pam_unix)[29596]: check pass; user unknown
Nov 23 19:14:16 server sshd(pam_unix)[29596]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=a2.f5.5646.static.theplanet.com
Nov 23 19:14:19 server sshd(pam_unix)[29600]: check pass; user unknown
Nov 23 19:14:19 server sshd(pam_unix)[29600]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=a2.f5.5646.static.theplanet.com
Nov 23 19:14:22 server sshd(pam_unix)[29605]: check pass; user unknown
Nov 23 19:14:22 server sshd(pam_unix)[29605]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=a2.f5.5646.static.theplanet.com
Nov 23 19:14:25 server sshd(pam_unix)[29614]: check pass; user unknown
Nov 23 19:14:25 server sshd(pam_unix)[29614]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=a2.f5.5646.static.theplanet.com
Nov 23 19:14:27 server sshd(pam_unix)[29618]: check pass; user unknown
Nov 23 19:14:27 server sshd(pam_unix)[29618]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=a2.f5.5646.static.theplanet.com
Nov 23 19:14:30 server sshd(pam_unix)[29622]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=a2.f5.5646.static.theplanet.com user=mailnull
Nov 23 19:14:33 server sshd(pam_unix)[29631]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=a2.f5.5646.static.theplanet.com user=nfsnobody
Nov 23 19:14:36 server sshd(pam_unix)[29635]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=a2.f5.5646.static.theplanet.com user=rpcuser
Nov 23 19:14:38 server sshd(pam_unix)[29639]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=a2.f5.5646.static.theplanet.com user=rpc
Nov 23 19:14:41 server sshd(pam_unix)[29643]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=a2.f5.5646.static.theplanet.com user=gopher