database error many messages,needed help. (realy need help)
 

hello,

i get many error from my database :
its the sample :

The error means that the MySQL daemon was down while a connection was trying to be established.

thats because my host or my vbulletin?

Your server.

i get this error message again :

Database error in vBulletin 3.7.0:

Invalid SQL:

UPDATE session
SET lastactivity = 1213782551, location = '/forum/forumdisplay.php?f=120', inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '67396536c9a4cb42a379df8ac799ec7b';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, June 18th 2008 @ 05:49:11 AM
Error Date : Wednesday, June 18th 2008 @ 05:49:14 AM
Script : http://www.anakayam.us/forum/forumdisplay.php?f=120
Referrer : http://www.anakayam.us/forum/forumdisplay.php?f=2
IP Address : 125.163.91.150
Username : asbun
Classname : vB_Database
MySQL Version :
==========
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/zhazha/public_html/forum/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Wednesday, June 18th 2008 @ 05:49:17 AM
Error Date : Wednesday, June 18th 2008 @ 05:49:17 AM
Script : http://anakayam.us/forum/archive/index.php/f-91.html
Referrer : http://www.foolfind.com/search/cerit...esama-pria-gay
IP Address : 125.163.7.202
Username :
Classname : vB_Database
MySQL Version :
=============
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/zhazha/public_html/forum/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Wednesday, June 18th 2008 @ 05:49:18 AM
Error Date : Wednesday, June 18th 2008 @ 05:49:18 AM
Script : http://www.anakayam.us/forum/register.php?do=register
Referrer : http://www.anakayam.us/forum/register.php?do=checkdate
IP Address : 125.164.205.207
Username :
Classname : vB_Database
MySQL Version :
==========
Database error in vBulletin 3.7.0:

Invalid SQL:
SELECT COUNT(*) AS total FROM post_thanks WHERE userid = 21753 AND date > 1213696153;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, June 18th 2008 @ 05:49:13 AM
Error Date : Wednesday, June 18th 2008 @ 05:49:14 AM
Script : http://www.anakayam.us/forum/showthread.php?t=5350
Referrer : http://www.anakayam.us/forum/forumdi...=desc&page=125
IP Address : 125.162.57.251
Username : randang_darek
Classname : vB_Database
MySQL Version :
=========
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/zhazha/public_html/forum/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Wednesday, June 18th 2008 @ 05:49:16 AM
Error Date : Wednesday, June 18th 2008 @ 05:49:16 AM
Script : http://anakayam.us/forum/showthread.php?t=1686&page=2
Referrer : http://anakayam.us/forum/showthread.php?t=1686
IP Address : 210.245.52.35
Username :
Classname : vB_Database
MySQL Version :
=========

and my host support say : its because my vbulletin script.not my host.
what should i do to fixed this?

--------------- Added [DATE]1213783750[/DATE] at [TIME]1213783750[/TIME] ---------------

my support say like this :

but problem never solved.

It means your server cannot handle the load you are putting on it.

When this happens, check the uptime of the mysql server.

im realy tired about this for 3months.my issue never fixed :(
my host support say :

i take dedicated server for this.
so until now my issue never fixed.what should i do for this friend?
i really need ur help for this.
well thank you very much,i hope my problem solved in here.

vBulletin can handle many, many users at once. It is most likely that your server is being hammered with requests. Run the command top in SSH and see which process is the first.

until now i get database error in my site :

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)
/home/zhazha/public_html/forum/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Friday, June 20th 2008 @ 04:22:52 AM
Error Date : Friday, June 20th 2008 @ 04:23:01 AM
Script : http://www.anakayam.us/forum/showthread.php?t=3504
Referrer : http://www.anakayam.us/forum/forumdisplay.php?f=19
IP Address : 125.162.244.38
Username :
Classname : vB_Database
MySQL Version :

i dont know about my hosting never solved my issue.

Please stop posting the same error over and over again - WE GET THE POINT. Furthermore, please read replies posted.

im very sorry bout this sir,but i dont know what should i do to make my forum normal again.
until now my host support never solved my problem.im stressfull about this.

It sounds like your host is offering a lot of help, but the problem appears to be in your software. Maybe a corrupt modification.

You can try disabling all your mods and adding them back one by one.

But, like Dismounted just said, there's no point in asking for help here if you're going to ignore the replies. You've been given three suggestions now and you need to try all of them and report back.

If you're not familiar with vbulletin I believe paid help is available somewhere around here.

okay no problem,i can pay for this but it must make my vbulletin normal again and not have an issue like this.
but my support host say i must upgrade the RAM.
before this my ram is 2GB.i take dedicated server.

--------------- Added [DATE]1214028670[/DATE] at [TIME]1214028670[/TIME] ---------------

in my plugin/product i just install simple mod :
Cyb - Advanced Forum Statistics
Cyb - Login To User Account
elmati - ADS inside postbit
Enhanced Image Captcha
Force Users to Read a Thread : Disable
Full Quick Reply
Invitation System
Members Who Registered Today
nCode Image Resizer
Personal Notepad
Post Thank You Hack
Quick Register
Tag Cloud - Forum Home
Usergroup Legend - J2Gaming.com
vB Ad Management
vB Ad Management English language
vB.Sponsors
vbBux / vbPlaza : Disable
vBCode table
Watermark Attachments
Welcome Headers

Again, please read replies and run the top command.

okay,my support say :

Please post my.cnf from /etc.

Okay this is my.cnf :

[mysqld]
max_connections = 650
safe-show-database
skip-locking
key_buffer = 128M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 64M
thread_concurrency = 8
wait_timeout = 30

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

log-slow-queries = /var/log/mysql-slow.log
long_query_time = 3

Try increasing max_connections.

how i can set for max_connection?
do u have suggestion sir?

--------------- Added [DATE]1214151094[/DATE] at [TIME]1214151094[/TIME] ---------------

btw my support say :

now im using dedicated server for 2GB ram.
but my host told me to upgrade my ram in to 4GB ram.
but the problem is that my members was online each day it is just for 5k uniq visitors.
is 2gb is not enough?

Again - run the top command and post the result.

okay here the result :

--------------- Added [DATE]1214307185[/DATE] at [TIME]1214307185[/TIME] ---------------

my host support say :


Here is the my current plan :
DEDICATED SERVER.
Item: Webmaster Plan1
Processor: Pentium 4 3GHZ Hyperthreaded
Memory: 1GB DDR SDRAM
Hd1: 120GB 7200RPM SATA / 8MB Cache
Hd2: 120GB 7200RPM SATA / 8MB Cache
RemoteBackup: No Remote Backup Needed
OS: Linux - CentOS 4
ControlPanel: CPanel / Web Host Manager
(+ServerSecure)
(+Fantastico/XController)


You currently have a single duo core processor with 2 Gigs of ram.


but its not enough?
my uniq visitors / day just only 4k.
so i must upgrade my server or what sir?
thanks

To answer your host's comments:

1) vBulletin is NOT a resource hog. It only opens as many connections to the server as people visiting.
2) You still have ~500MB of free memory....
3-4) Your load average is high, very high in fact. So your processor would be dragging you down as well.

but now im already upgrade in to 4GB ram. :)

turn persistant connectons off in the config.php file if its on.

may i know about persistant connections its for what? thx

--------------- Added [DATE]1214413338[/DATE] at [TIME]1214413338[/TIME] ---------------

btw im already upgrade in to 4GB ram.but my issue never solved.
my host just say :
i think the problem its because vbulletin.not my host.because im already upgrade in to 4GB ram.
and my issue always getting from vbulletin.

I was suggesting to copy the vBulletin database to a fresh install just to be sure there is no vbulletin issue. The server hardware seems ok to me, since the site is pretty fast under normal conditions. Now with 4 GB it is slightly better.

If a fresh copy fails, I suggest to move hosting and run a dedicated server under own regime. Of course, excellent computer knowledge is required ;)

Apache should be compiled with PHP, and PHP should not run as CGI. Thats why it eats so much resources.

As i can see, PHP runs as separate module here. I remember once my hoster did this to my server due to some obscure bug , and server was rendered unusable in just few visits.

Again, vBulletin is NOT a resource hog. It only opens as many connections to the server as people visiting.

Look at the output of top, you have too many PHP forks running - this is killing the server, not the amount of RAM, but the CPU power required.

friend u mean i must backup the database forum and then create a new installation forum,
then upload my database in to a new forum. right?

and how about the plugin menu? thx

--------------- Added [DATE]1214486448[/DATE] at [TIME]1214486448[/TIME] ---------------

now my forum using vb.3.7.1 PL2.
its impossible if i create a new installation vb.3.7.2 and restore the database from vb.3.7.1 PL2 ?

Reinstalling vBulletin is not going to do anything. Just look at the output of the top command.

I think you're really trying to help, so I'll post this and hope you don't take it the wrong way.

Your responses are assuming way too much knowledge. "you have too many PHP forks running" describes the result of a problem, but doesn't tell the poor guy what to do about it.

He's at the point now where he'll do anything you say, but now you've got to give him some sort of action to take. What should he do next to try to solve the problem?

No, I mean to make a fresh installation and use IMPEX to transport the forum data on a new board, in order to get rid of all plugins, style changes and eventual errors.

Just backing up and restoring would not help. It would just reproduce the same problems on the new installation ;)

--------------- Added [DATE]1214496396[/DATE] at [TIME]1214496396[/TIME] ---------------

It seems his host is not very cooperative and just tries to guess where the problem lays.

I try to fix the problem without touching the hardware and server settings, since this would require to change host.

There are some errors on style basis which cause the pages not to load correctly and may have side effects on certain scripts. These errors are present with and without plugins. It may also be, some of the plugins are outdated, but I doubt the problem is there.

After he upgraded to 4 GB RAM the problem continued. With permanent connections, the problem was less frequent, which points my finger to the MySQL settings.

I'm not sure if PHP run as CGI makes the big difference, since it should just run shortly an instance of PHP for each client. Of course it would show a long list of instances, if the operating system doesn't unload them quickly. At most there could be a short delay between connections. MySQL errors could occur, if the PHP instances don't unload quick enough while other client connections are incoming. I've no idea how Linux handles CGI, and how applications are scheduled.

PHP run as CGI is the usual way to keep processes apart and avoid to crash or block the whole server if one client instance crashes or blocks. However it is useful only in shared virtual servers.

until now for 2days.im not getting the many error message in my mail.
just error database in attachment.its because im using watermark attachment for vb.3.6.8 version..im running vbulletin vb.3.7.1 version. i need watermark attachment for my image.because this the watermark attachment not uninstall in my plugin.i really need it.

i hope it will be okay for the next time.
because im really tired about this issue.

Can you provide me the link to the watermark plugin please?

Host support :
u must login with Paid member :
userid : testing
pass : 123456

that's example link for attachment.

today i get 3message database error :
just 3message not more.
before im upgrade in to 4GB. everyday i get more than 100 error database message in my inbox.

thanks

--------------- Added [DATE]1214554100[/DATE] at [TIME]1214554100[/TIME] ---------------

yesterday my support host ask i must upgrade the ram for fixed my issue.
and now they need me to an upgrade my Host in to proffessional dedicated server. *Sigh

In order to fix the attachmentviews problem, you can try to add the following line to your config.php and see if this makes any difference:

i put the code in bottom of config.php
but thats not work.
im always get database error :

Well I don't know. My smallest server gets ten's of thousands hits per hour and still doesn't give up. The MySQL gone away error is usually a record size problem, and the server should time out at most = no reply = white or error page. For me it's a server setting issue. But of course, if you are on a shared environment - as it seems -changing the settings may be done only within certain limits.

I don't know if you solve the problems you have now switching to a "professional" solution of the same host. If I was you I'd look to get the best for my money, which isn't necessarily the cheapest. I would buy a good computer, giving the most attention to the hard disk quality, add some RAM, install an operating system, the latest Apache, MySQL and PHP and would go housing after a home test session. This way, you know what you have and if something doesn't work, you know how to fix it. It has a relatively high cost because of the computer, the OS and preliminary work, but pays off after a year, because the expense of housing is very small.

That server should be more then fine for your traffic depending on your site and what add ons you have. If this is just for one vbulletin forum then your server or software configuration is way off.