vb.org Archive - database error many messages,needed help. (realy need help)

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)

Again - run the top command and post the result.

okay here the result :

Code:

top - 12:48:37 up 3 days, 24 min, 2 users, load average: 20.79, 22.28, 20.00

Tasks: 357 total, 8 running, 336 sleeping, 0 stopped, 13 zombie Cpu(s): 78.1%

us, 14.7% sy, 0.0% ni, 7.1% id, 0.0% wa, 0.2% hi, 0.0% si Mem: 2073872k total,

1492364k used, 581508k free, 55936k buffers Swap: 2040244k total, 208k used,

2040036k free, 893324k cached



 PID USER      PR  NI %CPU    TIME+  %MEM  VIRT  RES  SHR S COMMAND

25011 zhazha    17   0   14   0:00.44  0.0     0    0    0 Z php <defunct>

25010 zhazha    20   0   14   0:00.43  0.0     0    0    0 Z php <defunct>

25016 zhazha    20   0   13   0:00.39  0.0     0    0    0 Z php <defunct>

25012 zhazha    21   0   12   0:00.38  0.0     0    0    0 Z php <defunct>

25017 zhazha    19   0   12   0:00.38  0.0     0    0    0 Z php <defunct>

25020 zhazha    21   0   12   0:00.38  0.0     0    0    0 Z php <defunct>

25024 zhazha    21   0   11   0:00.34  0.7 25536  13m 5244 R php

25018 zhazha    18   0   10   0:00.32  0.0     0    0    0 Z php <defunct>

10100 mysql     15   0    8 150:26.57  6.1  329m 124m 4288 S mysqld

25025 zhazha    20   0    8   0:00.25  0.6 26156  13m 5120 R php

25027 zhazha    19   0    7   0:00.22  0.6 25892  12m 5160 R php

25028 zhazha    19   0    7   0:00.21  0.6 25784  12m 5108 R php

25030 zhazha    18   0    3   0:00.09  0.4 21780 9036 4652 R php

25029 zhazha    18   0    1   0:00.04  0.2 19888 4840 2896 R php

24903 root      16   0    1   0:00.28  0.1  3388 1216  780 R top

10658 root      17   0    1   5:36.59  0.1  3764 1284  780 S top

16150 nobody    15   0    1   0:00.37  0.2 11316 3936 1460 S httpd

11916 nobody    15   0    0   0:00.50  0.2 11328 3952 1452 S httpd

14076 nobody    16   0    0   0:00.52  0.2 11348 3980 1468 S httpd

17868 nobody    15   0    0   0:00.37  0.2 11348 3980 1464 S httpd

18104 nobody    15   0    0   0:00.34  0.2 11332 3972 1464 S httpd

18739 nobody    16   0    0   0:00.27  0.2 11332 3972 1460 S httpd

18853 nobody    15   0    0   0:00.30  0.2 11324 3976 1484 S httpd

19589 nobody    16   0    0   0:00.23  0.2 11348 3996 1464 S httpd

20153 nobody    15   0    0   0:00.19  0.2 11196 3884 1456 S httpd

20156 nobody    16   0    0   0:00.27  0.2 11188 3884 1460 S httpd

20461 nobody    16   0    0   0:00.18  0.2 11212 3952 1488 S httpd

22137 nobody    16   0    0   0:00.07  0.2 11188 3860 1444 S httpd

22987 nobody    16   0    0   0:00.12  0.2 11188 3892 1460 S httpd

23536 nobody    16   0    0   0:00.02  0.2 11188 3844 1436 S httpd

23595 nobody    16   0    0   0:00.06  0.2 11188 3868 1448 S httpd

23760 nobody    16   0    0   0:00.09  0.2 11176 3844 1440 S httpd

23852 nobody    15   0    0   0:00.05  0.2 11176 3856 1444 S httpd





as you can see this is an issue with the user (indeed your only user and

account it appears) zhazha, to much PHP use, before it was this AND too much

Mysql use, if you can have the makers of your forum software trouble shoot

that would be great, can you please let me know what they say?

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

my host support say :

Quote:

Hi,

After reading through several tickets and other admin notes, the problems can
be summarized thusly:

1) The vbulletin software is a resource hog. The number of connections that it
is trying to handle and pass to the server is extremely large.

2) The memory usage required by php on the site is also using an overabundance
of memory.

3) we have tried to optimize the existing software configuration to the nth
degree all without success.

4) The hardware configuration of the server itself is inadequate for your
current needs.

To solve these problems I would recommend the following:

A: Upgrade the server to at least a 4 core processor or better yet, 8 cores
would be optimal. You currently have a single duo core processor.

B: Upgrade the ram to at least 4 Gigs, 8 Gigs would be better. You currently
have 2 Gigs.

C: Consider optimizing the php software you are using for the site itself. The
number of concurrent connections are causing 'out of memory' errors which
causes the failed or dropped mysql connections causing downtime for the site.

D: Consider changing the software you are using for the bulletin board. The
current problem is that the board is spawning over 1100
/usr/bin/php/home/zhazha/public_html/forum/showthread.php processes.

To put it simply, you are trying to toast 100 slices of bread on a 4 slice
toaster. The answer to this issue is you need a bigger toaster. This may be
oversimplifying the issue but it is accurate. This is my opinion, but the
final decision is yours to make. We can improve via upgrade or continue to see
the same issues reappear again and again. Please let me know how you would
like to proceed.

Let me also take this time to say thank you for your time and patience while
we try and resolve this issue. I know the frustration level is high, but there
is a solution to this if we continue to work together to find it.

Regards,
David Singer

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.

Quote:

Originally Posted by FRDS (Post 1558696)

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 :

Quote:

Hello again,

There's nothing further we can do for you, regarding your vbulletin issues. As
Ian and myself have stated before, we've optimized your server's services and
have reviewed it's overall setup several times. We've gone above and beyond
our realm of support trying to keep your server stable, but your server is
flooded by connections and the demands from VB bring it offline.

I apologize for the inconvenience this has caused you, but everything we
provide support for is working as expected. If the VB support staff isn't able
to provide an additional step for you, I'd recommend trying either new forum
software or reinstalling VB. I'm not trying to push you away from that
software, but our Support staff isn't trained on the ins and outs of VB, only
identifying what's causing an issue and how best to resolve it. We don't
provide support for 3rd party applications (i.e. anything outside of cPanel,
not directly related to the Operating System).

Please let me know if there's anything else I can help you with. Though we
can't resolve the VB problems, I can assure you that we're always here for
questions or problems with anything pertaining to cPanel.

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.

Quote:

Originally Posted by y2ksw (Post 1558816)

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 ?

X vBulletin 3.8.12 by vBS Debug 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 (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01099 seconds Memory Usage 1,780KB 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 (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)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
Messages: