Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By trueMarketing on
NEED:
Immediate Help Needed (as in today!)
PAY:
Based on experience, but I'll pay generously for someone who can do the job quickly and right the first time. Immediate payment through Paypal and a $100 bonus for getting this solved today!
DESCRIPTION
I'm looking for someone who can immediately troubleshoot and repair several issues with a Drigg-powered news website. I'm only looking for someone who's extremely knowledgeable of MySQL and Drupal DB issues. I will provide more information upon receiving your information, skillset, and previous projects that relate to MySQL/DB tweaking, fixes, and so on.
To give a quick overview of the issues though we are running a Drigg-powered Drupal news site. The DB is tweaking out and our VPS company keeps sending emails saying the following:
..."your account has been suspended for 15 minutes in our node powerhouse.gteinterlink.com due your account is responsible for overloading the server, which is impacting overall performance in the node. The cause for suspension its due to excessive I/O hard drive utilization, mostly by excessive writes, which slows down the overall performance of the VPS box."
Several of the errors I'm seeing when the site is responsive are:
PHP WATCHDOG TYPE ERRORS
Message Got error 28 from storage engine query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 81259 ORDER BY v.weight, t.weight, t.name in /home/dbname/public_html/includes/database.mysql.inc on line 172.
and many watchdog / page generated errors, such as:
Warning: Table './dbname_fn2/sessions' is marked as crashed and should be repaired query: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = '696747b6aab3067192b8962a8adc221c' in /home/dbname/public_html/includes/database.mysql.inc on line 172
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/dbname/public_html/includes/database.mysql.inc:172) in /home/dbname/public_html/includes/bootstrap.inc on line 899
Warning: Cannot modify header information - headers already sent by (output started at /home/dbname/public_html/includes/database.mysql.inc:172) in /home/dbname/public_html/includes/bootstrap.inc on line 531
Warning: Cannot modify header information - headers already sent by (output started at /home/dbname/public_html/includes/database.mysql.inc:172) in /home/dbname/public_html/includes/bootstrap.inc on line 532
Warning: Cannot modify header information - headers already sent by (output started at /home/dbname/public_html/includes/database.mysql.inc:172) in /home/dbname/public_html/includes/bootstrap.inc on line 533
Warning: Cannot modify header information - headers already sent by (output started at /home/dbname/public_html/includes/database.mysql.inc:172) in /home/dbname/public_html/includes/bootstrap.inc on line 534
etc. and so on...
The hosting company, after rebooting, sent this email of running processes before rebooting the VPS:
"If you do see in the last column all Zero's [0] , your VPS is under its allocated resources, and was rebooted due to one of more services has been detected offline."
/proc/user_beancounters :
uid resource held maxheld barrier limit failcnt
4681: kmemsize 2117 56435634 107374182 107374182 0
lockedpages 0 0 1174 1174 0
privvmpages 0 789827 786432 9223372036854775807 1256
shmpages 0 20628 262144 262144 0
dummy 0 0 0 0 0
numproc 0 494 586 586 0
physpages 0 596490 0 2147483647 0
vmguarpages 0 0 262144 9223372036854775807 0
oomguarpages 0 596490 262144 9223372036854775807 0
numtcpsock 0 251 586 586 0
numflock 0 150 937 1030 0
numpty 0 1 58 58 0
numsiginfo 0 148 1024 1024 0
tcpsndbuf 55824 5392400 15728640 15728640 0
tcprcvbuf 0 2175904 15728640 15728640 0
othersockbuf 0 2830848 2809719 5209975 22587
dgramrcvbuf 0 90720 2809719 2809719 0
numothersock 0 453 586 586 0
dcachesize 0 1442304 5242880 5400576 0
numfile 0 6972 9376 9376 0
dummy 0 0 0 0 0
dummy 0 0 0 0 0
dummy 0 0 0 0 0
numiptent 0 77 500 500 0
-------------------------------------------------------
I'll be glad to give more information, VPS access, and other access to troubleshoot once I can find someone who knows their stuff. PM me with your experience.
Comments
Do you have any more
Do you have any more information on your VPS plan? There's a chance that your host just has your server slice under tight restrictions. If this is the case, it may not be possible to fix without lifting those restrictions. Also, have you ever done any MySQL table maintenance?
http://www.trailheadinteractive.com
Well, start with the glaring
Well, start with the glaring problem: fix your sessions table. Clear it out ("DELETE FROM sessions") and run a repair if necessary ("REPAIR TABLE sessions"). You can run both from phpmyadmin if you have it available, or via the mysql command line. I'd try that as first order to fix up your session starting and bootstrapping errors which, at the very least, should give you a cleaner run of watchdog errors to track.
Also, error 28 is caused by
Also, error 28 is caused by insufficient disk space. You should bring this error to the attention of your hosting provider - since you are shared hosting, it may not be your fault at all. The /tmp directory may be at capacity. This may be related to the excessive I/O operations that your host is complaining about.