vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   database error many messages,needed help. (realy need help) (https://vborg.vbsupport.ru/showthread.php?t=182628)

Dismounted 06-26-2008 12:37 PM

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

Videx 06-26-2008 01:49 PM

Quote:

Originally Posted by Dismounted (Post 1559523)
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?

y2ksw 06-26-2008 02:44 PM

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] ---------------

Quote:

Originally Posted by Videx (Post 1559573)
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?

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.

geevest.com 06-26-2008 03:28 PM

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.

y2ksw 06-26-2008 09:29 PM

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

geevest.com 06-27-2008 02:46 AM

Host support :
Quote:

Hello,

Again, you need something more powerful. You are receiving 1000's of hits per
hour, and the server is unable to process it. Our support department has
worked with you extensively on optimizing and keeping your site up.
u must login with Paid member :
userid : testing
pass : 123456

Code:

Invalid SQL:
INSERT INTO attachmentviews (attachmentid)
                      VALUES (1162);

MySQL Error  : MySQL server has gone away
Error Number  : 2006
Request Date  : Thursday, June 26th 2008 @ 11:36:30 PM
Error Date    : Thursday, June 26th 2008 @ 11:37:20 PM
Script        : http://www.anakayam.us/forum/attachment.php?attachmentid=1162&d=1213042014
Referrer      : http://www.anakayam.us/forum/showthread.php?t=12398&page=2
IP Address    : xxxxx
Username      : ankurdiok
Classname    : vB_Database
MySQL Version :

Quote:

Database error in vBulletin 3.7.1:

Invalid SQL:
INSERT INTO attachmentviews (attachmentid)
VALUES (1393);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, June 26th 2008 @ 11:17:41 PM
Error Date : Thursday, June 26th 2008 @ 11:18:12 PM
Script : http://www.anakayam.us/forum/attachm...3&d=1213286649
Referrer : http://www.anakayam.us/forum/showthread.php?t=12827
IP Address : xxxxxxx
Username : ankurdiok
Classname : vB_Database
MySQL Version :
Quote:

Database error in vBulletin 3.7.1:

Invalid SQL:
INSERT INTO attachmentviews (attachmentid)
VALUES (1756);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, June 26th 2008 @ 10:41:35 PM
Error Date : Thursday, June 26th 2008 @ 10:42:06 PM
Script : http://www.anakayam.us/forum/attachm...6&d=1214455833
Referrer : http://www.anakayam.us/forum/showthread.php?t=14405
IP Address : xxxxx
Username : ankurdiok
Classname : vB_Database
MySQL Version :
Quote:

Invalid SQL:
INSERT INTO attachmentviews (attachmentid)
VALUES (783);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, June 26th 2008 @ 07:35:39 AM
Error Date : Thursday, June 26th 2008 @ 07:37:12 AM
Script : http://anakayam.us/forum/attachment....3&d=1209057072
Referrer : http://www.anakayam.us/forum/showthr...?t=7763&page=2
IP Address : xxxx
Username : pandamesum
Classname : vB_Database
MySQL Version :
that's example link for attachment.

today i get 3message database error :
Quote:

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 : Tuesday, June 24th 2008 @ 03:36:41 PM
Error Date : Tuesday, June 24th 2008 @ 03:36:42 PM
Script : http://www.anakayam.us/forum/image.p...ine=1213793980
Referrer : http://www.anakayam.us/forum/showthread.php?t=13153
IP Address : xxxx
Username :
Classname : vB_Database
MySQL Version :
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

Quote:

Without knowing how much traffic and server spec other people have, I can't
comment on why it doesn't happen to them.

If you can't get vbulletin to optimize the forum, I'm afraid you will need to
upgrade to more powerful server, not just upgrade the ram. Giving your past
ticket issues, I don't think I can do anything else to help the situation.


Marco van Herwaarden 06-27-2008 08:48 AM

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:
PHP Code:

define('NOSHUTDOWNFUNC'true); 


geevest.com 06-27-2008 05:33 PM

Quote:

Originally Posted by Marco van Herwaarden (Post 1560233)
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:
PHP Code:

define('NOSHUTDOWNFUNC'true); 


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

Database error in vBulletin 3.7.1:

Invalid SQL:
INSERT INTO attachmentviews (attachmentid)
VALUES (1422);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, June 27th 2008 @ 02:22:43 PM
Error Date : Friday, June 27th 2008 @ 02:23:32 PM
Script : http://www.anakayam.us/forum/attachm...2&d=1213289277
Referrer : http://www.anakayam.us/forum/showthread.php?t=12827
IP Address : xxxx
Username : wela
Classname : vB_Database
MySQL Version :

y2ksw 06-28-2008 07:40 AM

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.

R1lover 08-03-2008 03:45 AM

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.


All times are GMT. The time now is 05:57 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01237 seconds
  • Memory Usage 1,788KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (2)bbcode_php_printable
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete