Re: What does this tell me?

> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000E4
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000E5
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000E6
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000E7
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000E8
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000E9
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000EA
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000EB
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000EC
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000ED
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000EE
> 2002-10-08 20:37:13 DEBUG: recycled transaction log file
> 0000000A000000EF
> 2002-10-08 20:37:13 DEBUG: reaping dead processes
> 2002-10-08 20:37:13 DEBUG: child process (pid 15270) exited with exit
> code 0
>
> ... repeat ad nauseum. The problem is, each "recycle transaction
> log ... reaping dead child process" cycle takes about 4-7 minutes
> ... meaning that the procedure can take up to 1/2 hour to finish,
> and sometimes not finish at all.
>
> Obviously, the system is telling me that it is running out of
> resources somehow. But I'm at my wit's end to figure out what
> resources, exactly. Suggestions?

You're running out of WAL log space, iirc. Increase the number of WAL
logs available and you should be okay. If you're experiencing this
halfway through, I'd increase the size by 50%, say maybe 60-70% for
good measure. -sc

--
Sean Chittenden