Link-ID == false, connect failed mysql error number: 0

StewardManscat · November 17th, 2005, 06:00 PM

Can anyone share some possible causes of this error?

Thank you

rbl · November 22nd, 2005, 01:56 AM

I have experienced these errors on several occasions but never on vBG.
Are you sure they relate to vBG and not anything else?

Zachariah · November 22nd, 2005, 10:29 AM

Link-ID == false, connect failed mysql error number: 0

MySQL isn't accepting new connections. (The server could either be down or has reached it's maximum connections limit - either on the server level or user level.) If you are sure your config.php info is correct, then you will need to contact your host about this.

Mysql outages happen on "shared" host sometime also. If website A,B,C run on a server and "B" re-index. This could red line the and give timeouts / connect failed errors to the other sites hosted.

I have had to yell a lot (e-mail tag for a month) and have server changes to my account @ my host.

Chuck S · November 22nd, 2005, 11:12 AM

Powweb or Ipowerweb are famous for these types of errors in general they simply shut down the whole mysql server for a specified period of time after you reach x amount of mysql requests

Zachariah · November 22nd, 2005, 11:19 AM

Quote:

Originally Posted by Chuck S

Powweb or Ipowerweb are famous for these types of errors in general they simply shut down the whole mysql server for a specified period of time after you reach x amount of mysql requests

I had an idea of sequential mysql usernames on the same DB - in thought that each account would get 50,000 questions or what ever it is per day/hour. This might get past MAX questions errors many hosts love to give out.

Chuck S · November 22nd, 2005, 11:55 AM

Yes true but no programs currently use mysql username access arrays on a single database so the best thing with those hosts a user can do is set say vbulletin to one mysql name and the gallery to another

ConqSoft · November 22nd, 2005, 11:59 AM

But PhotoPost vBGallery is integrated with vBulletin, and uses all vBulletin connection info. No separate configuration.

Zachariah · November 22nd, 2005, 01:54 PM

Quote:

Originally Posted by ConqSoft

But PhotoPost vBGallery is integrated with vBulletin, and uses all vBulletin connection info. No separate configuration.

Here was some thoughts from: Freddie Bingham @ vb.com

Quote:

Originally Posted by Zachariah

This may be a vb.org hack, but I am sure others may have ran into this issue.

I have ran into webhosts that because of "hackers and server loads" have a cap on questions mySQL server can be given in a time frame. ( I do not know the time frame)

"Error: SQL server exceeded 50,000 max questions" --- All mySQL is stoped for like 5 min then all is ok. The server it self auto temp bans then mysql account.

I was thinking of a script / VB Scheduled Task that would do steps like "Rebuild Search Index" to do like 10,000 questions a day/hour/whatever or some set value untill done. Is there a way to start and index, "pause" and contenue later ? - There may be many other "index" type operations that need this "if it can be done"

Most if not all of the Maintenance => Update Counters tasks.

Quote:

Originally Posted by Freddie Bingham

One workaround is to create multiple mysql users in your hosting account. In config.php you randomly pick one of these users to connect to the database. This will spread the questions between users and since the limit is per user, you can usually overcome the problem.