Ack ...

The server is down again. Error messages seem to indicate that connection handles are not being released properly?

- Kris

"Brad Anderson" <brad@dsource.dot.org> wrote in message news:do0b6j$f42$1@digitaldaemon.com...
> I'm w/ Tom and JCC - Postgres rules, except for this case.  I had to restart it this AM, and this PM, so something is up.  Maybe the new version of Trac I put down?  Dunno, but it's disconcerting.
>
> All involved, send email to me at the following:
>
> brad@dsource.org
> brad@sankaty.com
> brad@mirus.com
>
> Those should reach me in case the server is absolutely hosed and postfix is down as well.  Hopefully someone in the Trac world solves the issue...
>
> BA
>
> P.S.  Tomorrow, if it goes down, I may not be able to help, as I'll be rooting the Tampa Bay Buccaneers to victory over the New England Patriots... those facists.
>
>
>
> J C Calvarese wrote:
>> In article <dnvv5g$2s1$1@digitaldaemon.com>, John Demme says...
>>> The MySQL server appears to be down... I'm pretty sure Brad uses the
>>> MySQL
>>> database for authentication, so when that goes down...
>>>
>>> ~John
>>
>> Dsource.org definitely used MySQL in the beginning, but I think Brad
>> switched
>> everything to Postgre a while back.
>>
>> jcc7

In article <do0b6j$f42$1@digitaldaemon.com>, Brad Anderson says...
>
>I'm w/ Tom and JCC - Postgres rules, except for this case.  I had to restart it this AM, and this PM, so something is up.  Maybe the new version of Trac I put down?  Dunno, but it's disconcerting.
>
>All involved, send email to me at the following:
>
>brad@dsource.org
>brad@sankaty.com
>brad@mirus.com
>
>Those should reach me in case the server is absolutely hosed and postfix is down as well.  Hopefully someone in the Trac world solves the issue...
>
>BA
>
>P.S.  Tomorrow, if it goes down, I may not be able to help, as I'll be rooting the Tampa Bay Buccaneers to victory over the New England Patriots... those facists.

The dsource.org database seems to be down again. I've sent e-mail to Brad, but he might be in the middle of his football game.

jcc7

Boiyoiyoiyoiyoing!

Back up again :-)


"J C Calvarese" <technocrat7@gmail.com> wrote in message news:do2d3l$2e7k$1@digitaldaemon.com...
> In article <do0b6j$f42$1@digitaldaemon.com>, Brad Anderson says...
>>
>>I'm w/ Tom and JCC - Postgres rules, except for this case.  I had to restart it this AM, and this PM, so something is up.  Maybe the new version of Trac I put down?  Dunno, but it's disconcerting.
>>
>>All involved, send email to me at the following:
>>
>>brad@dsource.org
>>brad@sankaty.com
>>brad@mirus.com
>>
>>Those should reach me in case the server is absolutely hosed and postfix is down as well.  Hopefully someone in the Trac world solves the issue...
>>
>>BA
>>
>>P.S.  Tomorrow, if it goes down, I may not be able to help, as I'll be rooting the Tampa Bay Buccaneers to victory over the New England Patriots... those facists.
>
> The dsource.org database seems to be down again. I've sent e-mail to Brad,
> but
> he might be in the middle of his football game.
>
> jcc7

Kris wrote:
> Boiyoiyoiyoiyoing!
> 
> Back up again :-)

Did it fix itself? Or did Brad work his magic on it.

> 
> 
> "J C Calvarese" <technocrat7@gmail.com> wrote in message news:do2d3l$2e7k$1@digitaldaemon.com...
> 
>>In article <do0b6j$f42$1@digitaldaemon.com>, Brad Anderson says...
>>
>>>I'm w/ Tom and JCC - Postgres rules, except for this case.  I had to
>>>restart it this AM, and this PM, so something is up.  Maybe the new
>>>version of Trac I put down?  Dunno, but it's disconcerting.
>>>
>>>All involved, send email to me at the following:
>>>
>>>brad@dsource.org
>>>brad@sankaty.com
>>>brad@mirus.com
>>>
>>>Those should reach me in case the server is absolutely hosed and postfix
>>>is down as well.  Hopefully someone in the Trac world solves the issue...
>>>
>>>BA
>>>
>>>P.S.  Tomorrow, if it goes down, I may not be able to help, as I'll be
>>>rooting the Tampa Bay Buccaneers to victory over the New England
>>>Patriots... those facists.
>>
>>The dsource.org database seems to be down again. I've sent e-mail to Brad, but
>>he might be in the middle of his football game.
>>
>>jcc7 
> 
> 
> 

I imagine he booted the server from the comfort of his sofa, whilst the Patriots were attempting to boot a football ...



"clayasaurus" <clayasaurus@gmail.com> wrote in message news:do2gde$2kq7$1@digitaldaemon.com...
> Kris wrote:
>> Boiyoiyoiyoiyoing!
>>
>> Back up again :-)
>
> Did it fix itself? Or did Brad work his magic on it.
>
>>
>>
>> "J C Calvarese" <technocrat7@gmail.com> wrote in message news:do2d3l$2e7k$1@digitaldaemon.com...
>>
>>>In article <do0b6j$f42$1@digitaldaemon.com>, Brad Anderson says...
>>>
>>>>I'm w/ Tom and JCC - Postgres rules, except for this case.  I had to restart it this AM, and this PM, so something is up.  Maybe the new version of Trac I put down?  Dunno, but it's disconcerting.
>>>>
>>>>All involved, send email to me at the following:
>>>>
>>>>brad@dsource.org
>>>>brad@sankaty.com
>>>>brad@mirus.com
>>>>
>>>>Those should reach me in case the server is absolutely hosed and postfix is down as well.  Hopefully someone in the Trac world solves the issue...
>>>>
>>>>BA
>>>>
>>>>P.S.  Tomorrow, if it goes down, I may not be able to help, as I'll be rooting the Tampa Bay Buccaneers to victory over the New England Patriots... those facists.
>>>
>>>The dsource.org database seems to be down again. I've sent e-mail to
>>>Brad, but
>>>he might be in the middle of his football game.
>>>
>>>jcc7
>>
>> 

In article <do2gde$2kq7$1@digitaldaemon.com>, clayasaurus says...
>
>Kris wrote:
>> Boiyoiyoiyoiyoing!
>> 
>> Back up again :-)
>
>Did it fix itself? Or did Brad work his magic on it.

I think Brad had to fix it. He's investigating the situation and has a theory of what's causing the problem.

jcc7

Kris wrote:
> I imagine he booted the server from the comfort of his sofa, whilst the Patriots were attempting to boot a football ...

Grrr.  Patriots demolished my Buccaneers.

As for dsource, the connections are purposefully not being released b/c of connection pooling.  I have to see if pooling is required for the volume each project will get.  i.e. the number of connections per, and then making sure that the max-connections setting for Postgres is set to handle it.

There may be a leak in the phpBB side, or the php side of dsource, but hopefully that goes away soon.

Thanks for your patience while I solve this.

BA

Brad Anderson wrote:
> Kris wrote:
>> I imagine he booted the server from the comfort of his sofa, whilst the Patriots were attempting to boot a football ...
> 
> Grrr.  Patriots demolished my Buccaneers.
> 
> As for dsource, the connections are purposefully not being released b/c of connection pooling.  I have to see if pooling is required for the volume each project will get.  i.e. the number of connections per, and then making sure that the max-connections setting for Postgres is set to handle it.
> 
> There may be a leak in the phpBB side, or the php side of dsource, but hopefully that goes away soon.
> 
> Thanks for your patience while I solve this.

It's not a solution, but what about a monitor process that restarts the DB or whatever when the website becomes unresponsive?


Sean