11
hervet
Re: What is there in line 34 of databasefactory.php ?
  • 2004/11/30 17:20

  • hervet

  • Friend of XOOPS

  • Posts: 2267

  • Since: 2003/11/4


Did it changed something ?

12
ackbarr
Re: What is there in line 34 of databasefactory.php ?

sounds like MySQL is hitting its max_connections limit, which defaults to 100. You could try increasing this limit to a larger number, but make sure it is more then the apache connection limit. It might also help to lower the apache KeepAliveTimeout setting to about 5 to force connections to terminate quicker

* Edit - MySQL connections should be set higher than apache, not lower as I originally typed.

13
hervet
Re: What is there in line 34 of databasefactory.php ?
  • 2004/11/30 17:35

  • hervet

  • Friend of XOOPS

  • Posts: 2267

  • Since: 2003/11/4


more cache will be a good solution too

14
shivaji
Re: What is there in line 34 of databasefactory.php ?
  • 2004/12/15 8:26

  • shivaji

  • Friend of XOOPS

  • Posts: 179

  • Since: 2003/9/18


Quote:
hervet wrote: IPB must use too much queries


Our new IPB 2.03 -XOOPS plugin does not change anythings of XOOPS cores and installed on separate /Forum folder, so this is not a problem of IPB code.

15
shivaji
Re: What is there in line 34 of databasefactory.php ?
  • 2004/12/17 14:33

  • shivaji

  • Friend of XOOPS

  • Posts: 179

  • Since: 2003/9/18


> You could try increasing this limit to a larger number, but make sure it is more or set to higher then the apache connection limit.

I have had max_connections=500 set ever since the very first evidence of problems with MySql on this server; it has not addressed the issue. From eve

> It might also help to lower the apache KeepAliveTimeout setting to about 5 to force connections to terminate quicker.

I doubt that changing anything in Apache would help an issue with MySql. Keepalive is turned off in Apache anyway.

> Is TurkMCache is installed in this server ?

No.

> It appears that some hosting service providers are imposing their own "unadvertised" restrictions on SQL queries. (hijacked from other thread)

This is a dedicated server running "stock" Red Hat MySql code; no restrictions are placed on any of MySql parameters.

16
shivaji
Re: What is there in line 34 of databasefactory.php ?
  • 2004/12/17 17:34

  • shivaji

  • Friend of XOOPS

  • Posts: 179

  • Since: 2003/9/18


Quote:
hervet wrote: Did it changed something ?


hervet, I will get back after doing some more research. During peak time still line 34 databasefactory.php.

17
patchwork
Re: What is there in line 34 of databasefactory.php ?
  • 2005/5/3 13:19

  • patchwork

  • Just popping in

  • Posts: 11

  • Since: 2005/4/29


I managed to resolve this error in my site by changing the password used to access MySql and reflecting this change in the mainfile.php.

All previous attempts of rewrite the password failed. You really HAVE to change the password.

Hope it helps!

18
hervet
Re: What is there in line 34 of databasefactory.php ?
  • 2005/5/3 18:07

  • hervet

  • Friend of XOOPS

  • Posts: 2267

  • Since: 2003/11/4


patchwork,

I would like to congratulate you for what you have done.
You have searched (and find) a post relative to your problem without creating a new one !
It's so unusual...

Bye,
Hervé

19
cmacone
Re: It Helped! What is there in line 34 of databasefactory.php ?
  • 2005/5/28 21:28

  • cmacone

  • Just popping in

  • Posts: 47

  • Since: 2004/8/25


Thanks... I experienced that problem, and as I am the administrator of my own dedicated server, I went in and put up both the max amount of users and the bandwith, and it fixed the problem.

20
landry
Re: What is there in line 34 of databasefactory.php ?
  • 2008/6/18 1:44

  • landry

  • Just popping in

  • Posts: 22

  • Since: 2005/6/7 2


I am having the same issue on a site that receives very little traffic. It was suggested elsewhere that the database password should be changed, but I"m unable to do that at this time. Is there another solution?


Suggestion to change pwd:
https://xoops.org/modules/smartfaq/faq.php?faqid=279&com_id=41137&com_rootid=41137&com_mode=flat&com_order=0#comment41137

Login

Who's Online

199 user(s) are online (122 user(s) are browsing Support Forums)


Members: 0


Guests: 199


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits