Kbase P97598: Batch job run from cron never logs out of database preventing other users from accessing database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/14/2004 |
|
Status: Unverified
FACT(s) (Environment):
UNIX
SYMPTOM(s):
Batch job running from cron
Batch program into database, runs commands and exits
Batch job logs into database but does exit
Batch job preventing users from accessing database
The server or the system has no more resources. Try a larger -n. (748)
You have attempted to connect to a database with too many users connected to it. Retry the connection later, or increase -n on the server. (5291)
CAUSE:
A new batch job program was launched every minute by cron. The newly launched program started running before the previous batch job completed.
FIX:
Increase the time between the running of the batch jobs from 1 minute to 15 minutes in cron.