You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 198 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - SQL connection not being closed [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
dotcomUNDERGROUND
Lieutenant
Lieutenant


Joined: Jul 18, 2003
Posts: 180


PostPosted: Fri Aug 06, 2004 4:02 pm Reply with quoteBack to top

two of my nuke sites (one running 7.2 (NC bunble) and the other updated to 7.4 (patched version from NSN) are not closing their open threads properly.

its resulting the sites going down (cannot connect database) till mostly a server reboot.

How can i solve it?

I am losing my hardly earned visitors and google ranking for this.
Sad

_________________
[ Bangla Music | Web Hosting Bangladesh | Domain Registration Bangladesh ]
Find all posts by dotcomUNDERGROUNDView user's profileSend private messageVisit poster's website
dotcomUNDERGROUND
Lieutenant
Lieutenant


Joined: Jul 18, 2003
Posts: 180


PostPosted: Sat Aug 07, 2004 6:04 am Reply with quoteBack to top

help pls

_________________
[ Bangla Music | Web Hosting Bangladesh | Domain Registration Bangladesh ]
Find all posts by dotcomUNDERGROUNDView user's profileSend private messageVisit poster's website
madman
Support Mod
Support Mod


Joined: Feb 15, 2004
Posts: 806


PostPosted: Sat Aug 07, 2004 3:38 pm Reply with quoteBack to top

This is what I've got from a line at includes/db.php file:

Code:
$db = new sql_db($dbhost, $dbuname, $dbpass, $dbname, false);


The last parameter "false" indicating the db will be connected as non-persistent connection. If you having problem with that, you can set it as "true" to connect db using persistent connection (db won't closed even if the http requests terminated), and vice versa.

_________________
I'm Image
Find all posts by madmanView user's profileSend private messageVisit poster's websiteYahoo MessengerMSN Messenger
dotcomUNDERGROUND
Lieutenant
Lieutenant


Joined: Jul 18, 2003
Posts: 180


PostPosted: Sun Aug 08, 2004 12:33 pm Reply with quoteBack to top

thanks a lot

ill give a try.

Quote:

There are a couple of additional caveats to keep in mind when using persistent connections. One is that when using table locking on a persistent connection, if the script for whatever reason cannot release the lock, then subsequent scripts using the same connection will block indefinitely and may require that you either restart the httpd server or the database server.


is there any issue relaited to this locking i need to worry about?

thanks once again for your help

_________________
[ Bangla Music | Web Hosting Bangladesh | Domain Registration Bangladesh ]
Find all posts by dotcomUNDERGROUNDView user's profileSend private messageVisit poster's website
dotcomUNDERGROUND
Lieutenant
Lieutenant


Joined: Jul 18, 2003
Posts: 180


PostPosted: Wed Aug 11, 2004 1:08 pm Reply with quoteBack to top

didnt help Sad

_________________
[ Bangla Music | Web Hosting Bangladesh | Domain Registration Bangladesh ]
Find all posts by dotcomUNDERGROUNDView user's profileSend private messageVisit poster's website
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.108 Seconds - 329 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::