Seeking guidance with server errors

[Saurabh Jain]

My members keep saying me on linkeidn - you have a server error on page.   Some times the  captcha table crashes, sometime downloads  -  IPS support teams says problem in server .  MY webhosts says - server is fine -  every script has some configuration for server 

the latest error says  

------------------------------------------
 Date: Wed, 18 Feb 2015 17:11:28 +0000
 Error: 2006 - MySQL server has gone away
 IP Address: 111.93.6.70 - /forum/files/download/329-refrigeration-and-heat-pump-systems/
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT COUNT(file_id) as files, SUM(file_downloads) as downloads, SUM(file_views) as views FROM ibf_downloads_files WHERE file_cat IN(30) AND file_open=1
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications_addon/ips/downloads/sources/classes/categories.php      | [class_categories]._rebuildCategoryFileinfo                                   | 536       

 

Another type of errors

Date: Tue, 17 Feb 2015 00:04:31 +0000 Error: 2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) IP Address: 66.249.65.172 - /forum/gallery/image/1080-isothermal-process/ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Tue, 17 Feb 2015 00:04:41 +0000 Error: 2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) IP Address: 66.249.65.164 - /forum/gallery/image/482-tce-mech-2000-batch/

-----------------

Seeking help how to diagnose the problem  

Thanks and Regards

Saurabh

Additional comments from my webhost - I am on vps server

Please communicate with your development team regarding this issue. MySQL could be crashing from excessive database usage, causing the service to be stopped and restarted by cPanel and any open database tables at that time to become crashed.
If there are any specific MySQL settings or variables they recommend being updated, we can assist you with getting these changed.
 

[Saurabh Jain]

Another reply from my webshost

What kind of 3rd party plugins are you running? Those are almost always the issue with IPB installs and MySQL.

We can upgrade you to MySQL 5.6, it may be more stable and will offer increased performance. 

I've been monitoring the server and I have adjusted various MySQL configuration options/adjusting the caching for improved performance. Are you able to upgrade IPB? The version you're running appears to be quite old.

Your Apache process is very stable and resource usage is good:
root@vps [/home]# hostname; uptime; free -m
vps.mechanical-engineering.in
10:33:59 up 23 days, 21:03, 0 users, load average: 0.28, 0.57, 0.51

total used free shared buffers cached
Mem: 3072 2399 672 0 0 1784
-/+ buffers/cache: 614 2457
Swap: 1024 45 978


Current Time: Thursday, 19-Feb-2015 10:28:56 IST
Restart Time: Monday, 26-Jan-2015 13:36:36 IST
Parent Server Config. Generation: 178
Parent Server MPM Generation: 177
Server uptime: 23 days 20 hours 52 minutes 20 seconds
Server load: 1.01 0.87 0.55

It's most likely a plugin generating bad MySQL queries that is causing MySQL to crash.

Let me know if I should proceed with the MySQL upgrade, we will perform an Apache upgrade at the same time as you're a few minor revisions behind.

[Makoto]

A web application should never be able to cause the database server to crash. If your database server is crashing, there is a server issue, the software is virtually never to blame for this. Even in the case of very poor queries being executed, the server may choke and refuse connections, but never should a properly configured server crash.

Can you please check (and post) the most recent lines in your MySQL error log? (Generally /var/log/mysqld.log)

[Saurabh Jain]

There is no var folder in my cpanel  

can you please elaborate a little more 

 

 

[IveLeft...]

Are you on shared hosting or a VPS/Dedicated ?

var/log/ is at root level