Page 1 of 1
forum overcrowded?
Posted: 31 Oct 2011 23:53
by rogerdpack
Hello.
I've gotten the following "500 message" recently, when posting message replies, or sometimes even just viewing the forum at all:
"too many connections to postgres database" connection rejected (or something along those lines).
(this prevents browsing the forum, or writing responses at times, might be worth remedying).
Thanks!
-roger-
Re: forum overcrowded?
Posted: 01 Nov 2011 01:57
by marlosb
Hi, I'm really sorry to bother but I just came in here and have been looking for the last 30 minutes on how to make a new thread... yes, pretty stupid but i can't figure it out. would you give me a hint? thanks in advance and sorry again for bothering...
Re: forum overcrowded?
Posted: 01 Nov 2011 08:57
by Jean-Baptiste Kempf
The machines seems to have some issue sometimes to handle all the load.
Re: forum overcrowded?
Posted: 01 Nov 2011 19:56
by rogerdpack
Hi, I'm really sorry to bother but I just came in here and have been looking for the last 30 minutes on how to make a new thread... yes, pretty stupid but i can't figure it out. would you give me a hint? thanks in advance and sorry again for bothering...
"New topic" button upper left, when looking at the index of messages.
Re: forum overcrowded?
Posted: 04 Nov 2011 19:40
by rogerdpack
Ironically, just got it when viewing this thread.
The tough thing is when you go to post a "response" message and it fails--you don't know if you should try to repost it or not, and it's a bit disconcerting.
Cheers!
-r
General Error
SQL ERROR [ postgres ]
Errno 2: pg_connect(): Unable to connect to PostgreSQL server: FATAL: connection limit exceeded for non-superusers at /var/www/forum.videolan.org/includes/db/postgres.php line 108 []
BACKTRACE
FILE: includes/db/postgres.php
LINE: 128
CALL: dbal->sql_error()
FILE: common.php
LINE: 108
CALL: dbal_postgres->sql_connect()
FILE: ucp.php
LINE: 17
CALL: require('common.php')
Re: forum overcrowded?
Posted: 06 Nov 2011 20:56
by Jean-Baptiste Kempf
Yes, the forum traffic is going up, and the machine has issues to follow, especially on the postgres connections.
Re: forum overcrowded?
Posted: 07 Nov 2011 13:11
by rogerdpack
Perhaps increasing the postgres connection limit?
-r
Re: forum overcrowded?
Posted: 07 Nov 2011 13:14
by Jean-Baptiste Kempf
Will kill the postgres server. We are working on a better solution.