vb_post broken? dead?

[solarboy]

Hello forum

I am getting database errors very often and everyday.
I have dealt with db errors before, nothing that a visit to server cpanel - not admincp- and phmyadmin sometimes would not fix.

This time though, when I try to repair my forum-s db, I get this:


ALLTHE NORMAL PRECEDING TABLES....
novena_novena.vbpaymentinfo OK
novena_novena.vbpaymenttransaction OK
novena_novena.vbphrase OK
novena_novena.vbphrasetype OK
novena_novena.vbpicture OK
novena_novena.vbpicturecomment OK
novena_novena.vbpicturecomment_hash OK
novena_novena.vbplugin OK
novena_novena.vbpm OK
novena_


This is when it gets interesting. The repair never gets trough vbpost!

After several minutes frozen like that, cpanel says that the repair is completed.

Something similar happens when I try to repair that table via phpmyadmin or even the admincp. It gets stuck forever.

After several minutes with db error, my forums comes back to life and everything works seemingly fine for 5 minutes, and then db error all over again.


What do you think it can be?
Thank so much in advance.

[HMBeaty]

Really hard to say without knowing what the database error is.

See my article here: https://vborg.vbsupport.ru/showthread.php?t=272014

[solarboy]

Thanks for replying.



This is the error I get wth db error screen:

Database error in vBulletin :

mysqli_real_connect() [<a href='function.mysqli-real-connect'>function.mysqli-real-connect</a>]: (42000/1203): User novena_novena already has more than 'max_user_connections' active connections
/home/novena/public_html/includes/class_core.php on line 1139


MySQL Error :
Error Number :
Request Date : Tuesday, January 10th 2012 @ 11:33:27 PM
Error Date : Tuesday, January 10th 2012 @ 11:33:27 PM
Script : http://xxx.com/index.php
Referrer : http://xxxx.com/admincp/index.php?do=head
IP Address : xxx.xxx.xxx.xxx.
Username :
Classname : vB_Database_MySQLi
MySQL Version :
-->


The empty spaces are originally empty.
:confused:

[HMBeaty]

The important part is this:

User novena_novena already has more than 'max_user_connections' active connections

See this: https://www.vbulletin.com/forum/showthread.php/202554-simultaneous-connections?p=1221165#post1221165

[solarboy]

I see!

I was looking at the wrong lines , at $config['SlaveServer']['usepconnect'] = 0;

I hope this fixes it. :D