
Morning...

	the following is starting to get on my nerves :(  The table I'm
trying to update is ~22k records, and I can't seem to get through it...

	So, my first question is *what* does this message mean?  The
backend gives an error about too many open files, but there are less then
20 process running on this machine...

zeus:/usr/local/acctng/bin> ./close.pl isdn-1.trends.ca
processing 1405 records ... Found 1405 open records...
NOTICE:  AbortTransaction and not in in-progress state

	I suspect that this is still a 6.3.1 server, and we're planning on
moving this to another machine that has 6.3.2 installed, but I figured I'd
ask regardless...

Marc G. Fournier                                
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 


Mon, 1 Jun 1998 22:26:49 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
AbortTransaction and not in in-progress state
> 
> Morning...
> 
> 	the following is starting to get on my nerves :(  The table I'm
> trying to update is ~22k records, and I can't seem to get through it...
> 
> 	So, my first question is *what* does this message mean?  The
> backend gives an error about too many open files, but there are less then
> 20 process running on this machine...

There are two limits on the number of open files in UNIX systems (ok, three, if your C library imposes it's own limit on the number of FILE *), the system wide limit and the per process limit.  The per process limit is usually much smaller than the system wide limit (i.e 60 vs. 400).  It is therefor possible that the backend process is running out of file handles, even though there are plenty of file handles available on a system wide bases.

I hope this helps.

Billy G. Allie.



Tue, 02 Jun 1998 01:00:57 -0400
"Billy G. Allie" <Bill.Allie@mug.org>
Re: [HACKERS] AbortTransaction and not in in-progress state 