Connection Persist

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Suggested Hosts
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
Z3u5
Registered User
Posts: 57
Joined: Sun Feb 12, 2006 4:52 pm
Contact:

Connection Persist

Post by Z3u5 »

The phpBB3 has created many connections persists with mysql server, and not closed these connections.
Did disable em DBAL this option, and disable in server, but still many connections stay opened for hours.

Some suggestion?
Brazilian Support - Suporte phpBB
User avatar
david63
Registered User
Posts: 20646
Joined: Thu Dec 19, 2002 8:08 am

Re: Connection Persist

Post by david63 »

If you believe that you have found a bug then post it in the bug tracker.
David
Remember: You only know what you know and - you don't know what you don't know!

I now no longer support any of my extensions but they will start to become available here
Z3u5
Registered User
Posts: 57
Joined: Sun Feb 12, 2006 4:52 pm
Contact:

Re: Connection Persist

Post by Z3u5 »

david63 wrote:If you believe that you have found a bug then post it in the bug tracker.
I posted in bug tracker, but did assigned to "Support request".
Brazilian Support - Suporte phpBB
Z3u5
Registered User
Posts: 57
Joined: Sun Feb 12, 2006 4:52 pm
Contact:

Re: Connection Persist

Post by Z3u5 »

Changing to mysqli, no problems, but more users reported in suportephpbb.org community same problem. Only changing to mysqli to fix this problem??
Brazilian Support - Suporte phpBB
User avatar
HLT
Registered User
Posts: 296
Joined: Wed May 15, 2002 7:05 pm
Contact:

Re: Connection Persist

Post by HLT »

Z3u5 wrote:
david63 wrote:If you believe that you have found a bug then post it in the bug tracker.
I posted in bug tracker, but did assigned to "Support request".
Well gee there's a surprise. A bug being reported and again getting mindlessly kicked out and pushed back to the support forum. That's happened to me now twice.

Exactly what do you all suggest we do when the bug fixers dont want to be bothered with bugs?

I also was told by Rackspace that my connection limit was reached yesterday.

If the bug guys wont look at this, what are other forum members going to do?

Help.
User avatar
david63
Registered User
Posts: 20646
Joined: Thu Dec 19, 2002 8:08 am

Re: Connection Persist

Post by david63 »

HLT wrote:I also was told by Rackspace that my connection limit was reached yesterday.
Your connection limit is nothing to do with phpbb3
David
Remember: You only know what you know and - you don't know what you don't know!

I now no longer support any of my extensions but they will start to become available here
User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34459
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run
Contact:

Re: Connection Persist

Post by A_Jelly_Doughnut »

phpBB does properly clean up its database connections.

It calls mysql_close() at the end of every page.

phpBB does not use persistent links (by default).

In fact, we can find the cause of this issue at PHP Bug 30525. It is a "bug"/feature in PHP where the language sometimes ignores a call to mysql_close(). I would assume they've reconsidered this for mysqli, and there fore that change fixes your issue.
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish
User avatar
HLT
Registered User
Posts: 296
Joined: Wed May 15, 2002 7:05 pm
Contact:

Re: Connection Persist

Post by HLT »

Love and peace.
Last edited by HLT on Thu Jul 05, 2007 4:54 am, edited 1 time in total.
User avatar
iyeru42
Registered User
Posts: 1120
Joined: Wed Feb 01, 2006 7:22 pm
Location: Madison, WI
Contact:

Re: Connection Persist

Post by iyeru42 »

If invisionthings.com wasn't retired, I could show you what the person wants. However, since it is, you'll just have to bear with me.

Connection Persistence means that the connection is always established, no matter if someone is viewing the script or not.
My Website | My MOD Requests | Foreign Key Docs (some topics are not requests)
"It's easy to rebel, but it's hard to be recognized."
Locked

Return to “[3.0.x] Support Forum”