LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 03-24-2009, 08:17 AM   #1
sai_sonika
LQ Newbie
 
Registered: Mar 2009
Posts: 1

Rep: Reputation: 0
Cannot create new link. Too many open links error


hello frds,

i received following error as
Cannot create new link. Too many open links
while creating connection between php 4 and postgresql version 7.

please reply with ur valuable comments.

thx
 
Old 03-24-2009, 11:37 AM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 18,316

Rep: Reputation: 3878Reputation: 3878Reputation: 3878Reputation: 3878Reputation: 3878Reputation: 3878Reputation: 3878Reputation: 3878Reputation: 3878Reputation: 3878Reputation: 3878
Quote:
Originally Posted by sai_sonika View Post
hello frds,

i received following error as
Cannot create new link. Too many open links
while creating connection between php 4 and postgresql version 7.

please reply with ur valuable comments.

thx
There are known issues with both PHP4 and Postgres 7.x, posted on both the PHP and Postgres forums. Upgrade to the latest versions, and the problems are resolved.

Also, please provide complete information, such as what version/distro of Linux you're running, and what you're doing to get the error(s). And spell out your words.
 
Old 03-24-2009, 05:34 PM   #3
JaksoDebr
Member
 
Registered: Mar 2009
Distribution: Fedora, Slackware
Posts: 104

Rep: Reputation: 21
Your script are probably accessing the database by opening a connection each time (maybe even in a loop), without closing already opened connections. You should adjust the scripts to reuse an existing connection throughout the scripts by passing the connection value along as a function parameter. Proper programming always helps. Upgrading the involved software will also cure the situation, though the script would be still pieces of bad programming.

Linux Archive

Last edited by JaksoDebr; 04-02-2009 at 05:56 AM.
 
Old 03-24-2009, 06:28 PM   #4
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 18,316

Rep: Reputation: 3878Reputation: 3878Reputation: 3878Reputation: 3878Reputation: 3878Reputation: 3878Reputation: 3878Reputation: 3878Reputation: 3878Reputation: 3878Reputation: 3878
Quote:
Originally Posted by JaksoDebr View Post
Your script are probably accessing the database by opening a connection each time (maybe even in a loop), without closing already opened connections. You should adjust the scripts to reuse an existing connection throughout the scripts by passing the connection value along as a function parameter. Proper programming always helps. Upgrading the involved software will also cure the situation, though the script would be still pieces of bad programming.
Good point, JaksoDebr. The update will put a band-aid on the issue, but bad programming should ALWAYS be fixed.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
BackupPC Error: Unable to open/create XferLOG rkulp Linux - Server 1 05-12-2008 11:07 PM
How to create symbolic link to html file and avoid page link problem? haxpor Linux - General 2 01-29-2008 08:40 AM
In Qmail server socket create error instead of too many open files. linuxxx123 Linux - Server 0 12-10-2007 03:48 PM
Create a link to open Konqueror with filter already on davidguygc Linux - Desktop 5 03-22-2007 01:38 PM
An error while trying to create a soft link g_trueblood Slackware 4 10-07-2005 01:17 PM


All times are GMT -5. The time now is 07:03 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration